Symptom
- When trying to setup "System Waits" collector in DBA Cockpit, you get the following error message:
[ASE Error SQL2714][SAP][ASE ODBC Driver][Adaptive Server Enterprise]There is already an object named 'DBH_STG_SYSWAITS' in the database
- Here is complete error message from the collector information:
Exception CX_DBA_DBH_SETUP in class CL_SYB_DBH_COLLECTOR method
IF_DBA_DBH_COLLECTOR~INSTALL line 60
Kernel Error ID:
WP ID: 35
WP PID: 11331
Application Server: solman
SYSID:
SY-SUBRC: 0
SY-TABIX: 0
Message: Error in RDI back-end setup occured!
Database:
caused by
Exception CX_DBA_RDI_SETUP in class CL_SYB_RDI_DBO_TABLE method IF_DBA_RDI_DBO~CREATE line 103
Kernel Error ID:
WP ID: 35
WP PID: 11331
Application Server: solman
SYSID:
SY-SUBRC: 0
SY-TABIX: 0
Message: Unable to create table 'saptools..DBH_STG_SYSWAITS'!
Database:
caused by
Exception CX_DBA_ADBC in program SAPMHTTP line 0
Kernel Error ID:
WP ID: 35
WP PID: 11331
Application Server: solman
SYSID: <SYSID>
SY-SUBRC: 0
SQL statement: CREATE TABLE saptools..DBH_STG_SYSWAITS ( "COLLECT_MODE" CHARACTER(1), "InstanceID" TINYINT DEFAULT 0, "SNAPSHOT_TIMESTAMP" BIGDATETIME DEFAULT current_bigdatetime(), "SOURCE_HOSTNAME" VARCHAR(60)
DEFAULT '', "TIME_PERIOD" INTEGER, "WaitClassID" SMALLINT, "WaitEventID" SMALLINT DEFAULT 0, "WaitTime" BIGINT, "Waits" BIGINT) LOCK DATAROWS WITH COMPRESSION = PAGE
Database: <SYSID>
caused by
Exception CX_SQL_EXCEPTION in class CL_SYB_RDI_QUERY
Kernel Error ID:
DB Error: Yes
SQL Code: 2714
SQL Message: [ASE Error SQL2714][SAP][ASE ODBC Driver][Adaptive Server Enterprise]There is already an object named 'DBH_STG_SYSWAITS' in the database.
Read more...
Environment
- SAP Adaptive Server Enterprise (ASE) 15.7 and 16.0 for Business Suite
- SAP Solution Manager (SOLMAN) 7.1
Product
Keywords
SQL2714, 2714, DBH_STG_SYSWAITS, CX_SQL_EXCEPTION, CL_SYB_RDI_QUERY, DBACOCKPIT , KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , SV-SMG-DIA , Diagnostics , 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.