A database collector of type Oracle fails when pressing the Test Connection button with the following error message:
10/07/2021 09:03:46.203 ERROR (Thread-825 (ActiveMQ-client-global-threads)) [com.aveksa.server.utils.NodeMessageBroker] Exception while getting test data from collector com.aveksa.server.runtime.ServerException: com.aveksa.common.DataReadException: Could not get user data.. Caused by com.aveksa.common.DataReadException: Could not read data from resultset. Caused by java.sql.SQLException: Non supported character set (add orai18n.jar in your classpath): IW8ISO8859P8 Caused By
This is a known issue in the following versions when connecting against Oracle databases that use international character sets:
For the Wildfly server, add the files orai18n-19.3.0.0.jar and module.xml to the directory $AVEKSA_HOME/wildfly/modules/com/oracle/main. Restart acm for the changes to take effect.
For remote Aveksa Agents, add the files orai18n-19.3.0.0.jar and module.xml to the directory AveksaAgent/common/lib. Restart the aveksa agent for the changes to take effect.
Please contact RSA Customer Support and quote this article number to obtain the required files, orai18n-19.3.0.0.jar and module.xml.