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 Feb 12, 2018 5:00 PM

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

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 Feb 26, 2018 1:03 PM (in response to 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.
Like Show 1 Likes(1)

Actions
2. Re: Smart Reporting upgrade from 9.1 to 9.1.04 failed

Vanessa Jimenez Torres Oct 1, 2018 9:00 AM (in response to Mohammad Rehman)

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
Like Show 0 Likes(0)

Actions
3. Re: Smart Reporting upgrade from 9.1 to 9.1.04 failed

Andrea Rose Dec 4, 2018 1:15 AM (in response to Vanessa Jimenez Torres)

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
Like Show 0 Likes(0)

Actions
4. Re: Smart Reporting upgrade from 9.1 to 9.1.04 failed

Andrea Rose Dec 5, 2018 5:18 AM (in response to 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...
Like Show 0 Likes(0)

Actions
5. Re: Smart Reporting upgrade from 9.1 to 9.1.04 failed

Vanessa Jimenez Torres Dec 5, 2018 5:24 AM (in response to Andrea Rose)

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>
Like Show 0 Likes(0)

Actions
6. Re: Smart Reporting upgrade from 9.1 to 9.1.04 failed

Mohammad Rehman Dec 11, 2018 11:18 AM (in response to Andrea Rose)

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.
Like Show 0 Likes(0)

Actions
7. Re: Smart Reporting upgrade from 9.1 to 9.1.04 failed

Andrea Rose Dec 12, 2018 1:03 AM (in response to Mohammad Rehman)

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
Like Show 0 Likes(0)

Actions
8. Re: Smart Reporting upgrade from 9.1 to 9.1.04 failed

Vanessa Jimenez Torres Dec 14, 2018 5:23 AM (in response to Andrea Rose)

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
Like Show 0 Likes(0)

Actions

Go to original post