Hi,
we have a tabel with a columnstore index where DBCC fails with the following error:
Msg 5283, Level 16, State 1, Line 1CREATE TABLE [dbo].[factLossToLayer](
[ByesId] [bigint] NOT NULL,
[ByesSequenceID] [bigint] NOT NULL,
[EventID] [bigint] NOT NULL,
[TrialID] [int] NOT NULL,
[TimeOfLossTK] [int] NOT NULL,
[CeltTK] [int] NOT NULL,
[RltTK] [int] NOT NULL,
[BetTK] [int] NOT NULL,
[PMLAreaTK] [int] NOT NULL,
[EventTK] [int] NOT NULL,
[EventPropertiesTK] [int] NOT NULL,
[EventOccurrenceTK] [int] NOT NULL,
[ContractTK] [int] NOT NULL,
[ModelGroupTK] [int] NOT NULL,
[ModelTK] [int] NOT NULL,
[OriginalCurrencyTK] [int] NOT NULL,
[CededLossOriginalCurrency] [money] NOT NULL,
[GrossAmountOriginalCurrency] [money] NOT NULL,
[GrossNetAmountOriginalCurrency] [money] NOT NULL,
[CededLossUSD] [money] NOT NULL,
[GrossAmountUSD] [money] NOT NULL,
[GrossNetAmountUSD] [money] NOT NULL,
[ReinstatementPremiumToPremiumRatio] [decimal](18, 16) NOT NULL,
[ReinstatementPremiumAmountOriginalCurrency] [money] NOT NULL,
[ReinstatementPremiumAmountUSD] [money] NOT NULL,
[ReinstatementPremiumGrossNetAmountOriginalCurrency] [money] NOT NULL,
[ReinstatementPremiumGrossNetAmountUSD] [money] NOT NULL,
[TaxFactor] [decimal](8, 7) NULL,
[RltRowFraction] [decimal](18, 17) NOT NULL,
[PackageExecutionId] [int] NOT NULL,
[RowInserted] [datetime] NOT NULL
The Cross Rowset check on columnstore index object ID 299148111, index ID 16, partition ID 72057698163752960. Drop and recreate the columnstore index.
CHECKDB found 0 allocation errors and 1 consistency errors in table 'factLossToLayer' (object ID 299148111).
CHECKDB found 0 allocation errors and 1 consistency errors in database 'GPIR_DM_Prod'.
I found a blog statiting that states that "Right now, a columnstore index supports only common business data types like int, real, string, money, datetime, the decimal data type has to be less than 18 digits."
But that was on CTP3 and our developers states that the limitation is "up to" 18 digits for decimal...
We have two columns with decimal 18, could that be the problem ? I have tried dropping the index and recreating, but I get the same error.
http://blogs.lessthandot.com/index.php/DataMgmt/DBAdmin/MSSQLServerAdmin/columnstore-index-limitations-in-sql
The server is on 11.0.2332 and here is a table and index definition:
CREATE NONCLUSTERED COLUMNSTORE INDEX [csx_factLossToLayer] ON [dbo].[factLossToLayer]
(
[ByesId],
[ByesSequenceID],
[EventID],
[TrialID],
[TimeOfLossTK],
[CeltTK],
[RltTK],
[BetTK],
[PMLAreaTK],
[EventTK],
[EventPropertiesTK],
[EventOccurrenceTK],
[ContractTK],
[ModelGroupTK],
[ModelTK],
[OriginalCurrencyTK],
[CededLossOriginalCurrency],
[GrossAmountOriginalCurrency],
[GrossNetAmountOriginalCurrency],
[CededLossUSD],
[GrossAmountUSD],
[GrossNetAmountUSD],
[ReinstatementPremiumToPremiumRatio],
[ReinstatementPremiumAmountOriginalCurrency],
[ReinstatementPremiumAmountUSD],
[ReinstatementPremiumGrossNetAmountOriginalCurrency],
[ReinstatementPremiumGrossNetAmountUSD],
[TaxFactor],
[RltRowFraction],
[PackageExecutionId],
[RowInserted]
)WITH (DROP_EXISTING = OFF)
GO
