Powershell: Get-RDMDataSource -Name "xxx" not working from Powershell

Powershell: Get-RDMDataSource -Name "xxx" not working from Powershell

avatar

I have a strange behaviour with the PowerShell-Module. If i run the command "Get-RDMDataSource -Name "OC" from the PowerShell i get the error message:

PSArgumentException - Cannot process the argument because the value of activity cannot be null or empty.

at System.Management.Automation.ProgressRecord..ctor(Int32 activityId, String activity, String statusDescription)
at Devolutions.RemoteDesktopManager.Managers.UIManager.HideWaitProgress()
at Devolutions.RemoteDesktopManager.Managers.RepositoryManager.Refresh(Boolean force)
at Devolutions.RemoteDesktopManager.Managers.SecurityManager.LoadSecurity(BaseConnectionDataSource dataSource)
at Devolutions.RemoteDesktopManager.Managers.ConnectionManager.LoadConnectionsFromDataSource(ConnectionEngine engine, Boolean hasChanged)
at Devolutions.RemoteDesktopManager.Managers.ConnectionManager.LoadConnections(BaseConnectionDataSource dataSource)

When I run the command in PowerShell as adminsitrator I get the error message:

Get-RDMDataSource : Cannot validate argument on parameter 'Name'. The argument "OC" does not belong to the set "Local Data Source" specified by the ValidateSet
attribute. Supply an argument that is in the set and then try the command again.
At line:1 char:25
+ Get-RDMDataSource -Name "OC"
+ ~~~~
+ CategoryInfo : InvalidData: (:) [Get-RDMDataSource], ParameterBindingValidationException
+ FullyQualifiedErrorId : ParameterArgumentValidationError,RemoteDesktopManager.PowerShellModule.GetRDMDatasourceCommand

If i run the the command inside the ISE everything works fine.

Get-RDMDataSource -Name "OC"

ID : xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx
IsConnected : True
IsOffline : False
Name : OC
Type : SQLServer

Any thougths on this?

Kind regards
Matthias

All Comments (13)

avatar

Hello,

What data source type are you using?

What PowerShell version are you using?

Could you please run the Get-RDMDiagnostic and post the result here?

About when you open PowerShell as an administrator, because it runs in a different user context, your RDM configuration cannot be reached in the administrator user context. So in that case, you won't be able to connect on the data source.

Best regards,

Érica Poirier

avatar

Hi,

the data source type is SQL-Server.

PowerShell version:

Name Value
---- -----
PSVersion 5.1.22000.282
PSEdition Desktop
PSCompatibleVersions {1.0, 2.0, 3.0, 4.0...}
BuildVersion 10.0.22000.282
CLRVersion 4.0.30319.42000
WSManStackVersion 3.0
PSRemotingProtocolVersion 2.3
SerializationVersion 1.1.0.1

Get-RDMDiagnostic : The term 'Get-RDMDiagnostic' is not recognized as the name of a cmdlet, function, script file, or operable program. Check the spelling of the name,
or if a path was included, verify that the path is correct and try again.

Kind regards,
Matthias

avatar

Hello,

Thank you for your feedback.

What RDM version are you using?

Best regards,

Érica Poirier

avatar

Remote Desktop Manager Enterprise Version
2022.1.16.0 64-bit

avatar

Hello,

What is the result when you run the Get-RDMInstance cmdlet?

If that cmdlet cannot run, have you installed the RDM PowerShell module from PSGallery?
https://kb.devolutions.net/kb_rdmpowershellcore.html

Best regards,

Érica Poirier

avatar

Hello,

the output:

Get-RDMInstance
PSArgumentException - Cannot process the argument because the value of activity cannot be null or empty.

at System.Management.Automation.ProgressRecord..ctor(Int32 activityId, String activity, String statusDescription)
at Devolutions.RemoteDesktopManager.Managers.UIManager.HideWaitProgress()
at Devolutions.RemoteDesktopManager.Managers.RepositoryManager.Refresh(Boolean force)
at Devolutions.RemoteDesktopManager.Managers.SecurityManager.LoadSecurity(BaseConnectionDataSource dataSource)
at Devolutions.RemoteDesktopManager.Managers.ConnectionManager.LoadConnectionsFromDataSource(ConnectionEngine engine, Boolean hasChanged)
at Devolutions.RemoteDesktopManager.Managers.ConnectionManager.LoadConnections(BaseConnectionDataSource dataSource)

ApplicationVersion OptionFilename
------------------ --------------
2022.1.0.5 C:\Users\mph\AppData\Local\Devolutions\RemoteDesktopManager\RemoteDesktopManager.cfg

avatar

Hello,

Could you please update the RDM PowerShell module to version 2022.1.1.0 with the following command?

Update-Module -Name RemoteDesktopManager


Let me know if you get the correct version with Get-RDMInstance and if that helps to solve your issue.

Best regards,

Érica Poirier

avatar

Hi,

I´ve removed the old module and reinstalled the new module. But I still get the same error:

PS C:\Users\mph> Get-RDMDiagnostic
PSArgumentException - Das Argument kann nicht verarbeitet werden, da der Wert von "activity" nicht NULL oder leer sein darf.

