IBM Support

Unable to access PE workitems after migration

Technote (troubleshooting)


IBM ECM FileNet P8 (P8) Process Engine (PE) workitems are migrated from a P8 3.5 to a P8 5.X system. When attempting to access these workitems, a security violation error occurs.


The P8 3.5 user IDs (including owners of workitems) were not migrated to the P8 5.X system and were therefore assigned new user IDs. This was due to the ORACLE NLS_SESSION parameters being set to a language; e.g. German; instead of BINARY.

Diagnosing the problem

If the locale on the PE is set to a language other than English, then the NLS session parameters; NLS_SORT and NLS_COM; will not be set to BINARY and the user IDs will not be transferred correctly.

NOTE: The session parameters of the client (Process Engine) overwrite the session parameters of the database. With JDBC or JDBC OCI connections there is no way to change this on the server side (e.g. using logon trigger). You must guarantee that the client runs with the correct environment to guarantee the correct NLS settings.

Resolving the problem

Run the PE migration in an English environment.

Document information

More support for: Case Foundation
Business Process Manager

Software version: 5.1.0

Operating system(s): Windows

Reference #: 1639599

Modified date: 24 June 2013