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