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

OBIEE analysis returns [nQSError: 46036] Internal Assertion: Condition pColumn->GetExpr()->IsTarget

Received Response
292
Views
5
Comments
984976
984976 Rank 1 - Community Starter
edited Aug 13, 2024 5:57PM in Oracle Analytics Cloud and Server

Hi all,

on some analysis we get the following error:

State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. (HY000)
State: HY000. Code: 43113. [nQSError: 43113] Message returned from OBIS. (HY000)
State: HY000. Code: 43119. [nQSError: 43119] Query Failed: (HY000)
State: HY000. Code: 46036. [nQSError: 46036] Internal Assertion: Condition pColumn->GetExpr()->IsTargetColumn(), file server/Query/Optimizer/ServiceInterfaceMgr/Src/SQOIGeneratorCache.cpp, line 78. (HY000)

After refresh we get results.

Has anyone run into the same problem?

Best regards,

                    Matej

Answers

  • Syedsalmancs110
    Syedsalmancs110 Rank 6 - Analytics Lead

    What is your OBIEE version with complete patch level is it 10g(10.3.x)/11g(11.1.1.X.X)/12c(12.2.1.X.X)?

    What is the database source(Oracle, Essbase etc..) for the report which fails with mentioned error?

    From the error it looks to be an issue with cache(SQOIGeneratorCache), is simple report/dashboard refresh is resolving the issue or purging the cache resolves the issue?

  • 984976
    984976 Rank 1 - Community Starter

    OBIEE version: 12.2.1.2.0

    Database source is Oracle.

    Yes, report refresh (which forces the query to bypass the cache) resolves the issue.

    Regards,

                   Matej

  • Subhod Shetty-Oracle
    Subhod Shetty-Oracle Rank 1 - Community Starter

    Check if your report makes use of "IFNULL" in  one of the column formulae . Remove it and test.

  • Syedsalmancs110
    Syedsalmancs110 Rank 6 - Analytics Lead

    That confirms it, that BI Server isn't able to resolve certain piece of code when trying to fetch result for report from cache hence the error(SQOIGeneratorCache), but when cache is not hit then you get your result.

    Now it could be of different reason for facing this issue, it can be a product bug or design issue or maybe something else,as far as I know assertion errors occurs when something within the code that should have never happened has happened.

    Suggest you to log a ticket with Oracle Support and check with them , whether this issue has been reported before or it's something new that could be bring to there notice.

    Did some search on Oracle KM but did not find anything specific to the posted error message.

  • Ebin Cherian
    Ebin Cherian Rank 5 - Community Champion

    Hi Matej,

    I faced the same issue in the past. In my case, issue was with the report. There were 'NULL' keyword used in one column formula of the report by the user and removing it resolved the issue.

    Thanks

    Ebin