Creating Data Warehouse for JTS using Oracle database results in “java.sql.SQLException: ORA-01031: insufficient privileges” error

Technote (troubleshooting)


Problem(Abstract)

Attempts to create Data Warehouse for JTS in IBM Rational Quality Manager 3.0.1 results in the error “java.sql.SQLException: ORA-01031: insufficient privileges”.

Cause

The creation of the warehouse on Oracle requires elevated permissions as compared to other databases.

Resolving the problem

When you specify the database user in the connection spec for data warehouse, ensure that the database user has DBA permissions.

This is documented in the Rational Quality Manager 3.0.1 Information Center.


Rate this page:

(0 users)Average rating

Document information


More support for:

Rational Quality Manager
RQM Server

Software version:

3.0.1

Operating system(s):

Windows

Reference #:

1507700

Modified date:

2011-08-03

Translate my page

Machine Translation

Content navigation