cancel
Showing results for 
Search instead for 
Did you mean: 

Getting Zero Delta records after filling setup table for 2LIS_03_BF datasource

Former Member
0 Kudos

Hi Experts,

I have a dataflow with datasource 2LIS_03_BF in my BI system and data load is happening daily with delta mode.

As per the client requirement for data validation, yesterday I had deleted and filled the setup table in background for 2LIS_03_BF datasource.

But today morning, once our process chain loads are completed, and when checked the datasource, zero records are extracted (Successful) in today's load.

Our process chain will start daily morning 3.30 am IST.

Iam not getting why there is an impact on delta and what could be the reason for Zero records.

Regards,

Satish

Former Member
0 Kudos

Here my issue is. For this datasource Iam unable to see it in SMQ1 queue list or LBWQ list.

As my update mode is unserialized V3 update, I should be able to see this datasource in SMQ1 with entries updating to it.

But it is not present in SMQ1 itself.

Iam not getting why is it missing from SMQ1 list.

Regards,

Satish.

Accepted Solutions (1)

Accepted Solutions (1)

former_member186445
Active Contributor
0 Kudos

run the V3 job. it will gather the delta in the delta queue. afterwards run your delta again

Former Member
0 Kudos

Hi Mario,

But iam not able to see my datasource in SMQ1 queue list itself.

Will that work out if I run V3 job manually??

And once it is done, from next run will it work as it is as earlier??

bhavinvyas
Active Contributor
0 Kudos

First try to run the V3 job manually. Let us see it is fetching delta or not. There is no issue to run the V3 manually.

Thanks,

Bhavin Vyas

Former Member
0 Kudos

Hi Mario,

Your solution resolved my issue.

Thank you...

Regards,

Satish.

Answers (4)

Answers (4)

bhavinvyas
Active Contributor

Hi Satish,

Have you initialized the delta? also for inventory you have to be bit cautious while performing data loads. You may need to take the downtime as well in ECC in case of productive environment.

Please see these blogs and follow the steps to perform dataloads,

https://blogs.sap.com/2013/02/06/sap-bw-inventory-data-loading-step-by-step0icc03/

https://wiki.scn.sap.com/wiki/display/BI/Step+by+Step+Loading+Data+to+Inventory+Cube

Thanks,

Bhavin Vyas

Former Member
0 Kudos

Hi Bhavin,

Daily deltas are being loaded to BW system.

Regards,

Satish

Former Member
0 Kudos

Here my issue is. For this datasource Iam unable to see it in SMQ1 queue list or LBWQ list.

As my update mode is unserialized V3 update, I should be able to see this datasource in SMQ1 with entries updating to it.

But it is not present in SMQ1 itself.

Iam not getting why is it missing from SMQ1 list.

Regards,

Satish.

former_member186445
Active Contributor
0 Kudos

is the V3 update job still running?

do you have entries in lbwq?

do you have entries in rsa7?

Former Member
0 Kudos

Hi Mario,

No the V3 job is not running

Iam not able to see MCEX03 in LBWQ or BW5002LIS_03_BF in SMQ1.

Iam having delta in RSA7 but number of entries = 0.

Regards,

Satish.

Former Member
0 Kudos

Hi,

Check status below job in ECC system in SM37

LIS-BW-VB_APPLICATION_03*

Check LBWQ for MCEX03

Check LBWE whether updates for 2LIS_03_BF is active or not

Follow the documents referred by Bhavin Vyas

Regards,

Sucheta

Former Member
0 Kudos

Hi Sucheta,

Checked for LIS-BW-VB_APPLICATION_03* in SM37, last ran is on 14.06 2017

MCEX03 is not present in LBWQ

Updates are active for 2LIS_03_BF in LBWE

But as it is unserialised V3 update, i will get my entries in SMQ1 right. But i couldn't find my datasource in that list even.

Regards,

Satish

Former Member
0 Kudos

Hi,

Can you please check SM13?

Regards,

Sucheta

Anand71
Active Contributor
0 Kudos

Hi,

Check with T-Code : RSA3 in ERP whether you can to extract the data.

regards,

Anand Kumar

Former Member
0 Kudos

Hi Anand,

Yes iam able to get data in RSA3

Regards,

Satish.