OnCommand Insight DataWarehouse fails to restore backup with error 'The user specified as a definer ('username') does not exist'
- Views:
- 208
- Visibility:
- Public
- Votes:
- 1
- 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