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:

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

Cause

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