Uploaded image for project: 'Service Packs and Hot Fixes'
  1. Service Packs and Hot Fixes
  2. MNT-17340

Patch for MSSQL to handle large strings for transactional queries can be overwritten

    Details

    • Type: Service Pack Request
    • Status: Closed
    • Resolution: Fixed
    • Affects Version/s: 5.0.3, 5.1.2
    • Fix Version/s: 5.1.4, 5.2.2
    • Component/s: Upgrades
    • Labels:
      None
    • Environment:
      MS SQLServer based environments with:
      Alfresco 5.0.3
      Alfresco 5.1.2

      Description

      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

        Attachments

          Structure

            Activity

              People

              • Assignee:
                closedbugs Closed Bugs (Inactive)
                Reporter:
                asolerasenci Antonio Soler-Asenci [X] (Inactive)
              • Votes:
                0 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Structure Helper Panel