cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Error in CCMS monitoring Batch job SAP_CCMS_MONI_BATCH_DP.

Former Member

on ‎06-14-2011 6:03 AM

0 Kudos

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

Show replies
Show replies
Answer

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
‎06-14-2011 6:57 AM
0 Kudos

Hi Dinesh,

Please check the note is applicable for you [Note 978319 - DB6: Incorrectly cataloged table functions|https://websmp230.sap-ag.de/sap(bD1lbiZjPTAwMQ==)/bc/bsp/spn/sapnotes/index2.htm?numm=978319]

so please check wheter db2<sid>user has enough permission

Thanks,

Jansi

Show replies
Show replies
Former Member
‎06-14-2011 7:12 AM
0 Kudos

Hi Jansi,

Thanks for your response.

The Note link which you have provided requires authentication but i dont have access to it. So could you please explain briefly or give me some other link.

Former Member
‎06-14-2011 6:05 AM
0 Kudos

For your information Sap connect is configured in that system and i tested by sending an email from SBWP , it is working i can receive email.

Show replies
Show replies
Ask a Question