Data Conversion Error

We are using 3.4.31, and we are using an Oracle 10g database.

We recently changed one of our fields in an Oracle table from a "DATE" type to a "TIMESTAMP" type. We currently use the DatabaseImport command to import tab-delimited information from a text file into the table that we changed the column on. After the column type was changed and we ran the JAL command, we received this error:
"An error occurred while executing automation script: Line 11: Error #-9 importing file... Data conversion error in row 2."

Here are two sample lines from the input file:
7/17/2008 5:54:01.036000 0 7321 0 Move_24x7_LogFile Job finished.
7/17/2008 5:55:00.929000 0 22510 0 24x7_Logfile_import Job started.

Do you know what the problem might be?

This sounds like the data you are loading is not compatible with the timestamp datatype. In other words the target data type is not the same as the source data-type which is leading to the mentioned "Data conversion error in row 2"

The name of the job in your log tells me that you are loading 24x7 job log. If you cannot keep DATE type column in the target table, I suggest to load the data file in 2 steps, create a work table with DATA column, load into that table and after DatabaseImport execute DatabaseExecute "INSERT INTO main_table SELECT * FROM work_table", rows. In this case Oracle will take care of data type conversion from DATE to TIMESTAMP.

Hope this helps.