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 DECEMBER 28, 2017
Applies to:Primavera Unifier Cloud Service - Version 18.104.22.168 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:
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)
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
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!