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


...
driver:mondrian.olap4j.MondrianOlap4jDriver
url:jdbc:mondrian:Jdbc=jdbc:postgresql://HereIsOurIPaddress:5432/CollectEarthDb;Catalog=HereIsOurPath/collectEarthCubes.xml;JdbcDrivers=org.postgresql.Driver;
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(MondrianResource.java:972)
        at mondrian.olap.Util.newInternal(Util.java:2403)
        at mondrian.olap.Util.newError(Util.java:2419)
        at mondrian.rolap.RolapConnection.<init>(RolapConnection.java:246)
        at mondrian.rolap.RolapSchema.<init>(RolapSchema.java:188)
        at mondrian.rolap.RolapSchema.<init>(RolapSchema.java:216)
...

asked 10 May, 09:01

jurafejfar's gravatar image

jurafejfar
112
accept rate: 0%


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

permanent link

answered 19 May, 08:57

collectearth's gravatar image

collectearth ♦
62515
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, 09:09

jurafejfar's gravatar image

jurafejfar
112
accept rate: 0%

edited 10 May, 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, 11:15

Open%20Foris's gravatar image

Open Foris ♦♦
2805612
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

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "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:

×28

question asked: 10 May, 09:01

question was seen: 303 times

last updated: 19 May, 08:57