Data loading error

[Former Member]

Hi friends,

When i am loading the data from generic data source in to bw system through the infopackage i am getting the fallowing error

Error 7 when sending an IDoc

SQL error in the database when accessing a table.

Errors in source system

please tell me the what are the steps i have to take to load the data

Thanks and Regards

Pedamarla

[Former Member · Accepted solution]

Hi

(Error 7 when sending an IDoc)-Please check for any Idoc(BD87) with status 64 at Source system/ BI system, if so please process them manually

(SQL error in the database when accessing a table)- please check at SM12 for any dead locks by giving table name(which you are trying to access) at your source system, if you see any dead locks work with basis team to clear dead locks

hope this will resolve your issue

-DU

[Former Member]

Hi Click on monitor than try to find out the reason for failure by clicking on message.

Or else you go to se37 and try to find out the error.

Hope it helps,

Uday.

[former_member208595]

Hi,

Contact your Basis team for this.

[Former Member]

Can you please send the lontext of the error message.You can follow the the following step.

1.Check BD87 idoc prcoessing.If idoc status is 64 then execute the idoc manually.But inform your basis team regarding this.

else

2.logon to source system and go to SM37.Please check the status of the backgound job(put *requestname from BW system like *REQU_D5W1IG2CLEKDIDIZMF2HXKPVB).check the joblog and ST22 shotdump.If it is only due to standard system SQL error ,consult basis and on advise of them delete the red request from cube and set the technichal status to red) and restart the load again,If it is a delat then perfrom repeat delta.

Regards

Bibhu

[mansi_dandavate]

Are you able to extract data from the generic datasource in RSA3?