IMPORT_PROPER SPAM status Error Stop

[Former Member]

Hi SAP People,

I have tried to uncheck "Check active DDIC user" in SPAM settings, and tried r3trans -d in OS level, but it still not fixed, and wont be able to import.

Any suggestions?

Queue            SAPKB70212

Import of queue for the

Software Component:   SAP_BASIS

SPAM status:           (Error stop)

Import phase:     IMPORT_PROPER

Thanks and Regards,

Karl

[Former Member · Accepted solution]

Hi All,

I have now a fix for this.

Just restart SAP and Stop DB in Linux, then delete TMP files (there are files that have been created before that cannot be overwritten so the installation wont proceed).

It is now working.

Thanks and Regards,

Karl

[d028544]

Dear Customer,

the system processes a phase, which cannot be reset. In addition you have a SAP_BASIS package in the queue.  You should not leave your system in this state.

I highly recommend that you contact the SAP Support. They can analyze it further.

Nevertheless you can always retry the the phase. Have you tried restarting the import? The error looks like a DB connection issue. If the db connection is lost, the import process will halt.

best regards,

  Thorsten Scheyter (SPAM/SAINT)

[Reagan]

Go to Tx SPAM and check the import logs.

You will have to expand the logs fully and check what caused the import to end in error.

Also check for any dumps in Tx ST22 and see what they say.

[Former Member]

Hi Reagan,

here is what the logs says,

TRACE-INFO: 121: [ dev trc,00000] *** ERROR in DB6Execute[dbdb6.c, 4969] (END) 56

3600.471007

TRACE-INFO: 122: [ dbtrtab ,00000] ***LOG BY4=>sql error -911 performing INS on table D1GEN

TRACE-INFO: 123: 134

3600.471141

TRACE-INFO: 124: [ dbtrtab ,00000] ***LOG BY0=>SQL0911N The current transaction has been rolled back because of a deadlock or

timeout. Reason code "68". SQLSTATE=40001 row=1

TRACE-INFO: 125: 17

3600.471158

HALT 20160913164008

ERROR: uncaught internal error: SQL0911N The current transaction has been rolled back because of a deadlock or timeout. Reason

code "68". SQLSTATE=40001 row=1

ERROR: EXIT(16) -> process ID is: 15361

tp returncode summary:

TOOLS: Highest return code of single steps was: 16

ERRORS: Highest tp internal error was: 0234

standard output from tp and from tools called by tp:

Abort the import due to an error situation (13.09.2016, 16:40:08)

ST22 message

what happened?

Error in the ABAP Application Program

The current ABAP program "SAPLTMSM" had to be terminated because it has

come across a statement that unfortunately cannot be executed.

The following syntax error occurred in program "SAPLSTCE " in include "LSTCEICH

  " in

line 291:

"FORM "FCHK_UNI_IMPTRG_CLIENT" does not exist"

" "

" "

" "

The include has been created and last changed by:

Created by: "SAP "

Last changed by: "SAP "

Error in the ABAP Application Program

The current ABAP program "SAPLTMSM" had to be terminated because it has

come across a statement that unfortunately cannot be executed.

[manish_singh13]

Hi Karl,

Can you please provide environment details (OS, DB, Kernel) with which SPs you are trying to import.

Also if possible please provide import logs to analyze further.

Thanks,

Manish

[Former Member]

Hi Manish,

I am using Linux, DB2 database, Kernel Release 720.

for Logs, this is where i see the errors in import_proper

Import phase 'IMPORT_PROPER' (13.09.2016, 15:40:07)

Error during executing the tp command 'tp IMPORT all KSZ ...'

tp return code: '0234' , tp message: 'uncaught error -> function err_exit called' , tp output:

  This is tp version 380.08.41 (release 720, unicode enabled)

  -911

  sap_dext called with msgnr 951.

  ec: 10; msgid: 00; retf: 0.

  TRACE-INFO: 70: [ dev trc,00000] RLIMIT_STACK: current=8388608, max=-1 610

  0.000610

  TRACE-INFO: 71: [ dev trc,00000] DB6 (DB2 UDB) UNICODE database interface 720.00 [opt] 13

  0.000623

  TRACE-INFO: 72: [ dev trc,00000] ..retrieving configuration parameters 9

  0.000632

  TRACE-INFO: 73: [ dev trc,00000] ..done 102

  0.000734

  TRACE-INFO: 74: [ dev trc,00000] Running with UTF-8 Unicode 9

  0.000743

  TRACE-INFO: 75: [ dev trc,00000] Running with CLI driver. 692

  0.001435

  TRACE-INFO: 76: [ dev trc,00000] Connected to DB server type 'DB2/LINUXX8664' 106995

  0.108430

  TRACE-INFO: 77: [ dev trc,00000] Connected to DB server version '10.01.0002' 23

  0.108453

  TRACE-INFO: 78: [ dev trc,00000] Connected to 'KSZ' as 'SAPKSZ' schema 'SAPKSZ' o.k. 876

  0.109329

  TRACE-INFO: 79: [ dev trc,00000] Connected: con_hdl=0 ; appl_hdl=13642; appl_id="172.18.100.146.50110.160913074007"

  TRACE-INFO: 80: 15

  0.109344

  TRACE-INFO: 81: [ dev trc,00000] Current member="172.18.100.146:5912" 11

  0.109355

