BookmarkSubscribeRSS Feed
MG18
Lapis Lazuli | Level 10

Hi All,

 

Happy New year to all .

 

we have developed one SAS DI job which is having user written code in the job. This user written code will load the data from Dow jones file to the Oracle data base and job is running fine and loading the data too. But it is having below mentioned WARNING in the log tab in SAS DI.

 

WARNING :-

 


************** End:    SQL*Loader Log File **************

WARNING: All or some rows were rejected/discarded!(or possibly there were other errors like Index maintenance errors)
**********************************************************************
 Please look in SQL*Loader log for the load results.
 SQL*Loader Log location(only if BL_DELETE_FILES=NO is set): -- BL_FSC_ENTITY_WATCH_LIST_DIM_0.log --
 Note:In Client/Server environment,the Log File is located on the Server. The log is also echoed in the Server SAS log file.
**********************************************************************
NOTE: PROCEDURE APPEND used (Total process time):

 

so I have few questions about the warning as below :-

  • Where is the BL_FSC_ENTITY_WATCH_LIST_DIM_0.log log file located  ? is it in SAS APPLICATION server or oracle server or in my desktop ?
  • What is the  BL_DELETE_FILES=NO is set ? Do I need to set this options before running the SAS DI JOB ?

 

1 REPLY 1
SuryaKiran
Meteorite | Level 14

Hello,

 

1) This is related to Oracle, SQL*Loader created the log file and not by SAS. You may need to contact your Oracle DBA for find the location.

2) When the option is set to NO (the default value), all SQLLDR warnings are returned as warnings. However, when the option is set to YES, all SQLLDR warnings are returned as errors (SYSERR will reflect this). I think this is set by DBA's.

Thanks,
Suryakiran

SAS Innovate 2025: Register Now

Registration is now open for SAS Innovate 2025 , our biggest and most exciting global event of the year! Join us in Orlando, FL, May 6-9.
Sign up by Dec. 31 to get the 2024 rate of just $495.
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
  • 1131 views
  • 1 like
  • 2 in conversation