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@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