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)

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 for Me (Login required).

Search for additional results

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