Skip to Content

DTP data packet got hanged while loading from DSO to cube

Hello Experts,

I am facing an issue with DTP data loading, I have searched the forum but not helpful.

There are 19 data packets in the DTP, while loading always 5th,11th and 12th packets are got hanged in yellow color, no records added to the cube.

Data is loading from DSO to CUBE.

Background processes are available, no dead locks found, no error message.

I have deleted the indexes and loaded the master data then triggered again,but no luck.

Could you please some one throw light on this issue.

Thanks & Regards

Venkat

Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • Posted on Jul 24, 2016 at 10:41 PM

    Hi,

    Could you share the screenshot of the error?

    Have you checked the memory of the machind in db02, lack of memory also is impossible to load the data.

    Regards,

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 25, 2016 at 05:42 AM

    hi Venkat,

    please check SM50 and find the long running job/PID.

    click on your long running job and see details.

    if there is no increment in insert/update record numbers then please cancel your job and re-trigger your dtp.

    During your load, server/BGDs will be busy and unable to process your request..

    Thanks

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 25, 2016 at 06:14 AM

    Hi,

    Please check "overall Status of Request" to set automatically in DTP.


    This might be due to a deadlock, please check resources as others have already mentioned.


    If possible kindly add some screenshots of the situation.


    Regards,

    Las

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 25, 2016 at 04:07 PM

    Hi All,

    Thank you so much for your inputs.

    I found the root cause of the issue, due to inconsistency in SID's it is hanged.

    I ran the complete process chain then all the master data and SID's were corrected and transaction data also successfully loaded to cube.

    Once again thank you so much.

    Regards

    Venkat

    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.