ORA 01792 Error when running a report — Oracle Analytics

Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

ORA 01792 Error when running a report

Received Response
11
Views
2
Comments
yaseennawaz
yaseennawaz Rank 4 - Community Specialist
edited Aug 13, 2024 6:20PM in Oracle Analytics Cloud and Server

Hi ,

I am getting  the ORA 01792---Maximum number of columns in a table or view is 1000 message when running  a report. Could you please let me know how to fix this without making any configuration changes.

Regards,

Yaseen

Answers

  • Gianni Ceresa
    Gianni Ceresa Mod

    Hi,

    Call your DBA !

    ORA 01792 isn't an OBIEE error itself.

    The database raise the error and OBIEE simply display it, so if you want it to run without changing anything in your OBIEE you call your DBA and ask him to change the setting in the DB.

    Do a google for the Oracle ORA 01792 to get more info, it seems it can also be related to a bug in the DB and there seems to be a patch ...

  • Bharat G
    Bharat G Rank 1 - Community Starter

    Hi Yaseen,

    Can you please let us know which Report you are trying to run and what is the Database Version you are currently on.

    Regards,

    Bharat