PDA

View Full Version : Problem Using Drill Through table (Analysis View)



yashdeep
06-19-2008, 08:59 AM
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

lukasz_ex
06-20-2008, 08:33 AM
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

yashdeep
06-23-2008, 06:59 AM
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

nebu
08-11-2008, 07:20 AM
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!