[icinga-checkins] icinga.org: icinga-web/tdressler/issue_3855: Oracle: hoststatus and servicestatus: fix ORA-00932 caused by distinct on a clob field by removing distinct in host .xml and service.xml.

git at icinga.org git at icinga.org
Sat Apr 13 20:58:58 CEST 2013


Module: icinga-web
Branch: tdressler/issue_3855
Commit: 9360d4a1276b4a694a096187fcb915ed3b0a27d9
URL:    https://git.icinga.org/?p=icinga-web.git;a=commit;h=9360d4a1276b4a694a096187fcb915ed3b0a27d9

Author: Thomas Dressler <tdressler at tdressler.net>
Date:   Sat Apr 13 20:55:39 2013 +0200

Oracle: hoststatus and servicestatus: fix ORA-00932 caused by distinct on a clob field by removing distinct in host.xml and service.xml.
refs #3855

---

 app/modules/Api/config/views/host.xml    |    4 ++--
 app/modules/Api/config/views/service.xml |    2 +-
 2 files changed, 3 insertions(+), 3 deletions(-)

diff --git a/app/modules/Api/config/views/host.xml b/app/modules/Api/config/views/host.xml
index 7798846..e301b3f 100644
--- a/app/modules/Api/config/views/host.xml
+++ b/app/modules/Api/config/views/host.xml
@@ -6,7 +6,7 @@
         <dql name="TARGET_HOST" >
             <query>
             <![CDATA[
-            SELECT DISTINCT
+            SELECT
                 h.icon_image AS HOST_ICON_IMAGE,
                 i.instance_name AS INSTANCE_NAME,
                 h.host_object_id AS HOST_OBJECT_ID,
@@ -161,7 +161,7 @@
          <dql base="TARGET_HOST" name="TARGET_HOST_OPEN_PROBLEMS" >
             <query>
             <![CDATA[
-            SELECT DISTINCT
+            SELECT 
                    h.icon_image AS SERVICE_ICON_IMAGE,
                 i.instance_name AS INSTANCE_NAME,
                 h.host_object_id AS HOST_OBJECT_ID,
diff --git a/app/modules/Api/config/views/service.xml b/app/modules/Api/config/views/service.xml
index 893e767..50bacb8 100644
--- a/app/modules/Api/config/views/service.xml
+++ b/app/modules/Api/config/views/service.xml
@@ -6,7 +6,7 @@
         <dql name="TARGET_SERVICE" >
             <query>
             <![CDATA[
-            SELECT DISTINCT
+            SELECT 
                 s.icon_image AS SERVICE_ICON_IMAGE,
                 i.instance_name AS INSTANCE_NAME,
                 h.host_object_id AS HOST_OBJECT_ID,





More information about the icinga-checkins mailing list