Page 1 of 1

Job Aborts even if warnings are allowed

Posted: Fri Nov 28, 2008 4:51 am
by jinm
Hi Experts.
We are running jobs under a Basic Routine (RunJob) that handles - amongst other things - the analyze of job status after a run.

Routine goes like this:
*--
case Status = DSJS.RUNWARN
* check whether some fatal errors are generated even the job is not aborted
* get the list of fatal errors...
LogIdList = Ereplace(DSGetLogEventIds(hJob1, 0, 'F') , \"\\\" , @FM, 1)
if LogIdList # -99 then
* DSGetLogEventIds returns -99 if no messages found
* .. and get the first error message - it's the real error
LogId = LogIdList<1>
AnalyzeError = @True
end else
Call DSLogWarn(\"Job had warning(s)...\", ROUTINE.NAME)
Exit
end

*--
Apparently when no fatal errors are found the routine returns the very first logentry regardless of type.
It seems status ends as DSJS.RUNWARN ( I hope since entry from job itself says:
Job ItemPzn.ALL has finished, status = 2 (Finished with warnings)

Nevertheless the errormessage created is the first entry in logfile

Job has error - last error text:
Starting Job ItemPzn.ALL.\n
$DB2CODEPAGE = 1208\n
SERVER_OW = OW**AS00\n
LIB_OW = DATA\n
USER_ID_OW = dwhprod\n
PWD_OW = ********\n
SERVER_STAGING = *******\n
LIB_STAGING = STAGING_P1\n
USER_ID_STAGING = *******\n
PWD_STAGING = ********\nP_
JOB_ID = 2003-06-24 10:00:00\n
DSJobController = DSRunJob.ItemPzn_ALL
*--

Has it to do with LogIdList # -99 ??

Any input is appreciated

Re: Job Aborts even if warnings are allowed

Posted: Thu Mar 19, 2009 12:27 am
by jinm
An update

IBM confirmed a bug and supplied a fix.

Posted: Thu Mar 19, 2009 2:12 am
by ray.wurlod
What's the bug, and what's the fix?

Can you please replace the Quote tags in your earlier post with Code tags?

Posted: Mon Mar 30, 2009 11:40 pm
by jinm
ray.wurlod wrote:What's the bug, and what's the fix?

Can you please replace the Quote tags in your earlier post with Code tags?
Hi Roy

qute/code... bare with me..

From the supplied readme file:

PATCH FOR APAR : JR31357
PATCH NAME : patch_JR31357
COMPONENT : DataStage Server
TIERS : Engine
OPERATING SYSTEM : Windows
SUITE VERSION* : 8.1.0.0
UNINSTALL** : Not Supported

PROBLEM: Patch for CRM 25337,010,678

DETAILS:

In DSGetLogEventIds() when no log records match the type filter the 8.1
version returns an empty string whereas the 8.0 version returned code -99

AND

This patch modifies the following files, shown from the root of the IBM
Information Server installation:

Server\Template\DSG_BP.O\DSR_LOG.B
Server\Projects\{project}\DSG_BP.O\DSR_LOG.B

where '{project}' represents the enumeration of customer created projects.


Hope i can be of use