2110307 - Error 16817 when recompliing a dynamic sql if "streamlined dynamic SQL" is OFF - SAP ASE | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2110307 - Error 16817 when recompliing a dynamic sql if "streamlined dynamic SQL" is OFF - SAP ASE

Symptom

  • When a dynamic SQL with homogeneous batch parameters is executed and it's required a recompile and
  • The configuration parameter "streamlined dynamic SQL" is set to OFF, then
  • Error 16817 may occur:

Error #16817
A query plan cannot be generated for DML command executed with homogeneous batch parameters. The batch was aborted.

  • Here is a sample Java stack trace when Error 16817 occurs:

com.sybase.jdbc4.jdbc.SybBatchUpdateException: JZ0BE: BatchUpdateException: Error occurred while executing batch statement: A query plan cannot be generated for DML command executed with homogeneous batch parameters. The batch was aborted.

        at com.sybase.jdbc4.jdbc.ErrorMessage.raiseBatchUpdateException(ErrorMessage.java:1319)
        at com.sybase.jdbc4.jdbc.SybStatement.batchLoop(SybStatement.java:2133)
        at com.sybase.jdbc4.jdbc.SybStatement.sendBatch(SybStatement.java:1923)
        at com.sybase.jdbc4.jdbc.SybStatement.executeBatch(SybStatement.java:1881)
        at com.sybase.jdbc4.jdbc.SybStatement.executeBatch(SybStatement.java:1799)
        at com.sybase.jdbc4.jdbc.SybPreparedStatement.executeBatch(SybPreparedStatement.java:1885)
        at HomoBatchTest.main(HomoBatchTest.java:56)


Read more...

Environment

SAP Adaptive Server Enterprise (ASE) 15.7

Product

SAP Adaptive Server Enterprise 15.7

Keywords

774383, CR774383 , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , 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.