ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Issue running OEBS job

book

Article ID: 88689

calendar_today

Updated On:

Products

CA Automic Workload Automation - Automation Engine

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

Release: AUTOME99000-2.0-Automic-Oracle Retail MOM-Enterprise Edition
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">