Latest installer of Collect Earth (1.6.33 from download page) for Win is missing PostgreSQL JDBC driver. This causes Saiku error:

12:12:00,143 WARN  [RolapUtil] Mondrian: Warning: JDBC driver org.postgresql.Driver not found
12:12:00,143 WARN  [RolapUtil] Mondrian: Warning: JDBC driver sun.jdbc.odbc.JdbcOdbcDriver not found
12:12:00,174 WARN  [RolapUtil] Mondrian: Warning: JDBC driver oracle.jdbc.OracleDriver not found
mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while creating SQL connection: Jdbc=jdbc:postgresql://HereIsOurIPaddress:5432/CollectEarthDb; JdbcUser=HereIsOurUser; JdbcPassword=HereIsOurPass
        at mondrian.resource.MondrianResource$_Def0.ex(
        at mondrian.olap.Util.newInternal(
        at mondrian.olap.Util.newError(
        at mondrian.rolap.RolapConnection.<init>(
        at mondrian.rolap.RolapSchema.<init>(
        at mondrian.rolap.RolapSchema.<init>(

asked 10 May '18, 09:01

jurafejfar's gravatar image

accept rate: 0%

The newest version of Collect Earth (1.6.34) fixes the issue. Thanks for reporting it.

permanent link

answered 19 May '18, 08:57

collectearth's gravatar image

collectearth ♦
accept rate: 16%

According to similar problem reported here, put postgresql-42.2.2.jar into tomcat/lib directory (e.g. C:\OpenForis\CollectEarth\saiku-server_2.6\tomcat\lib on Win or /home/vagrant/OpenForis/CollectEarth/saiku-server_2.6/tomcat/lib on Linux).

permanent link

answered 10 May '18, 09:09

jurafejfar's gravatar image

accept rate: 0%

edited 10 May '18, 13:08

Thank you for reporting the issue and even providing a fix yourself!!

We will add this library to the Saiku distributed within Collect Earth. There was already a PostgreSQL driver in it but it seems not to be compatible with the newest Postgres 10

permanent link

answered 11 May '18, 11:15

Open%20Foris's gravatar image

Open Foris ♦♦
accept rate: 7%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text]( "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:


question asked: 10 May '18, 09:01

question was seen: 789 times

last updated: 19 May '18, 08:57