SAP Knowledge Base Article - Preview

3004272 - Program SAPLAI_SOLMAN_SVCP_EXTRACTORS reporting TIME_OUT dumps

Symptom

You're seeing the following dumps being reported by program SAPLAI_SOLMAN_SVCP_EXTRACTORS, function module E2E_ITSM_DATA_LOADER_CUBE.
-------------------------------------------------------------------------------------------------------------------
Category ABAP Programming Error
Runtime Errors TIME_OUT
ABAP Program CX_SQL_EXCEPTION==============CP
Application Component BC-DB-DBI
Date and Time 30.10.2020 01:37:16
-------------------------------------------------------------------------------------------------------------------
Short Text
Time limit exceeded
-------------------------------------------------------------------------------------------------------------------
What happened?
Program "CX_SQL_EXCEPTION==============CP" has exceeded the maximum
uninterrrupted runtime and has
therefore been terminated.
-------------------------------------------------------------------------------------------------------------------
Call program...........SAPLAI_SOLMAN_SVCP_EXTRACTORS
Function module..... E2E_ITSM_DATA_LOADER_CUBE
-------------------------------------------------------------------------------------------------------------------

Transaction code SM21 reports lock-wait timeouts coinciding with the dumps.
-------------------------------------------------------------------------------------------------------------------
30.10.2020|01:37:16|SM_EFWK |Database error -911 at EXE
30.10.2020|01:37:16|SM_EFWK |> SQL0911N The current transaction has been rolled back
30.10.2020|01:37:16|SM_EFWK |> because of a deadlock or timeout. Reason code "68".
30.10.2020|01:37:16|SM_EFWK |> SQLSTATE=40001 row=1
30.10.2020|01:37:16|SM_EFWK |Deadlock occurred
30.10.2020|01:37:17|SM_EFWK |Runtime error "TIME_OUT" occurred.
30.10.2020|01:37:18|SM_EFWK |> Short dump "201030 013716 INBLR-V-SM3_SM3_01 SM_EFWK" created.
-------------------------------------------------------------------------------------------------------------------

Checking the developer trace in DIR_HOME you see the INSERT statement timeing out due to LOCKTIMEOUT period expiring.
-------------------------------------------------------------------------------------------------------------------
C Fri Oct 30 01:37:16:882 2020
C *** ERROR in DB6Execute[/bas/753_REL/src/dbs/db6/dbdb6.c, 5483] CON = 1 CACHEID = 2 (BEGIN)
C &+*** dsql_db6_exec( SQLExecute ): [IBM][CLI Driver][DB2/AIX64] SQL0911N The current transaction has been rolled back
C &+*** Because of a deadlock or timeout. Reason code "68". SQLSTATE=40001 row=1
C &+***
C &+*** INSERT INTO "/BI0/0100000395"("KEY_0SPRCMCUP","SID_0CALDAY","SID_0CALMONTH","SID_0CALQUARTER","SID_0CALWEEK","SID_
C &+*** 0CALYEAR","SID_0SPRCATLV1","SID_0SPRCATLV2","SID_0SPRCATLV3","SID_0SPRCATLV4","SID_0SPRCDAY","SID_0SPRCMON","SID_0
C &+*** SPRCOMPL","SID_0SPRCQUA","SID_0SPRCREATED","SID_0SPRCREATEM","SID_0SPRCREATEQ","SID_0SPRCREATET","SID_0SPRCREATEW"
................................................
................................................
C &+*** E."SID_0SPRCMCAT" AND FS."SID_0SPR_SID" = E."SID_0SPR_SID" AND FS."SID_0SPR_LINS" = E."SID_0SPR_LINS" AND FS."SID
C &+*** _0SPR_LUID" = E."SID_0SPR_LUID" AND FS."SID_0SPRSHEMID" = E."SID_0SPRSHEMID" AND FS."SID_0SPRPRODID" = E."SID_0SPR
C &+*** PRODID" /* <OPTGUIDELINES><DEGREE VALUE="ANY"/> </OPTGUIDELINES> */
-------------------------------------------------------------------------------------------------------------------

Transaction code DB01 shows statement holding the lock as the following SELECT statement.
-------------------------------------------------------------------------------------------------------------------
Dynamic SQL statement text:
SELECT VERSION, UUID, CRTIMESTMP, ABTIMESTMP, DYTIMESTMP, FLDCNT, TABLENGTH, KEYCNT, KEYLENGTH, CLIENTPOS, TABTYPE, TABFORM, R
EFNAME, HFLAG, BUFSTATE, BUFPARM, ALIGN, POINTERLG, UNICODELG, COMPCNT, LEAFCNT FROM "DDNTT" WHERE TABNAME = ?
WITH CS -- OPTLEVEL( 5 ) -- QUERY_DEGREE( 1 ) -- SYSTEM( SAP , SAPSAP )
-------------------------------------------------------------------------------------------------------------------


Read more...

Environment

  • SAP Netweaver AS
  • SAP Business Warehouse
  • IBM DB2 LUW (DB6)

Product

SAP NetWeaver all versions ; SAP Solution Manager 7.2

Keywords

CL_RSCDS_METHODS_IMPL_DB6=====CP SAPMSSY1 SM_EFWK Lock-wait SOLMAN Solution Manager Infocube Compression , KBA , BW-SYS-DB-DB6 , BW DB2 Universal Database , BC-DB-DB6 , DB2 Universal Database for Unix / NT , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.