Data Load From FDMEE To Planning Application using MSAD user Fail with Error "HTTPError: HTTP Error 500: Internal Server Error" (Doc ID 2334376.1)

Last updated on SEPTEMBER 09, 2024

Applies to:

Symptoms

Data load to Planning Essbase application using MSAD user fail with following error.

• MSAD user is provisioned with Administrator rights for the planning and essbase components.
• The same user can import the .dat file generated into Essbase through EAS with no issues.
• Data load with Admin user complete successfully.

2017-11-27 14:08:03,219 INFO [AIF]: EssbaseService.exportData - START
2017-11-27 14:08:03,219 DEBUG [AIF]: appId:3, appType:HPL, mcFlag:false, dataLoadMethod:CLASSIC_VIA_EPMI, mDataFlowNode:LOCAL, textDataLoad:N, isFccsLoad:false, isJournalLoad:false
2017-11-27 14:08:03,219 DEBUG [AIF]: LOAD_METHOD:ESSFILE, LOAD_TYPE:DATA, EXPORT_MODE:STORE_DATA, CREATE_DRILL_REGION:true, PURGE_DATA_FILE:false, BATCH_SIZE:10000
2017-11-27 14:08:03,219 DEBUG [AIF]: GlobalUserForAppAccess from Profile: null
2017-11-27 14:08:03,266 INFO [AIF]: Cloud Mode: NONE, Resolved user name for application access: <MSAD User>
2017-11-27 14:08:03,281 FATAL [AIF]: Error in CommData.exportData
Traceback (most recent call last):

File "<string>", line 4632, in exportData
File "<string>", line 1074, in callOdiServlet
File "__pyclasspath__/urllib2.py", line 124, in urlopen
File "__pyclasspath__/urllib2.py", line 387, in open
File "__pyclasspath__/urllib2.py", line 497, in http_response
File "__pyclasspath__/urllib2.py", line 425, in error
File "__pyclasspath__/urllib2.py", line 360, in _call_chain
File "__pyclasspath__/urllib2.py", line 506, in http_error_default

HTTPError: HTTP Error 500: Internal Server Error

Cause

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