Smart Reporting upgrade from 9.1 to 9.1.04 failed
Feb 12, 2018 5:00 PM
Feb 12, 2018 5:00 PM
-
1. Re: Smart Reporting upgrade from 9.1 to 9.1.04 failed
Mohammad Rehman
Feb 26, 2018 1:03 PM
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
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
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
1 of 1 people found this helpfulThe 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
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<>
-
6. Re: Smart Reporting upgrade from 9.1 to 9.1.04 failed
Mohammad Rehman
Dec 11, 2018 11:18 AM
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
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
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
Dec 14, 2018 10:27 AM
2 of 2 people found this helpfulHere 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);
-
10. Re: Smart Reporting upgrade from 9.1 to 9.1.04 failed
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
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
Dec 17, 2018 10:14 AM
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
That's what happens when "Sucessful" hides "not successful".
Regards