Updating OAE Trigger throws error java.sql.SQLException: ORA-00942: table or view does not exist drop table aw_oper_table

book

Article ID: 191878

calendar_today

Updated On:

Products

CA Automic Applications Manager (AM)

Issue/Introduction

Updating OAE Trigger results in the below error:

java.sql.SQLException: ORA-00942: table or view does not exist
drop table aw_oper_table
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:447)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:951)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:513)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:227)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:195)
at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:1036)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1336)
at oracle.jdbc.driver.OracleStatement.executeUpdateInternal(OracleStatement.java:1845)
at oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:1810)
at oracle.jdbc.driver.OracleStatementWrapper.executeUpdate(OracleStatementWrapper.java:294)
at com.appworx.server.sql.DBAccess.doSql(DBAccess.java:687)
at com.appworx.server.sql.DBAccess.doSql(DBAccess.java:726)
at com.appworx.server.sql.CommonDB.doSql(CommonDB.java:217)
at com.appworx.server.sql.CommonDB.doSql(CommonDB.java:205)
at com.appworx.agent.generic.B.updateAgent(GenericAgent.java:814)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:566)
at com.uc4.be.util.InvokeUtil.invoke(InvokeUtil.java:122)
at com.appworx.util.InvokeRequest.invokeMethod(InvokeRequest.java:47)
at com.appworx.agent.AbstractAgent.invoke(AbstractAgent.java:590)
at com.appworx.agent.AgentService.invoke(AgentService.java:1311)
at com.appworx.agent.AgentSocketManager$_A.doRun(AgentSocketManager.java:461)
at com.uc4.be.threading.AbstractWorker.run(AbstractWorker.java:367)
at java.base/java.lang.Thread.run(Thread.java:834)

Cause

Issue where the trigger script is exiting when it encounters an error

Environment

Release : 9.3.2

Component : APPLICATIONS MANAGER

Resolution

Workaround:

Edit the $AW_HOME/sql/OAE_Objects.sql or in Windows the %AW_HOME%\sql\OAE_Objects.sql script and comment out the drop statement of the aw_oper_table table or any other drop statements that are resulting in an error.

Solution:

This is fixed in version 9.3.3