Error While Checking Data Source

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

Error While Checking Data Source

Environment

Release: AOATAM99000-8.0-Automic-One Automation Tools-Application Manager
Component:

Resolution

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.

or

U0003531 Error while checking data source (e.g. code conversion or driver problem, see log file).

Investigation

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

Solution

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'

AND

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:

;SP=NLS_LANGUAGE=AMERICAN,NLS_TERRITORY=AMERICA,CODESET=WE8ISO8859P15