I'm on a W2003 box with WF 7.6.11, IIS 6, Apache Tomcat 6.0.26, Java 1.6.0.17 and PostgreSQL 8.4. Reporting server and WF and DM can access the PostgreSQL db without any problems, but RC seems to think that the Distribution Server is not started, even though it is. The testcfg.bat says it's correctly setup. The reader trace looks good but in the srvtrace file I get the following message:
Wed Apr 28 18:44:04 CEST 2010: Begin to Add DataServer EDASERVE to DataServer Manager Wed Apr 28 18:44:04 CEST 2010: Added DataServer to DataServer Manager successfully. Wed Apr 28 18:44:04 CEST 2010: Begin to locate, load and link the class org.postgresql.Driver Wed Apr 28 18:44:04 CEST 2010: Initialization Status: -1 Wed Apr 28 18:44:04 CEST 2010: Unable to establish connection to ReportCaster repository. Contact your ReportCaster Administrator. WebFocus Server EDASERVE Initialization Error (java.lang.ClassNotFoundException: org.postgresql.Driver)
The path on the box is like this: C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Program\Java\jdk1.6.0_17\bin;C:\Program\Java\jdk1.6.0_17\jre\bin;C:\Program\Java\jdk1.6.0_17\jre\bin\server;C:\Program\psqlJDBC
Any idea where to look?
Tia HåkanThis message has been edited. Last edited by: Håkan,
First, look here, /WebFOCUS/ibi/reportcaster762/bin, for the classpath file and make sure that it is correct. Then from that same directory, run the testcfg script and make sure that comes out ok.
If none of that helps, check the profile of the admin id that starts the distribution server to make sure that its path is pointing to the right stuff.
Everything looked right but the problem turned out to be a missing reference to the PostgreSQL JDBC driver in catalina.properties. Added that to the common.loader string and now it works.