My Oracle Support Banner

Hierarchy resave is resulting in '-1' version entries in rev_bihier and rev_locale_hier tables for certain hierarchies. (Doc ID 2605700.1)

Last updated on FEBRUARY 27, 2022

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 8.0.7.1.0 and later
Information in this document applies to any platform.

Symptoms

On : 8.0.7.1.0 version, Unified Metadata Manager_OFSS

When attempting to resave hierarchies using RUNIT.sh run executable as a task in a batch,  it is resulting in '-1' version entries in rev_bihier and rev_locale_hier tables.

ERROR
-----------------------

SMSService.log

10-10-19 10:47:12,044 MST AM] [INFO ] [APP] [SMS] [NA] [DACDATABASEGATEWAY] Failed in Executing Bind variables Update [Query : UPDATE rev_bihier SET version_no = 5 WHERE hier_code = 'HMGMT001' AND version_no = 0] [On URL: jdbc:oracle:thin:XXXX] [Driver: oracle.jdbc.driver.OracleDriver]
[10-10-19 10:47:12,045 MST AM] [ERROR] [APP] [SMS] [NA] [DACDATABASEGATEWAY]
java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (ATOMIC_SCHEMA.REV_BIHIER_PK) violated


[10-10-19 10:47:14,244 MST AM] [INFO ] [APP] [SMS] [NA] [DACDATABASEGATEWAY] Failed in Executing Bind variables Update [Query : UPDATE rev_locale_hier SET version_no = 5 WHERE ( metadata_key LIKE 'HMGMT001:%' OR metadata_key LIKE '[HMGMT001]%' )AND version_no = 0 AND upper(metadata_locale) LIKE upper('%')] [On URL: jdbc:oracle:thin:@//XXXX] [Driver: oracle.jdbc.driver.OracleDriver]
[10-10-19 10:47:14,244 MST AM] [ERROR] [APP] [SMS] [NA] [DACDATABASEGATEWAY]
java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (ATOMIC_SCHEMA.REV_LOCALE_HIER_PK) violated


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Try resaving hierarchies using RUNIT.sh run executable as a task in a batch.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot see the changes done to the hierarchy after resave.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.