Skip to main content
NetApp Knowledge Base

OnCommand Insight DataWarehouse fails to restore backup with error 'The user specified as a definer ('username') does not exist'

Views:
154
Visibility:
Public
Votes:
0
Category:
oncommand-insight-data-warehouse
Specialty:
oci
Last Updated:

Applies to

OnCommand Insight DataWarehouse (DWH) 7.3.x

Issue

Trying to restore a DWH backup fails with the following errors on dwh_upgrade.log

<InstallDrive>\SANscreen\wildfly\standalone\log\dwh_upgrade.log

2020-04-09 11:36:11,130 ERROR [default task-16] UpgradeManagerPortalBean (UpgradeManagerPortalBean.java:93) - Failed to restore from 'dwh_7.3.1_sitename_all_1291577520156352224.zip' Reason: Failed to execute sql statements from the temp sql file [D:\OCIDWH\SANscreen\mysql\securefile\dwh\dwh_7.3.1_sitename_all_12915775201563522242418961623483620116_3338610024098833867.dump], because mysql user 'root' does not exist.

ERROR 1449 (HY000) at line 240058 in file: 'D:\OCIDWH\SANscreen\mysql\securefile\dwh\dwh_7.3.1_SRVPARSNAP20_all_12915775201563522242418961623483620116_3338610024098833867.dump': The user specified as a definer ('root'@'%') does not exist

 

Sign in to view the entire content of this KB article.

New to NetApp?

Learn more about our award-winning Support

Scan to view the article on your device