Delphix Products

  • 1.  Delphix Virtualization - Initial load fails after creating dSource - MS SQL Server

    Posted 07-12-2021 04:05:00 AM
    Hi,

    After creating the dSource, the initial load fails with the following error:
    Failed to discover and mount LUNs from the Delphix Engine through the iSCSI initiator on target host <Host Name>

    This is for MS SQL Server. Please help.

    Following is the complete log:

    <mat-dialog-container aria-modal="true" class="mat-dialog-container ng-tns-c70-59 ng-trigger ng-trigger-dialogContainer ng-star-inserted" id="mat-dialog-4" role="dialog" aria-labelledby="mat-dialog-title-8" tabindex="-1"><shr-error-dialog _nghost-qvb-c308="" class="ng-star-inserted"><dx-base-dialog _ngcontent-qvb-c308="" _nghost-qvb-c225="" ng-reflect-dialog-title="Run SnapSync for database "DSO" ng-reflect-actions="[object Object]">
    <dx-labeled-value _ngcontent-qvb-c308="" class="sid-shr-error-dialog-command-output ng-star-inserted" _nghost-qvb-c223="" ng-reflect-label="Command Output">

    <mat-dialog-container aria-modal="true" class="mat-dialog-container ng-tns-c70-59 ng-trigger ng-trigger-dialogContainer ng-star-inserted" id="mat-dialog-4" role="dialog" aria-labelledby="mat-dialog-title-8" tabindex="-1"><shr-error-dialog _nghost-qvb-c308="" class="ng-star-inserted"><dx-base-dialog _ngcontent-qvb-c308="" _nghost-qvb-c225="" ng-reflect-dialog-title="Run SnapSync for database "DSO" ng-reflect-actions="[object Object]">

    <dx-labeled-value _ngcontent-qvb-c308="" class="sid-shr-error-dialog-command-output ng-star-inserted" _nghost-qvb-c223="" ng-reflect-label="Command Output">

    Microsoft DiskPart version 10.0.17763.1 Copyright (C) Microsoft Corporation. On computer: INCHNQETVM56 Automatic mounting of new volumes disabled. Leaving DiskPart... Microsoft iSCSI Initiator Version 10.0 Build 17763 The operation completed successfully. TIMER(0.191): Add target portal Microsoft iSCSI Initiator Version 10.0 Build 17763 The operation completed successfully. TIMER(0.209): Refresh target portal Microsoft iSCSI Initiator Version 10.0 Build 17763 The target has already been logged in via an iSCSI session. Microsoft iSCSI Initiator Version 10.0 Build 17763 The target has already been logged in via an iSCSI session. Resolve-Path : Cannot find path 'C:\Program Files\Delphix\DelphixConnector\42091151-c7c5-bee5-1b43-c195d53543a8-staging-4\DATA' because it does not exist. At C:\Program Files\Delphix\DelphixConnector\42091151-c7c5-bee5-1b43-c195d53543a8-staging-4\SCRIPT\MountLunData.ps1:274 char:23 + $resolvedMountpath = (Resolve-Path -LiteralPath "$mountpath").Path + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ + CategoryInfo : ObjectNotFound: (C:\Program File...-staging-4\DATA:String) [Resolve-Path], ItemNotFoundException + FullyQualifiedErrorId : PathNotFound,Microsoft.PowerShell.Commands.ResolvePathCommand Get-WmiObject : Provider load failure At C:\Program Files\Delphix\DelphixConnector\42091151-c7c5-bee5-1b43-c195d53543a8-staging-4\SCRIPT\MountLunData.ps1:238 char:12 + $obj = Get-WmiObject -namespace root/wmi -query "select SessionId ... + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ + CategoryInfo : InvalidOperation: (:) [Get-WmiObject], ManagementException + FullyQualifiedErrorId : GetWMIManagementException,Microsoft.PowerShell.Commands.GetWmiObjectCommand die : Error: Login to target 10.16.27.99 (port 3260) failed: -268500929 At C:\Program Files\Delphix\DelphixConnector\42091151-c7c5-bee5-1b43-c195d53543a8-staging-4\SCRIPT\MountLunData.ps1:26 char:9 + die "$($args[0])" + ~~~~~~~~~~~~~~~~~ + CategoryInfo : NotSpecified: (:) [Write-Error], WriteErrorException + FullyQualifiedErrorId : Microsoft.PowerShell.Commands.WriteErrorException,die


    </dx-labeled-value>
    </dx-base-dialog></shr-error-dialog></mat-dialog-container>

    </dx-labeled-value>
    </dx-base-dialog></shr-error-dialog></mat-dialog-container>

    ------------------------------
    Rajat Solanki
    TCS
    Delphix Community Members
    ------------------------------


  • 2.  RE: Delphix Virtualization - Initial load fails after creating dSource - MS SQL Server

    Posted 07-12-2021 08:33:00 AM
    Hello,

    I see two errors of concern:
    1. For the first one "Get-WmiObject : Provider load failure", we usually see the error "Provider load failure" when there is some type of resource issue on the Windows server such as lack of free memory. Is there sufficient free memory (10% or more) for the operating system to do its work? Can you run the command "Get-WmiObject -Class Win32_MountPoint" interactively from a PowerShell command prompt?
    2. For the second one "Error: Login to target 10.16.27.99 (port 3260) failed: -268500929", it might be a result of the first but it could also indicate a firewall issue. Is port 3260 open between the Windows host and the Delphix Engine? The Windows host needs to connect to port 3260 on the Delphix Engine. You can test connectivity using this PowerShell command:
      New-Object System.Net.Sockets.TcpClient("10.16.27.99", "3260")
    There are a few other rare scenarios where the iSCSI Initiator on Windows gets into an odd state. This KB helps:
      https://support.delphix.com/Delphix_Virtualization_Engine/MSSQL_Server/Resolving_iSCSI_LUN_Discovery_Failures_on_Windows_Machines_(KBA1613)

    Thanks,
      Neal

    ------------------------------
    Neal Stack
    Senior Principal Technical Support Engineer
    Delphix
    ------------------------------



  • 3.  RE: Delphix Virtualization - Initial load fails after creating dSource - MS SQL Server

    Posted 07-12-2021 09:09:00 AM
    Hi Neal,

    I have checked based on your suggestions.
    Get-WmiObject command works fine from Powershell Command-prompt.
    Regarding the second point of testing the connectivity, I ran the command in the target environment and got the following output:

    Do you see any problems above ?

    Thanks,

    ------------------------------
    Rajat Solanki
    TCS
    Delphix Community Members
    ------------------------------



  • 4.  RE: Delphix Virtualization - Initial load fails after creating dSource - MS SQL Server
    Best Answer

    Posted 07-12-2021 09:17:00 AM
    Hello,

    It says "Connected" is "True" so it seems like there is no issue with a firewall.

    Did you check the KB article. Is the iSCSI Initiator in a good state?

    Is this a sporadic failure or is it happening all the time?

    This looks like a much more complicated issue than what we normally address in a community post and I would recommend raising a support ticket and generating a support bundle ( https://support.delphix.com/Delphix_Virtualization_Engine/Delphix_Admin/Creating_and_Uploading_Support_Bundle_to_Delphix_(KBA1459) ) and uploading it to our upload site (https://upload.delphix.com).

    Thanks,
      Neal

    ------------------------------
    Neal Stack
    Senior Principal Technical Support Engineer
    Delphix
    ------------------------------



  • 5.  RE: Delphix Virtualization - Initial load fails after creating dSource - MS SQL Server

    Posted 07-12-2021 09:47:00 AM
    Hi Neal,

    Yes, I went through the article you have shared. The initiator is in "connected" state and doesn't have any issues mentioned in the article.

    But apart from that, when I check disk management in the target environment, I don't see any disk shown for the iSCSI initiator. Could this be an issue? Do I need to add an iSCSI virtual disk in Delphix engine server?

    Based on your response I'll raise a support ticket.

    Thanks


    ------------------------------
    Rajat Solanki
    TCS
    Delphix Community Members
    ------------------------------



  • 6.  RE: Delphix Virtualization - Initial load fails after creating dSource - MS SQL Server

    Posted 07-12-2021 09:50:00 AM
    Hello,

    Delphix manages the disks itself so you don't need to. The script that is failing "MountLunData.ps1" is trying to mount them.

    I think it would be best to log a ticket.

    Thanks,
      Neal

    ------------------------------
    Neal Stack
    Senior Principal Technical Support Engineer
    Delphix
    ------------------------------