microsoft / microsoft/sql-server-samples

Table Application.Logs produces error on the Clustered Columnstore Index when trying to deploy

Open
#494 3 comments 0 reactions 0 assignees View on GitHub

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

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. 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

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.