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.