Return
-
Title
Error 'Set_Variable_1 - Error while getting SQL results' when using the Set_Variable activity in Automation -
Description
The error 'Set_Variable_1 - Error while getting SQL results' appears, when running a query such as the one below in an Automation .TAS file in Toad Data Point.
USE TEST
SELECT DISTINCT test.TABLE_NAME
FROM test1.TMP_TABLE_NAME
When you run the same query in the editor, it runs normally, but via automation, this error is seen. It happens on MySQL or Local Storage databases.
Sign In Required
You need to be signed in and under a current maintenance contract to view premium knowledge articles.