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

SQLServer index limit reached for 'idx_alf_props_str'

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Resolution: Fixed
    • Affects Version/s: No Version
    • Fix Version/s: 3.2.1
    • Component/s: Build
    • Labels:
      None
    • Bug Priority:
      Category 2

      Description

      TEST-org.alfresco.repo.audit.AuditComponentTest.xml. This test failed with message: Cause: java.sql.SQLException: Operation failed. The index entry of length 2057 bytes for the index 'idx_alf_props_str' exceeds the maximum length of 900 bytes. Investigating this problem more deeply we've founded this article http://msdn.microsoft.com/en-us/library/ms191241.aspx where is said that SQL Server retains the 900-byte limit for the maximum total size of all index key columns. This excludes nonkey columns that are included in the definition of nonclustered indexes (http://msdn.microsoft.com/en-us/library/ms190806.aspx ). In our case we try to index field of type NVARCHAR(1024) so it can't be used as key column but it also can't be used as nonkey column ('idx_alf_props_str' index contains only one column but at least one key column must be defined). So at this time solution is just not create 'idx_alf_props_str' index (see AlfrescoPostCreate-3.2-PropertyValueTables.sql.6.diff).

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                closedbugs Closed Bugs
                Reporter:
                ahind Andrew Hind [X] (Inactive)
              • Votes:
                0 Vote for this issue
                Watchers:
                0 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: