Symptom
When running replication with 60 connections from 2 repservers and all connections are active the connection to repserver DSI goes down with the following errors”
In repserver:
ERROR #1028 DSI EXEC(165(1) SERVER.DATABASE) - /generic/useful/cm.c(5329)
Message from server: Message: -102, State 0, Severity 21 -- 'SQL Anywhere Error -102: Database server connection limit exceeded'.
ERROR #1027 DSI EXEC(165(1) SERVER.DATABASE) - /generic/useful/cm.c(5329)
Open Client Client-Library error: Error: 67175468, Severity 4 -- 'ct_connect(): protocol specific layer: external error: The attempt to connect to the server failed.'.
ERROR #13045 DSI EXEC(165(1) SERVER.DATABASE) - /generic/useful/cm.c(5333)
Failed to connect to server 'SERVER' as user 'GPS14t'. See CT-Lib and/or server error messages for more information.
The DSI thread for database 'SERVER.DATABASE' is shutdown.
In IQ:
Exception Thrown from hqmlib/hqm_con.cxx:199, Err# 1, tid 13 origtid 13
O/S Err#: 0, ErrID: 8192 (hqm_exception); SQLCode: -1003002, SQLState: 'QHA02', Severity: 14
0000000057 [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: .
-- (hqmlib/hqm_con.cxx 199)
0000000042 PostRbck
Read more...
Environment
-
SAP IQ
- SAP Repserver
Product
Keywords
KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-SYB-REP , Sybase Replication Server (standalone) , BC-SYB-SDK , SDK , BC-SYB-IQ , Sybase IQ , How To
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.