IBM Support

Database Error Number 2601 Has Occurred While Operating on
WORKVIEW

Question & Answer


Question

Is there a workaround for the error, "BMXAA4211E - Database error number 2601 has occurred when operating on WORKVIEW"?

Cause

This error is the result of incorrect sequencing or corruption of the sequence generator. When this happens, the interface will present an error similar to, "BMXAA4211E - Database error number 2601 has occurred when operating on WORKVIEW Record=12-3456789 Class=WORKORDER Site=YOURSITE. Cannot insert duplicate key row in object 'dbo.workview' with unique index 'workview_ndx'.

This errror may occur when inserting a new Work Order record.

Answer

Execute the following database updates to correct this issue. Please note that this will not work exactly as described with Oracle databases, as sequence functionality is present.

1. Get the highest current value for WORKVIEWID plus 1:

select max(WORKVIEWID)+1 from WORKVIEW

2. Update the sequence, using the number from the select query above:

update maxsequence set maxreserved = ### where tbname='WORKVIEW' and
name = 'WORKVIEWID'

Example: if the maximum number is 5000, then the update statement is:

update maxsequence set maxreserved = 5001 where tbname='WORKVIEW' and
name = 'WORKVIEWID'

3. It is necessary to restart Maximo after updating the sequence, so
please restart from the WebSphere console when users are out of the
application.

[{"Product":{"code":"SSLKT6","label":"IBM Maximo Asset Management"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Work View","Platform":[{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"Version Independent","Edition":"Enterprise","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]

Document Information

Modified date:
17 June 2018

UID

swg21598339