Selecting assemblies and operations in MES End Activity is SLOW

jlalonde · October 15, 2019, 6:23pm

My users are experiencing an issue where selecting the Assembly and Operation in End Activity takes over 15 seconds to give them the drop down menu. This has caused many issues (mostly users unwilling to log their work). Any ideas on what could cause this? We already have users clocking out of MES. This helped but did not resolve the issue completely.

Jason_Woods · October 16, 2019, 12:04am

Do you have any BPMs on those for GetList or GetRows?

jlalonde · October 16, 2019, 12:24pm

There are no BPMs enabled. This also happens when testing in base with no customization.

Jason_Woods · October 16, 2019, 1:31pm

Can you run a user trace to see what the screen is doing to filter the drop down?
Also, is your database progress or sql?

jlalonde · October 16, 2019, 2:30pm

Jason, I’ve never used user tracing before. How would I do this in 8?

The database is Progress.

Jason_Woods · October 17, 2019, 3:23am

In the main Epicor screen, is there a Tools > User Tracing?

jlalonde · October 17, 2019, 12:05pm

I found Tracing Options. I will enable it and post the report.

jlalonde · October 22, 2019, 8:09pm

Here’s the results from the tracing. Mine seem to hang more after entering the job number than the assembly and operation but similar MES response -

