SAP Knowledge Base Article - Preview

3750270 - intermittent "not enough threads or cursors for the query" when running hana remote statements against IQ database - SAP IQ

Symptom

  • Executing a command from HANA to the IQ database intermittently fails with the error: "Not enough threads or cursors for the query".


Read more...

Environment

  • IQ Version: SAP IQ/16.1.050.2358/13176/P/SP05.09/Linux
  • HANA Version: 2.00.079.08.1766434523

Product

SAP IQ all versions

Keywords

not enough threads or cursors, iq threads, thread shortage, cursor limit, intermittent failure, alternating runs, complex sql, hana remote statement, sda, prefetch_threads_percent, commit_threads_percent, max_iq_threads_per_connection, iq query plan, index_advisor, fedodbc tracing , KBA , BC-SYB-IQ , Sybase IQ , BW-SYS-DB-IQ , BW on HANA with Sybase IQ Near-line Storage , 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.