- Access exclusive content
- Connect with peers
- Share your expertise
- Find support resources
03-13-2025 09:07 PM
Hi all,
Can somebody help me with this? I imported the PSM-SqlDeveloper connection components from the Marketplace and encountered this errorIn the PSM server, I opened the component's ClientDispatcher.log and saw this:
[12/03/2025 | 17:12:12] | :: | PSMDU014E Error performing dispatcher's request [GetSessionPropertyBufferLength]. Reason: PSMDU032E Session property [TnsServiceName] is not present
[12/03/2025 | 17:12:12] |:: | PSMDU018E Dispatcher error: [Parameters:: GetOptionalSessionProperty -> Error while getting parameter TnsServiceName, using default value: ]
[12/03/2025 | 17:12:12] | :: | PSMDU018E Dispatcher error: [Parameters :: GetOptionalSessionProperty -> Error details: System.Exception: Function GetSessionPropertyBufferLength returned with an error.
aAtPSMDispatcherUtilsManaged.PSMDispatcherUtilsWrapper.GetSessionPropertyBufferLength(String stPropName)
At PSMDispatcherUtilsManaged.PSMDispatcherUtilsWrapper.GetSessionProperty(String stPropName)
At CyberArk.PSM.DesktopAppCCInfra.PSMIntegration.PsmWrapper.GetSessionProperty(String propName)
At CyberArk.PSM.OracleSqlDeveloper.Parameters.GetOptionalSessionProperty(IPsmWrapper psmWrapper, String propertyName, String defaultValue)]
[12/03/2025 | 17:12:12] | :: | PSMDU014E Error performing dispatcher's request [GetSessionPropertyBufferLength]. Reason: PSMDU032E Session property [DSN] is not present
[12/03/2025 | 17:12:12] |:: | PSMDU018E Dispatcher error: [Parameters : GetOptionalSessionProperty -> Error while getting parameter DSN, using default value: ]
[12/03/2025 | 17:12:12] | :: | PSMDU018E Dispatcher error: [Parameters :: GetOptionalSessionProperty -> Error details: System.Exception: Function GetSessionPropertyBufferLength returned with an error.
atAtSMDispatcherUtilsManaged.PSMDispatcherUtilsWrapper.GetSessionPropertyBufferLength(String stPropName)
At PSMDispatcherUtilsManaged.PSMDispatcherUtilsWrapper.GetSessionProperty(String stPropName)
At CyberArk.PSM.DesktopAppCCInfra.PSMIntegration.PsmWrapper.GetSessionProperty(String propName)
At CyberArk.PSM.OracleSqlDeveloper.Parameters.GetOptionalSessionProperty(IPsmWrapper psmWrapper, String propertyName, String defaultValue)]
[12/03/2025 | 17:12:12] | :: | PSMDU014E Error performing dispatcher's request [GetSessionPropertyBufferLength]. Reason: PSMDU032E Session property [ProxyID] is not present
[12/03/2025 | 17:12:12] |:: | PSMDU018E Dispatcher error: [Parameters : GetOptionalSessionProperty -> Error while getting parameter ProxyID, using default value: ]
[12/03/2025 | 17:12:12] | :: | PSMDU018E Dispatcher error: [Parameters :: GetOptionalSessionProperty -> Error details: System.Exception: Function GetSessionPropertyBufferLength returned with an error.
atAtSMDispatcherUtilsManaged.PSMDispatcherUtilsWrapper.GetSessionPropertyBufferLength(String stPropName)
At PSMDispatcherUtilsManaged.PSMDispatcherUtilsWrapper.GetSessionProperty(String stPropName)
At CyberArk.PSM.DesktopAppCCInfra.PSMIntegration.PsmWrapper.GetSessionProperty(String propName)
At CyberArk.PSM.OracleSqlDeveloper.Parameters.GetOptionalSessionProperty(IPsmWrapper psmWrapper, String propertyName, String defaultValue)]
[12/03/2025 | 17:12:12] | :: | PSMDU014E Error performing dispatcher's request [GetSessionPropertyBufferLength]. Reason: PSMDU032E Session property [DriverType] is not present
[12/03/2025 | 17:12:12] |:: | PSMDU018E Dispatcher error: [Parameters:: GetOptionalSessionProperty -> Error while getting parameter DriverType, using default value: Oracle]
[12/03/2025 | 17:12:12] | :: | PSMDU018E Dispatcher error: [Parameters :: GetOptionalSessionProperty -> Error details: System.Exception: Function GetSessionPropertyBufferLength returned with an error.
At PSMDispatcherUtilsManaged.PSMDispatcherUtilsWrapper.GetSessionPropertyBufferLength(String stPropName)
At PSMDispatcherUtilsManaged.PSMDispatcherUtilsWrapper.GetSessionProperty(String stPropName)
At CyberArk.PSM.DesktopAppCCInfra.PSMIntegration.PsmWrapper.GetSessionProperty(String propName)
At CyberArk.PSM.OracleSqlDeveloper.Parameters.GetOptionalSessionProperty(IPsmWrapper psmWrapper, String propertyName, String defaultValue)]
[12/03/2025 | 17:12:12] | :: | PSMDU018E Dispatcher error: [SqlDeveloperConfigurationFileUpdater :: UpdateConfigurationFiles -> File SqlDevConfig\ConnectionsTemplate.json does not exist]
I tried to add the missing properties in the Target Settings > Supported Capabilities, but it still does not work.
03-14-2025 02:59 AM
Hi @Nhien
Have you whitelisted the SQL-Developer exe path via AppLocker rule?
https://docs.cyberark.com/pam-self-hosted/latest/en/content/pas%20inst/configure_applocker.htm
03-14-2025 03:05 AM
Hi @Malhar Vora
I didn't harden the PSM server, so there are no AppLocker rules
03-14-2025 04:21 AM
Hi @Nhien
Can you please confirm the version of SQL developer that you are using it?
03-16-2025 11:52 PM
Hi, it seems some issue with SQL developer finding correct java path. Are you using custom java path ? There different connection component related client specific parameters for this connection component. Have you set it correctly ?
03-17-2025 12:13 AM
Hi @Somidi Vamshi
I use the SQL Developer with JDK 11 included, so I don't use any custom Java path. I also don't set any parameters but the SQLDeveloperLocation, I just leave them as default.
04-08-2025 01:06 AM
Hello @Nhien
Have you received an answer to your question? If so, we kindly encourage you to share it with us.
Your insights could be valuable to other community members in the future.
Thank you, Isar.
04-23-2025 04:21 AM
Hi @Nhien,
please check the parameter ConnectionsConfigAppDataLocation and set the version (for example "SQL Developer\system23.1.1.345.2114\o.jdeveloper.db.connection").
Open the Shadow User folder and navigate into AppData\Roaming and check your version.
Nino
04-23-2025 01:55 PM
I have done configuration for Domain account, but not importing from Marketplace. I think the one in Marketplace supports only Local Accounts. I have to test for Local accounts and will let you know.
05-17-2025 02:33 PM
Hello @Nhien
Did you manage to solve the problem? I have the same problem with the Oracle SQL Developer connector
05-19-2025 01:26 AM
Yes, the problem was the extracted destination of the SQLDeveloper.zip tool. I extracted the tool to the desktop, and that caused the error. After I moved the zip file to C:\oracle folder, the problem was solved.
05-19-2025 01:31 AM
I recommend you troubleshoot by logging in to the PSM server as the PSMShadow user
https://community.cyberark.com/s/article/How-to-manually-run-an-application-as-a-PSM-Shadow-User
05-19-2025 01:56 AM
Thank you, I have checked and Oracle SQL Developer runs without a problem from the shadow user level.
However, when I want to connect via RDP file the connecting status takes a very long time - no success.
Click Accept as Solution to acknowledge that the answer to your question has been provided.
The button appears next to the replies on topics you’ve started. The member who gave the solution and all future visitors to this topic will appreciate it!
These simple actions take just seconds of your time, but go a long way in showing appreciation for community members and the LIVEcommunity as a whole!
The LIVEcommunity thanks you for your participation!

