MID Server DataSource error "Caught java.security.InvalidAlgorithmParameterException while initializing EncryptionManager. See attached Throwable for details. ERRORCODE=-4223, SQLSTATE=null"


Description

MID Server authentication error "Caught java.security.InvalidAlgorithmParameterException while initializing EncryptionManager. See attached Throwable for details. ERRORCODE=-4223, SQLSTATE=null" from DataSource

Steps to Reproduce:
1. log in to instance: xxxxxx
2. go to the data sourceĀ 
3. Select the UI action "Test load 20 records"
4. ConfirmĀ the error

Release or Environment

ALL

Cause

The connection URL did not include "encryptionAlgorithm" and should like something like this:

Connection URL: jdbc:db2://xx.xx.xx.xx:1234/SNMA:securityMechanism=9;currentSchema=YYYYYYYY;sslConnection=true;encryptionAlgorithm=2;

https://docs.servicenow.com/bundle/paris-platform-administration/page/administer/encryption/concept/encryption.html

https://docs.servicenow.com/bundle/quebec-platform-administration/page/administer/encryption/concept/db-full-disk-encryption.html

- encryption types = AES-256

Resolution

Make a change to the connection URL to include "encryptionAlgorithm" which was not there before