Skip to main content
G
gopuh
June 27, 2023
Question

Connection PoolTimeOut Connection

  • June 27, 2023
  • 4 replies
  • 1 view

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

    4 replies

    stefanhelzle0001
    stefanhelzle0001
    Brainy
    June 27, 2023

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

    P
    piyusha6151
    July 3, 2023

    but any qyery record type needs connection pool or not?

    stefanhelzle0001
    stefanhelzle0001
    Brainy
    July 3, 2023

    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
    karumurua531442
    July 4, 2023

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

    Terms & ConditionsAccessibility statement