Severe error(s) occurred in phase MAIN_SHDIMP/SUBMOD_SHD2_RUN/TABLECOPY_POOL2SHD_DUMP!

[Former Member]

Hi Experts,

I am working on SAP CRM 7.0 EHP 3 upgrade..I have stuck at the phase -->>Severe error(s) occurred in phase MAIN_SHDIMP/SUBMOD_SHD2_RUN/TABLECOPY_POOL2SHD_DUMP! .Here are the log files attached .Please check and help me to proceed further.

This issue has encountered due to lack of space in /usr/sap/<sid> is 100% due to which tp ended with rc=212 .Later we have requested the additional space and started but ending with below error.I suspect that tp is not able to connect the shadow instance to update the tables TCDOB and TCDOBT..

Any suggestions or resolution advises can be highly appreciated

Thanks

Naresh Gollapelly

ERROR:
Detected the following errors:

# /usr/sap/CR1/SUM/abap/log/XCNVSHDDMP.CR1:
4 ETW000 > client=all
4 ETW000 > dumping=yes
4 ETW000 > select * from "TCDOB"
4 ETW000 > select * from "TCDOBT"
4 ETW000 R3trans was called as follows: R3trans -w /usr/sap/CR1/SUM/abap/tmp/XCNVSHDDMP.CR1 /usr/sap/CR1/SUM/abap/tmp/R3SAVEX.CTL
2EETW169 no connect possible: "maybe someone set invalid values for DIR_LIBRARY ('/usr/sap/CR1/DVEBMGS00/exe') or dbms_type ('ORA')"

XCNVDUMPPOOL2SHD.ELG

[cr1adm@IGTBILSAP006 log]$ more XCNVDUMPPOOL2SHD.ELG

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
EXTERNAL CONVERSION: DUMP and RETURN CODE in XCNVSHDDMP.CR1
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
4 ETW000 > client=all
4 ETW000 > dumping=yes
4 ETW000 > select * from "TCDOB"
4 ETW000 > select * from "TCDOBT"
4 ETW000 R3trans was called as follows: R3trans -w /usr/sap/CR1/SUM/abap/tmp/XCNVSHDDMP.CR1 /usr/sap/CR1/SUM/abap/tmp/R3SAVEX.CTL
2EETW169 no connect possible: "maybe someone set invalid values for DIR_LIBRARY ('/usr/sap/CR1/DVEBMGS00/exe') or dbms_type ('ORA')"
[cr1adm@IGTBILSAP006 log]$

SLOG740 log:

URRENTPHASE MAIN_SHDIMP/SUBMOD_SHD2_RUN/TABLECOPY_POOL2SHD_DUMP
...started at 20140806074517
# Using phase log file 'XCNVDUMPPOOL2SHD.LOG'.
..finished at 20140806074519 with status ABORTED.
# Error message set: 'Single errors (code <= 😎 found in logfile 'XCNVDUMPPOOL2SHD.ELG''
...begin dialog at 20140806074531
...end dialog at 20140806074634
..answered at 20140806074634.
-> decided to try again.

CURRENTPHASE MAIN_SHDIMP/SUBMOD_SHD2_RUN/TABLECOPY_POOL2SHD_DUMP
...started at 20140806074634
# Using phase log file 'XCNVDUMPPOOL2SHD.LOG'.
..finished at 20140806074635 with status ABORTED.
# Error message set: 'Single errors (code <= 😎 found in logfile 'XCNVDUMPPOOL2SHD.ELG''
...begin dialog at 20140806074636
...end dialog at 20140806074837
..answered at 20140806074837.
-> decided to try again.

CURRENTPHASE MAIN_SHDIMP/SUBMOD_SHD2_RUN/TABLECOPY_POOL2SHD_DUMP
...started at 20140806074837
# Using phase log file 'XCNVDUMPPOOL2SHD.LOG'.
..finished at 20140806074837 with status ABORTED.
# Error message set: 'Single errors (code <= 😎 found in logfile 'XCNVDUMPPOOL2SHD.ELG''
...begin dialog at 20140806074838
...end dialog at 20140806075248
..answered at 20140806075248.
-> decided to try again.

CURRENTPHASE MAIN_SHDIMP/SUBMOD_SHD2_RUN/TABLECOPY_POOL2SHD_DUMP
...started at 20140806075248
# Using phase log file 'XCNVDUMPPOOL2SHD.LOG'.
..finished at 20140806075248 with status ABORTED.
# Error message set: 'Single errors (code <= 😎 found in logfile 'XCNVDUMPPOOL2SHD.ELG''
...begin dialog at 20140806075250
...end dialog at 20140806080209
..answered at 20140806080209.
-> decided to try again.

