Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: build test fails

  1. #1
    Join Date
    Jul 2001
    Posts
    6

    Default build test fails

    When I try 'build test', it fails:
    C:\java\mondrian-0.2>build test
    C:\java\mondrian-0.2>set CLASSPATH=C:\java\mondrian-0.2\/classes;C:\java\mondria
    n-0.2\/lib/javacup.jar;C:/java/jakarta-tomcat-4.0.4/common/lib/xerces.jar;C:\jav
    a\mondrian-0.2\/lib/boot.jar;C:/oracle/ora81/jdbc/lib/classes12.zip
    Buildfile: build.xml
    test:
    [java] Error in test 'non empty 1(mondrian.test.Main$2)': mondrian.resource
    .Error: Internal error: while counting members of level '[Customers].[Country]';
    sql=[select count(*) from (select distinct "country" as "c0" from (SELECT *, "f
    name" + ' ' + "lname" as "name" FROM "customer") "Customers")]
    [java] ORA-00923: FROM keyword not found where expected
    [java]
    [java] Error in test 'non empty 2(mondrian.test.Main$3)': mondrian.resource
    .Error: Internal error: while counting members of level '[Customers].[Country]';
    sql=[select count(*) from (select distinct "country" as "c0" from (SELECT *, "f
    name" + ' ' + "lname" as "name" FROM "customer") "Customers")]
    [java] ORA-00923: FROM keyword not found where expected
    [java]
    ....
    I'm using Oracle as the database.
    Any ideas?
    Thanks,
    Chris

  2. #2
    Join Date
    Nov 1999
    Posts
    1,618

    Default RE: build test fails

    Which version of Oracle are you using? Select-in-the-from-clause is a relatively recent Oracle feature.

  3. #3
    Join Date
    Jul 2001
    Posts
    6

    Default RE: build test fails

    It's 8.1.7
    I shall try MySQL instead!
    Thanks,
    Chris

  4. #4
    Join Date
    Nov 1999
    Posts
    1,618

    Default RE: Oracle syntax error

    The problem was the concatenation syntax. Oracle uses '+' rather than '||'. With release 0.3, the only fix was to edit foodmart.xml. As of change 111 (available as mondrian-0.3.111-src.zip), you can foodmart.xml contains multiple queries, one per database dialect, and automatically uses the right one.

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.