DB_SYNC job failed due to an error during execution

  • 0
  • 1
  • Problem
  • Updated 4 years ago
  • Acknowledged
Hello,

After launching the first snapshot from a sqlserver source (VM), on Landshark 2.0, we get this error:
"DB_SYNC job for ... failed due to an error during execution:
Failed to discover and mount LUNs from the Delphix Engine through the iSCSI initiator on target host ... .
Make sure that the iSCSI initiator is running and that the user ... has privileges to perform disk management on the host."

We double-checked that:
delphix user is a domain user with local administrator privileges on both source and target,
it has sysadmin role on both SQL Server instances (source and target),
and has "Logon as Batch job" rights on target.
Delphix Connector and iSCSI initiator services are up and running on target machine.
(target machine is used as staging too)

Could you help us to solve this issue?
Thanks.

Note: This conversation was created from a reply on: Tip of the Day: SQL Server Set Up and a Windows User.
Photo of Giorgio Segnato

Giorgio Segnato

  • 332 Points 250 badge 2x thumb

Posted 4 years ago

  • 0
  • 1
Photo of Vikas Singh

Vikas Singh

  • 90 Points 75 badge 2x thumb
Hi,

I am also having the same issue. Did you able to find any solution?

Thanks,
Vikas
Photo of Giorgio Segnato

Giorgio Segnato

  • 332 Points 250 badge 2x thumb
Hello Adam,

the following screenshots show the actual configuration on both source and target environments.











Unfortunatley, even though I switched the user and system locale to us_En, DB_SYNC still not works (always the same error).

Have you other advices?

Could you provide me a link to download the 4.2 version, I will try with that.

Thanks,
Giorgio
Photo of Adam Bowen

Adam Bowen, Official Rep

  • 17,884 Points 10k badge 2x thumb
Can you refresh your target environment, try to snapshot again, and then send me the support bundle?
Photo of Giorgio Segnato

Giorgio Segnato

  • 332 Points 250 badge 2x thumb
I sent you an email with a Dropbox link to download the support bundle.

Thanks,
Giorgio
Photo of Giorgio Segnato

Giorgio Segnato

  • 332 Points 250 badge 2x thumb
Hello,

we are getting the same issues with 4.2 version.

Digging into the error messages we found "No volume specified" error from PS script output:
...
Microsoft DiskPart versione 6.1.7601
Copyright (C) 1999-2008 Microsoft Corporation.
Nel computer DELPHIX2
Il disco attualmente selezionato � il disco 4.
La partizione attualmente selezionata � la partizione 1.
Nessun volume specificato.
Selezionare un volume e riprovare.
ERROR_ASSIGN_MOUNTPATH: failed to assign mount path for disk 4 at C:\Delphix\De
lphixConnector42\564ddbcc-9f64-0680-a2dc-1e5959a3cdc9-staging-3\DATA, error -21
47024809
Looking into  our stanging env, which I remind you is a 2008 r2, we found the file C:\Delphix\De
lphixConnector42\564ddbcc-9f64-0680-a2dc-1e5959a3cdc9-staging-3\SCRIPT\MountLunData.ps1
which we think it is raising the error (see lines 350 - 358).
# Assign a mount path to the volume
$diskScript = "select disk $diskDeviceNumber`
select partition $partition`
assign mount=`"$mountpath`"`
exit"
$err = diskpartRetry $diskScript 10 6
if ($err -ne 0) {
   "ERROR_ASSIGN_MOUNTPATH: failed to assign mount path for disk $diskDeviceNumber at $mountpath, error $err"
   exit $err
}
As you can see the Remarks on Microsoft Technet for "ASSIGN" syntax on Win 2008 r2 seems to be mandatory  setting a volume:
A volume must be selected for this operation to succeed. Use the select volume command to select a volume and shift the focus to it.
That is missing in ps script. So this could be the point.
What's your opinion?

Regards,
Giorgio
(Edited)
Photo of Darin Tully

Darin Tully, SQL DBA

  • 530 Points 500 badge 2x thumb
It's an issue with the locale and the mount script. The diskpart commands are coming back in non-English and that leads to the failure to mount the LUN,  We will work on fixing this in a future release.
Photo of Giorgio Segnato

Giorgio Segnato

  • 332 Points 250 badge 2x thumb
Hello,

do you think that this issue could be bypassed by installing the MUI package for Windows Server 2008 (and PowerShell) and setting the English language for Delphix user?

Thanks,
Giorgio
Photo of Giorgio Segnato

Giorgio Segnato

  • 332 Points 250 badge 2x thumb
Hello again,

we found a Windows 2008 server in English.

Now, obviously only for testing purposes, could we use only one server for source, target and staging?

Should we pay attention on something in particular in that case?

Thanks
Photo of Adam Bowen

Adam Bowen, Official Rep

  • 17,884 Points 10k badge 2x thumb
Yes, I have done it. Purely for exploratory purposes. As you can imagine, the performance won't be great.