Skip to main content
Known Participant
Jun 27, 2023 1:54 PM UTC
Question

Connection PoolTimeOut Connection

Hi All,

We have a requirement of uploading 500 rows at a time. Out of 500 instances i see few instances are failing with the below error.

a!queryRecordType [line 2]: APNX-3-4300-001: Connection pool drained - too many concurrent requests: org.apache.http.conn.ConnectionPoolTimeoutException: Timeout waiting for connection from pool) (Data Outputs).

What could be the reason of failure though the data is being fetched from the cached data of a record type?

Thanks in Advance !!

    6 replies

    stefanhelzle0001
    Brainy
    Jun 27, 2023 2:30 PM UTC

    Seems to be an environment sizing issue. I suggest to contact Appian.

    Known Participant
    Jul 3, 2023 4:45 PM UTC

    but any qyery record type needs connection pool or not?

    stefanhelzle0001
    Brainy
    Jul 3, 2023 5:11 PM UTC

    Eh ... what ?!?!

    Any database connection requires at least one connection from the pool. If the pool is exhausted, it has to wait. If the max waiting time is over, it fails. Simple logic!

    karumurua531442
    Participating Frequently
    Jul 4, 2023 9:12 AM UTC

    Hi [mention:1b11e32040364718842957ec85993731:e9ed411860ed4f2ba0265705b8793d05] I think you can raise support ticket with Appian.  They might increase GB for buffer pool in the database.

    Participating Frequently
    Nov 2, 2026 1:14 PM UTC

    hi , i have these issue , anyone can help how to solve it

    mathieud0001
    Genius
    Nov 2, 2026 1:22 PM UTC

    See answer in