Upgrade E10.1.600 on E10.1.500

Epicor ERP 10
1

I am trying to upgrade E10.1.600 on E10.1.500 environment i am following below steps.

  1. Taking Live DB backup restored on Test environment using administrator console of Epicor kept for Database upgrade during that process I am getting below error message .

Starting Preparation

  • Ice.Internal.Upgrade.ReportDataDefinition
    Preparation Complete: 0.0013117 seconds

Starting Execution Phase…

  • Ice.Internal.Upgrade.ReportDataDefinition
    Information Ice.Internal.Upgrade.ReportDataDefinition Ice.Internal.Upgrade.ReportDataDefinition~ Upgrading customized Report Data Definitions
    Information Ice.Internal.Upgrade.ReportDataDefinition Ice.Internal.Upgrade.ReportDataDefinition~ Process Ice.RptTable records…
    Information Ice.Internal.Upgrade.ReportDataDefinition Ice.Internal.Upgrade.ReportDataDefinition~ Ice.RptTable Records Affected: 0
    Information Ice.Internal.Upgrade.ReportDataDefinition Ice.Internal.Upgrade.ReportDataDefinition~ Process Ice.RptRelation records…
    Information Ice.Internal.Upgrade.ReportDataDefinition Ice.Internal.Upgrade.ReportDataDefinition~ Ice.RptRelation Records Affected: 0
    Information Ice.Internal.Upgrade.ReportDataDefinition Ice.Internal.Upgrade.ReportDataDefinition~ Process Ice.RptRelationField records…
    Information Ice.Internal.Upgrade.ReportDataDefinition Ice.Internal.Upgrade.ReportDataDefinition~ Ice.RptRelationField Records Affected: 0
    Information Ice.Internal.Upgrade.ReportDataDefinition Ice.Internal.Upgrade.ReportDataDefinition~ Process Ice.RptCalcField records…
    Information Ice.Internal.Upgrade.ReportDataDefinition Ice.Internal.Upgrade.ReportDataDefinition~ Ice.RptCalcField Records Affected: 0
    Information Ice.Internal.Upgrade.ReportDataDefinition Ice.Internal.Upgrade.ReportDataDefinition~ Process Ice.RptLinkTable records…
    Information Ice.Internal.Upgrade.ReportDataDefinition Ice.Internal.Upgrade.ReportDataDefinition~ Ice.RptLinkTable Records Affected: 0
    Information Ice.Internal.Upgrade.ReportDataDefinition Ice.Internal.Upgrade.ReportDataDefinition~ Process Ice.RptLinkField records…
    Information Ice.Internal.Upgrade.ReportDataDefinition Ice.Internal.Upgrade.ReportDataDefinition~ Ice.RptLinkField Records Affected: 0
    Execute Phase Complete: 1.3929566 seconds

Starting Cleanup Phase…

  • Ice.Internal.Upgrade.ReportDataDefinition
    Cleanup Phase: 0.000676 seconds

Starting Preparation

  • SSRS Breaking/Routing Rules
    Preparation Complete: 0.0006852 seconds

Starting Execution Phase…

  • SSRS Breaking/Routing Rules
    Information SSRS Breaking/Routing Rules SSRS Breaking/Routing Rules~ Starting upgrade for SSRS Breaking/Routing rules.
    Information SSRS Breaking/Routing Rules SSRS Breaking/Routing Rules~ Upgrade for SSRS Breaking/Routing rules completed successfully.
    Execute Phase Complete: 0.0052626 seconds

Starting Cleanup Phase…

  • SSRS Breaking/Routing Rules
    Cleanup Phase: 0.0007221 seconds

Starting Preparation

  • Post Migration
    Preparation Complete: 0.0021046 seconds

