Job Died But Why?

Mar 21, 2008

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

Message
Executed as user: domainatchuser. ...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: domainatchuser. ...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

View 1 Replies


ADVERTISEMENT

Emptyfile Died And File Not Empty

May 26, 2006

I was running a DBCC SHRINKFILE with EMPTYFILE to move data to a different drive. But somehow the autogrow got unchecked on the new file while it was running. So the shrinkfile died and the file wasn't anywhere near being empty. When I try to run it again on the file is comes back right away and says that it completed, but it hasn't moved any data. It like SQL thinks that the empty file is complete. But it isn't near being done, with about 50 GB left to go. I made sure that the new file will autogrow and that it actually can grow and also that I can write to it. I created an index on the filegroup and it went to the new file and not the old. Any help would be appreciated.

Thanks,
Anthony

View 2 Replies View Related

My NT Server Has Died And Taken SQL Server With It, Help

Sep 29, 1998

I have an NT Server (SP3) and I cannot get it to boot. I have installed another copy of NT so that I can get to the files on the NTFS partion where the original NT installation lives (and the MSSQL directory).
What is the best way of recovering the "lost" databases?

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved