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

Search for additional results

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