CURRENTPHASE MAIN_SHDIMP/SUBMOD_SHD2_RUN/TABLECOPY_POOL2SHD_DUMP
...started at 20140806080209
# Using phase log file 'XCNVDUMPPOOL2SHD.LOG'.
..finished at 20140806080209 with status ABORTED.
# Error message set: 'Single errors (code <= 😎 found in logfile 'XCNVDUMPPOOL2SHD.ELG''
...begin dialog at 20140806080210
...end dialog at 20140806080739
..answered at 20140806080739.
-> decided to try again.

CURRENTPHASE MAIN_SHDIMP/SUBMOD_SHD2_RUN/TABLECOPY_POOL2SHD_DUMP
...started at 20140806080739
# Using phase log file 'XCNVDUMPPOOL2SHD.LOG'.
..finished at 20140806080739 with status ABORTED.
# Error message set: 'Single errors (code <= 😎 found in logfile 'XCNVDUMPPOOL2SHD.ELG''
...begin dialog at 20140806080740
...end dialog at 20140806085432
..answered at 20140806085432.
-> decided to try again.

[Reagan · Accepted solution]

Check the Oracle database alert log for any errors. If there are no errors and if there is enough space in the upgrade directory then do a restart of the SUM tool.

Regards

RB

[Former Member · Accepted solution]

Hi RB,

Thanks for your reply..

I have checked already alert<SID>.log file /oracle/<SID>/saptrace/diag/rdbms/<sid>/<SID>/trace for any DB related but could not find any errors and also restarted the shadow instance and SUM but no luck..

SUM reporting immidiately after  i restart it  now with below error

ERROR:
Detected the following errors:

# /usr/sap/CR1/SUM/abap/log/XCNVSHDDMP.CR1:
4 ETW000 > client=all
4 ETW000 > dumping=yes
4 ETW000 > select * from "TCDOB"
4 ETW000 > select * from "TCDOBT"
4 ETW000 R3trans was called as follows: R3trans -w /usr/sap/CR1/SUM/abap/tmp/XCNVSHDDMP.CR1 /usr/sap/CR1/SUM/abap/tmp/R3SAVEX.CTL
2EETW169 no connect possible: "maybe someone set invalid values for DIR_LIBRARY ('/usr/sap/CR1/DVEBMGS00/exe') or dbms_type ('ORA')"

[Reagan · Accepted solution]

What does the log file XCNVDUMPPOOL2SHD.ELG say ?

Also provide the list of last 20 log files.

ls -latr /usr/sap/CR1/SUM/abap/log | tail -20

[Former Member · Accepted solution]

Hello Reagan,

As requested I have attached the latest logs. Please have a look and suggest.

Thanks

Naresh

Last 20 upgrade logs.txt.zip

[Reagan · Accepted solution]

Naresh,

Could you supply these log files ?

XCNVDUMPPOOL2SHD.LOG

XCNVDUMPPOOL2SHD.ELG

R3trans.out

Regards

RB

[Former Member · Accepted solution]

Hi RB,

Please find the below log files .Please check and help us

And one thing i would like to share that we have tried replaceing /usr/sap/CR1/DVEBMGS00/exe/ with /usr/sap/CR1/SUM/abap/exe in the below command then R3trans -d results 0000.

[cr1adm@IGTBILSAP006 exe]$ /usr/sap/CR1/SUM/abap/exe/R3trans -w /usr/sap/CR1/SUM/abap/tmp/XCNVSHDDMP.CR1 /usr/sap/CR1/SUM/abap/tmp/R3SAVEX.CTL

This is /usr/sap/CR1/SUM/abap/exe/R3trans version 6.24 (release 741 - 10.06.14 - 20:14:07).

unicode enabled version

/usr/sap/CR1/SUM/abap/exe/R3trans finished (0000).

but SUM by default taking as below and resulting 0012.Please advise where should we update the environment with /usr/sap/CR1/SUM/abap/exe/ to read the SUM  to result 0000

/usr/sap/CR1/DVEBMGS00/exe/R3trans -w /usr/sap/CR1/SUM/abap/tmp/XCNVSHDDMP.CR1 /usr/sap/CR1/SUM/abap/tmp/R3SAVEX.CTL

EXECUTING /usr/sap/CR1/DVEBMGS00/exe/R3trans -w /usr/sap/CR1/SUM/abap/tmp/XCNVSHDDMP.CR1 /usr/sap/CR1/SUM/abap/tmp/R3SAVEX.CTL

This is R3trans version 6.24 (release 741 - 10.06.14 - 20:14:07).

unicode enabled version

2EETW169 no connect possible: "maybe someone set invalid values for DIR_LIBRARY ('/usr/sap/CR1/DVEBMGS00/exe') or dbms_type ('ORA')"

R3trans finished (0012).

SAPup> Process with PID 39835 terminated with status 12 at 20140808054640!

XCNVDUMPPOOL2SHD.LOG

XCNVDUMPPOOL2SHD.ELG

