cancel
Showing results for 
Search instead for 
Did you mean: 

Data load issues from ods to ods in bw

Former Member
0 Kudos

Hi,

Data loading taking long time from ODS to ODS.

I have one ods and and data sending from source ODS to 3 taget ODS.Request is yellow for long time whn i am running through initialization without data transfer.

There is no log in sm37.

Kindly anybody tell me what is the reason and how to solve this problem.

Sidhu.

Accepted Solutions (0)

Answers (2)

Answers (2)

umesh_pednekar
Active Participant
0 Kudos

Hi Sidhu

Is the data in your source ODS active ? Have you checked the change log ?

I would suggest that you try some different options prior to coming to a conclusion :

- Try doing a full load from the source ODS to the 3 target ODS. Check if there is an error.

- Try doing an Init with data . Check for errors.

Try and do the elimination methods if you are not getting logs or errors in ST22 / SM37. You should definitely get the job details in sm37.

Cheers

Umesh

Former Member
0 Kudos

Hi,

When i am running delta then not loading and status remains yellow for long period.

But when i am doing initialization without data transfer then 1 records going.

When i am doing delta 0 records going but when i am checking in my infopackage then initialization with transfer is not there.

umesh_pednekar
Active Participant
0 Kudos

Hi

When you do Init w/o data transfer then it will load just 1 record. Yes, it is correct.

When you follow it with delta then the records the source ODS should get loaded. I would suggest you to try one more method :

Remove 2 target ODS from the DTP and load data into only 1 ODS and check.

Cheers

Umesh

MartinMaruskin
Active Contributor
0 Kudos

Have you checked for ABAP dumps in TA ST22? Are there any dumps?

Former Member
0 Kudos

No.There is no dumps in st22.

MartinMaruskin
Active Contributor
0 Kudos

What is the job status in SM37? Might be that corresponding work process in set on hold?