Issue running OEBS job

Document ID : KB000088689
Last Modified Date : 14/04/2018
Show Technical Document Details
Issue:

Symptoms

After updating RA OEBS Solution, jobs fail with:


java.sql.SQLException: ORA-06550: line 1, column 18:
PLS-00302: component 'DELETEREQUEST' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

    at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:113)
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
    at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:754)
    at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:218)
    at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:971)
    at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1192)
    at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3415)
    at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3521)
    at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:4612)
    at com.automic.ra.jdbc.DBCall.runProcedure(DBCall.java:530)
    at com.automic.oebs.agent.RunJob.deleteRequest(RunJob.java:94)
    at com.automic.oebs.agent.RunJob$deleteRequest.call(Unknown Source)
    at Default.runJob(OEBSAgent.groovy:1256)
    at com.automic.extensibility.types.CITAgent.dispatchJob(CITAgent.java:253)
    at com.automic.ex.cit.CITJob.execute(CITJob.java:174)
    at com.automic.ex.Job.run(Job.java:452)
    at com.automic.ex.ThreadPool$RunnableDecorator.run(ThreadPool.java:53)
    at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441)
    at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
    at java.util.concurrent.FutureTask.run(FutureTask.java:138)
    at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
    at java.lang.Thread.run(Thread.java:662)
Caused by: java.sql.SQLException: (SQLState 65000) automic_oae_pk.deleteRequest
    0 appJobId : 5807686 : i :

    at com.automic.ra.jdbc.DBCall.throwIt(DBCall.java:126)
    at com.automic.ra.jdbc.DBCall.checkRetry(DBCall.java:433)
    at com.automic.ra.jdbc.DBCall.runProcedure(DBCall.java:590)
    ... 13 more

 


Cause

Automic Triggers for the OEBS database were corrupted during update and need to be re-created.

 



 

Resolution:

With the Agent Running > Client 0 > Host Object
On the OEBS tab, check the 'Update' box.
Stop and restart the Agent.

.png