Here is a scenario where an upgrade of ICC failed with errors from ICC 126.96.36.199 to ICC 4.0.1 and steps taken to rectify these errors.
The upgrade installer reported ICC was sucessfully upgraded. ICC Configuration Manager is started for the first time after the upgrade, upon starting the Configuration Manager and opting to import and upgrade the configuration data from the ICC 188.8.131.52 external database, various errors are reported:
The following errors are reported while using the ICC Configuration Manager to complete the data store import:
Error occured in 'DataAccess' - 'Failed to read from an IPC Port: The pipe has been ended. '
at NetSvc.Common.CatalogProxy.InvokeCatalogServiceSync(IDataIn input) in d:\builds\ctms_ui\ctms_ui_201511022204\svn\EMA\UiServices\NetSvc\Common\CatalogProxy.cs
at NetSvc.Common.Proxy.CatalogInvokeSync(IDataIn input) in
oxy.cs:line 27 at DataAccess.DataStoreTable.MigrateDataStore(DataStoreDefinitionNET
legacyDefinition, DataStoreDefinitionNET solidDefintion)
The root cause for these errors is due to the fact the customers ICC 184.108.40.206 database with the "black_list", "report_data_minute" and "report_data_hour" tables was consuming > 8GB size at the time of import. The ICC 4.0.1 Solid DB grew to about 4GB in size when it reported the error.
Best practice always is to make sure to first backup the three largest tables within ICC and then purge them prior to the upgrade. These tables are"black_list", "report_data_minute" and "report_data_hour"