SAP Knowledge Base Article - Preview

2488137 - Error 3701 Cannot drop the index at DR - SAP Business Suite

Symptom

  • Replication with SAP Business Suite
     

  • After executing a TSQL setuser command unable to proceed with replication to create or drop an index on the DR

  • The following error messages have been seen in the SRS log:
     

    • ERROR #1028 DSI EXEC(107(1) DR.DB) - neric/dsi/dsiqmint.c(5052)
      Message from server: Message: 3701, State 2, Severity 11 -- 'Cannot drop the index '<Table>.<Index>', because it doesn't exist in the system catalogs.

    • ERROR #1028 DSI EXEC(107(5) DR.DB) - neric/dsi/dsiqmint.c(5052)
      Message from server: Message: 1913, State 1, Severity 16 -- 'There is already an index on table 'XXXX' named 'XXXX~0'

       


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 15.7 for Business Suite

  • SAP Adaptive Server Enterprise (ASE) 16.0 for Business Suite

  • SAP Replication Server (SRS) 15.7.1

  • SAP Replication Server (SRS) 16.0

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0 ; SAP Replication Server 15.7 ; SAP Replication Server 16.0

Keywords

setuser, SAPR3, DROP INDEX, CREATE INDEX, CR 799684, 799684 , KBA , BC-SYB-REP-SAP , Replication with SAP Suite / SAP BW , 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.