The Multi-Company Process is quite fragile and it sometimes takes 1 bad record to get the entire Queue stuck. Currently Epicor provides a little Maintenance screen to look at the IntQueue but most of the times it won’t even report the Error (IntError) and you have to go to SQL to wipe IM Tables away and do your diligence what’s missing.
Just some better Oversight, Canceling, Viewing Progress Multi-Company Process Entry Screen.
Ability to Investigate / Cancel:
- Queue Out
- Queue In
- IM Table Issues
Since we are at it bump up the 1000 records to limit to 10,000 atleast; its hard-coded in the Multi-Company Assembly.
Currently I Investigate it via SQL, but needs a SQL Admin / Dev / IT Person:
select t.name TableName, i.rows Records from sysobjects t, sysindexes i where t.xtype = 'U' and i.id = t.id and i.indid in (0,1) AND t.name LIKE 'IM%' order by i.rows desc; SELECT * FROM IM.IMPart; SELECT * FROM IM.IMVendPBrk; SELECT * FROM IM.IMVendPart; --DELETE FROM IM.IMVendor; --DELETE FROM IM.IMVendorPP; --DELETE FROM IM.IMVendCnt; SELECT * FROM Erp.IntError; SELECT * FROM Ice.IntQueOut; SELECT * FROM Ice.IntQueIn; SELECT * FROM Erp.Part WHERE Company = '00100000'; SELECT * FROM Erp.VendPart WHERE Company = '00100000';
Example 2 (Another Manual Sshot of Queries to fix Bad GL Data):