Issue running OEBS job
Article ID: 88689
Updated On:
Products
Issue/Introduction
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.
Environment
Component:
Resolution
With the Agent Running > Client 0 > Host Object
On the OEBS tab, check the 'Update' box.
Stop and restart the Agent.
<Please see attached file for image>
align="bottom" class="documentation" title="Host Object in Client 0" border="0" alt=".png" src="http://ecmstage.ca.com/KB%20Asset%20Library/000008578_Embeded/.png">Feedback
