Error 0069

 

Updated: March 16, 2017

Error 0069

Exception occurs if the specified SQL script is not correct.

This error in Azure Machine Learning occurs if the specified SQL script has syntax problems, or if the columns or table specified in the script is not valid.

You will receive this error if the SQL engine encounters any error while executing the query or script. The SQL error message is normally reported back in the Error Log so that you can take action based on the specific error.

Revisit the module and inspect the SQL query for mistakes.

Verify that the query works correctly outside of Azure ML by logging in to the database server directly and running the query.

If there is a SQL generated message reported by the module exception, take action based on the reported error. For example, the error messages sometimes include specific guidance on the likely error:

  • No such column or missing database, indicating that you might have typed a column name wrong
  • SQL logic error near <SQL keyword>, indicating that you might have a syntax error before the specified keyword
Exception Messages
SQL script is incorrect.
SQL query "{0}" is not correct.
SQL query "{0}" is not correct: {1}

System_CAPS_ICON_tip.jpg Tip

Need more help or troubleshooting tips for Azure Machine Learning? Try these resources:

Module Error Codes

Show: