locked
Install-CsDatabase -Update "The network path was not found" RRS feed

  • Question

  • Hello,

    We've run into a strange problem. We have two Enterprise Edition Skype for Business 2015 pools in our deployment. We ran a cumulative update January 2019 over the weekend and wanted to update databases as well.

    The update on the secondary pool database went fine, however update on the primary pool database throws a strange error:

    Connection: Data Source=sql2.contoso.com\i02;Initial Catalog=xds;Integrated Security=True;Application Name=Microsoft.Rtc.Management   
    
     └ ▼ Action
    
         └    Root domain: contoso.com. 
         └    Root domain: contoso.com.
         └    Filter: (&((ObjectCategory Equal person)(ObjectClass Equal user)(Sid Equal <edited out>))) 
         └    Found   
         └    User: <edited out> 
         └    Group security identifier (SID): <edited out> 
         └    HasToken: False  
         └    Check Groups
    
     └    Error: An error occurred: "System.IO.IOException" "The network path was not found." 
     └    Error: The network path was not found.  
    ▼ Details 
    └ Type: IOException 
    └ ▼ Stack Trace 
        └   at Microsoft.Win32.RegistryKey.Win32ErrorStatic(Int32 errorCode, String str) 
    at Microsoft.Win32.RegistryKey.OpenRemoteBaseKey(RegistryHive hKey, String machineName, RegistryView view) 
    at Microsoft.Rtc.Management.Deployment.InstallDatabaseCmdlet.CheckIsWarningNeeded(String sqlServer, String instanceName) 
    at Microsoft.Rtc.Management.Deployment.InstallDatabaseCmdlet.ExecutePlan(String host) 
    at Microsoft.Rtc.Management.Deployment.InstallDatabaseCmdlet.CreateDatabasesForMachine(IMachine machine, String forInstance) 
    at Microsoft.Rtc.Management.Deployment.InstallDatabaseCmdlet.CreateDatabasesForFqdn(Fqdn sqlServerFqdn, String forInstance) 
    at Microsoft.Rtc.Management.Deployment.InstallDatabaseCmdlet.CreateDatabases() 
    at Microsoft.Rtc.Management.Deployment.InstallDatabaseCmdlet.InternalProcessRecord() 
    at Microsoft.Rtc.Management.Deployment.DeploymentCmdlet.CmdletProcessRecord() 

    Both databases are on single MS SQL servers (no mirroring, no availability group)

    What puzzles me the most is that error when trying to run this against sql1.contoso.com shows that Data Source=sql2.contoso.com

    Commands tried:

    Install-CsDatabase -Update -ConfiguredDatabases -SqlServerFqdn sql1.contoso.com
    Install-CsDatabase -Update -SqlServerFqdn sql1.contoso.com -SqlInstanceName i01 -DatabaseType User

    Test-CsDatabase command runs successfully against both SQL servers.

    Any ideas, please? I already verified Network Discovery is turned on on sql1.contoso.com.

    Monday, February 25, 2019 11:53 AM

Answers

All replies

  • Hi Tomas,

    According to your description, the database is on the single SQL Server without mirroring or always-on, and the network discovery is turned on. 

    For this issue, please confirm whether you have deployed Archiving or Monitoring database in your environment, if you have deployed, please run the following command: Install-CsDatabase -Update -ConfiguredDatabases -SqlServerFqdn <SQL Server FQDN>  -ExcludeCollocatedStores. 

    In addition, please check the firewall in your environment, please make sure you have turned on the tcp port of 1433. You could refer to the similar case to find the details. 

    Best Regards,
    Evan Jiang


    Please remember to mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact tnsf@microsoft.com.


    Click here to learn more. Visit the dedicated forum to share, explore and talk to experts about Microsoft Teams.

    Tuesday, February 26, 2019 3:21 AM
  • Hello Evan,

    Thank you for replying. I have tried the command with -ExcludeCollocatedStores flag, but the result is exactly the same. I do have tcp/1433, udp/1434 and also the actual port the database runs on accessible. We have deployed both Monitoring and Archiving.

    Best Regards,

    Tomas

    Tuesday, February 26, 2019 7:31 AM
  • Hi Tomas,

    Please check whether there’s any Event errors in your FE Servers when you run the Install-CsDatabase command. 

    In addition, as you said, Test-CsDatabase command runs successfully against both SQL servers, it seems there’s no issue with the SQL, please try to run the following command to check the version whether has been updated:
    Test-CsDatabase -ConfiguredDatabases -SqlServerFqdn sql.contoso.com | ft databasen*,Expe*,Inst*,Suc* -AutoSize

    Best Regards,
    Evan Jiang


    Please remember to mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact tnsf@microsoft.com.


    Click here to learn more. Visit the dedicated forum to share, explore and talk to experts about Microsoft Teams.

    Friday, March 1, 2019 8:32 AM
  • Hello Evan,

    The database needs an update:

    DatabaseName ExpectedVersion InstalledVersion Succeed
    ------------ --------------- ---------------- -------
    rtcxds       15.13.13        15.13.11            True
    rtcshared    5.0.2           5.0.1               True
    rtcab        62.42.13        62.42.12            True
    rgsconfig    5.5.2           5.5.1               True
    rgsdyn       2.2.2           2.2.1               True
    cpsdyn       1.1.3           1.1.2               True
    LcsLog       24.40.3         24.40.2             True
    LcsCDR       39.85.11        39.85.10            True
    QoEMetrics   62.93.13        62.93.12            True
    mgc          1.42.3          1.42.2              True
    xds          10.15.5         10.15.4             True
    lis          3.1.2           3.1.1               True
    I don't see anything in Event Viewer that would be specific to this. Only GroupPickup service is complaining that it cannot start, because the database is not upgraded.


    Friday, March 1, 2019 10:05 AM
  • Hi Tomas,

    Please also try to check whether you have turn on network discovery in the SQL Server as below:

    If you did not turn on it, please turn on then check again. 

    Best Regards,
    Evan Jiang


    Please remember to mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact tnsf@microsoft.com.


    Click here to learn more. Visit the dedicated forum to share, explore and talk to experts about Microsoft Teams.

    Wednesday, March 6, 2019 7:28 AM
  • Thank you very much, it was indeed the Remote Registry service that was disabled on that one SQL server.
    Monday, March 25, 2019 1:18 PM