Sap bw: cannot delete DTP

Source: Internet
Author: User

Problem:

Cannot delete data transfer process (DTP) from DSO/cube to DSO/cube. Despite all the pre-conditions have been met, such as deleting data and requests in the target and source.

Error Message:

Delta DTP cannot currently be deleted (see long text)
Message No. rsbk037

Diagnosis
You want to delete a Delta DTP that has been successfully used to load requests from the source into the target. if you delete the DTP, you will also delete the information on the source data that was successfully transferred. as a result the source data wocould
Be transferred again, If you create a new Delta DTP that links the same source with the same target.

Procedure
You have two options:
1. delete all the requests loaded with this DTP from the target and then delete the DTP.
2. Do not delete the DTP and continue to load deltas using this DTP.

Solution:

Go to transactionRsbkdtpTo delete DTP directly.(RsbkdtpIs a tabe if "delete" in the table is gray, you can use ABAP in se38Program

Delete from rsbkdtp

Where DTP = 'dtp _ 07dskgxkg6fhjkz0qz1icpv01'

To execute,

Or use/h to enter the debug mode for deletion. However, you have to consider using the background table to perform this operation. tr won't remember this operation. Will it be a problem if it is passed to QAS? )

Source: http://forums.sdn.sap.com/thread.jspa? Threadid = 1568522 & messageid = 8581401

Additional note:

Data transfer process (DTP) is related to various object such as target, source and transformation. here's an extra table check for transformation. after deleting DTP, cube or DSO than the transformation shocould be deleted too.

RstranTransformation
RstranfieldMapping of rule parameters-structure Fields
RstranruleTransformation rule
RstransteproutRule type: Routine
RstranrulestepRule steps for a transformation rule
RstranstepmapMapping for rule step within a rule

Source: http://www.sapks.com/2010/01/dtp-tables.html

 

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.