I’ve run the data scrubber with no failures.
I then create a new instance on E10.
I then run the migration and it makes it all the way down to step 500, then I get errors.
I have attached the log below. Some of these are very strange, like duplicate systemTaskAgent?
Does anyone have any thoughts as to what might be going on here?
Any assistance will be greatly appreciated.
The below logs are also in C:\Program Files (x86)\Common Files\Epicor Software Corporation\Database Manager Extensions\3.0.7\DB Migration\E10Migrate_Results.txt.
Starting Preparation
- IceSystemTablesMigration
Preparation Complete, Elapsed Time: 0.0067422s
Starting Execution Phase...
- IceSystemTablesMigration
Error Staging Tables Migration MigrateICETables.sql Violation of PRIMARY KEY constraint 'PK_XFileAttch'. Cannot insert duplicate key in object 'Ice.XFileAttch'. The duplicate key value is (eee92eab-91fe-76a7-e111-dae717bf4fa4).
Violation of PRIMARY KEY constraint 'PK_Memo'. Cannot insert duplicate key in object 'Ice.Memo'. The duplicate key value is (f75cbea7-d1e6-76b8-e111-925d4a2a3924).
The CREATE UNIQUE INDEX statement terminated because a duplicate key was found for the object name 'Ice.MemoCat' and the index name 'PK_MemoCat'. The duplicate key value is (COT, Erp, Customer, CS).
Could not create constraint or index. See previous errors.
The statement has been terminated.
The statement has been terminated.
The statement has been terminated.
Error Staging Tables Migration MigrateICETables.sql Violation of PRIMARY KEY constraint 'PK_SysAgent'. Cannot insert duplicate key in object 'Ice.SysAgent'. The duplicate key value is (SystemTaskAgent).
Violation of PRIMARY KEY constraint 'PK_SysConfig'. Cannot insert duplicate key in object 'Ice.SysConfig'. The duplicate key value is (, ESUrl, , ).
The statement has been terminated.
The statement has been terminated.
Error Staging Tables Migration MigrateICENonSystemData.sql Violation of PRIMARY KEY constraint 'PK_LangOrg'. Cannot insert duplicate key in object 'Ice.LangOrg'. The duplicate key value is (-656).
Violation of PRIMARY KEY constraint 'PK_LangTran'. Cannot insert duplicate key in object 'Ice.LangTran'. The duplicate key value is (-101, esm, ).
The statement has been terminated.
Error Staging Tables Migration MigrateICENonSystemData.sql Violation of PRIMARY KEY constraint 'PK_LangXref'. Cannot insert duplicate key in object 'Ice.LangXref'. The duplicate key value is (-656, Epicor.Mfg.UI.App.COT-POToAPInvXRef.dll).
The statement has been terminated.
Error Staging Tables Migration MigrateICENonSystemData.sql Violation of PRIMARY KEY constraint 'PK_ZDataField'. Cannot insert duplicate key in object 'Ice.ZDataField'. The duplicate key value is (ERP, CMCustomer, BillFrequency).
The statement has been terminated.
Error Staging Tables Migration MigrateERPTables.sql Violation of PRIMARY KEY constraint 'PK_VntgStat'. Cannot insert duplicate key in object 'Erp.VntgStat'. The duplicate key value is (cce919f9-2ee2-2ca7-e111-764b486fa7f1).
The statement has been terminated.
Error Staging Tables Migration MigrateERPNonSystemData.sql Violation of PRIMARY KEY constraint 'PK_TranGLC'. Cannot insert duplicate key in object 'Erp.TranGLC'. The duplicate key value is (COT, ApInvExp, 100, CO 010114, 1, 1, , , 0).
The statement has been terminated.
Error Staging Tables Migration MigrateERPNonSystemData.sql Violation of PRIMARY KEY constraint 'PK_GLJrnDtlMnl'. Cannot insert duplicate key in object 'Erp.GLJrnDtlMnl'. The duplicate key value is (COT, COTO-US, 2011, , GJ, 1, 1, CotoCalendar).
The statement has been terminated.
Error Staging Tables Migration MigrateERPNonSystemData.sql Violation of PRIMARY KEY constraint 'PK_BankAcct'. Cannot insert duplicate key in object 'Erp.BankAcct'. The duplicate key value is (COT, CITZ).
The statement has been terminated.
Execute Phase Complete: 72.3924323
Starting Cleanup Phase...
- IceSystemTablesMigration
Cleanup Phase: 0.0043451
The total execution time is 1.2088 minutes.
Regards,
Coto Technology, Inc.
66 Whitecap Drive
North Kingstown, RI 02852
Phone: (401) 583-7223
Cell: (401) 368-9938
Fax: (401) 942-0920
Email: Bill.Turgeon@...
Web: www.cotorelay.com
Please consider the environment before printing this email.
This e-mail and any attachments are for the sole use of the intended recipients and may be privileged or confidential. Any distribution, printing or other use by anyone else is prohibited. If you are not an intended recipient, please contact the sender immediately, and permanently delete this e-mail and attachments.