How can I log Errors / Exceptions to a file?

ray.wurlod · Post by **ray.wurlod** » Thu Jan 29, 2009 2:55 pm

The exception handler has two or three activity variables that report, for example, an error code and the name of the activity that failed. I'm travelling at the moment so can't check, but you can find them in the manual.

wjfitzgerald · Post by **wjfitzgerald** » Fri Jan 30, 2009 2:02 am

Ray,

thanks for coming back to me. Unfortunatley i am not a premium poster and so where ever you were going to tell me to look is hidden to me.

Thanks for the repsonse though.

John FItz

mk_ds09 · Post by **mk_ds09** » Fri Jan 30, 2009 2:38 am

John,

Whenever there is failure of the job, all the datastage logs you can write to the file..

Dsjob function can give you all the log depending upon your requirements.
Here you can write all the info message/warnings/errors.

So create one file which will be amended whenever a parallel job executes. So whenever there is failure it can be checked by viewing this file. It will contain all the messages that could help you to determine the exact cause of failure..

Hope this helps

-------------

MK

wjfitzgerald · Post by **wjfitzgerald** » Fri Jan 30, 2009 2:43 am

That's great thanks.

this self education thing is highly frustrating!

thanks again,

John Fitz

ray.wurlod · Post by **ray.wurlod** » Fri Jan 30, 2009 2:53 am

I think only the word "manual" was missing. Have removed premium status from message.

wjfitzgerald · Post by **wjfitzgerald** » Fri Jan 30, 2009 3:00 am

thanks again ray.

I'll mark this post as resolved.

John Fitz

wjfitzgerald · Post by **wjfitzgerald** » Fri Jan 30, 2009 3:13 am

Sorry about this, a quick follow up if i might:

MK, is it possible to make the call of DSJob function in the after job routine conditional on the job itself failing? i presume it is relatively straight forward, and that you would write a basic routine to check the return status, and make the call of DSJob conditional? if so, how do you refernce the status?

thanks again,

John FItz

throbinson · Post by **throbinson** » Fri Jan 30, 2009 5:25 am

Example;

Code: Select all

vJOB_STATUS	= DSTranslateCode(DSGetJobInfo(DSJ.ME, DSJ.JOBINTERIMSTATUS))
			* The interim status of the just completed job itself
IF vJOB_STATUS = "Finished OK"

wjfitzgerald · Post by **wjfitzgerald** » Fri Jan 30, 2009 5:28 am

fantastic, that's great thanks for the help.