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
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.