Skip to Content
0
Former Member
May 10, 2016 at 09:25 AM

Error in phase TP_ACTION_CP2STRIG: SQL0010N

105 Views

Hi all

We hit some issues during the downtime phase of SUM with SPS patching due to a mismatch of physical and virtual host names. This was corrected but SUM crashed, so we had to restart the system.

Unfortunately now we are getting the following error:

SAPup> Starting subprocess with PID 10823 in phase 'TP_ACTION_CP2STRIG' at 20160509163849

ENV: CLASSPATH=:/db2/db2qs0/sqllib/java/db2java.zip:/db2/db2qs0/sqllib/java/runtime.zip:.:/db2/db2qs0/sqllib/java/db2java.zip:/db2/db2qs0/sqllib/java/runtime.zip:.

ENV: DB2DBDFT=QS0

ENV: DB2INSTANCE=db2qs0

ENV: DIR_LIBRARY=/SPS_Upgrade/QS0/SUM/abap/exe

ENV: LD_LIBRARY_PATH=/SPS_Upgrade/QS0/SUM/abap/exe:/usr/sap/QS0/SYS/exe/run:/usr/sap/QS0/SYS/exe/uc/linuxx86_64

ENV: PATH=/SPS_Upgrade/QS0/SUM/abap/exe:/usr/lib64/qt-3.3/bin:/usr/local/bin:/bin:/usr/bin:/usr/sap/QS0/SYS/exe/uc/linuxx86_64:/usr/sap/QS0/SYS/exe/run:/home/qs0adm:.:/db2/db

2qs0/sqllib/bin:/db2/db2qs0/sqllib/adm:/db2/db2qs0/sqllib/misc

ENV: SAPSYSTEMNAME=QS0

ENV: dbms_type=db6

ENV: dbs_db6_schema=SAPQS0

PWD: /SPS_Upgrade/QS0/SUM/abap/tmp

EXECUTING /SPS_Upgrade/QS0/SUM/abap/exe/tp pf=/SPS_Upgrade/QS0/SUM/abap/var/CP2SHDT.TPP r3e SAPKBBO731 -s QS0 u8

This is tp version 380.29.44 (release 721, unicode enabled)

This is /SPS_Upgrade/QS0/SUM/abap/exe/R3trans version 6.24 (release 721 - 01.04.15 - 20:15:04).

unicode enabled version

2EETW000 sap_dext called with msgnr "1":

2EETW000 ---- db call info ----

2EETW000 function: db_ntab (shadow)

2EETW000 fcode: NT_RDTDESCR

2EETW000 tabname: E070~

2EETW000 len (char): 5

2EETW000 key: E070~

2EETW000 retcode: 1

2EETW000 sql error: -10 SQL0010N The string constant beginning with ""XXXXT WITH CS -- OPTLEVEL( 5 ) -- QUERY_DEGREE" does not have an ending string deli

miter. SQLSTATE=42603

2EETW125 SQL error "-10" during "" access: "SQL0010N The string constant beginning with ""XXXXT WITH CS -- OPTLEVEL( 5 ) -- QUERY_DEGREE" does not have an

ending string delimiter. SQLSTATE=42603"

/SPS_Upgrade/QS0/SUM/abap/exe/R3trans finished (0012).

INFO: No client specified on command line. Taking client 0 from E070C.

tp finished with return code: 12

meaning:

A tool used by tp aborted

SAPup> Process with PID 10823 terminated with status 12 at 20160509163851!

If we look in CP2SHDR.ELG it repeats the following:

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

COPY TO SHADOW and RETURN CODE in SAPEBBO731.QS0

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

4 ETW000 [ dbntab ,00000] ***LOG BY0=>SQL0010N The string constant beginning with ""XXXXT WITH CS -- OPTLEVEL( 5 ) -- QUERY_DEGREE" does not have an

ending string delimiter. SQLSTATE=42603

4 ETW000 11 0.074003

4 ETW000 [ dev trc,00000] NTAB: db_ntab(): NT_RDTDESCR: tabname: E070~ , fieldname: , fieldnumber: 0

4 ETW000 9 0.074012

4 ETW000 [ dev trc,00000] NTAB: db_ntab(): procure_2 failed, returning 1 5 0.074017

2EETW000 sap_dext called with msgnr "1":

2EETW000 ---- db call info ----

2EETW000 function: db_ntab (shadow)

2EETW000 fcode: NT_RDTDESCR

2EETW000 tabname: E070~

2EETW000 len (char): 5

2EETW000 key: E070~

2EETW000 retcode: 1

2EETW000 sql error: -10 SQL0010N The string constant beginning with ""XXXXT WITH CS -- OPTLEVEL( 5 ) -- QUERY_DEGREE" does not have an ending string deli

miter. SQLSTATE=42603

2EETW125 SQL error "-10" during "" access: "SQL0010N The string constant beginning with ""XXXXT WITH CS -- OPTLEVEL( 5 ) -- QUERY_DEGREE" does not have an

ending string delimiter. SQLSTATE=42603"

2EETP200 Export with errors, request will not be imported

Any ideas?