Skip to Content

Info pack is hanging for longer times

Hi Gurus,

I had a Info pack which will fetch the data from IBM Data stage to SAP BW,When i'm executing the load jobs my info pack is in yellow for hours and message in Data stage is "APT_CombinedOperatorController,0: Logging delayed metadata.".Can any body throw some light on this?The Job over view is enabling for BW but not for Source system.The same for all other options.But i can see some ALE Management i din't know which were related to my job and how to deal them.

Regards,

Rambabu

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

5 Answers

  • Sep 19, 2014 at 05:40 AM

    Hi Any one faced this issue.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Rambabu Thota

      Thota,

      I am thinking that this problem is coming from IBM Data Stage.

      Setting a transaction's isolation level helps avoid various data anomalies.

      Please refer to the link below for more information on how to change the transaction isolation level to Read uncommitted:

      IBM Knowledge Center

      Regards,

      Ashvin

  • Sep 19, 2014 at 07:49 AM

    Hi Rambabu

    If the job overview is disabled for the source system, there should be something wrong about the job status.

    If you could check in source system directly to check if the system has enough background processes to execute the jobs, it would give you a clue.

    If there are lot of jobs waiting to run in released state, your job will also wait.

    You can also check this in other way, if you have another data flow from the same source system try running that to check if this is happening only with one IP or with all jobs associated with that source system.

    Regards

    Karthik

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Ram

      Is this the first time you are running this IP?

      Please give us more details on data as well. Approximately how much data lies in the source system. At least do you have an option to check the data in source system.

      If there is no data also, the IP will have yellow status forever. In that case, you should do as below.

      Click on the below option in your IP

      Below screen will appear. Change it to Green and execute the job again

      Share the screenshots of detailed tab of the IP monitor, if nothing worked out.

      Regards

      Karthik

      Capture.PNG (17.8 kB)
      Capture1.PNG (7.3 kB)
  • avatar image
    Former Member
    Sep 19, 2014 at 12:20 PM

    Hi,

    As my guess above messages clearly belongs source system.

    Source system have data? is this full load or delta load?

    if its full load, Again activate your data flow set up at source side and replicate data source into bw.

    activate data source and trigger info pack.

    If you check about above messages with Data stage team you may get useful information.

    Even you can search on google by using "APT_CombinedOperatorController,0: Logging delayed metadata".

    Thanks

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 20, 2014 at 01:53 PM

    Hi

    Actually in some case, while fetching data from IBM data stage to SAP BW,There are some Data stage jobs which will run before the BW job runs and Data stage jobs upload the data in some Excel format for BW.From there BW will pull the data.if everything is fine in BW,its better to check the data stage jobs once.

    Thanks,

    Add comment
    10|10000 characters needed characters exceeded

    • Hi

      If the Data stage jobs fails the File will not get uploaded.The Data Stage job has to be fixed.

      In BW data source Info package 3 rd Party Selection Tab you will get the Path of the file with Data Stage job Name also(Table name).


      You can see the data in the file by using the path if you have access of Data Stage server.


      Thanks,

  • avatar image
    Former Member
    Sep 26, 2014 at 10:48 AM

    Hi Rambabu,

    Take a screenshot of the third party tab in the info package (which shows the workflow) and ask the Datastage team if there is any problem with the workflow. If the workflow is inactive ask them to kill it and run infopackage again.

    Regards,

    Rajesh.

    Add comment
    10|10000 characters needed characters exceeded