ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Db load error ORA-64204

book

Article ID: 240063

calendar_today

Updated On:

Products

CA Automic Workload Automation - Automation Engine CA Automic One Automation

Issue/Introduction

Installing Automic Workload Automation v21.0.2, During the database load the following error is returned:

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

Cause

The Oracle database is using the character set AL32UTF8

The ODBC connection string in the ini file was set using:

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

 

 

Environment

Release : 21.0.2

Component : DBLoad Utility

Resolution

The codeset and character set are different. The character set is what the database uses, and the codeset is what the client uses to communicate with the character set specified in the database. 

For Oracle, Automic supports the use of one of three codesets for use in the ini: 

WE8ISO8859P1, WE8ISO8859P15 and WE8MSWIN1252

When the codeset was updated to WE8MSWIN1252 as:

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

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

Attachments

Powered by Wolken Software