java/code/src/com/redhat/rhn/common/db/datasource/xml/Monitoring_queries.xml | 2 +-
1 file changed, 1 insertion(+), 1 deletion(-)
New commits:
commit e9cb8e1b3e6bd19992d3921dbf9588cd91a18acd
Author: Michael Mraka <michael.mraka(a)redhat.com>
Date: Thu Mar 31 08:36:44 2011 +0200
replaced check_probe synonym with original table
fixing
com.redhat.rhn.common.db.datasource.CachedStatement - Error while
processing cached statement sql: SELECT C.description,
count(p.recid) probe_count,
count(S.id) server_count
FROM rhn_probe P, rhn_command C, rhn_command_groups CG, rhnServer S,
rhn_probe_state PS, rhnUserServerPerms USP
where P.command_id = C.recid
AND C.group_name = CG.group_name
AND P.recid = PS.probe_id
AND PS.state = ?
AND P.customer_id = ?
AND S.id = (SELECT host_id from check_probe where probe_id =
P.recid)
AND USP.user_id = ?
AND USP.server_id = S.id
GROUP BY CG.description, C.description
ORDER BY CG.description
com.redhat.rhn.common.db.WrappedSQLException: ERROR: relation
"check_probe" does not exist
diff --git a/java/code/src/com/redhat/rhn/common/db/datasource/xml/Monitoring_queries.xml
b/java/code/src/com/redhat/rhn/common/db/datasource/xml/Monitoring_queries.xml
index dc906ea..8ccae6a 100644
--- a/java/code/src/com/redhat/rhn/common/db/datasource/xml/Monitoring_queries.xml
+++ b/java/code/src/com/redhat/rhn/common/db/datasource/xml/Monitoring_queries.xml
@@ -239,7 +239,7 @@ SELECT C.description,
AND P.recid = PS.probe_id
AND PS.state = :state
AND P.customer_id = :org_id
- AND S.id = (SELECT host_id from check_probe where probe_id = P.recid)
+ AND S.id = (SELECT host_id from rhn_check_probe where probe_id = P.recid)
AND USP.user_id = :user_id
AND USP.server_id = S.id
GROUP BY CG.description, C.description
Show replies by thread