OBIEE 11g & 12c: Error: ” [nQSError: 17012] Bulk fetch failed. [[ [nQSError: 17001] Oracle Error code: 25137, message: ORA-25137: Data value out of range” when Running Reports:
Error:
Some of the reports are failing with the following error:
View Display Error
Odbc driver returned an error (SQLExecDirectW).
Error Details
Error Codes: OPR4ONWY:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:OI2DL65P
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: 17001. [nQSError: 17001] Oracle Error code: 25137, message: ORA-
25137: Data value out of range at OCI call OCIStmtFetch. (HY000)
State: HY000. Code: 17012. [nQSError: 17012] Bulk fetch failed. (HY000)
See the following error in the sawlog.log file:
Query Status: [nQSError: 17012] Bulk fetch failed. [[
[nQSError: 17001] Oracle Error code: 25137, message: ORA-25137: Data value out of range at OCI call OCIStmtFetch.
[nQSError: 43119] Query Failed:
Solution:
Step 1: Log in to the Administration Tool.
Step 2: Open the repository (RPD).
Step 3: Navigate to Physical Layer-> Database features.
Step 4: Change CAST_SUPPORTED parameter "Value" from default "YES" to "NO"(Uncheck)
Step 5: Save your changes.
Step 6: Re-deploy the repository (RPD).
Step 7: Re-test the issue.