2516459 - How to recreate a user temporary database for missing its device files | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2516459 - How to recreate a user temporary database for missing its device files

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: BWP
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/BWP/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

  • ASE 15.7 ESD#3 for AIX

Product

SAP NetWeaver 7.3

Keywords

  • disk init, create temporary database, sp_tempdb
, KBA , BC-DB-SYB , SAP Business Suite on Sybase ASE Database Platform , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , 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.