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 for Me (Login required).

Search for additional results

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