chb_state_workers object definition does not match the expected reference schema
Article ID: CTX212303
Updated On:
Description
To Run test Site successfully after upgrade.
On running test site we encounter a warning for "table chb_state_workers object definition does not match the expected reference schema". Although everything seems to be running OK.
Run test site successfully without any warning
Instructions
The issue happens because the page locks on the index of the chb_state.workers table are enabled by a maintenance task being run on SQL server or were enabled by a DBA manuallyOut of all the indexes in the chb_state_workers table the following pagelocks should be enabled:
1.workers_desktopgroupuid
2.workers_unregisteredfaultdeadline
All others should be disabled.
Areas Affected:
Page locking is disabled on the rest of the indexes to avoid deadlocks. For smaller sites or light user load we won’t see any issues (except the site test failure) however if the site is large and/or under load then we might start to see deadlocks and ultimately throughput issues and brokering failures.
Issue/Introduction
Customer performed upgrade of controller to 7.6 from 7.5 and while performing test site gets a warning
"chb_state_workers object definition does not match the expected reference schema"
Was this article helpful?
Yes
No
Powered by
