OAC: Workbook Based On Excel Fails With Error 'nQSError: 59001 Subtract operation is not permitted on TIMESTAMP, INTEGER operand(s)'
(Doc ID 2937490.1)
Last updated on NOVEMBER 03, 2023
Applies to:
Oracle Analytics Cloud - Version N/A to N/A [Release 14.1]Information in this document applies to any platform.
Symptoms
Workbook based on excel data fails with the below error:
Error during query processing (SQLExecDirectW).
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred.
(HY000)
State: HY000. Code: 43275. [nQSError: 43275] Message returned from OBIS
(HY000)
State: HY000. Code: 43119. [nQSError: 43119] Query Failed:
(HY000)
State: HY000. Code: 59001. [nOSError: 59001] Subtract operation is not permitted on TIMESTAMP, INTEGER operand(s). (HY000) SQL Issued: SET VARIABLE PREFERRED_CURRENCY='Local Currency',ENABLE_DIMENSIONALITY=1;SELECT O s_0,
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |