Batch Hierarchy Load Overload Error During Hierarchy Flattening Process (Doc ID 1681716.1)

Last updated on JUNE 13, 2024

Applies to:

Symptoms

On 7.3, when attempting to run the Hierarchy Flattening Transformation, the following error occurs in the FSI_MESSAGE_LOG messages for the batch:

ERROR

Batch Hierarchy Load Overload
Mode and Hier Id :2--200720
Deleting Hier Id :200720
vsql::  INSERT INTO REV_HIER_FLATTENED (  DIMENSION_ID  ,  HIERARCHY_ID  ,  LEAF_NODE     ,  LEVEL_01_CODE ,  LEVEL_01_NAME ,  LEVEL_02_CODE ,  LEVEL_02_NAME ,  LEVEL_03_CODE ,  LEVEL_03_NAME ,  LEVEL_04_CODE ,  LEVEL_04_NAME ,  LEVEL_05_CODE ,  LEVEL_05_NAME ,  LEVEL_06_CODE ,  LEVEL_06_NAME ,  LEVEL_07_CODE ,  LEVEL_07_NAME ,  LEVEL_08_CODE ,  LEVEL_08_NAME ,  LEVEL_09_CODE ,  LEVEL_09_NAME ,  LEVEL_10_CODE ,  LEVEL_10_NAME ,  LEVEL_11_CODE ,  LEVEL_11_NAME ,  LEVEL_12_CODE ,  LEVEL_12_NAME ,  LEVEL_13_CODE ,  LEVEL_13_NAME ,  LEVEL_14_CODE ,  LEVEL_14_NAME ,  LEVEL_15_CODE , LEVEL_15_NAME ,  LEVEL_16_CODE ,  LEVEL_16_NAME ,  LEVEL_17_CODE ,  LEVEL_17_NAME ,  LEVEL_18_CODE ,  LEVEL_18_NAME ,  LEVEL_19_CODE ,  LEVEL_19_NAME ,  LEVEL_20_CODE ,  LEVEL_20_NAME )  SELECT 3 DIMENSION_ID, 200720 HIERARCHY_ID , LEAF_NODE , null LEVEL_1_CODE,null LEVEL_1_NAME,null LEVEL_2_CODE,null LEVEL_2_NAME,null LEVEL_3_CODE,null LEVEL_3_NAME,null LEVEL_4_CODE,null LEVEL_4_NAME,null LEVEL_5_CODE,null LEVEL_5_NAME,null LEVEL_6_CODE,null LEVEL_6_NAME,null LEVEL_7_CODE,null LEVEL_7_NAME,null LEVEL_8_CODE,null LEVEL_8_NAME,null LEVEL_9_CODE,null LEVEL_9_NAME,null LEVEL_10_CODE,null LEVEL_10_NAME,null LEVEL_11_CODE,null LEVEL_11_NAME,null LEVEL_12_CODE,null LEVEL_12_NAME,null LEVEL_13_CODE,null LEVEL_13_NAME,null LEVEL_14_CODE,null LEVEL_14_NAME,null LEVEL_15_CODE,null LEVEL_15_NAME,null LEVEL_16_CODE,null LEVEL_16_NAME,null LEVEL_17_CODE,null LEVEL_17_NAME,null LEVEL_18_CODE,null LEVEL_18_NAME, REV_HIER_TRANSFORMATON_BIAPPS.getTokenValueAt(NODE_PATH,2,'&') LEVEL_19_CODE, REV_HIER_TRANSFORMATON_BIAPPS.getTokenValueAt(NODE_NAME_PATH,2,'&') LEVEL_19_NAME, REV_HIER_TRANSFORMATON_BIAPPS.getTokenValueAt(NODE_PATH,1,'&') LEVEL_20_CODE, REV_HIER_TRANSFORMATON_BIAPPS.getTokenValueAt(NODE_NAME_PATH,1,'&') LEVEL_20_NAME
Error while executing hierachy Query

The issue can be reproduced at will with the following steps:
1. Ran Hierarchy Flatenning function batch_hierTransformation via Batch Execution.
2. No results in REV_HIER_FLATTENED table instead received error in FSI_MESSAGE_LOG.

Cause

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