Starting Execution Phase…

  • Post Migration
    Information Post Migration Post Migration ~ Executing: ICE3_ExtendedEvents.sql
    Information Post Migration Post Migration ~ Executing: BackupXXXDefXXXChunk.sql
    Information Post Migration Post Migration ~ Executing: CaptureLogCleanup.sql
    Information Post Migration Post Migration ~ Executing: CleanupCacheAndAssemblyStore.sql
    Information Post Migration Post Migration ~ Executing: DeleteFromSysTask.sql
    Information Post Migration Post Migration ~ Executing: InsertZDataFieldwithUD.sql
    Information Post Migration Post Migration ~ Executing: Set_IDENTITY_INSERT_OFF.sql
    Information Post Migration Post Migration ~ Executing: SyncUDRows.sql
    Error Post Migration SyncUDRows.sql Invalid object name ‘dbo.Budget’.
    Invalid object name ‘dbo.Budget’.
    DELETE UDTable
    FROM [dbo].[Budget_UD] UDTable
    WHERE NOT EXISTS (SELECT 1 FROM [dbo].[Budget] a
    WHERE a.SysRowID = UDTable.ForeignSysRowID)
    INSERT INTO [dbo].Budget_UD
    SELECT SysRowID FROM [dbo].[Budget] a
    WHERE NOT EXISTS (SELECT 1 FROM [dbo].[Budget_UD] b
    WHERE b.ForeignSysRowID = a.SysRowID)
    DELETE UDTable
    FROM [Erp].[GLJrnDtl_UD] UDTable
    WHERE NOT EXISTS (SELECT 1 FROM [Erp].[GLJrnDtl] a
    WHERE a.SysRowID = UDTable.ForeignSysRowID)
    INSERT INTO [Erp].GLJrnDtl_UD
    SELECT SysRowID FROM [Erp].[GLJrnDtl] a
    WHERE NOT EXISTS (SELECT 1 FROM [Erp].[GLJrnDtl_UD] b
    WHERE b.ForeignSysRowID = a.SysRowID)
    DELETE UDTable
    FROM [Erp].[GLJrnDtlMnl_UD] UDTable
    WHERE NOT EXISTS (SELECT 1 FROM [Erp].[GLJrnDtlMnl] a
    WHERE a.SysRowID = UDTable.ForeignSysRowID)
    INSERT INTO [Erp].GLJrnDtlMnl_UD
    SELECT SysRowID FROM [Erp].[GLJrnDtlMnl] a
    WHERE NOT EXISTS (SELECT 1 FROM [Erp].[GLJrnDtlMnl_UD] b
    WHERE b.ForeignSysRowID = a.SysRowID)
    DELETE UDTable
    FROM [Erp].[OrderHed_UD] UDTable
    WHERE NOT EXISTS (SELECT 1 FROM [Erp].[OrderHed] a
    WHERE a.SysRowID = UDTable.ForeignSysRowID)
    INSERT INTO [Erp].OrderHed_UD
    SELECT SysRowID FROM [Erp].[OrderHed] a
    WHERE NOT EXISTS (SELECT 1 FROM [Erp].[OrderHed_UD] b
    WHERE b.ForeignSysRowID = a.SysRowID)
    DELETE UDTable
    FROM [Erp].[Part_UD] UDTable
    WHERE NOT EXISTS (SELECT 1 FROM [Erp].[Part] a
    WHERE a.SysRowID = UDTable.ForeignSysRowID)
    INSERT INTO [Erp].Part_UD
    SELECT SysRowID FROM [Erp].[Part] a
    WHERE NOT EXISTS (SELECT 1 FROM [Erp].[Part_UD] b
    WHERE b.ForeignSysRowID = a.SysRowID)
    DELETE UDTable
    FROM [Erp].[RvJrnTrDtl_UD] UDTable
    WHERE NOT EXISTS (SELECT 1 FROM [Erp].[RvJrnTrDtl] a
    WHERE a.SysRowID = UDTable.ForeignSysRowID)
    INSERT INTO [Erp].RvJrnTrDtl_UD
    SELECT SysRowID FROM [Erp].[RvJrnTrDtl] a
    WHERE NOT EXISTS (SELECT 1 FROM [Erp].[RvJrnTrDtl_UD] b
    WHERE b.ForeignSysRowID = a.SysRowID)
    DECLARE @TableSchema sysname,
    @TableName sysna
    Execute Phase Complete: 4.9187459 seconds

Starting Cleanup Phase…

  • Post Migration
    Cleanup Phase: 0.0025352 seconds

DB Migration process is cancelled by the user.
The total execution time is 0.1071 minutes.
Starting Preparation

  • Ice.Internal.Upgrade.ReportDataDefinition
    Preparation Complete: 0.0013136 seconds

