1 Reply Latest reply on Feb 26, 2018 1:03 PM by Mohammad Rehman

    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 - 64bit Production

      ITSM 9.1.04

      CMDB 9.1.04

      java version 1.8.0_151