Hitachi Vantara Pentaho Community Forums
Results 1 to 7 of 7

Thread: Mondrian with Sybase error

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Join Date
    Mar 2017
    Posts
    8

    Default Mondrian with Sybase error

    Hi,

    I am getting a similar error as in the following post http://jira.pentaho.com/browse/MONDRIAN-1510 on Mondrian+Sybase, which is caused by a missing alias at the generated SQL query.

    In the link I read that this is fixed, but I have tried with the following mondrian jars and I am still getting the error:
    3.6.6
    4.3.0.1
    4.6.0.0

    So where can I get the fixed version ?

    Thank you!

    Edit: I think it is the same issue:
    My schema:


    <?xml version="1.0"?>
    <Schema name="GenericDynaListSchema">
    <Cube name="GenericDynaListCube">
    <View alias="GenericDynaListCube">
    <SQL dialect="generic">
    <=!=[=C=D=A=T=A=[SELECT * FROM (select * from job_consumption_data where fiscal_year >= 2010) wrappedQry]=]=>
    </SQL>
    </View>
    <Dimension name="part_number">
    <Hierarchy hasAll="true">
    <Level name="part_number" visible="true" column="part_number" type="String" uniqueMembers="false" />
    </Hierarchy>
    </Dimension><Measure name="qty_produced" column="qty_produced" aggregator="sum" formatString="Standard"/></Cube>
    </Schema>

    It is a very simple table with fields: id, part_number, qty_produced. Nothing more.

    Query if putting "qty_produced" in the measures, and "part_number" in the rows:

    select {[Measures].[qty_produced]}
    ON COLUMNS,
    {Hierarchize(
    {[part_number].[part_number].Members}
    )} ON ROWS
    from [GenericDynaListCube]

    SQL generated (and giving the error):
    Mondrian Error:Internal error: Reading row count from query [select distinct "GenericDynaListCube"."part_number" as "c0" from (SELECT * FROM (select * from job_consumption_data where fiscal_year >= 2010) wrappedQry) as "GenericDynaListCube"]; sql=[select count(*) from (select distinct "GenericDynaListCube"."part_number" as "c0" from (SELECT * FROM (select * from job_consumption_data where fiscal_year >= 2010) wrappedQry) as "GenericDynaListCube")]

    Error: SybSQLException: SQL Anywhere Error -131: Syntax error near '(end of line)' on line 1

    If you change
    select count(*) from (select distinct "GenericDynaListCube"."part_number" as "c0" from (SELECT * FROM (select * from job_consumption_data where fiscal_year >= 2010) wrappedQry) as "GenericDynaListCube")
    to
    select count(*) from (select distinct "GenericDynaListCube"."part_number" as "c0" from (SELECT * FROM (select * from job_consumption_data where fiscal_year >= 2010) wrappedQry) as "GenericDynaListCube") AS DUMMY

    then the query works. I guess this is the same issue in the link?
    Last edited by edulid1; 03-19-2017 at 06:08 AM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.