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®

Ready to join fellow brilliant minds for the SAS Hackathon?

Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.

Register today!
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
  • 411 views
  • 0 likes
  • 2 in conversation