Delta load fails in 7.x flow for transactional data

[former_member489760]

Activation of DTP has failed due to lower case data. Here are the steps that i have taken to resolve the issue

a)     Go to target and make the request red.

b)     delete the request from the target.

c)     Go to PSA and correct the data.

d)     Run and activate the failed DTP again from PSA.

Do the same activity as many times the load fails

Are these correct steps? is there any other step that i should keep in mind?

Thanks

[Former Member · Accepted solution]

This message was moderated.

[Former Member]

Hi Aditya,

For daily work around, above steps looks good.

For permanent solution, you can either write the characteristic routine at infoobject level for converting lowercase letters to uppercase (as suggested by Sriram and Leslaw) or you can mark the lowercase checkbox in the infoobject which would allow the data to load successfully even if it contains lowercase.

Hope this helps.

Regards,

Nikhil

[former_member194898]

Hi,

I think you should rather create routine/transformation for converting data to upper case instead of doing manual correction of data in PSA.

And then try to load data to DSO through that transformation.

In this way you test how that routine/transformation work.

In future any data in lower case will be converted to uppercase in this transformation.

In the trasformation use function TOUPPER( CONVERTEDCHAR )

But I think if the error occurs even after you has corrected the data it's not the end of what you have to do.

Regards, Leszek

[former_member183012]

Hi,

Your steps are correct.But it happens so many times then you need to act as suggested by sriram or ask your R/3 team that your source data format need to correct at source level itself so that you need not to do anything .

Regards,

Ganesh Bothe

[sriramvijay_ravidoss]

Hi,

The steps are ok. but you can write routines to avoid this problem.

-Sriram

[RamanKorrapati]

Hi Aditya,

bit confusion on your issue.

Are you facing DTP activation problem or Dtp data load problem.

Can you share your error screen shot please.

Thanks

[former_member489760]

DTP activation problem

[RamanKorrapati]

in such case, you need to transport active dtp from dev system to bw prod.

While activating dtp, if you got error please share here.

To activate dtp, above stops are not related.

You listed steps are useful when your data load to dso/cube was failed with bad or invalid data.

[former_member489760]

Sorry my bad. I meant after loading data in dso, we need to activate the DSO request.

And the information that you provided for DTP activation is also very helpful although its a completely different problem.

[RamanKorrapati]

Ok, During dso data activation you got error.

Have you error screen shot or error messages please share it.

if bad or invalid data then you can handle thru routines.

what kind of bad/invalid data:

if its lower case issue then you can select lower case option at info object level.

other wise inform to source team and enter the correct values in future.