Starting Execution Phase…

  • Ice.Internal.Upgrade.ReportDataDefinition
    Information Ice.Internal.Upgrade.ReportDataDefinition Ice.Internal.Upgrade.ReportDataDefinition~ Upgrading customized Report Data Definitions
    Information Ice.Internal.Upgrade.ReportDataDefinition Ice.Internal.Upgrade.ReportDataDefinition~ Process Ice.RptTable records…
    Information Ice.Internal.Upgrade.ReportDataDefinition Ice.Internal.Upgrade.ReportDataDefinition~ Ice.RptTable Records Affected: 0
    Information Ice.Internal.Upgrade.ReportDataDefinition Ice.Internal.Upgrade.ReportDataDefinition~ Process Ice.RptRelation records…
    Information Ice.Internal.Upgrade.ReportDataDefinition Ice.Internal.Upgrade.ReportDataDefinition~ Ice.RptRelation Records Affected: 0
    Information Ice.Internal.Upgrade.ReportDataDefinition Ice.Internal.Upgrade.ReportDataDefinition~ Process Ice.RptRelationField records…
    Information Ice.Internal.Upgrade.ReportDataDefinition Ice.Internal.Upgrade.ReportDataDefinition~ Ice.RptRelationField Records Affected: 0
    Information Ice.Internal.Upgrade.ReportDataDefinition Ice.Internal.Upgrade.ReportDataDefinition~ Process Ice.RptCalcField records…
    Information Ice.Internal.Upgrade.ReportDataDefinition Ice.Internal.Upgrade.ReportDataDefinition~ Ice.RptCalcField Records Affected: 0
    Information Ice.Internal.Upgrade.ReportDataDefinition Ice.Internal.Upgrade.ReportDataDefinition~ Process Ice.RptLinkTable records…
    Information Ice.Internal.Upgrade.ReportDataDefinition Ice.Internal.Upgrade.ReportDataDefinition~ Ice.RptLinkTable Records Affected: 0
    Information Ice.Internal.Upgrade.ReportDataDefinition Ice.Internal.Upgrade.ReportDataDefinition~ Process Ice.RptLinkField records…
    Information Ice.Internal.Upgrade.ReportDataDefinition Ice.Internal.Upgrade.ReportDataDefinition~ Ice.RptLinkField Records Affected: 0
    Execute Phase Complete: 1.3563067 seconds

Starting Cleanup Phase…

  • Ice.Internal.Upgrade.ReportDataDefinition
    Cleanup Phase: 0.0006759 seconds

Starting Preparation

  • SSRS Breaking/Routing Rules
    Preparation Complete: 0.0006849 seconds

Starting Execution Phase…

  • SSRS Breaking/Routing Rules
    Information SSRS Breaking/Routing Rules SSRS Breaking/Routing Rules~ Starting upgrade for SSRS Breaking/Routing rules.
    Information SSRS Breaking/Routing Rules SSRS Breaking/Routing Rules~ Upgrade for SSRS Breaking/Routing rules completed successfully.
    Execute Phase Complete: 0.0050761 seconds

Starting Cleanup Phase…

  • SSRS Breaking/Routing Rules
    Cleanup Phase: 0.0007153 seconds

Starting Preparation

  • Post Migration
    Preparation Complete: 0.0021184 seconds

