Home Discussions Questions & Answers Database Internal Error during Report Export

Database Internal Error during Report Export

Avatar photoCustomer November 10, 2024 at 5:26 am

When trying to export Blitz Reports as XML files on our database, we are intermittently hitting an ORA-00600 internal error, specifically argument [qkeIsExprReferenced1]. We are running DB version 12.1.0.2.

Viewing 4 reply threads
  • Author
    Replies
    • Support November 11, 2024 at 9:22 pm  

      This is a known database bug, Oracle bug 25203656, impacting 12.1.0.2. You can resolve the issue either by applying the corresponding patch 25203656, or by setting a database parameter as a workaround.

    • Avatar photoCustomer November 13, 2024 at 8:34 am  

      What is the parameter workaround for the DBA to implement immediately?

    • Support November 14, 2024 at 3:39 pm  

      The required workaround is to execute the command: `alter system set “_projection_pushdown” = false`.

    • Avatar photoCustomer November 14, 2024 at 7:01 pm  

      Would this workaround apply if we were on an older 11g version?

    • Support November 15, 2024 at 4:00 pm  

      Yes, if you are using an older 11g version (10.2.0.3 to 11.1.0.7), a similar bug exists, and the same workaround to set `_projection_pushdown` to false is recommended.

Viewing 4 reply threads
  • You must be logged in to reply to this post.

Login with: