Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

SQL error 60 when accessing table "LOGIC_DEST".

Hi Basis Guru's

We are getting dumps DBIF_RSQL_SQL_ERROR  and sm21 error Database error 60 at UPD access to table LOGIC_DEST

Category           Installation Errors
Runtime Errors     DBIF_RSQL_SQL_ERROR
Except.            CX_SY_OPEN_SQL_DB
Date and Time      12/16/2013 10:42:05

--

|Short text                                                                                    |
|SQL error 60 when accessing table "LOGIC_DEST".                                           |

|What happened?                                                                                |
|Error Text of the Database: "ORA-00060: deadlock detected while waiting for               |
| resource"                                                                                |

----------------------------------------------------------------------------------------------------

----------------------------------------------------------------------------------------------------

|What can you do?                                                                              |
|Note which actions and input led to the error.                                            |
|                                                                                              |
|For further help in handling the problem, contact your SAP administrator                  |
|.                                                                                         |
|                                                                                              |
|You can use the ABAP dump analysis transaction ST22 to view and manage                    |
|termination messages, in particular for long term reference.                              |
|                                                                                              |
|Note which actions and input led to the error.                                            |
|                                                                                              |
|For further help in handling the problem, contact your SAP administrator                  |
|.                                                                                         |
|                                                                                              |
|You can use the ABAP dump analysis transaction ST22 to view and manage                    |
|termination messages, in particular for long term reference.                              |
|                                                                                              |

----------------------------------------------------------------------------------------------------

----------------------------------------------------------------------------------------------------

|Error analysis                                                                                |
|An exception occurred that is explained in detail below.                                  |
|The exception, which is assigned to class 'CX_SY_OPEN_SQL_DB', was not caught             |
| in                                                                                       |
|procedure "SMON_GET_LOGICAL_DESTINATIONS" "(FUNCTION)", nor was it propagated             |
| by a RAISING clause.                                                                     |
|Since the caller of the procedure could not have anticipated that the                     |
|exception would occur, the current program is terminated.                                 |
|The reason for the exception is:                                                          |
|Error Text of the Database: "ORA-00060: deadlock detected while waiting for               |
| resource"                                                                                |
|Last error logged in SAP kernel                                                           |
|                                                                                              |
|Component............ "SAP-Gateway"                                                       |
|Place................ "SAP-Gateway on host saprf / sapgw00"                               |
|Version.............. 2                                                                   |
|Error code........... 242                                                                 |
|Error text........... "timeout during allocate"                                           |
|Description.......... "no connect of TP rfcoscol from host sapr after 60 sec"             |
|System call.......... " "                                                                 |
|Module............... "gwr3cpic.c"                                                        |
|Line................. 6225                                                                |
|                                                                                              |
|The error reported by the operating system is:                                            |
|Error number..... " "                                                                     |
|Error text....... " "                                                                     |
|                                                                                              |
|Unable to access the specified service.                                                   |
|                                                                                              |
|Depending on the type of connection, check the following:                                 |
|                                                                                              |
|Connection to an R/3 System:                                                              |
|                                                                                              |
|1. Is the specified target system active?                                                 |
|   Try to logon to this system directly.                                                  |
|2. Is the system number correct?                                                          |
|   With an RFC connection, the specified two-character number ##                          |
|   is converted to the TCP/IP service sapdp##.                                            |
|   This number must match the system number in the profile of                             |
|   the target system.                                                                     |
|3. Is the host name correct?                                                              |
|4. Is the host name known to the calling computer and is the                              |
|   IP address correct?                                                                    |
|                                                                                              |
|Connection to an external program:                                                        |
|                                                                                              |
|1. Is the path name of the program in the destination correct?                            |
|   Always use explicit path names.                                                        |
|2. If the program is to be executed on another computer, is the                           |
|   SAP application server authorized to start this program?                               |
|   -                                                                                      |
|   Logon to the calling computer as administrator for the                                 |
|   SAP application server and try to call the program                                     |
|   from there with 'remote shell' (rsh, remsh).                                           |
|   -                                                                                      |
|3. Does the program end before it can establish a connection                              |
|   to the SAP gateway?                                                                    |
|   Instead of the program to be called, install an executable                             |
|   script which calls the actual program with all the command                             |
|   line parameters and diverts 'stdout' and 'stderr' to a                                 |
|   file.                                                                                  |
|   Is this file open (date changed)?                                                      |
|   Does it contain error messages?                                                        |
|                                                                                              |
|                                                                                              |
|                                                                                              |

----------------------------------------------------------------------------------------------------

----------------------------------------------------------------------------------------------------

|How to correct the error                                                                      |
|Internal call code.........: "[RSQL/UPDT/LOGIC_DEST ]"                                    |
|Please check the entries in the system log (Transaction SM21).                            |
|                                                                                              |
|If the error occures in a non-modified SAP program, you may be able to                    |
|find an interim solution in an SAP Note.                                                  |
|If you have access to SAP Notes, carry out a search with the following                    |
|keywords:                                                                                 |
|                                                                                              |
|"DBIF_RSQL_SQL_ERROR" "CX_SY_OPEN_SQL_DB"                                                 |
|"SAPLSMON" or "LSMONU31"                                                                  |
|"SMON_GET_LOGICAL_DESTINATIONS"                                                           |
|                                                                                              |
|If you cannot solve the problem yourself and want to send an error                        |
|notification to SAP, include the following information:                                   |
|                                                                                              |
|1. The description of the current problem (short dump)                                    |
|                                                                                              |
|   To save the description, choose "System->List->Save->Local File                        |
|(Unconverted)".                                                                           |
|                                                                                              |
|2. Corresponding system log                                                               |
|                                                                                              |
|   Display the system log by calling transaction SM21.                                    |
|   Restrict the time interval to 10 minutes before and five minutes                       |
|after the short dump. Then choose "System->List->Save->Local File                         |
|(Unconverted)".                                                                           |
|                                                                                              |
|3. If the problem occurs in a problem of your own or a modified SAP                       |
|program: The source code of the program                                                   |
|   In the editor, choose "Utilities->More                                                 |
|Utilities->Upload/Download->Download".                                                    |
|                                                                                              |
|4. Details about the conditions under which the error occurred or which                   |
|actions and input led to the error.                                                       |
|                                                                                              |
|                                                                                              |
|If the error occures in a non-modified SAP program, you may be able to                    |
|find an interim solution in an SAP Note.                                                  |
|If you have access to SAP Notes, carry out a search with the following                    |
|keywords:                                                                                 |
|                                                                                              |
|"DBIF_RSQL_SQL_ERROR" "CX_SY_OPEN_SQL_DB"                                                 |
|"SAPLSMON" or "LSMONU31"                                                                  |
|"SMON_GET_LOGICAL_DESTINATIONS"                                                           |
|                                                                                              |
|If you cannot solve the problem yourself and want to send an error                        |
|notification to SAP, include the following information:                                   |
|                                                                                              |
|1. The description of the current problem (short dump)                                    |
|                                                                                              |
|   To save the description, choose "System->List->Save->Local File                        |
|(Unconverted)".                                                                           |
|                                                                                              |
|2. Corresponding system log                                                               |
|                                                                                              |
|   Display the system log by calling transaction SM21.                                    |
|   Restrict the time interval to 10 minutes before and five minutes                       |
|after the short dump. Then choose "System->List->Save->Local File                         |
|(Unconverted)".                                                                           |
|                                                                                              |
|3. If the problem occurs in a problem of your own or a modified SAP                       |
|program: The source code of the program                                                   |
|   In the editor, choose "Utilities->More                                                 |
|Utilities->Upload/Download->Download".                                                    |
|                                                                                              |
|4. Details about the conditions under which the error occurred or which                   |
|actions and input led to the error.                                                       |
|                                                                                              |
|The exception must either be prevented, caught within proedure                            |
|"SMON_GET_LOGICAL_DESTINATIONS" "(FUNCTION)", or its possible occurrence must             |
| be declared in the                                                                       |
|RAISING clause of the procedure.                                                          |
|To prevent the exception, note the following:                                             |

