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)
|
One answer
|
This worked for me: http://www-01.ibm.com/support/docview.wss?uid=swg1PM47297
Funny how it mentions fixed in 3.0.1.1 |