Architecting, installing and maintaining your SAS environment

Connection to cube

Reply
Occasional Contributor
Posts: 9

Connection to cube

Hi,

 

When I try to connect to the OLAP server in SAS EG, I'm getting this error:

ERROR: The Bridge Protocol Engine Socket Access Method was unable to connect to host abc.net, port 5451.
ERROR: The TCP/IP tcpSockConnect() support routine failed with error 110 (The connection has timed out.)

 

What is the problem?

(This question is not related to programming but here is the code:

 

proc sql;
         connect to olap (host="abc.net" port=5451
                          user="***" password="***");
         
         disconnect from olap;
       quit;

)

 

Thanks.

Super User
Posts: 7,760

Re: Connection to cube

Check if the OLAP server is up on host abc.net.

On UNIX, I'd issue

ps -ef|grep OLAP

from the commandline as the simplest method. But you can of course use the SAS Management Console to test the server. (expand Server Manager Plug-In, expand SASApp, right-click SASApp - Logical OLAP server, select "Verify")

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
SAS Super FREQ
Posts: 299

Re: Connection to cube

Hi,

 

is this the complete error message or is there more? Is there anything in the OLAP Server log?

See: config dir\Lev1\SASApp\OLAPServer\Logs.
 
Have you tried restarting the OLAP Server?
 
Did this ever work before?
 
Thanks
Anja
Occasional Contributor
Posts: 9

Re: Connection to cube

I don't have access to logs on server.

But one question that in order to connect to OLAP cubes from SAS should 'SAS/ACCESS interface to OLE DB' be installed on server?

 

Ask a Question
Discussion stats
  • 3 replies
  • 149 views
  • 0 likes
  • 3 in conversation