cancel
Showing results for 
Search instead for 
Did you mean: 

Import of SPAM 702 43 interrupted during import

Former Member
0 Kudos

Hello

I'm importing the SPAM update 7.02 43

Due to a deadlock the import has been interrupted:

sap_dext called with msgnr 1:
     db call info
function:   db_repo
fcode:      TOUCH_REPORT
tabname:    SOURCE
len (char): 42
key:        LSPAM$01                                AM
retcode:    1
SQL-Fehler -60 bei Zugriff auf  : POS(1) Work rolled back,DEADLOCK DETECTED

Using STMS I cannot restart the import (program error).

If I try using R3trans:

sapgle:gleadm 83> R3trans -w /usr/sap/trans/tmp/SAPID70243.GLE /usr/sap/trans/tmp/SAPKKD70243.GLE
This is R3trans version 6.22 (release 720 - 02.05.11 - 15:56:00).
unicode enabled version
2EETW152 Cannot open file "/usr/sap/trans/tmp/SAPKKD70243.GLE".
: No such file or directory
R3trans finished (0012).

Is there a way to restart the import from the shell?

Thank you and regards,

Tommaso

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos


cd /usr/sap/trans/log

ls -latr

less ULOG11_4

tp MODBUFFER SAPKD70243 GLE pf=/usr/sap/trans/bin/TP_DOMAIN_GLE.PFL mode=G0,V0,w0 -Dsourcesystems= tag=SPAM -Dtransdir=/usr/sap/trans 

tp CMD ALL GLE pf=/usr/sap/trans/bin/TP_DOMAIN_GLE.PFL -Dclientcascade=yes -Drepeatonerror=8 -Dstoponerror=8 -Dsourcesystems= tag=spam -Dtransdir=/usr/sap/trans


tp GETOBJLIST SAPKD70243 pf=/usr/sap/trans/bin/TP_DOMAIN_GLE.PFL -s GLE -Dtp_version=266 -Dnbufform=1 -Dtransdir=/usr/sap/trans

tp TST ALL GLE pf=/usr/sap/trans/bin/TP_DOMAIN_GLE.PFL -Dsourcesystems= tag=spam U1 -Dtransdir=/usr/sap/trans   

tp IMPORT all GLE pf=/usr/sap/trans/bin/TP_DOMAIN_GLE.PFL -Dclientcascade=yes -Dstoponerror=8 -Drepeatonerror=8 -Dsourcesystems= -Dbuffreset=yes -Dmainimp_proc=1 -Dstopimmediately=1 -Dactivatemerged=yes -Dcheckmasterlang=no tag=spam -Dtransdir=/usr/sap/trans

SPAM -> restart