SAP Knowledge Base Article - Preview

2196373 - SELECT INTO replication in MSA raises ASE Error 226 - SRS

Symptom

  • Unable to replicate the "select into" statement in MSA (Multi-Site Availability) enviroment.
  • When replicating "select into", ASE Error 226 is reported in the Replication Server errorlog file:

Message from server: Message: 226, State 1, Severity 16 -- 'SELECT INTO command not allowed within multi-statement transaction.


Read more...

Environment

  • SAP Replication Server (SRS) 15.2 and higher
  • SAP Adaptive Server Enterprise (ASE) 15.0.3 and higher

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0 ; SAP Replication Server all versions ; Sybase Adaptive Server Enterprise 15.0 ; Sybase Adaptive Server Enterprise 15.5 ; Sybase Replication Server software all versions

Keywords

Multi-Site, SQL, RepServer , KBA , BC-SYB-REP , Sybase Replication Server (standalone) , Bug Filed

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.