R3trans error

[Former Member]

Hello all,

I backed up one of the SAP table using R3trans. I deleted entries in that table. Now I am trying to load them back again using R3trans. But import is failing with error Ext. prog.: External program terminated with exit code 4.

I checked there some entries getting created in the table but not all. How can i get detailed error information?

I tried this for several other tables and same story is repeated again.

regards,

Abhijeet

[former_member182034]

hi Abhijeet,

You have to follow this SAP note to import a table

Note 1942 - How does R3trans work?

Example:

Exp: 1

Exp: 2

[Former Member]

can you post export and import profile?

let me know

a

[Former Member]

Andrea,

Are you looking for control file i used for exporting and importing of data?

Regards,

Abhijeeet

[Former Member]

exactly!

so i understand better the scenario

cheers

a

[Former Member]

Control file to dwnload:

export

file='/tmp/key64.txt'

client=100

select * from cnvtdic_key64

Control file to upload:

import

file='/tmp/key64.txt'

client=100

Import worked, however, the job went in error with exit code 4 and few entries were missing in imported table.

[Former Member]

was sap down when you did the import? (this could explain why only few of the entries are not imported)

can you attach also trans.log?

a

[Former Member]

Hello Andrea,

No SAP was not down during import. I am not a sap basis person. Can you tell the location of log file? One more thing I want to add is I executed R3trans from SM69 transaction not from the command line.

Thanks again for your responds

Abhijeet

[Former Member]

hi Abhijeet

  the trans.log file should be where you launched r3trans and should tell you what went wrong

But let me tell you that if you import a table when sap is running there could be "conflicts" with sap processes...

anyway i'll wait the log

cheers

a

[Former Member]

Andrea,

I ran R3trans from SM69. I ran it in backgrond job mode. The log generated in job log was

27.04.2012 10:52:23 Job started

27.04.2012 10:52:23 Step 001 started

27.04.2012 10:52:23 External command: ZR3TRANS_IMP

27.04.2012 10:52:23 Related parameter:

27.04.2012 10:56:36 Ext. prog.: This is R3trans version 6.21 (release 720 - 05.04.11 - 11:45:00).

27.04.2012 10:56:36 Ext. prog.: R3trans finished (0004).

27.04.2012 10:56:36 Ext. prog.: External program terminated with exit code 4

27.04.2012 10:56:36 External program was cancelled

27.04.2012 10:56:36 Job cancelled

Is this the log you are looking after?

Shall I run R3trans again from command line? If that is the case, then is the following command write?

R3trans -w '/tmp/implog.log' -u 1 '/tmp/imptable.ctl'

with expectation that implog.log will give me the log

Thanks,

Abhijeet

[Former Member]

I am executing this on my personal system. Thus I am pretty sure that nothing else was running on it except my import command.

Abhijeet

[former_member182034]

HI abhijeet,

1. make sure that user SAPserviceSID is able to access \\trans folder.

2. Check the SAP note 1074030.

3. try to update R3Tran to latest version in upgrade kernel directory.

Regards,

[Former Member]

hi,

i did with my server

r3trans x (where x is a flat file with line1->EXPORT line2->file='test.dmp' line3->client=123 line4->select * from mytable)

and then

r3trans x1 (where x1 is a flat file with line1->IMPORT line2->file='test.dmp' line3->client=123)

but I did it from the op sys

can you do the same?

btw i received rc0004 too even if all the lines were correct

let me know

a