DevTest Reports are not populating data: Error ORA-01950: no privileges on tablespace

Products

• CA Application Test
• CA Continuous Application Insight (PathFinder)

Issue/Introduction

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)

Environment

All Supported Devtest Environments

Cause

Looks like permission on the tables was changed unknowingly. 
Caused by: java.sql.SQLSyntaxErrorException: ORA-01950: no privileges on tablespace 'LISA_USER'

 

Resolution

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;

Additional Information

Once tables are created , these would probably be sufficient after the Schema(s) is/are created.

 

EXECUTE ANY PROCEDURE

SELECT ANY TABLE

UPDATE ANY TABLE

INSERT ANY TABLE

CREATE VIEW