Skip to main content
NetApp Response to Russia-Ukraine Cyber Threat
In response to the recent rise in cyber threat due to the Russian-Ukraine crisis, NetApp is actively monitoring the global security intelligence and updating our cybersecurity measures. We follow U.S. Federal Government guidance and remain on high alert. Customers are encouraged to monitor the Cybersecurity and Infrastructure Security (CISA) website for new information as it develops and remain on high alert.
NetApp Knowledge Base

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

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

 

Scan to view the article on your device
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