Timeout Oracle After a while of time

Alwaleed
Alwaleed Registered Posts: 8

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

Answers

  • Alexandru
    Alexandru Dataiker, Dataiku DSS Core Designer, Dataiku DSS ML Practitioner, Dataiku DSS Adv Designer, Registered Posts: 1,225 Dataiker

    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.





  • Alexandru
    Alexandru Dataiker, Dataiku DSS Core Designer, Dataiku DSS ML Practitioner, Dataiku DSS Adv Designer, Registered Posts: 1,225 Dataiker

    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.

Setup Info
    Tags
      Help me…