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.