ReportPortal
ReportPortal
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 ReportPortal General Forum
 Report Portal General Issues
 Subscription error
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

keith

New Zealand
26 Posts

Posted - 06/05/2012 :  13:23:27  Show Profile  Reply with Quote
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:

admin

1640 Posts

Posted - 06/05/2012 :  14:26:56  Show Profile  Reply with Quote
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
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
ReportPortal © 2000-2002 Snitz Communications Go To Top Of Page