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 28, 2017

Applies to:

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

Symptoms

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:

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 com.skire.analytics.taskdefs.AnalyticsTask.execute(AnalyticsTask.java:228)


STEPS
-----------------------
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.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms