Skip to Content
0
Former Member
Jun 14, 2011 at 05:03 AM

Error in CCMS monitoring Batch job SAP_CCMS_MONI_BATCH_DP.

210 Views

Hi All,

I am using a Sanbox system for CCMS Monitoring activities. I assigned a method CCMS_ONAlert_Email under auto reaction to the MTE class ABAP shortdumps on node System errors. So the requirement is when an alert triggered i have to receive an alert email. I just found there is an error in Batch job created for Alert monitoring, please find the error details mentioned below. Please let me know how to solve this error

Job started

Step 001 started (program RSAL_BATCH_TOOL_DISPATCHING, variant , user ID NBKIPXP)

:Exception CX_DBA_ADBC in class CL_DB6_RDI method GET_SNAPSHOT line 431

: Kernel Error ID:

: SYSID: ES1

: SY-SUBRC: 1208

: Message: ADBC error

: SQL statement: SELECT '20110613075617',0 as DB6PMCF_PARTITION,FS_NAM

: E,'T','20110521174003','700',FREE_KB,USED_KB,TOTAL_KB,NUM_IUSED,PCT_IU

: SED FROM SYSIBM.SYSDUMMY1, TABLE(SAPTOOLS.DB6PMCF('/db2/ES1/sapdata1')

: ) AS FS_CONFIG

: Database:

:caused by

:Exception CX_SQL_EXCEPTIONin class CL_SQL_RESULT_SET

: Kernel Error ID:

: DB Error: Yes

: SQL Code: 444-

