BW4Hana Clearing Data in Delta Queue

[blaise_chai]

Hi Experts,

Recently there users loaded vendor data into ECC with some mistakes in the data.

BW triggered an error while trying to load the data into with a delta DTP. Data has already been loaded into the Delta Queue so i am unable to reload the data, and there was no error during the delta queue request so i am unable to re-read the data.

How do I remove the data from the delta queue to repair the DTP?

Many thanks.

[Jan_van_Ansem]

On your DTP - Execute tab, select Processing Mode: No Data Transfer.

[blaise_chai]

Hi Jan,

When i tried to do the delta initialization, it triggers this error.

[Jan_van_Ansem]

I have not seen that error message before. Just clutching at straws here - what does the long description say in the error message?
It might give you a useful description or at least an error code which might help you to look for notes.

This goes down to the change pointer tables CDHDR and CDPOS, where I would stay clear of making manual changes.

[blaise_chai]

The long text doesn't seem to show anything extra

The issue is cause by 2 columns of data loaded into the delta queue with invalid format/data

Initially I thought about re-reading into the request but since it was a successful load, ODQMON doesn't let us do that.

I'm very new to BW so am really lost for ideas on what to do here. Please help.

[FCI]

Make a new delta initialization.

[blaise_chai]

May i know what are the steps to doing it?

Thanks.