SAP Knowledge Base Article - Preview

2483463 - CTLibrary connection errors being reported in both SAP IQ and repserver.

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

SAP Adaptive Server Enterprise all versions ; Sybase SDK 12.5 ; Sybase SDK 15.0 ; Sybase SDK 15.5 ; Sybase SDK 15.7

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 ONE Support launchpad (Login required).

Search for additional results

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