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.
SAP Knowledge Base Article - Preview