status 8 when extracting data

[Former Member]

Hello,

I’ve built a generic extractor for attributes and in RSA3 I can see that it works well. I assigned the attribute to an info object and extracted the data in the DEV and got the data. I transported everything to PROD (after it worked in the QA…) but in the PROD it doesn’t work!!! In R3 PROD RSA3 it works, I replicated the data, activated the transfer rule again and replicated the data source but getting status 8 when extracting.

What can it be?

David

[Former Member · Accepted solution]

Hi David,

Does system says anything else other than status 8 ?? some runtime dump (Tcode : ST22) , some error in the details screen ??

[Former Member · Accepted solution]

Hi MR Kapadia,

no dumps.

the system message:

-

---

No data available

Diagnosis

The data request was a full update.

In this case, the corresponding table in the source system does not

contain any data.

System response

Info IDoc received with status 8.

Procedure

Check the data basis in the source system.

-

---

but in the source system, in RSA3 there are no errors (in the log everything is green)

[Former Member · Accepted solution]

HI

If you are able to get some data in Rsa3 Of production then there is something wrong with the objects which you have transported.

Replicate the data source.

Activate the transfer rules.

Check if you are able to get the data in psa first.

Hope this helps

[Former Member]

I've built the datasource again and now it is working.Dont know why it didnt work before... Thank you all

David

[Former Member]

If your connection fine.

Try replicating the data source and activate the tr rules again.

And also check the transport request which you have done from QA to PRD.

There should be a connection problem or must be errors in the transport request.

Please check

[former_member186445]

it seems there is no data in the source system. did you check the selection criteria you put in you infopackage. try loading without any selections.

[Former Member]

Hi,

There is data in the source system. I can see it in RSA3. I also tried a new datapackage with no selection criteria, or loading it just to the PSA but nothing work......

David

[edwin_harpino]

hi David,

all other extractions work fine ? only this datasource ?

verify that connection between bw and r/3 is ok ?

sm59, rfc r/3, do test -> test authorization

right click r/3 source system and 'check' ?

hope this helps.

[Former Member]

Hi AHP,

The problem happends only with this data source.

The Connection with the R3 system is fine(we extracting data every day).

I replicated the trnsfer rule and checked the requests but nothing works....

David

Message was edited by:

David Cohn

[Former Member]

Hi David,

How is generic extractor built up ?? Extraction via function module or Tables ?? If its function module could you paste a code here for further inputs.

Regards

Mr Kapadia

[Former Member]

its the very simple generic extractor - extraction from DB table.

no code at all and it is working in RSA3.

[Former Member]

Hi David,

I am not too sure , but try changing something (may be text, some fields to be set hidden / unhidden ) in the datasource and replicate it in BW dev and transport it to production ,then after it should work .

Hope that helps.

Regards

Mr Kapadia