Jobs calling SQL stored procedures moved over to 7.5.1 with no problem. I changed a stored procedure, creating an alternate version for access shares on a file cluster. The procedure has two parameters, both taken from the trigger. One is the the full file path and the other is the change type.
Connection: Set to take me to the instance and database
Name of Stored Procedure: dbo.ClientFilePositioningVFC
Name Type Direction Value
Parameters: FullFilePath VarChar Input {TRIGGER(Active|LastTrigger|File.Result.FullPath)}
Event VarChar Input {TRIGGER(Active|LastTrigger|File.Result.ChangeType)}
ERROR RETURNED: Error in SQL query: ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near '{'.
It looks like the text representation of value is being passed and not the computed value.
I have attempted to turn off Validate value, but every time I clear the check box and go back in to verify it is checked again.
This works for jobs brought over, but not after I changed the stored procedure name to my new version.
The connection has not changed.
The parameters have not changed.
One parameter type was changed from NVarChar to VarChar as NVarChar no longer needed.
Direction has not changed.
Values have not changed.