12 Replies Latest reply: Jul 30, 2012 4:09 AM by dnagvanshi RSS

    Trusted Recon Error in OIM 11g

    S.K.N
      Hi,

      Getting the following exception when I tried to run trusted recon in OIM 11g.

      oracle.iam.platform.utils.SuperRuntimeException: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
      ORA-06512: at "DEV_OIM.OIM_SP_RECONBLKUSERCRUD", line 3925
      ORA-06512: at "DEV_OIM.OIM_SP_RECONBLKUSRMLSWRAPPER", line 71
      ORA-06512: at line 1

      at oracle.iam.reconciliation.dao.DBCall.execute(DBCall.java:24)
      at oracle.iam.reconciliation.dao.ReconActionDao.processSPCall(ReconActionDao.java:1330)
      at oracle.iam.reconciliation.dao.ReconActionDao.executeBulkUserMatchCRUD(ReconActionDao.java:696)
      at oracle.iam.reconciliation.impl.UserHandler.executeBulkCUD(UserHandler.java:518)
      at oracle.iam.reconciliation.impl.BaseEntityTypeHandler.process(BaseEntityTypeHandler.java:42)
      at oracle.iam.reconciliation.impl.ActionEngine.processBatch(ActionEngine.java:131)
      at oracle.iam.reconciliation.impl.ActionEngine.execute(ActionEngine.java:92)
      at oracle.iam.reconciliation.impl.ActionTask.execute(ActionTask.java:72)

      I have crossed check the mappings especially the mandatory fields declared in OIM. Events gets generated but it is in Data Received state, not getting linked to user.

      Please help me to fix this.