It's all about the answers!

Ask a question

Why does 'Work Items' Data Collection Job Fail?


Dustan Daniel (3921823) | 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 (3921823) | 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.


Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.