Hi All,
The process chain is taking a long time to execute.
1.Scenario:Have to manually kill the process chain as it is taking a long time to complete.
2.Problem:Some of the data packets show "Missing Messages" warning(Yellow) & the processes are still running. We had to cancel the job as it was taking a long time.There are no problems in the transfer & update rules(Returns with no errors)in the data packets.
3.Environment:HP-Unix/Oracle 10
4.Solution Tried:
a)We have checked the cubes and ODS(RSRV)for consistencies
b)We changed the ODS settings for serial processing(we have several instances in the same box--parrallel processing was causing a time out issue).
Any insight or help would be appreciated.
Thanks.
Hi:
1) Load from outside using infopackage and see how long it takes.
2) THen immediatly load using Process Chain.
If 1) is finished and 2) is hanging up, then tell me.
Ram C.,
Hi,
At which part of the process i.e transfer or update rules, post processing, etc are the missing mesasges being shown ?
You can check using SM58 if any data packets are getting stuck and if so then you can manually push them over.
Check if there are any short dumps.
Also make sure that the data extraction has finished, or wait till the job times out. Are there any routines, or logic in the transfer or update rules that might be taking a long time ? Also check the processes to see if they are doing anything or just sitting there.
Check if they are actual warnings. If so you can goto the infopackage and through there to treatment of warning and set it to green. So, next time even if there are warnings, the load will turn green.
Cheers,
Kedar
Hi,
A few thoughts:
try to load data using info package (just for test purpose). if it is run in the reasonable and expected timeframe, then it would be good to have a closer look into the PC design.
In PC design, if you have several data targets, it would be good to have the steps running in serial instead of parallel, esp. for the data activation step.
If you could share more info about which steps in your PC having problem (loading, ODS activation ...), it would be very help for analsis.
Have you reviewed how many background processes you have defnied on your server and how many might be trying to run at this time?
The recommendation is N + 1 background processes are needed for N Process Chains and subchains that are running, e.g. you have 1 metachain that has 4 subchains - which menas you should have 5 background processes available when you go to run the metachain.
Having insufficient background processes availalbe can manifest itself in a variety of problems.
Add a comment