R3trans.out:

  ENV: SAPDATA_HOME=/oracle/CR1
    ENV: SAPSYSTEMNAME=CR1
    ENV: dbms_type=ORA
    ENV: dbs_ora_schema=SAPSR3
    ENV: dbs_ora_tnsname=CR1

EXECUTING /usr/sap/CR1/DVEBMGS00/exe/R3trans -w /usr/sap/CR1/SUM/abap/tmp/XCNVSHDDMP.CR1 /usr/sap/CR1/SUM/abap/tmp/R3SAVEX.CTL
This is R3trans version 6.24 (release 741 - 10.06.14 - 20:14:07).
unicode enabled version
2EETW169 no connect possible: "maybe someone set invalid values for DIR_LIBRARY ('/usr/sap/CR1/DVEBMGS00/exe') or dbms_type ('ORA')"
R3trans finished (0012).
SAPup> Process with PID 36057 terminated with status 12 at 20140807153321!
SAPup> Starting subprocess with PID 36135 in phase 'TABLECOPY_POOL2SHD_DUMP' at 20140807154817
    ENV: DIR_LIBRARY=/usr/sap/CR1/DVEBMGS00/exe
    ENV: LD_LIBRARY_PATH=/usr/sap/CR1/DVEBMGS00/exe:/usr/sap/CR1/SUM/jvm/jre/lib/amd64/server:/usr/sap/CR1/SUM/jvm/jre/lib/amd64:/usr/sap/CR1/SUM/jvm/jre/../lib/amd64:/usr/sap/CR1/SYS/exe/run:/oracle/client/11x_64/instantclient
    ENV: NLS_LANG=AMERICAN_AMERICA.UTF8
    ENV: ORACLE_BASE=/oracle
    ENV: ORACLE_HOME=/oracle/CR1/11204
    ENV: ORACLE_SID=CR1
    ENV: PATH=/usr/sap/CR1/DVEBMGS00/exe:/usr/lib64/qt-3.3/bin:/usr/local/bin:/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/sbin:/home/cr1adm/bin:/usr/sap/CR1/SYS/exe/run
    ENV: SAPDATA_HOME=/oracle/CR1
    ENV: SAPSYSTEMNAME=CR1
    ENV: dbms_type=ORA
    ENV: dbs_ora_schema=SAPSR3
    ENV: dbs_ora_tnsname=CR1

EXECUTING /usr/sap/CR1/DVEBMGS00/exe/R3trans -w /usr/sap/CR1/SUM/abap/tmp/XCNVSHDDMP.CR1 /usr/sap/CR1/SUM/abap/tmp/R3SAVEX.CTL
This is R3trans version 6.24 (release 741 - 10.06.14 - 20:14:07).
unicode enabled version
2EETW169 no connect possible: "maybe someone set invalid values for DIR_LIBRARY ('/usr/sap/CR1/DVEBMGS00/exe') or dbms_type ('ORA')"
R3trans finished (0012).
SAPup> Process with PID 36135 terminated with status 12 at 20140807154817!
SAPup> Starting subprocess with PID 39328 in phase 'TABLECOPY_POOL2SHD_DUMP' at 20140808043643
    ENV: DIR_LIBRARY=/usr/sap/CR1/DVEBMGS00/exe
    ENV: LD_LIBRARY_PATH=/usr/sap/CR1/DVEBMGS00/exe:/usr/sap/CR1/SUM/jvm/jre/lib/amd64/server:/usr/sap/CR1/SUM/jvm/jre/lib/amd64:/usr/sap/CR1/SUM/jvm/jre/../lib/amd64:/usr/sap/CR1/SYS/exe/run:/oracle/client/11x_64/instantclient
    ENV: NLS_LANG=AMERICAN_AMERICA.UTF8
    ENV: ORACLE_BASE=/oracle
    ENV: ORACLE_HOME=/oracle/CR1/11204
    ENV: ORACLE_SID=CR1
    ENV: PATH=/usr/sap/CR1/DVEBMGS00/exe:/usr/lib64/qt-3.3/bin:/usr/local/bin:/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/sbin:/home/cr1adm/bin:/usr/sap/CR1/SYS/exe/run
    ENV: SAPDATA_HOME=/oracle/CR1
    ENV: SAPSYSTEMNAME=CR1
    ENV: dbms_type=ORA
    ENV: dbs_ora_schema=SAPSR3
    ENV: dbs_ora_tnsname=CR1

