Spectrum Report Manager/Business Objects no CLASSPATH WIS 01901

Situation:

 

Web Intelligence Rich Client not running reports (WIS 10901 Java Class not found in classpath : com.mysql.jdbc.Driver)

 

Resolution:

 

Search for the jdbc.sbo file in the Business Intelligence Server, open it with a text editor and search for a <CLASSPATH> tag, should be something like this (This one is for MySQL):

 

<DataBase Active="Yes" Name="MySQL 5">

            <JDBCDriver>

            <ClassPath>

                  <Path>D:\CA\SC\CommonReporting3\common/4.0/java/lib/external\mysql-connector-java.jar</Path>

</ClassPath>

 

Copy the mysql-connector*.jar from that path to a folder (C:\TEMP for example) in the PC where the WEBI Rich Client is and set the Environment variable CLASSPATH to folder\mysql-connector*.jar; (for example CLASSPATH= C:\Temp\mysql-connector-java.jar;)

 

Read More:

 

 

http://wiki.sdn.sap.com/wiki/display/BOBJ/Connectivity+configuration+between+BOE+and+Data+Federator