Loading is running forever.

[Former Member]

Dear Experts,

Data load is running for a WBS Element. the load is running for ever ..last data packet not finishing loading..please assist

[Former Member · Accepted solution]

hey Prasad,

Go into Details tab of your load and check if extraction is done. If yes, then turn the load status to red, in monitor and target. Right click on the yellow package and select manual update.

Hope this helps.

Sheen

[former_member203104 · Accepted solution]

Hi,

Please check in SM58 if any trfc are stuck,if so process them manually.

Thanks

[Former Member · Accepted solution]

Hii,

Check if the job is running in sm37 or check for dump in ST22.

IF dump exists at ST22 then forcibly make the request red and delete the same ,reload again.

Regards,

Akshay

[Former Member]

Hello Experts,

too many thanks for your quick response. i have already tired the workaround suggestions before i post it in SCN. but it is my mistake, not explained issue clearly.. i would have provided all details and explained the tried workarounds

i have resolved this issue.. the BWA indexes are corrupted..have delted indexes and activated again.. it has resolved my issue...

Thanks,

Prasad.

[srikanth_rapur2]

Hi,

1.please check the job status in sm37 whether finishe or not then take pid num and check the status in sm50 about the availablity of background work process.

2. check whether the trfc's got struck.

3. check whether it is delta or full and take action i.e.... cancel the job and retrigger.

regards

sap

[Former Member]

Hi Prasad,

Cancel the request by making the traffic light to red explicitly. Then delete this request from the data target and reinitiate the load. It should work.

Meanwhile also check if there are any short dumps in the Warehouse by using the Tcode sm22. If a short dump exists for your load then you have got no other option than to repeat the data load as decribed in the first two statements above.

Regards,

Hemlata