Epicor.Mfg.Lib.SessionMod Sync void 10/22/2019 16:03:33:4848403 PM 286.2339 Epicor.Mfg.BO.UserFile GetByID Epicor.Mfg.BO.UserFileDataSet 10/22/2019 16:03:33:7830430 PM 130.6511 Epicor.Mfg.BO.UserFile GetDefaults void 10/22/2019 16:03:33:9176883 PM 20.1818 Epicor.Mfg.BO.UserFile IsPasswordExpired bool 10/22/2019 16:03:33:9406208 PM 9.0037 Epicor.Mfg.Lib.SessionMod GetModuleAccess void 10/22/2019 16:03:33:9645814 PM 6.1851 Epicor.Mfg.Lib.SessionMod GetLicense void 10/22/2019 16:03:33:9725354 PM 15.2365 Epicor.Mfg.Lib.SessionMod GetLanguage string 10/22/2019 16:03:33:9884921 PM 6.0232 Epicor.Mfg.BO.LangName GetByID Epicor.Mfg.BO.LangNameDataSet 10/22/2019 16:03:34:0074423 PM 15.9552 Epicor.Mfg.Sec.SecRights CheckExecutionRights void 10/22/2019 16:03:34:1615518 PM 12.9619 Epicor.Mfg.Sec.SecRights CheckExecutionRights void 10/22/2019 16:03:34:1805368 PM 9.9208 Epicor.Mfg.Sec.SecRights CheckExecutionRights void 10/22/2019 16:03:34:1904576 PM 23.0132 Epicor.Mfg.Sec.SecRights CheckExecutionRights void 10/22/2019 16:03:34:2134708 PM 9.8981 Epicor.Mfg.BO.GenXData GetRows Epicor.Mfg.BO.GenXDataDataSet 10/22/2019 16:03:34:6844889 PM 30.9178 Epicor.Mfg.BO.GenXData GetVersion void 10/22/2019 16:03:35:3796955 PM 22.9377 Epicor.Mfg.BO.QuickSearch BAQExists void 10/22/2019 16:03:35:4074324 PM 49.4315 Epicor.Mfg.BO.QuickSearch BAQExists void 10/22/2019 16:03:35:4568639 PM 10.9725 Epicor.Mfg.BO.QuickSearch BAQExists void 10/22/2019 16:03:35:4678364 PM 14.959 Epicor.Mfg.BO.QuickSearch BAQExists void 10/22/2019 16:03:35:4827954 PM 48.8701 Epicor.Mfg.BO.GenXData GetVersion void 10/22/2019 16:03:35:5346573 PM 6.9809 Epicor.Mfg.BO.GenXData GetList Epicor.Mfg.BO.XXXDefListDataSet 10/22/2019 16:03:35:6149655 PM 56.0516 Epicor.Mfg.Sec.SecRights CheckExecutionRights void 10/22/2019 16:03:36:4674555 PM 80.7832 Epicor.Mfg.BO.DynamicQuery ExecuteByID System.Data.DataSet 10/22/2019 16:03:36:5502342 PM 20.9426 Epicor.Mfg.BO.GenXData GetVersion void 10/22/2019 16:03:36:5742267 PM 15.9002 Epicor.Mfg.BO.GenXData GetRows Epicor.Mfg.BO.GenXDataDataSet 10/22/2019 16:03:36:5901269 PM 56.8463 Epicor.Mfg.BO.Menu GetByID Epicor.Mfg.BO.MenuDataSet 10/22/2019 16:03:36:6828789 PM 14.9605 Epicor.Mfg.Sec.SecRights CheckExecutionRights void 10/22/2019 16:03:36:7247671 PM 14.9601 Epicor.Mfg.Sec.SecRights CheckExecutionRights void 10/22/2019 16:03:36:7556829 PM 8.9882 Epicor.Mfg.BO.GenXData GetList Epicor.Mfg.BO.XXXDefListDataSet 10/22/2019 16:03:37:0328252 PM 17.9519 Epicor.Mfg.BO.GenXData GetVersion void 10/22/2019 16:03:37:1782462 PM 13.9612 Epicor.Mfg.BO.ReportMonitor GetRowsKeepIdleTime Epicor.Mfg.BO.ReportMonitorDataSet 10/22/2019 16:03:37:1802407 PM 38.9181 '' AND WorkStationID ='BOLD04-PC 2']]> Epicor.Mfg.BO.Favorite GetList Epicor.Mfg.BO.FavFolderListDataSet 10/22/2019 16:03:37:2161670 PM 13.9622 Epicor.Mfg.BO.EmpBasic GetRows Epicor.Mfg.BO.EmpBasicDataSet 10/22/2019 16:03:38:4805726 PM 69.8133 Epicor.Mfg.Lib.SessionMod SetUser void 10/22/2019 16:03:40:9546175 PM 21.9403 Epicor.Mfg.BO.UserFile GetByID Epicor.Mfg.BO.UserFileDataSet 10/22/2019 16:03:40:9775551 PM 565.5363 Epicor.Mfg.BO.UserFile GetDefaults void 10/22/2019 16:03:41:5430914 PM 14.9827 Epicor.Mfg.BO.UserFile IsPasswordExpired bool 10/22/2019 16:03:41:5590544 PM 8.9965 Epicor.Mfg.BO.UserFile GetRows Epicor.Mfg.BO.UserFileDataSet 10/22/2019 16:03:41:5839680 PM 61.0075 Epicor.Mfg.BO.Menu GetRowsTranslated Epicor.Mfg.BO.MenuDataSet 10/22/2019 16:03:41:6589028 PM 253.4095 Epicor.Mfg.BO.Labor GetRows Epicor.Mfg.BO.LaborDataSet 10/22/2019 16:03:41:9222850 PM 304.3446 Epicor.Mfg.Lib.SessionMod GetLanguage string 10/22/2019 16:03:42:2655687 PM 6.9875 Epicor.Mfg.BO.LangName GetByID Epicor.Mfg.BO.LangNameDataSet 10/22/2019 16:03:42:2725562 PM 438.1577 Epicor.Mfg.Sec.SecRights CheckExecutionRights void 10/22/2019 16:03:42:9210831 PM 12.0083 Epicor.Mfg.BO.LangTran Translate Epicor.Mfg.BO.TranTextDataSet 10/22/2019 16:03:42:9380397 PM 1053.0155 Epicor.Mfg.BO.Menu GetRowsTranslated Epicor.Mfg.BO.MenuDataSet 10/22/2019 16:03:47:7247867 PM 10.0919 Epicor.Mfg.Sec.SecRights CheckExecutionRights void 10/22/2019 16:03:47:8504458 PM 15.9218 Epicor.Mfg.Sec.SecRights CheckExecutionRights void 10/22/2019 16:03:47:8883167 PM 13.2097 Epicor.Mfg.Sec.SecRights CheckExecutionRights void 10/22/2019 16:03:47:9202616 PM 9.9707 Epicor.Mfg.Sec.SecRights CheckExecutionRights void 10/22/2019 16:03:47:9760736 PM 9.1234 Epicor.Mfg.Sec.SecRights CheckExecutionRights void 10/22/2019 16:03:48:0359743 PM 8.9179 Epicor.Mfg.Sec.SecRights CheckExecutionRights void 10/22/2019 16:03:48:0807938 PM 245.732 Epicor.Mfg.BO.Labor GetList Epicor.Mfg.BO.LaborHedListDataSet 10/22/2019 16:03:48:4980659 PM 204.454 Epicor.Mfg.BO.GenXData GetList Epicor.Mfg.BO.XXXDefListDataSet 10/22/2019 16:03:48:7523868 PM 11.9672 Epicor.Mfg.BO.EmpBasic GetList Epicor.Mfg.BO.EmpBasicListDataSet 10/22/2019 16:03:48:9139820 PM 15.9644 Epicor.Mfg.BO.Labor GetList Epicor.Mfg.BO.LaborHedListDataSet 10/22/2019 16:03:48:9309468 PM 31.9279 Epicor.Mfg.BO.Labor GetByID Epicor.Mfg.BO.LaborDataSet 10/22/2019 16:03:48:9708061 PM 44.8759 Epicor.Mfg.BO.Labor StartActivity void 10/22/2019 16:03:49:0196726 PM 83.352 Epicor.Mfg.BO.Labor GetRows Epicor.Mfg.BO.LaborDataSet 10/22/2019 16:03:50:9521737 PM 35.5551 Epicor.Mfg.BO.EmpBasic ClockOut void 10/22/2019 16:03:52:7488383 PM 6863.7924 Epicor.Mfg.BO.Labor GetRows Epicor.Mfg.BO.LaborDataSet 10/22/2019 16:03:59:6126307 PM 1927.5121 Epicor.Mfg.BO.EmpBasic GetRows Epicor.Mfg.BO.EmpBasicDataSet 10/22/2019 16:04:05:9988832 PM 221.4322 Epicor.Mfg.BO.ReportMonitor GetRowsKeepIdleTime Epicor.Mfg.BO.ReportMonitorDataSet 10/22/2019 16:04:07:2270064 PM 15.9583 '' AND WorkStationID ='BOLD04-PC 2']]> Epicor.Mfg.Lib.SessionMod SetUser void 10/22/2019 16:04:07:9735866 PM 25.1106 Epicor.Mfg.BO.UserFile GetByID Epicor.Mfg.BO.UserFileDataSet 10/22/2019 16:04:07:9995520 PM 65.1138 Epicor.Mfg.BO.UserFile GetDefaults void 10/22/2019 16:04:08:0646658 PM 12.1908 Epicor.Mfg.BO.UserFile IsPasswordExpired bool 10/22/2019 16:04:08:0768566 PM 8.9754 Epicor.Mfg.BO.UserFile GetRows Epicor.Mfg.BO.UserFileDataSet 10/22/2019 16:04:08:0938106 PM 105.7185 Epicor.Mfg.BO.Menu GetRowsTranslated Epicor.Mfg.BO.MenuDataSet 10/22/2019 16:04:08:2005274 PM 145.8358 Epicor.Mfg.BO.Labor GetRows Epicor.Mfg.BO.LaborDataSet 10/22/2019 16:04:08:3503528 PM 26.9262 Epicor.Mfg.Lib.SessionMod GetLanguage string 10/22/2019 16:04:08:4002706 PM 5.1189 Epicor.Mfg.BO.LangName GetByID Epicor.Mfg.BO.LangNameDataSet 10/22/2019 16:04:08:4053895 PM 8.8258 Epicor.Mfg.BO.GenXData GetList Epicor.Mfg.BO.XXXDefListDataSet 10/22/2019 16:04:08:4191683 PM 27.3204 Epicor.Mfg.BO.EmpBasic CheckShift void 10/22/2019 16:04:09:7827119 PM 16.9191 Epicor.Mfg.BO.EmpBasic ClockIn void 10/22/2019 16:04:09:8255594 PM 224.7386 Epicor.Mfg.BO.Labor GetRows Epicor.Mfg.BO.LaborDataSet 10/22/2019 16:04:10:0502980 PM 30.9193 Epicor.Mfg.BO.LangTran Translate Epicor.Mfg.BO.TranTextDataSet 10/22/2019 16:04:10:1989775 PM 865.2668 Epicor.Mfg.BO.Menu GetRowsTranslated Epicor.Mfg.BO.MenuDataSet 10/22/2019 16:04:11:1231169 PM 29.9458 Epicor.Mfg.BO.Labor GetList Epicor.Mfg.BO.LaborHedListDataSet 10/22/2019 16:04:11:2079565 PM 31.8863 Epicor.Mfg.BO.EmpBasic GetList Epicor.Mfg.BO.EmpBasicListDataSet 10/22/2019 16:04:11:3782079 PM 12.0376 Epicor.Mfg.BO.Labor GetList Epicor.Mfg.BO.LaborHedListDataSet 10/22/2019 16:04:11:3902455 PM 30.2043 Epicor.Mfg.BO.Labor GetByID Epicor.Mfg.BO.LaborDataSet 10/22/2019 16:04:11:4204498 PM 33.8186 Epicor.Mfg.BO.Labor StartActivity void 10/22/2019 16:04:11:4542684 PM 270.8329 Epicor.Mfg.Sec.SecRights CheckExecutionRights void 10/22/2019 16:04:14:3585211 PM 87.7769 Epicor.Mfg.BO.Company GetCheckOffLabels void 10/22/2019 16:04:14:4483316 PM 132.5963 Epicor.Mfg.Sec.SecRights CheckExecutionRights void 10/22/2019 16:04:14:6317911 PM 8.01 Epicor.Mfg.BO.EpiSearch DoNamedSearch Epicor.Mfg.BO.NamedSearchDataSet 10/22/2019 16:04:14:6577215 PM 25.966 Epicor.Mfg.Sec.SecRights CheckExecutionRights void 10/22/2019 16:04:14:6996335 PM 20.9194 Epicor.Mfg.BO.QuickSearch GetBaseDefault void 10/22/2019 16:04:14:7215522 PM 8.9749 Epicor.Mfg.BO.JobEntry GetList Epicor.Mfg.BO.JobHeadListDataSet 10/22/2019 16:04:20:9479291 PM 5003.9449 Epicor.Mfg.BO.JobEntry GetList Epicor.Mfg.BO.JobHeadListDataSet 10/22/2019 16:04:28:0834139 PM 1916.1165 Epicor.Mfg.BO.JobEntry GetList Epicor.Mfg.BO.JobHeadListDataSet 10/22/2019 16:04:30:0553475 PM 1201.4093 Epicor.Mfg.BO.JobEntry GetList Epicor.Mfg.BO.JobHeadListDataSet 10/22/2019 16:04:31:3046291 PM 1210.8262 Epicor.Mfg.BO.JobEntry GetList Epicor.Mfg.BO.JobHeadListDataSet 10/22/2019 16:04:32:5742976 PM 1608.8285 Epicor.Mfg.BO.JobEntry GetList Epicor.Mfg.BO.JobHeadListDataSet 10/22/2019 16:04:34:2454707 PM 1486.3529 Epicor.Mfg.BO.ReportMonitor GetRowsKeepIdleTime Epicor.Mfg.BO.ReportMonitorDataSet 10/22/2019 16:04:37:2375841 PM 16.9545 '' AND WorkStationID ='BOLD04-PC 2']]> Epicor.Mfg.BO.JobEntry GetList Epicor.Mfg.BO.JobHeadListDataSet 10/22/2019 16:04:35:7926594 PM 1490.803 Epicor.Mfg.BO.JobEntry GetList Epicor.Mfg.BO.JobHeadListDataSet 10/22/2019 16:04:37:3532741 PM 1549.5287 Epicor.Mfg.BO.JobEntry GetList Epicor.Mfg.BO.JobHeadListDataSet 10/22/2019 16:04:38:9855821 PM 1750.9481 Epicor.Mfg.BO.ReportMonitor GetRowsKeepIdleTime Epicor.Mfg.BO.ReportMonitorDataSet 10/22/2019 16:05:07:2560191 PM 10.9005 '' AND WorkStationID ='BOLD04-PC 2']]> Epicor.Mfg.BO.Labor DefaultJobNum void 10/22/2019 16:05:04:6539700 PM 23553.8575 Epicor.Mfg.BO.EpiSearch DoNamedSearch Epicor.Mfg.BO.NamedSearchDataSet 10/22/2019 16:05:28:2606836 PM 15.9583 Epicor.Mfg.BO.QuickSearch GetBaseDefault void 10/22/2019 16:05:28:2796337 PM 16.1429 Epicor.Mfg.Lib.BOReader GetList System.Data.DataSet 10/22/2019 16:05:31:6606537 PM 46.9085 Epicor.Mfg.Lib.BOReader GetList System.Data.DataSet 10/22/2019 16:05:32:7178274 PM 53.8575 Epicor.Mfg.BO.Labor DefaultOprSeq void 10/22/2019 16:05:33:5851524 PM 232.3785 Epicor.Mfg.BO.ReportMonitor GetRowsKeepIdleTime Epicor.Mfg.BO.ReportMonitorDataSet 10/22/2019 16:05:37:2672666 PM 11.7235 '' AND WorkStationID ='BOLD04-PC 2']]> Epicor.Mfg.BO.Labor DefaultJobNum void 10/22/2019 16:05:43:2765001 PM 74.5842 Epicor.Mfg.BO.ReportMonitor GetRowsKeepIdleTime Epicor.Mfg.BO.ReportMonitorDataSet 10/22/2019 16:06:07:2804028 PM 547.8276 '' AND WorkStationID ='BOLD04-PC 2']]> Epicor.Mfg.BO.Labor DefaultJobNum void 10/22/2019 16:05:49:4916500 PM 38280.8975 Epicor.Mfg.Lib.BOReader GetList System.Data.DataSet 10/22/2019 16:06:31:4579172 PM 19.9463 Epicor.Mfg.Lib.BOReader GetList System.Data.DataSet 10/22/2019 16:06:33:1919627 PM 40.8859 Epicor.Mfg.BO.Labor DefaultOprSeq void 10/22/2019 16:06:34:0636958 PM 191.4885 Epicor.Mfg.BO.ReportMonitor GetRowsKeepIdleTime Epicor.Mfg.BO.ReportMonitorDataSet 10/22/2019 16:06:37:8296302 PM 12.9999 '' AND WorkStationID ='BOLD04-PC 2']]> Epicor.Mfg.BO.Labor CheckWarnings void 10/22/2019 16:06:37:9645346 PM 25.9315 Epicor.Mfg.BO.Labor CheckEmployeeActivity void 10/22/2019 16:06:37:9934564 PM 19.2421 Epicor.Mfg.BO.Labor CheckFirstArticleWarning void 10/22/2019 16:06:38:0134048 PM 46.8992 Epicor.Mfg.BO.Labor SetClockInAndDisplayTimeMES void 10/22/2019 16:06:38:0623099 PM 48.8321 Epicor.Mfg.BO.Labor Update void 10/22/2019 16:06:38:1141333 PM 443.8169 Epicor.Mfg.BO.Labor GetRows Epicor.Mfg.BO.LaborDataSet 10/22/2019 16:06:38:6217819 PM 92.7561 Epicor.Mfg.BO.Menu GetRowsTranslated Epicor.Mfg.BO.MenuDataSet 10/22/2019 16:06:41:3798611 PM 10.9714 Epicor.Mfg.Sec.SecRights CheckExecutionRights void 10/22/2019 16:06:41:4885713 PM 8.9759 Epicor.Mfg.BO.GenXData GetList Epicor.Mfg.BO.XXXDefListDataSet 10/22/2019 16:06:41:6521322 PM 26.9283 Epicor.Mfg.BO.EmpBasic GetList Epicor.Mfg.BO.EmpBasicListDataSet 10/22/2019 16:06:41:7778047 PM 9.9706 Epicor.Mfg.BO.Labor GetDetail Epicor.Mfg.BO.LaborDataSet 10/22/2019 16:06:41:7947511 PM 99.6834 Epicor.Mfg.BO.Labor EndActivity void 10/22/2019 16:06:41:9178739 PM 70.0631 Epicor.Mfg.BO.Labor CheckWarnings void 10/22/2019 16:06:46:3644651 PM 729.545 Epicor.Mfg.BO.Labor Update void 10/22/2019 16:06:47:0960041 PM 4129.3758 Epicor.Mfg.BO.Labor GetRows Epicor.Mfg.BO.LaborDataSet 10/22/2019 16:06:51:2991694 PM 7813.9332 Epicor.Mfg.BO.EmpBasic ClockOut void 10/22/2019 16:07:01:6095962 PM 76.9237 Epicor.Mfg.BO.Labor GetRows Epicor.Mfg.BO.LaborDataSet 10/22/2019 16:07:01:6865199 PM 25.9675 Epicor.Mfg.Lib.SessionMod GracefulShutdown void 10/22/2019 16:07:03:6331507 PM 10.971

