Error loading data from R/3 to ODS

[Former Member]

Hi All,

I am getting an error when trying to load data from R/3 DataSource  (0FI_AA_11) to the SAP defined ODS (0FIA_DS11). In the InfoPackage, i  tried with all options (only PSA, only Datatargets, PSA and data  targets). Also i tried Initialization and Full update. The data is not  loaded into PSA either. The error which i get is:

------------------------------------------------------------------
Error message from the source system

Diagnosis
An error occurred in the source system.

System response
Caller 09 contains an error message.

Further analysis:
The error occurred in Extractor .
Refer to the error message.

Procedure
How you remove the error depends on the error message.

Note
If the source system is a Client Workstation, then it is possible  that the file that you wanted to load was being edited at the time of  the data request. Make sure that the file is in the specified directory, that it is not being processed at the moment, and restart the request. 
------------------------------------------------------------------

Details: Red symbol appears only before this message.
------------------------------------------------------------------

Error occurred in the data selection

------------------------------------------------------------------

I checked st22. There were no short dumps.
I checked sm12. No locks.
I checked sm21. No problem even in there.
I checked sm37. Job says finished.
Also, i don't think there is problem with the connection, since i was able to extract data with other standar Datasources.

Could someone please help.

Regards,

Sudheer.

[former_member182470 · Accepted solution]

Have you checked the data in RSA3 before trying to load to PSA? Run in F mode.

After you make it ok in RSA3 oonly, you will be able to get it to BW side.

[Former Member · Accepted solution]

Hi Sudheer,

        Please check in RSA3  in R/3 side whether  data is there or not.       

most of the time we will  receiv a error like Caller 9 missing if there is no data file.

thanx,

ML

[Former Member · Accepted solution]

Hi Sudheer,

There may be transfer structure is not active , please check it .

The caller  09 message is error in source system , but there may be number reasons ,  in details tab , 

& find what is error message.

Regards,

Anand Mehrotra.

[Former Member]

Hi Sudeer,

Some times it causes due to DataSources in the source system were changed.To resolve this you need to replicate the DataSources for the source system that you're extracting out of.

http://scn.sap.com/thread/1418801

May be this thread help you.

Regards,

Bhaskar

[RamanKorrapati]

Hi Sr,

Please use small font while posting.

Which version of bw your using?

when you received a error like Caller 9 missing, then you will see the causes at SM37 ecc side not in bw side.

at BW side go to info package monitor screen, from header tab - copy request id

Go to ECC side, Tx - SM37, job name: BI<copied request id from bw>.

user id: *

Status: Active,finish and cancel.

date: yester day and today date.

enter it you will get respective job, select it and click on job log details on tool bar.

if you observe the log you will may find the cause or share here.

Thanks