[AWA] SQL Job gets killed (return code 3) because of a TimeOut on the DB

book

Article ID: 198601

calendar_today

Updated On:

Products

CA Automic Workload Automation - Automation Engine CA Automic Workload Automation - Automation Engine

Issue/Introduction

SQL Jobs always end in ENDED_NOT_OK with return code 3 after exactly 40 minutes.
The message below is visible in the logs :

java.lang.NegativeArraySizeException2020-08-31 12:07:45 - U02000155 Internal error (Exception).java.lang.NegativeArraySizeException	at oracle.net.ano.CryptoNIONSDataChannel.readDataFromSocketChannel(Unknown Source)	at oracle.jdbc.driver.T4CMAREngineNIO.prepareForReading(T4CMAREngineNIO.java:98)	at oracle.jdbc.driver.T4CMAREngineNIO.unmarshalUB1(T4CMAREngineNIO.java:534)	at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:485)	at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:252)	at oracle.jdbc.driver.T4C7Ocommoncall.doOROLLBACK(T4C7Ocommoncall.java:67)	at oracle.jdbc.driver.T4CConnection.doRollback(T4CConnection.java:1036)	at oracle.jdbc.driver.PhysicalConnection.rollback(PhysicalConnection.java:1966)	at com.uc4.ex.sql.db.DriverBridge.rollback(DriverBridge.java:232)	at com.uc4.ex.sql.SQLConsumer.finishJob(SQLConsumer.java:300)	at com.uc4.ex.sql.SQLConsumer.execute(SQLConsumer.java:194)	at com.uc4.ex.Job.run(Job.java:466)	at com.uc4.ex.ThreadPool$RunnableDecorator.run(ThreadPool.java:53)	at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:522)	at java.util.concurrent.FutureTask.run(FutureTask.java:277)	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1160)	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635)	at java.lang.Thread.run(Thread.java:818)

 

 

Cause

SQLNet timeout in the DB Config.

 

Environment

Release : 12.2

Component : AUTOMATION ENGINE

Resolution

Change the Timeout parameter on the target DB used for the SQL Jobs (not on AE DB) :

In "sqlnet.ora" (on the Target DB), the parameter SQLNET.SEND_TIMEOUT needs to be tuned.