Random Error ' Drill Region was not created ' When Loading to FCCS (Doc ID 3000031.1)

Last updated on FEBRUARY 02, 2024

Applies to:

Symptoms

ACTUAL BEHAVIOR
---------------

Randomly when running frequent data loads the following error will be seen in the process log:

ERROR: Drill Region was not created/updated. No valid data rows exist in TDATASEG for Process ID:

Error from AIF log:

[SRC_CLASS: com.hyperion.aif.gl.drilldown.util.DrillRegionImpl] [SRC_METHOD: manageDrillRegions] ERROR: Drill Region was not created/updated. No valid data rows exist in TDATASEG for Process ID: XXXX[[
java.lang.Exception: ERROR: Drill Region was not created/updated. No valid data rows exist in TDATASEG for Process ID: XXXX
at com.hyperion.aif.gl.drilldown.util.DrillRegionImpl.manageDrillRegions(DrillRegionImpl.java:323)
at com.hyperion.aif.gl.drilldown.util.DrillRegionImpl.createDrillRegions(DrillRegionImpl.java:89)
at com.hyperion.aif.webservices.EssbaseService.createDrillRegions(EssbaseService.java:2009)
at com.hyperion.aif.webservices.EssbaseService.loadData(EssbaseService.java:872)
at com.hyperion.aif.webservices.HPLService.loadData(HPLService.java:43)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at com.hyperion.aif.servlet.ODIServlet.doPost(ODIServlet.java:97)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)

Changes

 Frequent runs of the same data load rule with the same POV (Location, Category, Period).

Cause

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