EXECUTING /usr/sap/CR1/DVEBMGS00/exe/R3trans -w /usr/sap/CR1/SUM/abap/tmp/XCNVSHDDMP.CR1 /usr/sap/CR1/SUM/abap/tmp/R3SAVEX.CTL
This is R3trans version 6.24 (release 741 - 10.06.14 - 20:14:07).
unicode enabled version
2EETW169 no connect possible: "maybe someone set invalid values for DIR_LIBRARY ('/usr/sap/CR1/DVEBMGS00/exe') or dbms_type ('ORA')"
R3trans finished (0012).
SAPup> Process with PID 39328 terminated with status 12 at 20140808043643!
SAPup> Starting subprocess with PID 39426 in phase 'TABLECOPY_POOL2SHD_DUMP' at 20140808045522
    ENV: DIR_LIBRARY=/usr/sap/CR1/DVEBMGS00/exe
    ENV: LD_LIBRARY_PATH=/usr/sap/CR1/DVEBMGS00/exe:/usr/sap/CR1/SUM/jvm/jre/lib/amd64/server:/usr/sap/CR1/SUM/jvm/jre/lib/amd64:/usr/sap/CR1/SUM/jvm/jre/../lib/amd64:/usr/sap/CR1/SYS/exe/run:/oracle/client/11x_64/instantclient
    ENV: NLS_LANG=AMERICAN_AMERICA.UTF8
    ENV: ORACLE_BASE=/oracle
    ENV: ORACLE_HOME=/oracle/CR1/11204
    ENV: ORACLE_SID=CR1
    ENV: PATH=/usr/sap/CR1/DVEBMGS00/exe:/usr/lib64/qt-3.3/bin:/usr/local/bin:/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/sbin:/home/cr1adm/bin:/usr/sap/CR1/SYS/exe/run
    ENV: SAPDATA_HOME=/oracle/CR1
    ENV: SAPSYSTEMNAME=CR1
    ENV: dbms_type=ORA
    ENV: dbs_ora_schema=SAPSR3
    ENV: dbs_ora_tnsname=CR1

EXECUTING /usr/sap/CR1/DVEBMGS00/exe/R3trans -w /usr/sap/CR1/SUM/abap/tmp/XCNVSHDDMP.CR1 /usr/sap/CR1/SUM/abap/tmp/R3SAVEX.CTL
This is R3trans version 6.24 (release 741 - 10.06.14 - 20:14:07).
unicode enabled version
2EETW169 no connect possible: "maybe someone set invalid values for DIR_LIBRARY ('/usr/sap/CR1/DVEBMGS00/exe') or dbms_type ('ORA')"
R3trans finished (0012).
SAPup> Process with PID 39426 terminated with status 12 at 20140808045522!
SAPup> Starting subprocess with PID 39450 in phase 'TABLECOPY_POOL2SHD_DUMP' at 20140808045858
    ENV: DIR_LIBRARY=/usr/sap/CR1/DVEBMGS00/exe
    ENV: LD_LIBRARY_PATH=/usr/sap/CR1/DVEBMGS00/exe:/usr/sap/CR1/SUM/jvm/jre/lib/amd64/server:/usr/sap/CR1/SUM/jvm/jre/lib/amd64:/usr/sap/CR1/SUM/jvm/jre/../lib/amd64:/usr/sap/CR1/SYS/exe/run:/oracle/client/11x_64/instantclient
    ENV: NLS_LANG=AMERICAN_AMERICA.UTF8
    ENV: ORACLE_BASE=/oracle
    ENV: ORACLE_HOME=/oracle/CR1/11204
    ENV: ORACLE_SID=CR1
    ENV: PATH=/usr/sap/CR1/DVEBMGS00/exe:/usr/lib64/qt-3.3/bin:/usr/local/bin:/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/sbin:/home/cr1adm/bin:/usr/sap/CR1/SYS/exe/run
    ENV: SAPDATA_HOME=/oracle/CR1
    ENV: SAPSYSTEMNAME=CR1
    ENV: dbms_type=ORA
    ENV: dbs_ora_schema=SAPSR3
    ENV: dbs_ora_tnsname=CR1

EXECUTING /usr/sap/CR1/DVEBMGS00/exe/R3trans -w /usr/sap/CR1/SUM/abap/tmp/XCNVSHDDMP.CR1 /usr/sap/CR1/SUM/abap/tmp/R3SAVEX.CTL
This is R3trans version 6.24 (release 741 - 10.06.14 - 20:14:07).
unicode enabled version
2EETW169 no connect possible: "maybe someone set invalid values for DIR_LIBRARY ('/usr/sap/CR1/DVEBMGS00/exe') or dbms_type ('ORA')"
R3trans finished (0012).
SAPup> Process with PID 39450 terminated with status 12 at 20140808045858!
SAPup> Starting subprocess with PID 39583 in phase 'TABLECOPY_POOL2SHD_DUMP' at 20140808050200
    ENV: DIR_LIBRARY=/usr/sap/CR1/DVEBMGS00/exe
    ENV: LD_LIBRARY_PATH=/usr/sap/CR1/DVEBMGS00/exe:/usr/sap/CR1/SUM/jvm/jre/lib/amd64/server:/usr/sap/CR1/SUM/jvm/jre/lib/amd64:/usr/sap/CR1/SUM/jvm/jre/../lib/amd64:/usr/sap/CR1/SYS/exe/run:/oracle/client/11x_64/instantclient
    ENV: NLS_LANG=AMERICAN_AMERICA.UTF8
    ENV: ORACLE_BASE=/oracle
    ENV: ORACLE_HOME=/oracle/CR1/11204
    ENV: ORACLE_SID=CR1
    ENV: PATH=/usr/sap/CR1/DVEBMGS00/exe:/usr/lib64/qt-3.3/bin:/usr/local/bin:/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/sbin:/home/cr1adm/bin:/usr/sap/CR1/SYS/exe/run
    ENV: SAPDATA_HOME=/oracle/CR1
    ENV: SAPSYSTEMNAME=CR1
    ENV: dbms_type=ORA
    ENV: dbs_ora_schema=SAPSR3
    ENV: dbs_ora_tnsname=CR1

