IBM Support

Error running Birt reports in Maximo - ORA-01792: maximum number of columns in a table or view is 1000

Troubleshooting


Problem

Attempting to run Custom and Out-of-the-box BIRT reports against an Oracle 12C database may throw the error: ORA-01792: maximum number of columns in a table or view is 1000.

Symptom

You will see the following in the log: (Sample from a failed Work order List report (wotrack.rptdesign)

Tue May 09 09:02:51 CDT 2017 INFO DataSet [dataSet]: select workorder.workorderid, workorder.wonum, workorder.description, workorder.woclass, workorder.status, workorder.assetnum, workorder.worktype, workorder.wopriority, workorder.lead, workorder.location, workorder.jpnum, workorder.parent, workorder.siteid, workorder.schedstart, workorder.schedfinish, workorder.siteid from ((workorder left outer join wochange on workorder.siteid = wochange.siteid and workorder.orgid = wochange.orgid and workorder.wonum = wochange.wonum) left outer join woactivity on workorder.siteid = woactivity.siteid and workorder.orgid = woactivity.orgid and workorder.wonum = woactivity.wonum) where 1=1 and workorder.istask = 0 and workorder.historyflag = 0 and workorder.assetnum like '%MYASSET%' and workorder.istask = 0 and workorder.siteid = 'SITEID' and workorder.location = 'MYLOC1' order by workorder.siteid, workorder.wonum
Tue May 09 09:02:52 CDT 2017 ERROR DataSet [dataSet] fetch failed:
java.sql.SQLSyntaxErrorException: ORA-01792: maximum number of columns in a table or view is 1000

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:207)
at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:884)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1167)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1289)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3584)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3628)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1493)
at com.ibm.tivoli.maximo.report.script.MXReportDataSetImpl.fetch(MXReportDataSetImpl.java:325)

[{"Product":{"code":"SSLKT6","label":"IBM Maximo Asset Management"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Database Config","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"7.6","Edition":"","Line of Business":{"code":"LOB77","label":"Automation Platform"}},{"Product":{"code":"SSRHPA","label":"IBM Maximo Application Suite"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":" ","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB77","label":"Automation Platform"}},{"Product":{"code":"SSWT9A","label":"IBM Control Desk"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":" ","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB77","label":"Automation Platform"}}]

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.

Document Information

Modified date:
18 September 2025

UID

swg22003342

Page Feedback