Now I start up Mondrian and get an error ORA-00942: Table or view “sales” does not exist while executing the SQL statement SELECT “prodid”, count(*) FROM “sales” GROUP BY “prodid”. The query looks valid, and the table exists, so why is Oracle giving an error?
The problem is that table and column names are case-sensitive. You told Mondrian to look for a table called “sales”, not “SALES” or “Sales”. Oracle’s table and column names are case-sensitive too, provided that you enclose them in double-quotes, like this: CREATE TABLE “sales” ( “prodid” INTEGER, “day” INTEGER, “amount” NUMBER); If you omit the double-quotes, Oracle automatically converts the identifiers to upper-case, so the first CREATE TABLE command actually created a table called “SALES”. When the query gets run, Mondrian is looking for a table called “sales” (because that’s what you called it in your schema.xml), yet Oracle only has a table called “SALES”. There are two possible solutions. The simplest is to change the objects to upper-case in your schema.xml file: …
Related Questions
- I have tried to customize error message responses with the webserver yet I am unable to view the customized error response page. What could be wrong?
- When I click the padlock icon to view the certificate when connected to a secure site, I receive an error message. Am I in a secure session?
- Why are visitors receiving a "403 Forbidden" error page when they try to view the contents of a directory?
