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