Table in sync or data model in sync still yellow after data model regen

Epicor ERP 10
21

I hadn’t yet checked that. I on;y checked what tables SQL says I have. I had a few things I was going to check before I created a clean VM:

  1. ZDataTable - Good - Only shows the correct _UD tables (not the ones I’ve deleted)
  2. ZDataField - Good - Only shows the correct _UD tables (not the ones I’ve deleted)
  3. SQL Views - Good - Only shows the correct _UD tables (not the ones I’ve deleted)
  4. Datamodel Exclusions - Good - Does not exclude any extra items <value>Ice.SysSequence,IceDBMigrationLog</value>

My REAL issue is it leaves the old fields. New fields aren’t being generated either, but I have pending conversions that are failing.

1 Like
22

If you hadn’t already, check the regen log it might provide you with some clues. That’s what pointed out to me I was regenning the wrong DB.

23

I didn’t see any errors:

Start time: 9/21/2019 9:14:36 AM
Database server: EPICORAPP
Database name: Epicor10
Using Windows authentication: True
User ID: EPICORAPP\Administrator
Schemas to include: 
Tables to exclude: Ice.SysSequence, Ice.DBMigrationLog
Generator version: 3.2.400.0
Server version: 3.2.400.9
Folder C:\Users\Administrator\AppData\Local\Temp\Epicor\DataModelGenerator\Source is deleted successfully.
Extracting "Epicor.ServiceModel.dll" from "C:\Program Files (x86)\Common Files\Epicor Software\Database Manager Extensions\3.2.400\DataModelGenerator\..\DbMigration.zip" to "C:\Users\Administrator\AppData\Local\Temp\Epicor\DataModelGenerator\Deployment\Server\Bin".
Extracting "Epicor.System.dll" from "C:\Program Files (x86)\Common Files\Epicor Software\Database Manager Extensions\3.2.400\DataModelGenerator\..\DbMigration.zip" to "C:\Users\Administrator\AppData\Local\Temp\Epicor\DataModelGenerator\Deployment\Server\Bin".
Extracting "EntityFramework.dll" from "C:\Program Files (x86)\Common Files\Epicor Software\Database Manager Extensions\3.2.400\DataModelGenerator\..\DbMigration.zip" to "C:\Users\Administrator\AppData\Local\Temp\Epicor\DataModelGenerator\Deployment\Server\Assemblies".
Synchronizing schema changes.
SQL COMMAND TO EXECUTE
{
INSERT INTO [Erp].[Customer_UD] (ForeignSysRowID) SELECT (TT.SysRowID)
                      FROM [Erp].[Customer] TT LEFT OUTER JOIN [Erp].[Customer_UD] UD ON TT.SysRowID = UD.ForeignSysRowID WHERE UD.ForeignSysRowID IS NULL
}
SQL COMMAND TO EXECUTE
{
EXEC [Ice].[SPCreateTriggerForUDCreateView] N'Erp', N'Customer'
}
SQL COMMAND TO EXECUTE
{
EXEC [Ice].[SyncColumnAttribute] N'Erp', N'Customer_UD'
}
SQL COMMAND TO EXECUTE
{
INSERT INTO [Erp].[Plant_UD] (ForeignSysRowID) SELECT (TT.SysRowID)
                      FROM [Erp].[Plant] TT LEFT OUTER JOIN [Erp].[Plant_UD] UD ON TT.SysRowID = UD.ForeignSysRowID WHERE UD.ForeignSysRowID IS NULL
}
SQL COMMAND TO EXECUTE
{
EXEC [Ice].[SPCreateTriggerForUDCreateView] N'Erp', N'Plant'
}
SQL COMMAND TO EXECUTE
{
EXEC [Ice].[SyncColumnAttribute] N'Erp', N'Plant_UD'
}
SQL COMMAND TO EXECUTE
{
INSERT INTO [Erp].[ProdGrup_UD] (ForeignSysRowID) SELECT (TT.SysRowID)
                      FROM [Erp].[ProdGrup] TT LEFT OUTER JOIN [Erp].[ProdGrup_UD] UD ON TT.SysRowID = UD.ForeignSysRowID WHERE UD.ForeignSysRowID IS NULL
}
SQL COMMAND TO EXECUTE
{
EXEC [Ice].[SPCreateTriggerForUDCreateView] N'Erp', N'ProdGrup'
}
SQL COMMAND TO EXECUTE
{
EXEC [Ice].[SyncColumnAttribute] N'Erp', N'ProdGrup_UD'
}
SQL COMMAND TO EXECUTE
{
INSERT INTO [Ice].[SysConfig_UD] (ForeignSysRowID) SELECT (TT.SysRowID)
                      FROM [Ice].[SysConfig] TT LEFT OUTER JOIN [Ice].[SysConfig_UD] UD ON TT.SysRowID = UD.ForeignSysRowID WHERE UD.ForeignSysRowID IS NULL
}
SQL COMMAND TO EXECUTE
{
EXEC [Ice].[SPCreateTriggerForUDCreateView] N'Ice', N'SysConfig'
}
SQL COMMAND TO EXECUTE
{
EXEC [Ice].[SyncColumnAttribute] N'Ice', N'SysConfig_UD'
}
SQL COMMAND TO EXECUTE
{
INSERT INTO [Ice].[SysPlant_UD] (ForeignSysRowID) SELECT (TT.SysRowID)
                      FROM [Ice].[SysPlant] TT LEFT OUTER JOIN [Ice].[SysPlant_UD] UD ON TT.SysRowID = UD.ForeignSysRowID WHERE UD.ForeignSysRowID IS NULL
}
SQL COMMAND TO EXECUTE
{
EXEC [Ice].[SPCreateTriggerForUDCreateView] N'Ice', N'SysPlant'
}
SQL COMMAND TO EXECUTE
{
EXEC [Ice].[SyncColumnAttribute] N'Ice', N'SysPlant_UD'
}
Generating: C:\Users\Administrator\AppData\Local\Temp\Epicor\DataModelGenerator\Source\Server\Db\Ice.Data.Model\IceContext.edmx
Connecting to server/database: EPICORAPP/Epicor10
   connection opened and DB info retrieved. (8.80 s)
