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.

Sign up for GitHub

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

Jump to bottom

xSQLServerSetup: Getting warnings when running integration test #798

Closed
johlju opened this issue Sep 11, 2017 · 0 comments · Fixed by #800
Closed

xSQLServerSetup: Getting warnings when running integration test #798

johlju opened this issue Sep 11, 2017 · 0 comments · Fixed by #800
Labels
enhancement The issue is an enhancement request.

Comments

@johlju
Copy link
Member

johlju commented Sep 11, 2017

Details of the scenario you tried and the problem that is occurring:
When running the integration test for this resource I'm seeing a lot of warnings. After a quick search it seems to be because the AppVeyor build worker has the Azure SQL cmdlets installed.

https://social.technet.microsoft.com/Forums/ie/en-US/35b0bf59-b554-46f2-86cd-27e3773c6505/importmodule-sqlps-disablenamechecking-is-returning-a-bunch-of-warnings-i-do-not-want-to-see-in?forum=sqlkjmanageability

[APPVYR-WIN]:                            [[xSQLServerSetup]Integration_Test] Could not obtain SQL Server Service information. An attempt to connect to WMI on 'Microsoft.WindowsAzure.Commands.SqlDatabase.Types.ps1xml' failed with the following error: The RPC server is unavailable. (Exception from HRESULT: 0x800706BA)
[APPVYR-WIN]:                            [[xSQLServerSetup]Integration_Test] Could not obtain SQL Server Service information. An attempt to connect to WMI on 'Microsoft.WindowsAzure.Commands.SqlDatabase.Types.ps1xml' failed with the following error: The RPC server is unavailable. (Exception from HRESULT: 0x800706BA)
[APPVYR-WIN]:                            [[xSQLServerSetup]Integration_Test] Could not obtain SQL Server Service information. An attempt to connect to WMI on 'Microsoft.WindowsAzure.Commands.SqlDatabase.Types.ps1xml' failed with the following error: The RPC server is unavailable. (Exception from HRESULT: 0x800706BA)
[APPVYR-WIN]:                            [[xSQLServerSetup]Integration_Test] Could not obtain SQL Server Service information. An attempt to connect to WMI on 'Microsoft.WindowsAzure.Commands.SqlDatabase.Types.ps1xml' failed with the following error: The RPC server is unavailable. (Exception from HRESULT: 0x800706BA)
[APPVYR-WIN]:                            [[xSQLServerSetup]Integration_Test] Could not obtain SQL Server Service information. An attempt to connect to WMI on 'Microsoft.WindowsAzure.Commands.SqlDatabase.Types.ps1xml' failed with the following error: The RPC server is unavailable. (Exception from HRESULT: 0x800706BA)
[APPVYR-WIN]:                            [[xSQLServerSetup]Integration_Test] Could not obtain SQL Server Service information. An attempt to connect to WMI on 'Microsoft.WindowsAzure.Commands.SqlDatabase.dll' failed with the following error: The RPC server is unavailable. (Exception from HRESULT: 0x800706BA)
[APPVYR-WIN]:                            [[xSQLServerSetup]Integration_Test] Could not obtain SQL Server Service information. An attempt to connect to WMI on 'Microsoft.WindowsAzure.Commands.SqlDatabase.dll' failed with the following error: The RPC server is unavailable. (Exception from HRESULT: 0x800706BA)
[APPVYR-WIN]:                            [[xSQLServerSetup]Integration_Test] Could not obtain SQL Server Service information. An attempt to connect to WMI on 'Microsoft.WindowsAzure.Commands.SqlDatabase.dll' failed with the following error: The RPC server is unavailable. (Exception from HRESULT: 0x800706BA)
[APPVYR-WIN]:                            [[xSQLServerSetup]Integration_Test] Could not obtain SQL Server Service information. An attempt to connect to WMI on 'Microsoft.WindowsAzure.Commands.SqlDatabase.dll' failed with the following error: The RPC server is unavailable. (Exception from HRESULT: 0x800706BA)
[APPVYR-WIN]:                            [[xSQLServerSetup]Integration_Test] Could not obtain SQL Server Service information. An attempt to connect to WMI on 'Microsoft.WindowsAzure.Commands.SqlDatabase.dll' failed with the following error: The RPC server is unavailable. (Exception from HRESULT: 0x800706BA)