EXECUTING /usr/sap/CR1/DVEBMGS00/exe/R3trans -w /usr/sap/CR1/SUM/abap/tmp/XCNVSHDDMP.CR1 /usr/sap/CR1/SUM/abap/tmp/R3SAVEX.CTL
This is R3trans version 6.24 (release 741 - 10.06.14 - 20:14:07).
unicode enabled version
2EETW169 no connect possible: "maybe someone set invalid values for DIR_LIBRARY ('/usr/sap/CR1/DVEBMGS00/exe') or dbms_type ('ORA')"
R3trans finished (0012).
SAPup> Process with PID 39583 terminated with status 12 at 20140808050200!
SAPup> Starting subprocess with PID 39673 in phase 'TABLECOPY_POOL2SHD_DUMP' at 20140808051809
    ENV: DIR_LIBRARY=/usr/sap/CR1/DVEBMGS00/exe
    ENV: LD_LIBRARY_PATH=/usr/sap/CR1/DVEBMGS00/exe:/usr/sap/CR1/SUM/jvm/jre/lib/amd64/server:/usr/sap/CR1/SUM/jvm/jre/lib/amd64:/usr/sap/CR1/SUM/jvm/jre/../lib/amd64:/usr/sap/CR1/SYS/exe/run:/oracle/client/11x_64/instantclient
    ENV: NLS_LANG=AMERICAN_AMERICA.UTF8
    ENV: ORACLE_BASE=/oracle
    ENV: ORACLE_HOME=/oracle/CR1/11204
    ENV: ORACLE_SID=CR1
    ENV: PATH=/usr/sap/CR1/DVEBMGS00/exe:/usr/lib64/qt-3.3/bin:/usr/local/bin:/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/sbin:/home/cr1adm/bin:/usr/sap/CR1/SYS/exe/run
    ENV: SAPDATA_HOME=/oracle/CR1
    ENV: SAPSYSTEMNAME=CR1
    ENV: dbms_type=ORA
    ENV: dbs_ora_schema=SAPSR3
    ENV: dbs_ora_tnsname=CR1

EXECUTING /usr/sap/CR1/DVEBMGS00/exe/R3trans -w /usr/sap/CR1/SUM/abap/tmp/XCNVSHDDMP.CR1 /usr/sap/CR1/SUM/abap/tmp/R3SAVEX.CTL
This is R3trans version 6.24 (release 741 - 10.06.14 - 20:14:07).
unicode enabled version
2EETW169 no connect possible: "maybe someone set invalid values for DIR_LIBRARY ('/usr/sap/CR1/DVEBMGS00/exe') or dbms_type ('ORA')"
R3trans finished (0012).
SAPup> Process with PID 39673 terminated with status 12 at 20140808051809!
SAPup> Starting subprocess with PID 39737 in phase 'TABLECOPY_POOL2SHD_DUMP' at 20140808052917
    ENV: DIR_LIBRARY=/usr/sap/CR1/DVEBMGS00/exe
    ENV: LD_LIBRARY_PATH=/usr/sap/CR1/DVEBMGS00/exe:/usr/sap/CR1/SUM/jvm/jre/lib/amd64/server:/usr/sap/CR1/SUM/jvm/jre/lib/amd64:/usr/sap/CR1/SUM/jvm/jre/../lib/amd64:/usr/sap/CR1/SYS/exe/run:/oracle/client/11x_64/instantclient
    ENV: NLS_LANG=AMERICAN_AMERICA.UTF8
    ENV: ORACLE_BASE=/oracle
    ENV: ORACLE_HOME=/oracle/CR1/11204
    ENV: ORACLE_SID=CR1
    ENV: PATH=/usr/sap/CR1/DVEBMGS00/exe:/usr/lib64/qt-3.3/bin:/usr/local/bin:/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/sbin:/home/cr1adm/bin:/usr/sap/CR1/SYS/exe/run
    ENV: SAPDATA_HOME=/oracle/CR1
    ENV: SAPSYSTEMNAME=CR1
    ENV: dbms_type=ORA
    ENV: dbs_ora_schema=SAPSR3
    ENV: dbs_ora_tnsname=CR1

