ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.
Client Tool Load Data Fails
Article ID: 106873
CA Identity ManagerCA Identity GovernanceCA Identity Portal
We are getting the below exception while saving our config data in the database.
CHARACTERSET UTF16 infile \\hostname\\BulkTempDirectory\EUREKI~1.TBL append into table DataTypes fields terminated by " " optionally enclosed by '"' ( DATATYPEID , DATATYPENAME CHAR(256) )
To attempt and work around this we tried to use the sample file that comes with the installer but we see the same behavior.
Identity Governance Client Tools
Disabled bulk insert and import looks correct.
To use bulk insert: Using the wrong version of Oracle Client, which was causing the error. The Client must be the exact same version as the DB. After upgrading the oracle client from R12c Release 1 to release 2 , I was able to run the SQLLDR which the GM client tool utilize to load data through the bulk loader.