Clarity database is Unavailable due to mismatched encryption

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

Clarity CSA shows database Unavailable for both Clarity and DWH, error is thrown in logs upon debugging:

• Connection failed. Verify all connection parameters and confirm that the appropriate driver is installed.
• [CA Clarity][Oracle JDBC Driver]arraycopy: destination index -1 out of bounds for byte[128]

Environment

All Supported Clarity releases with Oracle

Cause

JDBC URL is set up with encryption whilst the Clarity database is not set up with encryption

Resolution

• In JDBC URL remove any encryption parameters.
• Example of parameters that cannot be used with a database without encryption
  • ;DataIntegrityLevel=requested;EncryptionLevel=requested
• This is how the final JDBC URL should look (example):
  url="jdbc:clarity:oracle://SERVERNAME:1521;ServiceName=CLARITY;BatchPerformanceWorkaround=true;InsensitiveResultSetBufferSize=0;ServerType=dedicated;supportLinks=true"

• Restart all services