josh.guffey wrote:Inside of DataStage Director, go to Tools and select Options. Once the Options dialog box pops up select the Limits tab and change warnings to No limit or select Abort job after: value to something > 50.
Hope this helps.
Thanks for the info, but this seems to be different. This is not addressing the warnings in the Director log.
If you go to the Scratch directory (for our installation /opt/IBM/InformationServer/Server/Scratch directory), it contains log files for jobs using the SQL Loader technology. It has the following entry:
SQL*Loader: Release 10.2.0.3.0 - Production on Wed Jun 18 20:34:59 2008
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Control File: ora.8214.348555.0.ctl
Data File: ora.8214.348555.fifo.0
File processing option string: "FIX 2807"
Bad File: ora.8214.348555.0.log.bad
Discard File: none specified
(Allow all discards)
Number to load: ALL
Number to skip: 0
Errors allowed: 50
Bind array: 64 rows, maximum of 256000 bytes
Continuation: none specified
Path used: Conventional
Further down in the file, it has a message as follows:
MAXIMUM ERROR COUNT EXCEEDED - Above statistics reflect partial run.
Table DW_FNNCL_TRNSCTN:
1 Row successfully loaded.
51 Rows not loaded due to data errors.
0 Rows not loaded because all WHEN clauses were failed.
0 Rows not loaded because all fields were null.
However, I don't know where this gets set.
Thanks!