| T O P I C R E V I E W |
| keith |
Posted - 06/05/2012 : 13:23:27
Subscriptions are working for SQL reports but not for OLAP reports. History reports the following error.
Execute Error: Data at the root level is invalid. Line 1, position 1.
, XML: The remote server returned an error: (401) Unauthorized.
at System.Net.HttpWebRequest.GetResponse()
at RpScheduler.XmlaRequest.PostData(String sUrl, String sData)
, XmlaRequest.Execute()>LoadXml()
at RpScheduler.XmlaRequest.Execute(String sMdx, String sServer, String sCatalog, String sURL)
at RpScheduler.XmlaRequest.ExecuteMdx(String sMdx, String sServer, String sCatalog, String sURL, String sOptionXml, String sConditionalFormat)
at RpScheduler.XmlaRequest.GetReportHtml(String sReportId, String sUserId, String sJobId)
at RpScheduler.Scheduler.ProcessReport(String sReportId, String sReportType, String sJobId, String sDeliveryType, String sContentType, String iLanguageId, String sToUserId, String sToUserName, String sToEmail, String sToNtUserId, String sToNtPassword, String sConditionOperator, String iConditionRow, String iConditionCol, String sConditionValue, String& sStylePage, String& sReportHtml, String& sError, String& sMDX, String& sReportDesc, String& sFilterLabel, Boolean& bConditionMet, String& sStyleThemeId); XMLA: http://localhost/xmla/msmdpump.dll; NtUserId: |
| 1 L A T E S T R E P L I E S (Newest First) |
| admin |
Posted - 06/05/2012 : 14:26:56
The problem is that the user used for the RP Scheduler Windows service does not have access to XMLA virtual directory. You can:
1) Give the user access by using Windows Explorer and SSAS roles security.
2) Change the user used by RP Scheduler Windows service
3) Use Anonymous Access for XMLA virtual directory
|
|
|
Report Portal
