8 Replies Latest reply on Dec 14, 2018 5:23 AM by Vanessa Jimenez Torres

    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

        • 1. Re: Smart Reporting upgrade from 9.1 to 9.1.04 failed
          Mohammad Rehman

          BMC support provided the work around solution, But I had to restore the Smart Reporting DB and OS Level back to the point where i started the upgrade.

          Issue relate to broadcast repository table.

          • 2. Re: Smart Reporting upgrade from 9.1 to 9.1.04 failed
            Vanessa Jimenez Torres

            Hi Mohammad,

             

            same issue for us when upgrading from 9.1.02 to 9.1.04. We have two servers and whereas the primary one gives the error, the second one completes the installation. Thus, we have one server showing 7.1 version of Smart Reporting and the other showing the 7.3 version (using the same installer). Could you name in big words the steps provided by BMC support to solve the issue?

             

            Thanks,

             

            Vanessa

            • 3. Re: Smart Reporting upgrade from 9.1 to 9.1.04 failed
              Andrea Rose

              Hi Vanessa,

               

              we face the same issue upgrading from 9.1 to 18.08. Did you resolve this in the meantime? I'm in contact with BMC Support but up to now they haven't provided the steps to do to solve this issue .

               

              Regards,

              Andrea

              • 4. Re: Smart Reporting upgrade from 9.1 to 9.1.04 failed
                Andrea Rose

                The installation failes if there are records in table reportbroadcast. We deleted all records and ran the installation again successfully.

                For our test environment this is okay. For prod we still need a practicable work around. Waiting for BMC Support...

                • 5. Re: Smart Reporting upgrade from 9.1 to 9.1.04 failed
                  Vanessa Jimenez Torres

                  Hi Andrea,

                   

                  That could be an explanation; we have plenty of broadcast in our env. In fact, since the upgrade we’ve lost access to the broadcast console too.

                  We’ll give it a try and report our results. Thanks for the tip!

                   

                  Vanessa

                   

                  De: Andrea Rose

                  Enviado el: miércoles, 5 de diciembre de 2018 12:20

                  Para: María Vanessa Jiménez Torres <mvjimenez@bankinter.com>

                  Asunto: Re:  - Smart Reporting upgrade from 9.1 to 9.1.04 failed

                   

                  BMC Communities <https://communities.bmc.com/?et=watches.email.thread>

                   

                   

                  Smart Reporting upgrade from 9.1 to 9.1.04 failed

                   

                  reply from Andrea Rose<https://communities.bmc.com/people/rose?et=watches.email.thread> in Remedy ITSM - View the full discussion<https://communities.bmc.com/message/798667?et=watches.email.thread#798667>

                  • 6. Re: Smart Reporting upgrade from 9.1 to 9.1.04 failed
                    Mohammad Rehman

                    Would you both share the error message you see in <Smart Reporting Installed Folder>/SmartReporting/ SmartReportingUpgradePatchLog-<Date>.log ?

                    My error was

                    BigDecimal cannot be cast to java.lang.IntegerencryptStoredPasswords(UpdateContent73Job.java:372)

                     

                    If your error is related to broadcast table then i can provide you the workaround which was provided by BMC and it worked.

                    • 7. Re: Smart Reporting upgrade from 9.1 to 9.1.04 failed
                      Andrea Rose

                      Hi Mohammad,

                       

                      is exactly the same error and it's obviously related to table reportbroadcast. Without any records in this table there's no installation error.

                       

                      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:463)

                          at com.hof.patch.cmd.SilentInstaller.install(SilentInstaller.java:119)

                          at com.hof.patch.PatchInstaller.runSilent(PatchInstaller.java:782)

                          at com.hof.patch.PatchInstaller.runInstaller(PatchInstaller.java:738)

                          at com.hof.patch.PatchInstaller.main(PatchInstaller.java:800)

                      --- SmartReporting Installation Failed ---

                       

                      Many Thanks

                      • 8. Re: Smart Reporting upgrade from 9.1 to 9.1.04 failed
                        Vanessa Jimenez Torres

                        Same error for us:

                         

                        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 13196 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 ---

                         

                        Haven't had the chance so far to test reinstallation removing content from broadcast table.

                         

                        Vanessa