ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

UC_SAML_SETTINGS not auto populating *SP key.

book

Article ID: 227512

calendar_today

Updated On:

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

Cause

Configuration.

Environment

Release : 12.3

Component : AUTOMATION ENGINE

Database: Oracle 19c

Resolution

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