A very quick blog post to provide some information about an issue that may arise with Data Visualisation projects based on manual SQL queries in Oracle Analytics Server 5.5 and above. These queries would have worked in previous versions of Oracle Analytics Server.
Essentially, manual multi line SQL queries throw an exception:
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A
Oracle have confirmed that this is a defect that has a workaround. You will only encounter this issue if the SQL query test consists of several lines ending with carriage returns.
The workaround is to place a space character at the end of each line of the query text just before each carriage return. You can find more information about this here.
A bit about me. I am an Oracle ACE Pro, Oracle Cloud Infrastructure 2023 Enterprise Analytics Professional, Oracle Cloud Fusion Analytics Warehouse 2023 Certified Implementation Professional, Oracle Cloud Platform Enterprise Analytics 2022 Certified Professional, Oracle Cloud Platform Enterprise Analytics 2019 Certified Associate and a certified OBIEE 11g implementation specialist.