2146700 - INSERT LOCATION error "The maximum number of connections have already been opened" - SAP IQ | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2146700 - INSERT LOCATION error "The maximum number of connections have already been opened" - SAP IQ

Symptom

insert .. location '' { select .. } job in IQ fails with following error

---
I. Exception Thrown from hqm_con.cxx:192, Err# 1, tid 107 origtid 107
I. O/S Err#: 0, ErrID: 8192 (hqm_exception); SQLCode: -1003002, SQLState: 'QHA02', Severity: 14
I. [20174]: CtLibrary Error: 6, Severity: 0, Origin: 1, Layer: 1
Error Message: ct_connect(): user api layer: external error: The maximum number of connections have already been opened.
OS Error: 0, OS Message: .
-- (hqm_con.cxx 192)
---

location is another IQ server which has -gm 200 ( 200 maximum connections ) but sp_iqconnection shows enough available connections.

Why "maximum number of connections have already been opened" message even though more connections can be made to server identified by location ?


Read more...

Environment

SAP IQ 15.x
SAP IQ 16.x

Product

SAP IQ 16.0 ; SAP Sybase IQ 15.4

Keywords

KBA , BC-SYB-IQ , Sybase IQ , Problem

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.