Symptom
There are no data of table space usage from DBA Cockpit.
- All Basis standard jobs are correctly scheduled, data collector configuration are also configured.
- Actually data are displayed in our DEV and QAS systems but not in our PRD system.
- We also checked if there were sapnotes implemented on our DEV and QAS corresponding to DBACOCKPIT but, all 3 systems are in synch with regards to sapnotes implementation.
- There're some exception messages for Tables object of Data Collectors and Admin Procedures
Message Details:
Exception CX_DBA_RDI in class CL_DBA_RDI_QUERY method IF_DBA_RDI_QUERY~COLLECT line 199
Kernel Error ID:
WP ID: 4
WP PID: 22675650
SYSID:
SY-SUBRC: 0
SY-TABIX: 0
Message: Repair data collector!
Database:
caused by
Exception CX_DBA_DBH_SETUP in class CL_SYB_DBH_COLLECTOR method IF_DBA_DBH_COLLECTOR~COLLECT line 45
Kernel Error ID:
WP ID: 4
WP PID: 22675650
SYSID:
SY-SUBRC: 0
SY-TABIX: 0
Message: Unable to call procedure 'saptools..SP_DBH_TABLES'!
Database:
caused by
Exception CX_DBA_ADBC in program SAPMHTTP line 0
Kernel Error ID:
WP ID: 4
WP PID: 22675650
SYSID: SID
SY-SUBRC: 0
SQL statement: saptools..SP_DBH_TABLES
Database: +++SYBADM
caused by
Exception CX_SQL_EXCEPTION in class CL_SQL_STATEMENT
Kernel Error ID:
DB Error: Yes
SQL Code: 208
SQL Message: [ASE Error SQL840]Device 'tempdb2prd' (with physical name '/sybase/SID/sybtemp2/tempdb2prd.dat', and virtual device number 13) has not been correctly activated at startup time. Please contact a user with System Administrator (SA) role.
[ASE Error SQL208:
DB Object Exists: No
Duplicated Key: No
Internal Error: 5
Invalid Cursor: No
Unknown Connection: No
Connection Closed: No
Read more...
Environment
- SAP Adaptive Server Enterprise (ASE) 15.7 ESD#3 AIX for Business Suite
- SAP NetWeaver (NW) - All versions
Product
Keywords
- disk init, create temporary database, sp_tempdb
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.