Remote Client Copy - Ended in Erros

[Former Member]

Hi Friends,

We recently performed a Remote client copy. What we normally do is we restore an latest offline backup of the Prod into an instance built exclusively for performing client copies into our QA system.

So if our actual PROD is ABC ( production ), the replica system is ADC. We restore latest backup onto ADC. Then from ADC we do a client copy onto AQC ( Quality ). We have n number of clients in AQC. When copying into a particular client we are facing this problem of 3 tables not being able to get copied. They are BKPF,LTAK and SOST. It happened twice that the Remote client ended with errors.

It says "Read or conversion error". The detailed error looks like below ;

TAB_COPY_R_CONTINUE LTAK WITH KEY:

I01 0000066362

Read or conversion error system: ADCT500 table: LTAK

ERROR: Internal error when inserting in table: LTAK

Internal error: 1,262,713 65,536 VERIFY_CNT

Process 00001 has copied data 25.02.2010 18:04:16

Read or conversion error system: ADC500 table: BKPF

Process 00002 has copied data 25.02.2010 19:09:00

Start: Recopy errors 25.02.2010 19:09:02

TAB_COPY_R_CONTINUE BKPF WITH KEY:

2100 5100019665 2008

Read or conversion error system: ADC500 table: BKPF

ERROR: Internal error when inserting in table: BKPF

Internal error: 6,948,636 1,777,664 VERIFY_CNT

Read or conversion error system: ADC500 table: LTAK

TAB_COPY_R_CONTINUE SOST WITH KEY:

OTF 34 000000019247

Read or conversion error system: ADC500 table: SOST

ERROR: Internal error when inserting in table: SOST

Internal error: 2,594,254 180,224 VERIFY_CNT

We approached SAP and they asked to do a DB reorg, run update statistics on both source and target and then re run the client copy.

Well DB reorg is a big activity so we just updated the statistics and ran again the "recopying errors" but still it is the same problem.

Can anybody please suggest something. Thank you.

regards

Vinod K

[Former Member]

Hi Friends,

My apologies for coming back to you guys so late. I kind of was lost to find a solution for this.

Hi Sanujit,

The database logs dont indicate anything at all about this error or i am not able to locate them.

Rajesh,

There was a table comparison done for these tables properties in both source and target and everything looked ok and confirmed by the application.

At this moment we have anyway decided to go a fresh client copy again as lot of time has already passed and there would be differences in source and target tables.

But anyway could you please tell me the procedure to transport tables between source and target systems?

Hi Anil,

SAP iS ECC 6.0 and Oracle is 10.2.0.4.0

Thanks again for your time and pateince.

Regards

Vinod K

[former_member227283]

Hi Vinod ,

Can you bit describe ..

what is an SAP and database version you are using.

Thanks

Anil

[Former Member]

Hi,

Make sure and confirm that BKPF,LTAK and SOST tables are not explicitely modified. In such cases this problem may occur.

You can also do one thing..

You can manually create TRANSPORT request of these tables and transport that request into TARGET system.

After that RETRY client copy...

I hope, you know how to transport the tables between SOURCE and TARGET system.

Regards.

Rajesh Narkhede

[Former Member]

Hi Vinod,

Can you please investigate on the following message in your log

"ERROR: Internal error when inserting in table: LTAK".

Not sure if it is going to help, please check the database logs about this error.

Regards,

Sanujit