I recently added the InvcHead_UD table to Extended UD Table Maintenance so I was trying to sync it up with the db. Now I’m getting the following error when regenerating the data model for our “Dev” environment (we have Prod, Pilot, and Dev environments) [image] I checked all the topics that were …

do you have the log file from here: C:\Users<your user name>\AppData\Local\Temp\Epicor\DataModelGenerator\DataModelGenerator.log. That will have what it’s trying to execute.

[image] Aaron_Moreng: Can you run the following query? select * from Erp.InvcHead_UD ud where not exists(select 1 from Erp.InvcHead base where base.SysRowID = ud.ForeignSysRowID) Got this: [image]

That table does exist correct? Can you verify this?

It doesn’t exist under SQL Management, but when I check Extended UD Table Maintenance it’s in there… Of course it does say “Table not in database” though since I’m not able to regen the data model.

Yikes. Did you have that table in your environment before or did you just create it?

I just created it and then went to regen the data model and got the error…

You might be able to see more detail within the SQL server logs themselves, or in the Event logs for Epicor. T

What version of E10 are you running? In 10.0 Re-Synch table usually worked for me before doing data model regen

In ~10.1 the second step of ‘Sync DB’ in the UI was moved into the Regen DM process - one less step to forget. It smells like the regen process is failing and not creating the db table. That should be in the event log or in the file log (I thought that was shown during an error).

There isn’t any data in the table yet, right? You could try deleting it and recreating it (after verifying there’s no data). We had a regeneration problem related to a UD field about a year ago-- I don’t remember the specific error message, but deleting it (it was empty) and recreating it fixed the …

Does the user have access rights to the database table creation?

Regenerate Data Model Error

Epicor ERP 10

Caleb323 (Caleb) January 8, 2018, 11:11pm 18

This is correct, right?

Custom fields ending in "_c" not showing in BPM table

Topic		Replies	Views
Regenerating Data Model Error (Epicor Administration Console) Epicor ERP 10 e10 , epicor	6	1946	May 5, 2017
Error when running Generate Data Model Epicor ERP 10	12	4412	January 18, 2024
10.2.100 Upgrade Data Model Error Epicor ERP 10	35	7744	June 8, 2018
Epicor 10 Regenerating the datamodel error in our test database Epicor ERP 10 epicor	18	2579	April 21, 2022
Regenerate Data Model Error Epicor ERP 10 sql	9	2885	March 12, 2019

Regenerate Data Model Error

Related topics