SAS DI job running with warning

[MG18]

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 ?

[SuryaKiran]

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.