Hi @santoshkc it is all a bit strange to say the least. The data is there and it is all correct. I have created an ML model on Designer using this data set and it works. So, there is no problem pulling the data. The problem seems to be on Auto ML. Microsoft technical support are telling me I can no longer pull data from my Azure sql server the way I used to do it, which was by creating a data asset. I need to create a data import instead. However that data import does not produce a tabular data set but an ML table which I get an error message about too. I keep thinking the problem is in auto ml rather than in the data import process.
Error encountered when running a Classifier on Azure Auto ML
Ivan Casana-Gallen
26
Reputation points
I have been working on a classifier for a few days on Azure Auto ML and when I tried disabling some variables that I do not need today, I encountered the below error. I have never encountered this type of error before and even after creating a new dataset with just the variables I am interested in, the error persists. I need help to resolve this issue.
Thank you
Encountered error while fetching data. Error:
Error Code: ScriptExecution.Database.Unexpected
Native Error: Dataflow visit error: ExecutionError(DatabaseError(Unknown("SQLError(Server(TokenError { code: 103010, state: 1, class: 16, message: \"Parse error at line: 1, column: 22: Incorrect syntax near 'stmt'.\", server: \"data-platform-sql-data-warehouse-server\", procedure: \"\", line: 1 }))", Some(SQLError(Server(TokenError { code: 103010, state: 1, class: 16, message: "Parse error at line: 1, column: 22: Incorrect syntax near 'stmt'.", server: "data-platform-sql-data-warehouse-server", procedure: "", line: 1 }))))))
VisitError(ExecutionError(DatabaseError(Unknown("SQLError(Server(TokenError { code: 103010, state: 1, class: 16, message: \"Parse error at line: 1, column: 22: Incorrect syntax near 'stmt'.\", server: \"data-platform-sql-data-warehouse-server\", procedure: \"\", line: 1 }))", Some(SQLError(Server(TokenError { code: 103010, state: 1, class: 16, message: "Parse error at line: 1, column: 22: Incorrect syntax near 'stmt'.", server: "data-platform-sql-data-warehouse-server", procedure: "", line: 1 })))))))
=> Failed with execution error: An error occur when executing database query.
ExecutionError(DatabaseError(Unknown("SQLError(Server(TokenError { code: 103010, state: 1, class: 16, message: \"Parse error at line: 1, column: 22: Incorrect syntax near 'stmt'.\", server: \"data-platform-sql-data-warehouse-server\", procedure: \"\", line: 1 }))", Some(SQLError(Server(TokenError { code: 103010, state: 1, class: 16, message: "Parse error at line: 1, column: 22: Incorrect syntax near 'stmt'.", server: "data-platform-sql-data-warehouse-server", procedure: "", line: 1 }))))))
Error Message: Database execution failed with "SQLError(Server(TokenError { code: 103010, state: 1, class: 16, message: \"Parse error at line: 1, column: 22: Incorrect syntax near 'stmt'.\", server: \"data-platform-sql-data-warehouse-server\", procedure: \"\", line: 1 }))". "Ok(SQLError(Server(TokenError { code: 103010, state: 1, class: 16, message: \"Parse error at line: 1, column: 22: Incorrect syntax near 'stmt'.\", server: \"data-platform-sql-data-warehouse-server\", procedure: \"\", line: 1 })))"| session_id=af8ac40c-2ffe-410f-8ecb-70e45405ef78