Unable to access PE workitems after migration

Technote (troubleshooting)


Problem(Abstract)


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.

Cause

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.

Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

Case Foundation
Business Process Manager

Software version:

5.1.0

Operating system(s):

Windows

Reference #:

1639599

Modified date:

2013-06-24

Translate my page

Machine Translation

Content navigation