We are using NiFi to pull data from oracle and perform some transformation. The pipeline works fine for small amount but fails with the error no output to read from socket when data volume is high -> 1million records. Any Help or configuration changes that i need to do.
Asked
Active
Viewed 224 times
0
-
provide the error stacktrace, the flow, which processors you are using, which processor is failing... – daggett Jul 06 '18 at 12:14
-
Hi The ExecuteSql Processor is failing with error message: no more data to read from socket after running for almost an hour. ExecuteSql is the first processor which is running select * from {tablename} – Siddharth Chaurasia Jul 06 '18 at 17:04
-
1This might be an issue on the Oracle side. This post may help you: https://stackoverflow.com/questions/7839907/no-more-data-to-read-from-socket-error – Jagrut Sharma Jul 06 '18 at 17:41
-
Can you tell us what release of oracle and the version of NiFi or HDF you are working with? – Sivaprasanna Sethuraman Jul 09 '18 at 04:29
-
Hi, The nifi version is 1.6.0 and oracle 11g. – Siddharth Chaurasia Jul 09 '18 at 09:00