Error encountered when running a Classifier on Azure Auto ML

Ivan Casana-Gallen 26 Reputation points
2024-03-27T22:16:32.3933333+00:00

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
Azure Machine Learning
Azure Machine Learning
An Azure machine learning service for building and deploying models.
2,922 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Ivan Casana-Gallen 26 Reputation points
    2024-04-04T15:51:39.11+00:00

    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.

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.