Skip to Content

Loading error From ECC to Bw in one packet

Hi Guru

When i am loading the data for 0INSP_LOT_TEXT through process chain (DS for 0INSP_LOT_TEXT is in 7.0 Version) i got an error in the system for 1 or 2 of Data Package like "Data Package 1 : arrived in BW ; Processing : 2nd processing step not yet finished ", status is yellow which become red because of timeout after 7hr. this is one example this problem sometime occurs with other master also.

There are around 20 Data Packages, and i am getting the same message in the monitor for only 1 or 2 rest are green.

One Solution that we to currently doing is to repeat the data load for that Datasource through the repeat option in process chain but as there is around 40Lac record and to repeat the dataload is time taking job as we are loading data through process chain, so we have to repeat that through process chain next morning.

1. In 3.x flow there was option to repeat 1 Data Packet(error packet) out of n Data Packet but in 7 this option is not there please can any one help me to do the following in 7.0 flow.

2. Please help how to permanently fix this issue

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on Jul 03, 2012 at 12:17 PM

    Hi Himanshu,

    If you are not experiencing any issues when you run the job a second time later, this indicates that it is a resource conflict issue for a specific time during the nightly load window.

    Try the following:

    (1) Isolate the master data process chains to run by themselves. The goal is to ensure there are no transaction data load occurring, no aggregate rollups or any change runs occurring when the master data is loading. Yes, I know you have identified a TEXT which should not interfere with other loads but the older versions of BW programs used to have a similar bug where it locked the whole InfoObject (Transaction RS12). As BW has evolved a lot of these 'All or nothing' characteristic locks have been removed and fine tuned to the appropriate master data tables (Like attribute lock only). The idea is to eliminate the overlap of competing resources between the processing of master data and the processing of transaction data.

    (2) How any process slots are available during the nightly load window? Are the process chains trying to do too much in parallel? The nightly load window should have been built with a parallel strategy in mind which limits the total number of process variants that could possible execute. Yes, the process scheduler is smart enough to delay the execution of jobs when the available number of process slots gets overloaded, but there is still a limit on the amount it can queue up before the scheduled jobs just disappear. This includes the part where a single background process slot is needed for a quick status update to complete the InfoPackage status to complete.

    (3) Is the system configured to change the type of process slots to make more background slots available during the execution of the nightly load window? Then switch it back to have more dialog slots available during the day. Check with you basis team or have a look at transaction RZ03 and RZ04 to see if a Day/Night configuration is active and still switching each night.

    Hope this helps.

    Kind regards,

    John.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member lifesgud 12

      Hello,

      the answer about your question is: You need to run the IP again.

      Please follow the points that John mentioned.

      Check that no other loads interrup this load.

      Check if your system is ready for more loads process during the loading window (nigth)

      Also in IP menus there are one in particular called "Check the Jobs in Source system".

      During running time: Environment -> Job Overview -> Source system

      If this is Ok, then the problem is in BW.

      Regards.

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.