EXECUTING /usr/sap/CR1/DVEBMGS00/exe/R3trans -w /usr/sap/CR1/SUM/abap/tmp/XCNVSHDDMP.CR1 /usr/sap/CR1/SUM/abap/tmp/R3SAVEX.CTL
This is R3trans version 6.24 (release 741 - 10.06.14 - 20:14:07).
unicode enabled version
2EETW169 no connect possible: "maybe someone set invalid values for DIR_LIBRARY ('/usr/sap/CR1/DVEBMGS00/exe') or dbms_type ('ORA')"
R3trans finished (0012).
SAPup> Process with PID 39737 terminated with status 12 at 20140808052917!
SAPup> Starting subprocess with PID 39783 in phase 'TABLECOPY_POOL2SHD_DUMP' at 20140808053638
    ENV: DIR_LIBRARY=/usr/sap/CR1/DVEBMGS00/exe
    ENV: LD_LIBRARY_PATH=/usr/sap/CR1/DVEBMGS00/exe:/usr/sap/CR1/SUM/jvm/jre/lib/amd64/server:/usr/sap/CR1/SUM/jvm/jre/lib/amd64:/usr/sap/CR1/SUM/jvm/jre/../lib/amd64:/usr/sap/CR1/SYS/exe/run:/oracle/client/11x_64/instantclient
    ENV: NLS_LANG=AMERICAN_AMERICA.UTF8
    ENV: ORACLE_BASE=/oracle
    ENV: ORACLE_HOME=/oracle/CR1/11204
    ENV: ORACLE_SID=CR1
    ENV: PATH=/usr/sap/CR1/DVEBMGS00/exe:/usr/lib64/qt-3.3/bin:/usr/local/bin:/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/sbin:/home/cr1adm/bin:/usr/sap/CR1/SYS/exe/run
    ENV: SAPDATA_HOME=/oracle/CR1
    ENV: SAPSYSTEMNAME=CR1
    ENV: dbms_type=ORA
    ENV: dbs_ora_schema=SAPSR3
    ENV: dbs_ora_tnsname=CR1

EXECUTING /usr/sap/CR1/DVEBMGS00/exe/R3trans -w /usr/sap/CR1/SUM/abap/tmp/XCNVSHDDMP.CR1 /usr/sap/CR1/SUM/abap/tmp/R3SAVEX.CTL
This is R3trans version 6.24 (release 741 - 10.06.14 - 20:14:07).
unicode enabled version
2EETW169 no connect possible: "maybe someone set invalid values for DIR_LIBRARY ('/usr/sap/CR1/DVEBMGS00/exe') or dbms_type ('ORA')"
R3trans finished (0012).
SAPup> Process with PID 39783 terminated with status 12 at 20140808053638!
SAPup> Starting subprocess with PID 39835 in phase 'TABLECOPY_POOL2SHD_DUMP' at 20140808054640
    ENV: DIR_LIBRARY=/usr/sap/CR1/DVEBMGS00/exe
    ENV: LD_LIBRARY_PATH=/usr/sap/CR1/DVEBMGS00/exe:/usr/sap/CR1/SUM/jvm/jre/lib/amd64/server:/usr/sap/CR1/SUM/jvm/jre/lib/amd64:/usr/sap/CR1/SUM/jvm/jre/../lib/amd64:/usr/sap/CR1/SYS/exe/run:/oracle/client/11x_64/instantclient
    ENV: NLS_LANG=AMERICAN_AMERICA.UTF8
    ENV: ORACLE_BASE=/oracle
    ENV: ORACLE_HOME=/oracle/CR1/11204
    ENV: ORACLE_SID=CR1
    ENV: PATH=/usr/sap/CR1/DVEBMGS00/exe:/usr/lib64/qt-3.3/bin:/usr/local/bin:/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/sbin:/home/cr1adm/bin:/usr/sap/CR1/SYS/exe/run
    ENV: SAPDATA_HOME=/oracle/CR1
    ENV: SAPSYSTEMNAME=CR1
    ENV: dbms_type=ORA
    ENV: dbs_ora_schema=SAPSR3
    ENV: dbs_ora_tnsname=CR1

