PSM-SqlDeveloper Error: Warning - could not install some modules

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

PSM-SqlDeveloper Error: Warning - could not install some modules

L1 Bithead

Hi all,

Can somebody help me with this? I imported the PSM-SqlDeveloper connection components from the Marketplace and encountered this errorField_Content_versions_oct20__068Vy00000OsXCTIA3.pngIn 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.

 

14 REPLIES 14

L7 Applicator

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

Hi @Malhar Vora​ 

 

I didn't harden the PSM server, so there are no AppLocker rules Field_Content_versions_oct20__068Vy00000OsMXEIA3.png

L7 Applicator

Hi @Nhien​ 

 

Can you please confirm the version of SQL developer that you are using it?

Hi @Malhar​ 

 

I am currently using sqldeveloper-23.1.0.097.1607-x64

L4 Transporter

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 ?

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.

L1 Bithead

I wonder if anyone successfully configured this PSM-SqlDeveloper connection component. Please help me with this. Thanks guys!

L4 Transporter

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.

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

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.

L0 Member

Hello @Nhien​ 

 

Did you manage to solve the problem? I have the same problem with the Oracle SQL Developer connector 

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.

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

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. Field_Content_versions_oct20__068Vy00000XZ6fTIAT.png

  • 615 Views
  • 14 replies
  • 0 Likes
Like what you see?

Show your appreciation!

Click Like if a post is helpful to you or if you just want to show your support.

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!