DevTest Reports are not populating data: Error ORA-01950: no privileges on tablespace
Article ID: 106337
CA Application TestCA Continuous Application Insight (PathFinder)
When running load test on our DevTest instance. We tried to generate "Virtual Service Response Time" report for the service, but its not displaying any data after a particular time.
Seeing errors in the Registry logs.
Caused by: java.sql.SQLSyntaxErrorException: ORA-01950: no privileges on tablespace 'LISA_USER' at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399)
All Supported Devtest Environments
Looks like permission on the tables was changed unknowingly. Caused by: java.sql.SQLSyntaxErrorException: ORA-01950: no privileges on tablespace 'LISA_USER'
The LISA_USER user needs the following rights:
GRANT DBA TO LISA_USER;
GRANT CREATE SESSION TO LISA_USER;
GRANT SELECT ON "SYS"."DBA_TABLESPACES" TO LISA_USER WITH GRANT OPTION;
Once tables are created , these would probably be sufficient after the Schema(s) is/are created.