6 Replies Latest reply: Dec 12, 2012 8:53 AM by 952827 RSS

    Error granting privileges and roles with a cloned DBUM connector oim11g

    952827
      hi,
      I cloned the DBUM connector and the provisioning task works ok but when i add roles and privileges OIM shows me this error:

      Error
      Dec 10, 2012: Exception com.thortech.xl.dataaccess.tcDataSetException: Data Access Error was thrown in adapter "BBDORAAddUserToGroup". The Adapter Response was "Data Access Error" .Setting task status... "Data Access Error" does not correspond to a known Response Code. Using "UNKNOWN".

      any idea?? thanks for your help.!
        • 1. Re: Error granting privileges and roles with a cloned DBUM connector oim11g
          Rajiv Dewan
          Not sure how you cloned the connector...

          For debugging enable logs for Connector in TRACE:32 mode and paste the errors here
          • 2. Re: Error granting privileges and roles with a cloned DBUM connector oim11g
            952827
            Hi, i cloned the connector with the "manage connector" and i selected the DBUM connector and i followed 12 steps .
            my log is in trace:32, this is the log shows.

            <Dec 10, 2012 10:22:05 AM COT> <Warning> <Socket> <BEA-000450> <Socket 1,022 internal data record unavailable (probable closure due idle timeout), event received -32>
            Loading query for SET_PASSWORD
            Loading query for UPDATE_TABLESPACE
            Loading query for UPDATE_DEFAULTQUOTA
            Loading query for UPDATE_GLOBALDN
            Loading query for UPDATE_PROFILE
            Loading query for UPDATE_TEMPTABLESPACE
            Loading query for UPDATE_TMPQUOTA
            Loading query for UPDATE_AUTHTYPE_EXTERNAL
            Loading query for UPDATE_AUTHTYPE_GLOBAL
            Loading query for UPDATE_ADD_ROLES
            Loading query for ROLE_ADMIN_OPTION
            Loading query for UPDATE_ADD_PRIVILEGES
            Loading query for PRIVILEGE_ADMIN_OPTION
            Loading query for UPDATE_REVOKE_ROLES
            Loading query for UPDATE_REVOKE_PRIVILEGES
            Loading query for TABLESPACE_QUERY
            Loading query for PROFILE_QUERY
            Loading query for TEMP_TABLESPACE_QUERY
            Loading query for TEMPTS_QUOTA_QUERY
            Loading query for DEFAULTS_QUOTA_QUERY
            Loading query for ROLE_ADMIN_OPTION
            Loading query for PRIVILEGE_ADMIN_OPTION
            Loading query for CREATE_PASSWORD_USER
            Loading query for TABLESPACE_QUERY
            Loading query for TEMP_TABLESPACE_QUERY
            Loading query for PROFILE_QUERY
            Loading query for DEFAULTS_QUOTA_QUERY
            Loading query for TEMPTS_QUOTA_QUERY
            <Dec 10, 2012 10:22:26 AM COT> <Warning> <ORG.IDENTITYCONNECTORS.DBUM.DBUMCONNECTOR> <BEA-000000> <org.identityconnectors.dbum.DBUMConnector : securityValidation : Excluding security check on __NAME__>
            <Dec 10, 2012 10:22:26 AM COT> <Warning> <ORG.IDENTITYCONNECTORS.DBUM.DBUMCONNECTOR> <BEA-000000> <org.identityconnectors.dbum.DBUMConnector : securityValidation : Excluding security check on __PASSWORD__>
            Running SETFORMFIELD
            Target Class = oracle.iam.connectors.dbum.intg.ProcessFormHelper
            *<Dec 10, 2012 10:22:29 AM COT> <Error> <XELLERATE.DATABASE> <BEA-000000> <select UD_DB_ORA_P_KEY from UD_DBBAN24P where UD_DBBAN24P_KEY = 1*
            java.sql.SQLSyntaxErrorException: ORA-00904: "UD_DB_ORA_P_KEY": invalid identifier

                 at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:457)
                 at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)
                 at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:889)
                 at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:476)
                 at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:204)
                 at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:540)
                 at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:202)
                 at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:919)
                 at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1261)
                 at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1419)
                 at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1668)
                 at oracle.jdbc.driver.OracleStatementWrapper.executeQuery(OracleStatementWrapper.java:432)
                 at weblogic.jdbc.wrapper.Statement.executeQuery(Statement.java:487)
                 at com.thortech.xl.util.JDBCUtils.executeQuery(JDBCUtils.java:159)
                 at com.thortech.xl.dataaccess.tcDataBase.readPartialStatement(tcDataBase.java:728)
                 at com.thortech.xl.dataobj.tcDataBase.readPartialStatement(tcDataBase.java:271)
                 at com.thortech.xl.dataaccess.tcDataSet.executeQuery(tcDataSet.java:935)
                 at com.thortech.xl.dataobj.tcDataSet.executeQuery(tcDataSet.java:1523)
                 at com.thortech.xl.dataaccess.tcDataSet.executeQuery(tcDataSet.java:903)
                 at com.thortech.xl.dataobj.tcDataSet.executeQuery(tcDataSet.java:1490)
                 at com.thortech.xl.adapterfactory.events.tcAdpEvent.getChildTableFieldValue(tcAdpEvent.java:2261)
                 at com.thortech.xl.adapterfactory.events.tcAdpEvent.getRunTimeValue(tcAdpEvent.java:806)
                 at com.thortech.xl.adapterfactory.events.tcAdpEvent.getRunTimeValue(tcAdpEvent.java:680)
                 at com.thortech.xl.adapterGlue.ScheduleItemEvents.adpBBDORAADDUSERTOGROUP.implementation(adpBBDORAADDUSERTOGROUP.java:50)
                 at com.thortech.xl.client.events.tcBaseEvent.run(tcBaseEvent.java:196)
                 at com.thortech.xl.dataobj.tcDataObj.runEvent(tcDataObj.java:2492)
                 at com.thortech.xl.dataobj.tcScheduleItem.runMilestoneEvent(tcScheduleItem.java:2917)
                 at com.thortech.xl.dataobj.tcScheduleItem.eventPostInsert(tcScheduleItem.java:547)
                 at com.thortech.xl.dataobj.tcDataObj.insert(tcDataObj.java:602)
                 at com.thortech.xl.dataobj.tcDataObj.save(tcDataObj.java:474)
                 at com.thortech.xl.dataobj.tcOrderItemInfo.processChildTableChange(tcOrderItemInfo.java:655)
                 at com.thortech.xl.dataobj.tcOrderItemInfo.eventPostInsert(tcOrderItemInfo.java:184)
                 at com.thortech.xl.dataobj.tcUDProcess.eventPostInsert(tcUDProcess.java:235)
                 at com.thortech.xl.dataobj.tcDataObj.insert(tcDataObj.java:602)
                 at com.thortech.xl.dataobj.tcDataObj.save(tcDataObj.java:474)
                 at com.thortech.xl.dataobj.tcTableDataObj.save(tcTableDataObj.java:2906)
                 at com.thortech.xl.dataobj.tcUDProcess.addUDChildData(tcUDProcess.java:1867)
                 at com.thortech.xl.dataobj.tcUDProcess.eventPostInsert(tcUDProcess.java:363)
                 at com.thortech.xl.dataobj.tcDataObj.insert(tcDataObj.java:602)
                 at com.thortech.xl.dataobj.tcDataObj.save(tcDataObj.java:474)
                 at com.thortech.xl.dataobj.tcTableDataObj.save(tcTableDataObj.java:2906)
                 at com.thortech.xl.dataobj.tcORC.autoDOBSave(tcORC.java:3002)
                 at com.thortech.xl.dataobj.util.tcOrderPackages.createOrder(tcOrderPackages.java:526)
                 at com.thortech.xl.dataobj.util.tcOrderPackages.orderPackageForUser(tcOrderPackages.java:177)
                 at com.thortech.xl.dataobj.tcOIU.provision(tcOIU.java:527)
                 at com.thortech.xl.dataobj.tcOIU.eventPostInsert(tcOIU.java:303)
                 at com.thortech.xl.dataobj.tcDataObj.insert(tcDataObj.java:602)
                 at com.thortech.xl.dataobj.tcDataObj.save(tcDataObj.java:474)
                 at com.thortech.xl.dataobj.tcTableDataObj.save(tcTableDataObj.java:2906)
                 at com.thortech.xl.dataobj.tcUserProvisionObject.insertImplementation(tcUserProvisionObject.java:283)
                 at com.thortech.xl.dataobj.tcDataObj.insert(tcDataObj.java:591)
                 at com.thortech.xl.dataobj.tcDataObj.save(tcDataObj.java:474)
                 at oracle.iam.accesspolicy.impl.handlers.provisioning.ProvisionAccountActionHandler.execute(ProvisionAccountActionHandler.java:104)
                 at oracle.iam.accesspolicy.impl.handlers.provisioning.ProvisionAccountActionHandler.execute(ProvisionAccountActionHandler.java:35)
                 at sun.reflect.GeneratedMethodAccessor2179.invoke(Unknown Source)
                 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
                 at java.lang.reflect.Method.invoke(Method.java:597)
                 at oracle.iam.platform.kernel.impl.EventHandlerDynamicProxy.invoke(EventHandlerDynamicProxy.java:30)
                 at $Proxy250.execute(Unknown Source)
                 at oracle.iam.platform.kernel.impl.OrchProcessData.runActionEvents(OrchProcessData.java:1036)
                 at oracle.iam.platform.kernel.impl.OrchProcessData.runEvents(OrchProcessData.java:644)
                 at oracle.iam.platform.kernel.impl.OrchProcessData.executeEvents(OrchProcessData.java:227)
                 at oracle.iam.platform.kernel.impl.OrchestrationEngineImpl.resumeProcess(OrchestrationEngineImpl.java:739)
                 at oracle.iam.platform.kernel.impl.OrchestrationEngineImpl.process(OrchestrationEngineImpl.java:499)
                 at oracle.iam.platform.kernel.impl.OrchestrationEngineImpl.orchestrate(OrchestrationEngineImpl.java:444)
                 at oracle.iam.platform.kernel.impl.OrchestrationEngineImpl.orchestrate(OrchestrationEngineImpl.java:378)
                 at oracle.iam.accesspolicy.impl.AccessPolicyServiceImpl.evalutePoliciesForUser(AccessPolicyServiceImpl.java:182)
                 at oracle.iam.accesspolicy.api.AccessPolicyServiceEJB.evalutePoliciesForUserx(Unknown Source)
                 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
                 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
                 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
                 at java.lang.reflect.Method.invoke(Method.java:597)
                 at com.bea.core.repackaged.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:310)
                 at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
                 at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
                 at com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:131)
                 at com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:119)
                 at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
                 at com.bea.core.repackaged.springframework.jee.spi.MethodInvocationVisitorImpl.visit(MethodInvocationVisitorImpl.java:37)
                 at weblogic.ejb.container.injection.EnvironmentInterceptorCallbackImpl.callback(EnvironmentInterceptorCallbackImpl.java:54)
                 at com.bea.core.repackaged.springframework.jee.spi.EnvironmentInterceptor.invoke(EnvironmentInterceptor.java:50)
                 at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
                 at com.bea.core.repackaged.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)
                 at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
                 at com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:131)
                 at com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:119)
                 at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
                 at com.bea.core.repackaged.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
                 at $Proxy388.evalutePoliciesForUserx(Unknown Source)
                 at oracle.iam.accesspolicy.api.AccessPolicyService_vb2s0z_AccessPolicyServiceRemoteImpl.__WL_invoke(Unknown Source)
                 at weblogic.ejb.container.internal.SessionRemoteMethodInvoker.invoke(SessionRemoteMethodInvoker.java:40)
                 at oracle.iam.accesspolicy.api.AccessPolicyService_vb2s0z_AccessPolicyServiceRemoteImpl.evalutePoliciesForUserx(Unknown Source)
                 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
                 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
                 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
                 at java.lang.reflect.Method.invoke(Method.java:597)
                 at weblogic.ejb.container.internal.RemoteBusinessIntfProxy.invoke(RemoteBusinessIntfProxy.java:85)
                 at $Proxy208.evalutePoliciesForUserx(Unknown Source)
                 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
                 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
                 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
                 at java.lang.reflect.Method.invoke(Method.java:597)
                 at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307)
                 at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:198)
                 at $Proxy387.evalutePoliciesForUserx(Unknown Source)
                 at oracle.iam.accesspolicy.api.AccessPolicyServiceDelegate.evalutePoliciesForUser(Unknown Source)
                 at oracle.iam.identity.rolemgmt.impl.handlers.grantrole.RoleGrantPostProcessActionHandler.evaluateAccessPolicies(RoleGrantPostProcessActionHandler.java:186)
                 at oracle.iam.identity.rolemgmt.impl.handlers.grantrole.RoleGrantPostProcessActionHandler.execute(RoleGrantPostProcessActionHandler.java:116)
                 at oracle.iam.identity.rolemgmt.impl.handlers.grantrole.RoleGrantPostProcessActionHandler.execute(RoleGrantPostProcessActionHandler.java:68)
                 at oracle.iam.platform.kernel.impl.OrchProcessData.runPostProcessEvents(OrchProcessData.java:1167)
                 at oracle.iam.platform.kernel.impl.OrchProcessData.runEvents(OrchProcessData.java:711)
                 at oracle.iam.platform.kernel.impl.OrchProcessData.executeEvents(OrchProcessData.java:227)
                 at oracle.iam.platform.kernel.impl.OrchestrationEngineImpl.resumeProcess(OrchestrationEngineImpl.java:749)
                 at oracle.iam.platform.kernel.impl.OrchestrationEngineImpl.resumeProcess(OrchestrationEngineImpl.java:780)
                 at oracle.iam.platform.kernel.impl.OrhestrationAsyncTask.execute(OrhestrationAsyncTask.java:129)
                 at oracle.iam.platform.async.impl.TaskExecutor.executeUnmanagedTask(TaskExecutor.java:101)
                 at oracle.iam.platform.async.impl.TaskExecutor.execute(TaskExecutor.java:71)
                 at oracle.iam.platform.async.messaging.MessageReceiver.onMessage(MessageReceiver.java:68)
                 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
                 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
                 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
                 at java.lang.reflect.Method.invoke(Method.java:597)
                 at com.bea.core.repackaged.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:310)
                 at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
                 at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
                 at com.bea.core.repackaged.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)
                 at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
                 at com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:131)
                 at com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:119)
                 at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
                 at com.bea.core.repackaged.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
                 at $Proxy386.onMessage(Unknown Source)
                 at weblogic.ejb.container.internal.MDListener.execute(MDListener.java:574)
                 at weblogic.ejb.container.internal.MDListener.transactionalOnMessage(MDListener.java:477)
                 at weblogic.ejb.container.internal.MDListener.onMessage(MDListener.java:379)
                 at weblogic.jms.client.JMSSession.onMessage(JMSSession.java:4659)
                 at weblogic.jms.client.JMSSession.execute(JMSSession.java:4345)
                 at weblogic.jms.client.JMSSession.executeMessage(JMSSession.java:3821)
                 at weblogic.jms.client.JMSSession.access$000(JMSSession.java:115)
                 at weblogic.jms.client.JMSSession$UseForRunnable.run(JMSSession.java:5170)
                 at weblogic.work.SelfTuningWorkManagerImpl$WorkAdapterImpl.run(SelfTuningWorkManagerImpl.java:528)
                 at weblogic.work.ExecuteThread.execute(ExecuteThread.java:209)
                 at weblogic.work.ExecuteThread.run(ExecuteThread.java:178)
            >
            <Dec 10, 2012 10:22:29 AM COT> <Error> <XELLERATE.DATABASE> <BEA-000000> <Class/Method: tcDataBase/readPartialStatement encounter some problems: ORA-00904: "UD_DB_ORA_P_KEY": invalid identifier

            java.sql.SQLSyntaxErrorException: ORA-00904: "UD_DB_ORA_P_KEY": invalid identifier

                 at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:457)
                 at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)
                 at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:889)
                 at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:476)
                 at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:204)
                 at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:540)
                 at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:202)
                 at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:919)
                 at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1261)
                 at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1419)
                 at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1668)
                 at oracle.jdbc.driver.OracleStatementWrapper.executeQuery(OracleStatementWrapper.java:432)
                 at weblogic.jdbc.wrapper.Statement.executeQuery(Statement.java:487)
                 at com.thortech.xl.util.JDBCUtils.executeQuery(JDBCUtils.java:159)
                 at com.thortech.xl.dataaccess.tcDataBase.readPartialStatement(tcDataBase.java:728)
                 at com.thortech.xl.dataobj.tcDataBase.readPartialStatement(tcDataBase.java:271)
                 at com.thortech.xl.dataaccess.tcDataSet.executeQuery(tcDataSet.java:935)
                 at com.thortech.xl.dataobj.tcDataSet.executeQuery(tcDataSet.java:1523)
                 at com.thortech.xl.dataaccess.tcDataSet.executeQuery(tcDataSet.java:903)
                 at com.thortech.xl.dataobj.tcDataSet.executeQuery(tcDataSet.java:1490)
                 at com.thortech.xl.adapterfactory.events.tcAdpEvent.getChildTableFieldValue(tcAdpEvent.java:2261)
                 at com.thortech.xl.adapterfactory.events.tcAdpEvent.getRunTimeValue(tcAdpEvent.java:806)
                 at com.thortech.xl.adapterfactory.events.tcAdpEvent.getRunTimeValue(tcAdpEvent.java:680)
                 at com.thortech.xl.adapterGlue.ScheduleItemEvents.adpBBDORAADDUSERTOGROUP.implementation(adpBBDORAADDUSERTOGROUP.java:50)
                 at com.thortech.xl.client.events.tcBaseEvent.run(tcBaseEvent.java:196)
                 at com.thortech.xl.dataobj.tcDataObj.runEvent(tcDataObj.java:2492)
                 at com.thortech.xl.dataobj.tcScheduleItem.runMilestoneEvent(tcScheduleItem.java:2917)
                 at com.thortech.xl.dataobj.tcScheduleItem.eventPostInsert(tcScheduleItem.java:547)
                 at com.thortech.xl.dataobj.tcDataObj.insert(tcDataObj.java:602)
                 at com.thortech.xl.dataobj.tcDataObj.save(tcDataObj.java:474)
                 at com.thortech.xl.dataobj.tcOrderItemInfo.processChildTableChange(tcOrderItemInfo.java:655)
                 at com.thortech.xl.dataobj.tcOrderItemInfo.eventPostInsert(tcOrderItemInfo.java:184)
                 at com.thortech.xl.dataobj.tcUDProcess.eventPostInsert(tcUDProcess.java:235)
                 at com.thortech.xl.dataobj.tcDataObj.insert(tcDataObj.java:602)
                 at com.thortech.xl.dataobj.tcDataObj.save(tcDataObj.java:474)
                 at com.thortech.xl.dataobj.tcTableDataObj.save(tcTableDataObj.java:2906)
                 at com.thortech.xl.dataobj.tcUDProcess.addUDChildData(tcUDProcess.java:1867)
                 at com.thortech.xl.dataobj.tcUDProcess.eventPostInsert(tcUDProcess.java:363)
                 at com.thortech.xl.dataobj.tcDataObj.insert(tcDataObj.java:602)
                 at com.thortech.xl.dataobj.tcDataObj.save(tcDataObj.java:474)
                 at com.thortech.xl.dataobj.tcTableDataObj.save(tcTableDataObj.java:2906)
                 at com.thortech.xl.dataobj.tcORC.autoDOBSave(tcORC.java:3002)
                 at com.thortech.xl.dataobj.util.tcOrderPackages.createOrder(tcOrderPackages.java:526)
                 at com.thortech.xl.dataobj.util.tcOrderPackages.orderPackageForUser(tcOrderPackages.java:177)
                 at com.thortech.xl.dataobj.tcOIU.provision(tcOIU.java:527)
                 at com.thortech.xl.dataobj.tcOIU.eventPostInsert(tcOIU.java:303)
                 at com.thortech.xl.dataobj.tcDataObj.insert(tcDataObj.java:602)
                 at com.thortech.xl.dataobj.tcDataObj.save(tcDataObj.java:474)
                 at com.thortech.xl.dataobj.tcTableDataObj.save(tcTableDataObj.java:2906)
                 at com.thortech.xl.dataobj.tcUserProvisionObject.insertImplementation(tcUserProvisionObject.java:283)
                 at com.thortech.xl.dataobj.tcDataObj.insert(tcDataObj.java:591)
                 at com.thortech.xl.dataobj.tcDataObj.save(tcDataObj.java:474)
                 at oracle.iam.accesspolicy.impl.handlers.provisioning.ProvisionAccountActionHandler.execute(ProvisionAccountActionHandler.java:104)
                 at oracle.iam.accesspolicy.impl.handlers.provisioning.ProvisionAccountActionHandler.execute(ProvisionAccountActionHandler.java:35)
                 at sun.reflect.GeneratedMethodAccessor2179.invoke(Unknown Source)
                 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
                 at java.lang.reflect.Method.invoke(Method.java:597)
                 at oracle.iam.platform.kernel.impl.EventHandlerDynamicProxy.invoke(EventHandlerDynamicProxy.java:30)
                 at $Proxy250.execute(Unknown Source)
                 at oracle.iam.platform.kernel.impl.OrchProcessData.runActionEvents(OrchProcessData.java:1036)
                 at oracle.iam.platform.kernel.impl.OrchProcessData.runEvents(OrchProcessData.java:644)
                 at oracle.iam.platform.kernel.impl.OrchProcessData.executeEvents(OrchProcessData.java:227)
                 at oracle.iam.platform.kernel.impl.OrchestrationEngineImpl.resumeProcess(OrchestrationEngineImpl.java:739)
                 at oracle.iam.platform.kernel.impl.OrchestrationEngineImpl.process(OrchestrationEngineImpl.java:499)
                 at oracle.iam.platform.kernel.impl.OrchestrationEngineImpl.orchestrate(OrchestrationEngineImpl.java:444)
                 at oracle.iam.platform.kernel.impl.OrchestrationEngineImpl.orchestrate(OrchestrationEngineImpl.java:378)
                 at oracle.iam.accesspolicy.impl.AccessPolicyServiceImpl.evalutePoliciesForUser(AccessPolicyServiceImpl.java:182)
                 at oracle.iam.accesspolicy.api.AccessPolicyServiceEJB.evalutePoliciesForUserx(Unknown Source)
                 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
                 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
                 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
                 at java.lang.reflect.Method.invoke(Method.java:597)
                 at com.bea.core.repackaged.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:310)
                 at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
                 at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
                 at com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:131)
                 at com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:119)
                 at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
                 at com.bea.core.repackaged.springframework.jee.spi.MethodInvocationVisitorImpl.visit(MethodInvocationVisitorImpl.java:37)
                 at weblogic.ejb.container.injection.EnvironmentInterceptorCallbackImpl.callback(EnvironmentInterceptorCallbackImpl.java:54)
                 at com.bea.core.repackaged.springframework.jee.spi.EnvironmentInterceptor.invoke(EnvironmentInterceptor.java:50)
                 at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
                 at com.bea.core.repackaged.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)
                 at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
                 at com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:131)
                 at com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:119)
                 at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
                 at com.bea.core.repackaged.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
                 at $Proxy388.evalutePoliciesForUserx(Unknown Source)
                 at oracle.iam.accesspolicy.api.AccessPolicyService_vb2s0z_AccessPolicyServiceRemoteImpl.__WL_invoke(Unknown Source)
                 at weblogic.ejb.container.internal.SessionRemoteMethodInvoker.invoke(SessionRemoteMethodInvoker.java:40)
                 at oracle.iam.accesspolicy.api.AccessPolicyService_vb2s0z_AccessPolicyServiceRemoteImpl.evalutePoliciesForUserx(Unknown Source)
                 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
                 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
                 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
                 at java.lang.reflect.Method.invoke(Method.java:597)
                 at weblogic.ejb.container.internal.RemoteBusinessIntfProxy.invoke(RemoteBusinessIntfProxy.java:85)
                 at $Proxy208.evalutePoliciesForUserx(Unknown Source)
                 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
                 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
                 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
                 at java.lang.reflect.Method.invoke(Method.java:597)
                 at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307)
                 at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:198)
                 at $Proxy387.evalutePoliciesForUserx(Unknown Source)
                 at oracle.iam.accesspolicy.api.AccessPolicyServiceDelegate.evalutePoliciesForUser(Unknown Source)
                 at oracle.iam.identity.rolemgmt.impl.handlers.grantrole.RoleGrantPostProcessActionHandler.evaluateAccessPolicies(RoleGrantPostProcessActionHandler.java:186)
                 at oracle.iam.identity.rolemgmt.impl.handlers.grantrole.RoleGrantPostProcessActionHandler.execute(RoleGrantPostProcessActionHandler.java:116)
                 at oracle.iam.identity.rolemgmt.impl.handlers.grantrole.RoleGrantPostProcessActionHandler.execute(RoleGrantPostProcessActionHandler.java:68)
                 at oracle.iam.platform.kernel.impl.OrchProcessData.runPostProcessEvents(OrchProcessData.java:1167)
                 at oracle.iam.platform.kernel.impl.OrchProcessData.runEvents(OrchProcessData.java:711)
                 at oracle.iam.platform.kernel.impl.OrchProcessData.executeEvents(OrchProcessData.java:227)
                 at oracle.iam.platform.kernel.impl.OrchestrationEngineImpl.resumeProcess(OrchestrationEngineImpl.java:749)
                 at oracle.iam.platform.kernel.impl.OrchestrationEngineImpl.resumeProcess(OrchestrationEngineImpl.java:780)
                 at oracle.iam.platform.kernel.impl.OrhestrationAsyncTask.execute(OrhestrationAsyncTask.java:129)
                 at oracle.iam.platform.async.impl.TaskExecutor.executeUnmanagedTask(TaskExecutor.java:101)
                 at oracle.iam.platform.async.impl.TaskExecutor.execute(TaskExecutor.java:71)
                 at oracle.iam.platform.async.messaging.MessageReceiver.onMessage(MessageReceiver.java:68)
                 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
                 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
                 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
                 at java.lang.reflect.Method.invoke(Method.java:597)
                 at com.bea.core.repackaged.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:310)
                 at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
                 at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
                 at com.bea.core.repackaged.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)
                 at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
                 at com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:131)
                 at com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:119)
                 at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
                 at com.bea.core.repackaged.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
                 at $Proxy386.onMessage(Unknown Source)
                 at weblogic.ejb.container.internal.MDListener.execute(MDListener.java:574)
                 at weblogic.ejb.container.internal.MDListener.transactionalOnMessage(MDListener.java:477)
                 at weblogic.ejb.container.internal.MDListener.onMessage(MDListener.java:379)
                 at weblogic.jms.client.JMSSession.onMessage(JMSSession.java:4659)
                 at weblogic.jms.client.JMSSession.execute(JMSSession.java:4345)
                 at weblogic.jms.client.JMSSession.executeMessage(JMSSession.java:3821)
                 at weblogic.jms.client.JMSSession.access$000(JMSSession.java:115)
                 at weblogic.jms.client.JMSSession$UseForRunnable.run(JMSSession.java:5170)
                 at weblogic.work.SelfTuningWorkManagerImpl$WorkAdapterImpl.run(SelfTuningWorkManagerImpl.java:528)
                 at weblogic.work.ExecuteThread.execute(ExecuteThread.java:209)
                 at weblogic.work.ExecuteThread.run(ExecuteThread.java:178)

            thank you.!!!
            • 3. Re: Error granting privileges and roles with a cloned DBUM connector oim11g
              Rajiv Dewan
              Are you getting this error with cloned RO because error includes OOTB form name UD_DB_ORA_P?

              It seems there is some issue with the cloning.

              Verify the generated XML and search for above field
              Verify the newly created Lookups for above value
              • 4. Re: Error granting privileges and roles with a cloned DBUM connector oim11g
                952827
                i run this select : select UD_DBBAN24P_KEY from UD_DBBAN24P where UD_DBBAN24P_KEY = 1 and this was correct!
                but the error shows select UD_DB_ORA_P_KEY from UD_DBBAN24P where UD_DBBAN24P_KEY = 1 and this is the error the UD_DB_ORA_P_KEY field doesnt exist.! where i can change this query? i verified the xml generated and its ok i didnt find the UD_DB_ORA_P i find the UD_DBBAN24P
                <FormHierarchy repo-type="RDBMS">
                <SDH_CHILD_VERSION>0</SDH_CHILD_VERSION>
                <SDH_PARENT_VERSION>0</SDH_PARENT_VERSION>
                <SDH_UPDATE>1330584300000</SDH_UPDATE>
                <SDH_CHILD_KEY Form="UD_DBBAN24P"/>
                </FormHierarchy>
                </Form>
                <Form repo-type="RDBMS" name="UD_DBBAN24P" subtype="Process Form">
                <SDK_ORC>1</SDK_ORC>
                <SDK_SCHEMA>SILENTPS1_OIM</SDK_SCHEMA>
                <SDK_UPDATE>1330584298000</SDK_UPDATE>
                <SDK_FORM_DESCRIPTION>DBUM Grant/Revoke Privileges</SDK_FORM_DESCRIPTION>
                <SDK_ACTIVE_VERSION>0</SDK_ACTIVE_VERSION>
                <SDK_LATEST_VERSION>0</SDK_LATEST_VERSION>
                <SDK_TYPE>P</SDK_TYPE>
                <source-scope type="Form" name="UD_DBBAN24U" subtype="Process Form">
                <source-scope type="Process" name="Oracle DB User ban24">
                <source-scope type="Resource" name="Oracle DB User ban24"/>
                </source-scope>
                </source-scope>

                how can i upload the xml to this forum?
                thank you.!
                • 5. Re: Error granting privileges and roles with a cloned DBUM connector oim11g
                  Rajiv Dewan
                  Don't search for UD_DB_ORA_P_KEY, search for UD_DB_ORA_P


                  Send me at my email address (It's there in my profile)

                  RO XML
                  Lookup XMLs
                  Log File
                  • 6. Re: Error granting privileges and roles with a cloned DBUM connector oim11g
                    952827
                    hi rajiv i wrote u from my gmail email. the subject is like this forum.
                    thank you.!