Jason_Woods · October 22, 2019, 8:16pm

It looks like you have a customization on that screen that is running code too often. The last number on each line is the milliseconds.

Epicor.Mfg.BO.JobEntry GetList Epicor.Mfg.BO.JobHeadListDataSet 10/22/2019 16:04:20:9479291 PM 5003.9449 Epicor.Mfg.BO.JobEntry GetList Epicor.Mfg.BO.JobHeadListDataSet 10/22/2019 16:04:28:0834139 PM 1916.1165 Epicor.Mfg.BO.JobEntry GetList Epicor.Mfg.BO.JobHeadListDataSet 10/22/2019 16:04:30:0553475 PM 1201.4093 Epicor.Mfg.BO.JobEntry GetList Epicor.Mfg.BO.JobHeadListDataSet 10/22/2019 16:04:31:3046291 PM 1210.8262 Epicor.Mfg.BO.JobEntry GetList Epicor.Mfg.BO.JobHeadListDataSet 10/22/2019 16:04:32:5742976 PM 1608.8285 Epicor.Mfg.BO.JobEntry GetList Epicor.Mfg.BO.JobHeadListDataSet 10/22/2019 16:04:34:2454707 PM 1486.3529

jlalonde · October 22, 2019, 8:23pm

Here’s another run. I did this in MESC with base configuration. Job and Assembly both took 20+ seconds. There should be no customizations running in base, correct?

