Data is not to BW system

[Former Member]

Hi..

My question is "last 2 days data is not reflected in BW system(it is showing 0 from 0 records) but the data is available in R/3 system"..What is the observations and how to solve this problem

Regards

Satish

[Former Member]

The decription of your problem is too broad please try to be more specific as far as the extraction is concerned.

What kind of data you are trying to extract.

I assume its a delta load.

How have you set the delta, Is it weekly, daily?

Thanks

Raj

[Former Member]

Hi Raj,

I am extracting the data from standard datasource 2lis_02_itm .it is a delta load and scheduled in daily.

Satish..

[Former Member]

Hi,

we need to know what kind of DataSource it is (Generic, LO/LIS, other...)

If LO/LIS (application "aa") check in your source system qRFC monitor (SMQ1) if you have LUWs for the MCEXaa element. Next, check if you have LUW entries for your BW client ("ccc"); something like BWccc2LIS_aa_xxxx (this is your delta queue)

If you have entries in MCEXaa and none in BWccc2LIS_xxxx then either:

- the collective run job most probably didn't run; goto SM37 and search for jobs (all status; range of 3 days; all users) with ABAP program RMBW* in the job step. You should find a job with step RMBWVxaa. If not then you can create and schedule a job doing that via LBWE / job control for your application node.

Once this job has run the LUW entries in your outbound queue (MCEXaa) will be transferred to your delta queue (BW....) and you'll be able to extract delta.

- there is no delta initialized for your DataSource

hope hit helps...

Olivier

[Former Member]

Did you use Delta load...?

Is the problem for all the datasources or for some specific datasources?

Regards

[Former Member]

Check the extractor checker (RSA3) if there is data there. Replicate the datasource before loading the data. Are you doing doing delta loads?

Regards,

Lokesh

[former_member301934]

Hi,

check with Extractor Checker in R/3 system (tcode RSA3) for the datasource, enter the selection exactly same with your infopackage selection, and then execute. Is there any data return ? If not, then you should check to your source data based on your selection.

Hope this help.

[Former Member]

Is it Delta Load?

And is it LO Extractor or all Extractors.

If it is LO, make sure if there is any data in RSA7 but if there is nothing check in lbwq if there is any data for the specific components, if data is in lbwq but not rsa7, then you could check the V3 update in lbwe->Job control if the job is getting canceled for some reason, if that is the case, then find out the reason the job is canceled. In my experience, the person who scheduled the V3 job left and the job is getting released under his id and the id was expired, so the job couldn't finish.

Hope that helps.

thanks.

Wond