WorkflowGen installation for Oracle fails to create the database structure


#1

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 which requires storage in UTF-8 encoding.

Solution

The database must use CHARACTER SET and NATIONAL CHARACTER SET in UTF8. 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 section on requirements for installation on Oracle databases in the WorkflowGen Technical Reference Guide, available on the Documentation page.