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 |