DataFlux Job Log Warning: Delimited text: Missing field(s) on row 999

papakr — Fri, 25 Feb 2022 17:57:36 GMT

From the log messages, I cannot determine which delimited text file is causing the issue. The job uses a number of delimited text files. The relevant log entries:

2022-01-07T15:07:26,922 INFO Loaded version Blue Fusion version 9.6 (build 314). Path /opt/SAS/qkb/data/ci/22
2022-01-07T15:07:27,126 WARN [SAS] qkb_ci_enusa state GRACE
2022-01-07T15:07:27,240 WARN [SAS] qkb_ci_en state GRACE
2022-01-07T15:07:27,722 WARN Delimited text: Missing field(s) on row 1
2022-01-07T15:07:27,722 WARN Delimited text: Missing field(s) on row 2
2022-01-07T15:07:27,722 WARN Delimited text: Missing field(s) on row 3

...

2022-01-07T15:07:27,778 WARN Delimited text: Missing field(s) on row 998
2022-01-07T15:07:27,778 WARN Delimited text: Missing field(s) on row 999
2022-01-07T15:07:27,778 WARN Max warning count reached
2022-01-07T15:07:36,487 INFO Node DF001(0) completed successfully.
2022-01-07T15:07:36,487 INFO [ROOT]Setting Execution State: STOPPING, Error message:()
2022-01-07T15:07:36,488 INFO [ROOT]Process Flow - Job completed successfully.
2022-01-07T15:07:36,488 INFO [ROOT]Setting Execution State: SUCCESS, Error message:()
2022-01-07T15:07:36,488 INFO ...Begin JobMon Block...
2022-01-07T15:07:36,488 INFO JobMon: PROC | 0 | 2022-01-07 15:07:26,708 | 2022-01-07 15:07:36,486 | COMPLETE | DF001 | 0: |

... and the list of job nodes continues ...

The only node reference is to "DF001" before the rest of the nodes are processed. Any insight as to which delimited text file is the cause? Thank you.

Re: DataFlux Job Log Warning: Delimited text: Missing field(s) on row 999

audrey — Mon, 28 Feb 2022 11:27:23 GMT

Hello,

These are warning, not error messages, so these should not prevent the job from running fine. If you want to investigate further, can you show us, at least, a screenshot of the job?

Thanks,

Audrey

topic Re: DataFlux Job Log Warning: Delimited text: Missing field(s) on row 999 in SAS Data Management

DataFlux Job Log Warning: Delimited text: Missing field(s) on row 999

Re: DataFlux Job Log Warning: Delimited text: Missing field(s) on row 999