ELFFAR ANALYTICS
  • Home
  • Services
  • Contact Us
  • About Us
  • Blog

Elffar Analytics Blog

OAS 5.5 - Manual SQL Query Issue

15/11/2020

0 Comments

 
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.
0 Comments

Your comment will be posted after it is approved.


Leave a Reply.

    Author

    I'm an Oracle Ace Associate, Oracle Cloud Platform Enterprise Analytics 2019 Certified Associate and a certified OBIEE 11g implementation specialist.

    Archives

    March 2020
    February 2020
    December 2019
    August 2019
    June 2019
    February 2019
    January 2019
    December 2018
    August 2018
    May 2018
    December 2017
    November 2016
    December 2015
    November 2015
    October 2015

    Categories

    All
    OAC
    OAS
    OBIEE
    OBIEE 12c

    RSS Feed

Powered by Create your own unique website with customizable templates.
  • Home
  • Services
  • Contact Us
  • About Us
  • Blog