Forum Discussion
Query errors after training model
Hi lcarlone,
Can you please share some more detailed information for your scenario? They will help us clarify your situations and test to troubleshoot.
How to Get Your Question Answered Quickly
Regards,
Xiaoxin Sheng
Ok, I will try to retrace the steps!
I created a Workspace (premium). In the workspace I created a Dataflow (Immobili)
In the dataflow I have 3 tables with data from a SQL Database via a Data Gateway
On the 3 tables I trained 3 different Machine learning models
The model training automatically creates 2 tables (training and testing data) for each model in the dataflow and the regression reports in the workspace.
Since this point all worked correctly.
Now I would like to add one more table in the dataflow with new data from a different SQL DB on which I would like to apply the trained models.
I choose “Add table” from the dataflow, insert the connection parameters and the query and I get this screen with the data loaded correctly.
I click Save & Close and I get this
for a very long time (nearly 30 minutes). After waiting that long, I get this error that prevents saving the dataflow with the new table.
The query with error is not everytime the same!
Trying to save another time it succeded, but again after a lot of time.
What am I missing?
HI lcarlone,
According to your description, it seems like the training models setting and work well before you do modify to insert other data sources into current contents, right? If that is the case, I'd like to get some more detailed information to confirm the root cause of this issue.
Gateway related issues:
Did these tables reachable from the data gateway that is used by current training modes?
What version of the gateway are you working on? If you are working with the old versions, please update them and try again.
Data records issues:
According to the snapshots, the error message seems related to validating/committing changes failed. Did any particular in these newly added data tables? (e.g. security setting on the data source, data structures, wrong data include in tables)
The issue with specific contents:
Any change/update on your data source tables recently?
If you create a new ML model with these new tables, did the same issue appear?
Server/service-related issue:
If you change on other models that you created in the past, can you reproduce this issue on the old models?
Regards,
Xiaoxin Sheng
