Skip to Content
author's profile photo Former Member
0
Former Member

Process Chain Problem

Posted on Oct 13, 2006 at 03:42 PM 8 Views

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.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • author's profile photo Udayabhanu Pattabhi Ram Chamarthy
    Udayabhanu Pattabhi Ram Chamarthy
    Posted on Oct 13, 2006 at 03:59 PM
    0

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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 13, 2006 at 04:02 PM
    0

    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

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member
      Oct 13, 2006 at 04:18 PM

      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.

  • author's profile photo Former Member
    Former Member
    Posted on Oct 13, 2006 at 04:06 PM
    0

    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.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member
      Oct 13, 2006 at 04:30 PM

      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.

  • author's profile photo Former Member
    Former Member
    Posted on Oct 13, 2006 at 05:42 PM
    0

    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
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.