cancel
Showing results for 
Search instead for 
Did you mean: 

Problems connecting MSOLAP with Analisys Service in XMII?

Former Member
0 Kudos

Values Data server MSOLAP in XMII <b>version 11.5</b>

Name Value

Catalog BANCO_OLAP

ColumnNameAttribute sql:field

Connector OLAP

ConnectorType OLP

DataSourceInfo Provider=SQLNCLI.1;Data Source=danilosantos;Persist Security Info=True;Password=;User ID=sa

DataTypeAttribute type

DecimalDelimiter .

Description Default Microsoft OLAP Query Server

Enabled true

IP 10.15.85.52

InternalDateFormat yyyy-MM-dd HH:mm:ss

Name BANCO_OLAP

Port 80

ResultInNamespace true

ServerPackage com.lighthammer.Illuminator.connectors.OLAP

UserName NEORIS\danilo.santos

WebService /xmla/msxisapi.dll

Accepted Solutions (0)

Answers (1)

Answers (1)

0 Kudos

Danilo,

What is the error message in the General Log? What are you trying to do? In the future please post this along with your config. Thanks.

Sam

Former Member
0 Kudos

Hi Salvatore,

<b>My connection data source MSOLAP in new test.</b>

Name Value

Catalog BancoOEE

ColumnNameAttribute sql:field

Connector OLAP

ConnectorType OLP

DataSourceInfo Provider=MSOLAP;Data Source=danilosantos

DataTypeAttribute type

DecimalDelimiter .

Description Default OLAP Query Server

Enabled true

IP localhost

InternalDateFormat yyyy-MM-dd HH:mm:ss

Name BancoOEE

Port 80

ResultInNamespace false

ServerPackage com.lighthammer.Illuminator.connectors.OLAP

UserName sa

WebService /xmla/msxisapi.dll

Here's my general log.

13:00:13,255 SYSTEM Connector Create Server [name=KlabinOEE2,className=com.lighthammer.Illuminator.connectors.OLAP.OLAP,description=Default OLAP Query Server,enabled=true,connected=false,holder=null]

help xMII parameters.

http://localhost/LighthammerCMS/Help/Connectors/OLAPConnector.htm

Attempting to run a query template does not appear any cube. And indicates that the server is not connected in log error.

Error occurred while processing data stream, Connection refused: connect com.lighthammer.Illuminator.logging.LHException: Error occurred while processing data stream, Connection refused: connect at java.net.PlainSocketImpl.socketConnect(Native Method) at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:305) at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:171) at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:158) at java.net.Socket.connect(Socket.java:452) at java.net.Socket.connect(Socket.java:402) at java.net.Socket.<init>(Socket.java:309) at java.net.Socket.<init>(Socket.java:124) at

Softwares in use SQL Server 2005 and Analysis Services

Thanks

Danilo

0 Kudos

Pedro,

The "connection refused" error message you are receiving can be attributed to a couple of things:

1) Firewall on either the switch or MSOLAP server

2) MSOLAP is not setup to receieve network requests, or is and is expecting the request on a different port.

3) The local machine's host file was modified incorrectly

The first test I suggest is attempting the following from the xMII machine's command prompt:

telnet localhost 80

This will indicate if the local port can even be reached via the network (Most companies block port 80 traffic as a standard network security protocol). I would verify the port number is correct and that MSOLAP is listening.

Hope this helps.

Sam

Former Member
0 Kudos

Hi Salvatore,

Thanks for the attention I will do some tests.

My name is Danilo

0 Kudos

Danilo,

My apologies, I feel foolish...I was just answering someone else on another thread an I guess I was still thinking about it. Sorry about that.

Sam

Former Member
0 Kudos

No problem I have a friend named Pedro Sena working me he commented you.

In test the port 80 for telnet - connection refused with my server

thanks the sugestion