Check system integrity - errors

Legacy Execution
1

Hi,

I upgraded from 3.8.2 to 3.8.7. After upgrade there was a task which failed. I attached logs. Could you please check what the problem is?

It starts with:
Running: Schema
| Missing item: IDX dbo.IX_Artifact_TenantId NONCLUSTERED 0
| Missing item: IDX dbo.IX_Artifact_TenantId TenantId
| Missing item: IDX dbo.IX_Channel_ProjectId NONCLUSTERED 0
| Missing item: IDX dbo.IX_Channel_ProjectId ProjectId
| Missing item: IDX dbo.IX_Deployment_ChannelId ChannelId

Regards,
Jan

ServerTasks-1967.log.txt (5 KB)

2

Hi Jan,

Thanks for getting in touch! We recently added some extra information in our documentation around what the schema check is: https://octopus.com/docs/administration/diagnostics
Your results show that you have extra added indexes that do not match our schema.

Hope that helps!
Vanessa

3

Hi Vanessa,

Please try to read it properly next time. Indexes were missing. But I found this is my fault, I incorrectly migrated DB.

Thank you for help and sorry for bothering.
Jan