SAP Knowledge Base Article - Preview

3417017 - SQL226 SET CHAINED command not allowed within multi-statement transaction in SM21 after kernel upgrade

Symptom

After Solman 7.2 kernel update, error 226 start to report frequently in SM21:

ERROR: -1 in function ExecuteAndFlush (SQLExecDirect) [line 17824]
(226) [ZZZZZ] [SAP][ASE ODBC Driver][Adaptive Server Enterprise]SET CHAINED command not allowed within multi-statement transaction.


Read more...

Environment

  • SAP Adaptive Server Enterprise 16.0 for Business Suite
  • SAP ASE ODBC Driver/16.0.04.00/16.0 SP04/P/x86_64/Linux/drvsp04
  • SAP_BASIS 740 SP25
  • uc kernel 753 1224
  • DBSL patchno  1217

Product

SAP Adaptive Server Enterprise 16.0 ; SAP Solution Manager 7.2

Keywords

error 226, ERROR 226, SQL226, SET CHAINED, kernel upgrade  , KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , 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.