3 Replies Latest reply: Jan 8, 2013 9:06 AM by rviegas RSS

    OIM OIA User import error

    Amruta Agarwal
      Hi All,

      I am tryin to import users from OIM to OIA. But it fails with DATA STAGING FAILED error. Following is theerror logs seen from OIM side

      [2012-12-19T12:42:44.789+01:00] [server_oim_QAT01] [ERROR] [] [XELLERATE.SCHEDULER.TASK] [tid: OIMQuartzScheduler_Worker-8] [userId: oiminternal] [ecid: 9e99b5f79a81ee67:-3987dbde:13bb2f18ac9:-8000-0000000000000002,1:24189] [APP: oim#11.1.1.3.0] SQLException occured while performing data collection[[
      java.sql.SQLException: ORA-01407: cannot update ("QA_OIM"."OIA_STAGING_ROLEGRANTS"."USERNAME") to NULL
      ORA-06512: at "QA_OIM.OIM_PKG_OIA_INTEGRATION", line 315
      ORA-06512: at line 1

           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.T4CCallableStatement.doOall8(T4CCallableStatement.java:213)
           at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:1075)
           at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1466)
           at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3752)
           at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3937)
           at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:9259)
           at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1535)
           at weblogic.jdbc.wrapper.PreparedStatement.execute(PreparedStatement.java:99)
           at com.thortech.xl.dataobj.util.DataCollectionUtil.collectRoleMembershipData(DataCollectionUtil.java:480)
           at com.thortech.xl.dataobj.util.DataCollectionUtil.collectData(DataCollectionUtil.java:396)
           at com.thortech.xl.schedule.tasks.DataCollectionTask.execute(DataCollectionTask.java:130)
           at com.thortech.xl.scheduler.tasks.SchedulerBaseTask.execute(SchedulerBaseTask.java:384)
           at oracle.iam.scheduler.vo.TaskSupport.executeJob(TaskSupport.java:145)
           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 oracle.iam.scheduler.impl.quartz.QuartzJob.execute(QuartzJob.java:196)
           at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
           at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:529)

      ]]

      Can anyone suggest any resolution for this error.

      Thanks,
      Amruta Agarwal