----------------------------------------------------------------------------------------------------

----------------------------------------------------------------------------------------------------

|System environment                                                                            |
|SAP Release..... 731                                                                      |
|SAP Basis Level. 0006                                                                     |
|                                                                                              |
|Application server... "saprf"                                                             |
|Network address...... "10.195.232.7"                                                      |
|Operating system..... "AIX"                                                               |
|Release.............. "7.1"                                                               |
|Hardware type........ "00F86C054C00"                                                      |
|Character length.... 16 Bits                                                              |
|Pointer length....... 64 Bits                                                             |
|Work process number.. 27                                                                  |
|Shortdump setting.... "full"                                                              |
|                                                                                              |
|Database server... "galahad"                                                              |
|Database type..... "ORACLE"                                                               |
|Database name..... "PR1"                                                                  |
|Database user ID.. "SAPPR1"                                                               |
|                                                                                              |
|Terminal.......... " "                                                                    |
|                                                                                              |
|Char.set.... "C"                                                                          |
|                                                                                              |
|SAP kernel....... 720                                                                     |
|created (date)... "Jan 16 2013 10:57:22"                                                  |
|create on........ "AIX 1 6 00CFACD14C00"                                                  |
|Database version. "OCI_112, 11.2.0.3.0, V1, default"                                      |
|                                                                                              |
|Patch level. 401                                                                          |
|Patch text.. " "                                                                          |
|                                                                                              |
|Database............. "ORACLE 10.1.0.*.*, ORACLE 10.2.0.*.*, ORACLE 11.2.*.*.*"           |
|SAP database version. 720                                                                 |
|Operating system..... "AIX 1 6, AIX 1 7"                                                  |
|                                                                                              |
|Memory consumption                                                                        |
|Roll.... 0                                                                                |
|EM...... 20948960                                                                         |
|Heap.... 0                                                                                |
|Page.... 32768                                                                            |
|MM Used. 1427232                                                                          |
|MM Free. 2759888                                                                          |

----------------------------------------------------------------------------------------------------

----------------------------------------------------------------------------------------------------

|User and Transaction                                                                          |
|Client.............. 000                                                                  |
|User................ "IBMSUPPORT"                                                         |
|Language key........ "E"                                                                  |
|Transaction......... " "                                                                  |
|Transaction ID...... "52AD12D980D41A50E10080000AC3E870"                                   |
|                                                                                              |
|EPP Whole Context ID.... "52AD255885A43020E10080000AC3E839"                               |
|EPP Connection ID....... 00000000000000000000000000000000                                 |
|EPP Caller Counter...... 0                                                                |
|                                                                                              |
|Program............. "SAPLSMON"                                                           |
|Screen.............. "SAPMSSY0 1000"                                                      |
|Screen Line......... 6                                                                    |
|Debugger Active..... "none"                                                               |

----------------------------------------------------------------------------------------------------

----------------------------------------------------------------------------------------------------

