BookmarkSubscribeRSS Feed
papakr
Calcite | Level 5

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: |

2022-01-07T15:07:36,489 INFO JobMon: DATA | 1 | 100%, Complete | Populate CLT00003
2022-01-07T15:07:36,489 INFO JobMon: DATA | 2 | 100%, Complete | Final CLT00003
2022-01-07T15:07:36,489 INFO JobMon: DATA | 3 | 100%, Complete | Join 0101 LI
2022-01-07T15:07:36,489 INFO JobMon: DATA | 4 | 100%, Complete | Join 2101 LI
2022-01-07T15:07:36,489 INFO JobMon: DATA | 5 | 100%, Complete | Join 5001 LI

...    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.

1 REPLY 1
audrey
SAS Employee

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

 

www.sas.comsupport.sas.com
SAS®... THE POWER TO KNOW®

sas-innovate-2024.png

Available on demand!

Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.

 

Register now!

How to connect to databases in SAS Viya

Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 1 reply
  • 382 views
  • 0 likes
  • 2 in conversation