Skip to main content
NetApp Knowledge Base

Occasional issues with SCSQL Clone jobs

Views:
73
Visibility:
Public
Votes:
0
Category:
snapcenter
Specialty:
snapx
Last Updated:

Applies to

  • SnapCenter Plug-In for SQL 4.8 (SCSQL)
  • SnapCenter Plug-In for Windows 4.8 (SCW)

Issue

SCSQL clone of a database from a backup to a remote SQL instance randomly fails.
For example, the clone from SourceSQLInstance\Inst1\db1 to Clonetoinstance Target_host1\Target_Instance generates the following errors:

Clone from backup 'RG1_ServerSource_10-25-2023_00.05.54.0002' : Failed.
Failed on'Target_host1':Activity 'FileSystem Clone' failed with error:
Failed to mount disk 01ABc$A1xAbC to mountpoint[C:\scmnpt\scmnpt\mpdisk0003\].
Failed to add access path to the partition. Details: Error:
Failed to get partition information fromdisk.

 

2023-10-26T02:07:28.5489445+02:00 Error SDW PID=[4000] TID=[10000] Error: Failed toget partition information from disk

2023-10-26T02:07:28.5509459+02:00 Information SDW PID=[4000] TID=[10000] Failed to addAccess path, removing the disk  from FailOverClusterManager

2023-11-03T08:27:52.5255826+01:00 Information SDW PID=[4000] TID=[10000] Executing Invoke-Command with ScriptBlock [("select disk 13", "attributes disk clear readonly", "online disk", "exit") | diskpart] on host Target_Host1
2023-11-03T08:27:52.5255826+01:00 Verbose SDW PID=[4000] TID=[10000] ++CmdletDiskManagementStrategy::CreateRunspace
2023-11-03T08:27:52.5255826+01:00 Verbose SDW PID=[4000] TID=[10000] local runspace
2023-11-03T08:27:52.5255826+01:00 Verbose SDW PID=[4000] TID=[10000] --CmdletDiskManagementStrategy::CreateRunspace
2023-11-03T08:27:52.5412089+01:00 Verbose SDW PID=[4000] TID=[10000] Running Invoke-Command on localhost without specifying -ComputerName parameter.
2023-11-03T08:27:54.2132312+01:00 Information SDW PID=[4000] TID=[10000]
Microsoft DiskPart version 10.0.20348.1
Copyright (C) Microsoft Corporation.
On computer: Target_Host1
DISKPART>
Disk 13 is now the selected disk.
DISKPART>
Disk attributes cleared successfully.
DISKPART>
DiskPart successfully onlined the selected disk.
DISKPART>
Leaving DiskPart...
2023-11-03T08:27:54.2132312+01:00 Verbose SDW PID=[4000] TID=[10000] DiskId: \\?\Disk{0101aaaa-aa1a-00ab-200a-100000000001}
2023-11-03T08:27:54.2132312+01:00 Verbose SDW PID=[4000] TID=[10000] --PartitionManager::ClearDiskReadOnlyAndOfflineFlags
2023-11-03T08:27:54.2132312+01:00 Verbose SDW PID=[4000] TID=[10000] query: select * from MSFT_Partition Where DiskId = \\\\?\\Disk{0101aaaa-aa1a-00ab-200a-100000000001}
2023-11-03T08:27:54.2132312+01:00 Verbose SDW PID=[4000] TID=[10000] scope: \\Target_Host1\root\Microsoft\Windows\Storage
2023-11-03T08:27:54.4476261+01:00 Error SDW PID=[4000] TID=[10000] Error: Failed to get partition information from disk

2023-11-03T08:30:17.7982096+01:00 DEBUG SnapManagerWeb_1535414 PID=[120000] TID=[10] Updating the job (1234567) task (FileSystem Clone) status as Failed

Sign in to view the entire content of this KB article.

New to NetApp?

Learn more about our award-winning Support

NetApp provides no representations or warranties regarding the accuracy or reliability or serviceability of any information or recommendations provided in this publication or with respect to any results that may be obtained by the use of the information or observance of any recommendations provided herein. The information in this document is distributed AS IS and the use of this information or the implementation of any recommendations or techniques herein is a customer's responsibility and depends on the customer's ability to evaluate and integrate them into the customer's operational environment. This document and the information contained herein may be used solely in connection with the NetApp products discussed in this document.