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
- create connection to ECDA.MSSQLDB
- 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'.
- Returned from SRV_LANGUAGE event handler.
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.