Longer index names cause upgrade and DBQueue processing issues (4383276)

After upgrading from Identity Manager 9.2.x to 9.3.x or later, the environment may experience:

• DBQueue tasks stuck or not processing
• Deferred operations failing
• SQL errors related to missing or truncated index names
• Errors referencing custom indexes on CCC_* tables

Example:

PK_CCC_TempTable_CCC_UID_ElarkDynamic

was internally truncated to:

PK_CCC_TempTable_CCC_UID_Elark

This can cause mismatches between the expected index name and the actual database object.

Starting from Identity Manager 9.3.0, custom index names are limited to 30 characters.

Environments upgraded from earlier versions may still contain custom indexes with names longer than 30 characters.

These indexes may have worked correctly in previous versions, but newer versions of Identity Manager can truncate the names internally during processing.

Review all custom indexes and constraints, especially on custom CCC_* tables.

Identify indexes with names longer than 30 characters and rename them to shorter unique names.

Example SQL query to find these index names:

SELECT 
    t.name AS TableName,
    i.name AS IndexName,
    LEN(i.name) AS NameLength
FROM sys.indexes i
JOIN sys.tables t ON i.object_id = t.object_id
WHERE 
    t.name LIKE 'CCC_%'
    AND LEN(i.name) > 30
ORDER BY LEN(i.name) DESC;

After renaming the indexes:

• Update the names in Designer if they are defined there
• Recompile the database
• Restart affected services if necessary