Get-RDMSession is not returning my sessions consistently on Windows 2016 server
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
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.
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
Thanks Erica, that seemed to do the trick on all the systems.