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

Getting dump after running dtp / loading data from dso to cube

Hi Folks

I am getting short dumb while loading data from my dso to cube

same flow is running in qa and prd system. but in dev system its throwing some error as i check in the past tr's were imported succesfully for this.

all the setting in the dtp filters and everything is same as of prd but still its throwing short dumb.

please find attached the snap shot and kindly help me with the resolution of the issue

Regards

Karan Sehjpal

Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • Posted on Nov 19, 2015 at 10:59 AM

    Hi Karan

    Please share the full dump from ST22. I think this should be probably because there must be data missing while doing lookups or select data.

    In ST22 log, get the information on where terminated. It will give you the exact code which has issue. You can check accordingly then.

    Hope this helps.

    Regards

    Karthik

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Nov 19, 2015 at 11:15 AM

    Hi Karan,

    Mean while lets try to activate source,target,transformation and dtp.

    Later try to re run your dtp.

    if your on BW 7.3 and SP5 then please go thru Note 1627236.

    Thanks

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Nov 19, 2015 at 11:34 AM

    Hi Sehjpal,

    When you loading the data from DSO --> CUBE.

    The Fallowing reasons is possible

    1 lock issue...in this case also you have to delete the request from the target.after making the QM status red........then lock get released you have to repeat the load.......

    2. loading data from DSO to infocube , the dtp run failed due to short dump.The error anlysis gives description as DBIF_RSQL_SQL_ERROR,

    Solution

    If data coming from multiple sources and failing the request. if you deleted the correct requests will also be deleted.

    Hence it is required to change the status of the failed job from red/yellow to green, activate the ODS data and then re-start the load from the (failing) source after correction of any possible errors.

    Thanks

    RMP

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Nov 20, 2015 at 04:14 AM

    Hi Karan,

    Pls try to activate flow once again with all dtp,dso, trans..etc... and then run dtp..

    have u written any routine inside trans ?? if yes,check/share for routine code ..

    Regards,

    Hitesh

    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.