It's all about the answers!

Ask a question

Why does 'Work Items' Data Collection Job Fail?


Dustan Daniel (3921723) | asked Jul 09 '13, 12:06 a.m.
edited Jul 09 '13, 12:08 a.m.
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)


One answer



permanent link
Dustan Daniel (3921723) | answered Jul 09 '13, 12:07 a.m.
edited Jul 09 '13, 12:07 a.m.
This worked for me: http://www-01.ibm.com/support/docview.wss?uid=swg1PM47297

Funny how it mentions fixed in 3.0.1.1

Your answer


Register or to post your answer.