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 ONE Support launchpad (Login required).

Search for additional results

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