SAP Knowledge Base Article - Preview

2997645 - How to reset the DSI parameter dsi_cmd separator to default value <newline> character - SRS

Symptom

  • The parameter of DSI connection named "dsi_cmd_separator" was configured with a value different of its default value.
  • Try to reset "dsi_cmd_separator" to its default value which is the <newline> character by using the regular expression '\n':

alter connection to <DEST_SERVER>.<DEST_DB> set dsi_cmd_separator to '\n'

  • When resuming connection to <DEST_SERVER>.<DEST_DB>, it fails with and error like:

ERROR #1028 DSI(103 <DEST_SERVER>.<DEST_DB>) - eneric/dsi/dsioqid.c(2045)
Message from server: Message: 102, State 181, Severity 15 -- 'Incorrect syntax near '\'.


Read more...

Environment

  • SAP Replication Server (SRS) 16.0
  • SAP Replication Server (SRS) 15.7.1
  • SAP Replication Server Heterogeneous Edition (RSHE) 15.7.1

Product

SAP Replication Server 15.7 ; SAP Replication Server 16.0 ; SAP Sybase Replication Server 15.7, heterogeneous edition

Keywords

dsi_cmd_separator, default, newline, \n, reset, 102, incorrect syntax near , KBA , BC-SYB-REP , Sybase Replication Server (standalone) , BC-SYB-REP-HET , Replication Server Heterogeneous Edition (RSHE) , How To

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.