7 Replies Latest reply: Nov 9, 2012 7:44 AM by 971772 RSS

    DBUM 9.1.0.4.0 add role task rejected

    971772
      Hi all, I'm facing some problems with dbum connector. When i'm provisioning a user, the account is being created in target system but roles are not being granted. When I see "Resource History" i notice that the "Add Role or Grant" task is rejected. The user has all the permissions.

      does somebody face something like this?. Every response will be appreciated,

      thanks in advance,

      Guido
        • 1. Re: DBUM 9.1.0.4.0 add role task rejected
          Nishith Nayan
          are you using sys user in IT Resource. make sure the user has admin privillege.

          Share connector or oim console log for same
          • 2. Re: DBUM 9.1.0.4.0 add role task rejected
            971772
            thanks for your quick response. I made the same test (grant role) in db (oracle db) with the same user that is configured in the IT resource and it worked fine, so i think that user's privilegies are not the trouble here.

            here is the log:

            [2012-10-31T19:22:58.665-03:00] [oim_server1] [TRACE] [] [OIMCP.DBUM] [tid: [ACTIVE].ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: xelsysadm] [ecid: b5b137796995ea37:-53f1ad5e:13ab2c66c07:-8000-0000000000006b66,0] [SRC_CLASS: com.thortech.util.logging.Logger] [APP: oim#11.1.1.3.0] [SRC_METHOD: debug] oracle.iam.connectors.dbum.common.db.util.DBConnection : getNonPooledConnection:: FINISHED
            [2012-10-31T19:22:58.669-03:00] [oim_server1] [ERROR] [] [OIMCP.DBUM] [tid: [ACTIVE].ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: xelsysadm] [ecid: b5b137796995ea37:-53f1ad5e:13ab2c66c07:-8000-0000000000006b66,0] [APP: oim#11.1.1.3.0] ================= Start Stack Trace =======================
            [2012-10-31T19:22:58.670-03:00] [oim_server1] [ERROR] [] [OIMCP.DBUM] [tid: [ACTIVE].ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: xelsysadm] [ecid: b5b137796995ea37:-53f1ad5e:13ab2c66c07:-8000-0000000000006b66,0] [APP: oim#11.1.1.3.0] oracle.iam.connectors.dbum.common.db.util.DBUtil : executeQuery
            [2012-10-31T19:22:58.671-03:00] [oim_server1] [ERROR] [] [OIMCP.DBUM] [tid: [ACTIVE].ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: xelsysadm] [ecid: b5b137796995ea37:-53f1ad5e:13ab2c66c07:-8000-0000000000006b66,0] [APP: oim#11.1.1.3.0] Error occurred while trying to execute query.
            [2012-10-31T19:22:58.672-03:00] [oim_server1] [ERROR] [] [OIMCP.DBUM] [tid: [ACTIVE].ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: xelsysadm] [ecid: b5b137796995ea37:-53f1ad5e:13ab2c66c07:-8000-0000000000006b66,0] [APP: oim#11.1.1.3.0] Description : ORA-01741: identificador de longitud cero no válido[[

            ]]
            [2012-10-31T19:22:58.673-03:00] [oim_server1] [ERROR] [] [OIMCP.DBUM] [tid: [ACTIVE].ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: xelsysadm] [ecid: b5b137796995ea37:-53f1ad5e:13ab2c66c07:-8000-0000000000006b66,0] [APP: oim#11.1.1.3.0] java.sql.SQLSyntaxErrorException: ORA-01741: identificador de longitud cero no válido[[

                 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.executeForRows(T4CStatement.java:1074)
                 at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1466)
                 at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:2224)
                 at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:2168)
                 at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:333)
                 at oracle.iam.connectors.dbum.common.db.util.DBUtil.executeQuery(Unknown Source)
                 at oracle.iam.connectors.dbum.common.db.util.DBUtil.executeQuery(Unknown Source)
                 at oracle.iam.connectors.dbum.operation.DBUMDatabaseOperation.executeQuery(Unknown Source)
                 at oracle.iam.connectors.dbum.integration.DBUMProvisionProxyManager.executeQuery(Unknown Source)
                 at oracle.iam.connectors.dbum.integration.DBUMProvisionManager.executeQuery(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.thortech.xl.adapterGlue.ScheduleItemEvents.adpDBUMEXECUTEQUERY.EXECUTEQUERY(adpDBUMEXECUTEQUERY.java:178)
                 at com.thortech.xl.adapterGlue.ScheduleItemEvents.adpDBUMEXECUTEQUERY.implementation(adpDBUMEXECUTEQUERY.java:87)
                 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:234)
                 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.ejb.beansimpl.tcFormInstanceOperationsBean.addProcessFormChildData(tcFormInstanceOperationsBean.java:1929)
                 at com.thortech.xl.ejb.beansimpl.tcFormInstanceOperationsBean.addProcessFormChildData(tcFormInstanceOperationsBean.java:1593)
                 at Thor.API.Operations.tcFormInstanceOperationsIntfEJB.addProcessFormChildDatax(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 $Proxy352.addProcessFormChildDatax(Unknown Source)
                 at Thor.API.Operations.tcFormInstanceOperationsIntfEJB_h6wb8n_tcFormInstanceOperationsIntfRemoteImpl.__WL_invoke(Unknown Source)
                 at weblogic.ejb.container.internal.SessionRemoteMethodInvoker.invoke(SessionRemoteMethodInvoker.java:40)
                 at Thor.API.Operations.tcFormInstanceOperationsIntfEJB_h6wb8n_tcFormInstanceOperationsIntfRemoteImpl.addProcessFormChildDatax(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 $Proxy175.addProcessFormChildDatax(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 $Proxy351.addProcessFormChildDatax(Unknown Source)
                 at Thor.API.Operations.tcFormInstanceOperationsIntfDelegate.addProcessFormChildData(Unknown Source)
                 at com.thortech.xl.webclient.actions.DirectProvisionUserAction.handleVerifyProcessData(DirectProvisionUserAction.java:2093)
                 at com.thortech.xl.webclient.actions.DirectProvisionUserAction.goNext(DirectProvisionUserAction.java:363)
                 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.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:269)
                 at com.thortech.xl.webclient.actions.tcLookupDispatchAction.execute(tcLookupDispatchAction.java:133)
                 at com.thortech.xl.webclient.actions.tcActionBase.execute(tcActionBase.java:894)
                 at com.thortech.xl.webclient.actions.tcAction.execute(tcAction.java:213)
                 at org.apache.struts.chain.commands.servlet.ExecuteAction.execute(ExecuteAction.java:58)
                 at org.apache.struts.chain.commands.AbstractExecuteAction.execute(AbstractExecuteAction.java:67)
                 at org.apache.struts.chain.commands.ActionCommandBase.execute(ActionCommandBase.java:51)
                 at org.apache.commons.chain.impl.ChainBase.execute(ChainBase.java:191)
                 at org.apache.commons.chain.generic.LookupCommand.execute(LookupCommand.java:305)
                 at org.apache.commons.chain.impl.ChainBase.execute(ChainBase.java:191)
                 at org.apache.struts.chain.ComposableRequestProcessor.process(ComposableRequestProcessor.java:283)
                 at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913)
                 at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:462)
                 at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
                 at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
                 at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)
                 at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)
                 at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:300)
                 at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:26)
                 at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
                 at com.thortech.xl.webclient.security.CSRFFilter.doFilter(CSRFFilter.java:76)
                 at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
                 at oracle.iam.platform.auth.web.PwdMgmtNavigationFilter.doFilter(PwdMgmtNavigationFilter.java:121)
                 at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
                 at oracle.iam.platform.auth.web.OIMAuthContextFilter.doFilter(OIMAuthContextFilter.java:107)
                 at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
                 at oracle.security.jps.ee.http.JpsAbsFilter$1.run(JpsAbsFilter.java:111)
                 at java.security.AccessController.doPrivileged(Native Method)
                 at oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:313)
                 at oracle.security.jps.ee.util.JpsPlatformUtil.runJaasMode(JpsPlatformUtil.java:413)
                 at oracle.security.jps.ee.http.JpsAbsFilter.runJaasMode(JpsAbsFilter.java:94)
                 at oracle.security.jps.ee.http.JpsAbsFilter.doFilter(JpsAbsFilter.java:161)
                 at oracle.security.jps.ee.http.JpsFilter.doFilter(JpsFilter.java:71)
                 at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
                 at oracle.dms.servlet.DMSServletFilter.doFilter(DMSServletFilter.java:136)
                 at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
                 at weblogic.servlet.internal.RequestEventsFilter.doFilter(RequestEventsFilter.java:27)
                 at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
                 at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3715)
                 at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3681)
                 at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
                 at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)
                 at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2277)
                 at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2183)
                 at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1454)
                 at weblogic.work.ExecuteThread.execute(ExecuteThread.java:209)
                 at weblogic.work.ExecuteThread.run(ExecuteThread.java:178)

            ]]
            [2012-10-31T19:22:58.674-03:00] [oim_server1] [ERROR] [] [OIMCP.DBUM] [tid: [ACTIVE].ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: xelsysadm] [ecid: b5b137796995ea37:-53f1ad5e:13ab2c66c07:-8000-0000000000006b66,0] [APP: oim#11.1.1.3.0] ================= End Stack Trace =======================
            [2012-10-31T19:22:58.674-03:00] [oim_server1] [TRACE] [] [OIMCP.DBUM] [tid: [ACTIVE].ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: xelsysadm] [ecid: b5b137796995ea37:-53f1ad5e:13ab2c66c07:-8000-0000000000006b66,0] [SRC_CLASS: com.thortech.util.logging.Logger] [APP: oim#11.1.1.3.0] [SRC_METHOD: debug] oracle.iam.connectors.dbum.common.db.util.DBConnection : closeConnection:: STARTED
            [2012-10-31T19:22:58.675-03:00] [oim_server1] [TRACE] [] [OIMCP.DBUM] [tid: [ACTIVE].ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: xelsysadm] [ecid: b5b137796995ea37:-53f1ad5e:13ab2c66c07:-8000-0000000000006b66,0] [SRC_CLASS: com.thortech.util.logging.Logger] [APP: oim#11.1.1.3.0] [SRC_METHOD: debug] oracle.iam.connectors.dbum.common.db.util.DBConnection : closeConnection : Connection closed....
            [2012-10-31T19:22:58.677-03:00] [oim_server1] [TRACE] [] [OIMCP.DBUM] [tid: [ACTIVE].ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: xelsysadm] [ecid: b5b137796995ea37:-53f1ad5e:13ab2c66c07:-8000-0000000000006b66,0] [SRC_CLASS: com.thortech.util.logging.Logger] [APP: oim#11.1.1.3.0] [SRC_METHOD: debug] oracle.iam.connectors.dbum.common.db.util.DBConnection : closeConnection:: FINISHED
            [2012-10-31T19:22:58.678-03:00] [oim_server1] [TRACE] [] [OIMCP.DBUM] [tid: [ACTIVE].ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: xelsysadm] [ecid: b5b137796995ea37:-53f1ad5e:13ab2c66c07:-8000-0000000000006b66,0] [SRC_CLASS: com.thortech.util.logging.Logger] [APP: oim#11.1.1.3.0] [SRC_METHOD: debug] oracle.iam.connectors.dbum.integration.DBUMProvisionProxyManager : executeQuery : result:- 1741
            [2012-10-31T19:22:58.679-03:00] [oim_server1] [TRACE] [] [OIMCP.DBUM] [tid: [ACTIVE].ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: xelsysadm] [ecid: b5b137796995ea37:-53f1ad5e:13ab2c66c07:-8000-0000000000006b66,0] [SRC_CLASS: com.thortech.util.logging.Logger] [APP: oim#11.1.1.3.0] [SRC_METHOD: debug] oracle.iam.connectors.dbum.integration.DBUMProvisionProxyManager : executeQuery:: FINISHED
            [2012-10-31T19:22:58.679-03:00] [oim_server1] [TRACE] [] [OIMCP.DBUM] [tid: [ACTIVE].ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: xelsysadm] [ecid: b5b137796995ea37:-53f1ad5e:13ab2c66c07:-8000-0000000000006b66,0] [SRC_CLASS: com.thortech.util.logging.Logger] [APP: oim#11.1.1.3.0] [SRC_METHOD: debug] oracle.iam.connectors.dbum.integration.DBUMProvisionManager : executeQuery : Error code received: 1741
            [2012-10-31T19:22:58.680-03:00] [oim_server1] [TRACE] [] [OIMCP.DBUM] [tid: [ACTIVE].ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: xelsysadm] [ecid: b5b137796995ea37:-53f1ad5e:13ab2c66c07:-8000-0000000000006b66,0] [SRC_CLASS: com.thortech.util.logging.Logger] [APP: oim#11.1.1.3.0] [SRC_METHOD: debug] oracle.iam.connectors.dbum.integration.DBUMProvisionManager : getErrorCodeKey:: STARTED
            [2012-10-31T19:22:58.681-03:00] [oim_server1] [TRACE] [] [OIMCP.DBUM] [tid: [ACTIVE].ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: xelsysadm] [ecid: b5b137796995ea37:-53f1ad5e:13ab2c66c07:-8000-0000000000006b66,0] [SRC_CLASS: com.thortech.util.logging.Logger] [APP: oim#11.1.1.3.0] [SRC_METHOD: debug] oracle.iam.connectors.dbum.integration.DBUMProvisionManager : getErrorCodeKey : return code to be looked for:1741
            [2012-10-31T19:22:58.681-03:00] [oim_server1] [TRACE] [] [OIMCP.DBUM] [tid: [ACTIVE].ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: xelsysadm] [ecid: b5b137796995ea37:-53f1ad5e:13ab2c66c07:-8000-0000000000006b66,0] [SRC_CLASS: com.thortech.util.logging.Logger] [APP: oim#11.1.1.3.0] [SRC_METHOD: debug] oracle.iam.connectors.dbum.integration.DBUMProvisionManager : getErrorCodeKey : Error code lookup name :Lookup.DBUM.Oracle.Error.Mapping
            [2012-10-31T19:22:58.682-03:00] [oim_server1] [TRACE] [] [OIMCP.DBUM] [tid: [ACTIVE].ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: xelsysadm] [ecid: b5b137796995ea37:-53f1ad5e:13ab2c66c07:-8000-0000000000006b66,0] [SRC_CLASS: com.thortech.util.logging.Logger] [APP: oim#11.1.1.3.0] [SRC_METHOD: debug] oracle.iam.connectors.common.dao.OIMUtil : getLookUpMap():: STARTED
            [2012-10-31T19:22:58.683-03:00] [oim_server1] [TRACE] [] [OIMCP.DBUM] [tid: [ACTIVE].ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: xelsysadm] [ecid: b5b137796995ea37:-53f1ad5e:13ab2c66c07:-8000-0000000000006b66,0] [SRC_CLASS: com.thortech.util.logging.Logger] [APP: oim#11.1.1.3.0] [SRC_METHOD: debug] oracle.iam.connectors.common.dao.OIMUtil : getLookUpMap() : LookUpName : Lookup.DBUM.Oracle.Error.Mapping
            [2012-10-31T19:22:58.695-03:00] [oim_server1] [TRACE] [] [OIMCP.DBUM] [tid: [ACTIVE].ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: xelsysadm] [ecid: b5b137796995ea37:-53f1ad5e:13ab2c66c07:-8000-0000000000006b66,0] [SRC_CLASS: com.thortech.util.logging.Logger] [APP: oim#11.1.1.3.0] [SRC_METHOD: debug] oracle.iam.connectors.common.dao.OIMUtil : getLookUpMap():: FINISHED
            [2012-10-31T19:22:58.696-03:00] [oim_server1] [TRACE] [] [OIMCP.DBUM] [tid: [ACTIVE].ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: xelsysadm] [ecid: b5b137796995ea37:-53f1ad5e:13ab2c66c07:-8000-0000000000006b66,0] [SRC_CLASS: com.thortech.util.logging.Logger] [APP: oim#11.1.1.3.0] [SRC_METHOD: debug] oracle.iam.connectors.dbum.integration.DBUMProvisionManager : getErrorCodeKey : Error code lookup map :{959=INVALID_TABLE_NAME, 1935=MISSING_ROLE, 1920=USER_ALREADY_EXIST, 1031=INSUFFICIENT_PRIVILEGE, 50004=CHILDNAME_NOT_PROVIDED, 900=INVALID_SQL, 998=INVALID_PASSWORD}
            [2012-10-31T19:22:58.697-03:00] [oim_server1] [TRACE] [] [OIMCP.DBUM] [tid: [ACTIVE].ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: xelsysadm] [ecid: b5b137796995ea37:-53f1ad5e:13ab2c66c07:-8000-0000000000006b66,0] [SRC_CLASS: com.thortech.util.logging.Logger] [APP: oim#11.1.1.3.0] [SRC_METHOD: debug] oracle.iam.connectors.dbum.integration.DBUMProvisionManager : getErrorCodeKey:: FINISHED
            [2012-10-31T19:22:58.946-03:00] [oim_server1] [NOTIFICATION] [IAM-0060016] [oracle.iam.platform.auth.impl] [tid: [ACTIVE].ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: xelsysadm] [ecid: b5b137796995ea37:-53f1ad5e:13ab2c66c07:-8000-0000000000006b68,0] [APP: oim#11.1.1.3.0] La dirección IP desde la que se dispara el explorador es 130.120.5.9
            [2012-10-31T19:22:58.950-03:00] [oim_server1] [NOTIFICATION] [IAM-0060016] [oracle.iam.platform.auth.impl] [tid: [ACTIVE].ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: xelsysadm] [ecid: b5b137796995ea37:-53f1ad5e:13ab2c66c07:-8000-0000000000006b6a,0] [APP: oim#11.1.1.3.0] La dirección IP desde la que se dispara el explorador es 130.120.5.9
            [2012-10-31T19:22:58.950-03:00] [oim_server1] [NOTIFICATION] [IAM-0060016] [oracle.iam.platform.auth.impl] [tid: [ACTIVE].ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: xelsysadm] [ecid: b5b137796995ea37:-53f1ad5e:13ab2c66c07:-8000-0000000000006b6c,0] [APP: oim#11.1.1.3.0] La dirección IP desde la que se dispara el explorador es 130.120.5.9
            [2012-10-31T19:22:58.950-03:00] [oim_server1] [NOTIFICATION] [IAM-0060016] [oracle.iam.platform.auth.impl] [tid: [ACTIVE].ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: xelsysadm] [ecid: b5b137796995ea37:-53f1ad5e:13ab2c66c07:-8000-0000000000006b6e,0] [APP: oim#11.1.1.3.0] La dirección IP desde la que se dispara el explorador es 130.120.5.9
            [2012-10-31T19:22:58.967-03:00] [oim_server1] [NOTIFICATION] [IAM-0060016] [oracle.iam.platform.auth.impl] [tid: [ACTIVE].ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: xelsysadm] [ecid: b5b137796995ea37:-53f1ad5e:13ab2c66c07:-8000-0000000000006b70,0] [APP: oim#11.1.1.3.0] La dirección IP desde la que se dispara el explorador es 130.120.5.9
            [2012-10-31T19:23:06.811-03:00] [oim_server1] [NOTIFICATION] [IAM-0060016] [oracle.iam.platform.auth.impl] [tid: [ACTIVE].ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: xelsysadm] [ecid: b5b137796995ea37:-53f1ad5e:13ab2c66c07:-8000-0000000000006b72,0] [APP: oim#11.1.1.3.0] La dirección IP desde la que se dispara el explorador es 130.120.5.9
            [2012-10-31T19:23:06.834-03:00] [oim_server1] [NOTIFICATION] [IAM-1010010] [oracle.iam.platform.authz.impl] [tid: [ACTIVE].ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: xelsysadm] [ecid: b5b137796995ea37:-53f1ad5e:13ab2c66c07:-8000-0000000000006b72,0] [APP: oim#11.1.1.3.0] ********** Entrando en el segmento de autorización con los parámetros:: LoggedInUserId = 1, target resourceID = 126, Feature = USER_MANAGEMENT, Action = VIEW_USER_DETAILS **********
            [2012-10-31T19:23:06.834-03:00] [oim_server1] [NOTIFICATION] [IAM-1010029] [oracle.iam.platform.authz.impl] [tid: [ACTIVE].ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: xelsysadm] [ecid: b5b137796995ea37:-53f1ad5e:13ab2c66c07:-8000-0000000000006b72,0] [APP: oim#11.1.1.3.0] Se han encontrado resultados de OES en caché con la clave F: USER_MANAGEMENTS: 1P: VIEW_USER_DETAILSOESDefinition
            [2012-10-31T19:23:06.834-03:00] [oim_server1] [NOTIFICATION] [IAM-1010021] [oracle.iam.platform.authz.impl] [tid: [ACTIVE].ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: xelsysadm] [ecid: b5b137796995ea37:-53f1ad5e:13ab2c66c07:-8000-0000000000006b72,0] [APP: oim#11.1.1.3.0] Validando las obligaciones internas: [InternalObligation: name: VIEW_USER_DETAILS, values: [ALL_ATTRIB_OBLI], convertToObligation: true, InternalObligation: name: noop, values: [true], convertToObligation: false, InternalObligation: name: UDCAO, values: [true], convertToObligation: false, InternalObligation: name: MODIFY_USER_PROFILE, values: [ALL_ATTRIB_OBLI], convertToObligation: false, InternalObligation: name: VIEW_USER_DETAILS, values: [ALL_ATTRIB_OBLI], convertToObligation: true, InternalObligation: name: noop, values: [true], convertToObligation: false, InternalObligation: name: UDCAO, values: [true], convertToObligation: false, InternalObligation: name: MODIFY_USER_PROFILE, values: [ALL_ATTRIB_OBLI], convertToObligation: false]
            [2012-10-31T19:23:06.834-03:00] [oim_server1] [NOTIFICATION] [IAM-1010022] [oracle.iam.platform.authz.impl] [tid: [ACTIVE].ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: xelsysadm] [ecid: b5b137796995ea37:-53f1ad5e:13ab2c66c07:-8000-0000000000006b72,0] [APP: oim#11.1.1.3.0] ---------- Se ha cumplido la lista de obligaciones internas, devolviendo TRUE ----------
            [2012-10-31T19:23:06.834-03:00] [oim_server1] [NOTIFICATION] [IAM-1010021] [oracle.iam.platform.authz.impl] [tid: [ACTIVE].ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: xelsysadm] [ecid: b5b137796995ea37:-53f1ad5e:13ab2c66c07:-8000-0000000000006b72,0] [APP: oim#11.1.1.3.0] Validando las obligaciones internas: [InternalObligation: name: VIEW_USER_DETAILS, values: [usr_key, LDAP GUID, Status, usr_manager_key, User Login], convertToObligation: true, InternalObligation: name: noop, values: [true], convertToObligation: false, InternalObligation: name: UDCAO, values: [true], convertToObligation: false]
            [2012-10-31T19:23:06.834-03:00] [oim_server1] [NOTIFICATION] [IAM-1010022] [oracle.iam.platform.authz.impl] [tid: [ACTIVE].ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: xelsysadm] [ecid: b5b137796995ea37:-53f1ad5e:13ab2c66c07:-8000-0000000000006b72,0] [APP: oim#11.1.1.3.0] ---------- Se ha cumplido la lista de obligaciones internas, devolviendo TRUE ----------
            [2012-10-31T19:23:06.834-03:00] [oim_server1] [NOTIFICATION] [IAM-1010021] [oracle.iam.platform.authz.impl] [tid: [ACTIVE].ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: xelsysadm] [ecid: b5b137796995ea37:-53f1ad5e:13ab2c66c07:-8000-0000000000006b72,0] [APP: oim#11.1.1.3.0] Validando las obligaciones internas: [InternalObligation: name: VIEW_USER_DETAILS, values: [usr_key, Full Name, Display Name, User Login, First Name, Last Name, act_key, Status, usr_manager_key], convertToObligation: true, InternalObligation: name: noop, values: [true], convertToObligation: false, InternalObligation: name: UDCAO, values: [true], convertToObligation: false, InternalObligation: name: VIEW_USER_DETAILS, values: [usr_key, Full Name, Display Name, User Login, First Name, Last Name, act_key, Status, usr_manager_key], convertToObligation: true, InternalObligation: name: noop, values: [true], convertToObligation: false, InternalObligation: name: UDCAO, values: [true], convertToObligation: false, InternalObligation: name: VIEW_USER_DETAILS, values: [usr_key, Full Name, Display Name, User Login, First Name, Last Name, act_key, Status, usr_manager_key], convertToObligation: true, InternalObligation: name: noop, values: [true], convertToObligation: false, InternalObligation: name: UDCAO, values: [true], convertToObligation: false, InternalObligation: name: VIEW_USER_DETAILS, values: [usr_key, Full Name, Display Name, User Login, First Name, Last Name, act_key, Status, usr_manager_key], convertToObligation: true, InternalObligation: name: noop, values: [true], convertToObligation: false, InternalObligation: name: UDCAO, values: [true], convertToObligation: false]
            [2012-10-31T19:23:06.834-03:00] [oim_server1] [NOTIFICATION] [IAM-1010022] [oracle.iam.platform.authz.impl] [tid: [ACTIVE].ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: xelsysadm] [ecid: b5b137796995ea37:-53f1ad5e:13ab2c66c07:-8000-0000000000006b72,0] [APP: oim#11.1.1.3.0] ---------- Se ha cumplido la lista de obligaciones internas, devolviendo TRUE ----------
            [2012-10-31T19:23:06.834-03:00] [oim_server1] [NOTIFICATION] [IAM-1010026] [oracle.iam.platform.authz.impl] [tid: [ACTIVE].ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: xelsysadm] [ecid: b5b137796995ea37:-53f1ad5e:13ab2c66c07:-8000-0000000000006b72,0] [APP: oim#11.1.1.3.0] ********** Saliendo del segmento de autorización con resultado Decision :PERMIT[[
            Obligations from policy:
            Name: VIEW_USER_DETAILS values: [ALL_ATTRIB_OBLI]
            Name: UDCAO values: [true]
            Name: MODIFY_USER_PROFILE values: [ALL_ATTRIB_OBLI]
            Name: VIEW_USER_DETAILS values: [ALL_ATTRIB_OBLI]
            Name: UDCAO values: [true]
            Name: MODIFY_USER_PROFILE values: [ALL_ATTRIB_OBLI]
            Obligations from policy:
            Name: VIEW_USER_DETAILS values: [usr_key, LDAP GUID, Status, usr_manager_key, User Login]
            Name: UDCAO values: [true]
            Obligations from policy:
            Name: VIEW_USER_DETAILS values: [usr_key, Full Name, Display Name, User Login, First Name, Last Name, act_key, Status, usr_manager_key]
            Name: UDCAO values: [true]
            Name: VIEW_USER_DETAILS values: [usr_key, Full Name, Display Name, User Login, First Name, Last Name, act_key, Status, usr_manager_key]
            Name: UDCAO values: [true]
            Name: VIEW_USER_DETAILS values: [usr_key, Full Name, Display Name, User Login, First Name, Last Name, act_key, Status, usr_manager_key]
            Name: UDCAO values: [true]
            Name: VIEW_USER_DETAILS values: [usr_key, Full Name, Display Name, User Login, First Name, Last Name, act_key, Status, usr_manager_key]
            Name: UDCAO values: [true] **********
            ]]


            thanks again!

            Guido
            • 3. Re: DBUM 9.1.0.4.0 add role task rejected
              Dhananjay Neeraj2
              java.sql.SQLSyntaxErrorException: ORA-01741: identificador de longitud cero no válido

              ORA-01741:     illegal zero-length identifier
              Cause:     An attempt was made to use two double quotes ("") as an identifier. An identifier must be at least one character long.
              Action:     Insert at least one character between the double quotes in the identifier. If a blank identifier is required, specify a blank space between the double quotes (" ").

              So, please revisit your "Add Role or Grant" task.. Figure out where the identifier is zero-length...

              There can't be anything wrong in the code... OOTB code.. Means the Adapter Mapping might be mistaken... Or any lookup...

              Lookup.DBUM.Oracle.Query.Configuration

              ORA_ADD_ROLE
              GRANT :ora_role_name TO :ora_user_id_external~ROLE_WITH_ADMIN_OPTION

              Take a look whether this lookup or this entry is not tampered with
              • 4. Re: DBUM 9.1.0.4.0 add role task rejected
                971772
                Hi again... we took a look at that lookup and that entry was OK.

                In my "Add role or grant" task, in integration tab, i have some variables like "value", "columnName", "setFlag" which are mapped to Literal, Qualifier String, and the Literal Value is Empty for the three of those variables.

                Could that be the problem?

                Thanks again for your quick response!
                • 5. Re: DBUM 9.1.0.4.0 add role task rejected
                  user10456909
                  How does add role query in the query configuration lookup look like?
                  Please provide the parameter mappings as well.

                  I feel user id is not getting supplied to the query properly..
                  • 6. Re: DBUM 9.1.0.4.0 add role task rejected
                    971772
                    Hi! in the query configuration lookup i have this entry:

                    ORA_ADD_ROLE
                    GRANT :ora_role_name TO :ora_user_id_external~ROLE_WITH_ADMIN_OPTION

                    Which parameter mappings do you need to be provided?

                    Thanks!
                    • 7. Re: DBUM 9.1.0.4.0 add role task rejected
                      971772
                      Any advance on this issue?

                      Thanks!