Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[New-DcnImage] Couldn't restore database System.Collections.Hashtable as MyDatabase-dbaclone on myserver. #226

Closed
bdway opened this issue Mar 27, 2023 · 2 comments

Comments

@bdway
Copy link

bdway commented Mar 27, 2023

I have attempted to create the same image by running commands from the server and remotely from my machine. Both attempts have resulted in the same error and same end state.

Version 0.10.72

Error:
WARNING: [07:12:02][New-DcnImage] Couldn't restore database System.Collections.Hashtable as Eligibility-dbaclone on mmappcore.
Cannot find an overload for "Round" and the argument count: "1".

Results:

  1. The database looks to have been restored properly, I can still see it on the destination sql server.
  2. There is a vhdx file and a folder with the database mdf/ldf in the Image location. The file is the proper size and matches the database size.
  3. No records have been written to the dbaclone.dbo.Image table.
  4. The vhdx files cannot be deleted. I get an error that "the file is open by System"

Commands:
New-DcnImage -BackupFilePath D:\Backup\Databases\MyDatabase\FULL -DestinationSqlInstance myserver -ImageNetworkPath \myserver\dbaclone\Images -Database MyDatabase

New-DcnImage -BackupFilePath D:\Backup\Databases\MyDatabase\FULL -DestinationSqlInstance myserver -ImageNetworkPath \myserver\dbaclone\Images -Database MyDatabase

I'm not a PowerShell expert and I'm not sure where to begin troubleshooting this Warning. Any tips or assistance would be greatly appreciated.

@bdway
Copy link
Author

bdway commented Mar 27, 2023

Here is the Verbose output. As soon as the restore hits 100% the warning gets displayed.

PS C:\WINDOWS\system32> New-DcnImage -Database MyDatabase -DestinationSqlInstance myserver -BackupFilePath \myserver\Databases\MyDatabase\FULL -ImageNetworkPath \myserver\dbaclone\Images -Verbose
VERBOSE: [08:50:59][New-DcnImage] Setting vhd type to 'VHDX'
VERBOSE: Performing the operation "Testing module setup" on target "Test-DcnConfiguration".
VERBOSE: [08:50:59][Test-DcnConfiguration] Checking configurations
VERBOSE: [08:50:59][Test-DcnConfiguration] Attempting to connect to dbaclone database server myserver..
VERBOSE: [08:51:02][Test-DcnConfiguration] Finished checking configurations
VERBOSE: [08:51:02][New-DcnImage] Started image creation
VERBOSE: Performing the operation "Converting UNC path to local path" on target "\myserver\dbaclone\Images".
VERBOSE: [08:51:31][New-DcnImage] Converted '\myserver\dbaclone\Images' to 'D:\dbaclone\Images'
VERBOSE: [08:51:31][New-DcnImage] Creating image for database System.Collections.Hashtable from \myserver\Databases\MyDatabase\FULL
VERBOSE: Performing the operation "Checking available disk space for database" on target "System.Collections.Hashtable".
VERBOSE: Performing the operation "Creating the vhd" on target "MyDatabase_20230327085131".
VERBOSE: [08:51:31][New-DcnImage] Create the vhd MyDatabase_20230327085131
VERBOSE: Performing the operation "Initializing the vhd" on target "MyDatabase_20230327085131".
VERBOSE: [08:51:35][New-DcnImage] Initializing the vhd MyDatabase_20230327085131
VERBOSE: Performing the operation "Creating access path D:\dbaclone\Images\MyDatabase_20230327085131" on target "D:\dbaclone\Images\MyDatabase_20230327085131".
VERBOSE: Performing the operation "Adding access path 'D:\dbaclone\Images\MyDatabase_20230327085131' to mounted disk" on target "D:\dbaclone\Images\MyDatabase_20230327085131".
VERBOSE: Performing the operation "Creating data folder in vhd" on target "D:\dbaclone\Images\MyDatabase_20230327085131".
VERBOSE: [08:51:43][New-DcnImage] Creating data folder for image
VERBOSE: Performing the operation "Creating log folder in vhd" on target "D:\dbaclone\Images\MyDatabase_20230327085131".
VERBOSE: [08:51:43][New-DcnImage] Creating transaction log folder for image
VERBOSE: Performing the operation "Restoring database" on target "MyDatabase-dbaclone".
VERBOSE: [08:51:43][New-DcnImage] Restoring database System.Collections.Hashtable on myserver
WARNING: [08:56:20][New-DcnImage] Couldn't restore database System.Collections.Hashtable as MyDatabase-dbaclone on myserver.
Cannot find an overload for "Round" and the argument count: "1".
VERBOSE: [08:56:20][New-DcnImage] Finished creating database image

@bdway
Copy link
Author

bdway commented Mar 27, 2023

I believe this issue was caused by having an additional sub folder with the previous backups in the -BackupFilePath location. I moved that folder out to a new location and the image operation has succeeded without issue several times.

@bdway bdway closed this as completed Mar 27, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant