Cannot Access "Scheduling Report" Post BSM 9.24 Upgrade - Micro Focus Community

Charles L. · ‎2014-09-01

Hi,

After upgrading to HP BSM 9.24, we encountered issue with the schedules for reports. No schedules shown in User Reports, and error found in the Report Scheduling. Here are the details.

Please share information if you had found similar issue to us, as we are currently working with HP Software Support, but no solution found so far.

Symptom:

Error message whenever checking Report Scheduling as shown in the screenshot here. Simply by clicking the tab will trigger the error message, "A general error has occurred. Please contact an administrator."
All schedules in the User Reports are missing / not seen.
However, seems Report Scheduler engine is still working because all the reports are still being sent and new schedule can be added as well (though once page is refreshed, the schedule is unseen from the GUI of User Reports)

Environment

BSM 9.24 was just upgraded from BSM 9.13 IP9.
2 servers deployment.
Oracle 11G, not RAC.
Issue was observed to occur on IE, FF and Chrome.
Java 1.7.51
BSM 9.13 applications were completely uninstalled before installing BSM 9.24.
Hotfix was installed on top of 9.13 IP9 as our scheduled report was not sending any report at that time, but HP Support informed that the files should have been replaced by 9.24since we had fully uninstalled BSM 9.13 prior to upgrade. These were the files being replaced by hotfix:

- repository-api.jar to HPBSM\lib folder of GW

- uiinfra.jar to HPBSM\lib folder of GW and DPS;

- repositoryManager.jar to HPBSM\AppServer\webapps\site.war\WEB-INF\LIB folder of GW

Steps taken so far:

Checked that we can access RTSM without any issue.
Clear Tomcat/Jboss cache and run Connect to DB wizard
Run PostInstall.bat in <HPBSM>\bin\ folder in DPS, followed up in GW.
Checking number of sessins connecting to BSM’s database, found normal.

SQL> select count(*) from V$session;

COUNT(*)

----------

144

Delete the following tables from Management DB and run Connect to DB wizard.

delete from HA_ACTIVE_SESS

delete from HA_BACKUP_PROCESSES

delete from HA_PROC_ALWD_SERVICES

delete from HA_PROCESSES

delete from HA_SRV_ALLWD_GRPS

delete from HA_SERVICES_DEP

delete from HA_SERVICES

delete from HA_SERVICE_GRPS

delete from HA_TASKS

delete from HA_SERVERS

delete from PROPERTIES where NAME = 'HAServiceControllerUpgrade'

Increase Connection Pool - Active Connection Monitor. The "Maximum connection timeout..." to 1800000.
Replaced the following files with the known working BSM 9.24 in HP Support's environment

- repository-api.jar to HPBSM\lib folder of GW

- uiinfra.jar to HPBSM\lib folder of GW and DPS;

- repositoryManagement.jar to HPBSM\AppServer\webapps\site.war\WEB-INF\LIB folder of GW

Checked that user schemas have the right permission (e.g. UCMDB_PROFILE for Profile DB):

SQL> select * from DBA_SYS_PRIVS where grantee = 'UCMDB_PROFILE';

UCMDB_PROFILE CREATE VIEW NO

UCMDB_PROFILE CREATE TRIGGER NO

UCMDB_PROFILE CREATE SEQUENCE NO

UCMDB_PROFILE UNLIMITED TABLESPACE NO

UCMDB_PROFILE CREATE PROCEDURE NO

UCMDB_PROFILE CREATE TABLE NO

SQL> select * from DBA_ROLE_PRIVS where grantee = 'UCMDB_PROFILE';

UCMDB_PROFILE CONNECT NO YES

UCMDB_PROFILE SELECT_CATALOG_ROLE NO YES

SQL> select * from DBA_TAB_PRIVS where grantee = 'UCMDB_PROFILE';

UCMDB_PROFILE SYS ORA_TEMP_1_DS_1930014 SYS SELECT NO NO

UCMDB_PROFILE SYS ORA_TEMP_1_DS_1930014 SYS INSERT NO NO

Notable error message in topaz_all.ejb.log (also found in <HPBSM>\log\scheduler.log) when opening the Report Scheduling tab.

2014-08-30 06:21:57,600 [ajp-0.0.0.0-8009-18] (LogUtils.java:17) ERROR - Failed to get job group names from quartz

com.mercury.infra.scheduler.SchedulerException: java.io.InvalidClassException: com.mercury.am.bac.core.ui.utils.user.resolution.ScreenResolution; class invalid for deserialization

at com.mercury.infra.scheduler.manager.SchedulerImpl.getObjectFromBlob(SchedulerImpl.java:1062)

at com.mercury.infra.scheduler.manager.SchedulerImpl.getJobsInfoPerJobType(SchedulerImpl.java:893)

at com.mercury.infra.scheduler.manager.SchedulerImpl.getJobsInfo(SchedulerImpl.java:573)

