search cancel

Invalid CODESET Parameter in SQLDRIVERCONNECT string


Article ID: 89744


Updated On:


CA Automic Workload Automation - Automation Engine


Invalid CODESET Parameter in SQLDRIVERCONNECT string


Release: AOATAM99000-9.0-Automic-One Automation Tools-Application Manager


Detailed Description and Symptoms
You encounter one of the following errors when attempting to start a WP or CP:
U0029104 Invalid CODESET Parameter in SQLDRIVERCONNECT string.
U0003531 Error while checking data source (e.g. code conversion or driver problem, see log file).


Check the NLS Character Set of the Oracle database and of the Oracle Client.


This message indicates that the database and client are using two different NLS Character Sets.  Confirm that the following match in the log file:

U0003535 DB INFO: 'OCI_NLS_CHARACTER_SET          = WE8ISO8859P15'
U0003535 DB INFO: 'NLS_CHARACTERSET               = WE8ISO8859P15'

*) The NLS_CHARACTERSET must be either WE8ISO8859P15 or WE8ISO8859P1.  If it is not, have your DBA set it to one of those.

*) Your Client will need to use the same NLS Characterset as your Database.  This can be specified in the your SQLDRIVERCONNECT= setting in ucsrv.ini by adding the following after your SQLDRIVERCONNECT= setting and being sure that CODESET= is either WE8ISO8859P15 or WE8ISO8859P1 and matches your database characterset.  Below is an example of this:


Problem Persists:
If you have attempted the above and are still seeing the same error, please send the following to Automic Support:
1) The full log file where this message is being displayed