Im an running a test of the OIM Bulk Load Utility (11 R2). I am running the Load Account Data. The data/Application I am testing with is LDAPUSER. I have 8 csv file, only 3 have data. Im not sure why I am getting this error, since it dies, the summary log has zero information. The temp files created in the log folder have no errors in them. Any help would be appreciated.
Here is my log:
Processing started ....
Exception in thread "main" java.sql.SQLException: ORA-00957: duplicate column name
ORA-06512: at "EDGIAG_OIM.OIM_BLKLD_PKG_ACCOUNT_LOAD", line 1406
ORA-06512: at line 1
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:447)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:951)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:513)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:227)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:205)
at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:1036)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1336)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3608)
at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3709)
at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:4735)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1090)
at bulkload.AccountLoad.processData(AccountLoad.java:805)
at bulkload.AccountLoad.inputCSV(AccountLoad.java:619)
at bulkload.AccountLoad.showSubMenu(AccountLoad.java:141)
at bulkload.AccountLoad.main(AccountLoad.java:1262)
SQL*Loader: Release 11.2.0.4.0 - Production on Tue Jun 21 14:02:32 2016
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
Load completed - logical record count 1.
SQL*Loader: Release 11.2.0.4.0 - Production on Tue Jun 21 14:02:33 2016
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
Load completed - logical record count 0.
SQL*Loader: Release 11.2.0.4.0 - Production on Tue Jun 21 14:02:33 2016
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
Load completed - logical record count 0.
SQL*Loader: Release 11.2.0.4.0 - Production on Tue Jun 21 14:02:33 2016
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
Load completed - logical record count 0.
SQL*Loader: Release 11.2.0.4.0 - Production on Tue Jun 21 14:02:33 2016
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
Load completed - logical record count 3.
SQL*Loader: Release 11.2.0.4.0 - Production on Tue Jun 21 14:02:33 2016
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
Load completed - logical record count 0.
SQL*Loader: Release 11.2.0.4.0 - Production on Tue Jun 21 14:02:33 2016
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
Load completed - logical record count 3.
SQL*Loader: Release 11.2.0.4.0 - Production on Tue Jun 21 14:02:33 2016
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.