Regenerate Data Model Error

Epicor ERP 10
1

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 similar to this and didn’t really receive any “answers”…

I can regen the data model for Pilot and Prod, but for some reason it doesn’t work for the Dev Environment.

So my questions are: Does anyone know where the log for this data is? It mentions the log for more detailed info but I can’t find the log. And does anyone have any insight on what the issue could be? I thought I’d check this website before I create a case with Support…

Caleb

2

I remember we once had a problem where we couldn’t regenerate the data model due to orphaned records.
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)

3

Got this:
image

4

That table does exist correct? Can you verify this?

5

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.

6

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

7

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

8

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

9

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

10

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).

11

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 issue for us.

12

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

13

Possibly random question but what’s the default schema set to for the user you’re running the data model regeneration as?

I believe there’s a log that will show where it’s failing. I’ll have to poke around to see if I can remember where it is, typically the eventlog is my go to.

14

I would assume that I have the correct permissions if I can create tables in Prod/Pilot with no issues… Should I try doing it as the manager user or something?

Update - I deleted and re-added and still got the same error. After I deleted I regen’d the data model to see if I would get an error but it succeeded… Then I re-added the InvcHead_UD table and regen’d and got the same error

15

What version are you in?

16

Permissions may not be the issue. What I found the hard way was that if you don’t have the default schema for your database user on that database set to DBO then it will create the table under your default schema for your user.
I ended up with a table called ‘domain\username.partprice’ and it threw errors when trying to create the view to join the two tables together.

17

10.1.400.13

18

This is correct, right?
image

19

Yeah, that looks correct.

20

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.

2 Likes