cancel
Showing results for 
Search instead for 
Did you mean: 

Client import Error "Unexpected error EOF after bytes"

former_member183788
Active Participant
0 Kudos

Dear Experts,

While importing client am getting the below error.

1AETW042 unexpected EOF after "1351253555" bytes.

2EETW000 Please contact the SAP support.

4 ETW000 End of Transport (0016).

4 ETW000 date&time: 27.06.2014 - 12:03:40

4 ETW000 2 warnings occured.

4 ETW000 2 errors occured.

1 ETP154 MAIN IMPORT

1 ETP110 end date and time   : "20140627120340"

1 ETP111 exit code           : "16"

1 ETP199 ######################################

Accepted Solutions (1)

Accepted Solutions (1)

former_member188883
Active Contributor
0 Kudos

Hi Prathish,

It looks to be problem with R3trans file. Can you update R3trans and tp files with newer patch and check the results.

Hope this helps.

Regards,

Deepak Kori

Former Member
0 Kudos

Hi,

Also have a look on file system & tablespace

Regards

Answers (2)

Answers (2)

Former Member
0 Kudos

If you have moved the data file from System A to System B , ensure the size in the destination is the same as the source. I have seen this happen when the datafile is incompletely copied especially in the case of large transport files.  You can also use the command R3trans -l  <datafilename> to validate a datafile.

Thanks,

Uday

former_member182657
Active Contributor
0 Kudos

Hi,

Kindly follow SCN thread

and refer SAP Note 2050.

Regards,

Gaurav

former_member183788
Active Participant
0 Kudos

Dear Rana,

How and where to set the value for below R3trans?

Limit the memory utilization of R3trans.

To do this, R3trans has the option TCS. Set the value of this option to half the value that is specified in the above message 4 ETW000 twrtab reached memory limit;"

former_member182657
Active Contributor
0 Kudos

Hi Philip,

Could you please share the complete error log for analysis.

Regards,

Gaurav

former_member183788
Active Participant
0 Kudos

Dear Rana,

Error as follows:

1 ETP199X######################################

1 ETP154 MAIN IMPORT

1 ETP101 transport order     : "IDEKT00005"

1 ETP102 system              : "IDT"

1 ETP108 tp path             : "tp"

1 ETP109 version and release : "380.03.41" "720"

1 ETP198

4 ETW000 R3trans.exe version 6.22 (release 720 - 03.06.11 - 17:57:00).

4 ETW000 unicode enabled version

4 ETW000 ===============================================

4 ETW000

4 ETW000 date&time   : 28.06.2014 - 08:20:39

4 ETW000 control file: \\AWQAFIDES-HQ\sapmnt\trans\tmp\IDEKKT00005.IDT

4 ETW000 > #pid 2324 on AWQAFIDES-HQ (APServiceIDT)

4 ETW000 > import

4 ETW000 > buffersync=yes

4 ETW000 > file='\\AWQAFIDES-HQ\sapmnt\trans\data\RT00005.IDE'

4 ETW000 > continuation='\\AWQAFIDES-HQ\sapmnt\trans\data\RT00005_#.IDE'

4 ETW000 > client=900

4 ETW000 > repeatimport=yes

4 ETW000 >

4 ETW000 > excluding 'R3TRDDDD','R3TRDOMA','R3TRDTEL','R3TRENQU','R3TRMACO','R3TRMCID','R3TRMCOB','R3TRSHLP','R3TRSQLT','R3TRTABL','R3TRTTYP','R3TRUENO','R3TRVIEW'

4 ETW000 R3trans was called as follows: R3trans.exe -u 8 -w \\AWQAFIDES-HQ\sapmnt\trans\tmp\IDEIT00005.IDT \\AWQAFIDES-HQ\sapmnt\trans\tmp\IDEKKT00005.IDT

4 ETW000 active unconditional modes: 8