bei System.Management.Automation.ProgressRecord..ctor(Int32 activityId, String activity, String statusDescription)
bei Devolutions.RemoteDesktopManager.Managers.UIManager.ShowWaitProgress(String message, Action action)
bei Devolutions.RemoteDesktopManager.Managers.ConnectionManager.ShowFirstLoadWaitInProgress()
bei Devolutions.RemoteDesktopManager.Managers.ConnectionManager.LoadConnections(BaseConnectionDataSource dataSource)
PSArgumentException - Das Argument kann nicht verarbeitet werden, da der Wert von "activity" nicht NULL oder leer sein darf.

bei System.Management.Automation.ProgressRecord..ctor(Int32 activityId, String activity, String statusDescription)
bei Devolutions.RemoteDesktopManager.Managers.UIManager.HideWaitProgress()
bei Devolutions.RemoteDesktopManager.Managers.RepositoryManager.Refresh(Boolean force)
bei Devolutions.RemoteDesktopManager.Managers.SecurityManager.LoadSecurity(BaseConnectionDataSource dataSource)
bei Devolutions.RemoteDesktopManager.Managers.ConnectionManager.LoadConnectionsFromDataSource(ConnectionEngine engine, Boolean hasChanged)
bei Devolutions.RemoteDesktopManager.Managers.ConnectionManager.LoadConnections(BaseConnectionDataSource dataSource)
PSArgumentException - Das Argument kann nicht verarbeitet werden, da der Wert von "activity" nicht NULL oder leer sein darf.

bei System.Management.Automation.ProgressRecord..ctor(Int32 activityId, String activity, String statusDescription)
bei Devolutions.RemoteDesktopManager.Managers.UIManager.HideWaitProgress()
bei Devolutions.RemoteDesktopManager.Managers.RepositoryManager.Refresh(Boolean force)
bei Devolutions.RemoteDesktopManager.Managers.SecurityManager.LoadSecurity(BaseConnectionDataSource dataSource)
bei Devolutions.RemoteDesktopManager.Managers.ConnectionManager.LoadConnectionsFromDataSource(ConnectionEngine engine, Boolean hasChanged)
bei Devolutions.RemoteDesktopManager.Managers.ConnectionManager.LoadConnections(BaseConnectionDataSource dataSource)

Serial LicenseType IsLicenseValid IsLicenseExpired
------ ----------- -------------- ----------------
Xyz...... Global True False


PS C:\Users\mph> Get-RDMInstance
PSArgumentException - Cannot process the argument because the value of activity cannot be null or empty.

at System.Management.Automation.ProgressRecord..ctor(Int32 activityId, String activity, String statusDescription)
at Devolutions.RemoteDesktopManager.Managers.UIManager.HideWaitProgress()
at Devolutions.RemoteDesktopManager.Managers.RepositoryManager.Refresh(Boolean force)
at Devolutions.RemoteDesktopManager.Managers.SecurityManager.LoadSecurity(BaseConnectionDataSource dataSource)
at Devolutions.RemoteDesktopManager.Managers.ConnectionManager.LoadConnectionsFromDataSource(ConnectionEngine engine, Boolean hasChanged)
at Devolutions.RemoteDesktopManager.Managers.ConnectionManager.LoadConnections(BaseConnectionDataSource dataSource)

ApplicationVersion OptionFilename
------------------ --------------
2022.1.1.0 C:\Users\mph\AppData\Local\Devolutions\RemoteDesktopManager\RemoteDesktopManager.cfg


PS C:\Users\mph> Get-RDMDataSource
PSArgumentException - Cannot process the argument because the value of activity cannot be null or empty.

at System.Management.Automation.ProgressRecord..ctor(Int32 activityId, String activity, String statusDescription)
at Devolutions.RemoteDesktopManager.Managers.UIManager.HideWaitProgress()
at Devolutions.RemoteDesktopManager.Managers.RepositoryManager.Refresh(Boolean force)
at Devolutions.RemoteDesktopManager.Managers.SecurityManager.LoadSecurity(BaseConnectionDataSource dataSource)
at Devolutions.RemoteDesktopManager.Managers.ConnectionManager.LoadConnectionsFromDataSource(ConnectionEngine engine, Boolean hasChanged)
at Devolutions.RemoteDesktopManager.Managers.ConnectionManager.LoadConnections(BaseConnectionDataSource dataSource)


ID : Xyz......
IsConnected : False
IsOffline : False
Name : Xyz......
Type : SQLServer

ID : Xyz......
IsConnected : False
IsOffline : False
Name : Xyz......
Type : SQLServer

avatar

Hello,

Thank you for your feedback.

Our engineer is currently investigating and once an update will be available, we will let you know in this thread.

Thank you for your patience.

Best regards,

Érica Poirier

avatar

Hello,

Thank you for your patience.

Is it possible for you to test a version of the RDM PowerShell module that contains a fix for your issue?

I will send you a zip file in a private message for this test version.

You can unzip the content in a folder and then load this module with the following command. Ensure you are located in the folder where the files are located to load this module in PowerShell.

Import-Module ./RemoteDesktopManager.psd1


Let me know if that helps to solve your issue.

Best regards,

Érica Poirier

avatar

Hello,

sure no problem. I can test the version.

Kind regards
Matthias

avatar

Hello Erica,

I´ve tested the module and everything works fine now.

Kind regards
Matthias

avatar

Hello Matthias,

Thank you for your feedback and glad that it works now.

Our engineering team will add this fix for the next version of the RDM PowerShell module.

Best regards,

Érica Poirier