Welcome to Knowage Q&A, where you can ask questions and receive answers from other members of the community.
0 votes
1 view
Good evening,
below is the explanation of the problem:
1- I create a federated dataset from the appropriate screen.
2- I open the federated dataset in qbe, set the fields and save the qbe dataset "x_qbe".
3- When I select the "x_qbe" dataset and press save, the system returns the error message:"JSONObject[\"qbeJSONQuery\"] not found.".
But in the payload of the request the value "qbeJSONQuery" is set:
4- Executing a query on the table relating to the knowage dataset I see that during the saving phase it does not set the field SBI_DATA_SET.CONFIGURATION for the last record of "x_qbe".
5- if I insert the data present in the previous record in the SBI_DATA_SET.CONFIGURATION field, always relating to the "x_qbe" dataset, the system no longer returns the error as before and makes me view it correctly. But when I rerun the save, the problem repeats itself in the new record created.
Environment Knowage 8.0.8, centos 8, Chrome, database knowage mysql 5.7.37
in Data Set by (120 points)
good information
Hello,

thank you for the detailed report. I'll try to replicate your case. In the meantime could you please tell me what types of dataset you've tried to federate? For example, I've tried to federate a file dataset with a query dataset, a QBE dataset with another QBE dataset, etc...
Hello mlibanor,

thank you for your reply, I've tried to federate two query dataset using an external database as datasource.
Hi federider,

I've replicated your case and I confirm the bug. I will work on it on the next days.

1 Answer

–1 vote
Hi,

as stated by my last comment, it was a bug. I've fixed it and it will be available in the next release of every branch of knowage: devel, 8.0 and 7.4.

I want to thank @federider for the report.
by (5.1k points)
...