SYMPTOMS

Error “-2147352566 (8002000A) Out of present range” when running VariTable Dayclose

CAUSE

Field size of some fields in table unithist is smallint instead of int.

RESOLUTION

this issue is will be fixed in VariTable release 3.0.90

FIX

to fix the problem run the following sql script

ALTER TABLE [dbo].[UNITHIST] ALTER COLUMN Y_ADULTS [int] NULL
go
ALTER TABLE [dbo].[UNITHIST] ALTER COLUMN Y_Tablessold [int] NULL
go
ALTER TABLE [dbo].[UNITHIST] ALTER COLUMN Y_Tables [int] NULL
go
ALTER TABLE [dbo].[UNITHIST] ALTER COLUMN Y_Seats [int] NULL
go
ALTER TABLE [dbo].[UNITHIST] ALTER COLUMN Y_Children [int] NULL
go
ALTER TABLE [dbo].[UNITHIST] ALTER COLUMN Y_NoShows [int] NULL
go
ALTER TABLE [dbo].[UNITHIST] ALTER COLUMN Y_Cancels [int] NULL
go
ALTER TABLE [dbo].[UNITHIST] ALTER COLUMN Y_Gutscheinpax [int] NULL
go
ALTER TABLE [dbo].[UNITHIST] ALTER COLUMN Y_Inhousepax [int] NULL
go