Link keeps black

jusami25 · Post by **jusami25** » Thu Apr 30, 2009 7:30 am

Hi all,

Normally when you run a job (on the designer) the links changes their colours between black, blue, green, red. We have one job that during and after the execution the links are allways black. The job finish successfully and the records gets the target stage.

Do you know how to see the links colours and the statistics?

We enable the Show performance statictics job option without success.

Thanks in advance.

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Thu Apr 30, 2009 8:21 am

Multi-instance ?

ray.wurlod · Post by **ray.wurlod** » Thu Apr 30, 2009 4:38 pm

Have you disabled display of "performance statistics"?

jusami25 · Post by **jusami25** » Fri May 01, 2009 3:06 am

Yes it's still active, but the colors and the number of rows are not displayed. However te job seems to work fine.

We just have to know what is causing this behaviour, because from time to time it's happening.

Thanks a lot for your help

priyadarshikunal · Post by **priyadarshikunal** » Fri May 01, 2009 3:19 am

can you see the stats in job monitor?
if no
Do you have any warning in the log?
any message handler active?

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Fri May 01, 2009 6:20 am

Maybe your job monitor is not running.

eostic · Post by **eostic** » Fri May 01, 2009 6:29 am

What exactly are the stage types at either end, and/or other characteristics....is there a container involved, etc.. I've seen this sort of thing lots of times. Does the Job work as designed?

The performance stats are just a "convenience aid". Personally, they annoy me, especially since in v8 they seem to always get "turned back on again" after I uncheck them. ; ) Once they are on, you can't easily re-name the links, etc. until you turn them back off. And if it's red, you have to go back to the Director anyway (old habits die hard).

My humble opinions aside, what is the structure of the job...that may offer us some hints.

Ernie

jusami25 · Post by **jusami25** » Tue May 05, 2009 1:48 am

Hi,

the stage types are:

Dataset ------> Remove Duplicates ---------> Oracle (Green link)

Dataset ------------------------------------------> Oracle (Black link)

No containers involved. The job works as expected. But no statistics are shown por the Dataset to Oracle link.

jusami25 · Post by **jusami25** » Tue May 05, 2009 2:53 am

Hi,

I forgot to clarify that it's not a multiple instance job.

regards.

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Tue May 05, 2009 2:56 am

What if you put a copy and force it ?

eostic · Post by **eostic** » Tue May 05, 2009 6:45 am

Are those separate paths in the same job? That may explain it. As noted above, I've seen Containers and other "not-so-standard" Job constructs result in behavior where some links fail to show any performance results or color status. This may be one of those situations.

If in fact they are separate paths, what happens if you put it in its own job...and also, what happens if there is something, like a Copy as noted before, or a Transformer, between the two I/O stages.

Ernie

priyadarshikunal · Post by **priyadarshikunal** » Tue May 05, 2009 7:06 am

What about my questions?

add one more question to that.

What is the value set for APT_NO_JOB_MON?

jusami25 · Post by **jusami25** » Wed May 06, 2009 10:12 am

APT_NO_JOB_MON = False

jusami25 · Post by **jusami25** » Thu May 07, 2009 3:48 am

Hi,

Following eostic workaround to add a copy stage between the dataset and the oracle stages now the link becomes green.

I think remember that when datastage compiles a copy stage that is just mapping all the fields on the compiled code is like this copy stage doesn't exist. In case I'm right. Why the link is not working without the copy stage?

Thanks!!!

ray.wurlod · Post by **ray.wurlod** » Thu May 07, 2009 4:47 pm

Dump the score, inspect it, and answer your own question. Please post the results of your investigations here.