Home › Discussions › Questions & Answers › Database Internal Error during Report Export

Database Internal Error during Report Export

Avatar photoCustomer Questions & Answers 5 replies

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.

5 replies

  • Support Enginatics

    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

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

  • Support Enginatics

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

  • Avatar photoCustomer

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

  • Support Enginatics

    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.

  • You must be logged in to reply to this post.