Oracle Analytics Cloud and Server

Products Banner

State: HY000. Code: 46008. Internal error:

Received Response
94
Views
7
Comments

Summary

Query Error for vizualizations

Content

Hi All,

I am getting a query error as 

tate: HY000. Code: 43113. [nQSError: 43113] Message returned from OBIS.
(HY000)
State: HY000. Code: 43119. [nQSError: 43119] Query Failed:
(HY000)
State: HY000. Code: 46008. [nQSError: 46008] Internal error: File server/Query/Optimizer/Request/Src/SQORRqDumpout.cpp, line 170. (HY000)

State: HY000. Code: 46008. [nQSError: 46008] Internal error: File server/Query/Optimizer/Request/Src/SQORRqDumpout.cpp, line 170. 

Fetch 10000001 rows only 

  1. There is no joins and is a single table in the data model
  2. The no of rows is around 2 Million which is less than 10M current limit
  3. using Live connection as Query Mode

Need help in understanding why this error is occuring and how we can resolve this issue

Regards,

Bhargav

 

 

 

 

 

Answers

  • Hi Bhargav,

    Iam assuming you are querying a subject area from withing DV. 

    What kind of visualization are you trying to create ? Do all vizs throw the same error ? 

    Does it work from answers ? Can you go to Sessions & Query Cache and look at the log for your SQL ? Does that give more information ? 

    Regards,

    Lalitha

     

  • Hi Lalitha,

    Thanks for replying,

    Below are the answers to your question

    What kind of visualization are you trying to create ?

    A simple bar chart showing percentage

    Do all vizs throw the same error ? 

    No it shows error for some visualizations only

    Does it work from answers ? 

    did'nt get you

    Can you go to Sessions & Query Cache and look at the log for your SQL ? Does that give more information ? 

    It does not show any additional information. Also I ran the query which comes in the Query error log and it ran successfully in the issue SQL

     

    Thanks and Regards,

    Bhargav

     

  • Hi Lalitha,

    Thanks for replying,

    Below are the answers to your question

    What kind of visualization are you trying to create ?

    A simple bar chart showing percentage

    Do all vizs throw the same error ? 

    No it shows error for some visualizations only

    Does it work from answers ? 

    did'nt get you

    Can you go to Sessions & Query Cache and look at the log for your SQL ? Does that give more information ? 

    It does not show any additional information. Also I ran the query which comes in the Query error log and it ran successfully in the issue SQL

     

    Thanks and Regards,

    Bhargav

     

  • It may have something to do with the data as some visualizations are working and some aren't.

    For the bar chart that's failing, can you change the viz type to table and send a screenshot of the data, so we can look for some pointers? 

  • Hi Lalitha,

    If i am changing it to table .The values are appearing without any error

    Regards,

     Bhargav

    Table.png

  • I can't see anything wrong with that data although I can't make out what the metric value there is, how many digits it has.

    To narrow down the issue, try with another metric and see if that works. 

    Also try playing with the number format (try abbreviation on/off) in the chart properties and see if that helps. 

     

  • Hi Lalitha,

    1. The metric contains 8 to 9 digits value 
    2.  I tried replacing other metric and it works fine
    3. Also I tried changing chart properties like number format and aggregation method.The moment I change the aggregation method to maximum it works fine and if I change it to auto or sum I get a query error

    Regards,

    Bhargav