Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Cannot insert the value NULL into column 'statsID', table 'database1.dbo.tbl_AdaptiveIndexDefrag_Stats_log' #196

Open
kinguru opened this issue Jun 10, 2020 · 2 comments · May be fixed by #267
Open

Cannot insert the value NULL into column 'statsID', table 'database1.dbo.tbl_AdaptiveIndexDefrag_Stats_log' #196

kinguru opened this issue Jun 10, 2020 · 2 comments · May be fixed by #267

Comments

@kinguru
Copy link

kinguru commented Jun 10, 2020

Error 515 has occurred. Message: Cannot insert the value NULL into column 'statsID', table 'database1.dbo.tbl_AdaptiveIndexDefrag_Stats_log'; column does not allow nulls. INSERT fails. (Line Number: 2113)
@kinguru kinguru changed the title Cannot insert the value NULL into column 'statsID', table 'Aurelon.Hub.DataCollection.dbo.tbl_AdaptiveIndexDefrag_Stats_log' Cannot insert the value NULL into column 'statsID', table 'database1.dbo.tbl_AdaptiveIndexDefrag_Stats_log' Jun 10, 2020
IanMoroney added a commit to IanMoroney/tigertoolbox that referenced this issue Apr 7, 2022
@IanMoroney
Update usp_AdaptiveIndexDefrag.sql
fb7cb9c 
Fixes microsoft#196
@IanMoroney IanMoroney linked a pull request Apr 7, 2022 that will close this issue
Open
@IanMoroney
Copy link

@pmasl , can you review this PR which I opened to resolve this?

@biohazardxxx
Copy link

encountered this too in a Production DB resulting to not have the maintenance run for months and now left with a terrible index state. Allowed nulls for [tbl_AdaptiveIndexDefrag_Stats_log].[statsID] as temp fix.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

Update usp_AdaptiveIndexDefrag.sql IanMoroney/tigertoolbox
3 participants
@kinguru @biohazardxxx @IanMoroney