[icinga-checkins] icinga.org: icinga-core/test/ido: idoutils: fix ORA-00913 too many values when MERGE INTO eventhandlers #2319

git at icinga.org git at icinga.org
Wed Feb 22 10:41:12 CET 2012


Module: icinga-core
Branch: test/ido
Commit: e586b345326ad2dd9b40cfbd633d73d16bbbd641
URL:    https://git.icinga.org/?p=icinga-core.git;a=commit;h=e586b345326ad2dd9b40cfbd633d73d16bbbd641

Author: Michael Friedrich <michael.friedrich at univie.ac.at>
Date:   Sat Feb 18 11:38:06 2012 +0100

idoutils: fix ORA-00913 too many values when MERGE INTO eventhandlers #2319

refs #2319

---

 Changelog                |    1 +
 module/idoutils/src/db.c |    2 +-
 2 files changed, 2 insertions(+), 1 deletions(-)

diff --git a/Changelog b/Changelog
index 1cd28c7..e0d6504 100644
--- a/Changelog
+++ b/Changelog
@@ -9,6 +9,7 @@ Thanks to all contributers, testers and developers. Please read AUTHORS and THAN
 ENHANCEMENTS
 
 FIXES
+* idoutils: fix ORA-00913 too many values when MERGE INTO eventhandlers #2319
 
 CHANGES
 * debug: set debug_verbosity=2 by default
diff --git a/module/idoutils/src/db.c b/module/idoutils/src/db.c
index 9d8290e..3f2e0e2 100644
--- a/module/idoutils/src/db.c
+++ b/module/idoutils/src/db.c
@@ -4712,7 +4712,7 @@ int ido2db_oci_prepared_statement_eventhandlerdata(ido2db_idi *idi) {
 	             "timeout=:X13, early_timeout=:X14, execution_time=:X15, "
 	             "return_code=:X16, output=:X17, long_output=:X18u "
 	             "WHEN NOT MATCHED THEN "
-	             "INSERT (instance_id, eventhandler_type, object_id, "
+	             "INSERT (id, instance_id, eventhandler_type, object_id, "
 	             "state, state_type, start_time, start_time_usec, "
 	             "end_time, end_time_usec, command_object_id, "
 	             "command_args, command_line, "





More information about the icinga-checkins mailing list