Skip to Content
avatar image
Former Member

SPAM/SAINT update error during MAIN IMPORT due to DEADLOCK

Hi,

We are updating SPAM/SAINT from version 7.02/0043 to 7.02/0045. The update ran well for all systems, except our production system. The update stopped with return code 12 at MAIN IMPORT phase with a DEADLOCK situation during the import of R3TRFUGRSPAM. We can't restart the import via SPAM transaction, because we cannot access this transaction for the moment (short dump when accessing).

Solution ?

Thanks in advance,

Christophe

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Feb 20, 2012 at 12:03 PM

    Hi,

    Refer SAP Note # 1454536 if helps.

    pls provide details Dump thrown by system.

    Regards,

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 20, 2012 at 12:40 PM

    Hi,

    Thanks for the help.

    I know that the import has to be repeated. If I remember correctly, I have to launch the import via OS commend prompt (here it is Linux). In the case of a SPAM/SAINT update, this import should be performed with special options. But I don't remember these options.

    In the log, I can see the following (extract only):

    Start import R3TRFUGRSPAM ...

    (...)

    report ~SPAMTOP======================HIL (L) synchronized.

    now touching the master programs

    199 REPOS activated (LSPAM$01 - LSPAMUXX ) after deleting 199

    47359492 297329435

    REPOS SAPLSPAM P inserted.

    0 entries for TRDIRT imported (SAPLSPAM E*).

    0 entries for TRDIRT imported (SAPLSPAM D*).

    REPOTDSAPLSPAM A replaced.

    REPOTESAPLSPAM A replaced.

    [ dev trc,00000] Mon Feb 20 11:55:08 2012 29538497 29.609699

    [ dev trc,00000] dbdynpdb2: no VERSION column found in table DYNPSOURCE 14 29.609713

    DYNPS SAPLSPAM 0101 replaced and activated (load removed).

    DYNPS SAPLSPAM 0102 replaced and activated (load removed).

    sap_dext called with msgnr 16:

    db call info

    function: db_setget

    fcode: RT_GET (0)

    tabname: D020T

    len (char): 40

    key: SAPLSPAM

    ok fetches: 0

    last entry:

    retcode: 16

    Main import

    End date and time : 20120220115508

    Ended with return code: ===> 12 <===

    Kind regards,

    Chistophe

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 20, 2012 at 12:47 PM
    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 20, 2012 at 12:57 PM

    Hi,

    Finally I found the correct command:

    tp R3I SAPKD70245 EP1 pf=/usr/sap/trans/bin/TP_DOMAIN_ED1.PFL tag=spam -Dclientcascade=yes -Dstoponerror=8 -Drepeatonerror=8

    This command enabled me to complete the MAIN IMPORT part. After that, I could access the SPAM transaction again and finish the update process (execution of the Method Execution phase via a new call of Support Package -> Import SPAM/SAINT update).

    Kind regards,

    Christophe

    Add comment
    10|10000 characters needed characters exceeded

    • Hello Christophe,

      In which SAP Note have you find this command?

      Christophe Brandt wrote:

      Finally I found the correct command:

      tp R3I SAPKD70245 EP1 pf=/usr/sap/trans/bin/TP_DOMAIN_ED1.PFL tag=spam -Dclientcascade=yes -Dstoponerror=8 -Drepeatonerror=8

      Thanks in advance for your answer.