August 25, 2010

BI Publisher – error creating Quartz tables

Filed under: BI publisher, quartz — rmoff @ 10:00

A very short blog post to break the drought, but I didn’t hit any google results for this error so thought it might be useful to record it.

In BI Publisher, trying to install the Scheduler (Quartz) schema, I got this error:

Schema installation failed while creating tables. Schema may already exist. Please remove the existing schema or choose another database and try again.

To me, the error text is a bit unhelpful. Whilst the first statement is correct – “Schema installation failed while creating tables”, it doesn’t tell you the error it encountered, and then it goes on to suggest only one reason for the failure.

The problem in this case was that my user didn’t have privileges to create the tables:

SQL> create table test_table (col1 int);
create table test_table (col1 int)
ERROR at line 1:
ORA-01031: insufficient privileges

Granting the CREATE TABLE privilege resolved the problem.

Create a free website or blog at WordPress.com.