4 ETW000 Connected to DBMS = MSSQL ---  SERVER = 'AWQAFIDES-HQ' DBNAME = 'IDT' --- SYSTEM = 'IDT'.

4 ETW690 COMMIT "0" "0"

4 ETW000  trace at level 1 opened for a given file pointer

4 ETW000

4 ETW000 ================== STEP 1 =====================

4 ETW000 date&time        : 28.06.2014 - 08:20:39

4 ETW000 function         : IMPORT

4 ETW000 data file        : \\AWQAFIDES-HQ\sapmnt\trans\data\RT00005.IDE

4 ETW000 Continuation     : \\AWQAFIDES-HQ\sapmnt\trans\data\RT00005_#.IDE

4 ETW000 buffersync       : YES

4 ETW000 client           : 900

4 ETW000 repeatimport     : YES (corresponds to unconditional mode 1)

4 ETW000 repeatclimport   : NO

4 ETW000 c.s.i.           : NO

4 ETW000 charsetadapt     : YES

4 ETW000 def. charset     : WEUROPEAN

4 ETW000 commit           : 100000

4 ETW000 table cache      : dynamic

4 ETW000 EXCLUDING        : 'R3TRVIEW','R3TRUENO','R3TRTTYP','R3TRTABL','R3TRSQLT','R3TRSHLP','R3TRMCOB','R3TRMCID','R3TRMACO','R3TRENQU','R3TRDTEL','R3TRDOMA','R3TRDDDD'

4 ETW000

4 ETW000 Data file is compressed with algorithm 'L'.

4 ETW000 export timestamp: 20140627192846

3 ETW709 "731 "

4 ETW000 exported with R3trans version: 03.06.11 - 17:57:00

4 ETW000 Source System = PC with Windows NT on DBMS = ORACLE --- dbs_ora_tnsname = 'IDE' --- SYSTEM = 'IDE'.

4 ETW000

4 ETW000 language vector during export: ABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789abcdi(),./:;&

4 ETW000 language vector during export: ABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789abcdi(),./:;& (ISO-ARHECSDEENFRELHUITJADAPLZFNLNOPTSKRUESTRFISVBGLTLVZ1SRZHTHKOROSLHRMSUKETAFISCASHIDZ2Z3Z4Z5Z6Z7Z8Z9)

4 ETW000 lsm during export: VECTOR

4 ETW000 trfunction = M (client transport)

4 ETW000 Used Commandfile IDEKT00005           (PPHILIP/117)

4 ETW000 Syslog: k CQC : rscpexcc-getSetting&                                 rscpexcc 12

4 ETW000 GetDBMigrateCodePagesLangs uses TCP0D, TCPDB, TCP0C.

4 ETW000 preview transport request IDEKT00005          % deleted.

4 ETW690 COMMIT "76190" "76190"

4 ETW000 This is a client transport.

4 ETW000   1 entry for E070 inserted (IDEKT00005).

4 ETW000 117 entries for E071 inserted (IDEKT00005          *).

4 ETW000   1 entry for E071K inserted (IDEKT00005          *).

4 ETW000   2 entries for E071KF inserted (IDEKT00005          *).

4 ETW000   1 entry for E070C inserted (IDEKT00005).

4 ETW000 185 entries for E070A inserted (IDEKT00005          *).

4 ETW000   1 entry for E07T inserted (IDEKT00005          *).

3 ETW674Xstart import of "R3TRTABUADCPS" ...

4 ETW000 This database uses collation SQL_Latin1_General_CP850_BIN2

4 ETW690 COMMIT "151590" "227780"

4 ETW690 COMMIT "150800" "378580"

4 ETW690 COMMIT "150800" "529380"

4 ETW690 COMMIT "150800" "680180"

4 ETW690 COMMIT "150800" "830980"

4 ETW690 COMMIT "150800" "981780"

4 ETW690 COMMIT "150800" "1132580"

4 ETW690 COMMIT "150800" "1283380"

4 ETW690 COMMIT "150800" "1434180"