: SQL Message: SQL0444N Routine "SAPTOOLS.DB6PMCF" (specific name "D

: B6PMCF") is implemented with code in library orpath "/usr/sap/ED2/SYS

: /exe/run/db6pmudf", function "Db6pmcf" which cannot be accessed. Reas

: on code: "4". SQLSTATE=42724

: DB Object Exists: No

: Duplicated Key: No

: Internal Error: 1

: Invalid Cursor: No

: Unknown Connection: No

: Connection Closed: No

Exception CX_DBA_ADBC in class CL_DB6_RDI method GET_SNAPSHOT line 431

:Exception CX_DBA_ADBC in class CL_DB6_RDI method GET_SNAPSHOT line 431

: Kernel Error ID:

: SYSID: ES1

: SY-SUBRC: 1208

: Message: ADBC error

: SQL statement: SELECT '20110613075633',0 as DB6PMCF_PARTITION,FS_NAM

: E,'T','20110521174003','700',FREE_KB,USED_KB,TOTAL_KB,NUM_IUSED,PCT_IU

: SED FROM SYSIBM.SYSDUMMY1, TABLE(SAPTOOLS.DB6PMCF('/db2/ES1/log_dir/NO

: DE0000/') ) AS FS_CONFIG

: Database:

:caused by

:Exception CX_SQL_EXCEPTION in class CL_SQL_RESULT_SET

: Kernel Error ID:

: DB Error: Yes

: SQL Code: 444-

: SQL Message: SQL0444N Routine "SAPTOOLS.DB6PMCF" (specific name "D

: B6PMCF") is implemented with code in library orpath "/usr/sap/ED2/SYS

: /exe/run/db6pmudf", function "Db6pmcf" which cannot be accessed. Reas

: on code: "4". SQLSTATE=42724

: DB Object Exists: No

: Duplicated Key: No

: Internal Error: 1

: Invalid Cursor: No

: Unknown Connection: No

: Connection Closed: No

Exception CX_DBA_ADBC in class CL_DB6_RDI method GET_SNAPSHOT line 431

:Exception CX_DBA_ADBC in class CL_DB6_RDI method GET_SNAPSHOT line 431

: Kernel Error ID:

: SYSID: ES1

: SY-SUBRC: 1208

: Message: ADBC error

: SQL statement: SELECT '20110613075633',0 as DB6PMCF_PARTITION,FS_NAM

: E,'T','20110521174003','700',FREE_KB,USED_KB,TOTAL_KB,NUM_IUSED,PCT_IU

: SED FROM SYSIBM.SYSDUMMY1, TABLE(SAPTOOLS.DB6PMCF('/db2/ES1/sapdata4/d

: b2es1/NODE0000/ES1/T0000003/C0000000.TMP') ) ASFS_CONFIG

: Database:

:caused by

:Exception CX_SQL_EXCEPTION in class CL_SQL_RESULT_SET

: Kernel Error ID:

: DB Error: Yes

: SQL Code: 444-

: SQL Message: SQL0444N Routine "SAPTOOLS.DB6PMCF" (specific name "D

: B6PMCF") is implemented with code in library orpath "/usr/sap/ED2/SYS

: /exe/run/db6pmudf", function "Db6pmcf" which cannot be accessed. Reas

: on code: "4". SQLSTATE=42724

: DB Object Exists: No

: Duplicated Key: No

: Internal Error: 1

: Invalid Cursor: No

: Unknown Connection: No

: Connection Closed: No

Exception CX_DBA_ADBC in class CL_DB6_RDI method GET_SNAPSHOT line 431

:Exception CX_DBA_ADBC in class CL_DB6_RDI method GET_SNAPSHOT line 431

: Kernel Error ID:

: SYSID: ES1

: SY-SUBRC: 1208

: Message: ADBC error

: SQL statement: SELECT '20110613075634',0 as DB6PMCF_PARTITION,FS_NAM

: E,'T','20110521174003','700',FREE_KB,USED_KB,TOTAL_KB,NUM_IUSED,PCT_IU

: SED FROM SYSIBM.SYSDUMMY1, TABLE(SAPTOOLS.DB6PMCF('/db2/ES1/sapdata2/d

: b2es1/NODE0000/ES1/T0000003/C0000001.TMP') ) ASFS_CONFIG

: Database:

:caused by

:Exception CX_SQL_EXCEPTION in class CL_SQL_RESULT_SET

: Kernel Error ID:

: DB Error: Yes

: SQL Code: 444-

: SQL Message: SQL0444N Routine "SAPTOOLS.DB6PMCF" (specific name "D

: B6PMCF") is implemented with code in library orpath "/usr/sap/ED2/SYS

: /exe/run/db6pmudf", function "Db6pmcf" which cannot be accessed. Reas

: on code: "4". SQLSTATE=42724

: DB Object Exists: No

: Duplicated Key: No

: Internal Error: 1

: Invalid Cursor: No

: Unknown Connection: No

: Connection Closed: No

Exception CX_DBA_ADBC in class CL_DB6_RDI method GET_SNAPSHOT line 431

:Exception CX_DBA_ADBC in class CL_DB6_RDI method GET_SNAPSHOT line 431

: Kernel Error ID:

: SYSID: ES1

: SY-SUBRC: 1208

: Message: ADBC error

: SQL statement: SELECT '20110613075634',0 as DB6PMCF_PARTITION,FS_NAM

: E,'T','20110521174003','700',FREE_KB,USED_KB,TOTAL_KB,NUM_IUSED,PCT_IU

: SED FROM SYSIBM.SYSDUMMY1, TABLE(SAPTOOLS.DB6PMCF('/db2/ES1/sapdata1/d

: b2es1/NODE0000/ES1/T0000003/C0000002.TMP') ) ASFS_CONFIG

: Database:

:caused by

:Exception CX_SQL_EXCEPTION in class CL_SQL_RESULT_SET

: Kernel Error ID:

: DB Error: Yes

: SQL Code: 444-

: SQL Message: SQL0444N Routine "SAPTOOLS.DB6PMCF" (specific name "D

: B6PMCF") is implemented with code in library orpath "/usr/sap/ED2/SYS

: /exe/run/db6pmudf", function "Db6pmcf" which cannot be accessed. Reas

: on code: "4". SQLSTATE=42724

: DB Object Exists: No

: Duplicated Key: No

: Internal Error: 1

: Invalid Cursor: No

: Unknown Connection: No

: Connection Closed: No

Exception CX_DBA_ADBC in class CL_DB6_RDI method GET_SNAPSHOT line 431

:Exception CX_DBA_ADBC in class CL_DB6_RDI method GET_SNAPSHOT line 431

: Kernel Error ID:

: SYSID: ES1

: SY-SUBRC: 1208

: Message: ADBC error

: SQL statement: SELECT '20110613075634',0 as DB6PMCF_PARTITION,FS_NAM

: E,'T','20110521174003','700',FREE_KB,USED_KB,TOTAL_KB,NUM_IUSED,PCT_IU

: SED FROM SYSIBM.SYSDUMMY1, TABLE(SAPTOOLS.DB6PMCF('/db2/ES1/sapdata3/d

: b2es1/NODE0000/ES1/T0000003/C0000003.TMP') ) ASFS_CONFIG

: Database:

:caused by

:Exception CX_SQL_EXCEPTION in class CL_SQL_RESULT_SET

: Kernel Error ID:

: DB Error: Yes

: SQL Code: 444-

: SQL Message: SQL0444N Routine "SAPTOOLS.DB6PMCF" (specific name "D

: B6PMCF") is implemented with code in library orpath "/usr/sap/ED2/SYS

: /exe/run/db6pmudf", function "Db6pmcf" which cannot be accessed. Reas

: on code: "4". SQLSTATE=42724

: DB Object Exists: No

: Duplicated Key: No

: Internal Error: 1

: Invalid Cursor: No

: Unknown Connection: No

: Connection Closed: No

Exception CX_DBA_ADBC in class CL_DB6_RDI method GET_SNAPSHOT line 431

:Exception CX_DBA_ADBC in class CL_DB6_RDI method GET_SNAPSHOT line 431

: Kernel Error ID:

: SYSID: ES1

: SY-SUBRC: 1208

: Message: ADBC error

: SQL statement: SELECT '20110613075634',0 as DB6PMCF_PARTITION,FS_NAM

: E,'T','20110521174003','700',FREE_KB,USED_KB,TOTAL_KB,NUM_IUSED,PCT_IU

: SED FROM SYSIBM.SYSDUMMY1, TABLE(SAPTOOLS.DB6PMCF('/db2/ES1/sapdata3/d

: b2es1/NODE0000/ES1/T0000004/C0000003.UTM') ) ASFS_CONFIG

: Database:

:caused by

:Exception CX_SQL_EXCEPTION in class CL_SQL_RESULT_SET

: Kernel Error ID:

: DB Error: Yes

: SQL Code: 444-

: SQL Message: SQL0444N Routine "SAPTOOLS.DB6PMCF" (specific name "D

: B6PMCF") is implemented with code in library orpath "/usr/sap/ED2/SYS

: /exe/run/db6pmudf", function "Db6pmcf" which cannot be accessed. Reas

: on code: "4". SQLSTATE=42724

: DB Object Exists: No

: Duplicated Key: No

: Internal Error: 1

: Invalid Cursor: No

: Unknown Connection: No

: Connection Closed: No

Exception CX_DBA_ADBC in class CL_DB6_RDI method GET_SNAPSHOT line 431

:Exception CX_DBA_ADBC in class CL_DB6_RDI method GET_SNAPSHOT line 431

: Kernel Error ID:

SYSID: ES1

SY-SUBRC: 1208

Message: ADBC error

SQL statement: SELECT '20110613075634',0 as DB6PMCF_PARTITION,FS_NAM

E,'T','20110521174003','700',FREE_KB,USED_KB,TOTAL_KB,NUM_IUSED,PCT_IU

SED FROM SYSIBM.SYSDUMMY1, TABLE(SAPTOOLS.DB6PMCF('/db2/ES1/sapdata4/d

b2es1/NODE0000/ES1/T0000004/C0000000.UTM') ) ASFS_CONFIG

Database:

caused by

Exception CX_SQL_EXCEPTION in class CL_SQL_RESULT_SET

Kernel Error ID:

DB Error: Yes

SQL Code: 444-

SQL Message: SQL0444N Routine "SAPTOOLS.DB6PMCF" (specific name "D

B6PMCF") is implemented with code in library orpath "/usr/sap/ED2/SYS

/exe/run/db6pmudf", function "Db6pmcf" which cannot be accessed. Reas

on code: "4". SQLSTATE=42724

DB Object Exists: No

Duplicated Key: No

Internal Error: 1

Invalid Cursor: No

Unknown Connection: No

Connection Closed: No

xception CX_DBA_ADBC in class CL_DB6_RDI method GET_SNAPSHOT line 431

Exception CX_DBA_ADBC in class CL_DB6_RDI method GET_SNAPSHOT line 431

Kernel Error ID:

SYSID: ES1

SY-SUBRC: 1208

Message: ADBC error

SQL statement: SELECT '20110613075634',0 as DB6PMCF_PARTITION,FS_NAM

E,'T','20110521174003','700',FREE_KB,USED_KB,TOTAL_KB,NUM_IUSED,PCT_IU

: SED FROM SYSIBM.SYSDUMMY1, TABLE(SAPTOOLS.DB6PMCF('/db2/ES1/sapdata2/d

: b2es1/NODE0000/ES1/T0000004/C0000001.UTM') ) ASFS_CONFIG

: Database:

:caused by

:Exception CX_SQL_EXCEPTION in class CL_SQL_RESULT_SET

: Kernel Error ID:

: DB Error: Yes

: SQL Code: 444-

: SQL Message: SQL0444N Routine "SAPTOOLS.DB6PMCF" (specific name "D

: B6PMCF") is implemented with code in library orpath "/usr/sap/ED2/SYS

: /exe/run/db6pmudf", function "Db6pmcf" which cannot be accessed. Reas

: on code: "4". SQLSTATE=42724

: DB Object Exists: No

: Duplicated Key: No

: Internal Error: 1

: Invalid Cursor: No

: Unknown Connection: No

: Connection Closed: No

Exception CX_DBA_ADBC in class CL_DB6_RDI method GET_SNAPSHOT line 431

:Exception CX_DBA_ADBC in class CL_DB6_RDI method GET_SNAPSHOT line 431

: Kernel Error ID:

: SYSID: ES1

: SY-SUBRC: 1208

: Message: ADBC error

: SQL statement: SELECT '20110613075634',0 as DB6PMCF_PARTITION,FS_NAM

: E,'T','20110521174003','700',FREE_KB,USED_KB,TOTAL_KB,NUM_IUSED,PCT_IU

: SED FROM SYSIBM.SYSDUMMY1, TABLE(SAPTOOLS.DB6PMCF('/db2/ES1/sapdata1/d

: b2es1/NODE0000/ES1/T0000004/C0000002.UTM') ) ASFS_CONFIG

: Database:

:caused by

:Exception CX_SQL_EXCEPTION in class CL_SQL_RESULT_SET

: Kernel Error ID:

: DB Error: Yes

: SQL Code: 444-

: SQL Message: SQL0444N Routine "SAPTOOLS.DB6PMCF" (specific name "D

: B6PMCF") is implemented with code in library orpath "/usr/sap/ED2/SYS

: /exe/run/db6pmudf", function "Db6pmcf" which cannot be accessed. Reas

: on code: "4". SQLSTATE=42724

: DB Object Exists: No

: Duplicated Key: No

: Internal Error: 1

: Invalid Cursor: No

: Unknown Connection: No

: Connection Closed: No

Exception CX_DBA_ADBC in class CL_DB6_RDI method GET_SNAPSHOT line 431

Job finished