My Oracle Support Banner

Analytics Jobs Complete In Failed Status With Exception ORA-12899 (Doc ID 2971180.1)

Last updated on AUGUST 30, 2023

Applies to:

Primavera Unifier - Version 20.12.16.0 to 20.12.16.0 [Release 20.12]
Information in this document applies to any platform.

Symptoms

In Self-Hosted Unifier instance

ACTUAL BEHAVIOR:

When attempting to run Analytics jobs , the jobs show failed status. In debug log file, it shows exception "Error Msg = ORA-12899: value too large for column "UNIFIER"."SYS_STG_WF_TASK"."ASSIGNEE_COMPANY" (actual: 44, maximum: 24)"

EXPECTED BEHAVIOR:

When attempting to run Analytics jobs, the jobs finish successfully without showing any exceptions in debug log.

Steps to reproduce the issue:

  1. Log into Unifier.
  2. Navigate to Company workspace admin mode->Analytics->Select analytics and click Run now.
  3. Click the Run history to view the history jobs showing with failed status.

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.