Table SWWWIHEAD cannot be written URGENT
All my workflows are failing with this error. It says that the workflow engine is not able to create entries in this table because of duplicate entries error.
When I go to the workflow log, I see work items numbers such as 356, 357 etc where as the maximum work item number that is there in the table till yesterday was 1257999. It looks till for the workflows which are in process or the new workflows that are starting are not picking up the next number which should be 1258000 but instead using lower numbers that are available in the table such as 357 etc and then failing with duplicate entry message when trying to insert records in SWWWIHEAD.
Can anyone help me with this? This is in production environment and kind of URGENT. I will award sufficient award points for the person who points us in right direction.
Thanks in advance.
Look at transaction SWUW. This is where the Number Range is maintained for Work Items.