Generate EDMX
   generate EDMX completed. (0.26 s)
Process Extended Tables
   process of extended tables completed. (0.03 s)
Saving EDMX
   save completed. (0.12 s)
Transform Model T4 template
   transformation completed. (19.53 s)
Transform TempRowTypes T4 template
   transformation of TempRowTypes completed. (2.43 s)
Build context project
   build project completed. (32.67 s)
Total generation time (63.83 s)
Copying generated assembly to database: C:\Users\Administrator\AppData\Local\Temp\Epicor\DataModelGenerator\Source\Server\Db\Ice.Data.Model\obj\Release\Ice.Data.Model.dll
Generating: C:\Users\Administrator\AppData\Local\Temp\Epicor\DataModelGenerator\Source\Server\Db\Erp.Data.910100\ErpContext.edmx
Connecting to server/database: EPICORAPP/Epicor10
   connection opened and DB info retrieved. (54.26 s)
Generate EDMX
   generate EDMX completed. (2.33 s)
Process Extended Tables
   process of extended tables completed. (0.08 s)
Saving EDMX
   save completed. (0.89 s)
Transform Model T4 template
   transformation completed. (96.93 s)
Transform TempRowTypes T4 template
   transformation of TempRowTypes completed. (19.53 s)
Build context project
   build project completed. (285.78 s)
Total generation time (459.82 s)
Copying generated assembly to database: C:\Users\Administrator\AppData\Local\Temp\Epicor\DataModelGenerator\Source\Server\Db\Erp.Data.910100\obj\Release\Erp.Data.910100.dll
Checking for orphans
Data Models generated successfully: 9/21/2019 9:23:52 AM
24

I think I’m going to bang my head against a wall for a while. It would be more fun…
I performed my 8th regen, rebooted immediately and suddenly… It worked.
I am not happy for all the wasted time, but I’m proud of my fellow Epicorians who threw out ideas!

1 Like
25

What does the host trace show?