I will try to solve this one when I send in a PR to fix another issue.

The DSC configuration that is using the resource (as detailed as possible):
n/a

Version of the Operating System, SQL Server and PowerShell the DSC Target Node is running:
SQL Server 2016

What module (SqlServer or SQLPS) and which version of the module the DSC Target Node is running:
n/a

Version of the DSC module you're using, or 'dev' if you're using current dev branch:
Dev
@johlju johlju added enhancement The issue is an enhancement request. in progress The issue is being actively worked on by someone. labels Sep 11, 2017
johlju added a commit to johlju/SqlServerDsc that referenced this issue Sep 11, 2017
@johlju
Changes to xSQLServerSetup
6c030aa 
- Fixed so integration test does not write warnings when SQLPS module is loaded
  (issue dsccommunity#798).
johlju added a commit to johlju/SqlServerDsc that referenced this issue Sep 11, 2017
@johlju
Changes to xSQLServerSetup
0a27325 
- Fixed so integration test does not write warnings when SQLPS module is loaded
  (issue dsccommunity#798).
johlju added a commit to johlju/SqlServerDsc that referenced this issue Sep 11, 2017
@johlju
Changes to xSQLServerSetup
38ccf34 
- Fixed so integration test does not write warnings when SQLPS module is loaded
  (issue dsccommunity#798).
johlju added a commit to johlju/SqlServerDsc that referenced this issue Sep 11, 2017
@johlju
Changes to xSQLServerSetup
970cf0f 
- Fixed so integration test does not write warnings when SQLPS module is loaded
  (issue dsccommunity#798).
johlju added a commit to johlju/SqlServerDsc that referenced this issue Sep 11, 2017
@johlju
Changes to xSQLServerSetup
67a31cb 
- Fixed so integration test does not write warnings when SQLPS module is loaded
  (issue dsccommunity#798).
@johlju johlju mentioned this issue Sep 11, 2017
Merged
5 tasks
johlju added a commit that referenced this issue Sep 12, 2017
@johlju
xSQLServer: Using correct assemblies for module SqlServer (#800)
c68733c 
- Changes to xSQLServer
  - Updated appveyor.yml so that integration tests run in order and so that
    the SQLPS module folders are renamed to not disturb the units test, but
    can be renamed back by the integration tests xSQLServerSetup so that the
    integration tests can run successfully.
    (issue #774).
- Changes to xSQLServerHelper
  - Changes to Connect-SQL and Import-SQLPSModule
    - Now it correctly loads the correct assemblies when SqlServer module is
      present (issue #649).
    - Now SQLPS module will be correctly loaded (discovered) after installation
      of SQL Server. Previously resources depending on SQLPS module could fail
      because SQLPS was not found after installation because the PSModulePath
      environment variable in the (LCM) PowerShell session did not contain the new
      module path.
- Changes to xSQLServerSetup
  - Fixed so that the integration test renames back the SQLPS module folders if
    they was renamed by AppVeyor (in the appveyor.yml file).
    (issue #774).
  - Fixed so integration test does not write warnings when SQLPS module is loaded
    (issue #798).
@johlju johlju removed the in progress The issue is being actively worked on by someone. label Oct 27, 2017
@johlju johlju removed their assignment Oct 27, 2017
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
enhancement The issue is an enhancement request.
Projects
None yet
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

xSQLServer: Using correct assemblies for module SqlServer johlju/SqlServerDsc
1 participant
@johlju