XML for Analysis SDK (msxisapi.dll) seems to have problems with Microsoft Reporting Services. Once you access a Reporting Services report you can no longer access XMLA via a web browser using the Microsoft.XMLHTTP object. Here are the steps to recreate the problem: 1) Download this test html page http://www.reportportal.com/MDX.htm and save it to your desktop. 2) Make sure that the connection information is correct and click the Submit button to test. Take a look at the XML returned by the page. 3) Open a Reporting Services report in the same browser 4) Go back to the Test page. Run it again. It will return the following error "An error occurred while processing the request." -- Regards, Igor Krupitsky http://www.reportportal.com
have you created a dedicated application pool for the XMLA virtual directory? "Igor Krupitsky" wrote in message news:eKgXzvQrFHA.3068@TK2MSFTNGP14.phx.gbl... > XML for Analysis SDK (msxisapi.dll) seems to have problems with Microsoft > Reporting Services. Once you access a Reporting Services report you can > no > longer access XMLA via a web browser using the Microsoft.XMLHTTP object. > > > > Here are the steps to recreate the problem: > > > > 1) Download this test html page http://www.reportportal.com/MDX.htm > and > save it to your desktop. > > 2) Make sure that the connection information is correct and click the > Submit button to test. Take a look at the XML returned by the page. > > 3) Open a Reporting Services report in the same browser > > 4) Go back to the Test page. Run it again. It will return the > following error "An error occurred while processing the request." > > > > -- > Regards, > Igor Krupitsky > http://www.reportportal.com > >
Jj, Thanks for replying to my question. Yes, I have tried putting XMLA virtual directory into a dedicated application pool and a separate process. Nothing seems to help. I think Reporting Services is setting up a site cookie that chokes msxisapi.dll. Where you able to reproduce the problem on your PC? Regards, Igor "Jj" wrote in message news:uz0gUgYuFHA.3252@TK2MSFTNGP10.phx.gbl... > have you created a dedicated application pool for the XMLA virtual > directory? > > "Igor Krupitsky" wrote in message > news:eKgXzvQrFHA.3068@TK2MSFTNGP14.phx.gbl... > > XML for Analysis SDK (msxisapi.dll) seems to have problems with Microsoft > > Reporting Services. Once you access a Reporting Services report you can > > no > > longer access XMLA via a web browser using the Microsoft.XMLHTTP object. > > > > > > > > Here are the steps to recreate the problem: > > > > > > > > 1) Download this test html page http://www.reportportal.com/MDX.htm > > and > > save it to your desktop. > > > > 2) Make sure that the connection information is correct and click the > > Submit button to test. Take a look at the XML returned by the page. > > > > 3) Open a Reporting Services report in the same browser > > > > 4) Go back to the Test page. Run it again. It will return the > > following error "An error occurred while processing the request." > > > > > > > > -- > > Regards, > > Igor Krupitsky > > http://www.reportportal.com > > > > > >
have you try to create a second virutal server on a dedicated TCP port for the XMLA access? to identify if the issue is at the server level or client level. "Igor Krupitsky" wrote in message news:utisYGcuFHA.4080@TK2MSFTNGP12.phx.gbl... > Jj, > > Thanks for replying to my question. > > Yes, I have tried putting XMLA virtual directory into a dedicated > application pool and a separate process. Nothing seems to help. > > I think Reporting Services is setting up a site cookie that chokes > msxisapi.dll. > > Where you able to reproduce the problem on your PC? > > Regards, > Igor > "Jj" wrote in message > news:uz0gUgYuFHA.3252@TK2MSFTNGP10.phx.gbl... > >> have you created a dedicated application pool for the XMLA virtual >> directory? >> >> "Igor Krupitsky" wrote in message >> news:eKgXzvQrFHA.3068@TK2MSFTNGP14.phx.gbl... >> > XML for Analysis SDK (msxisapi.dll) seems to have problems with > Microsoft >> > Reporting Services. Once you access a Reporting Services report you >> > can >> > no >> > longer access XMLA via a web browser using the Microsoft.XMLHTTP >> > object. >> > >> > >> > >> > Here are the steps to recreate the problem: >> > >> > >> > >> > 1) Download this test html page >> > http://www.reportportal.com/MDX.htm >> > and >> > save it to your desktop. >> > >> > 2) Make sure that the connection information is correct and click > the >> > Submit button to test. Take a look at the XML returned by the page. >> > >> > 3) Open a Reporting Services report in the same browser >> > >> > 4) Go back to the Test page. Run it again. It will return the >> > following error "An error occurred while processing the request." >> > >> > >> > >> > -- >> > Regards, >> > Igor Krupitsky >> > http://www.reportportal.com >> > >> > >> >> > >
