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