ASP.NET, SQL Server, WPF, C#, VB.NET

Hi, 
 
I am trying to setup an XMLA connection to the foodmart 2000 sample 
 
dbase. 
 
But the following error is generated: 
 
'System.Web.Services.Protocols.SoapException: An error occurred while 
 
processing the request. 
 
at 
 
System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage 
 
message, WebResponse response, Stream responseStream, Boolean 
 
asyncCall) 
 
at 
 
System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String 
 
methodName, Object[] parameters) 
 
at MsXmlAnalysis.Execute(XmlElement Command, XmlElement Properties) 
 
in e:\MCC prj\trial\MsXmlAnalysis.cs:line 107 
 
at trial.Program.Execute(String Command, String Properties) in 
 
e:\MCC prj\trial\Program.cs:line 54 
 
at trial.Program.Main(String[] args) in e:\MCC 
 
prj\trial\Program.cs:line 25' 
 
Is there anyone who can help me on locating the problem? 
 
thanx, 
 
Bhakti

Try to obtain the inner exception information. Also, try to use a HTTP trace 
 
utility to see what request/response is causing this error. 
 
Does the sample application work for you? 
 
Thanks, 
 
Akshai 
 
-- 
 
Try out the MSDN Forums for Analysis Services at: 
 
http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=83&SiteID=1 
 
This posting is provided "AS IS" with no warranties, and confers no rights 
 
Please do not send email directly to this alias. This alias is for newsgroup 
 
purposes only. 
 
"Bhakti" <bhakti.kulkarni@gmail.com> wrote in message 
 
news:1155195299.015661.17900@75g2000cwc.googlegroups.com...

Hi Akshai, 
 
Here are some more details : 
 
The inner exception information is null, but it is showing 
 
_COMPlusExceptionCode = -532459699. 
 
Error Details :- 
 
Description: An unhandled exception occurred during the execution of 
 
the current web request. Please review the stack trace for more 
 
information about the error and where it originated in the code. 
 
Exception Details: System.Web.Services.Protocols.SoapException: An 
 
error occurred while processing the request. 
 
Source Error: 
 
Line 105:    [return: 
 
System.Xml.Serialization.XmlElementAttribute("return", 
 
Form=System.Xml.Schema.XmlSchemaForm.Unqualified)] 
 
Line 106:    public System.Xml.XmlElement 
 
Execute([System.Xml.Serialization.XmlElementAttribute(IsNullable=true)] 
 
System.Xml.XmlElement Command, 
 
[System.Xml.Serialization.XmlElementAttribute(IsNullable=true)] 
 
System.Xml.XmlElement Properties) { 
 
Line 107:        object[] results = this.Invoke("Execute", new object[] 
 
{ 
 
Line 108:                    Command, 
 
Line 109:                    Properties}); 
 
Source File: e:\MCC prj\Execute\App_Code\MsXmlAnalysis.cs    Line: 107 
 
Stack Trace: 
 
[SoapException: An error occurred while processing the request.] 
 
System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage 
 
message, WebResponse response, Stream responseStream, Boolean 
 
asyncCall) +533462 
 
System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String 
 
methodName, Object[] parameters) +204 
 
MsXmlAnalysis.Execute(XmlElement Command, XmlElement Properties) in 
 
e:\MCC prj\Execute\App_Code\MsXmlAnalysis.cs:107 
 
_Default.execute(String Command, String Properties) in e:\MCC 
 
prj\Execute\Default.aspx.cs:58 
 
_Default.Execute_Click(Object sender, EventArgs e) in e:\MCC 
 
prj\Execute\Default.aspx.cs:30 
 
System.Web.UI.WebControls.Button.OnClick(EventArgs e) +105 
 
System.Web.UI.WebControls.Button.RaisePostBackEvent(String 
 
eventArgument) +107 
 
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String 
 
eventArgument) +7 
 
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler 
 
sourceControl, String eventArgument) +11 
 
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) 
 
+33 
 
System.Web.UI.Page.ProcessRequestMain(Boolean 
 
includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) 
 
+5102 
 
HTTP Trace Information : 
 
Unhandled Execution Error 
 
An error occurred while processing the request. 
 
at 
 
System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage 
 
message, WebResponse response, Stream responseStream, Boolean 
 
asyncCall) 
 
at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String 
 
methodName, Object[] parameters) 
 
at MsXmlAnalysis.Execute(XmlElement Command, XmlElement Properties) 
 
in e:\MCC prj\Execute\App_Code\MsXmlAnalysis.cs:line 107 
 
at _Default.execute(String Command, String Properties) in e:\MCC 
 
prj\Execute\Default.aspx.cs:line 58 
 
at _Default.Execute_Click(Object sender, EventArgs e) in e:\MCC 
 
prj\Execute\Default.aspx.cs:line 30 
 
at System.Web.UI.WebControls.Button.OnClick(EventArgs e) 
 
at System.Web.UI.WebControls.Button.RaisePostBackEvent(String 
 
eventArgument) 
 
at 
 
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String 
 
eventArgument) 
 
at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler 
 
sourceControl, String eventArgument) 
 
at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection 
 
postData) 
 
at System.Web.UI.Page.ProcessRequestMain(Boolean 
 
includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) 
 
I am trying sample application, but it's throwing same exception. 
 
Thanks, 
 
Bhakti 
 
Akshai Mirchandani [MS] wrote:

Try to trace the HTTP request/response (there are publicly available HTTP 
 
trace utilities that you can use). It would appear that your XMLA 
 
installation isn't properly configured, but I can't see anything in the 
 
details below to clearly indicate what the problem could be. 
 
Thanks, 
 
Akshai 
 
-- 
 
Try out the MSDN Forums for Analysis Services at: 
 
http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=83&SiteID=1 
 
This posting is provided "AS IS" with no warranties, and confers no rights 
 
Please do not send email directly to this alias. This alias is for newsgroup 
 
purposes only. 
 
"Bhakti" <bhakti.kulkarni@gmail.com> wrote in message 
 
news:1155277072.964841.72040@m73g2000cwd.googlegroups.com...