OAS
OAS 5.5 - Manual SQL Query Issue
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…
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
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: 923, message:
ORA-00923: FROM keyword not found where expected at OCI call OCIStmtExecute.
(HY000)
State: HY000. Code: 17010. [nQSError: 17010] SQL statement preparation
failed. (HY000)
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.