MarkView Process Monitor - ORA-06513 when logging into Process Monitor

Applies To

• ERP System: Oracle, Peoplesoft, SAP
• MarkView Version: All Versions

Behavior

When attempting to logon to Process Monitor some users may receive the following error message:

javax.servlet.ServletException: ORA-06513: PL/SQL: index for PL/SQL table out of range for host language array ORA-06512: at line 1

Known Causes

In a default configuration Process Monitor will only display if an end user has less than 1000 Roles, or 500 Configurations associated with their account.

Resolution

• In order to determine how many Roles or Configurations are assigned to a specific user you can run the monitor_get_roles.sql script or monitor_get_configs.sql script attached to the answer.
• If the end user has more than 1000 Roles or 500 Configurations associated with their account you can temporarily disable some Roles and/or remove some Configurations in order to allow the end user to logon to Process Monitor.
  • monitor_get_roles.sql (1K)
  • monitor_get_configs.sql (1K)