iGrafx Process360 Live
Breadcrumbs

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
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:

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