EAM performance issues with work orders that are left open for long periods of time
Description of Issue
Field Sheet app crashing when attempting to add detail info to work order
Error in Field Work when attempting to add equipment detail to work order:
Add Equipment Failed
Could not insert equipment detail record ( -691 ).
Context
Enterprise Asset Management
EAM
Cause
Work orders were left open for long periods of time and accumulated so much detail that they started to bog down the performance
Resolution
Best practice is to close work orders at least every year (or more often if they accumulate data more quickly and performance issues start to be seen) and create new ones
Additional Information