SAP Knowledge Base Article - Preview

2341608 - DSI threads may be suspended when DDL commands are executed on a table with a replication filter - SAP ASE and Replication Server

Symptom

  • You configure a multi-path replication and create an alternate replication path for the primary database.
  • You also create a replication filter with a table and bind it to the alternate replication path.
  • When you run a DDL command including the table with the filter on the primary database, the command is replicated to both the default and alternate replication paths.
  • As a result, a DSI thread executes the same DDL command on the replicate database twice and gets suspended due to an error.
  • The following example is an error raised from a DSI thread when executing an alter table command to change a lock schema. 

E. 2016/07/12 12:04:57. ERROR #1028 DSI EXEC(103(1) ASE157.RDB) - neric/dsi/dsiqmint.c(5052)
        Message from server: Message: 4963, State 1, Severity 16 -- 'Table 'test_table' is already locked in the desired locking scheme.
'.


Read more...

Environment

  • SAP Adaptive Server Enterprise 15.7
  • SAP Adaptive Server Enterprise 16.0
  • SAP Replication Server 15.7.1

Product

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

Keywords

KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-SYB-REP , Sybase Replication Server (standalone) , 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.