-
Type:
Service Pack Request
-
Status: Closed
-
Resolution: Fixed
-
Affects Version/s: 5.0.3, 5.1.2
-
Component/s: Upgrades
-
Labels:None
-
Environment:MS SQLServer based environments with:
Alfresco 5.0.3
Alfresco 5.1.2
-
Bug Priority:
-
ACT Numbers:
00789791
The patch to apply the required indexes for the transactional metadata queries does not have into account the particularity discovered for MS SQLServer in: MNT-9764
The creation of the index "idx_alf_nprop_s" on "alf_node_properties"
on line 16 of the patch (see atached file)
CREATE INDEX idx_alf_nprop_s ON alf_node_properties (qname_id, node_id, string_value);
Where it SHOULD be:
CREATE INDEX idx_alf_nprop_s ON alf_node_properties (qname_id, node_id) INCLUDE (string_value);
Otherwise the index creation will fail with an error and the upgrade process stops