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

book

Article ID: 106337

calendar_today

Updated On:

Products

CA Application Test Service Virtualization CA Continuous Application Insight (PathFinder) CA Service Virtualization (DevTest / LISA / VSE / Application Test)

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)

Cause

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

 

Environment

All Supported Devtest Environments

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;