Timeout Oracle After a while of time

[Alwaleed]

Hi everyone , I not sure about the problem but the recipes raised timeout error after 1 hour 

It was working fine with no errors anyone can help ? 

Thanks in advance 

[AlexT]

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.

[AlexT]

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.