Scheduling Errors

A place to report bugs and discuss testing
Post Reply
Message
Author
mrrrl
Posts: 8
Joined: Sun Feb 02, 2014 2:48 pm

Scheduling Errors

#1 Post by mrrrl » Thu Feb 06, 2014 8:28 pm

Trying to add getting this error when updating:

02/06/2014 09:11:50.006 PM - ScheduleRecurringUpdate error: CALL osae_sp_schedule_recurring_update(@OldScheduleName, @NewScheduleName, @Object, @Method, @Parameter1, @Parameter2, @Script, @RecurringTime, @Sunday, @Monday, @Tuesday, @Wednesday, @Thursday, @Friday, @Saturday, @Interval, @RecurringMinutes, @RecurringDay, @RecurringDate, @Active) - error: Incorrect integer value: 'Lamp A2' for column 'object_id' at row 1

Or when adding:

02/06/2014 09:21:16.053 PM - ScheduleRecurringAdd error: CALL osae_sp_schedule_recurring_add(@ScheduleName, @Object, @Method, @Parameter1, @Parameter2, @Script, @RecurringTime, @Sunday, @Monday, @Tuesday, @Wednesday, @Thursday, @Friday, @Saturday, @Interval, @RecurringMinutes, @RecurringDay, @RecurringDate, @Active) - error: Incorrect integer value: 'Lamp A2' for column 'object_id' at row 1

Here is the object:

SYSTEM Lamp A2 X10 RELAY Off 2/6/2014 9:07:15 PM A2

Could add but could never get it to "active" state.

Thanks

Automate
Posts: 1691
Joined: Sat Dec 11, 2010 1:44 pm
Location: US

Re: Scheduling Errors

#2 Post by Automate » Fri Feb 07, 2014 3:19 am

This is a known bug that has been fixed in our Git source code. The problem is with scheduling methods so your options are:

1. Create a script with your method and then schedule the script
2. Make the MySQL change documented here http://www.opensourceautomation.com/php ... 7664#p7664
3. Wait for the next release which will include the fix.

Post Reply