SAP Knowledge Base Article - Preview

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

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

SAP NetWeaver 7.3

Keywords

  • disk init, create temporary database, sp_tempdb
, KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , 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 for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.