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.