Skip to Content
avatar image
Former Member

TP status SIGW

Dear all,

I am applying support packages on SAP BW 3.1. On support package basis 20, the status bar display "Main import finished with return code 0" and the clock show in process but no activity. When i checked in os, TP show no cpu utilization and status SIGW.

I tried both in background and dialog but result same. SLOG show error that background job not running but there is no problem with background jobs as other jobs are running. According to sapnote i also update tp, r3trans, dw and lib_dbsl and now my patch level is 1903.

but the problem same.

Can anyone help me.

Thanks

Imran Hasware

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    avatar image
    Former Member
    Jul 23, 2006 at 09:50 AM

    One thing more to add, when i checked TP with status SIGW, in the same i found wp00 running with cpu utilization of 0.3 or 0.4 %. I checked the job log and here is one sample, if it is helpful.

    Job 263931/BDK11/WP00 started on 07/22/06 at 15:33:57 in subsystem R3_11

    in R3BDK400. Job entered system on 07/22/06 at 15:33:57.

    Library QGY added to library list.

    Current library changed to R3BDKDATA.

    Connect from workprocess w0 on kr3dev_BDK_11

    Library R3SYS added to library list.

    Ownership of object "abrtmAT" in R3BDK12050 type *SQLPKG changed.

    Ownership of object "abrtmAT" in R3BDK12050 type *SQLPKG changed.

    R3BDK52052 in *N type *LIB not found.

    Library R3BDK52052 already exists.

    Error: CRTLIB LIB(R3BDK52052) TEXT('R/3 SQL packages for system BDK')

    AUT(EXCLUDE) CRTAUT(EXCLUDE) failed.

    Prepared statement KMgCOA5eAA not found.

    Prepared statement KNICOALxCA not found.

    Ownership of object "dbsyntAT" in R3BDK12052 type *SQLPKG changed.

    Ownership of object "dbsyntAT" in R3BDK12052 type *SQLPKG changed.

    Prepared statement NazAAAB6DAsp not found.

    Prepared statement P0hAAAGGDC not found.

    Ownership of object REPOSRCAT in R3BDK62052 type *SQLPKG changed.

    Ownership of object REPOSRCAT in R3BDK62052 type *SQLPKG changed.

    Ownership of object D010INCAT in R3BDK62050 type *SQLPKG changed.

    Ownership of object D010INCAT in R3BDK62050 type *SQLPKG changed.

    Ownership of object D010TABAT in R3BDK62050 type *SQLPKG changed.

    Ownership of object D010TABAT in R3BDK62050 type *SQLPKG changed.

    Prepared statement P0hAAAIeCA not found.

    Prepared statement P0hAAAFSCA not found.

    Prepared statement P0hAAAFQCA not found.

    Prepared statement P0hAAAIcCA not found.

    Prepared statement J1xCOAcQAA not found.

    Prepared statement J1xCOAbiAA not found.

    Prepared statement J1xCOAguBA not found.

    Prepared statement J1xCOAm/BA not found.

    Prepared statement J1xCOAj1DA not found.

    Prepared statement J1xCOAZYBA not found.

    Prepared statement J1xCOAkeAA not found.

    Prepared statement J1xCOAc+AA not found.

    Prepared statement J1xCOAinBA not found.

    Prepared statement J1xCOAfHBA not found.

    Prepared statement J1xCOAaxDA not found.

    Prepared statement J1xCOAaJDA not found.

    Prepared statement J1xCOAgGBA not found.

    Prepared statement J1xCOAd8BA not found.

    Prepared statement J1xCOAlzDA not found.

    Prepared statement J1xCOAhcBA not found.

    Prepared statement JUgCOABTAA not found.

    Prepared statement JUgCOACoAC not found.

    Prepared statement JUgCOAA9DA not found.

    Prepared statement KLrCOAXmAA not found.

    Prepared statement KLrCOAX2CA not found.

    Prepared statement KLrCOAYEBA not found.

    Prepared statement KLrCOAYaCA not found.

    Prepared statement JUhCOAYQAABK not found.

    Prepared statement JUhCOAa/DABK not found.

    Commit operation failed due to constraint violation.

    Duplicate key value specified.

    Duplicate record key in member CSMCLSMAP.

    Duplicate key on access path.

    Duplicate key on access path.

    Duplicate key value specified.

    Duplicate record key in member CSMCLSMAP.

    Duplicate key on access path.

    Duplicate key on access path.

    Duplicate key value specified.

    Duplicate record key in member CSMCLSMAP.

    Duplicate key on access path.

    Duplicate key on access path.

    Duplicate key value specified.

    Duplicate record key in member CSMCLSMAP.

    Duplicate key on access path.

    Duplicate key on access path.

    Duplicate key value specified.

    Duplicate record key in member CSMCLSMAP.

    Duplicate key on access path.

    Duplicate key on access path.

    Duplicate key value specified.

    Duplicate record key in member CSMCLSMAP.

    Duplicate key on access path.

    Duplicate key on access path.

    Duplicate key value specified.

    Duplicate record key in member CSMCLSMAP.

    Duplicate key on access path.

    Duplicate key on access path.

    Duplicate key value specified.

    Duplicate record key in member CSMCLSMAP.

    Duplicate key on access path.

    Duplicate key on access path.

    Duplicate key value specified.

    Duplicate record key in member CSMCLSMAP.

    Duplicate key on access path.

    Duplicate key on access path.

    Duplicate key value specified.

    Duplicate record key in member CSMCLSMAP.

    Duplicate key on access path.

    Duplicate key on access path.

    Duplicate key value specified.

    Duplicate record key in member CSMCLSMAP.

    Duplicate key on access path.

    Duplicate key on access path.

    Duplicate key on access path.

    Duplicate key on access path.

    Duplicate key value specified.

    Duplicate record key in member CSMCLSMAP.

    Duplicate key on access path.

    Duplicate key on access path.

    Duplicate key value specified.

    Duplicate record key in member CSMCLSMAP.

    Duplicate key on access path.

    Duplicate key on access path.

    Duplicate key value specified.

    Commit operation failed due to constraint violation.

    Duplicate key value specified.

    Duplicate record key in member CSMCLSMAP.

    (I have not pasted all, because the process for csmclsmap continued for long, then checked another object as below)

    Duplicate key on access path.

    Duplicate key on access path.

    Duplicate key value specified.

    Duplicate record key in member ALGRPCUSGE.

    Duplicate key on access path.

    Duplicate key on access path.

    Duplicate key value specified.

    Duplicate record key in member ALGRPCUSGE.

    Duplicate key on access path.

    Duplicate key on access path.

    Duplicate key value specified.

    Duplicate record key in member ALGRPCUSGE.

    Duplicate key on access path.

    Duplicate key on access path.

    (Again after long time, now the object is changed as below:)

    Duplicate key on access path.

    Duplicate key on access path.

    Duplicate key value specified.

    Duplicate record key in member ALGRPCUSGE.

    Duplicate key on access path.

    Duplicate key on access path.

    Duplicate key value specified.

    Duplicate record key in member ALGRPCUSGE.

    Duplicate key on access path.

    Duplicate key on access path.

    Duplicate key value specified.

    Duplicate record key in member ALGRPCUSGE.

    Duplicate key on access path.

    Duplicate key on access path.

    Duplicate key value specified.

    Duplicate record key in member ALCLASTOOL.

    Duplicate key on access path.

    Duplicate key on access path.

    Duplicate key value specified.

    Prepared statement Lf6COABCAA not found.

    Prepared statement Lf6COAQCBA not found.

    Prepared statement Lf6COAVbAA not found.

    R3BDK52050 in *N type *LIB not found.

    Ownership of object R3BDK52050 in QSYS type *LIB changed.

    Library R3BDK52050 created.

    Ownership of object DYNPSOURAT in R3BDK52050 type *SQLPKG changed.

    Ownership of object DYNPSOURAT in R3BDK52050 type *SQLPKG changed.

    DYNPTXTLAT in R3BDK52050 type *SQLPKG not found.

    Ownership of object DYNPTXTLAT in R3BDK52050 type *SQLPKG changed.

    Ownership of object DYNPTXTLAT in R3BDK52050 type *SQLPKG changed.

    DYNPLOADAT in R3BDK52050 type *SQLPKG not found.

    Ownership of object DYNPLOADAT in R3BDK52050 type *SQLPKG changed.

    Ownership of object DYNPLOADAT in R3BDK52050 type *SQLPKG changed.

    Prepared statement OsVAAACQBAt not found.

    Prepared statement P0GAAAEfBA not found.

    Prepared statement P0GAAAEfBA not found.

    Prepared statement P0GAAAEfBA not found.

    Duplicate record key in member ALCLASTOOL.

    Duplicate key on access path.

    Duplicate key on access path.

    Duplicate key value specified.

    Duplicate record key in member ALCLASTOOL.

    Duplicate key on access path.

    Duplicate key on access path.

    Duplicate key value specified.

    Prepared statement KL4COARCBA not found.

    Prepared statement KL4COASBAC not found.

    Prepared statement KL4COAScCA not found.

    Prepared statement KL4COATHCC not found.

    Prepared statement KL4COATlCA not found.

    SAPLCRFCBQ in R3BDK02060 type *SQLPKG not found.

    Ownership of object SAPLCRFCBQ in R3BDK02060 type *SQLPKG changed.

    Ownership of object SAPLCRFCBQ in R3BDK02060 type *SQLPKG changed.

    Prepared statement JxsCOAstCA not found.

    SAPLTMSCBN in R3BDK02060 type *SQLPKG not found.

    Ownership of object SAPLTMSCBN in R3BDK02060 type *SQLPKG changed.

    Ownership of object SAPLTMSCBN in R3BDK02060 type *SQLPKG changed.

    Prepared statement KL4COAUZDA not found.

    Prepared statement KL4COBPQCA not found.

    Prepared statement KL4COBPmAA not found.

    SAPLSXMIBQ in R3BDK02060 type *SQLPKG not found.

    Ownership of object SAPLSXMIBQ in R3BDK02060 type *SQLPKG changed.

    Ownership of object SAPLSXMIBQ in R3BDK02060 type *SQLPKG changed.

    Prepared statement JScCOALQAA not found.

    Prepared statement KNJCOACzBA not found.

    Duplicate record key in member ALGRPCUSGE.

    Duplicate key on access path.

    Duplicate key on access path.

    Duplicate key value specified.

    Duplicate record key in member ALGRPCUSGE.

    (And then the above object continues.....)

    I must also told you that when two days back when the patch was hanged for couple of hours, i had terminated it with endjob as there was no other way.

    Is the above problem can be solved, please.

    Thanks

    Imran Hasware

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Imran,

      What Volker explained to you can be read in detail in <b>SAP note 71353</b> (Transports hang during background steps). You find some background information there and a detailed description of how to check and what to do. Related and also very useful is <b>note 26966</b> (Background jobs do not start when transporting)

      Regards,

      Thomas

  • avatar image
    Former Member
    Jul 23, 2006 at 07:25 AM

    Hi Imran,

    I don't understand patch 1903 with BW 3.1, because you should switch to the 6.40 kernel instead of using 6.20. But this is not your current issue here.

    tp issues the even SAP_TRIGGER_RDDIMPDP and then RDDIMPDP should start for a second and submit a real worker job with RDD*.

    You should now check if RDDIMPDP was running shortly - every minute or so. If not, I would trigger this event via SM64 myself. If it then runs further the SAPEVT seems to be bad.

    But, my assumption is:

    There is an RDD* job in SM37 on active, but not really working. You should check the state and correct it then.

    When you later go to a new kernel, it should be fixed.

    Regards

    Volker

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 23, 2006 at 09:24 AM

    Thanks for the reply.

    Actually we have 6.20 kernel with bw 3.1. and to update it to kernel 6.40, basis support package for 6.20 should be 47. Everything was working fine upto basis 19.

    i triggered the same through sm64, but it is same.

    I found that a job RDDGEN0L with ready status but it is not working. I tried to release it, is giving me message that "....(job name) cannot be modified due to its status"

    Should i update the remaining kernel files as well as there was a long time to download all these, i updated 4 files, dw, lib dbsl, tp and r3trans or any other solution.

    Thanks

    Imran Hasware

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 25, 2006 at 12:59 PM

    Thanks to all for the replies. sapnote 26966 was very helpful.

    Thanks

    Imran

    Add comment
    10|10000 characters needed characters exceeded