Error: Required Field Process wonum is Blank

When saving a workorder , get error: "Required Field Process work order is Blank"

Cause

This error can happen if an index is missing / not unique, and refreshing index via database configuration application will change the primarykeycolseq value during Data Migration or Database Upgrade.


Resolving the problem

Run the query below to determine the problem:
select attributename, primarykeycolseq from maxattributecfg where objectname = 'WORKORDER' and attributename = 'WONUM'

If the output returns NULL for primarykeycolseq then run the update statement below to fix the problem:

update maxattributecfg set primarykeycolseq = 2 where objectname =
'WORKORDER' and attributename = 'WONUM'
update maxattribute set primarykeycolseq = 2 where objectname =
'WORKORDER' and attributename = 'WONUM'
Restart the Application Server for the change to take effect.


You should be able to save any workflow process after fixing the primarykeycolseq