OBIEE 12C: Export Issue With CSV -An Overflow Occurred During The Conversion Of DOUBLE PRECISION To INTEGER.
(Doc ID 2609462.1)
Last updated on JUNE 22, 2023
Applies to:
Business Intelligence Suite Enterprise Edition - Version 12.2.1.4.0 and laterInformation in this document applies to any platform.
Symptoms
- Issue while exporting report in CSV format after upgraded to 12C
- Same reports working fine in 11G
- In 12C, Displaying below error after downloading more than 200000 rows.
Error:
style="margin-top:4pt">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: 43119. [nQSError: 43119] Query Failed:
(HY000)State: HY000. Code: 46226. [nQSError: 46226] An error occurred during data conversion for column: s_4.
(HY000)State: HY000. Code: 46224. [nQSError: 46224] An overflow occurred during the conversion of DOUBLE PRECISION to INTEGER. (HY000)
(HY000)State: HY000. Code: 43119. [nQSError: 43119] Query Failed:
(HY000)State: HY000. Code: 46226. [nQSError: 46226] An error occurred during data conversion for column: s_4.
(HY000)State: HY000. Code: 46224. [nQSError: 46224] An overflow occurred during the conversion of DOUBLE PRECISION to INTEGER. (HY000)
Changes
OBIEE upgraded from 11G to 12C
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 |
| Changes |
| Cause |
| Solution |
| References |