Error configuring a OLAP connector to MS Analysis Server 2000

[Former Member]

Hi,

I am unable to configure the OLAP Data Connector. I get the Status (500): Server Error. This is occuring both in 11.5.3 and 12.0.5.

Detailed error log:

java.lang.Exception: Status (500): Server Error com.lighthammer.Illuminator.logging.LHException: java.lang.Exception: Status (500): Server Error at com.lighthammer.xml.XMLHandler.getDocumentWithPost(Unknown Source) at com.lighthammer.Illuminator.connectors.OLAP.XMLARequestHandler.discoverRequest(Unknown Source) at com.lighthammer.Illuminator.connectors.OLAP.OLAP.processRequest(Unknown Source) at com.lighthammer.Illuminator.services.handlers.IlluminatorService.processRequest(Unknown Source) at com.lighthammer.Illuminator.services.ServiceManager.runQuery(Unknown Source) at com.lighthammer.Illuminator.servlet.Illuminator.service(Unknown Source) at javax.servlet.http.HttpServlet.service(HttpServlet.java:856) at com.newatlanta.servletexec.SERequestDispatcher.forwardServlet(SERequestDispatcher.java:638) at com.newatlanta.servletexec.SERequestDispatcher.forward(SERequestDispatcher.java:236) at com.newatlanta.servletexec.SERequestDispatcher.internalForward(SERequestDispatcher.java:283) at com.newatlanta.servletexec.SEFilterChain.doFilter(SEFilterChain.java:96) at com.lighthammer.cms.system.CMSFilter.doFilter(Unknown Source) at com.newatlanta.servletexec.SEFilterChain.doFilter(SEFilterChain.java:60) at com.newatlanta.servletexec.ApplicationInfo.filterApplRequest(ApplicationInfo.java:2159) at com.newatlanta.servletexec.ApplicationInfo.processApplRequest(ApplicationInfo.java:1823) at com.newatlanta.servletexec.ServerHostInfo.processApplRequest(ServerHostInfo.java:937) at com.newatlanta.servletexec.ServletExec.ProcessRequest(ServletExec.java:1091) at com.newatlanta.servletexec.ServletExec.ProcessRequest(ServletExec.java:973) at com.newatlanta.servletexec.ServletExecService.processServletRequest(ServletExecService.java:167) at com.newatlanta.servletexec.ServletExecService.Run(ServletExecService.java:204) at com.newatlanta.servletexec.HttpServerRequest.run(HttpServerRequest.java:487) Caused by: java.lang.Exception: Status (500): Server Error ... 21 more

Following is my configuration from 11.5

Name Value

Catalog FoodMart 2000

ColumnNameAttribute sql:field

Connector OLAP

ConnectorType OLP

DataSourceInfo Provider=MSOLAP.2;Data Source=local

DataTypeAttribute type

DecimalDelimiter .

Description Default Microsoft OLAP Query Server

Enabled true

IP <IP/name>

InternalDateFormat yyyy-MM-dd HH:mm:ss

Name OLAP_Test1

Port 80

ResultInNamespace true

ServerPackage com.lighthammer.Illuminator.connectors.OLAP

UserName yu

WebService /xmla/msxisapi.dll

I have installed the XMLfor Analysis SDK on the Analysis server.I have followed all the steps as stated in http://msdn.microsoft.com/en-us/library/aa902642(SQL.80).aspx.

I am sure that MII is communicating with the server as deleting the Virtual Directory on the Analysis server OR deleting the Web Service extensions on the Analysis servers result in different HTTP errors (Not Found OR Authorization required).

I did try to search the forums and followed the advice from some previous posts (specially changing the DataSourceInfo parameter) but that has not helped so far.

Any pointers as to how else can one troubleshoot this? I have installed Analysis Manager on my machine and am able to connect to the Analysis server and browse the data.

Thanks

[Former Member]

Another message from the 11.5 Logs.

Whenever I modify the Data Server I find the following entry in the logs

Create Server name=OLAP_Test2,className=com.lighthammer.Illuminator.connectors.OLAP.OLAP,description=Default Microsoft OLAP Query Server,enabled=true,connected=false,holder=null

The "connected=false" , is that any indication if MII is unable to connect to the Analysis Services?

[Former Member]

Finally I seemed to have this working in both the environments.

The key was the DataSourceInfo parameter . This value in the configuration should specify the <DataSourceName> value from the DataSources.xml file. This file is part of the XMLA SDK installation.

I am going to keep this thread open as I have a very basic question. In the OLAP Query Template Editor --> OLAP Query details Tab there is a section called SAP Variables. Because I think I am querying MSOLAP this section shows No Data Available but simultaneously I also get a HTTP 500 Server error in the logs.

Is this something to worry about?

In any case what does the SAP Variables section signify?I couldn't find anything in the help files.

In 12.0 when i select the CUBE from the drop down , The measures & Dimensions sections are populated and I get a small error window pop-up with the 500 Server error. Still I am able to query the cubes but was wondering if this is a bug or I am missing something.