Skip to Content
avatar image
Former Member

Long Running Update to Infocube

Hello all

We have DTP that always run successfully, but had failed today. The process runs for 8 hours and still does not have short dump. Data is only little to process that is why 8hours should not be happening. There's no error message.

Looking the request, Data Package is still yellow.

Updating to InfoCube: 19,376 -> 0 Data Records is yellow

Green status for Overlapping check with archived data areas for InfoProvider and Conversion of Characteristic Values to SIDs.

But after this steps, No Message: Write to Fact Table and No Message: InfoCube Update Completed are not executed that is why it is forever yellow.

I'm facing above error for all DTP's and Background job is cancelling for all dtp's and there is no job log creation as well.

Could you please suggest solution for this? I have tried to change the request to red and delete it. then reload the dtp again but still in yellow.


Thans & Regards

Narendra

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

8 Answers

  • Best Answer
    Jan 14, 2015 at 12:04 PM

    Hello Narendra

    Do you see any dump in the BW system. Check for the BW system space also.

    Regards

    Gajesh

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hello Rajesh

      sorry for delay, i went for vactaion.

      There is no dump arising on BW System and space also available.

      Thanks & Regards

      Narendra

  • avatar image
    Former Member
    Jan 14, 2015 at 12:09 PM

    Hi,

    Try to run your dtp only where there is no other loads on bw and see.

    As of now lets continue present dtp. once it fails please share error message or dump details.

    As of now we can't judge what will be the issue in your case.

    it full load or delta load?

    Thanks

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hello Ramanjaneyulu

      I have tried running DTP when there is no other loads but still i'm facing same error.

      Its not triggering any errors but DTP is in yellow and 0 records are updating to the target and

      its a full load.

      Thanks & Regards

      Narendra

  • Jan 14, 2015 at 12:10 PM

    Hi,

    check the process avaliable in the SM51

    any process chains running parelly?

    have you updated any patches?

    Thanks,

    Phani.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hello Kodanda pani

      I have checked sm 51 and process are available.

      There is no process chains are running parellaly.

      I have not updated any patches.

      Regards

      Narendra

  • avatar image
    Former Member
    Jan 14, 2015 at 07:59 PM

    Hi Narendra,

    also check for lock entries in sm12

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Kodanda Pani KV

      Hello kodanda pani,

      Its not related to one infocube, the above mentioned error is for all infoproviders in development scenario.

      Thanks & Regards

      Narendra

  • Jan 19, 2015 at 01:41 PM

    Hi,

    please check your infocube design means dimension table size should not be more than 20% of fact table.

    Thanks,

    Swapna

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 19, 2015 at 02:31 PM

    Is the DTP running in process chain ? If yes, Try to activate you process chain and re run.

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 20, 2015 at 08:31 AM

    Hi Narendra,

    Try checking and Reparing the Infocube in SE14 . If its inconsistent then loads dont happen .

    Regards,
    RKS

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 21, 2015 at 06:31 AM

    Hello All

    The issue related long running update to cube is been resolved and it is raised because of lack of space in BW server. Thank you for your help.

    Thanks & Regards

    Narendra

    Add comment
    10|10000 characters needed characters exceeded