Focal Point
Error: No tables found

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/7881073941

January 17, 2006, 06:19 PM
Alanocturna
Error: No tables found
Hi,

Can anyone help me??... I'm trying to connect to MS OLAP, when I make a Syn locally it's ok but when I add a new connection to another MS OLAP that it is in another machine sends Error: No tables found

Thank you!!!!
January 17, 2006, 07:43 PM
Ricardo
WebFOCUS version ?
MSOLAP with SP3 ?
Did u add WebFOCUS user into OLAP GROUP in DB server ?


Web Focus Developer

WF 5.xLinux/,winxp,win2003
WF 7.x Linux,winxp,win2008
WF 8.x , win
January 19, 2006, 12:14 PM
Alanocturna
WebFocus 7.1 The patch SP3 was installed, but I wasn't into OLAP Group....... OK, I was added in the group but it doesn't work.

Error: No Tables Found

What do u think that's happend???

Thanks!!!!
January 19, 2006, 01:39 PM
Ricardo
After created that MSOLAP adapter, did you run some test report?


Web Focus Developer

WF 5.xLinux/,winxp,win2003
WF 7.x Linux,winxp,win2008
WF 8.x , win
January 19, 2006, 07:07 PM
Alanocturna
I CAN'T RUN ANYONE BECAUSE I DON'T MAKE THE SYNONIM.... I SEE THE CUBES FROM MS OLAP ANALYSIS SERVICES BUT WEBFOCUS CAN'T MAKE IT..... I HAVE WEBFOCUS IN WEB WITH SECURITY OFF
January 24, 2006, 08:06 AM
Ricardo
Hi,

For solved this problem.. Connect in the server console WebFOCUS
http://: ex: http://localhost:8121

Listener / HTTP

- uncheck the option IWA.

Restart the WebFOCUS Server...


Web Focus Developer

WF 5.xLinux/,winxp,win2003
WF 7.x Linux,winxp,win2008
WF 8.x , win
January 26, 2006, 11:05 PM
Alanocturna
This is the config file in Listeners / HTTP and I changed SECURITY = IWA to SECURITY = IWA; and finally ... Restart the WebFOCUS Server ....

T was trying to change localhos to bio (name servet to i like to connect) and it doesn't make the synonym...

Do u have another idea?? ... Thanks a lot



;-- config file generated on 01/26/2006 17:04:39


;HTTP Listener
NODE = LST_HTTP
BEGIN
PROTOCOL = HTTP
PORT = 8121
CLASS = AGENT
; SECURITY = IWA
END

;TCP Listener
NODE = LST_TCP
BEGIN
PROTOCOL = TCP
PORT = 8120
CLASS = AGENT
END

;TCP Loopback Client
NODE = LOOPBACK
BEGIN
PROTOCOL = TCP
CLASS = CLIENT
HOST = localhost
HTTP_PORT = 8121
PORT = 8120
; SECURITY = IWA
END

;FOCUS Database Server
NODE = FOCSU
BEGIN
PROTOCOL = TCP
CLASS = SUSERVER
PORT = 8122
END

;FOCUS Database Client
NODE = FOCSU01
BEGIN
PROTOCOL = TCP
CLASS = SUCLIENT
HOST = localhost
PORT = 8122
END

;JSCOM3 Listener
NODE = JSS
BEGIN
PROTOCOL = TCP
CLASS = JAVASERVER
PORT = 8123
END