Monitoring Trend Univ conn failed SAP BI4.1

[Former Member]

What should be the below parameters in the Monitoring Trend Universe connection?

JDBC URL and JDBC Class

I'm get the below error while parsing the connection:

CS: Java Class not found in classpath : org.apache.derby.jdbc.EmbeddedDriver

My current parameters:

JDBC URL: jdbc:derby:D:\DBBkp\Derby;create=false

JDBC Class: org.apache.derby.jdbc.EmbeddedDriver

The Trending DB is installed in the below location: (Default)

D:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\Data\TrendingDB

Thanks!

[Former Member · Accepted solution]

Check the note 1910486 - Error: "Database error (CS) java class not found in classpath:Org.apache.derby.jdbc.Embedd...

[Former Member · Accepted solution]

Hi Arvind,

The link you have provided does not open for me. May be its internal for SAP.

it directs me to the below url: https://css.wdf.sap.corp/sap/support/notes/1910486

do you have any notes from the above link?

Thanks!

[Former Member · Accepted solution]

It has been released to customer

Check the steps below:

• Install Apache Derby on Windows Server Machine, go to URL: http://db.apache.org/derby/releases/ and place derby.jar file in C:/derby.jar

• Navigate to the location: C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\dataAccess\connectionServer\jdbc.

• Edit derby.sbo file and add the ClassPath for derby.jar
  <DataBase Active="Yes" Name="Derby 10 Embedded">
  <JDBCDriver>
  <ClassPath> <Path>C:\derby.jar</Path>
  </ClassPath>

• Create the derby database backup: Login to CMC >> Applications >> Monitoring Application >> Trending database backup directory: C:\BackupDerby. (Specify appropriate location)

• Click Save and Close.

• Restart Adaptive Processing Server. When APS is up and running Go back to Applications >> Monitoring Application >> Run database backup task: Now.

• Login to Universe design tool >> File >> import >> select Monitoring TrendData Universes.

• Go to File >> Parameters >> Edit >> Database middleware selection: Apache >> Derby 10 Embedded >> JDBC Drivers.

• Click on Next.

• In Login parameters specify Server(host:port): C:\BackupDerby\Derby;create=false

• Click on Next >> Finish >> Test the connection. (Here we are pointing to backup database).

• Now Export the Monitoring TrendData Universes.

• Exit from Universe Design Tool.

[Former Member · Accepted solution]

Hi Arvind, Thanks for the response. I was able to follow the inst* and get the connection active.