4 ETW690 COMMIT "150800" "1584980"

4 ETW690 COMMIT "150800" "1735780"

4 ETW690 COMMIT "150800" "1886580"

4 ETW690 COMMIT "150800" "2037380"

4 ETW690 COMMIT "150800" "2188180"

4 ETW690 COMMIT "150800" "2338980"

4 ETW690 COMMIT "150800" "2489780"

4 ETW690 COMMIT "150800" "2640580"

4 ETW690 COMMIT "150800" "2791380"

4 ETW690 COMMIT "150800" "2942180"

4 ETW690 COMMIT "150800" "3092980"

4 ETW690 COMMIT "150800" "3243780"

4 ETW690 COMMIT "150800" "5958180"

4 ETW000   0 d / 7705 i /   0 u /   0 =   0% ucf ADCPS

4 ETW000 7705 entries for ADCPS imported (900*).

4 ETW675 end import of "R3TRTABUADCPS".

3 ETW674Xstart import of "R3TRTABUADR10S" ...

4 ETW000   0 d /   2 i /   0 u /   0 =   0% ucf ADR10S

4 ETW000   2 entries for ADR10S imported (900*).

4 ETW675 end import of "R3TRTABUADR10S".

3 ETW674Xstart import of "R3TRTABUADR11S" ...

4 ETW000 no entries from ADR11S (*) deleted (table is empty).

4 ETW000 no entries from ADR11S (*) deleted (table is empty).

4 ETW675 end import of "R3TRTABUADR11S".

3 ETW674Xstart import of "R3TRTABUADR12S" ...

4 ETW000   0 d /   3 i /   0 u /   0 =   0% ucf ADR12S

4 ETW000   3 entries for ADR12S imported (900*).

4 ETW675 end import of "R3TRTABUADR12S".

3 ETW674Xstart import of "R3TRTABUADR13S" ...

4 ETW000   0 d /   1 i /   0 u /   0 =   0% ucf ADR13S

4 ETW000   1 entry for ADR13S imported (900*).

4 ETW675 end import of "R3TRTABUADR13S".

3 ETW674Xstart import of "R3TRTABUADR2S" ...

4 ETW000   0 d / 102 i /   0 u /   0 =   0% ucf ADR2S

4 ETW000 102 entries for ADR2S imported (900*).

4 ETW675 end import of "R3TRTABUADR2S".

3 ETW674Xstart import of "R3TRTABUADR3S" ...

4 ETW000   0 d /  28 i /   0 u /   0 =   0% ucf ADR3S

4 ETW000  28 entries for ADR3S imported (900*).

4 ETW675 end import of "R3TRTABUADR3S".

3 ETW674Xstart import of "R3TRTABUADR4S" ...

4 ETW000 no entries from ADR4S (*) deleted (table is empty).

4 ETW000 no entries from ADR4S (*) deleted (table is empty).

4 ETW675 end import of "R3TRTABUADR4S".

3 ETW674Xstart import of "R3TRTABUADR5S" ...

4 ETW000 no entries from ADR5S (*) deleted (table is empty).

4 ETW000 no entries from ADR5S (*) deleted (table is empty).

4 ETW675 end import of "R3TRTABUADR5S".

3 ETW674Xstart import of "R3TRTABUADR6S" ...

4 ETW690 COMMIT "136914" "6095094"

4 ETW690 COMMIT "150800" "-1"

4 ETW690 COMMIT "150800" "-1"

1AETW042 unexpected EOF after "338689622" bytes.

2EETW000 Please contact the SAP support.

4 ETW000 End of Transport (0016).

4 ETW000 date&time: 28.06.2014 - 08:49:02

4 ETW000 2 errors occured.

1 ETP154 MAIN IMPORT

1 ETP110 end date and time   : "20140628084904"

1 ETP111 exit code           : "16"

1 ETP199 ######################################

former_member182657
Active Contributor
0 Kudos

Hi Philip,


