Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hello
When upgrade from OCI DWH 7.0.2 to OCI DWH 7.1 the DB restore goes failed.
Upgrade Log:
Caused by: java.lang.StringIndexOutOfBoundsException: String index out of range: -47
at java.lang.String.substring(Unknown Source)
at com.netapp.sanscreen.dwh.cognos.upgrade.v_7_1.Upgrader_7_1.run(Upgrader_7_1.java:81)
The error only occurs when I restore the DB with "Restore Reports"
Does anyone have any idea about it ?
Thanks
Michael
7 REPLIES 7
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Michael,
I'm not entirely certain, but do you have custom reports? Especially ones that use the Storage Capacity data mart?
Note that the Storage Capacity data mart and Storage Capacity fact table (dwh_capacity.capacity_fact) are removed.
But regardless of whether the Storage Capacity data mart is causing the issue or something else, you might want to open a case with NetApp support. This looks like a bug to me.
Kind regards,
Gerhard
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Gerhard
Thanks for the quick response, I know the Storage Capacity Datamart is removed in 7.1, I have 2 reports that used this datamart.
I delete this reports on 7.0.2 DB , but the same error on restore to 7.1 dwh.
at java.lang.Thread.run(Unknown Source)
Caused by: java.lang.StringIndexOutOfBoundsException: String index out of range: -47
at java.lang.String.substring(Unknown Source)
at com.netapp.sanscreen.dwh.cognos.upgrade.v_7_1.Upgrader_7_1.run(Upgrader_7_1.java:81)
at com.netapp.sanscreen.dwh.upgrade.cognos.CognosContentStoreUpgradeManager.upgrade(CognosContentStoreUpgradeManager.java:46)
... 109 more
Is it possible that I have a problem with the language here ?
Windows Server 2008 R2 English
I have opend a Case on Monday last Week , the support says the case is passed on engineering.
Kind regards
Michael
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Just thought I'd add a quick note, that I had the same issue today. The reason provided was: "Failed upgrading cognos data store". I, too, upgraded from 7.0.2 to 7.1.0. A little frustrating after waiting 2 hours for it to restore...
I'll be opening a case shortly.
Good luck!
Julia
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hello guys,
I just hit the same issue after OCIDWH upgrade to 7.1.
Have you been able to figure out what is the solution there?
Regards,
Slava
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I have a case open with NetApp at the moment. The issue for us is that when I try to restore the database and reports together, it fails. When I restore the database only, it is consistently successful. When I then try to restore the reports only, failure each time. I've tried with a restore from 6.4.3 reports and 7.0.2 report backups, but to no avail. I get the exact same error message you show in your attachment.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thanks for response.
I am also in process of restoring database only.
Then will try to restore from 7.0.1.
Regards,
Slava
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
You must remove all Slashes from the Report Name.
/content/folder[@name='Capacity']/package[@name='Storage and Storage Pool Capacity']/folder[@name='CustomerDashboards']/report[@name='NASFILER01/02 POOLS']
Check the dwh_upgrade.log to find Reportnames with Slash
Regards
Michael