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 NOVEMBER 07, 2019

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.

Changes

 

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
Changes
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.