Hello Guys,
I recently applied OIM patch with id as "30338509" in our environment. Going through the Read Me file of the applied patch, I did the necessary configuration for "Purging Certification Data".
Then created the job in OIM scheduler & executed it but it failed with below error :
<Error> <oracle.iam.DBUtil.scheduledtasks> <BEA-000000> <Error while Building the array parameters
java.sql.SQLException: ORA-06550: line 1, column 7:
PLS-00306: wrong number or types of arguments in call to 'OIM_SP_DATAPURGETASK_WRAPPER'
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:931)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:481)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:205)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:548)
at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:213)
at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:1111)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1488)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3769)
at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3954)
at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:9353)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1539)
at weblogic.jdbc.wrapper.PreparedStatement.execute(PreparedStatement.java:99)
at oracle.iam.DBUtil.scheduledtasks.OIMCertPurge.execute(OIMCertPurge.java:318)
at oracle.iam.scheduler.vo.TaskSupport.invokeExecute(TaskSupport.java:275)
at oracle.iam.scheduler.vo.TaskSupport.access$000(TaskSupport.java:46)
at oracle.iam.scheduler.vo.TaskSupport$1.processWithoutResult(TaskSupport.java:221)
at oracle.iam.platform.tx.OIMTransactionCallbackWithoutResult.process(OIMTransactionCallbackWithoutResult.java:9)
at oracle.iam.platform.tx.OIMTransactionCallback.doInTransaction(OIMTransactionCallback.java:13)
at oracle.iam.platform.tx.OIMTransactionCallback.doInTransaction(OIMTransactionCallback.java:6)
at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:128)
at oracle.iam.platform.tx.OIMTransactionManager.executeTransaction(OIMTransactionManager.java:47)
at oracle.iam.scheduler.vo.TaskSupport.executeJob(TaskSupport.java:201)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
As part of troubleshooting I performed the steps mentioned in the OIM issue i.e, https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=183222870182108&id=2356570.1&_afrWindowMode=0&_adf.ctrl-…
Job parameters & its types are provided correctly. Also database now has all the necessary tables, but still the same issue is occurring again.
can anyone help here or provide some pointers?