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

Question

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

Ebin Cherian · Answer

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

Syedsalmancs110 · Answer

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.

Subhod Shetty-Oracle · Answer

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