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.
Was this topic helpful?
Document Information
More support for:
IBM Maximo Asset Management
Software version:
Version Independent
Operating system(s):
Solaris, Windows
Document number:
206259
Modified date:
17 June 2018
UID
swg21598339