Problem with client copy table export

[Former Member]

Hi,

We have followed the steps described in SAP note 1942 but we don´t know if the control file format it´s incorrect because we obtain always errors:

clientcopy

source client = 200

target client = 210

use commandfile 'JK1K909818' ' select * from BALDAT where mandt ='200'

we obtained this error :

./R3trans -w test.log -u 1 test

This is ./R3trans version 6.14 (release 701 - 19.01.11 - 11:44:00).

unicode enabled version

2EETW000 error when reading the R3trans controlfile

2EETW000 syntax error at line 4, symbol "' SELECT * FROM BALDAT WHERE MANDT ='".

syntax error at line 4, symbol "' SELECT * FROM BALDAT WHERE MANDT ='"..

2EETW000 error when reading the R3trans controlfile

2EETW000 syntax error at line 5, symbol "'".

syntax error at line 5, symbol "'"..

./R3trans finished (0012).

Could you help us?

Which is the correct format to include the transport order and the select?

Thanks a lot and best regards, Sapera

[JPReyes · Accepted solution]

I can't find any reference to the "mandant" in the client copy segment of the note, that could be the cause of the syntax error.

Have you tried with,

use commandfile 'JK1K909818' ' select * from BALDAT

Regards

Juan

[Former Member · Accepted solution]

Hi,

Yes, we also tried with this

use commandfile 'JK1K90981 ' select * from SAPSR3.BALDAT;

and now the error is this one

2EETW000 error when reading the R3trans controlfile

2EETW000 syntax error at line 4, symbol "COEP".

syntax error at line 4, symbol "COEP".

expected: "RESTRICTVALUE", "WITH", "WHERE".

Also we tried with this one:

use commandfile 'JK1K90981 ' select * from BALDAT;

And the error was the same...

Any idea?

Thanks thnaks thanks a lot , sapera

[Former Member · Accepted solution]

SAP note 1942 says in section III Copying clients that you have to use commandfile OR select clause, but not both.

[Former Member · Accepted solution]

thanks a lot, sapera

[blanca_serrano]

Hi Sapera,

Can you update the kernel stack (Specially udate to the latest DBSL) and try again?

Regards,

Blanca