SAP Knowledge Base Article - Preview

3327936 - ECDA DSI connection encountered : Message 30291 native error 102 Incorrect syntax near '0' - SRS

Symptom

  • Replication from ASE to MSSQL (A2M) 
  • ECDA DSI get suspended right after the connection is created with rs_ase_to_msss profile.
  • Here is the create connection command:
    • create connection to ECDA.MSSQLDB
      using profile rs_ase_to_msss;standard
      set username xxxx
      set password xxxx
  • DSI error:
    • ERROR #1028 DSI(185 ECDA.MSSQLDB) - /generic/useful/cm.c(5341)
    •     Message from server: Message: 30291, State 0, Severity 19 -- '[[Message Iteration=1|Data Source Name=ECDA|SQLState=42000|Native Error=102|Message=[Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Incorrect syntax near '0'.]'.
  • ECDA server log:
    • Returned from SRV_LANGUAGE event handler.
       " set transaction isolation level 0 "       
      ==============================================================
      [Message Iteration=1|Data Source Name=ECDA SQLState=42000|Native Error=102|Message=
      [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Incorrect syntax near '0'.


Read more...

Environment

  • SAP Replication Server (SRS) 16.0
  • SAP Replication Server Option (RSO) for Microsoft SQL Server 16.0
  • Sybase EnterpriseConnect Data Access (ECDA) 15.7

Keywords

transaction isolation level; Msg 30291; native error 102; rs_ase_to_msss , KBA , BC-SYB-REP-RSO , Rep Server Options (RSO) , 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.