473,372 Members | 954 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,372 software developers and data experts.

job died but why?

Hi!
Sometimes I have som jobs that dies.
In the job history I found such as:

Message
Executed as user: domain\batchuser. ...r SET operation. [SQLSTATE
01003] (Message 8153) Warning: Null value is eliminated by an
aggregate or other SET operation. [SQLSTATE 01003] (Message 8153)
Warning: Null value is eliminated by an aggregate or other SET
operation. [SQLSTATE 01003] (Message 8153) Warning: Null value is
eliminated by an aggregate or other SET operation. [SQLSTATE 01003]
(Message 8153) Warning: Null value is eliminated by an aggregate or
other SET operation. [SQLSTATE 01003] (Message 8153) Warning: Null
value is eliminated by an aggregate or other SET operation. [SQLSTATE
01003] (Message 8153) Warning: Null value is eliminated by an
aggregate or other SET operation. [SQLSTATE 01003] (Message 8153)
Warning: Null value is eliminated by an aggregate or other SET
operation. [SQLSTATE 01003] (Message 8153) Warning: Null value is
eliminated by an aggregate or other SET operation. [SQLSTATE 01003]
(Message 8153) Warning: Null value is eliminated by an aggregate or
ot... The step failed

Message
Executed as user: domain\batchuser. ...ted by an aggregate or other
SET operation. [SQLSTATE 01003] (Message 8153) Warning: Null value is
eliminated by an aggregate or other SET operation. [SQLSTATE 01003]
(Message 8153) Warning: Null value is eliminated by an aggregate or
other SET operation. [SQLSTATE 01003] (Message 8153) Warning: Null
value is eliminated by an aggregate or other SET operation. [SQLSTATE
01003] (Message 8153) Warning: Null value is eliminated by an
aggregate or other SET operation. [SQLSTATE 01003] (Message 8153)
Warning: Null value is eliminated by an aggregate or other SET
operation. [SQLSTATE 01003] (Message 8153) Warning: Null value is
eliminated by an aggregate or other SET operation. [SQLSTATE 01003]
(Message 8153) Warning: Null value is eliminated by an aggregate or
other SET operation. [SQLSTATE 01003] (Message 8153) String or binary
data would be truncated. [SQLSTATE 22001] (Error 8152) The statement
has been terminated. [SQLSTATE 01000] (Error 3621). The step failed.

Whats going on?
Normally I got errors catched and logged in table, but not in this
case...

Suggestions how to find root cause?
/Bjorn
Mar 19 '08 #1
1 7105
Hi!
Sorry about the guessing game here.
I actually use batchlogging to avoid this game.

Running the same batchjob manual I got no error.
I hoped maybe it look similar to another kind of problem seen in
practice by people.
I now identified the proc that result in warning, which I now disabled
(SET ANSI_WARNINGS OFF, not that I'm happy about that,
but it should not harm in this case) Now I hope to see more from the
error message.
Remark that they are not exactly the same, or maybe they are, but it
seems that errormessage is truncated...

-thanks
Bjorn
Mar 21 '08 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: Richard Muller | last post by:
I had a nice time at your house last night. Thx. I lost two game of air hockey to Robert. He had this assessment. approximately: he thinks generally that he can beat me at physical things but...
0
by: Vanchau Nguyen | last post by:
I have a very simple problem (I hope). Our master database ran out of connections and we had to restart the server (couldn't SSH into the box). Rebooting the server worked and of our clients...
3
by: John Bailo | last post by:
Vote W '04 Vote for the only pro-GNU/pro-OSS candidate whose policy advisor publicly gave support to the cause. http://www.informationweek.com/story/showArticle.jhtml?articleID=17500856 The...
1
by: Raagz | last post by:
Hi, I have VS.NET 2003 installed on a windows 2000 professional. In the immediate window the intellisense does not work. Anybody got idea of how to fix this issue. Raagz
10
by: Steve | last post by:
Hi- I had this nice little wizard application running. It was comprised of several Panel controls initially set w/ their visibility off except for the first one, then as you progress through...
2
by: Scott Schluer | last post by:
I have an ASP.NET project that has been working fine until recently. For some reason NONE of the javascript on the site works (including rollovers, postbacks, etc). Anything that uses JS does not...
2
by: m00nm0nkey | last post by:
Hello. My organisation has been developing in VB.NET for a couple of months. We've been sucessfully implementing our software on a server with the dot net framework installed for a couple of...
8
by: darrel | last post by:
We've had to move one of our asp.net web applications to a new internal server. The move worked, except that our SUBMIT buttons on all the pages no longer trigger a postback in Internet...
4
by: darrel | last post by:
Our intranet server died a few months ago and we migrated everything over to a new one. When we did that, any app (asp.net 1.1) of ours that depended on client-side navigation just broke. ...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.