[Mondrian] Error running tests against foodmart db

[Chacko, Rachel (Truven Health)]

Thanks Kurtis! That server does not exist anymore and I don’t think the OracleFoodMart is setup anywhere else.

From: mondrian-bounces at pentaho.org [mailto:mondrian-bounces at pentaho.org] On Behalf Of Kurtis Walker
Sent: Wednesday, July 31, 2013 10:10 AM
To: Mondrian developer mailing list
Subject: Re: [Mondrian] Error running tests against foodmart db


There used to be an Oracle database on the development database server called OracleFoodMart. I belive there were was a mondrian.properties file checked in called mondrian.properties.oracle. That should have the correct setup assuming that database is still around.



Kurt
On Wednesday, July 31, 2013 09:06:48 AM Chacko, Rachel wrote:

I’m using the derby database.



From: mondrian-bounces at pentaho.org<mailto:mondrian-bounces at pentaho.org> [mailto:mondrian-bounces at pentaho.org] On Behalf Of Luc Boudreau
Sent: Wednesday, July 31, 2013 9:58 AM
To: Mondrian developer mailing list
Subject: Re: [Mondrian] Error running tests against foodmart db





On Wed, Jul 31, 2013 at 9:54 AM, Chacko, Rachel (Truven Health) <rachel.chacko at truvenhealth.com<mailto:rachel.chacko at truvenhealth.com>> wrote:

Caused by: java.sql.SQLException: Table/View 'time_by_day' does not exist.

This is probably why it is not working. What's the backend DB? Does it require tables to be prefixed by their schema name?


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