Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

I Can't have access to some functionality of Saiku (saved query and Properties on Chart Mode) #708

Open
neolinkbb opened this issue Sep 26, 2019 · 5 comments
Open

I Can't have access to some functionality of Saiku (saved query and Properties on Chart Mode) #708

neolinkbb opened this issue Sep 26, 2019 · 5 comments
Assignees
@brunogamacatao

Comments

@neolinkbb
Copy link

Is this a bug report?

YES

Environment

  1. java -version:
    java version "1.8.0_211"
    Java(TM) SE Runtime Environment (build 1.8.0_211-b12)
    Java HotSpot(TM) 64-Bit Server VM (build 25.211-b12, mixed mode)

  2. Operating system: CentOS (server where Saiku was installed), Windows 10 family (my computer)

  3. Browser and version (if relevant) : Firefox 69.0.1 (64 bits)

  4. Saiku plugin to Pentaho or Saiku Standalone : Saiku Standalone

  5. Saiku CE or Saiku EE : Saiku EE

  6. Saiku version: Saiku Suite V2.1 GA

Problem

We had a problem during this summer : my team restart Saiku and Kylin. We lost all our cube. So i had to create again the cube.
On Saiku, one of our data source was delete (I don’t know how and why). I create again a new data source copying the other one (who was not deleted). It didn't work because i used the same name as the last one. So i had to change the name of the data source. It works and i had access to all my cube.
This is the data source configuration :

image

The losted data source name was « job » and the new one name is « job1 ».
The problem we have now is that all the query save is not accessible anymore. The only solution i had was to create again all the query. Do you know if there is an other solution or something to do in case we have the same problem ?
image
The message we have when we tried to execute our saved query :

image

We tried to find where was save the data source but we didn’t find anything. Do you know were it’s save ? Can we recover the first data source "job" ? I think it’s the cause of our problem.

Another thing is that we don’t have access to the Properties menu on the Chart Mode. When I press on Properties nothing happen. How can i solve this ? Do i have to change something on Saiku configuration ?

image

Thanks for your help.
@brunogamacatao brunogamacatao self-assigned this Sep 29, 2019
@brunogamacatao
Copy link
Contributor

I am trying to reproduce this issue on the image you've sent me.
If you could please send me your Saiku logs, it would really help me to fix this problem earlier.
Thank you so much.

@neolinkbb
Copy link
Author

neolinkbb commented Sep 30, 2019 via email

@neolinkbb
Copy link
Author

neolinkbb commented Sep 30, 2019 via email

@brunogamacatao
Copy link
Contributor

Dear Blandine,

Can you please check if the cube '[job].[Cubes Job].[Cubes Job].[internaute]' exists in your schema definition?
This error is being thrown by a class named OlapMetaExplorer, method getNativeCube. It is trying to find the before mentioned cube on your OLAP connection. Depending on your DBMS it may be case sensitive, so, if your table is named Internaute instead of internaute it may have a problem to find it.
Feel free to send me your schema definition file, so I can check it for any problem.

Thanks a lot,
Bruno

@neolinkbb
Copy link
Author

neolinkbb commented Oct 7, 2019 via email

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@brunogamacatao brunogamacatao

Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@brunogamacatao @neolinkbb