IBM Support

Requirements for NLS_COMP and NLS_SORT Oracle database settings for Process Engine.

Troubleshooting


Problem

The current P8 documentation neglects to include the requirements to ensure that for Process Engine on Oracle database, the NLS_COMP and NLS_SORT environment variables needs to be identical.

Symptom

1) Some Process Engine (PE) user environment records may not be updated or migrated during an upgrade from Process Engine 3.5 .

2) Process Engine queries might not return all of the expected results.

[{"Product":{"code":"SSTHRT","label":"IBM Case Foundation"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Process Engine","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"},{"code":"PF016","label":"Linux"}],"Version":"5.1.0;5.0;4.5.1;4.5.0;4.5","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Document Information

Modified date:
17 June 2018

UID

swg21601261