SAP Knowledge Base Article - Preview

2280377 - Error SQL2714 in table DBH_STG_SYSWAITS table - SAP ASE for Business Suite

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

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0 ; SAP Solution Manager 7.1

Keywords

SQL2714, 2714, DBH_STG_SYSWAITS, CX_SQL_EXCEPTION, CL_SYB_RDI_QUERY, DBACOCKPIT , KBA , BC-DB-SYB , SAP Business Suite on Sybase ASE Database Platform , SV-SMG-DIA , Solution Manager Diagnostics , 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.