microsoft / microsoft/sql-server-samples
Table Application.Logs produces error on the Clustered Columnstore Index when trying to deploy
Nobody has claimed this yet.
- Dominant language
- PowerShell
- Stars
- 11.2k
- Forks
- 9.1k
- Avg merge
- 2d 7h
- Merged PRs (30d)
- 14
Description
Cloned the repro as of 2018-11-24. Attempted to deply the WWI database. Received the following error.
Creating [Application].[Logs].[CCX_Application_Logs]...
Warning! The maximum key length for a clustered index is 900 bytes. The index 'CCX_Application_Logs' has maximum length of 8000 bytes. For some combination of large values, the insert/update operation will fail.
(774,1): SQL72014: .Net SqlClient Data Provider: Msg 35343, Level 16, State 1, Line 4 The statement failed. Column 'LogEvent' has a data type that cannot participate in a columnstore index. Omit column 'LogEvent'.
(771,0): SQL72045: Script execution error. The executed script:
CREATE CLUSTERED INDEX [CCX_Application_Logs]
ON [Application].Logs;
CREATE CLUSTERED COLUMNSTORE INDEX [CCX_Application_Logs]
ON [Application].[Logs] WITH (DROP_EXISTING = ON);
An error occurred while the batch was being executed.
Contributor guide
No contributing guide indexed for this repository
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
Start with the WWI database deployment definition for Application.Logs and reproduce the clustered columnstore index deployment shown in the error. Check the CCX_Application_Logs definition against the reported LogEvent incompatibility; done means the deployment completes without the SQL72014 or SQL72045 errors.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- sql
- Domain
- databases
- Issue type
- Bug
- Difficulty
- 2/5
- Estimated time
- 1-3 hours
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 38/100