at com.mercury.am.bac.core.repository.impl.businessLogic.scheduleReports.TriggerHelper.fetchAllTriggers(TriggerHelper.java:77)

at com.mercury.am.bac.core.scheduleReports.entities.utils.ScheduleReportsTriggerHelper.fetchTriggersByCustomer(ScheduleReportsTriggerHelper.java:95)

at com.mercury.am.bac.core.scheduleReports.servlet.actions.CustomerTriggersAction.fetch(CustomerTriggersAction.java:57)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:606)

at org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:276)

at org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:196)

at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:421)

at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:226)

at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1164)

at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:397)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:690)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

at com.mercury.bac.ha.centers.HALoginStateFilter.doFilter(HALoginStateFilter.java:137)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

at com.mercury.topaz.webinfra.filters.NoCacheFilter.doFilter(NoCacheFilter.java:52)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

at com.mercury.am.bac.core.ui.utils.gzip.GZipServletFilter.doFilter(GZipServletFilter.java:77)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

at org.owasp.stinger.StingerFilter.doFilter(StingerFilter.java:128)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

at com.mercury.topaz.webinfra.filters.UserStatsLogFilter.doFilter(UserStatsLogFilter.java:101)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

at com.mercury.topaz.reportsExt.login.BacLwSsoFilter.doFilter(BacLwSsoFilter.java:564)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

at com.mercury.topaz.reportsExt.login.BacIdmSsoFilter.doFilter(BacIdmSsoFilter.java:122)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

at com.hp.sw.bto.ast.security.lwsso.LWSSOFilter.doFilter(LWSSOFilter.java:74)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

at com.mercury.topaz.reportsExt.login.BsmClientCertificateFilter.doFilter(BsmClientCertificateFilter.java:141)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

at com.mercury.topaz.webinfra.filters.SupportedLocaleFilter.doFilter(SupportedLocaleFilter.java:32)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

at com.mercury.j2f.j2eeutils.GZipSetCharacterEncodingFilter.doFilter(GZipSetCharacterEncodingFilter.java:189)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230)

at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)

at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:182)

at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:84)

at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)

at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)

at com.mercury.topaz.reportsExt.login.RenewSessionValve.invoke(RenewSessionValve.java:70)

at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)

at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:262)

at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:437)

at org.apache.coyote.ajp.AjpProtocol$AjpConnectionHandler.process(AjpProtocol.java:366)

at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:446)

at java.lang.Thread.run(Thread.java:744)

Caused by: java.io.InvalidClassException: com.mercury.am.bac.core.ui.utils.user.resolution.ScreenResolution; class invalid for deserialization

at java.io.ObjectStreamClass$ExceptionInfo.newInvalidClassException(ObjectStreamClass.java:150)

at java.io.ObjectStreamClass.checkDeserialize(ObjectStreamClass.java:768)

at java.io.ObjectInputStream.readOrdinaryObject(ObjectInputStream.java:1772)

at java.io.ObjectInputStream.readObject0(ObjectInputStream.java:1350)

at java.io.ObjectInputStream.defaultReadFields(ObjectInputStream.java:1990)

at java.io.ObjectInputStream.readSerialData(ObjectInputStream.java:1915)

at java.io.ObjectInputStream.readOrdinaryObject(ObjectInputStream.java:1798)

at java.io.ObjectInputStream.readObject0(ObjectInputStream.java:1350)

at java.io.ObjectInputStream.readObject(ObjectInputStream.java:370)

at java.util.HashMap.readObject(HashMap.java:1184)

at sun.reflect.GeneratedMethodAccessor157.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:606)

at java.io.ObjectStreamClass.invokeReadObject(ObjectStreamClass.java:1017)

at java.io.ObjectInputStream.readSerialData(ObjectInputStream.java:1893)

at java.io.ObjectInputStream.readOrdinaryObject(ObjectInputStream.java:1798)

at java.io.ObjectInputStream.readObject0(ObjectInputStream.java:1350)

at java.io.ObjectInputStream.defaultReadFields(ObjectInputStream.java:1990)

at java.io.ObjectInputStream.readSerialData(ObjectInputStream.java:1915)

at java.io.ObjectInputStream.readOrdinaryObject(ObjectInputStream.java:1798)

at java.io.ObjectInputStream.readObject0(ObjectInputStream.java:1350)

at java.io.ObjectInputStream.readObject(ObjectInputStream.java:370)

at com.mercury.infra.scheduler.manager.SchedulerImpl.getObjectFromBlob(SchedulerImpl.java:1054)

... 68 more

2014-08-30 06:21:57,606 [ajp-0.0.0.0-8009-18] (SchedulerExceptionHandler.java:32) ERROR - SchedulerExceptionHandler.execute - an exception has occured:

com.mercury.infra.scheduler.SchedulerException: Failed to get job group names from quartz

at com.mercury.infra.scheduler.util.LogUtils.logAndThrow(LogUtils.java:22)

at com.mercury.infra.scheduler.manager.SchedulerImpl.getJobsInfo(SchedulerImpl.java:578)