EAM-54074 CLONE - Work Orders | View Planned Part Availability - does not work for some work orders - HxGN EAM - Version 12.0 - Hexagon

HxGN EAM Resolved Issues for 2022

Language
English
Product
HxGN EAM
Search by Category
HxGN EAM Version
12

EAM-54074 CLONE - Work Orders | View Planned Part Availability - does not work for some work orders

 Description 

We were having real long load times and timeouts on the Work Orders screen when right-clicking and selecting View Planned Part Availability for some Work Orders, but not for all.

Through troubleshooting we narrowed the problem to what seems to be a bug on the R5PLNRESTRN View related to the join between r5objects and r5events using the e1 alias

When running the last section of the view in SQL and adding the e1.evt_code field to the display we observed the behaviour

Steps To reproduce

- Open Work Orders and query for 75314

- Do a right-click and select View Planned Part Availability

- Nothing happens and after long time : Unable to retrieve records. Please contact your system administrator.

- Try with another work order to see the difference

Expected Results - View Planned Part Availability popup windiw should open