When running an automation script with some variables, I get the following in the output automation log:
error 400: Activity 'Set_Variable_4' validation failed: Set Var - 1: Variable value is not valid <variable_value>
<automation_name>.log: Variable value = Unable to cast COM object of type 'MSScriptControl.ScriptControlClass' to interface type 'MSScriptControl.IScriptControl'. This operation failed because the QueryInterface call on the COM component for the interface with IID '{0E59F1D3-1FBE-11D0-8FF2-00A0D10038BC}' failed due to the following error: Error loading type library/DLL. (Exception from HRESULT: 0x80029C4A (TYPE_E_CANTLOADLIBRARY)).
Issue with the MSScriptControl in Automation variable validation. Toad for Data Analysts cannot load the DLL for this control. Toad relies on the OS for this DLL.
Ensure the ActiveX Control is installed on the Windows Server box or at least be reinstalled. Here is a link to download:
http://www.microsoft.com/en-us/download/details.aspx?id=1949
