BMXAA4211E - Database error number 1 has occurred when operating mbo...

 BMXAA4211E - Database error number 1 has occurred when operating on WFINSTANCE

This solution you can use for any table generic solution in oracle db only 

this is duplicate id issue.. (if you cannot remove duplicate just increase nextval like i did since in my case too i can't find duplicate and max value is greater than nextval.

select max(WFID) from maximo.wfinstance

*select maximo.WFINSTANCESEQ.NEXTVAL from dual;

increase you value with some 1000's from o/p of query 1...

example

*alter sequence maximo.WFINSTANCESEQ restart start with 17572034;

Similary if it comes for wfcallstack 

 BMXAA4211E – Database error number 1 has occurred when operating on WFCALLSTACK:   Report the error to the owner of the deployment.

   

check maxvalue   

select max(wfcallstackid) from maximo.WFCALLSTACK 

   check next value

   select maximo.WFCALLSTACKSEQ.NEXTVAL from dual;

increase value by some 10000 etc......

alter sequence maximo.WFCALLSTACKSEQ restart start with 36946999;