Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: Problem Using Drill Through table (Analysis View)

  1. #1
    Join Date
    May 2008
    Posts
    19

    Default Problem Using Drill Through table (Analysis View)

    Hi all!
    when i am trying to use Drill through table option then i will get following error

    An error occuredjava.sql.SQLException: [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near '.'.



    Please tell me the solution of this, i am not able to find this.

    Thanks in Advance
    yashdeep

  2. #2
    Join Date
    Mar 2008
    Posts
    12

    Default

    Hi,
    try to avoid using dot (.) in dimension, table, column etc. names in your cube definition. Mondrian parses dot (.) as database schema delimeter.
    I ran into similar problem and this was the solution.

    Lukasz

  3. #3
    Join Date
    May 2008
    Posts
    19

    Default Thanks

    hi

    thanks lukasz, it works for me but taking too much time and then generate error of java.lang.OutOfMemoryError: Java heap space

    java.lang.OutOfMemoryError: Java heap space


    now i am supposed to solve this problem.

    Once again thanks for your reply.


    Regards,
    yash

  4. #4
    Join Date
    May 2008
    Posts
    1

    Default

    Quote Originally Posted by yashdeep View Post
    hi

    thanks lukasz, it works for me but taking too much time and then generate error of java.lang.OutOfMemoryError: Java heap space

    java.lang.OutOfMemoryError: Java heap space


    now i am supposed to solve this problem.

    Once again thanks for your reply.


    Regards,
    yash
    hi,

    the heap space error just means that you JVM is getting to much data to handle. try to increase the initial memory and max memory for your tomcat. you can do this in the tomcat config window!

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.