Easily find issues by searching: #<Issue ID>
Example: #1832
Easily find members by searching in: <username>, <first name> and <last name>.
Example: Search smith, will return results smith and adamsmith
| Dev |
|
| QA |
|
| Priority | Major |
| Complexity | Unknown |
| Component | Q Analyzer |
| Version | 15.0 |
When I try to open data editor over a query I write in Q Analyzer, it throws an error saying Failed to locate table X. It doesn't matter how complex or simple the query is.
|
|
84 KB
|
|
69 KB
|When I try to open data editor over a query I write in Q Analyzer, it throws an error saying Failed to locate table X. It doesn't matter how complex or simple the query is
--->In query analyzer of ADS there is one database drop down list which sets your database context.
I am considering two scenarios in your issue
a)The query you are executing is not database qualified and in database dropdown list wrong database has been chosen.(please refer attached screenshot “scenario_a”)
Say your table X is in Database A
In database drop down list of query analyzer B has been chosen
you write your query as “select * from X”
when you run this query as execute edit it searches table in database B and gives error table “B.X doesn't exist”
b) Your query is database qualified but in database drop down list different database has been set.(please refer attached screenshot “scenario_b”)
Say your table X is in Database A
In database drop down list of query analyzer B has been chosen
You write your query as “select * from A.X”
In this case when you execute edit query it considers B as database and X as table name,and gives error :failed to locate table “B.A.X”
In order to move ahead , you can set the same database in which your table exists in the drop down list of query analyser ,this will not throw error message and execute edit window will be opened.
I can't share a screenshot here because the data belongs to a customer but I'm hundred percent sure that I'm referencing the table from the selected database. I don't refer it like A.X but only X instead.
What I discovered is, it actually works for simple small tables but it doesn't work on the table I first tried maybe because It's a huge one with millions of records. I'm adding top 100 or limiting the data on "where" part but it just doesn't work.
I can't share a screenshot here because the data belongs to a customer but I'm hundred percent sure that I'm referencing the table from the selected database. I don't refer it like A.X but only X instead.
What I discovered is, it actually works for simple small tables but it doesn't work on the table I first tried maybe because It's a huge one with millions of records. I'm adding top 100 or limiting the data on "where" part but it just doesn't work.
@koraytaylan: can you send us an email (architect@aquafold.com) and provide us the below information so we can diagnose the issue:
1) Send us the ADS Help > Support Information
2) The DB Server (e.g. SQL Server, DB2, etc) and version
3) If you're able to share the query that causes the issue. If not, a sample query that causes the issue.
4) Your ADS log files located in [USER_HOME]/.datastudio
Once we have the above information, we can diagnose further.
@koraytaylan: can you send us an email (architect@aquafold.com) and provide us the below information so we can diagnose the issue:
1) Send us the ADS Help > Support Information
2) The DB Server (e.g. SQL Server, DB2, etc) and version
3) If you're able to share the query that causes the issue. If not, a sample query that causes the issue.
4) Your ADS log files located in [USER_HOME]/.datastudio
Once we have the above information, we can diagnose further.
Verified in ADS v15.0.7-7. Extraction queries was fixed for Execute Edit
Verified in ADS v15.0.7-7. Extraction queries was fixed for Execute Edit
Issue #12517 |
| Closed |
| Fixed |
| Resolved |
Completion |
| No due date |
| Fixed Build 15.0.7-5 |
| No time estimate |
1 issue link |
relates to #12522
Issue #12522Upper on database side compared to java toUpper() on client side does not always match |
|When I try to open data editor over a query I write in Q Analyzer, it throws an error saying Failed to locate table X. It doesn't matter how complex or simple the query is
--->In query analyzer of ADS there is one database drop down list which sets your database context.
I am considering two scenarios in your issue
a)The query you are executing is not database qualified and in database dropdown list wrong database has been chosen.(please refer attached screenshot “scenario_a”)
Say your table X is in Database A
In database drop down list of query analyzer B has been chosen
you write your query as “select * from X”
when you run this query as execute edit it searches table in database B and gives error table “B.X doesn't exist”
b) Your query is database qualified but in database drop down list different database has been set.(please refer attached screenshot “scenario_b”)
Say your table X is in Database A
In database drop down list of query analyzer B has been chosen
You write your query as “select * from A.X”
In this case when you execute edit query it considers B as database and X as table name,and gives error :failed to locate table “B.A.X”
In order to move ahead , you can set the same database in which your table exists in the drop down list of query analyser ,this will not throw error message and execute edit window will be opened.