SAP Knowledge Base Article - Preview

2271280 - Getting error [IQ Error SQL-102:08004][SQL Anywhere]Database server connection limit exceeded -SAP IQ

Symptom

Enduser gets following error *sometimes* while connecting to IQ.
-------------
(-102) [08004] [Sybase][ODBC Driver][SQL Anywhere]Database server connection limit exceeded
Connection 0 failed using DRIVER={SQL Anywhere 12}; CommLinks=tcpip(HOST=...;ServerPort=..);uid=dba;DatabaseName=SAPIQ

***LOG BY2=> sql error -102 performing CON [dbds 1143]
***LOG BY0=> [IQ Error SQL-102:08004][SQL Anywhere]Database server connection limit exceeded [dbds 1143]
***LOG BY1=> sql error -102 [dbacds 1823]
-------------

IQ .cfg file has -gm 100 so IQ is configured for 100 connections.


Read more...

Environment

  • SAP IQ 16 SP08+
  • Any Platform

Product

SAP IQ 16.0

Keywords

SOLMAN_DBA ; timeout ; -ti ; "IQ Error SQL-102:08004" , KBA , BW-SYS-DB-IQ , BW on HANA with Sybase IQ Near-line Storage , 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 ONE Support launchpad (Login required).

Search for additional results

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