It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Follow this question
Question details

×42,790
×4,693

question asked: Jul 09 '13, 12:06 a.m.
question was seen: 4,240 times
last updated: Jul 09 '13, 12:08 a.m.

Related questions

FAQ - How this Forum works

Why does 'Work Items' Data Collection Job Fail?

0
Dustan Daniel (39●2●17●23) | 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

Most liked answers|Newest answers ↓|Oldest answers

0
permanent link
Dustan Daniel (39●2●17●23) | 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.