Process Chain Problem

[Former Member]

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.

[Former Member]

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.

[Former Member]

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.

[Former Member]

Hi Liu,

Thanks.

1)I will try to explain the design of the PC. One basic ODS(Level 1) >Feeding multiple ODS (Level 2)>Both Level 1(Basic ODS)and Level 2 ODS feeding the cubes [Two separate jobs-One for "Open" and one for "closed"]

2)The loads from Basic ODS(Level 1) to the cubes go fine. The problem is in one of the loads from Level 2 ODS to the cube.

So although,it doesn't error out-it takes a long time(I will check on Kedar's suggestions also & get back).

Thanks.

[Former Member]

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

[Former Member]

Hi Kedar,

Thanks.

1)In the processing of the data packages-there are no errors in the transfer or update rules(No Errors).But then,in some packets it doesn't "Update(0 new/0 changed):Warning Received" --it is still trying to activate one of the infocubes.

2)There are no short dumps.

But I will look at your other suggestions and get back.

Thanks.

[udayabhanupattabhiram_cha]

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.,

[Former Member]

Thanks Ram.

1)We did try loading from the infopackage "the part" which was initially giving problem in the process chain.

2)That worked fine.So we tried the "entire" process chain

But I will re-test it.

Thanks.