3 ETW674Xstart import of "R3TRTABUADR6S" ...

4 ETW690 COMMIT "136914" "6095094"

4 ETW690 COMMIT "150800" "-1"

4 ETW690 COMMIT "150800" "-1"

1AETW042 unexpected EOF after "338689622" bytes.

2EETW000 Please contact the SAP support.

As per SAP Note 2050 (Which i already suggested to you) possible reasons for the above issue could be


Incomplete file transfer

  1. Make sure the export is complete and that the target directory has enough space for the file. Then transfer the file again.

Here i would suggest you to test the file by following command from the Note i.e

R3trans -l R3TRTABUADR6S

After that kindly share the results for same.

Regards,

Gaurav

former_member183788
Active Participant
0 Kudos

Dear Rana,

The export was successfully completed and result for R3trans -l R3TRTABUADR6S as below.

divyanshu_srivastava3
Active Contributor
0 Kudos

Hi,

What is your source and target system ?

Also your source and target database ?

Divyanshu

former_member182657
Active Contributor
0 Kudos

Hi Philip,

Kindly share the trans.log file for same.Refer SAP Note 2050 for ref


trans.log contains the content directory if no problem occurred.

If the problem results in the error message

'Constant "ENTRYSIZE" in "twtrans.c" is too short'

then it is possible that "R3trans -l ..." works although the file was destroyed.

Regards,

Gaurav

former_member183788
Active Participant
0 Kudos

Dear Rana,

Error as follows:

1 ETP199X######################################

1 ETP183 EXPORT PREPARATION

1 ETP101 transport order     : "IDEKT00005"

1 ETP102 system              : "IDE"

1 ETP108 tp path             : "tp"

1 ETP109 version and release : "380.03.41" "720"

1 ETP198

2 EPU230XExecution of the export pre-processing methods for request "IDEKT00005"

4 EPU111    on the application server: "SAP01"

4 EPU138    in client                            : "000"

2 EPU250XStart: Sorting and compressing the object list

2 EPU251 End: Sorting and compressing the object list

2 EPU244XStart: Check for existence of inactive objects

2 EPU245 End: Check for existence of inactive objects

2 EPU248XStart: Creating project information

2 EPU249 End: Creating project information

2 EPU252XStart: Writing nametab information for key entries

2 EPU253 End: Writing nametab information for key entries

2 EPU235XStart: Version creation of the objects of the request "IDEKT00005"

2 EPU236 End: Version creation of the objects of the request "IDEKT00005"

2 EPU231XStart: Adjusting the object directory for the objects of the request "IDEKT00005"

2 EPU232 End:  Adapting the object directory for the objects of the request "IDEKT00005"

2 ETN085 "Adding component vector" " " " " " "

2 ETN085 "Finished." " " " " " "

1 ETP183 EXPORT PREPARATION

1 ETP110 end date and time   : "20140627222839"

1 ETP111 exit code           : "0"

1 ETP199 ######################################

1 ETP199X######################################

1 ETP150 MAIN EXPORT

1 ETP101 transport order     : "IDEKT00005"

1 ETP102 system              : "IDE"

1 ETP108 tp path             : "tp"

1 ETP109 version and release : "380.03.41" "720"

1 ETP198

4 ETW000 R3trans.exe version 6.22 (release 720 - 03.06.11 - 17:57:00).

4 ETW000 unicode enabled version

4 ETW000 ===============================================

4 ETW000

4 ETW000 date&time   : 27.06.2014 - 22:28:43

4 ETW000 control file: \\SAP01\sapmnt\trans\tmp\IDEKKT00005.IDE

4 ETW000 > #pid 10212 on SAP01 (APServiceIDE)

4 ETW000 > export

4 ETW000 > file='\\SAP01\sapmnt\trans\data\RT00005.IDE'

4 ETW000 > client=800

4 ETW000 > buffersync=yes

4 ETW000 >

4 ETW000 > use comm 'IDEKT00005'

