Error 'NMFTU-3909-3: No mapping for the Unicode character exists in the target multi-byte code page' When Exporting XER or When Viewing Notebook Topics (Doc ID 2248963.1)

Last updated on MAY 11, 2020

Applies to:

Symptoms

When attempting to export a project to XER, or viewing notebook topics in the pro client after re-importing the XER

OR

Importing an XER file when the database contains UTF BOM characters that exist in the affected tables, the following error occurs.

Event Code: NMFTU-3909-3
Message: No mapping for the Unicode character exists in the target multi-byte code page

TCVirtualTable.ProcessLoadDelayedMemo: table=(Activty Notebook), Exception=(No mapping for the Unicode character exists in the target multi-byte code page), sql=(SELECT memo_id, task_memo from taskmemo WHERE (memo_id IN (SELECT PK_ID FROM UPKLIST WHERE SESSION_ID = 97643 AND CONTEXT_ID = 2)) and task_memo is not null)

TCVirtualTable.ProcessLoadDelayedMemo: Table (OBS), Exception=(No mapping for the Unicode character exists in the target multi-byte code page), sql=(SELECT obs_id, obs_descr from obs WHERE (obs_id IN (xxx,xxx,xxx)) and obs_descr is not null)

The issue can be reproduced at will with the following steps:

1. Import a project into P6 version 15.2 or earlier (connected to an Oracle database).
2. Export the database and Import it into a new Oracle Database 12c instance on another server.
3. Upgrade P6 EPPM to a minimum version of 16.2 + Patch Set 4 or later.
4. Connect to the upgraded database with the appropriate version of the P6 Professional application.
5. Attempt to view the project's Notebooks at the project level.
6. Observe the reported error.

Changes

Cause