Why does 'Work Items' Data Collection Job Fail?

CLM 4.0.3, SQL Server 2008 R2, RHEL 5.6.


Work Items job had been failing, ccm-etl log contained a lot of error messages i this format:

"The index "%.*ls" (partition %ld) on table "%.*ls" cannot be reorganized because it is being reorganized by another process."

e.g.

The index "INTRGCNT_PK" (partition 1) on table "INTEGRAL_RANGE_COUNTER" cannot be reorganized because it is being reorganized by another process.

Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: The index "INTRGCNT_PK" (partition 1) on table "INTEGRAL_RANGE_COUNTER" cannot be reorganized because it is being reorganized by another process.

                at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:196)

                at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1454)

                at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:786)

Additionally, this error was present:

ERROR e.workitem.internal.WorkItemsRemoteSnapshotService  - Operation failed. The index entry of length 970 bytes for the index 'REQHISSTRMEXT_IDX3' exceeds the maximum length of 900 bytes.

com.microsoft.sqlserver.jdbc.SQLServerException: Operation failed. The index entry of length 970 bytes for the index 'REQHISSTRMEXT_IDX3' exceeds the maximum length of 900 bytes.     at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:196)