UC_SAML_SETTINGS not auto populating *SP key.

Products

• CA Automic One Automation

Issue/Introduction

Changing SAML from N to Y in UC_SYSTEM_SETTINGS does not create the *SP entry in the variable UC_SAML_SETTINGS. The JWP shows the following exception.

com.automic.database.api.DBException: INSERT INTO OVW (OVW_OH_Idnr,OVW_ValueX,OVW_VValue) VALUES (?,?,?)
Caused by: java.sql.SQLException: Non supported character set (add orai18n.jar in your classpath): WE8ISO8859P15

Environment

Release : 12.3

Component : AUTOMATION ENGINE

Database: Oracle 19c

Cause

Configuration.

Resolution

The AutomationEngine/bin/lib folder contained the ojdbc7.jar file. Once this was replaced with the ojdbc8.jar the *SP entry was created.