Page 1 of 1

Abort after 50 Warnings with no limit

Posted: Wed Oct 14, 2009 1:13 am
by Pierre
Hi,

I have a problem since a couple of days :

My project is set to "no limit" on Warnings.
Since yesterday, 2 different jobs aborted with error "Aborted after 50 warnings".
Those 2 jobs are launched by a Control Job, with no DSSetJobLimit, and I don't see any other way to set an limit on a job...

Does anyone have an idea about what's happening ?

Thanks in advance.

Posted: Wed Oct 14, 2009 2:51 am
by priyadarshikunal
I think 50 is the default value for warning limit. does the control job sets it to unlimited (0) ?

Posted: Wed Oct 14, 2009 3:05 am
by Pierre
Hi, priyadarshikunal

50 is the default, but it is set to unlimited for my project.

Just to make it clear, all jobs in this project are started by Job Controls, themselves started by another scheduled Job Control (no manual interventions).

I searched in all Job Controls, there is nowhere DSSetJobLimit specified, so the limit shouls be the one of the project (0).

Re: Abort after 50 Warnings with no limit

Posted: Wed Oct 14, 2009 3:51 am
by J.Calvo
Open Director,
In the Menu Bar select Tools > Options > Limits >
The window have two parts, Warnings and Rows, In Warnings is selected really NO LIMITS ?

Posted: Wed Oct 14, 2009 4:07 am
by Pierre
Yes, really !

Posted: Wed Oct 14, 2009 4:08 am
by Pierre
Yes, really !

Posted: Wed Oct 14, 2009 4:26 am
by priyadarshikunal
Pierre wrote: 50 is the default, but it is set to unlimited for my project.
I don't think you can set it to unlimited for the project. The setting in director is only for the jobs triggered from director. And its a client setting which doesn't affect the project.
Pierre wrote: Just to make it clear, all jobs in this project are started by Job Controls, themselves started by another scheduled Job Control (no manual interventions).
check the trigger, if the dsjob was triggered with -warn 0 (if used) else check trigger script/enterprise scheduler for the setting.
Pierre wrote: I searched in all Job Controls, there is nowhere DSSetJobLimit specified, so the limit shouls be the one of the project (0).
read my first statement of this post.

Posted: Wed Oct 14, 2009 5:29 am
by chulett
There is no such thing as a Project level warning limit. You can set it as a default for your Director client but that just affects jobs you run manually. Otherwise, unless specifically overridden, the default is 50.

Posted: Wed Oct 14, 2009 6:28 am
by ray.wurlod
Were these jobs started from dsjob command with no -warn option?

Resolved

Posted: Wed Oct 14, 2009 8:26 am
by Pierre
The problem is resolved.

The jobs were started by Job Controls.
In fact, the limit was 50 warnings at job run level.

Thanks to all for help.

Pierre.

Re: Resolved

Posted: Wed Jun 02, 2010 8:54 pm
by caterin_huang
Pierre wrote:The problem is resolved.

The jobs were started by Job Controls.
In fact, the limit was 50 warnings at job run level.

Thanks to all for help.

Pierre.
Dear all,
I had the same problem as what Pierre get. But I can't find how to set the limit warning at job run level. Can anyone help me? For your Information, I'm using Datastage 8.1

Need help so much..

Thanks in advance,
Caterin

Posted: Wed Jun 02, 2010 9:04 pm
by chulett
If by "job run level" you mean "dsjob from the command line" then you need to use the -warn option as noted in this thread. Running from the Director you will have a Limits tab where that can be set.

Posted: Thu Jun 03, 2010 1:11 am
by caterin_huang
chulett wrote:If by "job run level" you mean "dsjob from the command line" then you need to use the -warn option as noted in this thread. Running from the Director you will have a Limits tab where tha ...
unfortunately it is not triggered from the command line. but triggered using sequence. is there somewhere in the sequence we should set the limit warning?

Thanks in advance,
Caterin

Posted: Thu Jun 03, 2010 5:45 am
by chulett
caterin_huang wrote:
chulett wrote:If by "job run level" you mean "dsjob from the command line" then you need to use the -warn option as noted in this thread. Running from the Director you will have a Limits tab where tha ...
unfortunately it is not triggered from the command line. but triggered using sequence. is there somewhere in the sequence we should set the limit warning?
:!: Discussed here. Anyone wanting to chime in, please do so over there. Thanks.