13 Replies Latest reply on Dec 17, 2018 10:19 AM by Vanessa Jimenez Torres

    Smart Reporting upgrade from 9.1 to 9.1.04 failed

    Mohammad Rehman
      Share:|

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

                1 of 1 people found this helpful
                • 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

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

                          Here are the steps were provided by BMC support and worked out for me. ( Note I have underneath Oracle Database, you can convert these SQL statements as per your DB).

                           

                          Here are the General Steps to Follow:

                          1. Revert back the File System and Smart Reporting DB prior to Smart Reporting upgrade, basically make your older version functional again.

                          2. Apply the workaround below - to run the queries on DB.

                          3. Run the Upgrade to SP44. Perform the steps to execute the queries mentioned in earlier update , as post upgrade task.

                           

                          Note: In case you do not have the DB backup or you are sharing the same DB as ARSystem this will not work,  I have checked with Yellow Fin team, and they said, it is always recommended to take Backup of the DB/FileSystem before upgrade so that in case any issues occurred during Upgrade we can safely revert back to older/working version. If no backup we recommend to perform a fresh install.

                           

                          STEP 2

                          I suggest to first follow the workaround on the TEST environment first then proceed with other env.

                          Convert ReportBroadcast.BroadcastID from NUMBER to INTEGER, then do the upgrade, then convert it back.

                           

                          Here are the queries to do this:

                          SQL> create global temporary table ReportBroadcast_temp on commit preserve rows as select * from ReportBroadcast;

                          SQL> delete from reportBroadcast;

                          SQL> alter table ReportBroadcast modify(BroadcastID integer);

                          SQL> insert into ReportBroadcast (select * from ReportBroadcast_temp);

                           

                          STEP 3

                          then perform the upgrade

                           

                          STEP 4

                          SQL> create global temporary table ReportBroadcast_temp_2 on commit preserve rows as select * from ReportBroadcast;

                          SQL> delete from reportBroadcast;

                          SQL> alter table ReportBroadcast modify(BroadcastID number);

                          SQL> insert into ReportBroadcast (select * from ReportBroadcast_temp_2);

                           

                          2 of 2 people found this helpful
                          • 10. Re: Smart Reporting upgrade from 9.1 to 9.1.04 failed
                            Andrea Rose

                            Many thanks, Mohammad!

                            We have the same DB as ARSystem and we had to restore the complete DB in TEST, which is a problem. But we could use this workaround in PROD before starting the upgrade the first time. Unfortunately we have no "fresh" test environment anymore for testing. We have to discuss this within our team...

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

                              Thanks Mohammad for sharing!

                               

                              sorry to say it won't work in our side as we share DB with ARSystem and have no backup (upgrade was made weeks ago) as the installation ended "successfully". It was but reviewing the overall  functionality of the tool that we discovered the faulty install.

                               

                              However, I find it really tough to have to rollback the entire DB just because of an installation failure! Let's say in our case, it seems we are due to completely remove the application and reinstall in a different way (and pray for the import/export of reports to work smooth).

                               

                              Regards,

                               

                              Vanessa

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

                                That's what happens when we don't follow best practices during installation. Best wishes.

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

                                  That's what happens when "Sucessful" hides "not successful".

                                   

                                  Regards