Exalytics and OBIEE 11g: 188.8.131.52 Request Upgraded To OBIEE 184.108.40.206.X Fails With Error: [nQSError: 59001] Subtract Operation Not Permitted On DOUBLE
Last updated on JANUARY 02, 2018
Applies to:Business Intelligence Suite Enterprise Edition - Version 220.127.116.11.2 BP1 and later
Oracle Exalytics Software - Version 18.104.22.168.0 and later
Information in this document applies to any platform.
Upgraded the Oracle Business Intelligence Enterprise Edition (OBIEE) Repository (RPD) and catalog from version 22.214.171.124 to version 126.96.36.199.10 and migrated to Oracle Exalytics.
After completing this upgrade and migration, several requests/dashboards that were working fine in OBIEE 188.8.131.52 are now failing with error in the OBIEE 184.108.40.206.10 server on Exalytics.
The error details are:
Error Codes: OPR40NWY:U9IM8TAC:OI2DL65P
[2013-05-30T09:46:14.000-07:00] [OracleBIServerComponent] [TRACE:2] [USER-34]  [ecid: a1adba585fa6386b:17645edf:13e88a42519:-8000-0000000000190dce] [tid: 49cc6940] [requestid: d6620002] [sessionid: d6620000] [username: kkatrapati] -------------------- Query Status: [nQSError: 59001] Subtract operation is not permitted on DOUBLE PRECISION, VARBINARY operand(s). [[
[nQSError: 59140] The evaluation of the index 16 expression on row count -1 failed.
[nQSError: 43119] Query Failed:
The reports that fail include a calculated column that references DOUBLE datatypes in the logical model, but which are varchar datatype at the source database.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms