Note: Oracle database is no longer supported as of WorkflowGen version 7.16.0. We recommend migrating to MS SQL Server 2017 or later.
Description
One of the common errors that occurs during the WorkflowGen installation for Oracle is due to unsupported character set settings of the database instance. WorkflowGen is a multilingual software application that requires storage in UTF-8 encoding.
Solution
The database must use CHARACTER SET and NATIONAL CHARACTER SET in UTF-8. If the character sets could not be changed then a new database instance is required. Use the following query to verify the character sets in the Oracle SQL Command Line tool.
When the tablespace is created, you should specify the Database and National Character Set to UTF-8.
(Ordinary) character set
The (ordinary) character set for a database can be determined with:
select value from nls_database_parameters where parameter = 'NLS_CHARACTERSET';
National character set
The national character set for a database can be determined with:
select value from nls_database_parameters where parameter = 'NLS_NCHAR_CHARACTERSET';
For more information, see the Requirements for installation on Oracle databases section in the WorkflowGen Technical Guide (versions 7.15.0 and earlier).