Skip to Content

How do I catch a column delimiter was seen after column number error

Running a job and get the following error

4268 15032 FIL-080104 1/10/2018 9:43:08 AM |Data flow DF_PSA_Feed_Wrkr_Inbnd|Transform PSA_Worker_Inbound_DL1__AL_ReadFileMT_Process

4268 15032 FIL-080104 1/10/2018 9:43:08 AM A column delimiter was seen after column number <57> for row number <1> in file

4268 15032 FIL-080104 1/10/2018 9:43:08 AM <E:/Tx_Data/Feeds/PSA/Inbound/WorkerDownloadFile.csv>. The total number of columns defined is <57>, so a row delimiter should

4268 15032 FIL-080104 1/10/2018 9:43:08 AM be seen after column number <57>. Check the file for bad data, or redefine the input schema for the file by editing the file

4268 15032 FIL-080104 1/10/2018 9:43:08 AM format in the UI.

4268 15032 FIL-080104 1/10/2018 9:43:08 AM |Data flow DF_PSA_Feed_Wrkr_Inbnd|Transform PSA_Worker_Inbound_DL1__AL_ReadFileMT_Process

4268 15032 FIL-080104 1/10/2018 9:43:08 AM A column delimiter was seen after column number <57> for row number <2> in file

4268 15032 FIL-080104 1/10/2018 9:43:08 AM <E:/Tx_Data/Feeds/PSA/Inbound/WorkerDownloadFile.csv>. The total number of columns defined is <57>, so a row delimiter should

4268 15032 FIL-080104 1/10/2018 9:43:08 AM be seen after column number <57>. Check the file for bad data, or redefine the input schema for the file by editing the file

4268 15032 FIL-080104 1/10/2018 9:43:08 AM format in the UI.

I know the cause. How do I catch it. Itry on the execptions that CATCh has but none catch it.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Jan 11 at 12:43 PM

    Hi ,

    try error handling in source file (write errors to a file) and specify file name. all the error records will be loaded to that file.

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 11 at 02:27 PM

    Timothy Shields

    As Ravi said, enable the error handling features in the Flat File format editor.

    Refer Section Error handling for flat-file sources in Data Services Designer Guide

    Regards

    Arun Sasi

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 12 at 02:05 PM

    Able to catch the errors. Now can I check the contents during processing of job so I can send out failure email?

    Add comment
    10|10000 characters needed characters exceeded