Cognos Controller FAP cannot support languages other than English

When you try to publish in data mart, the following error message appears:

ERROR [common.persistence.retry.RetryInterceptor] [pool-2-thread-1], Trial 3 failed for method executeTM1Process

Cause

The error message appeared because of an incorrect character in the SQL definition.

Resolving the problem

In SQL Plus, determine if the database is Unicode by typing the following Select statement: select * from NLS_DATABASE_PARAMETERS; The result should return NLS_CHARACTERSET of ALI6UTF16.

If this is not the case, recreate the database as follows:

  1. Open SQL Plus.
  2. Type the following command: select * from NLS_DATABASE_PARAMETERS;
  3. Make sure the NLS_CHARACTERSET is ALI6UTF16.
  4. If the character set is different, create a new database instance with the correct character set.