topic Re: OCI 7.1 DWH DB restore failed in Active IQ Unified Manager Discussions

OCI 7.1 DWH DB restore failed

sstrznwra — Thu, 05 Jun 2025 04:24:37 GMT

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

Re: OCI 7.1 DWH DB restore failed

hotz — Mon, 04 May 2015 07:14:09 GMT

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

Re: OCI 7.1 DWH DB restore failed

sstrznwra — Mon, 04 May 2015 08:53:13 GMT

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

Re: OCI 7.1 DWH DB restore failed

JBARBALACE — Mon, 04 May 2015 19:29:23 GMT

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

Re: OCI 7.1 DWH DB restore failed

slava — Mon, 11 May 2015 13:21:22 GMT

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

Re: OCI 7.1 DWH DB restore failed

JBARBALACE — Mon, 11 May 2015 13:28:14 GMT

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.

Re: OCI 7.1 DWH DB restore failed

slava — Mon, 11 May 2015 13:42:42 GMT

Thanks for response.
I am also in process of restoring database only.
Then will try to restore from 7.0.1.
Regards,
Slava

Re: OCI 7.1 DWH DB restore failed

sstrznwra — Wed, 20 May 2015 10:58:14 GMT

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