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'
The Oracle database is using the multibyte character set AL32UTF8
The ODBC connection string in ucsrv.ini file was using the same:
Release : 21.0.2
Component : DBLoad Utility
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:
...the error no longer occurred and the dbload was completed without issue.
Note that if the DB is set to single-byte, the codeset in the connection string must match.