cancel
Showing results for 
Search instead for 
Did you mean: 

Records Transferred to ODS but Monitor shows 0 Records Transferred

Shamscharma
Participant
0 Kudos

We are in middle of an R/3 Upgrade to SAPERP.

While extracting GL Transaction data from R/3 to an ODS in BW 3.1 records are being transferred to ODS but the monitor is showing 0 Records. Although job has successfully completed in R/3 the status in monitor does not change. It stays yellow. As data is there in PSA and ODS New Table its possible to manually work on the data but monitor status does not change.

Any info regarding this would be a great help.

Thanks guys!

Accepted Solutions (1)

Accepted Solutions (1)

majeed_mohammedabdul
Active Participant
0 Kudos

Hi Suresh,

The Whole process of ODS Load is it transfers records from R/3 then puts it in New table , then the Activation process runs and the records are moved to Active table .

Till then the request shows Yellow since it is still running.

Check the Active table and the new table , if the records are still in New table then it means the request has not been activated yet.

Cheers

Majeed

Shamscharma
Participant
0 Kudos

Majeed/Dinesh,

What you say is right but irrespective of that monitor shows xx records from yy records (ex 50 records from 100)

info through out the extraction process. In my case monitor always shows xx records from 0 records.

Thanks for your support.

Suresg

Former Member
0 Kudos

Hello Suresh,

How many records you are loading? If the number of records are very large, initially it will show as XX from 0 and when selection is over, then it will show xx from yy. Are you uploading large number of records? For how long it is going and in the monitor at what stage the load process is?

Regards,

Praveen

Former Member
0 Kudos

Hi Suresh,

I have seen many time when it starts getting data it shows like 1000 from 0 like in your case but when the dataload finishes you will see the correct number.

Regards,

Rohit

Shamscharma
Participant
0 Kudos

Its not a real large load.

Its just over 500,000.

So it shows 500000 from 0 records.

Thanks to all of you!

Suresh

majeed_mohammedabdul
Active Participant
0 Kudos

Hi suresh,

check the monitor abt the estimated time and see if the load time is too big and if it is still showing yelllow do check the sm21 and st22 and see if there are any logs or dumps regarding ur load.

cheers

Majeed

Answers (3)

Answers (3)

Former Member
0 Kudos

Hi Suresh,

If your monitor shows XXX from 0 records then goto BD87 and you would find yellow package -> select that ans click execute.

Bye

Dinesh

Former Member
0 Kudos

Hi Suresh,

The request is yellow because the request is still getting activated. Just check is the ODS activation process is still running.

Bye

Dinesh

Former Member
0 Kudos

HI,

Check the settings in the monitor.