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]