If the Insight database is hosted on Oracle and the Insight Oracle user does not have the correct quota on the tablespaces in the Insight databases, the DCC web UI will show multiple symptoms as operations fail because the Insight database user cannot allocate an extent in the impacted tablespaces.
Common symptoms of this problem are:
The Data Collections Jobs status page no longer displays new entries.
- The "Delete History" operation in the Data Collection Jobs status page fails with this error:
Error 500: CRRCD1500E An exception com.ibm.team.jfs.app.http.HttpPreconditionFailedException was caught in the class sun.reflect.NativeConstructorAccessorImpl from calling the function newInstance0.
Precondition Failed Error 412: CRJZS0220E The precondition given in one or more of the request-header fields evaluated to false when it was tested on the server.
- Updates to settings in the Data Collection Jobs page fail with the error above.
- You see errors like this in your application server logs:
ORA-01950: no privileges on tablespace 'ETLUSER'
Troubleshooting this issue
This problem generally happens when the Insight database user's quota on the tablespace referenced in the ORA-01950 error is 0 instead of -1 (unlimited). To determine whether you are having this problem, show each ORA-01950 error to your DBA and have your DBA verify that the IBM Rational Insight database user has the correct quota on the tablespace(s) referenced in the ORA-01950 error(s).
To fix the problem
To resolve this issue, the DBA needs to fix the tablespace allocation on each tablespace referenced in an ORA-01950 error -- the Insight database user's quota cannot be 0 (it is commonly -1, which means unlimited quota).