Epicor.Mfg.Lib.SessionMod Sync void 10/22/2019 16:20:43:7928013 PM 239.9181 Epicor.Mfg.BO.UserFile GetByID Epicor.Mfg.BO.UserFileDataSet 10/22/2019 16:20:44:0416968 PM 120.7237 Epicor.Mfg.BO.UserFile GetDefaults void 10/22/2019 16:20:44:1668583 PM 14.1808 Epicor.Mfg.BO.UserFile IsPasswordExpired bool 10/22/2019 16:20:44:1838144 PM 8.1627 Epicor.Mfg.Lib.SessionMod GetModuleAccess void 10/22/2019 16:20:44:2057898 PM 6.1589 Epicor.Mfg.Lib.SessionMod GetLicense void 10/22/2019 16:20:44:2137335 PM 8.9769 Epicor.Mfg.Lib.SessionMod GetLanguage string 10/22/2019 16:20:44:2227104 PM 7.224 Epicor.Mfg.BO.LangName GetByID Epicor.Mfg.BO.LangNameDataSet 10/22/2019 16:20:44:2406617 PM 14.9945 Epicor.Mfg.Sec.SecRights CheckExecutionRights void 10/22/2019 16:20:44:3224817 PM 12.9655 Epicor.Mfg.Sec.SecRights CheckExecutionRights void 10/22/2019 16:20:44:3394846 PM 11.9179 Epicor.Mfg.Sec.SecRights CheckExecutionRights void 10/22/2019 16:20:44:3524002 PM 8.977 Epicor.Mfg.Sec.SecRights CheckExecutionRights void 10/22/2019 16:20:44:3613772 PM 6.9824 Epicor.Mfg.BO.GenXData GetRows Epicor.Mfg.BO.GenXDataDataSet 10/22/2019 16:20:44:7438864 PM 11.9985 Epicor.Mfg.BO.GenXData GetVersion void 10/22/2019 16:20:45:3137073 PM 8.9775 Epicor.Mfg.BO.QuickSearch BAQExists void 10/22/2019 16:20:45:3267083 PM 3466.4122 Epicor.Mfg.BO.QuickSearch BAQExists void 10/22/2019 16:20:48:7931205 PM 10.7345 Epicor.Mfg.BO.QuickSearch BAQExists void 10/22/2019 16:20:48:8038550 PM 9.9721 Epicor.Mfg.BO.QuickSearch BAQExists void 10/22/2019 16:20:48:8138271 PM 9.9737 Epicor.Mfg.BO.GenXData GetVersion void 10/22/2019 16:20:48:8247976 PM 8.2182 Epicor.Mfg.BO.GenXData GetList Epicor.Mfg.BO.XXXDefListDataSet 10/22/2019 16:20:45:6282554 PM 3432.2116 Epicor.Mfg.Sec.SecRights CheckExecutionRights void 10/22/2019 16:20:49:1741291 PM 11.1926 Epicor.Mfg.BO.LangName GetList Epicor.Mfg.BO.LangNameListDataSet 10/22/2019 16:20:49:1871306 PM 70.8111 Epicor.Mfg.Sec.SecRights CheckExecutionRights void 10/22/2019 16:20:54:2579982 PM 193.5401 Epicor.Mfg.BO.DynamicQuery ExecuteByID System.Data.DataSet 10/22/2019 16:20:54:4674940 PM 24.9332 Epicor.Mfg.BO.GenXData GetVersion void 10/22/2019 16:20:54:4954571 PM 17.9502 Epicor.Mfg.BO.GenXData GetRows Epicor.Mfg.BO.GenXDataDataSet 10/22/2019 16:20:54:5134073 PM 283.2668 Epicor.Mfg.BO.GenXData GetVersion void 10/22/2019 16:20:54:8238152 PM 14.1792 Epicor.Mfg.BO.Favorite GetList Epicor.Mfg.BO.FavFolderListDataSet 10/22/2019 16:20:54:8527380 PM 265.8223 Epicor.Mfg.BO.EmpBasic GetRows Epicor.Mfg.BO.EmpBasicDataSet 10/22/2019 16:20:56:1621306 PM 99.0568 Epicor.Mfg.Lib.SessionMod SetUser void 10/22/2019 16:20:59:4608925 PM 36.1551 Epicor.Mfg.BO.UserFile GetByID Epicor.Mfg.BO.UserFileDataSet 10/22/2019 16:20:59:4970476 PM 63.038 Epicor.Mfg.BO.UserFile GetDefaults void 10/22/2019 16:20:59:5600856 PM 14.9656 Epicor.Mfg.BO.UserFile IsPasswordExpired bool 10/22/2019 16:20:59:5760398 PM 8.9281 Epicor.Mfg.BO.UserFile GetRows Epicor.Mfg.BO.UserFileDataSet 10/22/2019 16:20:59:5959373 PM 62.4674 Epicor.Mfg.BO.Menu GetRowsTranslated Epicor.Mfg.BO.MenuDataSet 10/22/2019 16:20:59:6703709 PM 59.8858 Epicor.Mfg.BO.Labor GetRows Epicor.Mfg.BO.LaborDataSet 10/22/2019 16:20:59:7372299 PM 29.4944 Epicor.Mfg.Lib.SessionMod GetLanguage string 10/22/2019 16:20:59:7906592 PM 6.1866 Epicor.Mfg.BO.LangName GetByID Epicor.Mfg.BO.LangNameDataSet 10/22/2019 16:20:59:7968458 PM 10.77 Epicor.Mfg.BO.GenXData GetList Epicor.Mfg.BO.XXXDefListDataSet 10/22/2019 16:20:59:8589287 PM 10.9957 Epicor.Mfg.BO.LangName GetList Epicor.Mfg.BO.LangNameListDataSet 10/22/2019 16:20:59:8728889 PM 89.5258 Epicor.Mfg.BO.EmpBasic CheckShift void 10/22/2019 16:21:04:6231154 PM 12.2345 Epicor.Mfg.BO.EmpBasic ClockIn void 10/22/2019 16:21:04:6589635 PM 108.3 Epicor.Mfg.BO.Labor GetRows Epicor.Mfg.BO.LaborDataSet 10/22/2019 16:21:04:7682618 PM 31.9454 Epicor.Mfg.BO.LangTran Translate Epicor.Mfg.BO.TranTextDataSet 10/22/2019 16:21:04:9699620 PM 859.3253 Epicor.Mfg.BO.Menu GetRowsTranslated Epicor.Mfg.BO.MenuDataSet 10/22/2019 16:21:08:1440549 PM 9.0622 Epicor.Mfg.Sec.SecRights CheckExecutionRights void 10/22/2019 16:21:08:1989395 PM 15.8288 Epicor.Mfg.Sec.SecRights CheckExecutionRights void 10/22/2019 16:21:08:2197032 PM 12.2473 Epicor.Mfg.Sec.SecRights CheckExecutionRights void 10/22/2019 16:21:08:2377033 PM 10.9679 Epicor.Mfg.Sec.SecRights CheckExecutionRights void 10/22/2019 16:21:08:2579489 PM 9.9649 Epicor.Mfg.Sec.SecRights CheckExecutionRights void 10/22/2019 16:21:08:2738614 PM 8.9764 Epicor.Mfg.Sec.SecRights CheckExecutionRights void 10/22/2019 16:21:08:2918456 PM 9.9773 Epicor.Mfg.BO.Labor GetList Epicor.Mfg.BO.LaborHedListDataSet 10/22/2019 16:21:08:5028245 PM 42.1838 Epicor.Mfg.BO.GenXData GetList Epicor.Mfg.BO.XXXDefListDataSet 10/22/2019 16:21:08:6347659 PM 12.9799 Epicor.Mfg.BO.LangName GetList Epicor.Mfg.BO.LangNameListDataSet 10/22/2019 16:21:08:6587090 PM 73.9098 Epicor.Mfg.BO.EmpBasic GetList Epicor.Mfg.BO.EmpBasicListDataSet 10/22/2019 16:21:12:4361305 PM 17.9539 Epicor.Mfg.BO.Labor GetList Epicor.Mfg.BO.LaborHedListDataSet 10/22/2019 16:21:12:4560866 PM 30.9076 Epicor.Mfg.BO.Labor GetByID Epicor.Mfg.BO.LaborDataSet 10/22/2019 16:21:12:4889892 PM 39.3257 Epicor.Mfg.BO.Labor StartActivity void 10/22/2019 16:21:12:5303136 PM 63.5361 Epicor.Mfg.BO.Labor DefaultJobNum void 10/22/2019 16:21:14:4002901 PM 20272.284 Epicor.Mfg.Lib.BOReader GetList System.Data.DataSet 10/22/2019 16:21:37:0761935 PM 47.1933 Epicor.Mfg.BO.Labor DefaultAssemblySeq void 10/22/2019 16:21:37:9519310 PM 26653.6947 Epicor.Mfg.Lib.BOReader GetList System.Data.DataSet 10/22/2019 16:22:06:9953224 PM 128.7116 Epicor.Mfg.BO.Labor DefaultOprSeq void 10/22/2019 16:22:08:0828777 PM 250.3581 Epicor.Mfg.BO.Labor CheckWarnings void 10/22/2019 16:22:11:1523754 PM 32.9108 Epicor.Mfg.BO.Labor CheckEmployeeActivity void 10/22/2019 16:22:11:1902730 PM 17.9529 Epicor.Mfg.BO.Labor CheckFirstArticleWarning void 10/22/2019 16:22:11:2102194 PM 32.9129 Epicor.Mfg.BO.Labor SetClockInAndDisplayTimeMES void 10/22/2019 16:22:11:2451263 PM 35.9072 Epicor.Mfg.BO.Labor Update void 10/22/2019 16:22:11:2850200 PM 369.8871 Epicor.Mfg.BO.Labor GetRows Epicor.Mfg.BO.LaborDataSet 10/22/2019 16:22:11:7694005 PM 99.7374 Epicor.Mfg.BO.Menu GetRowsTranslated Epicor.Mfg.BO.MenuDataSet 10/22/2019 16:22:14:8432105 PM 11.1375 Epicor.Mfg.Sec.SecRights CheckExecutionRights void 10/22/2019 16:22:14:8842680 PM 11.9672 Epicor.Mfg.BO.GenXData GetList Epicor.Mfg.BO.XXXDefListDataSet 10/22/2019 16:22:15:1020720 PM 30.9163 Epicor.Mfg.BO.LangName GetList Epicor.Mfg.BO.LangNameListDataSet 10/22/2019 16:22:15:1389719 PM 58.848 Epicor.Mfg.BO.EmpBasic GetList Epicor.Mfg.BO.EmpBasicListDataSet 10/22/2019 16:22:17:9819708 PM 64.8316 Epicor.Mfg.BO.Labor GetDetail Epicor.Mfg.BO.LaborDataSet 10/22/2019 16:22:18:0517826 PM 94.8559 Epicor.Mfg.BO.Labor EndActivity void 10/22/2019 16:22:18:1725649 PM 88.3346 Epicor.Mfg.BO.Labor CheckWarnings void 10/22/2019 16:22:19:8753862 PM 142.3603 Epicor.Mfg.BO.Labor Update void 10/22/2019 16:22:20:0187530 PM 484.1589 Epicor.Mfg.BO.Labor GetRows Epicor.Mfg.BO.LaborDataSet 10/22/2019 16:22:20:5856840 PM 103.6997 Epicor.Mfg.BO.EmpBasic ClockOut void 10/22/2019 16:22:23:3420061 PM 1872.6501 Epicor.Mfg.BO.Labor GetRows Epicor.Mfg.BO.LaborDataSet 10/22/2019 16:22:25:2154869 PM 25.9608 Epicor.Mfg.Lib.SessionMod GracefulShutdown void 10/22/2019 16:22:26:0740956 PM 10.9669

