SAP Knowledge Base Article - Preview

2196373 - "SELECT INTO" , "ALTER TABLE" 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

  • When replicating "alter table ... lock ", ASE Error 226 is reported in the Replication Server errorlog file:

Message from server: Message: 226, State 1, Severity 16 -- 'ALTER TABLE LOCK 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, 226, 'send warm standby xacts' , 'alter table' , 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 for Me (Login required).

Search for additional results

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