Upgrading RA BANNER to 4.1.1 and above results in ORA-00942 error when trying to run any job

Products

• CA Automic Applications Manager (AM)

Issue/Introduction

Upgrading RA BANNER to 4.1.1 and above results in ORA-00942 error when trying to run any Job. Below is an snippet of the error.

Error message:
java.rmi.RemoteException: ORA-00942: table or view does not exist
; nested exception is: 
 java.lang.RuntimeException

 

 

Environment

Release : 9.4

Component : APPLICATIONS MANAGER

Resolution

RA Banner 4.1.1 and above requires 4 additional grants that are not listed in the documentation section "Issuing Grants to Create the BANWORX Banner User":

grant SELECT on GENERAL.GJAJBMO to banworx;
grant SELECT on GENERAL.GJRJLIS to banworx;
grant SELECT on GENERAL.GTVPDFT to banworx;

grant SELECT on GENERAL.GJRLCPR to banworx;