4 ETW000 R3trans was called as follows: R3trans.exe -u 18 -w \\SAP01\sapmnt\trans\tmp\IDEET00005.IDE \\SAP01\sapmnt\trans\tmp\IDEKKT00005.IDE

4 ETW000 active unconditional modes: 18

4 ETW000 Connected to DBMS = ORACLE --- dbs_ora_tnsname = 'IDE' --- SYSTEM = 'IDE'.

4 ETW690 COMMIT "0" "0"

4 ETW000  trace at level 1 opened for a given file pointer

4 ETW000

4 ETW000 ================== STEP 1 =====================

4 ETW000 date&time        : 27.06.2014 - 22:28:46

4 ETW000 function         : EXPORT

4 ETW000 data file        : \\SAP01\sapmnt\trans\data\RT00005.IDE

4 ETW000 buffersync       : YES

4 ETW000 client           : 800

4 ETW000 langdeletions    : YES

4 ETW000 Syslog: k CQC : rscpexcc-getSetting&                                 rscpexcc 12

4 ETW000 GetDBMigrateCodePagesLangs uses TCP0D, TCPDB, TCP0C.

4 ETW000 Language    : ABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789abcdi(),./:;& (ISO-ARHECSDEENFRELHUITJADAPLZFNLNOPTSKRUESTRFISVBGLTLVZ1SRZHTHKOROSLHRMSUKETAFISCASHIDZ2Z3Z4Z5Z6Z7Z8Z9)

4 ETW000 Compression      : L

4 ETW000 commit           : 100000

4 ETW000 table cache      : dynamic

4 ETW000

3WETW129 transport request "IDEKT00005" has trstatus "D".

3 ETW673XUse Commandfile "IDEKT00005"

4 ETW000       /* Client Export of Client-Spec. Objects */

4 ETW000       trfunction: 'M' (client transport)

4 ETW000       trstatus  : 'D'

4 ETW000       tarsystem : IDT      

4 ETW000       user      : PPHILIP

4 ETW000       date      : 27.06.2014 - 22:28:27

4 ETW000   1 entry from E070 exported (IDEKT00005          ).

4 ETW000 117 entries from E071 exported (IDEKT00005          *).

4 ETW000   1 entry from E071K exported (IDEKT00005          *).

4 ETW000   2 entries from E071KF exported (IDEKT00005          *).

4 ETW000   1 entry from E070C exported (IDEKT00005          ).

4 ETW000 185 entries from E070A exported (IDEKT00005          *).

4 ETW000   0 entries from CTS_SERIAL exported (IDEKT00005          *).

4 ETW000   1 entry from E07T exported (IDEKT00005          *).

3 ETW678Xstart export of "R3TRTABUADCPS" ...

4 ETW000 7705 entries from ADCPS exported (800).

4 ETW679 end export of "R3TRTABUADCPS".

3 ETW678Xstart export of "R3TRTABUADR10S" ...

4 ETW000   2 entries from ADR10S exported (800).

4 ETW679 end export of "R3TRTABUADR10S".

3 ETW678Xstart export of "R3TRTABUADR11S" ...

4 ETW000   0 entries from ADR11S exported (800).

4 ETW679 end export of "R3TRTABUADR11S".

3 ETW678Xstart export of "R3TRTABUADR12S" ...

4 ETW000   3 entries from ADR12S exported (800).

4 ETW679 end export of "R3TRTABUADR12S".

3 ETW678Xstart export of "R3TRTABUADR13S" ...

4 ETW000   1 entry from ADR13S exported (800).

4 ETW679 end export of "R3TRTABUADR13S".

3 ETW678Xstart export of "R3TRTABUADR2S" ...

4 ETW000 102 entries from ADR2S exported (800).

4 ETW679 end export of "R3TRTABUADR2S".

3 ETW678Xstart export of "R3TRTABUADR3S" ...

4 ETW000  28 entries from ADR3S exported (800).

