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.

NiFi, Connection to Oracle stuck

NiFi, Connection to Oracle stuck

Contributor

Hi All,

We stuck with a strange issue in our flows. 

The flow starts with processors GenerateTableFetch and after that ExecuteSQL. They use service which connects to the Oracle database.

If GenerateTableFetch gets new data all the time no issue discovered. But if for a long period in DB no new records and we insert one processor stuck for 15 minutes. Only after 15 minutes processor gets new data.

Any ideas where to search timeouts or stuck connections or use some connection parameters?

Thanks,

Ilya

 

NiFi version: 1.8.0

Java version: 1.8.0_112

Driver: ojdbc8.jar

Oracle server version: 11.2.0.4.0 (11g)

 

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