SaikuReport error SQLServerException: Invalid object name 'dbo.XX'

ReportServer (EN)
1

I try to create Mondrian Datasource to review data in Saiku Report but prompted error in execution with SQLServerException: Invalid object name ‘dbo.GLPOST’.
Hope that anyone able to help.

Mondrian Datasource configure as below ;-
URL : jdbc:mondrian:Jdbc=jdbc:sqlserver://192.8.8.21:1433

Properties :
type=OLAP
name=192.8.8.21
driver=mondrian.olap4j.MondrianOlap4jDriver
jdbcDrivers=com.microsoft.sqlserver.jdbc.SQLServerDriver

Schema created from Jasper Workbench 4.0 as below:





















2

Hi coshin,

did you solve this problem?
If not, please try using jdbc:mondrian:Jdbc=jdbc:sqlserver://192.8.8.21:1433;jdbc.databaseName=yourDB as a connection URL. (note the jdbc prefix before your databaseName parameter)
If this doesn’t work, you can select the default database for the user your are connecting from in SQL Server → Security → Logins → your user. But the URL should work.
Please let me know if this works.

Cheers,
Eduardo

3

Hello,

I am experimenting exactly the same problem, I tried with the URL extension but it didnt worked. Affortunatly it worked with the second solution.

thanks.

4

Hi mahdsip,
did you write “jdbc.databaseName=yourDB” or “databaseName=yourDB” ?
Could you please post the URL that is not working?

The URL works in my test case.

Cheers,
Eduardo

5

For completeness:

The correct URL should be:
jdbc:mondrian:Jdbc=jdbc:sqlserver://127.0.0.1;jdbc.databaseName=TEST_DW

Cheers,
Eduardo