Hi,
At runtime, though the job works fine, the UtilityMessageToLog gives an error at the last step. The error is as follows:
Clnt_JbL0LAClientRelation..JobControl (@OK_Log): Routine DSX.UTILITYMESSAGETOLOG did not finish OK, return code = '1'
Plz Help.
Mahesh
UtilityMessageToLog error
Moderators: chulett, rschirm, roy
-
ray.wurlod
- Participant
- Posts: 54595
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Please explain how you called this routine, and from where in your job or routine design.
You can examine this routine's code (it's provided as part of the SDK; it's name is UtilityMessageToLog - the all-upper case version is its "catalog" name) and you will note therein that it sets a return value depending on whether the input arguments make sense. If they do not, then the message you have received - or one like it - will be generated.
You can examine this routine's code (it's provided as part of the SDK; it's name is UtilityMessageToLog - the all-upper case version is its "catalog" name) and you will note therein that it sets a return value depending on whether the input arguments make sense. If they do not, then the message you have received - or one like it - will be generated.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
maheshsatam
- Participant
- Posts: 5
- Joined: Wed Nov 23, 2005 1:08 am
I have developed a job in which we have used a sequencer object. At the end of the job, we use this routine just to display the message that the job is successful with a message to it as a parameter as "*** data is loaded successfully". So when we run this job, the data is loaded and it control goes to utility to diaplay the message. At this point the warning message is flashed and the job gets aborted.
In the routine, we are just passing a single arguement (i.e. parameter) which is the message that we want to display.
Can you please help me in this regards to resolve this issue.
Also I do not know how do I access the catalog info. Plz guide.
Mahesh
In the routine, we are just passing a single arguement (i.e. parameter) which is the message that we want to display.
Can you please help me in this regards to resolve this issue.
Also I do not know how do I access the catalog info. Plz guide.
Mahesh
Mahesh,
I gather you were not able to follow Ray's suggestion and look at the code, which is visible in the Manager in Routines -> sdk -> Utility -> UtilityMessageToLog. That is unfortunate, because had you done so you would have seen that the last line in the routine is "Ans = 1". It will always return the same value. You need to code your sequence's Routine Activity to cater for this result.
I gather you were not able to follow Ray's suggestion and look at the code, which is visible in the Manager in Routines -> sdk -> Utility -> UtilityMessageToLog. That is unfortunate, because had you done so you would have seen that the last line in the routine is "Ans = 1". It will always return the same value. You need to code your sequence's Routine Activity to cater for this result.
</a>