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 , 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.