SQLException: Invalid column type: 1111 when Importing Accounts (Doc ID 1419534.1)

Last updated on AUGUST 08, 2017

Applies to:

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

Symptoms

SQLException: Invalid column type: 1111 when importing accounts in Oracle Identity Analytics.


ERROR [CSVAccountFileReader] ---> Error occured file reading file:
java.lang.RuntimeException: Unable to import accounts
at com.vaau.rbacx.iam.file.csv.CSVAccountFileReader.importAccounts(CSVAccountFileReader.java:354)
at com.vaau.rbacx.iam.file.csv.CSVAccountFileReader.readCSVFileInternal(CSVAccountFileReader.java:209)
at com.vaau.rbacx.iam.file.csv.AbstractCSVFileReader.readInternal(AbstractCSVFileReader.java:84)
at com.vaau.rbacx.iam.file.support.AbstractFileReader.read(AbstractFileReader.java:160)
at com.vaau.rbacx.iam.file.support.AbstractFileReader.run(AbstractFileReader.java:82)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:619)
Caused by: org.springframework.jdbc.UncategorizedSQLException: SqlMapClient operation; uncategorized SQLException for SQL []; SQL state [99999]; error code [17004];  
--- The error occurred in com/vaau/rbacx/dao/ibatis/maps/AccountAttributeWrapper.xml.  
--- The error occurred while applying a parameter map.  
--- Check the insertAccountAttribute-InlineParameterMap.  
--- Check the parameter mapping for the 'lastCert' property.  
--- Cause: java.sql.SQLException: Invalid column type: 1111; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException:  
--- The error occurred in com/vaau/rbacx/dao/ibatis/maps/AccountAttributeWrapper.xml.  
--- The error occurred while applying a parameter map.  
--- Check the insertAccountAttribute-InlineParameterMap.  
--- Check the parameter mapping for the 'lastCert' property.  
--- Cause: java.sql.SQLException: Invalid column type: 1111


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