ISSUE :
 
Profile photo
Submitted by Sara Kha
on May 21st, 2014 at 21:48:17 EST

Pentaho_ce_5.0_Saiku_Analytics_display_Nothing !!

Hi,

I created my cube in PSW and I have published it into Pentaho ce 5.0 successfully. The MDX queries work fine in PSW !

Now , I create a new analysis using Saiku Analytics. But when I used drill through on cell, it always returned empty result without any error message !!!

How can I fix it !?


Profile photo
Replied by Yogaraj Khanal
on May 21st, 2014 at 23:32:28 EST

Profile photo
Replied by Sara Kha
on May 22nd, 2014 at 06:45:56 EST
First of all .. thank you for your quick response.

i've created the connection with my database and when I test it, the connection test is ok.

I test the MDX query in postgreSql and it works fine ... but in Saiku , it returns empty result.

https://scontent-a-mad.xx.fbcdn.net/hphotos-prn1/t1.0-9/10330452_273674162811839_9200273505653656022_n.jpg

And what is strange is that the data is retrieved when I click on the row ... But nothing is displayed as a result !!

https://scontent-b-fra.xx.fbcdn.net/hphotos-ash4/t1.0-9/10177997_273989932780262_7061578182914412815_n.jpg

I see in the comment that someone, who has the same problem, said that is was a JDK's version (1.7) issue ! .. I think that he was using an older version of Pentaho
But me .. I'm using Pentaho ce 5.0 and I am using JDK 1.7. too..

Do you think that the JDK's version is the cause of the problem !!!??
So which version should I install ( Recent or Older one ) !?

***************************** ## *****************************

And in the "Pentaho log" ( in Pentaho_5.0\biserver-ce\tomcat\logs ) , I have those Error which are repeated :

2014-05-22 11:23:10,873 ERROR [org.pentaho.platform.web.servlet.GenericServlet] GenericServlet.ERROR_0004 - Resource /default-plugin/resources/messages/messages_fr.properties not found in plugin BI Server default plugin

2014-05-22 11:23:15,007 ERROR [org.pentaho.platform.web.servlet.GenericServlet] GenericServlet.ERROR_0004 - Resource /pentaho-cdf-dd/lang/messages_fr.properties not found in plugin pentaho-cdf-dd

2014-05-22 11:25:49,719 ERROR [hive.ql.exec.HiveHistory] Unable to create log directory /tmp/Sara
Edited on May 22nd, 2014 at 07:19:49 EST

Profile photo
Replied by Yogaraj Khanal
on June 4th, 2014 at 21:40:25 EST
Sorry for responding late..too busy with jee project these days.. Were you able to solve your issue?
I can't access your link anymore.
I tried these using jdk 1.5 and bi server 3.10 using ctools installer.


The error you are getting says sth is not installed or configured right.
You should be able to see if those file exist and if you have permission and stuff.

I tried my sample on Oracle & MySQL.Hope you have installed postgreSQL jdbc jar and stuff in corresponding places.

Test your code in those version. If not I can try getting latest bi server release and try it out.I am also using postgreSQL in my development these days.
Edited on June 4th, 2014 at 21:42:14 EST

Profile photo
Replied by Yogaraj Khanal
on June 4th, 2014 at 21:46:08 EST
Also I think each database has way of defining their data format pleas refer docs her