Get-RDMSession is not returning my sessions consistently on Windows 2016 server

Get-RDMSession is not returning my sessions consistently on Windows 2016 server

avatar

running on RDM ver: 12.5.4.0
using remote SQL 2014 database
using AD credential to connect to SQL database
AD credential has Administrator permissions

PowerShell version on Windows 2016

Major Minor Build Revision
----- ----- ----- --------
5 1 14393 1066




same code seems to be working consistently on Windows 8.1
PowerShell version on Windows 8.1

Major Minor Build Revision
----- ----- ----- --------
5 0 10586 117







$datasource = $null;
$msgstr = $null;
$securesvcpass = $null;

#Get the data source to use
Write-MOXLog ("[Line# " + (Get-MOXCurrentLineNumber) + "] Get-RDMDataSource -Name $remoteDataSourceName");
try { $datasource = Get-RDMDataSource -Name $remoteDataSourceName -ErrorAction Stop }
catch { $msgstr = "Error: Failed to get datasource $remoteDataSourceName -> $($_.Exception.Messagee)" Write-MOXLog ("[Line# " + (Get-MOXCurrentLineNumber) + "] $msgstr"); $issueFound = $true }


#set the retrieved datasource as the current datasource
if ($issueFound -eq $false)
{
Write-MOXLog ("[Line# " + (Get-MOXCurrentLineNumber) + "] ConvertTo-SecureString");
try { $securesvcpass = ConvertTo-SecureString $($cred.svcpwd) -asplaintext -force -ErrorAction Stop }
catch { $msgstr = "Error: Failed ConvertTo-SecureString -> $($_.Exception.Messagee)" Write-MOXLog ("[Line# " + (Get-MOXCurrentLineNumber) + "] $msgstr"); $issueFound = $true }

Write-MOXLog ("[Line# " + (Get-MOXCurrentLineNumber) + "] Set-RDMCurrentDataSource -ID $($datasource.ID) -Username $($cred.svcacct) -Password `$securesvcpass");
try { Set-RDMCurrentDataSource -ID $datasource.ID -Username $($cred.svcacct) -Password $securesvcpass -ErrorAction Stop }
catch { $msgstr = "Error: Failed Set-RDMCurrentDataSource -> $($_.Exception.Messagee)" Write-MOXLog ("[Line# " + (Get-MOXCurrentLineNumber) + "] $msgstr"); $issueFound = $true }
}




Get-RDMCurrentDataSource
$Lists = Get-RDMSession -IncludeSubFolders
$Lists.count

All Comments (3)

avatar

Issue does not appear to be limited to just Windows 2016. Able to duplicate issues on Windows 2012 R2 server also. Notice that Win 8.1 now behaving the same and not pull any data also. The original PowerShell ISE session can on the windows 8.1 box is still pull all the sessions from the SQL db though.

avatar

Hello,

I am unable to reproduce this issue on our environment. It looks like it is related to the local cache file.

Could you please disable the Caching mode in your data source configuration to see if this helps?



Best regards,

Érica Poirier

avatar

Thanks Erica, that seemed to do the trick on all the systems.