Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 16 Oracle Analytics Lounge
- 215 Oracle Analytics News
- 43 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Database error during DXEExecution?

I have an OBIEE 11.1.1.7.160119 environment. I am running a simple request that returns "Customer Name" which has names containing Chinese characters (possibly relevant). It returns results successfully. When I try to add any kind of conditional formatting to any field in the request, it returns this error:
View Display Error | |
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: 17001] Oracle Error code: 29275, message: ORA-29275: partial multibyte character at OCI call OCIStmtFetch. [nQSError: 17012] Bulk fetch failed. (HY000) SQL Issued: 62371~vjo7ajq010fd9rkphisgaunjpi |
The above error happens during DXEExecution.
Question 1: Why would DXEExecution return an Oracle database error? I thought DXEExecution is where Presentation Services does post-query processing like sorts, aggregates, etc. I was not expecting to see an Oracle database error happen during DXEExecution.
Question 2: I can't find any proof of OBIEE issuing any query that would cause this ORA-29275 error. That is, I can set the loglevel to 2 or 5 and see the physical SQL captured for other OBIEE queries, but I do not see any physical SQL happening from the DXEExecution portion of the logs. If OBIEE is in fact issuing a physical query to the database during DXEExecution, where would I find it? I don't see it in the logs or in the usage tracking S_NQ_DB_ACCT table.