Upgrade Jasper Reports 7.9 to 8.1 Failing with ORA-00942

Products

• CA Service Management - Service Desk Manager
• CA Service Desk Manager

Issue/Introduction

When upgrading from 7.9 to 8.1.1, the following error appears in cmd and the installation logs:

ERROR SqlExceptionHelper:131 - [TibcoSoftware][Oracle JDBC Driver][Oracle]ORA-00942: table or view does not exist
     [java] 
     [java] com.jaspersoft.jasperserver.api.JSExceptionWrapper: org.springframework.dao.InvalidDataAccessResourceUsageException: could not extract ResultSet; SQL [n/a]; nested exception is org.hibernate.exception.SQLGrammarException: could not extract ResultSet
     [java]     at org.springframework.orm.hibernate5.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:228)

Environment

Database: Oracle 

Cause

The user set in the default_master.properties does not have enough privileges to perform the upgrade 

Resolution

Refer to the following link for the permissions required for the database components:

Database Privileges Required By JasperReports Server