SAP Knowledge Base Article - Preview

2436979 - ASE Error SQL1913: There is already an index on table 'DBH_CONFIG' named '"DBH_CONFIG~0"' - SAP ASE

Symptom

You want to monitor and administer SAP ASE databases remotely using DBA Cockpit, the databases are not running any SAP applications.
You follow the Solution in SAP Note 1593987, set up the database connection and add it through System Configuration in DBA Cockpit.
After that click 'Database <SID>' -> Configuration -> DBA Cockpit Framework -> Data Collectors and Admin Procedures,
but find the Setup column of Data Collector is Red LED, so you click Impletement Template or Repair All to fix it, but error 1913 is raised:
e.g.
----------------------------------------------------------------------------------------------------------
Error in RDI setup back-end occured
Message Details 
 
Exception CX_DBA_DBH_SETUP in class CL_SYB_DBH_SETUP method INSTALL_INTERNAL line 38
Kernel Error ID: 
WP ID: 6 
WP PID: 2913
Application Server: XXX 
SYSID: 
SY-SUBRC: 0 
SY-TABIX: 0 
Message:                       Error in RDI setup back-end occured
Database:

caused by
Exception CX_DBA_RDI_SETUP in class CL_SYB_RDI_DBO_INDEX method IF_DBA_RDI_DBO~CREATE line 70
Kernel Error ID: 
WP ID: 6 
WP PID: 2913
Application Server: XXX 
SYSID: 
SY-SUBRC: 0 
SY-TABIX: 0 
Message:                       Unable to create index 'DBH_CONFIG~0'!
Database:

caused by
Exception CX_DBA_ADBC in program SAPMHTTP  line 0 
Kernel Error ID: 
WP ID: 6 
WP PID: 2913
Application Server: XXX 
SYSID: TS2
SY-SUBRC: 0 
SQL statement: CREATE UNIQUE NONCLUSTERED INDEX "DBH_CONFIG~0" ON saptools..DBH_CONFIG( "KEY" ) WITH FILLFACTOR = 90, STATISTICS HASHING
Database: TS2
caused by
Exception CX_SQL_EXCEPTION in class CL_SYB_RDI_QUERY 
Kernel Error ID: 
DB Error: Yes
SQL Code: 1913 
SQL Message: [ASE Error SQL1913][SAP][ASE ODBC Driver][Adaptive Server Enterprise]There is already an index on table 'DBH_CONFIG' named '"DBH_CONFIG~0"'

----------------------------------------------------------------------------------------------------------
The required data collectors Framework, Error Log, Deadlocks and Lock-Timeouts, Proc. Cache Usage, Temp. DB Activity, File Systems, Data Cache Usage, Tables, Indexes, Statement Cache Usage, Statement Cache, System Waits, System Load, Threads, ASE Instance, Spinlocks, Devices, ASE Resources, I/O Controllers, Memory Usage, Transaction Log Usage, HA/DR Paths, HA/DR Resources, HA/DR Replication Agents, HA/DR Error Log, Data Cache Objects, Resource Limits, Configuration Check, Database Dump, Transaction Dump, Reorganisation, Update Statistics are not properly set up

Message Details 
 
Exception CX_DBA_DBH_SETUP in program SAPMHTTP  line 0 
Kernel Error ID: 
WP ID: 6 
WP PID: 2913
Application Server: XXX 
SYSID: 
SY-SUBRC: 0 
SY-TABIX: 0 
Message:                       The required data collectors Framework, Error Log, Deadlocks and Lock-Timeouts, Proc. Cache Usage, Temp. DB Activity, File Systems, Data Cache Usage, Tables, Indexes, Statement Cache Usage, Statement Cache, System Waits, System Load, Threads, ASE Instance, Spinlocks, Devices, ASE Resources, I/O Controllers, Memory Usage, Transaction Log Usage, HA/DR Paths, HA/DR Resources, HA/DR Replication Agents, HA/DR Error Log, Data Cache Objects, Resource Limits, Configuration Check, Database Dump, Transaction Dump, Reorganisation, Update Statistics are not properly set up
----------------------------------------------------------------------------------------------------------


Read more...

Environment

  • SAP Adaptive Server Enterprise 15.7
  • SAP Adaptive Server Enterprise 16.0

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0

Keywords

dbacockpit, dba cockpit, sybase, standalone, error 1913, Error SQL1913, ATM, Data Collectors, DBH_CONFIG, saptools, quoted identifiers, netweaver, solution manager , 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.