topic Re: Delete adjacent duplicates in Application Development and Automation Discussions

Delete adjacent duplicates

Former Member — Mon, 09 Dec 2013 12:13:57 GMT

Hi Team ,

I have been strugguling with a typical issue .

Our Production system has been migrated from Window to Unix ( Os 400 ) system , In one of the report the below code works differenctly .

sort t_lqua by werks matnr.
delete adjacent duplicates from t_lqua comparing all fields.

In one production system the T_tqua is a result of 142 records and other sytem it is giving 129 records there is a data loss of 13 records . Some one can please help me on how to solve this issue .

Regards,

K.Vinay Kumar .

Re: Delete adjacent duplicates

Former Member — Mon, 09 Dec 2013 12:18:10 GMT

Hi Kumar,

For this you need analyze record by record only,

it is possible to tell after analysis only

Re: Delete adjacent duplicates

Former Member — Mon, 09 Dec 2013 12:26:38 GMT

Are you sure T_tqua contains the same data in both they systems before the delete statement?

Kindly debug and compare the contents of t_tqua in both the systems before the delete statement.There is probably a difference in format for some fields in both the systems.

Re: Delete adjacent duplicates

himanshu_gupta13 — Mon, 09 Dec 2013 12:29:15 GMT

Dear Vinay,

I think data is different in both the production system.. please check it before sort and delete adjacent.

Many Thanks / Himanshu Gupta

Re: Delete adjacent duplicates

stefan_schmcker — Mon, 09 Dec 2013 12:35:35 GMT

Hello Vinay Kumar,

you sort your table by only two fields and then delete adjacent duplicates comparing all fields.

Thus the final outcome depends on the sorting of your internal table before the first sort and is not guaranteed to always give the same result.

Re: Delete adjacent duplicates

Former Member — Mon, 09 Dec 2013 12:39:54 GMT

Hello,

Please consider these 2 things:

1. Are you sure you have the exact same data in both system?

2. Normally you should sort and delete adjacent by the same fields.

Re: Delete adjacent duplicates

anupam_anand — Mon, 09 Dec 2013 13:24:42 GMT

Hi Vinay,

Please check the following things:

1. You are giving the same selection screen parameters.

2. Put a breakpoint on the 'DELETE ADJACENT DUPLICATES' statement and check the internal table contents in debugger in both the scenarios.

3. Check the place where you populate this internal table. Check if different values are getting populated in the internal table.

Thanks,

Anupam

Re: Delete adjacent duplicates

Former Member — Mon, 16 Dec 2013 08:58:16 GMT

Hi Anupam ,

Thanks for your response , we have values different at table level .

Looks like this is a migration issue .

Regards,
K.Vinay Kumar

Re: Delete adjacent duplicates

former_member43585 — Mon, 16 Dec 2013 09:07:38 GMT

Hi Vinay,

Also there might be a possibility that after migration some transactions have been processed due to which there might be some additional entries inserted in the table.

Regards,

Ramiz