[nQSError: 46036] Internal Assertion — Oracle Analytics

Oracle Analytics Cloud and Server

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

[nQSError: 46036] Internal Assertion

Received Response
23
Views
1
Comments
Helan Kumar
Helan Kumar Rank 4 - Community Specialist

Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P

State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 43119] Query Failed: [nQSError: 46036] Internal Assertion: Condition cachedQueryEntryPos != pCacheMetadata->m_cachedQueries.end(), file server/Query/Optimizer/ServiceInterfaceMgr/Utility/Src/SQOIUExactMatch.cpp, line 2080.Please have your System Administrator look at the log for more details on this error. (HY000)


I'm getting the above error while running a dashboard report, I'm unable to replicate this issue in any of the other instances(except Prod), this occurs only for one particular date June 30, 2016. Can some one guide or did any one came across this issue earlier.


We have tried the following :

Clearing the presentation LOG,

By pass cache for this report in advanced tab,

Purged the cache in RPD.


Nothing fixed the issue, please help this is very high priority issue

Answers

  • Helan Kumar
    Helan Kumar Rank 4 - Community Specialist

    Issue is with cache in the server.

    Added a new column in the report and excluded it from the results view and saved the report. Report is working fine now.

    Thanks