Smart Reporting upgrade from 9.1 to 9.1.04 failed
Mohammad Rehman
Hello Gurus/Experts,
I am working on the smart reporting upgrade and it should be simple but failed on certain points but installer is smart enough to display successfully completed.
When I reviewed the logs i don't see anything except where it fails point onward all the database statements failed in the arsystem_installed log as well.
Actual problem was detected in smart report upgrade log under <AR Installed>/Smartreporting/ folder.
I have ticket open with BMC but as usual its been over a week no update except SME is working on it.
Here is the error where it fails,
Converting Report Content
Updating chart formats
[UpdateContent73Job] ValueChart rows 2
[UpdateContent73Job] Hist rows 0
[UpdateContent73Job] Created 2 records in ReportFormat
Deleting Draft Formula Fields
Updating field categories
Migrating Grouped Data Fields
[UpdateContent73Job] View Grouped Data row count: 0
[UpdateContent73Job] Numeric Grouped Data rows of Master Query 0
[UpdateContent73Job] Numeric Grouped Data rows 0
Updating AccessLevel
Updating ReportFieldTemplate
[UpdateContent73Job] Updated 28574 records from ReportFieldTemplate
Encrypting stored passwords
Installation Error
An error occurred during installation:
java.lang.ClassCastException: java.math.BigDecimal cannot be cast to java.lang.Integer
java.lang.ClassCastException: java.math.BigDecimal cannot be cast to java.lang.Integer
at com.hof.patch.process.job.UpdateContent73Job.encryptStoredPasswords(UpdateContent73Job.java:372)
at com.hof.patch.process.job.UpdateContent73Job.run(UpdateContent73Job.java:99)
at com.hof.patch.PatchInstaller.runInstallJobs(PatchInstaller.java:459)
at com.hof.patch.cmd.SilentInstaller.install(SilentInstaller.java:76)
at com.hof.patch.PatchInstaller.runSilent(PatchInstaller.java:778)
at com.hof.patch.PatchInstaller.runInstaller(PatchInstaller.java:734)
at com.hof.patch.PatchInstaller.main(PatchInstaller.java:796)
--- SmartReporting Installation Failed ---
Here is my environment:
ARS 9.1.04 201711272256
Apache Tomcat/8.5.23
ARS Midtier Version 9.1.04 201711272256
OS Linux 2.6.32-696.18.7.el6.x86_64
DB Oracle 12.1.0.2.0 - 64bit Production
ITSM 9.1.04
CMDB 9.1.04
java version 1.8.0_151
Thanks
Mohammad