7022558: Vibe database upgrade on Oracle fails with error ORA-02273: this unique/primary key is referenced by some foreign keys

This document (7022558) is provided subject to the disclaimer at the end of this document.

Environment

Micro Focus Vibe 4.0.3

Micro Focus Vibe 4.0.4

Situation

When updating from an earlier version of Vibe to Micro Focus Vibe 4.0.3, 4.0.4 or newer with an Oracle database, the database update step (as documented in the Vibe 4.0.3 Update Guide) fails with an error that looks like:

SEVERE 9/22/17 11:33 AM:liquibase: Change Set scripts/changelog/oracle-changelog-quartz-1.8-to-2.2.xml::6-4::jong failed. Error: Error executing SQL alter table SSQRTZ_JOB_DETAILS drop primary key drop index: ORA-02273: this unique/primary key is referenced by some foreign keys

liquibase.exception.DatabaseException: Error executing SQL alter table SSQRTZ_JOB_DETAILS drop primary key drop index: ORA-02273: this unique/primary key is referenced by some foreign keys

at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:62)

at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:104)

at liquibase.database.AbstractDatabase.execute(AbstractDatabase.java:1091)

…..

…..

Resolution

A fix for this issue is available for Vibe 4.0.3 / 4.0.4. Please contact Micro Focus Customer Care with reference to this TID for further assistance.

Disclaimer

This Support Knowledgebase provides a valuable tool for NetIQ/Novell/SUSE customers and parties interested in our products and solutions to acquire information, ideas and learn from one another. Materials are provided for informational, personal or non-commercial use within your organization and are presented “AS IS” WITHOUT WARRANTY OF ANY KIND.

Related:

Re: SQL Recovery Tool to Repair Corrupt MDF Database

I would like to refer an effective result-oriented tool, SQL database recovery tool. The tool quickly resolves all types corruption issues. The SQL repair tool also recovers all tables, stored procedure, functions, views, rules, triggers and associated Primary Key, Unique keys and etc.It completely repairs the corrupted MDF database files and recovers the data from the SQL database.It can successfully restore tables, triggers, indexes, keys, constraints, rules, and defaults from corrupt SQL database, and save them into a new database file. Also, it allows users to save recovered data in the form of SQL scripts. I hope the shared information would be helpful here.

Download Link :- http://www.filesrepairtool.com/sql-database-repair.html

Related:

Does prepared statement in mysql really protect from sql inject?

This is working as designed, you’re protected from SQL injection problems. The key thing here is SQL injection attacks are just one vector of many. In order to safely use that content you must escape it properly for the context in which it’s used. If you’re displaying that as HTML that means using a function …

Related: