Schedulers MSSQL problem.

[rbouza]

Hello,

We set up a few schedulers to run including the native workflow one. But we are getting this errors on the logs:

Wed Apr 29 12:21:02 2009 [25274][1][FATAL] SQL Server error: Incorrect syntax near 'st'.
Wed Apr 29 12:24:01 2009 [25374][1][FATAL] Incorrect syntax near 's'.: UPDATE schedulers s SET s.status = N'Active' WHERE s.id = N'3eb91e11-091c-8be4-5eb8-49c3a614ab4a'
Wed Apr 29 12:24:01 2009 [25374][1][FATAL] SQL Server error: Incorrect syntax near 's'.
Wed Apr 29 12:24:01 2009 [25374][1][FATAL] Incorrect syntax near 'st'.: UPDATE schedulers_times st SET st.status = N'failed' WHERE st.id = N'ee180991-3a13-2439-d162-49f8696a0095';
Wed Apr 29 12:24:01 2009 [25374][1][FATAL] SQL Server error: Incorrect syntax near 'st'.
Wed Apr 29 12:27:01 2009 [25483][1][FATAL] Incorrect syntax near 's'.: UPDATE schedulers s SET s.status = N'Active' WHERE s.id = N'3eb91e11-091c-8be4-5eb8-49c3a614ab4a'
Wed Apr 29 12:27:01 2009 [25483][1][FATAL] SQL Server error: Incorrect syntax near 's'.
Wed Apr 29 12:27:01 2009 [25483][1][FATAL] Incorrect syntax near 'st'.: UPDATE schedulers_times st SET st.status = N'failed' WHERE st.id = N'ee180991-3a13-2439-d162-49f8696a0095';

So as far as I know table aliases on MSSQL 2005 is not supported for UPDATES (maybe I'm wrong). So if you know how to solve this or you are having the same problem, please let the community know.

Thanks for your help, is really appreciated.

[eggsurplus]

I'm not sure where the query is off hand but this is definitely a bug. MSSQL doesn't support "UPDATE schedulers s SET...". It DOES support "UPDATE schedulers SET..." and "UPDATE s FROM schedulers s SET..." though. I'd suggest opening a bug at bugs.sugarcrm.com and copying that error along with this post here into it.

[maloner]

We are also having the same problem although it seems to be only for the Report Generation Job.

Anyone have any ideas?