Data Staging Failed: DATA COLLECTION FAILED. When Importing From OIM (Doc ID 1537141.1)

Last updated on NOVEMBER 09, 2016

Applies to:

Oracle Identity Analytics - Version 11.1.1.5.1 and later
Information in this document applies to any platform.

Symptoms

Choose Import Users, Accounts, User Role Memberships and Entitlements and "Load all resources defined in the system at the time the job is run" and run the import from OIM.

In OIA, we see these errors:

10:55:02,921 DEBUG [DBIAMSolution] We are coming back from a short sleep to see if data staging is ready
10:55:02,921 DEBUG [DBIAMSolution] Monitoring Staging tables Status: UUID:urn:uuid:4E6A4CB34AAC8851FF136190484114389, ImportRunStepId:117
10:55:02,938 DEBUG [DBIAMSolution] Checking data collection status with id: urn:uuid:4E6A4CB34AAC8851FF136190484114389
10:55:02,939 INFO [OIMDataProviderImpl] Start : Get Status of Data Collection ...
10:55:02,993 DEBUG [IamDataSyncMonitorImpl] OIMStatus FAILED
10:55:02,993 DEBUG [DBIAMSolution] Data Staging Failed: DATA COLLECTION FAILED. Aborting. Let's Finalize data collection.
10:55:02,993 INFO [OIMDataProviderImpl] Start Finalize Data Collection ...
10:55:04,647 INFO [OIMDataProviderImpl] End Finalize Data Collection ...
10:55:04,647 ERROR [DBIAMSolution] ERROR: Data Staging Failed: DATA COLLECTION FAILED. Aborting.

In OIM we see these errors:

DEBUG,11 Mar 2013 11:57:23,356,[XELLERATE.SERVER:debug],Data collection for Account entity ACC
DEBUG,11 Mar 2013 11:57:23,357,[XELLERATE.SERVER:debug],Class/Method: DataCollectionUtil/collectAccountData entered.
DEBUG,11 Mar 2013 11:57:23,359,[XELLERATE.SERVER:debug],Before invoking SP with signature: { call OIM_PKG_OIA_INTEGRATION.OIM_SP_OIA_POPULATE_ACCNT_DATA( ?, ?,?,?,? ) }
ERROR,11 Mar 2013 11:57:24,734,[XELLERATE.SCHEDULER.TASK:error],SQLException occured while performing data collection
java.sql.SQLException: ORA-20004: IT Resource Column is not defined
ORA-06512: at "OIDM.OIM_PKG_OIA_INTEGRATION", line 1097
ORA-06512: at line 1

at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)
at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:206)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1035)
at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:191)
at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:950)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1223)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3386)
at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3487)
at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:3858)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1374)
at com.thortech.xl.dataobj.util.DataCollectionUtil.collectAccountData(Unknown Source)
at com.thortech.xl.dataobj.util.DataCollectionUtil.collectData(Unknown Source)
at com.thortech.xl.schedule.tasks.DataCollectionTask.execute(Unknown Source)
at com.thortech.xl.scheduler.tasks.SchedulerBaseTask.run(Unknown Source)
at com.thortech.xl.scheduler.core.quartz.QuartzWrapper$TaskExecutionAction.run(Unknown Source)
at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:121)
at weblogic.security.Security.runAs(Security.java:41)
at Thor.API.Security.LoginHandler.weblogicLoginSession.runAs(Unknown Source)
at com.thortech.xl.scheduler.core.quartz.QuartzWrapper.execute(Unknown Source)
at org.quartz.core.JobRunShell.run(JobRunShell.java:178)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:477)
DEBUG,11 Mar 2013 11:57:24,755,[XELLERATE.DATABASE:debug],update OIA_DC_SESSION_DETAILS set session_status=?, note=?, end_time=sysdate where session_name=?
DEBUG,11 Mar 2013 11:57:24,758,[XELLERATE.PREPAREDSTATEMENT:debug],Class/Method: tcDataBase/writeStatement - Data: psSql - Value: update OIA_DC_SESSION_DETAILS set session_status=?, note=?, end_time=sysdate where session_name=?
DEBUG,11 Mar 2013 11:57:24,759,[XELLERATE.PREPAREDSTATEMENT:debug],Class/Method: tcDataBase/writeStatement: Param (string/clob): 1 is set to FAILED
DEBUG,11 Mar 2013 11:57:24,760,[XELLERATE.PREPAREDSTATEMENT:debug],Class/Method: tcDataBase/writeStatement: Param (string/clob): 2 is set to ORA-20004: IT Resource Column is not defined
ORA-06512: at "OIDM.OIM_PKG_OIA_INTEGRATION", line 1097
ORA-06512: at line 1

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms