Skip to Content
0

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

Jan 10 at 06:31 PM

83

avatar image

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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Ravi kiran Pagidi Jan 11 at 12:43 PM
0

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.

Share
10 |10000 characters needed characters left characters exceeded
Arun Sasi Jan 11 at 02:27 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded
Timothy Shields Jan 12 at 02:05 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded