8 Replies Latest reply: Jan 9, 2013 6:47 AM by NewUser7 RSS

    ad reconciliation error

    NewUser7
      Hi,
      I am working in OIM 10g. We did some kind of customization in AD i. e resused AD connector for another ad domain integration.Provisioning is working fine but reconciliation is having some problem. All users went inro event received state with the below error


      Error Keyword: DOBJ.GEN_ERROR
      Description: Error occurred updating process data.
      Remedy:
      Action: E
      Severity: H
      Help URL:
      Detail:
      com.thortech.xl.dataaccess.tcDataSetException: Data Access Error
           at com.thortech.xl.dataaccess.tcDataSet.executeQuery(Unknown Source)
           at com.thortech.xl.dataaccess.tcDataSet.executeQuery(Unknown Source)
           at com.thortech.xl.dataobj.tcRCE.deleteChildTableRecords(Unknown Source)
           at com.thortech.xl.dataobj.tcRCE.setChildTableRecords(Unknown Source)
           at com.thortech.xl.dataobj.tcRCE.updateProcessData(Unknown Source)
           at com.thortech.xl.dataobj.tcRCE.linkToProcess(Unknown Source)
           at com.thortech.xl.dataobj.tcRCE.applyActionRules(Unknown Source)
           at com.thortech.xl.dataobj.tcRCE.checkDataSorted(Unknown Source)
           at com.thortech.xl.dataobj.tcRCE.eventPostUpdate(Unknown Source)
           at com.thortech.xl.dataobj.tcDataObj.update(Unknown Source)
           at com.thortech.xl.dataobj.tcDataObj.save(Unknown Source)
           at com.thortech.xl.dataobj.tcTableDataObj.save(Unknown Source)
           at com.thortech.xl.dataobj.tcRCE.reapplyRules(Unknown Source)
           at com.thortech.xl.ejb.databeansimpl.tcRCEBean.reapplyRules(Unknown Source)
           at com.thortech.xl.ejb.beans.tcRCE_4tknfu_EOImpl.reapplyRules(tcRCE_4tknfu_EOImpl.java:130)
           at com.thortech.xl.ejb.beans.tcRCE_4tknfu_EOImpl_WLSkel.invoke(Unknown Source)
           at weblogic.rmi.internal.activation.ActivatableServerRef.invoke(ActivatableServerRef.java:85)
           at weblogic.rmi.internal.BasicServerRef$1.run(BasicServerRef.java:477)
           at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:363)
           at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:147)
           at weblogic.rmi.internal.BasicServerRef.handleRequest(BasicServerRef.java:473)
           at weblogic.rmi.internal.wls.WLSExecuteRequest.run(WLSExecuteRequest.java:118)
           at weblogic.work.ExecuteThread.execute(ExecuteThread.java:201)
           at weblogic.work.ExecuteThread.run(ExecuteThread.java:173)
      Data AccessException:
      com.thortech.xl.orb.dataaccess.tcDataAccessException: DB_READ_FAILEDDetail: SQL: select * from where orc_key=65107 and UD_ADNAUSR_key=87Description: ORA-00903: invalid table name
      SQL State: 42000Vendor Code: 903Additional Debug Info:com.thortech.xl.orb.dataaccess.tcDataAccessException
           at com.thortech.xl.dataaccess.tcDataAccessExceptionUtil.createException(Unknown Source)
           at com.thortech.xl.dataaccess.tcDataBase.createException(Unknown Source)
           at com.thortech.xl.dataaccess.tcDataBase.readPartialStatement(Unknown Source)
           at com.thortech.xl.dataobj.tcDataBase.readPartialStatement(Unknown Source)
           at com.thortech.xl.dataaccess.tcDataSet.executeQuery(Unknown Source)
           at com.thortech.xl.dataaccess.tcDataSet.executeQuery(Unknown Source)
           at com.thortech.xl.dataobj.tcRCE.deleteChildTableRecords(Unknown Source)
           at com.thortech.xl.dataobj.tcRCE.setChildTableRecords(Unknown Source)
           at com.thortech.xl.dataobj.tcRCE.updateProcessData(Unknown Source)
           at com.thortech.xl.dataobj.tcRCE.linkToProcess(Unknown Source)
           at com.thortech.xl.dataobj.tcRCE.applyActionRules(Unknown Source)
           at com.thortech.xl.dataobj.tcRCE.checkDataSorted(Unknown Source)
           at com.thortech.xl.dataobj.tcRCE.eventPostUpdate(Unknown Source)
           at com.thortech.xl.dataobj.tcDataObj.update(Unknown Source)
           at com.thortech.xl.dataobj.tcDataObj.save(Unknown Source)
           at com.thortech.xl.dataobj.tcTableDataObj.save(Unknown Source)
           at com.thortech.xl.dataobj.tcRCE.reapplyRules(Unknown Source)
           at com.thortech.xl.ejb.databeansimpl.tcRCEBean.reapplyRules(Unknown Source)
           at com.thortech.xl.ejb.beans.tcRCE_4tknfu_EOImpl.reapplyRules(tcRCE_4tknfu_EOImpl.java:130)
           at com.thortech.xl.ejb.beans.tcRCE_4tknfu_EOImpl_WLSkel.invoke(Unknown Source)
           at weblogic.rmi.internal.activation.ActivatableServerRef.invoke(ActivatableServerRef.java:85)
           at weblogic.rmi.internal.BasicServerRef$1.run(BasicServerRef.java:477)
           at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:363)
           at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:147)
           at weblogic.rmi.internal.BasicServerRef.handleRequest(BasicServerRef.java:473)
           at weblogic.rmi.internal.wls.WLSExecuteRequest.run(WLSExecuteRequest.java:118)
           at weblogic.work.ExecuteThread.execute(ExecuteThread.java:201)
           at weblogic.work.ExecuteThread.run(ExecuteThread.java:173)

      Source SQL Exception:
      java.sql.SQLSyntaxErrorException: ORA-00903: invalid table name


      Please help

      Thanks