Skip to Content

Help with DTP with Processing Mode No Data Transfer, Delta Status in Source

Hi, I am trying to test a Cube to Cube Extraction where I do a full DTP Extraction for a specific account to get the data I need and then a DTP Delta Init by using Processing Mode "No Data Transfer, Delta Status in Source".

When I do the DTP Delta init using Processing Mode "No Data" this is done in Dialog mode, but is taking an extrodinarily long time to run as it looks like it is going back through all of the source infocube requests to somehow determine the delta marker. The source infoCube does have a lot of requests, but I would think this would be a very quick process to set the marker.

Any ideas why this dtp init delta with no data would take soooo long?

Add a comment
10|10000 characters needed characters exceeded

Related questions

5 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Oct 12, 2011 at 06:57 PM

    HI,

    This will run in background only, we can not run any DTP job in dialog. Make sure you have enough background process available in your system to start the DTP.

    http://www.haungo.com/2010/08/how-to-initialize-delta-dtp-in-bw-7-x/

    Regards,

    Venkatesh

    Add a comment
    10|10000 characters needed characters exceeded

    • Hi, Thanks for the information, but I see in the documentation that this type of proces is run in dialog mode. Could you point out where this process type would run in background only? Can anyone tell me why this would run so long?

      No data transfer; delta status in source: fetched 
      
      With this processing mode you execute a delta without transferring data. 
      This is analogous to simulating the delta initialization with the InfoPackage. 
      *In this case you execute the DTP directly in the dialog. *
      

  • author's profile photo Former Member
    Former Member
    Posted on Oct 13, 2011 at 06:30 AM

    Hi Kenneth,

    I don't think any issue in running this type of DTP in dialog mode , this is very similar to the infopackage delta initialization without data transfer.

    The question why it is taking lot of time may be because of lot of requests in source cube, as I understand it goes through all the requests for setting up the proper delta pointer.

    Regards,

    Durgesh.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 13, 2011 at 11:52 AM

    It definatly not takes long time for DTP without transfer, Just delete your Yellow request. Then came out from your current transaction. Again go to RSA1 and select your DTP and load execute Delta Init.

    It's happen surprisingly when completed your data load and immediatly you are running DTP

    Regards,

    Sushant

    Add a comment
    10|10000 characters needed characters exceeded

    • Thanks for the information. It looks like no one is sure what is going on with this.

      It took an hour for the DTP Transfer without data. It definately looks like it is going through all of the source InfoCube Requests, but I don't know why it would take so long for setting this delta marker.. I will submit something to SAP....

      update***

      I still have this one into SAP

      Edited by: Kenneth Murray on Nov 16, 2011 11:44 AM

  • Posted on Nov 23, 2011 at 07:06 AM

    HI there

    Have you found a solution for this yet? I have the same problem. If I try and init with no data transfer it times out due to the fact that it is runnin in dialog.

    I am desperate to find a solution for this.

    Thanks

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 12, 2011 at 06:08 PM

    SAP OSS Notes corrected the problem

    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.