Field Work export gives invalid column name error

Description of Issue

Errors received exporting work orders from Field Work:

  • Field Work error: Work Order Export: An error occurred when exporting work orders. Please see the System Logs for more information.
  • System Log error: An exception occurred in ExportWorkOrders Inner Exception Message: System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'HeaderId'.
Context
  • Enterprise Asset Management
  • EAM
Cause

Defect

Resolution

Install the appropriate work ticket for your version:

  • 2021.7.0.1739 - MUN-474827
  • 2021.8.0.1481 - MUN-474828
  • 2021.9.0.1266 - MUN-474829
  • 2021.10.0.944 - MUN-474825
  • 2021.11.0.681 - MUN-474826

Workaround: Export from Work Order Management

Additional Information