ReportServer Forum

coshin

Member

Registered: 2016-12-02

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

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:
<Schema name="PackingList">
  <Cube name="GLS" cache="true" enabled="true">
    <Table name="GLPOST" schema="dbo" alias="GL">
    </Table>
    <Dimension type="StandardDimension" foreignKey="ACCTID" name="accounts">
      <Hierarchy name="Default" hasAll="true" primaryKey="ACCTID">
        <Table name="GLPOST" schema="dbo">
        </Table>
        <Level name="Account" table="GLPOST" column="ACCTID" uniqueMembers="false">
        </Level>
        <Level name="Year" table="GLPOST" column="FISCALYR" uniqueMembers="false">
        </Level>
        <Level name="Period" table="GLPOST" column="FISCALPERD" uniqueMembers="false">
        </Level>
      </Hierarchy>
    </Dimension>
    <Measure name="amount total" column="TRANSAMT" datatype="Numeric" aggregator="sum" visible="true">
    </Measure>
    <Measure name="account number" column="ACCTID" datatype="Numeric" aggregator="count" visible="true">
    </Measure>
  </Cube>
</Schema>

IF_Eduardo

Administrator

Registered: 2016-11-01

Website

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

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

mahdsip

Member

Registered: 2016-10-11

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

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.

IF_Eduardo

Administrator

Registered: 2016-11-01

Website

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

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

IF_Eduardo

Administrator

Registered: 2016-11-01

Website

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

For completeness:

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

Cheers,
Eduardo