DB Load error ORA-64204 : encountered partial multibyte character

Products

• CA Automic Workload Automation - Automation Engine
• CA Automic One Automation

Issue/Introduction

Installing Automic Workload Automation v21.0.x. During the database load the following error is returned:

U00003590 UCUDB - DB error: 'OCIStmtExecute', 'ERROR   ', '', 'ORA-64204: encountered partial multibyte character'

Environment

Release : 21.0.2

Component : DBLoad Utility

Cause

The Oracle database is using the multibyte character set AL32UTF8

The ODBC connection string in ucsrv.ini file was using the same:

SP=NLS_LANGUAGE=AMERICAN,NLS_TERRITORY=AMERICA,CODESET=AL32UTF8

 

 

Resolution

The codeset and character set are not the same thing. The character set is what the database uses and can be multibyte, the codeset is what the client uses to communicate with the character set specified in the database and MUST be single-byte. 

For Oracle, Automic supports 3 codesets in ucsrv.ini: 

WE8ISO8859P1, WE8ISO8859P15 or WE8MSWIN1252

When the codeset is updated to WE8MSWIN1252, like here:

SP=NLS_LANGUAGE=AMERICAN,NLS_TERRITORY=AMERICA,CODESET=WE8MSWIN1252,NLS_LENGTH_SEMANTICS='CHAR'

...the error no longer occurred and the dbload was completed without issue.

Additional Information

Note that if the DB is set to single-byte, the codeset in the connection string must match.