[dev.icinga.com #5688] error in oracle.sql

[icinga-migration]

This issue has been migrated from Redmine: https://dev.icinga.com/issues/5688

Created by Tommi on 2014-02-21 12:00:21 +00:00

Assignee: Tommi
Status: Resolved (closed on 2014-03-03 20:23:37 +00:00)
Target Version: 1.11
Last Update: 2014-12-08 14:47:04 +00:00 (in Redmine)

Icinga Version: 1.10.0
OS Version: any

---

looks like the create sequence SEQ_TIMEDEVENTQUEUE and SEQ_TIMEDEVENTS statements has been removed, but the later following alter sequence left over.

SQL>alter sequence SEQ_TIMEDEVENTQUEUE cache 10;
alter sequence SEQ_TIMEDEVENTQUEUE cache 10
*
ERROR at line 1:
ORA-02289: sequence does not exist

Changesets

2014-03-03 20:09:43 +00:00 by Tommi 4c5d39c

idoutils oracle: remove leftover alter sequence statements for timedevent

this caused to break the install objects sql script

Fixes #5688
Refs #4482

Signed-off-by: Michael Friedrich <Michael.Friedrich@netways.de>

2014-03-03 20:09:57 +00:00 by (unknown) 8f1b2e2

Merge branch 'fix/obsolete-oracle-sql-5688' into support/1.10

Refs #5688

2014-03-03 21:34:07 +00:00 by (unknown) 2e60399

Update Changelog/THANKS.

Refs #5671
Refs #5687
Refs #5688
Refs #5687
Refs #5698
Refs #5684
Refs #5691

---

Relations:

• relates #4482

[icinga-migration]

Updated by Tommi on 2014-02-21 17:22:34 +00:00

• Status changed from Assigned to Feedback
• Done % changed from 0 to 100

oracle.sql modified

[icinga-migration]

Updated by mfriedrich on 2014-03-03 20:08:54 +00:00

• Target Version set to 1.11

seems your commit msg refs are broken. and a target release is also missing.

please use one per line and capitalized, such as

subject: Short description.

longer desc1,
desc2.

Refs #1234
Refs #5678

[icinga-migration]

Updated by Tommi on 2014-03-03 20:23:37 +00:00

• Status changed from Feedback to Resolved

Applied in changeset icinga-core:4c5d39ca680044ae50f994c7925de912239fcf58.

[icinga-migration]

Updated by mfriedrich on 2014-12-08 14:47:04 +00:00

• Project changed from 18 to Core, Classic UI, IDOUtils
• Category changed from 105 to IDOUtils
• Icinga Version changed from 1 to 1
• OS Version set to any