Qbe build wrong sql

Question

Hi!

Qbe build wrong sql. Even on simple query to foodmart it gives:
An error occurred in EXEC_QUERY_ACTION service while executing query: [SELECT SUM(t_0.unit_sales), t_1.sales_city FROM Sales_fact t_0,Region t_1,Customer t_2 WHERE (t_0.compId.customer_id = t_2.customer_id AND t_2.rel_customer_region_id_in_region.region_id = t_1.region_id) GROUP BY t_1.sales_city]

I think the problem in "rel_customer_region_id_in_region." 

version: Knowage-6.0.0-CE-Installer-Windows-JVM64bit-20170616.exe, JAVA_VERSION="1.8.0_92", x64

Answer 1

Hi,

probably the QBE model is designed for a "foodmart_demo" schema, not for a "foodmart_ce" schema as installed.

Please try to export structure+data from "foodmart_ce" schema and import them to a new "foodmart_demo" schema, then fix the related resource in Knowage-Server-CE/conf/server.xml.

A new version of the installer CE will be available shortly.

Comments

The problem not in "foodmart_ce"!  I get such error on me own simplest model too:

An error occurred in EXEC_QUERY_ACTION service while executing query: [SELECT SUM(t_0.quantity_service), t_1.name FROM F_order t_0,D_filial t_1 WHERE (t_0.rel_filial_in_d_filial.objectid = t_1.objectid) GROUP BY t_1.name]

Code must generate "t_<N>.<fieldName>, but it generate "t_<N>.rel_<X>_in_<Y>.<fieldName>
In RC version it works fine.

---

Would you mind to file an issue on our bug tracker https://www.knowage-suite.com/jira ?
In this way you get notification when the issue will be resolved and we can put in place a fix about it.