Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only. Moving forward, myibi is our community platform to learn, share, and collaborate. We have the same Focal Point forum categories in myibi, so you can continue to have all new conversations there. If you need access to myibi, contact us at myibi@ibi.com and provide your corporate email address, company, and name.


Connect to myibi
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Connecting to the distribution server - fail

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[SOLVED] Connecting to the distribution server - fail
 Login/Join
 
Member
posted
Just installed WebFOCUS Reporting Server 76 on Windows XP with Mysql 5.1. When I run the test I get: Connecting to the distribution server - fail. Everything work except Report Caster.

I think the problem has to do with the JDBC driver not added correctly.

Could somebody advice me on how to solve this issue. Best regards, Stellan

This message has been edited. Last edited by: Kerry,
 
Posts: 4 | Registered: August 21, 2009Report This Post
Virtuoso
posted Hide Post
Invariably, whenever I install the products on a clean machine, there is one thing the install process does not do. And that is to add the path to the java jre or sdk. I always have to put in 'C:\Program Files\Java\jdk1.6.0_03\jre\bin\server;' (or equivalent) and then reboot the system to make the connection to the distribuition server work.


GamP

- Using AS 8.2.01 on Windows 10 - IE11.
in Focus since 1988
 
Posts: 1961 | Location: Netherlands | Registered: September 25, 2007Report This Post
Member
posted Hide Post
Thanks. But could you please elaborate with me more.

In what places do you need to set the java classpath?

This is what I get when trying to start the distribution server.

ReportCaster cannot communicate with the ReportCaster Repository. Check that the Application Server is properly configured with the correct JDBC driver.

- The file in C:\ibi\ReportCaster76\bin\classpath?

I also dont understand where to put the JDBC driver? I downloaded mysql-connector-java-5.1.8-bin.jar and placed the file in C:\ibi\ReportCaster76\bin.

This is how the classpath file in C:\ibi\ReportCaster76\bin

set CMD_LINE_ARGS=
rem set CMD_LINE_ARGS=MASTER -f
rem set CMD_LINE_ARGS=FAILOVER
set DSINSTALL=C:\ibi\ReportCaster76
set DSINSTALL_PROD=C:\ibi\ReportCaster76
set DSHOST=infobuild
set DSPORT=8200
set CLASSPATH=C:\Program\Java\jr6\bin\mysql-connector-java-5.1.8-bin.jar

BR, Stellan
 
Posts: 4 | Registered: August 21, 2009Report This Post
Virtuoso
posted Hide Post
The path to the jre or sdk java stuff should be set in the system variables of your computer.
The path to the jdbc for mysql should be set in the report caster environment, you should have given the path to the driver when installing the report caster. If you did not, you can add it later using the edit option for report caster from the start menu, or the editit.bat in the report caster bin directory.


GamP

- Using AS 8.2.01 on Windows 10 - IE11.
in Focus since 1988
 
Posts: 1961 | Location: Netherlands | Registered: September 25, 2007Report This Post
Guru
posted Hide Post
Sounds like you need to look through the Install manual. Especially Chapter 8 - ReportCaster Post-Installation Tasks and Appendix C - additional ReportCaster Repository Topics and Tasks

If you are running ReportCaster as a Service then you will also need to use regedit to change/correct the classpath in the registry. Also if you had Tomcat preinstalled or didn't supply the installer with the correct path to the JDBC driver then you will have to add the JDBC driver to Tomcat's classpath too.

All of this is covered in the Install Manual.

Cheers

Stu


WebFOCUS 8.2.03 (8.2.06 in testing)
 
Posts: 253 | Location: Melbourne, Australia | Registered: February 07, 2007Report This Post
Platinum Member
posted Hide Post
There are a lot of documents on techsupport.ibi.com that talk about how to change/check the JDBC jars fro ReportCaster.

While the following document specifically references SQL Server, the locations for setting the classpath are the same. As a result as long as you are entering/verifying the MySQL information, it should work for you:

http://techsupport.information...om/sps/51242524.html


WF 71.x, 76.x, 7701, 8.0 Beta OS: Linux, Win2k3, Win2k, Win2k8, WinXP


 
Posts: 203 | Registered: November 19, 2007Report This Post
Member
posted Hide Post
[SOLVED] Thanks everybody! The problem is solved.
 
Posts: 4 | Registered: August 21, 2009Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Connecting to the distribution server - fail

Copyright © 1996-2020 Information Builders