Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Hi @Alwaleed ,
Could you please raise support with the job diagnostics?
https://doc.dataiku.com/dss/latest/troubleshooting/obtaining-support.html
We need to look at the exact error you see to advise further.
Most likely, it is on the database side.
Hi @Alwaleed ,
Note we don't recommend adding job diagnostics to the community. I've asked the community admins to remove it.
We can see the timeout occurred while doing SQL insert batch
[2023/08/13-16:26:20.442] [FRT-62-FlowRunnable] [INFO] [dku.output.sql] act.compute_FL-CahsierWTID_NP - Executing SQL insert batch ...
About ~15 minutes later the timeout occurred in the JDBC Oracle code :
[2023/08/13-16:42:04.933] [FRT-62-FlowRunnable] [ERROR] [dku.output.sql] act.compute_FL-CahsierWTID_NP - Encountered SQL exception
Encountered SQL exception
java.sql.BatchUpdateException: IO Error: Connection timed out
at oracle.jdbc.driver.OraclePreparedStatement.generateBatchUpdateException(OraclePreparedStatement.java:10345)
https://support.oracle.com/knowledge/Middleware/2008225_1.html
It's unclear what caused the timeout. It would be best to work with your DBA and Network team to reproduce and isolate the issue. It could be a network/firewall timeout or something on the Oracle database side if the database was under load during that time.
If you need further assistance on this please open a support ticket.