Error while executing a query

0	Hi, I've designed a schema using the workbench. When I execute a query in the workbench the result is good but when I try to execute this same query on saiku's server I have some errors (see picture). Thx, Alexis query error asked 22 Dec '11, 11:21 alexis 1●2●2●4 accept rate: 0%

10 Answers:

oldest newest most voted

1	i can't spot any error in there. could you stop your server, delete all logfiles, restart your server and then execute this query and send me the logfile again please! link answered 28 Dec '11, 09:25 pstoellberger ♦♦ 897●2●7 accept rate: 5%

1	there is an attribute "schema" in schema workbench when you define tables for your cubes / hierarchies make sure you put "dbo" in there link answered 21 Feb, 18:37 pstoellberger ♦♦ 897●2●7 accept rate: 5%

0	can you copy me the newest catalina logfile in saiku-server/tomcat/logs/ to pastebin.com please link answered 22 Dec '11, 15:13 pstoellberger ♦♦ 897●2●7 accept rate: 5%

0	here is the link asked for : http://pastebin.com/d7JWsrp8 link answered 23 Dec '11, 02:56 alexis 1●2●2●4 accept rate: 0%

http://pastebin.com/ms6FgaH8

The fact is that when I execute this query using mondrian's Schema workbench it works. Maybe something is missing in the configuration files ...

EDIT : Ok now I am using the 2.2 version and I have i clear message : SQLServerException: Invalid object name 'dbo.Calendar' but i can't see the mdx query. Any idea ?

link

answered 21 Feb, 04:36

alexis
1●2●2●4
accept rate: 0%

edited 21 Feb, 05:58

0	Yes that's what I've done. here is my xml file : http://pastebin.com/RD243pKf But I think it's more about a connection issue ? I can't understand why the same request works in schema workbench ... Thank you for all your answers ! link answered 22 Feb, 04:14 alexis 1●2●2●4 accept rate: 0%

0	yeh thats interesting if it works in PSW but not in saiku. can you try and remove the dbo property thing and see if it works? you might not need it, but i've never used SQLServer for saiku.. so i'm not sure link answered 23 Feb, 10:51 pstoellberger ♦♦ 897●2●7 accept rate: 5%

0	It doesn't work... Now I have the error : SQLServerException: Invalid object name 'Calendar'. (obviously) link answered 23 Feb, 11:49 alexis 1●2●2●4 accept rate: 0%

can you test this im schema workbench by replacing the mondrian.jar with the one we use in saiku? saiku-server/tomcat/webapps/saiku/WEB-INF/lib/

maybe it shows some better error description in there, as this is purely mondrian related

link

answered 28 Feb, 12:07

pstoellberger ♦♦
897●2●7
accept rate: 5%

0	Schema workbench doesn't work now with the saiku's jar! it's really weird ... link answered 01 Mar, 03:22 alexis 1●2●2●4 accept rate: 0%

Your answer

toggle preview

community wiki

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

learn more about Markdown

Tags:

query ×10
error ×7

Asked: 22 Dec '11, 11:21

Seen: 559 times

Last updated: 01 Mar, 03:22

Error while executing a query

Follow this question

Related questions