TRACE-INFO: 82: [ dev trc,00000] CLI Insert Buffering is disabled on single partition databases. 1038

0.110393

TRACE-INFO: 83: [ dev trc,00000] INFO: Unable to determine SAPDBHOST; defaulting to 'UNKNOWN' 162

0.110555

TRACE-INFO: 84: [ tptrc.c,01036] trace level switched from 2 to 1 1107

0.111662

TRACE-INFO: 85: [ dev trc,00000] Tue Sep 13 16:40:08 2016 -694608448

3600.470510

TRACE-INFO: 86: [ dev trc,00000] *** ERROR in DB6Execute[dbdb6.c, 4969] CON = 0 (BEGIN) 30

3600.470540

TRACE-INFO: 87: [ dev trc,00000] &+ DbSlModifyDB6( SQLExecute 😞 [IBM][CLI Driver][DB2/LINUXX8664] SQL0911N The current

transaction has been rolled b

TRACE-INFO: 88: 48

3600.470588

TRACE-INFO: 89: [ dev trc,00000] &+ ack because of a deadlock or timeout. Reason code "68". SQLSTATE=40001 row=1

TRACE-INFO: 90: 16

3600.470604

TRACE-INFO: 91: [ dev trc,00000] &+

TRACE-INFO: 92: 27

3600.470631

TRACE-INFO: 93: [ dev trc,00000] &+ INSERT INTO "D1GEN" VALUES( ?, ?, ?, ? )

TRACE-INFO: 94: 19

3600.470650

TRACE-INFO: 95: [ dev trc,00000] &+ cursor type=NO_HOLD, isolation=UR, cc_release=YES, optlevel=5, degree=1,

op_type=15, reopt=0

TRACE-INFO: 96: 41

3600.470691

TRACE-INFO: 97: [ dev trc,00000] &+

TRACE-INFO: 98: 15

3600.470706

TRACE-INFO: 99: [ dev trc,00000] &+ Input SQLDA:

TRACE-INFO: 100: 14

3600.470720

TRACE-INFO: 101: [ dev trc,00000] &+ 1 CT=WCHAR T=VARCHAR L=20 P=30 S

TRACE-INFO: 102: 39

3600.470759

TRACE-INFO: 103: [ dev trc,00000] &+ 2 CT=WCHAR T=VARCHAR L=22 P=33 S

TRACE-INFO: 104: 16

3600.470775

TRACE-INFO: 105: [ dev trc,00000] &+ 3 CT=WCHAR T=VARCHAR L=64 P=96 S

TRACE-INFO: 106: 16

3600.470791

TRACE-INFO: 107: [ dev trc,00000] &+ 4 CT=WCHAR T=VARCHAR L=28 P=42 S

TRACE-INFO: 108: 15

3600.470806

TRACE-INFO: 109: [ dev trc,00000] &+

TRACE-INFO: 110: 22

3600.470828

TRACE-INFO: 111: [ dev trc,00000] &+ Input data:

TRACE-INFO: 112: 14

3600.470842

TRACE-INFO: 113: [ dev trc,00000] &+ row 1: 1 WCHAR I=4 "tp" 29

3600.470871

TRACE-INFO: 114: [ dev trc,00000] &+ 2 WCHAR I=22 "00000015361" 15

3600.470886

TRACE-INFO: 115: [ dev trc,00000] &+ 3 WCHAR I=20 "qcksoltest" 13

3600.470899

TRACE-INFO: 116: [ dev trc,00000] &+ 4 WCHAR I=28 "20160913154007" 13

3600.470912

TRACE-INFO: 117: [ dev trc,00000] &+

TRACE-INFO: 118: 25

3600.470937

TRACE-INFO: 119: [ dev trc,00000] &+

TRACE-INFO: 120: 14

3600.470951

TRACE-INFO: 121: [ dev trc,00000] *** ERROR in DB6Execute[dbdb6.c, 4969] (END) 56

3600.471007

TRACE-INFO: 122: [ dbtrtab ,00000] ***LOG BY4=>sql error -911 performing INS on table D1GEN

TRACE-INFO: 123: 134

3600.471141

TRACE-INFO: 124: [ dbtrtab ,00000] ***LOG BY0=>SQL0911N The current transaction has been rolled back because of a deadlock or

timeout. Reason code "68". SQLSTATE=40001 row=1

TRACE-INFO: 125: 17

3600.471158

HALT 20160913164008

ERROR: uncaught internal error: SQL0911N The current transaction has been rolled back because of a deadlock or timeout. Reason

code "68". SQLSTATE=40001 row=1

ERROR: EXIT(16) -> process ID is: 15361

tp returncode summary:

TOOLS: Highest return code of single steps was: 16

ERRORS: Highest tp internal error was: 0234

standard output from tp and from tools called by tp:

Thanks in advance!

Regards,

Karl

ort the import due to an error situation (13.09.2016, 16:40:08)