Banner Agent Error

Products

• CA Automic Applications Manager (AM)

Issue/Introduction

After upgrading Banner Agent when trying to run a Banner job or when trying to navigate to the Banner tab of a Banner job the following error is causing all Banner jobs to abort:

java.rmi.RemoteException: (ErrorCode 942) (SQLState 42000) select GJRJBMO_MIME_CDE, GJRJBMO_FONT_SIZE, GJRJBMO_PDFT_CODE, GJRJBMO_STORAGE_DAYS from GJRJBMO where upper(GJRJBMO_JOB) = ? ; nested exception is: 
 java.lang.RuntimeException

Environment

Release: 9.x

Resolution

Please make sure that the user has the following grants:

grant INSERT on GENERAL.GJBPRUN to banworx;
grant SELECT on GENERAL.GJBPRUN to banworx;
grant SELECT on GENERAL.GJBJOBS to banworx;
grant SELECT on GENERAL.GJBPDEF to banworx;
grant SELECT on GENERAL.GTVPRNT to banworx;
grant SELECT on GENERAL.GJBPDFT to banworx;
grant SELECT on GENERAL.GJBPSEQ to banworx;
grant SELECT on GENERAL.GJRJPRM to banworx;
grant SELECT on GENERAL.GLRSLCT to banworx;
grant SELECT on GENERAL.GLRAPPL to banworx;
grant SELECT on GENERAL.GLRVRBL to banworx;
grant SELECT on GENERAL.GUBLETR to banworx;
grant SELECT on GENERAL.GUBPARA to banworx;
grant SELECT on GENERAL.GJAJBMO to banworx;
grant SELECT on GENERAL.GJRJLIS to banworx;
grant SELECT on GENERAL.GTVPDFT to banworx;