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
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.