Return
-
Title
Configuration Wizard error: "[810143] Database error 50000: Indexname DialogDeferredOperation_TargetDate is too long" -
Description
The full error as reported by the configuration wizard:Processing step 'QBM DBQueueProcessing (install and start dbqueue processors)' failed.10 - Sql command failed.[810023] Error during execution of statement: exec QBM_PIndexCreateGenerated '%'[810143] Database error 50000: re-throw in Procedure QBM_PIndexDropRedundant, Line 5[810143] Database error 50000: re-throw in Procedure QBM_PIndexDropRedundant_i, Line 10[810143] Database error 50000: re-throw in Procedure QBM_PIndexCreate, Line 25[810143] Database error 50000: detected in (SRV=SQL01, DB=D1IM) Procedure QBM_PIndexCreate, Line 9[810143] Database error 50000: Indexname DialogDeferredOperation_TargetDate is too long. -
Cause
The index name is the issue here:
"Indexname DialogDeferredOperation_TargetDate is too long" -
Resolution
Check for a custom index on the referenced table and update the name, i.e. shorten it.