|Information on where terminated                                                               |
|Termination occurred in the ABAP program "SAPLSMON" - in                                  |
| "SMON_GET_LOGICAL_DESTINATIONS".                                                         |
|The main program was "RSHOST3M ".                                                         |
|                                                                                              |
|In the source code you have the termination point in line 115                             |
|of the (Include) program "LSMONU31".                                                      |
|The program "SAPLSMON" was started as a background job.                                   |
|Job Name....... "SAP_COLLECTOR_PERFMON_RSHOSTDC"                                          |
|Job Initiator.. "IBMSUPPORT"                                                              |
|Job Number..... 10324200                                                                  |
|The termination is caused because exception "CX_SY_OPEN_SQL_DB" occurred in               |
|procedure "SMON_GET_LOGICAL_DESTINATIONS" "(FUNCTION)", but it was neither                |
| handled locally nor declared                                                             |
|in the RAISING clause of its signature.                                                   |
|                                                                                              |
|The procedure is in program "SAPLSMON "; its source code begins in line                   |
|1 of the (Include program "LSMONU31 ".                                                    |

----------------------------------------------------------------------------------------------------

----------------------------------------------------------------------------------------------------

|Source Code Extract                                                                           |

----------------------------------------------------------------------------------------------------

|Line |SourceCde                                                                               |

----------------------------------------------------------------------------------------------------

|   85|                                                                                        |
|   86|* CK: if AGENT_DEST flag is set, the entry is an internal destination                   |
|   87|*DESTINATIONS-LOCALITY = 'REMOTE'.                                                  |
|   88|   IF LOG_DEST_WA_TBL-AGENT_DEST = 'X'.                                                 |
|   89|  DESTINATIONS-LOCALITY = 'INTERN'.                                                 |
|   90|  LOGIC_DESTIN-LOCALITY =  'INTERN'.                                                |
|   91|* new field in LOGIC_DESTS                                                              |
|   92|  LOGIC_DESTIN-AGENT_DEST = 'X'.                                                    |
|   93|   ELSE.                                                                                |
|   94|  DESTINATIONS-LOCALITY = 'REMOTE'.                                                 |
|   95|  LOGIC_DESTIN-LOCALITY  = 'REMOTE'.                                                |
|   96|   ENDIF.                                                                               |
|   97|                                                                                        |
|   98|*                                                                                       |
|   99|* Only mark an entry that matches the current DB Server as a db server,                 |
|  100|* and clear any others mark as such. This is only for logical dests.                    |
|  101|*                                                                                       |
|  102|                                                                                        |
|  103|search LOG_DEST_WA_TBL-LOGIC_DEST for '_'.                                              |
|  104|* name contains '_'                                                                     |
|  105|if sy-subrc = 0.                                                                        |
|  106|checked = 'X'.                                                                      |
|  107|SPLIT LOG_DEST_WA_TBL-LOGIC_DEST AT '_' INTO NAME1 NAME2.                           |
|  108|TRANSLATE NAME2 TO UPPER CASE.                                                      |
|  109|IF NAME2 = DB_HOST_NAME.                                                            |
|  110|  DESTINATIONS-DB_SERVER+1(1) = 'X'. " for output only                              |
|  111|  LOGIC_DESTIN-db_server+1(1) = 'X'. " for output only                              |
|  112|                                                                                        |
|  113|  LOG_DEST_WA_TBL-DB_SERVER = 'X'."for DB table                                 |
|  114|  LOGIC_DEST = LOG_DEST_WA_TBL.                                                     |
|>>>>>|  UPDATE LOGIC_DEST.                                                                |
|  116|  IF SY-SUBRC NE 0.                                                                 |
|  117|    RAISE CANT_GET_LOGICAL_DESTINATIONS.                                            |
|  118|  ENDIF.                                                                            |
|  119|ELSEIF LOG_DEST_WA_TBL-DB_SERVER = 'X'. "flag set but not for DB                    |
|  120|  CLEAR LOG_DEST_WA_TBL-DB_SERVER.                                                  |
|  121|  IF SY-DBSYS <> 'DB2'.                                                             |
|  122|  LOGIC_DEST = LOG_DEST_WA_TBL.                                                     |
|  123|  UPDATE LOGIC_DEST.                                                                |
|  124|  IF SY-SUBRC NE 0.                                                                 |
|  125|    RAISE CANT_GET_LOGICAL_DESTINATIONS.                                            |
|  126|  ENDIF.                                                                            |
|  127|  endif.                                                                            |
|  128|ENDIF.                                                                              |
|  129|endif.                                                                                  |
|  130|*  might be an agent destination, search for '.'                                        |
|  131|search LOG_DEST_WA_TBL-LOGIC_DEST for '...' .                                           |
|  132|if sy-subrc = 0.                                                                        |
|  133| checked = 'X'.                                                                     |
|  134|  DATA: ITAB TYPE TABLE OF STRING,                                                  |

----------------------------------------------------------------------------------------------------

----------------------------------------------------------------------------------------------------

|Contents of system fields                                                                     |

----------------------------------------------------------------------------------------------------

|Name|Val.                                                                                 |

----------------------------------------------------------------------------------------------------

|SY-SUBRC|0                                                                                    |
|SY-INDEX|0                                                                                    |
|SY-TABIX|5                                                                                    |
|SY-DBCNT|7                                                                                    |
|SY-FDPOS|8                                                                                    |
|SY-LSIND|0                                                                                    |
|SY-PAGNO|0                                                                                    |
|SY-LINNO|1                                                                                    |
|SY-COLNO|1                                                                                    |
|SY-PFKEY|                                                                                     |
|SY-UCOMM|                                                                                     |
|SY-TITLE|For Logging Statistic Data on Performance Database (Moni)                            |
|SY-MSGTY|                                                                                     |
|SY-MSGID|                                                                                     |
|SY-MSGNO|000                                                                                  |
|SY-MSGV1|                                                                                     |
|SY-MSGV2|                                                                                     |
|SY-MSGV3|                                                                                     |
|SY-MSGV4|                                                                                     |
|SY-MODNO|0                                                                                    |
|SY-DATUM|20131216                                                                             |
|SY-UZEIT|104003                                                                               |
|SY-XPROG|SAPMSSY0                                                                             |
|SY-XFORM|NEW-LINE                                                                             |

----------------------------------------------------------------------------------------------------

----------------------------------------------------------------------------------------------------

|Active Calls/Events                                                                           |

----------------------------------------------------------------------------------------------------

|No.   Ty.      Program                         Include                         Line   |
Name                                                                                    |

----------------------------------------------------------------------------------------------------

|2 FUNCTION SAPLSMON                        LSMONU31                          115  |
SMON_GET_LOGICAL_DESTINATIONS                                                           |
|1 EVENT    RSHOST3M                        RSHOST3M                          202  |
END-OF-SELECTION                                                                        |

----------------------------------------------------------------------------------------------------

----------------------------------------------------------------------------------------------------

|Chosen variables                                                                              |

----------------------------------------------------------------------------------------------------

|Name                                                                                          |
|Val.                                                                                      |

----------------------------------------------------------------------------------------------------

|No.   2 Ty.      FUNCTION                                                             |
|Name  SMON_GET_LOGICAL_DESTINATIONS                                                           |

----------------------------------------------------------------------------------------------------

|DESTINATIONS[]                                                                                |
|Table IT_28[4x170]                                                                        |
|\FUNCTION=SMON_GET_LOGICAL_DESTINATIONS\DATA=DESTINATIONS[]                               |
|Table reference: 17                                                                       |
|TABH+  0(20) = 0A0001000025D070000000000000000000000000                                   |
|TABH+ 20(20) = 000000110000001C00000004000000AAFFFFFFFF                                   |
|TABH+ 40(16) = 04000020000738400004249403000000                                           |
|store    = 0x0A0001000025D070                                                         |
|ext1     = 0x0000000000000000                                                         |
|shmId    = 0 (0x00000000)                                                         |
|id       = 17(0x00000011)                                                         |
|label    = 28(0x0000001C)                                                         |
|fill     = 4 (0x00000004)                                                         |
|leng     = 170   (0x000000AA)                                                         |
|loop     = -1(0xFFFFFFFF)                                                         |
|xtyp     = TYPE#000191                                                                |
|occu     = 4 (0x00000004)                                                         |
|accKind  = 1 (ItAccessStandard)                                                   |
|idxKind  = 0 (ItIndexNone)                                                        |
|uniKind  = 2 (ItUniNo)                                                            |
|keyKind  = 1 (default)                                                            |
|cmpMode  = 2 (cmpSingleMcmpR)                                                     |
|occu0    = 1                                                                          |
|stMode   = 0                                                                          |
|groupCntl= 0                                                                          |
|rfc      = 0                                                                          |
|unShareable  = 0                                                                          |
|mightBeShared = 0                                                                         |
|sharedWithShmTab = 0                                                                      |
|isShmLockId  = 0                                                                          |
|isUsed   = 1                                                                          |
|isCtfyAble   = 1                                                                          |
|hasScndKeys  = 0                                                                          |
|hasRowId = 0                                                                          |
|scndKeysOutdated = 0                                                                      |
|scndUniKeysOutdated = 0                                                                   |
|----- Shareable Table Header Data -----                                                   |
|tabi     = 0x0A0001000025D0F0                                                         |
|pgHook   = 0x0000000000000000                                                         |
|idxPtr   = 0x0000000000000000                                                         |
|id       = 31(0x0000001F)                                                         |
|shmTabhSet   = 0x0000000000000000                                                         |
|refCount = 0 (0x00000000)                                                         |
|tstRefCount  = 0 (0x00000000)                                                         |
|lineAdmin= 4 (0x00000004)                                                         |
|lineAlloc= 4 (0x00000004)                                                         |
|shmVersId= 0 (0x00000000)                                                         |
|shmRefCount  = 1 (0x00000001)                                                         |
|rowId    = 18446744073709551615                                                       |
|scndKeyAdmin = 0x0000000000000000                                                         |
|                                                                                              |
|SAPOSCOL_PR101                 SAP OS Collector for pr101          REMOTE         |
|0000000000000000000000000000000000000000000000000000000000000000000000000000000000000     |
|0000000000000000000000000000000000000000000000000000000000000000000000000000000000000     |
|5454544455533322222222222222222222254524524666667672667277333222222222222225444542222     |
|310F33FCF021010000000000000000000003100F303FCC534F206F20021010000000000000025DF450000     |
|005300410050004F00530043004F004C005F0050005200310030003100200020002000200020002000200020002000|
|                                                                                              |
|SAPOSCOL_PR102                 OS Collector for pr102              REMOTE         |
|0000000000000000000000000000000000000000000000000000000000000000000000000000000000000     |
|0000000000000000000000000000000000000000000000000000000000000000000000000000000000000     |
|5454544455533322222222222222222222245246666676726672773332222222222222222225444542222     |
|310F33FCF02102000000000000000000000F303FCC534F206F200210200000000000000000025DF450000     |
|005300410050004F00530043004F004C005F0050005200310030003200200020002000200020002000200020002000|
|                                                                                              |
|SAPOSCOL_PR103                 OS Collector for pr103              REMOTE         |
|0000000000000000000000000000000000000000000000000000000000000000000000000000000000000     |
|0000000000000000000000000000000000000000000000000000000000000000000000000000000000000     |
|5454544455533322222222222222222222245246666676726672773332222222222222222225444542222     |
|310F33FCF02103000000000000000000000F303FCC534F206F200210300000000000000000025DF450000     |
|005300410050004F00530043004F004C005F0050005200310030003300200020002000200020002000200020002000|
|                                                                                              |
|SAPOSCOL_PR104                 OS Collector for pr104              REMOTE         |
|0000000000000000000000000000000000000000000000000000000000000000000000000000000000000     |
|0000000000000000000000000000000000000000000000000000000000000000000000000000000000000     |
|5454544455533322222222222222222222245246666676726672773332222222222222222225444542222     |
|310F33FCF02104000000000000000000000F303FCC534F206F200210400000000000000000025DF450000     |
|005300410050004F00530043004F004C005F0050005200310030003400200020002000200020002000200020002000|
|LOGIC_DESTIN[]                                                                                |
|Table IT_29[4x172]                                                                        |
|\PROGRAM=RSHOST3M\DATA=LOGIC_DESTIN_TBL[]                                                 |
|Table reference: 18                                                                       |
|TABH+  0(20) = 0A0001000025D420000000000000000000000000                                   |
|TABH+ 20(20) = 000000120000001D00000004000000ACFFFFFFFF                                   |
|TABH+ 40(16) = 040000000001CA800004249403000000                                           |
|store    = 0x0A0001000025D420                                                         |
|ext1     = 0x0000000000000000                                                         |
|shmId    = 0 (0x00000000)                                                         |
|id       = 18(0x00000012)                                                         |
|label    = 29(0x0000001D)                                                         |
|fill     = 4 (0x00000004)                                                         |
|leng     = 172   (0x000000AC)                                                         |
|loop     = -1(0xFFFFFFFF)                                                         |
|xtyp     = TYPE#000178                                                                |
|occu     = 4 (0x00000004)                                                         |
|accKind  = 1 (ItAccessStandard)                                                   |
|idxKind  = 0 (ItIndexNone)                                                        |
|uniKind  = 2 (ItUniNo)                                                            |
|keyKind  = 1 (default)                                                            |
|cmpMode  = 2 (cmpSingleMcmpR)                                                     |
|occu0    = 1                                                                          |
|stMode   = 0                                                                          |
|groupCntl= 0                                                                          |
|rfc      = 0                                                                          |
|unShareable  = 0                                                                          |
|mightBeShared = 0                                                                         |
|sharedWithShmTab = 0                                                                      |
|isShmLockId  = 0                                                                          |
|isUsed   = 1                                                                          |
|isCtfyAble   = 1                                                                          |
|hasScndKeys  = 0                                                                          |
|hasRowId = 0                                                                          |
|scndKeysOutdated = 0                                                                      |
|scndUniKeysOutdated = 0                                                                   |
|----- Shareable Table Header Data -----                                                   |
|tabi     = 0x0A0001000025D4A0                                                         |
|pgHook   = 0x0000000000000000                                                         |
|idxPtr   = 0x0000000000000000                                                         |
|id       = 32(0x00000020)                                                         |
|shmTabhSet   = 0x0000000000000000                                                         |
|refCount = 0 (0x00000000)                                                         |
|tstRefCount  = 0 (0x00000000)                                                         |
|lineAdmin= 4 (0x00000004)                                                         |
|lineAlloc= 4 (0x00000004)                                                         |
|shmVersId= 0 (0x00000000)                                                         |
|shmRefCount  = 1 (0x00000001)                                                         |
|rowId    = 18446744073709551615                                                       |
|scndKeyAdmin = 0x0000000000000000                                                         |
|                                                                                              |
|SAPOSCOL_PR101                 SAP OS Collector for pr101          REMOTE         |
|00000000000000000000000000000000000000000000000000000000000000000000000000000000000000    |
|00000000000000000000000000000000000000000000000000000000000000000000000000000000000000    |
|54545444555333222222222222222222222545245246666676726672773332222222222222254445422222    |
|310F33FCF021010000000000000000000003100F303FCC534F206F20021010000000000000025DF4500000    |
|005300410050004F00530043004F004C005F0050005200310030003100200020002000200020002000200020002000|
|                                                                                              |
|SAPOSCOL_PR102                 OS Collector for pr102              REMOTE         |
|00000000000000000000000000000000000000000000000000000000000000000000000000000000000000    |
|00000000000000000000000000000000000000000000000000000000000000000000000000000000000000    |
|54545444555333222222222222222222222452466666767266727733322222222222222222254445422222    |
|310F33FCF02102000000000000000000000F303FCC534F206F200210200000000000000000025DF4500000    |
|005300410050004F00530043004F004C005F0050005200310030003200200020002000200020002000200020002000|
|                                                                                              |
|SAPOSCOL_PR103                 OS Collector for pr103              REMOTE         |
|00000000000000000000000000000000000000000000000000000000000000000000000000000000000000    |
|00000000000000000000000000000000000000000000000000000000000000000000000000000000000000    |
|54545444555333222222222222222222222452466666767266727733322222222222222222254445422222    |
|310F33FCF02103000000000000000000000F303FCC534F206F200210300000000000000000025DF4500000    |
|005300410050004F00530043004F004C005F0050005200310030003300200020002000200020002000200020002000|
|                                                                                              |
|SAPOSCOL_PR104                 OS Collector for pr104              REMOTE         |
|00000000000000000000000000000000000000000000000000000000000000000000000000000000000000    |
|00000000000000000000000000000000000000000000000000000000000000000000000000000000000000    |
|54545444555333222222222222222222222452466666767266727733322222222222222222254445422222    |
|310F33FCF02104000000000000000000000F303FCC534F206F200210400000000000000000025DF4500000    |
|005300410050004F00530043004F004C005F0050005200310030003400200020002000200020002000200020002000|
|T_DISKNAME                                                                                    |
|                                                                                              |
|000000000000000000000000000000000000                                                      |
|000000000000000000000000000000000000                                                      |
|222222222222222222222222222222222222                                                      |
|000000000000000000000000000000000000                                                      |
|0020002000200020002000200020002000200020002000200020002000200020002000200020002000200020002000|
|SY-SUBRC                                                                                      |
|0                                                                                         |
|0000                                                                                      |
|0000                                                                                      |
|00000000                                                                                  |
|RT_CCM_LAN                                                                                    |
|166                                                                                       |
|000A                                                                                      |
|0006                                                                                      |
|000000A6                                                                                  |
|RST_CCM_TEXT_EXT                                                                              |
|107                                                                                       |
|0006                                                                                      |
|000B                                                                                      |
|0000006B                                                                                  |
|LOG_DEST_WA_TBL-LOGIC_DEST                                                                    |
|SAPOSCOL_SAPRF                                                                            |
|00000000000000000000000000000000                                                          |
|00000000000000000000000000000000                                                          |
|54545444554554222222222222222222                                                          |
|310F33FCF31026000000000000000000                                                          |
|005300410050004F00530043004F004C005F0053004100500052004600200020002000200020002000200020002000|
|NAME1                                                                                         |
|SAPOSCOL                                                                                  |
|00000000000000000000000000000000                                                          |
|00000000000000000000000000000000                                                          |
|54545444222222222222222222222222                                                          |
|310F33FC000000000000000000000000                                                          |
|005300410050004F00530043004F004C00200020002000200020002000200020002000200020002000200020002000|
|NAME2                                                                                         |
|SAPRF                                                                                     |
|00000000000000000000000000000000                                                          |
|00000000000000000000000000000000                                                          |
|54554222222222222222222222222222                                                          |
|31026000000000000000000000000000                                                          |
|0053004100500052004600200020002000200020002000200020002000200020002000200020002000200020002000|
|SY-REPID                                                                                      |
|SAPLSMON                                                                                  |
|0000000000000000000000000000000000000000                                                  |
|0000000000000000000000000000000000000000                                                  |
|5454544422222222222222222222222222222222                                                  |
|310C3DFE00000000000000000000000000000000                                                  |
|005300410050004C0053004D004F004E00200020002000200020002000200020002000200020002000200020002000|
|DB_HOST_NAME                                                                                  |
|SAPRF                                                                                     |
|00000000000000000000000000000000                                                          |
|00000000000000000000000000000000                                                          |
|54554222222222222222222222222222                                                          |
|31026000000000000000000000000000                                                          |
|0053004100500052004600200020002000200020002000200020002000200020002000200020002000200020002000|
|RT_CCM_VIRT_MEM_VIRTCONT                                                                      |
|178                                                                                       |
|000B                                                                                      |
|0002                                                                                      |
|000000B2                                                                                  |
|DISK_TRANSFER_CLASS                                                                           |
|DiskTransferred                                                                           |
|0000000000000000000000000000000000000000                                                  |
|0000000000000000000000000000000000000000                                                  |
|4676576676677662222222222222222222222222                                                  |
|493B421E36522540000000000000000000000000                                                  |
|004400690073006B005400720061006E00730066006500720072006500640020002000200020002000200020002000|
|SPACE                                                                                         |
|                                                                                              |
|0                                                                                         |
|0                                                                                         |
|2                                                                                         |
|0                                                                                         |
|0020                                                                                      |
|MONI                                                                                          |
|                        ##  ##################################################################|
|0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000|
|0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000|
|2222222222222222222222220022000000000000000000000000000000000000000000000000000000000000000000|
|0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000|
|0020002000200020002000200020002000200020002000200020002000200020002000200020002000200020002000|
|<%_TABLE_LOGIC_DEST>                                                                          |
|???                                                                                       |
|??????                                                                                    |
|??????                                                                                    |
|????????????                                                                              |
|HW_OBJECT_TEXT_FIELD_BASE                                                                     |
|HW_OBJECT_TREE-TEXT                                                                       |
|00000000000000000000000000000000000000000000000000                                        |
|00000000000000000000000000000000000000000000000000                                        |
|45544444555544254552222222222222222222222222222222                                        |
|87FF2A534F4255D45840000000000000000000000000000000                                        |
|00480057005F004F0042004A004500430054005F0054005200450045002D0054004500580054002000200020002000|
|LOGIC_DEST                                                                                    |
|SAPOSCOL_SAPRF              automatically generated DB destination                   X|
|0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000|
|0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000|
|5454544455455422222222222222222267766676666672666676766244266776667666222222222222222222222225|
|310F33FCF31026000000000000000000154FD14931CC9075E521454042045349E149FE000000000000000000000008|
|005300410050004F00530043004F004C005F0053004100500052004600200020002000200020002000200020002000|
|SYST-REPID                                                                                    |
|SAPLSMON                                                                                  |
|0000000000000000000000000000000000000000                                                  |
|0000000000000000000000000000000000000000                                                  |
|5454544422222222222222222222222222222222                                                  |
|310C3DFE00000000000000000000000000000000                                                  |
|005300410050004C0053004D004F004E00200020002000200020002000200020002000200020002000200020002000|
|MONIKEY                                                                                       |
|                                                                                              |
|0000000000000000000000                                                                    |
|0000000000000000000000                                                                    |
|2222222222222222222222                                                                    |
|0000000000000000000000                                                                    |
|0020002000200020002000200020002000200020002000200020002000200020002000200020002000200020  |
|LOG_DEST_WA_TBL-DB_SERVER                                                                     |
|X                                                                                         |
|0                                                                                         |
|0                                                                                         |
|5                                                                                         |
|8                                                                                         |
|0058                                                                                      |

----------------------------------------------------------------------------------------------------

|No.   1 Ty.      EVENT                                                                |
|Name  END-OF-SELECTION                                                                        |

----------------------------------------------------------------------------------------------------

|SY-MSGV1                                                                                      |
|                                                                                              |
|00000000000000000000000000000000000000000000000000                                        |
|00000000000000000000000000000000000000000000000000                                        |
|22222222222222222222222222222222222222222222222222                                        |
|00000000000000000000000000000000000000000000000000                                        |
|0020002000200020002000200020002000200020002000200020002000200020002000200020002000200020002000|
|SY-MSGV2                                                                                      |
|                                                                                              |
|00000000000000000000000000000000000000000000000000                                        |
|00000000000000000000000000000000000000000000000000                                        |
|22222222222222222222222222222222222222222222222222                                        |
|00000000000000000000000000000000000000000000000000                                        |
|0020002000200020002000200020002000200020002000200020002000200020002000200020002000200020002000|
|SY-MSGV3                                                                                      |
|                                                                                              |
|00000000000000000000000000000000000000000000000000                                        |
|00000000000000000000000000000000000000000000000000                                        |
|22222222222222222222222222222222222222222222222222                                        |
|00000000000000000000000000000000000000000000000000                                        |
|0020002000200020002000200020002000200020002000200020002000200020002000200020002000200020002000|
|SY-MSGV4                                                                                      |
|                                                                                              |
|00000000000000000000000000000000000000000000000000                                        |
|00000000000000000000000000000000000000000000000000                                        |
|22222222222222222222222222222222222222222222222222                                        |
|00000000000000000000000000000000000000000000000000                                        |
|0020002000200020002000200020002000200020002000200020002000200020002000200020002000200020002000|
|TA_SPAG_ALL                                                                                   |
|##################################                                                        |
|0000000000000000000000000000000000                                                        |
|0000000000000000000000000000000000                                                        |
|0000000000000000000000000000000000                                                        |
|0000000000000000000000000000000000                                                        |
|0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000|
|SY-REPID                                                                                      |
|RSHOST3M                                                                                  |
|0000000000000000000000000000000000000000                                                  |
|0000000000000000000000000000000000000000                                                  |
|5544553422222222222222222222222222222222                                                  |
|238F343D00000000000000000000000000000000                                                  |
|005200530048004F005300540033004D00200020002000200020002000200020002000200020002000200020002000|
|SY-MSGID                                                                                      |
|                                                                                              |
|00000000000000000000                                                                      |
|00000000000000000000                                                                      |
|22222222222222222222                                                                      |
|00000000000000000000                                                                      |
|00200020002000200020002000200020002000200020002000200020002000200020002000200020          |
|%_SSCR                                                                                        |
|        ## ###                                                                            |
|0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000|
|0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000|
|2222222200200022222222222222222222222222222222222222222222222222222222222222222222222222222222|
|0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000|
|0020002000200020002000200020002000000000002000000000000000200020002000200020002000200020002000|
|T_PARMNAME                                                                                    |
|                                                                                              |
|0000000000000000                                                                          |
|0000000000000000                                                                          |
|2222222222222222                                                                          |
|0000000000000000                                                                          |
|0020002000200020002000200020002000200020002000200020002000200020                          |
|SPACE                                                                                         |
|                                                                                              |
|0                                                                                         |
|0                                                                                         |
|2                                                                                         |
|0                                                                                         |
|0020                                                                                      |
|SY-MSGNO                                                                                      |
|000                                                                                       |
|000                                                                                       |
|000                                                                                       |
|333                                                                                       |
|000                                                                                       |
|003000300030                                                                              |
|TA_SPAG_SUM                                                                                   |
|################################################                                          |
|000000000000000000000000000000000000000000000000                                          |
|000000000000000000000000000000000000000000000000                                          |
|000000000000000000000000000000000000000000000000                                          |
|000000000000000000000000000000000000000000000000                                          |
|0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000|
|TA_STOR_SUM[]                                                                                 |
|Table[initial]                                                                            |
|                                                                                              |
|LOGIC_DESTIN_TBL[]                                                                            |
|Table IT_29[4x172]                                                                        |
|TA_POOL_ALL[]                                                                                 |
|Table[initial]                                                                            |
|                                                                                              |
|%_DUMMY$$                                                                                     |
|                                                                                              |
|0000                                                                                      |
|0000                                                                                      |
|2222                                                                                      |
|0000                                                                                      |
|0020002000200020                                                                          |
|TA_LAN_SUM                                                                                    |
|###    ###############                                                                |
|00000000000000000000000000                                                                |
|00000000000000000000000000                                                                |
|00022222222000000000000000                                                                |
|00000000000000000000000000                                                                |
|0000000000000020002000200020002000200020002000000000000000000000000000000000000000000000000000|
|T_TOP_SINGLE_SAVE                                                                             |
|##                            ##    ######                                        |
|00000000000000000000000000000000000000000000000000                                        |
|00000000000000000000000000000000000000000000000000                                        |
|00222222222222222222222222222222220022222222000000                                        |
|00000000000000000000000000000000000000000000000000                                        |
|0000000000200020002000200020002000200020002000200020002000200020002000200020002000200020002000|
|SY-SUBRC                                                                                      |
|0                                                                                         |
|0000                                                                                      |
|0000                                                                                      |
|00000000                                                                                  |
|%_ARCHIVE                                                                                     |
|                                                                                              |
|0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000|
|0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000|
|2222222222222222222222222222222222222222222222222222222222222222222222222222222222222222222222|
|0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000|
|0020002000200020002000200020002000200020002000200020002000200020002000200020002000200020002000|

----------------------------------------------------------------------------------------------------

----------------------------------------------------------------------------------------------------

|Application Information                                                                       |

----------------------------------------------------------------------------------------------------

|Index|Information                                                                             |

----------------------------------------------------------------------------------------------------

|1|System user, switch to SYNC_CPIC                                                        |
|2|System user, switch to SYNC_CPIC                                                        |
|3|System user, switch to SYNC_CPIC                                                        |
|4|System user, switch to SYNC_CPIC                                                        |
|5|System user, switch to SYNC_CPIC                                                        |

----------------------------------------------------------------------------------------------------

----------------------------------------------------------------------------------------------------

|Internal notes                                                                                |
|The termination was triggered in function "ab_HandleRsqlErrors"                           |
|of the SAP kernel, in line 724 of the module                                              |
| "//bas/720_REL/src/krn/runt/absapsql.c#24".                                              |
|The internal operation just processed is "SQLS".                                          |
|Internal mode was started at 20131216103441.                                              |
|Internal call code.........: "[RSQL/UPDT/LOGIC_DEST ]"                                    |
|Internal call code.........: "[RSQL/UPDT/LOGIC_DEST ]"                                    |

----------------------------------------------------------------------------------------------------

----------------------------------------------------------------------------------------------------

|Active Calls in SAP Kernel                                                                    |

----------------------------------------------------------------------------------------------------

|Lines of C Stack in Kernel (Structure Differs on Each Platform)                               |

----------------------------------------------------------------------------------------------------

|=> 64 bit R/3 Kernel                                                                          |
|=> 64 bit AIX Kernel                                                                          |
|=> Heap limit  = unlimited                                                                |
|=> Stack limit = 4294967295                                                               |
|=> Core limit  = 1073741312                                                               |
|=> File size limit = unlimited                                                                |
|=> Heap address  = 0x122d75e00                                                                |
|=> Stack address = 0xfffffffffff4cd0                                                          |
|=> Stack low =  0xfffffffffff4cd0                                                         |
|=> Stack high=  0xffffffffffff490                                                         |
|=> Stack Trace:                                                                               |
|    AixStack() at 0x10015cda4                                                                    |
|    CTrcStack2() at 0x10015cc98                                                                  |
|    rabax_CStackSave__Fv@AF172_21() at 0x1002f50e8                                               |
|    ab_rabax() at 0x1002e2f90                                                                    |
|    ab_rsqlerr__FPCUsiT1P11RS_HEADER94T1Pv() at 0x100763638                                      |
|    ab_HandleRsqlErrors__FR5Jsqls9RsqlError9CloseMode() at 0x1009bea88                           |
|    SqlsExecuteCall__FUcR5Jsqls() at 0x1009c9394                                                 |
|    ab_jsqls__Fv() at 0x1009c4bfc                                                                |
|    ab_extri__Fv() at 0x10078cd8c                                                                |
|    ab_xevent__FPCUs() at 0x100f97418                                                            |
|    ab_trigg__Fv() at 0x100f96c90                                                                |
|    ab_run() at 0x10154148c                                                                      |
|    N_ab_run() at 0x100f84650                                                                    |
|    dynpmcal() at 0x100f8a4ac                                                                    |
|    dynppai0() at 0x100f8771c                                                                    |
|    dynprctl() at 0x100f8954c                                                                    |
|    dynpen00() at 0x100a38004                                                                    |
|    Thdynpen00() at 0x100280eb8                                                                  |
|    Unknown at 0x100262e98                                                                       |
|    ThStart() at 0x10025f9b4                                                                     |
|    DpMain() at 0x100024fb4                                                                      |
|    nlsui_main() at 0x100000934                                                                  |

----------------------------------------------------------------------------------------------------

----------------------------------------------------------------------------------------------------

|Database Interface Information                                                                |

----------------------------------------------------------------------------------------------------

|C|1|   OCIStmtExecute() failed with -1=OCI_ERROR [dboci.c#4454]                               |
|C|1|   OCIStmtExecute() failed with -1=OCI_ERROR [dboci.c#4454]                               |
|C|1|   SQL error 60: [dboci.c#4455]                                                           |
|C|E|Error 60 in stmt_execute() from oci_execute_stmt(), orpc=0 [dbsloci.c#17261]              |
|C|E|ORA-00060 occurred at SQL stmt (parse error offset=0) [dbsloci.c#17262]                   |
|C|1|Dump statement cache: [dbsloci.c#17262]                                                   |

|C|1|sc_p=117ec59c0,no=158,idc_p=117edd460,con=0,act=1,slen=132,smax=256,#vars=6,stmt=1186a8d50,tab|

|C|1|UPDATE "LOGIC_DEST" SET "LODEST_TEX"=:A0 , "ALERT"=:A1 , "INSTANCE"=:A2 , "DB_SERVER"=:A3 , "A|

|C|1|EST"=:A4 WHERE "LOGIC_DEST"=:A5 ; [dbsc.c#2318]                                           |
|C|1|Dump statement cache: [dbsloci.c#12251]                                                   |

|C|1|sc_p=117ec59c0,no=158,idc_p=117edd460,con=0,act=1,slen=132,smax=256,#vars=6,stmt=1186a8d50,tab|

|C|1|Dumping stmt. cache (DBSL private attributes): [dbsloci.c#16677]                          |
|C|1|sc=117ec59c0, scp=117ed42b0, ups_sc=0000NULL, stp=118d6c178, r_c=0 [dbsloci.c#16679]      |
|C|1|prep=0, lit=0, nsql=0, lobret_cnt=0, fae_cnt=0, xop=2, dbcount=0 [dbsloci.c#16684]        |

|C|1|IN : col_cnt=6, row_max=1, row_xcnt=1, row_pcnt=0, row_i=0, row_total=1,  [dbsloci.c#16694]   |

|C|1| row_upto=4294967295, row_size=190, vda_max=32, bound=1, itp=118013010, vda_arr=118d6dc70 |
|C|1| lob_cnt=0, lob_max=0, lob_pw_cnt=0,  lob_arr=0000NULL, rows_ret=0 [dbsloci.c#16708]  |

|C|1|OUT: col_cnt=14, row_max=1, row_xcnt=0, row_pcnt=0, row_i=0, row_total=1,  [dbsloci.c#16694]  |

|C|1| row_upto=0, row_size=98, vda_max=64, bound=0, itp=0000NULL, vda_arr=118d6e510 [dbsloci.c#|
|C|1| lob_cnt=0, lob_max=0, lob_pw_cnt=0,  lob_arr=0000NULL, rows_ret=0 [dbsloci.c#16708]  |

|C|1|UPDATE "LOGIC_DEST" SET "LODEST_TEX"=:A0 , "ALERT"=:A1 , "INSTANCE"=:A2 , "DB_SERVER"=:A3 , "A|

|C|1|EST"=:A4 WHERE "LOGIC_DEST"=:A5 ; [dbsc.c#2318]                                           |
|B|E|***LOG BYO=> deadlock aborts transaction [dbsh#1190]                                      |

|B|1|SQL code: 60, SQL text: ORA-00060: deadlock detected while waiting for resource [dbsh.c#1198] |

|B|E|***LOG BY4=> sql error 60 performing UPD on table LOGIC_DEST                 [dbtrtab#|
|B|E|***LOG BY0=> ORA-00060: deadlock detected while waiting for resource [dbtrtab#3770]       |

----------------------------------------------------------------------------------------------------

----------------------------------------------------------------------------------------------------

|List of ABAP programs affected                                                                |

----------------------------------------------------------------------------------------------------

|Index |Typ|Program                             |Group |Date  |Time|Size |Lang.|

----------------------------------------------------------------------------------------------------

| 0|Prg|RSHOST3M                            | 0|10/25/2013|21:39:07|   132096|E    |
| 1|Prg|SAPMSSY0                            | 1|04/08/2011|14:18:15|   111616|E    |
| 2|Prg|SAPMSSYD                            | 1|10/21/2013|02:54:46|24576|E    |
| 3|Prg|SAPFSYSCALLS                        | 1|09/09/2004|14:18:32| 8192|E    |
| 4|Prg|RSDBRUNT                            | 0|10/21/2013|01:28:36|   306176|E    |
| 5|Typ|RSSCR                               | 0|03/30/2005|10:21:45| 5120|     |
| 6|Prg|RSDBSPBL                            | 0|08/27/2010|09:20:12|84992|E    |
| 7|Prg|SAPDB__S                            | 0|03/30/2005|10:22:01|21504|E    |
| 8|Prg|RSDBSPMC                            | 0|08/27/2010|09:06:46|92160|E    |
| 9|Typ|DDSHDESCR                           | 0|09/03/1997|03:05:16| 4096|     |
|10|Typ|SPPARAMS                            | 0|05/07/1997|13:10:38| 2048|     |
|11|Prg|SAPLSABE                            |11|06/10/2008|17:01:42|14336|E    |
|12|Prg|SAPLSECU                            |12|10/21/2013|00:47:10|   110592|E    |
|13|Typ|RSSUBINFO                           | 0|10/14/1999|22:01:03| 3072|     |
|14|Prg|SAPLSCNT                            |14|02/18/2005|14:16:06|34816|E    |
|15|Prg|SAPSHDTV                            |14|10/21/2013|02:54:46|38912|E    |
|16|Prg|SAPFS_SECLOG                        | 1|10/21/2013|02:47:56|16384|E    |
|17|Typ|INDX                                | 0|07/29/1998|18:38:15| 6144|     |
|18|Prg|SAPFGUICNTL                         | 1|02/18/2005|14:15:08|27648|E    |
|19|Prg|SAPLOLEA                            |19|04/08/2011|14:06:14|   110592|E    |
|20|Prg|SAPLSGUI                            |20|07/21/2010|13:12:18|   105472|E    |
|21|Prg|SAPLSTTM                            |21|08/03/2010|14:57:54|79872|E    |
|22|Prg|SAPLSBDC                            |22|07/17/2009|16:58:56|48128|E    |
|23|Prg|SAPLSFES                            |23|10/21/2013|02:46:14|   317440|E    |
|24|Prg|SAPLTHFB                            |24|06/01/2011|17:20:53|   472064|E    |
|25|Typ|WPINFO                              | 0|02/26/1999|14:49:01| 6144|     |
|26|Prg|SAPLURFC                            |26|10/21/2013|00:48:52|29696|E    |
|27|Prg|SAPLSPLUGIN                         |27|01/13/2010|11:04:09| 9216|E    |
|28|Typ|SWCBCONT                            | 0|11/15/2000|17:55:11| 3072|     |
|29|Typ|OLE_VERBS                           | 0|04/04/1995|16:02:20| 2048|     |
|30|Typ|OLE_PA                              | 0|04/04/1995|16:02:19| 2048|     |
|31|Prg|SAPLSTUJ                            |31|08/16/2006|12:05:56|13312|E    |
|32|Prg|SAPLSMON                            |32|10/25/2013|21:39:39|   540672|E    |
|33|Prg|/1BCDWBEN/SAPLSEN0003               |33|10/21/2013|05:20:33|   300032|E    |
|34|Prg|SAPLSENA                            |34|07/17/2009|16:05:18|39936|E    |
|35|Typ|LOGDSTHTBL                          | 0|07/04/1996|12:49:37| 2048|     |
|36|Typ|LOGDST2                             | 0|02/06/2001|14:27:41| 2048|     |
|37|Typ|MSXXLIST_V6                         | 0|02/13/2005|18:20:27| 4096|     |
|38|Typ|LOGIC_DEST                          | 0|02/06/2001|14:29:35| 3072|     |
|39|Typ|CPU_SUM                             | 0|11/30/1998|15:52:44| 4096|     |
|40|Typ|MEM_SUM                             | 0|04/04/1995|16:01:16| 4096|     |
|41|Typ|LAN_SUM                             | 0|04/04/1995|15:58:33| 3072|     |
|42|Typ|DSK_SUM                             | 0|04/04/1995|15:48:01| 3072|     |
|43|Typ|FSY_SINGLE                          | 0|04/04/1995|15:53:08| 3072|     |
|44|Typ|MONI                                | 0|10/25/2013|21:39:07| 5120|     |
|45|Prg|CX_SY_OPEN_SQL_DB=============CP    |45|07/17/2009|16:58:56|13312|E    |
|46|Prg|CX_SY_OPEN_SQL_ERROR==========CP    |46|07/17/2009|16:58:56|11264|E    |
|47|Prg|CX_SY_SQL_ERROR===============CP    |47|07/17/2009|16:58:56|11264|E    |
|48|Prg|CX_DYNAMIC_CHECK==============CP    |48|07/17/2009|16:58:56|11264|E    |
|49|Prg|CX_ROOT=======================CP    |49|07/21/2010|13:10:03|13312|E    |
|50|Prg|CX_NO_CHECK===================CP    |50|07/17/2009|16:58:56|11264|E    |
|51|Prg|CX_SY_NO_HANDLER==============CP    |51|07/17/2009|16:58:56|11264|E    |
|52|Prg|%_CSYDB0                            | 0|08/27/2010|09:06:44|40960|E    |
|53|Typ|RSVAMEMKEY                          | 0|05/07/1997|13:07:49| 2048|     |
|54|Prg|%_CRSDS                             | 0|02/18/2005|14:15:39|11264|E    |
|55|Prg|%_CSLIS                             |12|08/27/2010|09:04:00|96256|E    |
|56|Typ|DTC_S_LAYO                          | 0|12/04/2000|12:46:23| 7168|     |
|57|Typ|ETCF_SVARS                          | 0|05/18/2004|10:29:43| 2048|     |
|58|Typ|CAT_SVARS                           | 0|05/18/2004|10:32:36| 3072|     |
|59|Typ|SYST                                | 0|09/09/2004|14:18:12|30720|     |

----------------------------------------------------------------------------------------------------

----------------------------------------------------------------------------------------------------

|Directory of Application Tables                                                               |

----------------------------------------------------------------------------------------------------

|Name                                 Date   Time   Lngth                          |
|Val.                                                                                      |

----------------------------------------------------------------------------------------------------

|Program  RSHOST3M                                                                             |

----------------------------------------------------------------------------------------------------

|SYST                                 09/09/2004 14:18:12   00004612                       |
|\0\0\0\0\0\x0005\0\x0007\0\0\0\0\0\x0001\0\0\0\0\0\0\0                                    |
|SY                                     /  /   :  : 00004612                       |
|\0\0\0\0\0\x0005\0\x0007\0\0\0\0\0\x0001\0\0\0\0\0\0\0                                    |
|MONI                                   /  /   :  : 00002944                       |
|OS--saprf~1 00000000LOG \0\x0001  å######\0\0\xDD03\0####                          |

----------------------------------------------------------------------------------------------------

|Program  SAPFS_SECLOG                                                                         |

----------------------------------------------------------------------------------------------------

|INDX                                   /  /   :  : 00003104                       |
|000%L%_SeclogExcludedCaller\0\0\0  00000000                                               |

----------------------------------------------------------------------------------------------------

|Program  SAPLSMON                                                                             |

----------------------------------------------------------------------------------------------------

|LOGIC_DEST                             /  /   :  : 00000190                       |
|SAPOSCOL_SAPRF              automatically generated DB                                |
|MONI                                   /  /   :  : 00002944                       |
|                        \0\0  \0\0\0\0\0\0\0\0\0\0\0\0\0\0                                |

----------------------------------------------------------------------------------------------------

----------------------------------------------------------------------------------------------------

|ABAP Control Blocks (CONT)                                                                    |

----------------------------------------------------------------------------------------------------

|Index|Name|Fl|PAR0|PAR1|PAR2|PAR3|PAR4|PAR5|PAR6|Source Code                         |Line|

----------------------------------------------------------------------------------------------------

|20131|1393|  ||||||||                                    |    |
|15238|comp|00|02DB|C00A|C007|||||LSMONU31                            | 109|
|15240|BRAF|02|0015|||||||LSMONU31                            | 109|
|15241|BREL|80|0000|||||||LSMONU31                            | 109|
|15242|mlq1|02|8200|0042|0058|||||LSMONU31                            | 110|
|15244|mlq1|02|8400|0042|0058|||||LSMONU31                            | 111|
|15246|mlq1|02|8000|00C2|0058|||||LSMONU31                            | 113|
|15248|mvqk|BE|0880|0000|0008|||||LSMONU31                            | 114|
|15250|SQLS|25|0000|||||||LSMONU31                            | 115|
|15251|SQLS|00|0144|||||||LSMONU31                            | 115|
|15252|PAR1|00|01D5|||||||LSMONU31                            | 115|
|15253|SQLS|39|0128|||||||LSMONU31                            | 115|
|>>>>>|SQLS|11|0142|||||||LSMONU31                            | 115|
|15255|cmpr|00|00E2|0149|0000|||||LSMONU31                            | 116|
|15257|BRAF|05|0003|||||||LSMONU31                            | 116|
|15258|BREL|80|0000|||||||LSMONU31                            | 116|
|15259|FUNE|03|0141|||||||LSMONU31                            | 117|
|15260|BRAX|00|0016|||||||LSMONU31                            | 119|
|15261|comp|00|02DB|C014|0007|||||LSMONU31                            | 119|
|15263|BRAF|02|0013|||||||LSMONU31                            | 119|

----------------------------------------------------------------------------------------------------

Former Member
replied

Hello

There is a job (I believe some jobs related to monitoring) trying running under the user IBMSUPPORT trying to update the table LOGIC_DEST and resulting in a deadlock.

You can find the details about the deadlock at /oracle/PR1/saptrace/usertrace location.

Check the jobs scheduled under the user IBMSUPPORT and what this job is doing.

If there are multiple jobs scheduled at the same time and trying to update the table then that can end in a deadlock situation.

Regards

RB

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question