IBM Support

Unable to publish: Error: 1792 ORA-01792: maximum number of columns

Troubleshooting


Problem

Unable to publish a specific D-cube in Contributor.

Symptom

The Job management step failed. An attempt has been made to mark the
'PUBLISH' Job as CANCELLED. Please rectify the problem and re-create a
similar Job.

The call to 'JobBegin' on 'Publish_%v.Implementation' was not successful.

Unable to execute statement. 1792 ORA-01792: maximum number of columns in a
table or view is 1000

[{"Product":{"code":"SSEH6Q","label":"Cognos Planning for Series 7"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Contributor","Platform":[{"code":"PF033","label":"Windows"}],"Version":"Planning - Contributor 7.2;Planning - Contributor 7.3","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Product":{"code":"SS9S5U","label":"Cognos 8 Planning"},"Business Unit":{"code":"BU053","label":"Cloud \u0026 Data Platform"},"Component":"Contributor","Platform":[{"code":"","label":""}],"Version":"8.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Historical Number

1013898

Document Information

Modified date:
09 May 2025

UID

swg21344717