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.
SAP Knowledge Base Article - Preview