EXECUTING /usr/sap/CR1/DVEBMGS00/exe/R3trans -w /usr/sap/CR1/SUM/abap/tmp/XCNVSHDDMP.CR1 /usr/sap/CR1/SUM/abap/tmp/R3SAVEX.CTL
This is R3trans version 6.24 (release 741 - 10.06.14 - 20:14:07).
unicode enabled version
2EETW169 no connect possible: "maybe someone set invalid values for DIR_LIBRARY ('/usr/sap/CR1/DVEBMGS00/exe') or dbms_type ('ORA')"
R3trans finished (0012).
SAPup> Process with PID 39835 terminated with status 12 at 20140808054640!
SAPup> Starting subprocess with PID 40294 in phase 'TABLECOPY_POOL2SHD_DUMP' at 20140808061908
    ENV: DIR_LIBRARY=/usr/sap/CR1/DVEBMGS00/exe
    ENV: LD_LIBRARY_PATH=/usr/sap/CR1/DVEBMGS00/exe:/usr/sap/CR1/SUM/jvm/jre/lib/amd64/server:/usr/sap/CR1/SUM/jvm/jre/lib/amd64:/usr/sap/CR1/SUM/jvm/jre/../lib/amd64:/usr/sap/CR1/SYS/exe/run:/oracle/client/11x_64/instantclient
    ENV: NLS_LANG=AMERICAN_AMERICA.UTF8
    ENV: ORACLE_BASE=/oracle
    ENV: ORACLE_HOME=/oracle/CR1/11204
    ENV: ORACLE_SID=CR1
    ENV: PATH=/usr/sap/CR1/DVEBMGS00/exe:/usr/lib64/qt-3.3/bin:/usr/local/bin:/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/sbin:/home/cr1adm/bin:/usr/sap/CR1/SYS/exe/run
    ENV: SAPDATA_HOME=/oracle/CR1
    ENV: SAPSYSTEMNAME=CR1
    ENV: dbms_type=ORA
    ENV: dbs_ora_schema=SAPSR3
    ENV: dbs_ora_tnsname=CR1

EXECUTING /usr/sap/CR1/DVEBMGS00/exe/R3trans -w /usr/sap/CR1/SUM/abap/tmp/XCNVSHDDMP.CR1 /usr/sap/CR1/SUM/abap/tmp/R3SAVEX.CTL
This is R3trans version 6.24 (release 741 - 10.06.14 - 20:14:07).
unicode enabled version
2EETW169 no connect possible: "maybe someone set invalid values for DIR_LIBRARY ('/usr/sap/CR1/DVEBMGS00/exe') or dbms_type ('ORA')"
R3trans finished (0012).
SAPup> Process with PID 40294 terminated with status 12 at 20140808061908!
SAPup> Starting subprocess with PID 40346 in phase 'TABLECOPY_POOL2SHD_DUMP' at 20140808062951
    ENV: DIR_LIBRARY=/usr/sap/CR1/DVEBMGS00/exe
    ENV: LD_LIBRARY_PATH=/usr/sap/CR1/DVEBMGS00/exe:/usr/sap/CR1/SUM/jvm/jre/lib/amd64/server:/usr/sap/CR1/SUM/jvm/jre/lib/amd64:/usr/sap/CR1/SUM/jvm/jre/../lib/amd64:/usr/sap/CR1/SYS/exe/run:/oracle/client/11x_64/instantclient
    ENV: NLS_LANG=AMERICAN_AMERICA.UTF8
    ENV: ORACLE_BASE=/oracle
    ENV: ORACLE_HOME=/oracle/CR1/11204
    ENV: ORACLE_SID=CR1
    ENV: PATH=/usr/sap/CR1/DVEBMGS00/exe:/usr/lib64/qt-3.3/bin:/usr/local/bin:/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/sbin:/home/cr1adm/bin:/usr/sap/CR1/SYS/exe/run
    ENV: SAPDATA_HOME=/oracle/CR1
    ENV: SAPSYSTEMNAME=CR1
    ENV: dbms_type=ORA
    ENV: dbs_ora_schema=SAPSR3
    ENV: dbs_ora_tnsname=CR1

EXECUTING /usr/sap/CR1/DVEBMGS00/exe/R3trans -w /usr/sap/CR1/SUM/abap/tmp/XCNVSHDDMP.CR1 /usr/sap/CR1/SUM/abap/tmp/R3SAVEX.CTL
This is R3trans version 6.24 (release 741 - 10.06.14 - 20:14:07).
unicode enabled version
2EETW169 no connect possible: "maybe someone set invalid values for DIR_LIBRARY ('/usr/sap/CR1/DVEBMGS00/exe') or dbms_type ('ORA')"
R3trans finished (0012).
SAPup> Process with PID 40346 terminated with status 12 at 20140808062951!
[cr1adm@IGTBILSAP006 tmp]$

XCNVDUMPPOOL2SHD.ELG

