SQL - DOMAIN ERROR

 
Vista:

DOMAIN ERROR

Publicado por Alberto (1 intervención) el 05/08/2010 10:30:55
Buenas tardes

Tengo la siguiente consulta que anteriormente me funcionaba y ahora me da el error
DOMAIN ERROR

SELECT
Nodes.Caption, CustomPollers.Description, (exp(avg(log(Rawstatus)))) AS MM,
RIGHT(CONVERT(varchar, DATEADD(minute,DATEDIFF(minute, 0, CustomPollerStatistics_Detail.DateTime) / 30 * 30, 0), 120), 9) AS hora,
DATEPART(dw, CustomPollerStatistics_Detail.DateTime) AS dia,
finicio,ffin,flunsig
FROM Nodes INNER JOIN
fechaspatronmediamoderada ON fechaspatronmediamoderada.caption = Nodes.caption
INNER JOIN
CustomPollerAssignment ON
Nodes.NodeID = CustomPollerAssignment.NodeID INNER JOIN
CustomPollerStatistics_Detail ON
CustomPollerStatistics_Detail.CustomPollerAssignmentID = CustomPollerAssignment.CustomPollerAssignmentID INNER JOIN
CustomPollers ON CustomPollers.PollerID = CustomPollerAssignment.PollerID
AND CustomPollerStatistics_Detail.DateTime >= fechaspatronmediamoderada.finicio
AND CustomPollerStatistics_Detail.DateTime <= fechaspatronmediamoderada.ffin
AND Nodes.Caption IN
(SELECT Caption FROM Nodes
WHERE (Comments LIKE 'firewall')
AND (Caption <> 'FMG3000')
AND (Caption <> 'FGT-REPLICACION1')
AND (Caption <> 'FORTIGATE_ANALYZER')
AND (Caption <> 'nagios-malaga')
AND (Caption <> 'cacti-malaga')
AND (Caption <> 'PVF-1')
AND (Caption <> 'Null')And ([Caption] LIKE '%AV%'))
AND CustomPollers.Description IN
(SELECT DISTINCT Description FROM CustomPollers
WHERE (Description IN
(SELECT Description FROM CustomPollers)
AND Description LIKE '%CPU%')
)
WHERE (DATEPART(dw, CustomPollerStatistics_Detail.DateTime) IN
(SELECT DATEPART(dw, CustomPollerStatistics_Detail.DateTime) AS DW
FROM Nodes INNER JOIN
CustomPollerAssignment ON Nodes.NodeID = CustomPollerAssignment.NodeID INNER JOIN
CustomPollerStatistics_Detail ON
CustomPollerStatistics_Detail.CustomPollerAssignmentID = CustomPollerAssignment.CustomPollerAssignmentID INNER JOIN
CustomPollers ON CustomPollers.PollerID = CustomPollerAssignment.PollerID
AND Nodes.Caption IN
(SELECT Caption
FROM Nodes
WHERE (Comments LIKE 'firewall') AND (Caption <> 'FMG3000') AND (Caption <> 'FGT-REPLICACION1') AND
(Caption <> 'FORTIGATE_ANALYZER') AND (Caption <> 'nagios-malaga') AND (Caption <> 'cacti-malaga') AND
(Caption <> 'PVF-1')And ([Caption] LIKE '%AV%')) AND CustomPollers.Description IN
(SELECT DISTINCT Description
FROM CustomPollers
WHERE (Description IN
(SELECT Description
FROM CustomPollers)
AND Description LIKE '%CPU%'))
GROUP BY LEFT(CONVERT(varchar, DATEADD(minute, DATEDIFF(minute, 0, CustomPollerStatistics_Detail.DateTime) / 30 * 30, 0), 120), 16),
DATEPART(dw, CustomPollerStatistics_Detail.DateTime), RIGHT(CONVERT(varchar, DATEADD(minute, DATEDIFF(minute, 0,
CustomPollerStatistics_Detail.DateTime) / 30 * 30, 0), 120), 9), Nodes.Caption, CustomPollers.Description,
CustomPollerStatistics_Detail.RawStatus))
GROUP BY Nodes.Caption, CustomPollers.Description, RIGHT(CONVERT(varchar, DATEADD(minute, DATEDIFF(minute, 0,
CustomPollerStatistics_Detail.DateTime) / 30 * 30, 0), 120), 9), DATEPART(dw, CustomPollerStatistics_Detail.DateTime),
finicio,ffin,FLUNSIG
ORDER BY Nodes.Caption, CustomPollers.Description, HORA,DIA

Saludos Cordiales.
Valora esta pregunta
Me gusta: Está pregunta es útil y esta claraNo me gusta: Está pregunta no esta clara o no es útil
0
Responder