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

[kinguru]

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)

[IanMoroney]

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

[biohazardxxx]

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.