Starting Execution Phase…

  • Post Migration
    Information Post Migration Post Migration ~ Executing: ICE3_ExtendedEvents.sql
    Information Post Migration Post Migration ~ Executing: BackupXXXDefXXXChunk.sql
    Information Post Migration Post Migration ~ Executing: CaptureLogCleanup.sql
    Information Post Migration Post Migration ~ Executing: CleanupCacheAndAssemblyStore.sql
    Information Post Migration Post Migration ~ Executing: DeleteFromSysTask.sql
    Information Post Migration Post Migration ~ Executing: InsertZDataFieldwithUD.sql
    Information Post Migration Post Migration ~ Executing: Set_IDENTITY_INSERT_OFF.sql
    Information Post Migration Post Migration ~ Executing: SyncUDRows.sql
    Error Post Migration SyncUDRows.sql Invalid object name ‘dbo.Budget’.
    Invalid object name ‘dbo.Budget’.
    DELETE UDTable
    FROM [dbo].[Budget_UD] UDTable
    WHERE NOT EXISTS (SELECT 1 FROM [dbo].[Budget] a
    WHERE a.SysRowID = UDTable.ForeignSysRowID)
    INSERT INTO [dbo].Budget_UD
    SELECT SysRowID FROM [dbo].[Budget] a
    WHERE NOT EXISTS (SELECT 1 FROM [dbo].[Budget_UD] b
    WHERE b.ForeignSysRowID = a.SysRowID)
    DELETE UDTable
    FROM [Erp].[GLJrnDtl_UD] UDTable
    WHERE NOT EXISTS (SELECT 1 FROM [Erp].[GLJrnDtl] a
    WHERE a.SysRowID = UDTable.ForeignSysRowID)
    INSERT INTO [Erp].GLJrnDtl_UD
    SELECT SysRowID FROM [Erp].[GLJrnDtl] a
    WHERE NOT EXISTS (SELECT 1 FROM [Erp].[GLJrnDtl_UD] b
    WHERE b.ForeignSysRowID = a.SysRowID)
    DELETE UDTable
    FROM [Erp].[GLJrnDtlMnl_UD] UDTable
    WHERE NOT EXISTS (SELECT 1 FROM [Erp].[GLJrnDtlMnl] a
    WHERE a.SysRowID = UDTable.ForeignSysRowID)
    INSERT INTO [Erp].GLJrnDtlMnl_UD
    SELECT SysRowID FROM [Erp].[GLJrnDtlMnl] a
    WHERE NOT EXISTS (SELECT 1 FROM [Erp].[GLJrnDtlMnl_UD] b
    WHERE b.ForeignSysRowID = a.SysRowID)
    DELETE UDTable
    FROM [Erp].[OrderHed_UD] UDTable
    WHERE NOT EXISTS (SELECT 1 FROM [Erp].[OrderHed] a
    WHERE a.SysRowID = UDTable.ForeignSysRowID)
    INSERT INTO [Erp].OrderHed_UD
    SELECT SysRowID FROM [Erp].[OrderHed] a
    WHERE NOT EXISTS (SELECT 1 FROM [Erp].[OrderHed_UD] b
    WHERE b.ForeignSysRowID = a.SysRowID)
    DELETE UDTable
    FROM [Erp].[Part_UD] UDTable
    WHERE NOT EXISTS (SELECT 1 FROM [Erp].[Part] a
    WHERE a.SysRowID = UDTable.ForeignSysRowID)
    INSERT INTO [Erp].Part_UD
    SELECT SysRowID FROM [Erp].[Part] a
    WHERE NOT EXISTS (SELECT 1 FROM [Erp].[Part_UD] b
    WHERE b.ForeignSysRowID = a.SysRowID)
    DELETE UDTable
    FROM [Erp].[RvJrnTrDtl_UD] UDTable
    WHERE NOT EXISTS (SELECT 1 FROM [Erp].[RvJrnTrDtl] a
    WHERE a.SysRowID = UDTable.ForeignSysRowID)
    INSERT INTO [Erp].RvJrnTrDtl_UD
    SELECT SysRowID FROM [Erp].[RvJrnTrDtl] a
    WHERE NOT EXISTS (SELECT 1 FROM [Erp].[RvJrnTrDtl_UD] b
    WHERE b.ForeignSysRowID = a.SysRowID)
    DECLARE @TableSchema sysname,
    @TableName sysna
    Execute Phase Complete: 4.60515 seconds

Starting Cleanup Phase…

  • Post Migration
    Cleanup Phase: 0.0022652 seconds

DB Migration process is cancelled by the user.
The total execution time is 0.1012 minutes.

1 Like
2

Hi

do you have UD fields added to budget table? Is your data model in sync?

Does the budget_ud table exist?

Graeme

3

Hi Graeme_Fraser

Yes, we have UD fields added budget table what should I do in this case …

4

Can you send a screenshot of the Budget_UD table in extended table maintenance from your 10.1.500 working environment? The fact this is showing dbo.Budget_UD is a problem. A standard UD table should be erp.TABLENAME_UD. What this budget table created some other way? I never thought there was a base Budget table to create a UD table from but could be mistaken.

1 Like