My Oracle Support Banner

Error "An Error Occurred. Business Process Workflow Related Data Was Not Sent to Analytics Successfully" for a Failed Unifier Analytics Publication Job With Error "ORA-01792: Maximum Number of Columns in a Table or View Is 1000" in the Associated Log (Doc ID 2332621.1)

Last updated on NOVEMBER 10, 2022

Applies to:

Primavera Unifier Cloud Service - Version and later
Primavera Unifier - Version 17.7 and later
Information in this document applies to any platform.


When attempting to run the Analytics publication process within Unifier (Company Workspace > Analytics Node), the schedule history shows the publication job as failed and reports the following error:

The following error is seen in the Unifier user interface in the Analytics Node's Run History:

An error occurred. Business Process Workflow related data was not sent to Analytics successfully

The following SQL exception can be found in the Unifier background job server log file:

Target.Exception performTasks
SEVERE: unifier:/analytics/publish throws an exception at file:///analytics/action.xml:5: file:///analytics/action.xml:5: java.sql.SQLSyntaxErrorException: ORA-01792: maximum number of columns in a table or view is 1000 at

The issue can be reproduced at will with the following steps:
1. Enable the Analytics node within Unifier
2. Configure data mappings
3. Run the publication process
4. Note the reported issue which occurs

This situation can cause invalid or no data to be sent to Primavera Data Warehouse via an ETL execution, causing Primavera Analytics to return invalid or no data.


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

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