Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

GenerateTableFetch and ExecuteSQL : Cannot get a connection, pool error Timeout

Highlighted

GenerateTableFetch and ExecuteSQL : Cannot get a connection, pool error Timeout

New Contributor

Hello All!

I'm new on NiFi. I'm getting the following error when running 'GenerateTableFetch' and 'ExecuteSQL'. It's like 'GenerateTableFetch' or/and 'ExecuteSQL' processors are asking for too many pools then get kick out by the database. Do you have any idea on how I could solve this issue ?

due to org.apache.nifi.processor.exception.ProcessException: org.apache.commons.dbcp.SQLNestedException: Cannot get a connection, pool error Timeout waiting for idle object; routing to failure: org.apache.commons.dbcp.SQLNestedException: Cannot get a connection, pool error Timeout waiting for idle object

Best Whises

Don't have an account?
Coming from Hortonworks? Activate your account here