August 11, 2010 at 12:30 am
Hi,
When I am trying to run a scheudled job in SQL SErver 2005, getting the below error and job gets failed.
8/10/2010 8:00:00 PM
LogJob History (Datamart Copy)
Step ID1
ServerEUDNTKRMPRODSQL
Job NameDatamart Copy
Step NameDataMartUpdateProcedure
Duration02:19:20
Sql Severity16
Sql Message ID8115
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted0
Message
Executed as user: KONENET\clustersql_eudntkrm. ... 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 other SET operation. [SQLSTATE 01003] (Message 8153) Warning... The step failed.
Can anyone tell me what should be the problem with this type of warning error and is there any way to disable the warning.
Thanks in Advance,
Regards,
Naveen
August 11, 2010 at 1:24 am
is there any sql script or stored proc running under it ? POst it
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
August 11, 2010 at 3:16 am
There is a SP running and its very big to paste it here. But can anyone tell me why its coming and how we can overcome with this. It looks like the complete SP has run and because of that wraning the job got failed.
August 11, 2010 at 3:52 am
ekknaveen (8/11/2010)
There is a SP running and its very big to paste it here. But can anyone tell me why its coming and how we can overcome with this. It looks like the complete SP has run and because of that wraning the job got failed.
Convert that Sp in script ( remove "create proc" syntax from above ) and then run it in mgmt.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
August 12, 2010 at 7:08 am
when i tried to run the below query gets the warning message
Warning: Null value is eliminated by an aggregate or other SET operation.
SELECT
S.StatisticsStartTime,
S.EquipmentNumber_FK,
isnull(MAX(S.StatisticsEndTime),0),
isnull(MAX(E.EquipmentClass_FK),0),
isnull(MAX(E.RemoteMonitoringType_FK),0),
isnull(MAX(E.AnalyzerType_FK),0),
isnull(MAX(S.TotalStarts),0),
isnull(MAX(S.TotalRunTime),0),
isnull(MAX(S.DoorOperations),0),
isnull(MAX(S.Knx3NbrRelevellings),0),
isnull(MAX(S.CreateDate),0)
FROM KRM.dbo.ElevatorTotalStatistics S INNER JOIN KRM.dbo.Equipment E ON S.EquipmentNumber_FK = E.EquipmentNumber WHERE
-- AND NOT EXISTS (SELECT * FROM ElevatorTotalStatistics T2 WHERE T2.EquipmentNumber_FK = E.EquipmentNumber AND S.StatisticsStartTime = T2.StatisticsStartTime)
-- 10.12.2004 / Tiina Mikonmäki
NOT EXISTS (SELECT * FROM ElevatorTotalStatistics T2 WHERE T2.EquipmentNumber_FK = E.EquipmentNumber AND S.CreateDate = T2.CreateDate)
GROUP BY
S.StatisticsStartTime,
S.EquipmentNumber_FK
August 12, 2010 at 7:36 am
please use stored procedure like this to avoid this warning
create proc nameofSP
as
SET ANSI_WARNINGS off
your code
SET ANSI_WARNINGS ON
November 8, 2010 at 5:34 am
amazing.. it worked like a wonder for me..
thanks a bunch mayank_tyagi 🙂
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply