SAP Knowledge Base Article - Preview

2753835 - Error: "ORA-01792: maximum number of columns in a table or view is 1000" appears while running a Webi report based on a universe on top of Oracle database

Symptom

After running a Webi query including multiple objects from a unx universe on top of an Oracle database below error displays:

"ORA-01792: maximum number of columns in a table or view is 1000"


Read more...

Environment

  • SAP BusinessObjects Business Intelligence Platform 4.x
  • Web Intelligence
  • Information Design Tool
  • Oracle Database

Product

SAP BusinessObjects Business Intelligence platform 4.0 ; SAP BusinessObjects Business Intelligence platform 4.1 ; SAP BusinessObjects Business Intelligence platform 4.2

Keywords

Fail, ORA, large, appear, unable, cannot, webi, Rich Client, BI LaunchPad, run, refresh , KBA , BI-RA-WBI , Web Intelligence , BI-BIP-IDT , Information design tool , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.