ORA-00904: While Importing XML File Using OIM's Deployment Manager in Production System

(Doc ID 870291.1)

Last updated on SEPTEMBER 26, 2016

Applies to:

Identity Manager - Version 9.1.0.2 to 9.1.0.2
Information in this document applies to any platform.
**Checked for Relevance on 14-Mar-2014**

Symptoms

Suppose a user have developed and tested an integration in Oracle Identity Manager and exported the integration for migration to the Production System.

The import process terminates with an error and the log shows the following errors:

 

ERROR,03 Aug 2009 13:00:31,339,[XELLERATE.DATABASE],ALTER TABLE USR MODIFY 
java.sql.SQLSyntaxErrorException: ORA-00904: : invalid identifier 

.....

ERROR,03 Aug 2009 13:00:31,409,[XELLERATE.DDM.IMPORT],Error Modifying a 
Column. 
ERROR,03 Aug 2009 13:00:31,409,[XELLERATE.DDM.IMPORT],Exception during import 
com.thortech.xl.ddm.exception.DDMException: Unable to save dataobject for SDC 

The above errors occurred when the deployment manager was attempting to import a file that modifies the USR table.  Your error will specify a different table name depending on the integration and objects that you are importing.

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