[nQSError: 46036] Internal Assertion

Helan Kumar

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

Helan Kumar

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