Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
[nQSError: 46036] Internal Assertion

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
-
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
0