Abort after 50 Warnings with no limit

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
Pierre
Participant
Posts: 66
Joined: Thu May 24, 2007 7:16 am
Location: Paris

Abort after 50 Warnings with no limit

Post 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.
priyadarshikunal
Premium Member
Premium Member
Posts: 1735
Joined: Thu Mar 01, 2007 5:44 am
Location: Troy, MI

Post by priyadarshikunal »

I think 50 is the default value for warning limit. does the control job sets it to unlimited (0) ?
Priyadarshi Kunal

Genius may have its limitations, but stupidity is not thus handicapped. :wink:
Pierre
Participant
Posts: 66
Joined: Thu May 24, 2007 7:16 am
Location: Paris

Post 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).
J.Calvo
Participant
Posts: 53
Joined: Fri Oct 09, 2009 4:21 am

Re: Abort after 50 Warnings with no limit

Post 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 ?
Best Regards,
Jorge Calvo
Pierre
Participant
Posts: 66
Joined: Thu May 24, 2007 7:16 am
Location: Paris

Post by Pierre »

Yes, really !
Pierre
Participant
Posts: 66
Joined: Thu May 24, 2007 7:16 am
Location: Paris

Post by Pierre »

Yes, really !
priyadarshikunal
Premium Member
Premium Member
Posts: 1735
Joined: Thu Mar 01, 2007 5:44 am
Location: Troy, MI

Post 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.
Priyadarshi Kunal

Genius may have its limitations, but stupidity is not thus handicapped. :wink:
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post 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.
-craig

"You can never have too many knives" -- Logan Nine Fingers
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Were these jobs started from dsjob command with no -warn option?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Pierre
Participant
Posts: 66
Joined: Thu May 24, 2007 7:16 am
Location: Paris

Resolved

Post 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.
caterin_huang
Participant
Posts: 48
Joined: Tue Jan 26, 2010 4:05 am
Location: Indonesia

Re: Resolved

Post 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
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post 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.
-craig

"You can never have too many knives" -- Logan Nine Fingers
caterin_huang
Participant
Posts: 48
Joined: Tue Jan 26, 2010 4:05 am
Location: Indonesia

Post 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
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post 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.
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply