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.
SAP Knowledge Base Article - Preview