Help with DTP Behavior with Error Handling

[sap_cohort]

Hi, We have a DTP set wtih "Valid Records Update, No Reporting (Request RED)" and I have some questions about the behavior to this setting.

I am loading from DataSource into a DSO. I have Referential Integrity set to a couple of fields in the Transformation and the DTP Load is correctly catching the Errors and putting them into the Error Stack just fine. The only problem is that once the errors occur, the loading process is halted and no further requests continue to load unless we mark the request with errors as successful(green). I have the "Get All New Data Request by Request" checkbox selected in the DTP.

This seems like a hassle having to turn the request green before loading will continue. When I 1st set this up i thought the loading continued automatically.

To get it to automatically keep loading do I just need to set the DTP Error Handling to "Valid Records Update, Reporting Possible (Request Green)? And if I do this how will I know if there were any errors in the load?

Thanks for any help with this..

[Former Member · Accepted solution]

Hi,

Yes you are right, it will save a lot of hassle by changing the option to " Valid Records Update, Reporting Possible (Request Green)".

Also you are right in thinking that this will trigger the subsequent steps in the process chain.

But then, there will be no track of when the records got stuck in error stack.

Please check this article:

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/e01c300f-e02f-2c10-46a8-b5ac929bc...

This will help you understand how you can monitor your error stack for any errors.

Hope this answered your question.

-Vikram

[sap_cohort · Accepted solution]

Thanks, Perfectly clear now... Just for my own Tribal Knowledge I just need to verify what am I seeing is the expected behavior due to a combination of the below settings.

When loading Multiple Requests from PSA everything is fine until error is encountered. Once errors are encountered the loading of further requests halts until I turn the Red Request to a Green Status in the DSO. Once I do that the remaining PSA Requests start loading again.

1. PSA has 15 Requests

1. Error handling being set to" "Valid Records Update, No Reporting (Request Red)"

2. Extraction being set to "Get All New Data Request by Request"

I plan on changing our DTP to use the Error Handling Option "Valid Records Update, Reporting Possible (Request Green)". As you say this should keep the PSA Requests loading and we will have to monitor for DTP Error Stacks.

Thanks for your help with this!

[Former Member · Accepted solution]

Hi Kenneth,

Yes , your understanding is 100% correct now.

-Vikram

[Former Member]

Update valid records, no reporting (request red)

This option allows you to update valid data. This data is only released for reporting after the administrator checks the incorrect records that are not updated and manually releases the request (by a QM action, that is, setting the overall status on the Status tab page in the monitor).

The incorrect records are written to a separate error stack in which the records are edited and can be updated manually using an error DTP.

Update valid records, reporting possible

Valid records can be reported immediately. Automatic follow-up actions, such as adjusting the aggregates, are also carried out.

The incorrect records are written to a separate error stack in which the records are edited and can be updated manually using an error DTP.

<To get it to automatically keep loading do I just need to set the DTP Error Handling to "Valid Records Update, Reporting Possible (Request Green)? And if I do this how will I know if there were any errors in the load?>

- Yes. In that case you will have to check the error stack.

Using "No Update, No reporting" is a convenient way to tackle error handling incase error DTPs are not used.