I am using ODM 8.9.2.3 running with WebSphere with with Oracle as the backend datasource.

I have using a default user, system in Oracle, and I have deployed the hello world decision service project to the ODMDC database there.

I want to archive the rules using the gen-archive-repository-script since I want to clean up with the rules that I do not need. So I create another user called ora_new and this user has been granted with connect, resource, create view permission. When I run the ran the ant script gen-archive-repository-role, it is working fine.

However, I am getting the table/view not found when I run the ant archive-repository-script. I am sure that the table/view are already there. What's the reason of this failure?

C:\IBM\ODM8923\teamserver\bin>ant gen-archive-repository-script -Dserver.url=http://localhost:9081/teamserver -DdatasourceName=jdbc/ilogDataSource6 -DoldDatabaseSchemaName=SYSTEM -Dusername=rtsAdmin -Dpassword=rtsAdmin -DarchiveDate=2019-01-01 -DoutputFile=gen-archive-repository-script.sql

7:58

Caused by: java.sql.SQLException: ORA-00942: table or view does not exist at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:494)

at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:446)

at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1054)

at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:623)

at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:252)

at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:612)

at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:213)

at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:37)

at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:733)

at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:904)

at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1082)

at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1276)

at oracle.jdbc.driver.OracleStatementWrapper.executeQuery(OracleStatementWrapper.java:366)

at com.ibm.ws.rsadapter.jdbc.WSJdbcStatement.pmiExecuteQuery(WSJdbcStatement.java:1765)

at com.ibm.ws.rsadapter.jdbc.WSJdbcStatement.executeQuery(WSJdbcStatement.java:1038)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:90)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:55)

at java.lang.reflect.Method.invoke(Method.java:508)

at ilog.rules.teamserver.transaction.logger.IlrStatementInvocationHandler.executeStatement(IlrStatementInvocati

With Oracle you need to restart Decision Center application so that the database connection available in the connection pool is recreated. Otherwise Oracle does no automatically assign new permissions to available connections.