SAP Knowledge Base Article - Preview

2498396 - SQL0901N ADM14005E FODC ADM0001C DIA0505I DIA0506I DIA0505I DIA0506I XML components dump

Symptom

  • db2diag.log contains:
       MESSAGE : ADM14005E  The following error occurred: "AppErr".  First Occurrence Data Capture (FODC) has been invoked in the following mode: "Automatic".  Diagnostic information has been recorded in the directory named 
          "/db2/<SID>/db2dump/FODC_AppErr_YYYY-MM-DD-HH.MM.SS.######_########_#####_###"
       MESSAGE : ADM0001C  A severe error has occurred.  Examine the administration notification log and contact IBM Support if necessary.
       LEVEL: Severe sqlcode: -901
       MESSAGE : DIA0505I Execution of a component signal handling function has begun.
       LEVEL: Severe PROC : db2sysc 0  FUNCTION: DB2 UDB, relation data serv, sqlrr_signal_handler XML components dump
       MESSAGE : DIA0506I Execution of a component signal handling function is complete.
       LEVEL: Severe PROC : db2sysc 0 FUNCTION: DB2 UDB, relation data serv, sqlrr_dump_ffdc XML components dump
       LEVEL: Severe Title: XMLC CB
          Dump File:/db2/<SID>/db2dump/FODC_AppErr_YYYY-MM-DD-HH.MM.SS.######_########_#####_###/########.#####.###.dump.bin
  • db2diag.log also contains SQL statement involved:
      SELECT /* FDA WRITE */ DISTINCT  "AI_CM_TRSP_OBJ_V"."SYS_NAME", "AI_CM_TRSP_OBJ_V"."SYS_TYPE", "AI_CM_TRSP_OBJ_V"."TRKORR", "AI_CM_TRSP_OBJ_V"."PROGRAM_ID",
           "AI_CM_TRSP_OBJ_V"."OBJECT_TYPE", "AI_CM_TRSP_OBJ_V"."OBJECT_NAME", "AI_CM_TRSP_OBJ_V"."TABLE_KEY", "AI_CM_TRSP_OBJ_V"."SUB_PROGRAM_ID",
           "AI_CM_TRSP_OBJ_V"."SUB_OBJECT_TYPE", "AI_CM_TRSP_OBJ_V"."SUB_OBJECT_NAME", "AI_CM_TRSP_OBJ_V"."DEV_PACKAGE"
      FROM "AI_CM_TRSP_OBJ_V",
         TABLE( SAPTOOLS.MEMORY_TABLE( CAST( ? AS BLOB( 2G )) ) CARDINALITY 1 ) AS "t_00" ( "C_0" VARCHAR(24) , "C_1" VARCHAR(48) , "C_2" VARCHAR(60) )
            WHERE "AI_CM_TRSP_OBJ_V"."SYS_NAME" = "t_00"."C_0" AND "AI_CM_TRSP_OBJ_V"."SYS_TYPE" = "t_00"."C_1" AND "AI_CM_TRSP_OBJ_V"."TRKORR" = "t_00"."C_2"
            WITH UR -- OPTLEVEL( 5 ) -- QUERY_DEGREE( 1 ) -- LOCATION( CL_ESH_EX_GENERIC_TO_PROVIDER=CP , 2551 ) -- SYSTEM( <SID> , SAP<SID> )
  • SQL0901N  The SQL statement or command failed because of a database system error. (Reason "this pred does not push to all branch".)  SQLSTATE=58004


Read more...

Environment

DB2 LUW

Product

SAP Solution Manager 7.2

Keywords

db2diag.log MESSAGE
ADM14005E  The following error occurred AppErr First Occurrence Data Capture FODC has been invoked in the following mode Automatic Diagnostic information has been recorded in the directory named db2 db2dump FODC_AppErr 
ADM0001C  A severe error has occurred Examine the administration notification log and contact IBM Support if necessary sqlcode: -901
DIA0506I Execution of a component signal handling function is complete
DIA0505I has begun
LEVEL Severe PROC db2sysc 0  FUNCTION DB2 UDB relation data serv sqlrr_signal_handler XML components dump sqlrr_dump_ffdc Title XMLC CB dump.bin
SELECT /* FDA WRITE */ DISTINCT FROM TABLE SAPTOOLS MEMORY_TABLE CAST AS BLOB 2G CARDINALITY 1 AS t_00 C_0 VARCHAR 24 C_1 VARCHAR 48 C_2 VARCHAR 60 WHERE SYS_NAME AND SYS_TYPE TRKORR WITH UR OPTLEVEL 5 QUERY_DEGREE 1 LOCATION CL_ESH_EX_GENERIC_TO_PROVIDER CP 2551 SYSTEM SAP
SQL0901N  The SQL statement or command failed because of a database system error Reason this pred does not push to all branch  SQLSTATE 58004
SQL0313N  The number of variables in the EXECUTE statement the number of variables in the OPEN statement or the number of arguments in an OPEN statement for a parameterized cursor is not equal to the number of values required SQLSTATE 07004 , KBA , 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.