Database Access Error INSERT fails with WebLink column

Problem

While using an upgraded database from version 15 or earlier and scheduling a review cycle on a specific date, you receive an error saying:

SQL Error

SQL

StatementCallback; SQL [INSERT INTO [Schedule] ([ObjectID], [ScheduleType], [Enabled], [ManualStart], [SendReminder], [ByDateCase], [EveryInterval], [IntervalType], [Scheduler], [PesterUsers], [PesterInterval], [NotifyScheduler], [RecurringCycle], [MarkUnapproved], [ReminderDaysInAdvance], [RecurrencePattern], [EndType], [StartDateAndTime], [EndByDate], [MonthlyType], [MonthlyDayOfMonth], [MonthlyDayEveryXMonths], [MonthlyTheWeekOfMonth], [MonthlyTheDayOfWeek], [MonthlyTheEveryXMonths], [YearlyType], [YearlyEveryXYears], [YearlyOnMonth], [YearlyOnDayOfMonth], [YearlyOnTheWeekOfMonth], [YearlyOnTheDayOfWeek], [YearlyOnTheMonth])
...
Cannot insert the value NULL into column 'WebLink', table '[database].dbo.Schedule'; column does not allow nulls. INSERT fails.

Solution

These columns are no longer used by the application and can be removed. You will need SQL database access to execute the solution.

The columns:

LCID
WebLink
ItemName

Can be removed by the following SQL query:

Solution

SQL

ALTER TABLE [Schedule] DROP COLUMN [LCID]
ALTER TABLE [Schedule] DROP COLUMN [WebLink]
ALTER TABLE [Schedule] DROP COLUMN [ItemName]