Page 1 of 1

Exporting a job with warnings

Posted: Wed Apr 04, 2012 3:38 am
by TonyInFrance
Good morning all,

I am exporting a DSEE 8.5 job which on execution is returning a few warnings on my development environment. I cannot evade these warnings and thus I am demoting these warnings to informational status in my director module.

However on exporting this job to another server these warnings reappear. is there anyway I can export these jobs taking into account warnings that shouldn't show up in yellow?

Thanks

S. BASU

Posted: Wed Apr 04, 2012 5:22 am
by kandyshandy
NO.. unless you define the message handler in the target environment...

You can't achieve this while exporting the jobs ;)

Posted: Wed Apr 04, 2012 5:30 am
by TonyInFrance
By 'define the message handler in the target environment' you mean I have to run the job in the target environment and physically convert the warnings to informational status just as I did in my dev.?

Or is there any other way to 'define the message handler in the target environment'?

Re: Exporting a job with warnings

Posted: Wed Apr 04, 2012 3:14 pm
by ray.wurlod
BASU wrote: I cannot evade these warnings
You're not trying hard enough.

Posted: Wed Apr 04, 2012 9:38 pm
by kandyshandy
BASU wrote:Or is there any other way to 'define the message handler in the target environment'?
One well known way is to do copy & paste.. Open both source & trarget message handler windows and do a copy/paste ;)

One another way is also there....

Posted: Wed Apr 04, 2012 9:40 pm
by kandyshandy
You can also open a new thread with the warnings you are getting...

Posted: Thu Apr 05, 2012 2:59 am
by TonyInFrance
I know what you mean Ray and I'll be honest with you. This is not exactly my development. I have simply been given this as an exercise and I need to come up with a solution. Ths eradicating the warnings, thus nipping the issue in the bud is not a solution.

As for the 2 solutions by kandyshandy, I confess that I don't understand very well what to do.

I have added the warnings to my message handler i.e. local runtime handler' for my job as well as added a new handler. How do I export these messages also as part of my DSX so that the target server knows that these warnings shouldn't appear in yellow?

Posted: Thu Apr 05, 2012 4:45 am
by kandyshandy
I posted a detailed reply and i could not see it here. God.. should i type it again? Let me make it simple..

Source Env -> DataStage Designer/Director -> Message Handler Manager/Management -> copy ->
{paste in Message Handler Manager/Management of target environment} -> save it ;) -> close it.

Posted: Thu Apr 05, 2012 5:25 am
by TonyInFrance
I can go upto Source Env -> DataStage Designer/Director -> Message Handler Manager/Management ->
I don't get an option to copy anything.

To be specific its Source Env -> DataStage Designer/Director -> TOOLS -> Message Handler Management

This is specific for each job.

Once we open this there is an option to SAVE Message Handler / Save Message Handler As

So where / how can I implement the copy paste method?

Regards

Posted: Sun Apr 08, 2012 8:59 pm
by kandyshandy
Basu, did you ever create a message handler in source environment? If yes, when you open message handler manager from designer, you will see a drop down list which lists out all available message handlers. If you don't any see in the drop down list, that means you don't have a message handler for that environment.

Once you select one from the drop down list, you can see corresponding message ids, action etc.

Posted: Tue Apr 10, 2012 1:17 am
by TonyInFrance
Alright, I am adding the message I want to suppress from my log / demote to informational status to my message handler under a new name. Now when I run this job the earlier warning does not come up in yellow. However once I export this job, how do I ensure that in the target environment the same warning is also handled in the same way as in the source environment?

Posted: Tue Apr 10, 2012 2:21 am
by kandyshandy
Oops.. That's what i explained in my previous replies. :shock:

Posted: Tue Apr 10, 2012 2:35 am
by TonyInFrance
That's exactly where I'm stuck. There is no option to copy once I locate the message handler that I've saved. Thus I don't see how I can copy paste to the target environment.

Posted: Tue Apr 10, 2012 3:33 am
by kandyshandy
I don't know what else i can do... Wait for someone who can paste a screen shot here.. Will that happen ever?

Meanwhile, Why don't you read DS documentation to get this resolved?

Posted: Tue Apr 10, 2012 3:52 am
by priyadarshikunal
If it is a project level message handler then there are 2 things you need to do.

you need to copy .msh file from <installation directory>/MessageHandlers

so now you have the message handler in the target system now you need to configure the project to use it, so in administrator select that message handler. (you can copy DSParams as well but then you may need to change quite a few parameters there)