Skip to main content
NetApp Knowledgebase

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

Views:
57
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

 

CUSTOMER EXCLUSIVE CONTENT

Registered NetApp customers get unlimited access to our dynamic Knowledge Base.

New authoritative content is published and updated each day by our team of experts.

Current Customer or Partner?

Sign In for unlimited access

New to NetApp?

Learn more about our award-winning Support