Since our upgrade to 2021.2.8 (from 10.2.700.x), we get random corruption on a few things. Epicare isn’t motivated enough to assist in trying to figure out the root cause, and the ‘solution’ is a Data Fix. Now we’ve got a few we have to run daily.
Is there any way we can run the data fix automatically?
We shouldn’t have to use a tech to run them manually every morning… How can I automate this?
Steps:
Open Data Fix Workbench
Click on ‘DataFix’ button, then ‘Search’ button, and select the specific generic datafix & click ‘OK’.
Click on ‘Run Data Fix’ tab, then ‘Report’ button’ and if any records appear, then ‘Select All’
Click on ‘Update’ button
Click on ‘Yes’ pop-up if we want to check again.
Repeat steps 2 thru 5 for the other data fixes…
Close Data Fix Workbench.
Note to Epicor support / devs: I understand that it’s hard to identify the root cause of random issues, but jeez! Don’t just automatically punt it back and say there’s nothing we can do until you figure it out yourself! When something worked fine in 10.0, 10.1, 10.2, and now sometimes gets messed up in Kinetic 2021, there is an obligation to work with your customers that pay for six figure maintenance support…
@josecgomez - Cool, I’ll have to check that out. Easier than pulling teeth from support, who has to beg dev’s to explain how the data fix does it…
We’re running these daily since our upgrade from 10.2.700 to Kinetic 2021.2.8:
MultiCompanyDirectLog Error - System.NullReferenceException. The data fix action shows ‘imcustcnt not on glbcustcnt table’. Support hasn’t completely given up on this yet, and we might figure it out… But it’s been nearly 2 months.
Case Entry error - Ship To contact references invalid value. The datafix changes the shpconnum from some integer to zero.
(Not Data Fix) - Recalculate Customer Credit - We used to do this every few weeks, but now have to run it daily since the upgrade to Kinetic…
But in good news, something improved with part allocations. The last month we ran Refresh Part Quantities and Allocations, it was clean! No records, where usually we’d get about 20 pages worth (we’d run it monthly). Back on 10.2.500, Epicor fixed something, and since then, Refresh PartBin QOH from PartTranhas been running clean too.
All the data fixes I’ve received from support recently have expiration dates, making them unusable after a few weeks. So even if you automated it, it may not be a long term solution.
@aosemwengie1 - Good point. I just had to request a new data fix to replace the one that expired. We’ll see if I can get one without an expiration date, or at least one that’s a year out (after we’ve upgraded to vNext).
@ScottLepley - Thanks! We have a dashboard that shows customers that need to have the recalc run (querying the GlbCustCred table where TotalOrders or TotalInvoices is negative), which we paste into the Recalculate Customer Credit’s filter tab. It’s a very bad time if someone forgets, and runs it wide open, with over a million customers! Can that be added to the filter somehow programmatically?
@Jonathan - Thank you - They are cases CS0003022656 & CS0002975394.
Regarding CS0003022656, is there any pattern at all as to why some Sales Orders are getting invalid customer contact values? Are they entered manually or through an integration?
About CS0002975394, I did some quick tests and so far anything related to a Global customer is flowing properly, so no idea why in your case some global customers on the child companies are missing Ship Tos. How are the customers and their related entities created on the parent company and how are they synced?
Yes, almost! The first one right after our upgrade did not, but the next one a month later did. I just kicked off a ‘report only’ to see if it’s clean again - Not quite - 1 part only (3 pages), out of a million plus (way better than before!).
We upgraded from 10.2.700 in mid-Feb 2022 (from 10.2.500 in Feb 2021 and 10.2.300 in 2020).
