Symptom
- ASE to ASE replication
- The primary table contains a column named 'user'
- To avoid the conflicts with ASE reserved word, SRS connection level dsi_quoted_identifier has set to 'on'
- An INSERT into this table is still failing with the following DSI error:
Message from server: Message: 156, State 2, Severity 15 -- 'Incorrect syntax near the keyword 'user'.
Read more...
Environment
-
SAP Replication Server (SRS) 15.7.1 and higher
- SAP Adaptive Server Enterprise (ASE) 15.7 and higher
Product
SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0 ; SAP Replication Server 15.7 ; SAP Replication Server 16.0
Keywords
msg 156; reserved word; key word; set quoted_identifier; Bracket , KBA , BC-SYB-REP , Sybase Replication Server (standalone) , 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.