[Mondrian] Error running tests against foodmart db

Julian Hyde jhyde at pentaho.com
Wed Jul 31 15:51:35 EDT 2013


On Jul 31, 2013, at 12:40 PM, "Chacko, Rachel (Truven Health)" <rachel.chacko at truvenhealth.com<mailto:rachel.chacko at truvenhealth.com>> wrote:

Thanks for the reply! I can connect to the db using Squirrel(SQL tool) and I do see the table ‘time_by_day’, but when I try ‘select * from time_by_day’ I get

Error: Table/View 'TIME_BY_DAY' does not exist.
SQLState:  42X05
ErrorCode: 30000

Still not sure if it is a permissions issue.

It's case-sensitivity. Try

select * from "time_by_day";

Julian

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20130731/f6d5a625/attachment.html 


More information about the Mondrian mailing list