Setting SAML to 'Y' in UC_SYSTEM_SETTINGS 'Non supported character set'

book

Article ID: 242242

calendar_today

Updated On:

Products

CA Automic Workload Automation - Automation Engine

Issue/Introduction

When activating SAML by setting the variable to 'Y' in UC_SYSTEM_SETTINGS, it is not working and throws the error: U00003590 UCUDB - DB error: '99999', 'Non supported character set (add orai18n.jar in your classpath): WE8ISO8859P15', '17056', 'java.sql.SQLException'

WP log shows something similar to:
20220512/132701.484 - 27     U00003434 Server routine  'SamlMessageHandler/TIMER' required '0' minutes and '3' seconds for processing.
20220512/132701.485 - 27     U00003590 UCUDB - DB error: '99999', 'Non supported character set (add orai18n.jar in your classpath): WE8ISO8859P15', '17056', 'java.sql.SQLException'
20220512/132701.485 - 27               SQL Statement which caused this DB error:
20220512/132701.486 - 27     U02012075 Set bind parameter '1' of type 'Integer' to value '50038'
20220512/132701.486 - 27     U02012075 Set bind parameter '2' of type 'XMLType' to value '[email protected]'
20220512/132701.486 - 27     U02012075 Set bind parameter '3' of type 'String' to value '*SP'
20220512/132701.486 - 27               INSERT INTO OVW (OVW_OH_Idnr,OVW_ValueX,OVW_VValue) VALUES (?,?,?)
20220512/132701.487 - 27     U00045014 Exception 'com.automic.database.api.DBException: "INSERT INTO OVW (OVW_OH_Idnr,OVW_ValueX,OVW_VValue) VALUES (?,?,?)"' at 'com.automic.database.impl.DBConnectionImpl.executeInternal():573'.
20220512/132701.487 - 27     U00045015 The previous error was caused by 'java.sql.SQLException: "Non supported character set (add orai18n.jar in your classpath): WE8ISO8859P15"' at 'oracle.sql.CharacterSetUnknown.failCharsetUnknown():231'.
20220512/132701.488 - 27     U00003620 Routine 'com.automic.kernel.impl.DBAction' forces trace because of error.

Environment

Release : 21.0.2

Component :

Resolution

This was resolved by setting classpath in the user's environment variable to the directory that includes the orai18n.jar file.