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'
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
Release : 21.0.2
Component : DBLoad Utility
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.