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
Release: 9.x
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;