Can anyone explain why the DBConnector action in Studio keeps timing out when querying a table with over 5k records?
I have a simple SELECT statement hitting a PostgreSQL instance via the connector. It works fine for small datasets but fails with a 504 Gateway Timeout when the row count exceeds the threshold.
The JSON output from the connector is empty on failure, and the Studio trace shows the action hanging for exactly 30 seconds before aborting. No specific error code is logged in the interaction details.
Is there a limit on the result set size or execution time for DBConnector actions in CXone Studio, or should I be batching these requests differently?