Skip to main content

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:

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:

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