Job Aborts even if warnings are allowed

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
jinm
Premium Member
Premium Member
Posts: 47
Joined: Tue Feb 24, 2004 1:59 am

Job Aborts even if warnings are allowed

Post 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
jinm
Premium Member
Premium Member
Posts: 47
Joined: Tue Feb 24, 2004 1:59 am

Re: Job Aborts even if warnings are allowed

Post by jinm »

An update

IBM confirmed a bug and supplied a fix.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post 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?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
jinm
Premium Member
Premium Member
Posts: 47
Joined: Tue Feb 24, 2004 1:59 am

Post 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
Post Reply