Loading from Fixed width flat file to oracle - DI project getting org.axiondb.AxionException

(Doc ID 1025968.1)

Last updated on FEBRUARY 05, 2009

Applies to:

Oracle Java CAPS Enterprise Service Bus - Version: R6 and later
Information in this document applies to any platform.

Symptoms

Data Integrator project developed in Windows and being deployed to the Solaris box. This is a simple flat file (axion db) to oracle data load project. It works fine in windows local machine. When the same file is loaded to Solaris box and project deployed to java server in Solaris, it gives the following error:

[#|2008-12-11T14:29:53.445-0600|SEVERE|sun-appserver9.1|com.sun.etl.engine.impl.InitTask|_ThreadID=312;_ThreadName=INIT_0;_RequestID=8269e41e-44de-4bc9-a6f3-60ec5e78c88e;|java.sql.SQLException: Failed to create table using supplied properties. (org.axiondb.AxionException: org.axiondb.AxionException: Fault tolerance threshold (0) exceeded for table S1_PROVMSTR_RATES_ICF. Unable to parse data file: (java.io.IOException: Corrupted data, record delimeter not found at specified record length.) (org.axiondb.AxionException: Unable to parse data file: (java.io.IOException: Corrupted data, record delimeter not found at specified record length.))) - java.sql.SQLException: Failed to create table using supplied properties. (org.axiondb.AxionException: org.axiondb.AxionException: Fault tolerance threshold (0) exceeded for table S1_PROVMSTR_RATES_ICF. Unable to parse data file: (java.io.IOException: Corrupted data, record delimeter not found at specified record length.) (org.axiondb.AxionException: Unable to parse data file: (java.io.IOException: Corrupted data, record delimeter not found at specified record length.)))
at org.axiondb.util.ExceptionConverter.convert(ExceptionConverter.java:68)
at org.axiondb.jdbc.AxionStatement.executeUpdate(AxionStatement.java:343)
at org.axiondb.jdbc.AxionStatement.executeUpdate(AxionStatement.java:143)
at com.sun.etl.engine.impl.InitTask.doExecute(InitTask.java:241)
at com.sun.etl.engine.impl.InitTask.execute(InitTask.java:345)
at com.sun.etl.engine.impl.InitTask.process(InitTask.java:128)
at com.sun.etl.engine.impl.ETLTaskThread.run(ETLTaskThread.java:161)
at java.lang.Thread.run(Thread.java:595)
|#]

I verified that the file in solaris is the same and no special charecters are present. The input is fixed width flat file with record delimiter (CR/LF) at the creation of it.

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