4 ETW679 end export of "R3TRTABUADR3S".

3 ETW678Xstart export of "R3TRTABUADR4S" ...

4 ETW000   0 entries from ADR4S exported (800).

4 ETW679 end export of "R3TRTABUADR4S".

3 ETW678Xstart export of "R3TRTABUADR5S" ...

4 ETW000   0 entries from ADR5S exported (800).

4 ETW679 end export of "R3TRTABUADR5S".

3 ETW678Xstart export of "R3TRTABUADR6S" ...

4 ETW000 3349 entries from ADR6S exported (800).

4 ETW679 end export of "R3TRTABUADR6S".

3 ETW678Xstart export of "R3TRTABUADR7S" ...

4 ETW000 7730 entries from ADR7S exported (800).

4 ETW679 end export of "R3TRTABUADR7S".

3 ETW678Xstart export of "R3TRTABUUST12" ...

4 ETW000 211813 entries from UST12 exported (800).

4 ETW679 end export of "R3TRTABUUST12".

4 ETW000 IDEKT00005 touched.

4 ETW000 IDEKT00005 released.

4 ETW000 376585638 bytes written.

4 ETW000 Transport overhead 11.8 %.

4 ETW000 Data compressed to 28.2 %.

4 ETW000 Duration: 9:51 min (637200 bytes/sec).

4 ETW000   0 tables in P-buffer synchronized.

4 ETW000   0 tables in R-buffer synchronized.

4 ETW690 COMMIT "15232" "15408"

4 ETW000

4 ETW000 Summary:

4 ETW000

4 ETW000   1 COMML exported

4 ETW000   1 COMMT exported

4 ETW000  46 DELETE commands exported

4 ETW000 Totally 13826398 tabentries exported

4 ETW000

4 ETW000  [     dev trc,00000]  Fri Jun 27 22:38:37 2014                                             590800104  590.800104

4 ETW000  [     dev trc,00000]  Disconnecting from ALL connections:                                       33  590.800137

4 ETW000  [     dev trc,00000]  Disconnecting from connection 0 ...                                       41  590.800178

4 ETW000  [     dev trc,00000]  Closing user session (con=0, svc=0283BF70, usr=0C797A60)                2047  590.802225

4 ETW000  [     dev trc,00000]  Server handle (con=0,svchp=0283BF70,srvhp=02840D70) detached            1766  590.803991

4 ETW000  [     dev trc,00000]  Disconnected (con=0) from ORACLE.                                         67  590.804058

4 ETW000  [     dev trc,00000]  Disconnected from connection 0                                            43  590.804101

4 ETW000  [     dev trc,00000]  statistics db_con_commit (com_total=3, com_tx=3)                          34  590.804135

4 ETW000  [     dev trc,00000]  statistics db_con_rollback (roll_total=0, roll_tx=0)                      34  590.804169

4 ETW000 Disconnected from database.

4 ETW000 End of Transport (0004).

4 ETW000 date&time: 27.06.2014 - 22:38:37

4 ETW000 1 warning occured.

1 ETP150 MAIN EXPORT

1 ETP110 end date and time   : "20140627223837"

1 ETP111 exit code           : "4"

1 ETP199 ######################################

divyanshu_srivastava3
Active Contributor
0 Kudos

Hi Prathish,

Was your source system having Oracle as DB and you target system having MSSQL ?

Regards,

Divyanshu

former_member182657
Active Contributor
0 Kudos

Hi,

If possible try to upgrade the kernel version or R3trans and tp to the latest available.

Regards,

Gaurav

former_member183788
Active Participant
0 Kudos

Yes Srivastava.

divyanshu_srivastava3
Active Contributor
0 Kudos

Replace the existing tp, R3trans with the latest available version in the marketplace.


A new tp version fixes this wrong error handling. The tp versions are:

7.20 380.07.22

7.21 380.07.22

7.40 380.07.22


Regrads,

Divyanshu