Skip to Main Content

Oracle Analytics Cloud

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Power User can't load data with EPM Data Management

Hi,

Power User has Run Integration Role, when the Data Load Rule is executed by the user, it fails at Export Step:

2023-03-21 16:19:41,338 INFO [AIF]: -------END VALIDATE STEP-------
2023-03-21 16:19:41,396 INFO [AIF]: -------START EXPORT STEP-------
2023-03-21 16:19:41,571 INFO [AIF]: EssbaseService.exportData - START
2023-03-21 16:19:41,585 INFO [AIF]: Creating data file: EPMSIC_204.dat
2023-03-21 16:19:49,889 INFO [AIF]: REST_PAGE_SIZE_LIMIT: 44000
2023-03-21 16:19:49,889 ERROR [AIF]: Invalid column name
2023-03-21 16:19:49,889 INFO [AIF]: EssbaseService.exportData - END (false)
2023-03-21 16:19:49,896 FATAL [AIF]: Error in CommData.exportData
Traceback (most recent call last):
File "<string>", line 2326, in exportData
RuntimeError: false

2023-03-21 16:19:50,099 FATAL [AIF]: Error in COMM Export Data
2023-03-21 16:19:50,104 INFO [AIF]: FDMEE Process End, Process ID: 204

However, if an admin runs the same Rule with the same file, it loads the data:

2023-03-21 16:17:03,539 INFO [AIF]: -------END VALIDATE STEP-------
2023-03-21 16:17:03,617 INFO [AIF]: -------START EXPORT STEP-------
2023-03-21 16:17:03,777 INFO [AIF]: EssbaseService.exportData - START
2023-03-21 16:17:03,792 INFO [AIF]: Creating data file: EPMSIC_203.dat
2023-03-21 16:17:12,436 INFO [AIF]: Data file creation completed: 11889
2023-03-21 16:17:12,436 INFO [AIF]: EssbaseService.exportData - END (true)
2023-03-21 16:17:12,510 INFO [AIF]: Executing the following script: BefLoad.py
2023-03-21 16:17:12,658 INFO [AIF]: No business rules found for load id:203
2023-03-21 16:17:12,733 INFO [AIF]: EssbaseService.loadData - START

My undestanding is that the Power User can't create the .dat file since the next line after “Creating data file: EPMSIC_203.dat” says “REST_PAGE_SIZE_LIMIT: 44000”.

If we set this Power User as an admin, the file loads.

We disabled the Security, tried restarting the services.

Tested with a smaller file of only 2 rows.

Thanks in advance.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked by Renae Stout-Oracle on Jul 8 2024
Added on Mar 21 2023
2 comments
912 views