Error "Unable to load the following resource: An error occured attempting to load Essbase with EssImport: "With Data Value [%s], Too Many Values In Row" When Importing Projects 'OEP_PFP' Cube from Data Management (Doc ID 2981608.1)

Last updated on NOVEMBER 14, 2023

Applies to:

Symptoms

Importing the Projects from Source PPM to Target EPBCS Application through Data Management returns with an error.


ERROR
--------

Unable to obtain dimension information and/or perform a data load: com.hyperion.planning.HspRuntimeException: Unable to load the following resource: An error occured attempting to load Essbase with EssImport: "With Data Value [%s], Too Many Values In Row, [%s] Records Completed", for application "ABCPLN", cube "OEP_PFP", data file "/u02/user_projects/instance0/tmp/XXXXX_-1XRP44TNIVOZG/hsp_hal_load0.txt".
Outline data store load process finished. 516 data records were read, 517 data records were processed, 517 were accepted for loading (verify actual load with Essbase log files), 0 were rejected.
Outline data store load process finished. 516 data records were read, 517 data records were processed, 517 were accepted for loading (verify actual load with Essbase log files), 0 were rejected.
Process failed with error code: com.hyperion.planning.HspRuntimeException: Unable to load the following resource: An error occured attempting to load Essbase with EssImport: "With Data Value [%s], Too Many Values In Row, [%s] Records Completed", for application "ABCPLN", cube "OEP_PFP", data file "/u02/user_projects/instance0/tmp/XXXXX_-1XRP44TNIVOZG/hsp_hal_load0.txt".
Outline load finished with errors. Check details in status.


INFO [AIF]: EssbaseService.loadData - END (false)
DEBUG [AIF]: AIFUtil.callOdiServlet - END
FATAL [AIF]: Error in CommData.loadData
Traceback (most recent call last):
  File "", line 2440, in loadData
RuntimeError: false

Cause

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