Cloning or Restore from SnapCenter SQL backup fails with an Object reference error
Applies to
SnapCenter Plug-in for SQL (SCSQL) 4.x
SnapCenter Plug-in for Windows (SCW) 4.x
Issue
When attempting to restore or clone a database from a Backup, the following error and previous log lines are seen in the SmSql_<JOB#>.log:
On Restore:
DEBUG SmSql_<RESTORE_JOB#> PID=[<PID>] TID=[70] Starting VDI restore for database [<database>]....
DEBUG SmSql_<RESTORE_JOB#> PID=[<PID>] TID=[70] Recovery: Operational RetainReplication: False
DEBUG SmSql_<RESTORE_JOB#> PID=[<PID>] TID=[70] createClonedDatabase End
ERROR SmSql_<RESTORE_JOB#> PID=[<PID>] TID=[70] Object reference not set to an instance of an object.
ERROR SmSql_<RESTORE_JOB#> PID=[<PID>] TID=[70] Failed to restore. Object reference not set to an instance of an object.On Clone:
DEBUG SmSql_<CLONE_JOB#> PID=[<PID>] TID=[80] Starting VDI restore for database [<database_Clone>]....
DEBUG SmSql_<CLONE_JOB#> PID=[<PID>] TID=[80] Recovery: Operational RetainReplication: False
DEBUG SmSql_<CLONE_JOB#> PID=[<PID>] TID=[80] createClonedDatabase End
ERROR SmSql_<CLONE_JOB#> PID=[<PID>] TID=[80] Object reference not set to an instance of an object.
ERROR SmSql_<CLONE_JOB#> PID=[<PID>] TID=[80] Failed to refresh the clone. Object reference not set to an instance of an object.