Jason_Woods · October 22, 2019, 8:56pm

Since there are no customizations, then BPMs need to be reviewed:

jlalonde · October 22, 2019, 9:01pm

Any thoughts on what BPM Business Objects would need to be looked at? Would it be Labor?

Jason_Woods · October 22, 2019, 9:20pm

Yes. The image I pasted shows the BO and Method.

Jason Woods
http://LinkedIn.com/in/jasoncwoods

bordway · October 22, 2019, 10:02pm

Besides BPMs already mentioned…

I’m curious how are users getting to End Activity screen
and which dropdown in End Activity?
Since I’ve only seen lag issues with Start Activity but…
never any performance issues with End Activity ( when launched from the main MES form ).

jlalonde · October 23, 2019, 12:00pm

Jason, I’m looking at the Method Directives and, I believe, there’s nothing in them. Here are photos of the Detail, List, Pre-Processing, Base Processing, and Post-Processing.

Detail:

List:

Pre-Processing:

Base Processing:

Post-Processing:

Am I looking in the right area? I’ve never done anything with BPMs before so I’m not sure exactly what I’m looking for.

jlalonde · October 23, 2019, 12:01pm

Bruce,

You’re correct. I accidentally said END activity. It’s how our organization defines the process. It is at the start when they start activity. Have you seen any way to speed this up?

Jason_Woods · October 23, 2019, 2:04pm

That is disappointing. The last step is to see how many jobs are not yet closed. Do you regularly use Job Completion/Closing?

jlalonde · October 23, 2019, 2:37pm

So I’m reading it right that it doesn’t appear to be any BPMs running?

We do regularly use Job Complete/Closing. We do have 2003 jobs that are open. 583 of them are from June 2019 or earlier are open/not complete.

Could this be the cause?

Jason_Woods · October 23, 2019, 2:50pm

For this logic, it should be filtered by JobComplete. However, without any BPMs and it running that slow, I fear your database may have issues. Is it SQL or Progress?

jlalonde · October 23, 2019, 2:56pm

It is SQL with a Progress layer.