[cr1adm@IGTBILSAP006 log]$ more XCNVDUMPPOOL2SHD.ELG

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
EXTERNAL CONVERSION: DUMP and RETURN CODE in XCNVSHDDMP.CR1
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
4 ETW000 > client=all
4 ETW000 > dumping=yes
4 ETW000 > select * from "TCDOB"
4 ETW000 > select * from "TCDOBT"
4 ETW000 R3trans was called as follows: R3trans -w /usr/sap/CR1/SUM/abap/tmp/XCNVSHDDMP.CR1 /usr/sap/CR1/SUM/abap/tmp/R3SAVEX.CTL
2EETW169 no connect possible: "maybe someone set invalid values for DIR_LIBRARY ('/usr/sap/CR1/DVEBMGS00/exe') or dbms_type ('ORA')"
[cr1adm@IGTBILSAP006 log]$

XCNVDUMPPOOL2SHD.LOG

[cr1adm@IGTBILSAP006 log]$ tail -500 XCNVDUMPPOOL2SHD.LOG

1 ETQ201 Entering upgrade-phase "MAIN_SHDIMP/SUBMOD_SHD2_RUN/TABLECOPY_POOL2SHD_DUMP" ("20140808062951")

2 ETQ367 Connect variables are set for standard instance access

4 ETQ399 System-nr = '00', GwService = 'sapgw00' Client = '000'

4 ETQ399 Environment variables:

4 ETQ399   dbs_ora_schema=SAPSR3

4 ETQ399   auth_shadow_upgrade=<null>

1 ETQ200 Executing actual phase 'MAIN_SHDIMP/SUBMOD_SHD2_RUN/TABLECOPY_POOL2SHD_DUMP'.

1 ETQ399 Phase arguments:

2 ETQ399 Arg[0] = 'DUMP'

2 ETQ399 Arg[1] = 'SHADOW'

2 ETQ399 Arg[2] = 'POOL2SHD'

2 ETQ399 Arg[3] = 'XCNVPOOL2SHD.SAP'

1 ETQ399 Using error summary log 'XCNVDUMPPOOL2SHD.ELG'.

2 ETQ399 Phase XCNV is called in mode DUMP for shadow tables.

4 ETQ399 Mapping SCR class 'POOL2SHD' to actual condition.

3 ETQ399 Selecting from 'PUTTB_SHD' with condition '( INITFILL == "X" AND SRCTYPE == "T" AND SRCFORM == "P" AND DSTTYPE == "T" AND DSTFORM == "P" )'.

4 ETQ601    - Table "TCDOB"

4 ETQ601    - Table "TCDOBT"

3 ETQ399 2 entries matched.

3 ETQ399 Creating R3trans control file '/usr/sap/CR1/SUM/abap/tmp/R3SAVEX.CTL':

4 ETQ399 >>> export

4 ETQ399 >>> file='/usr/sap/CR1/SUM/abap/data/XCNVPOOL2SHD.SAP'

4 ETQ399 >>> client=all

4 ETQ399 >>> dumping=yes

4 ETQ399 >>> select * from "TCDOB"

4 ETQ399 >>> select * from "TCDOBT"

3 ETQ120 20140808062951: PID 40346 execute '/usr/sap/CR1/DVEBMGS00/exe/R3trans -w /usr/sap/CR1/SUM/abap/tmp/XCNVSHDDMP.CR1 /usr/sap/CR1/SUM/abap/tmp/R3SAVEX.CTL', output written to '/usr/sap/CR1/SUM/abap/tmp/R3trans.out'.

3 ETQ122 20140808062951: PID 40346 exited with status 12 (time: 0.000/0.007/0.010 real/usr/sys)

1 ETQ124 Scanned file 'log/XCNVSHDDMP.CR1' from offset 5894 to 6622 for errors.

1EETQ399 Last error code set is: Single errors (code <= 😎 found in logfile 'XCNVDUMPPOOL2SHD.ELG'

1EETQ204 Upgrade phase "TABLECOPY_POOL2SHD_DUMP" aborted with severe errors ("20140808062951")

[cr1adm@IGTBILSAP006 log]$

[Former Member · Accepted solution]

Thanks for inputs...I resolved this issue from my end and upgrade went well

[Former Member · Accepted solution]

I have identified that there was 740 R3trans execuatble in usr/sap/<sid>/DV*/exe and the same was there in /usr/sap/<sid>/SUM/abap/exe so that SUM was reading  the executable from usr/sap/<sid>/DV*/exe instead of usr/sap/<sid>/DV*/exe..

So i have replaced the R3trans 741 executable version with R3trans 721 exwecutable in the kernel

usr/sap/<sid>/DV*/exe..then it worked..

Thanks

Naresh

[Former Member · Accepted solution]

I have identified that there was 740 R3trans execuatble in usr/sap/<sid>/DV*/exe and the same was there in /usr/sap/<sid>/SUM/abap/exe so that SUM was reading  the executable from usr/sap/<sid>/DV*/exe instead of usr/sap/<sid>/SUM/abap/exe..

So i have replaced the R3trans 741 executable version with R3trans 721 exwecutable in the kernel

usr/sap/<sid>/DV*/exe.. and continued the upgrade and then it worked..

Thanks

Naresh