on 01-14-2015 6:00 AM
Hello all
We have DTP that always run successfully, but had failed today. The process runs for 8 hours and still does not have short dump. Data is only little to process that is why 8hours should not be happening. There's no error message.
Looking the request, Data Package is still yellow.
Updating to InfoCube: 19,376 -> 0 Data Records is yellow
Green status for Overlapping check with archived data areas for InfoProvider and Conversion of Characteristic Values to SIDs.
But after this steps, No Message: Write to Fact Table and No Message: InfoCube Update Completed are not executed that is why it is forever yellow.
I'm facing above error for all DTP's and Background job is cancelling for all dtp's and there is no job log creation as well.
Could you please suggest solution for this? I have tried to change the request to red and delete it. then reload the dtp again but still in yellow.
Thans & Regards
Narendra
Hello Narendra
Do you see any dump in the BW system. Check for the BW system space also.
Regards
Gajesh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello All
The issue related long running update to cube is been resolved and it is raised because of lack of space in BW server. Thank you for your help.
Thanks & Regards
Narendra
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Narendra,
Try checking and Reparing the Infocube in SE14 . If its inconsistent then loads dont happen .
Regards,
RKS
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Is the DTP running in process chain ? If yes, Try to activate you process chain and re run.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
please check your infocube design means dimension table size should not be more than 20% of fact table.
Thanks,
Swapna
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Narendra,
also check for lock entries in sm12
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
check the process avaliable in the SM51
any process chains running parelly?
have you updated any patches?
Thanks,
Phani.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Try to run your dtp only where there is no other loads on bw and see.
As of now lets continue present dtp. once it fails please share error message or dump details.
As of now we can't judge what will be the issue in your case.
it full load or delta load?
Thanks
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
10 | |
10 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.