on 11-06-2007 1:06 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
User | Count |
---|---|
12 | |
6 | |
3 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.