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

Document ID : KB000106337
Last Modified Date : 13/07/2018
Show Technical Document Details
Issue:
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;