DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
Author Message
Joel in KC
Participant



Joined: 10 Aug 2018
Posts: 3

Points: 30

Post Posted: Fri Aug 10, 2018 12:42 pm Reply with quote    Back to top    

DataStage® Release: 11x
Job Type: Parallel
OS: Unix
Running a job and after after 4 warnings I get the following:
"No further reports will be generated from this partition until a successful import."

The job finishes but does not load any data.

How can I get the job to abort rather than to complete the load?

My warnings are set to 50.

Any help is appreciated!

Joel
chulett

Premium Poster


since January 2006

Group memberships:
Premium Members, Inner Circle, Server to Parallel Transition Group

Joined: 12 Nov 2002
Posts: 42677
Location: Denver, CO
Points: 219803

Post Posted: Sun Aug 12, 2018 7:48 am Reply with quote    Back to top    

Welcome.

How about describing your job design? That might help folks help you out. That or let us know what stage is generating that message. I'm assuming it's related to a sequential file but would like confirmation.

Another option, do an exact search here for your error message, it turned up 15 other posts for me and something in there should help you I would imagine. At least on the why of this, perhaps not on the core question. We'll see.

_________________
-craig

Research shows that 6 out of 7 dwarves aren't happy
Rate this response:  
UCDI



Group memberships:
Premium Members

Joined: 21 Mar 2016
Posts: 335

Points: 3391

Post Posted: Tue Aug 14, 2018 12:09 pm Reply with quote    Back to top    

Answering the subject and not the body...

You can drop your extract to a dataset, count the # of records in the dataset with a routine, and use that to gracefully exit or proceed depending on having data or not. This is nice for efficiency as well for complex jobs that do a whole lot of nothing like extracting lookup tables and such for nonexistent data...

There are several other ways to count as well. We use a lot of datasets so checking there is natural for us.
Rate this response:  
Joel in KC
Participant



Joined: 10 Aug 2018
Posts: 3

Points: 30

Post Posted: Tue Aug 14, 2018 3:01 pm Reply with quote    Back to top    

I appreciate the feedback.

I was hoping there was a parameter that controlled the number of records that could be processed before the application replies "No further reports will be generated from this partition until a successful import."

Apparently that is a hard coded number of records,,,set to 4? Or is there a parameter to control it?

Then, I could turn the parameter up to over 50 and the warnings would then cause the job to abort.

Again, thank you much for your replies and insights.

Joel
Rate this response:  
Not yet rated
qt_ky



Group memberships:
Premium Members

Joined: 03 Aug 2011
Posts: 2798
Location: USA
Points: 21145

Post Posted: Wed Aug 15, 2018 4:42 am Reply with quote    Back to top    

I am not aware of such a parameter or setting for that, however, you would not have to run your job using the default to abort after 50 warnings. You could set it to abort after 1 or 2 warnings at run time. If this is a scheduled job, then you would need to reschedule it to alter the setting.

_________________
Choose a job you love, and you will never have to work a day in your life. - Confucius
Rate this response:  
Not yet rated
ray.wurlod

Premium Poster
Participant

Group memberships:
Premium Members, Inner Circle, Australia Usergroup, Server to Parallel Transition Group

Joined: 23 Oct 2002
Posts: 54287
Location: Sydney, Australia
Points: 294450

Post Posted: Wed Aug 15, 2018 5:27 am Reply with quote    Back to top    

One job to prepare the data, loading the result into a Data Set. Another job to load the data from the Data Set into its real target. These two jobs are run from a controlling sequence that determin ...

_________________
RXP Services Ltd
Melbourne | Canberra | Sydney | Hong Kong | Hobart | Brisbane
currently hiring: Canberra, Sydney and Melbourne
Rate this response:  
Not yet rated
Display posts from previous:       

Add To Favorites
View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours