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

Why, after adding a UD field, then doing a data model gen followed by a app pool recycle, the Table in sync or the Data Model in sync is still yellow? Seems like 50% of the time, we have to regen again, then every thing is in sync.

My guess is it’s applying updates and if the table itself is large, it’s timing out on the update. Thus the subsequent regen complete the update. But this is only a guess.

We’re on 10.1.400.32

Thanks,
Steve

Steve;
Since we updated from .200 to .300 I have the same issue only worse.
I can regen several times to no avail,but when I reboot the server, all is well and I get the Green light.
Anyone else having this issue? A real PITA.
George Hicks

This is happening for us as well after upgrading to 10.2.300.9. All fields are there, but no matter what the status is still yellow. Support couldn’t figure out the issue.

Same in 10.2.300.11

Noticed it during our testing…

Turn on the system host trace and check what it gives for the success or failure on the Data model version check after app pool recycle

1 Like

I know what it is… I was just nagging Bart about it 2 weeks ago.

So the fields are there and the Yellow is misleading… Use the “List” View! Then make sure your

  • Integers have a default of 0 in the List View (Somehow the List and Detail Dont Match)
  • Booleans have a default of false NOT BLANK! (I also changed any that had no to false)
  • GUIDs have a default of 00000000-0000-0000-0000-000000000000
  • Your Decimal format might be >>>9.9999 with Decimals 4 but the Default Value in List View might be 0 set it to the correct 0.0000

As you are setting the defaults you might notice your Table goes green and in sync. As you are switching btw Detail/List you can notice the Default’s dont match. Once you fix them in the List View your Table goes in sync! It only took me like 7 hours to figure it out lol I even poked around with all Epicors Stored Procedures and SQL Debugging.

The Problem that seems to happen is 400, 500 and earlier versions allowed you to have some blank defaults, which in 10.2 does not like. For me it was Migrating from E9 I had Integer with BLANK which in E9 was fine in 500 it was fine… but in 10.2 it was not.

Fix the Default Initial Values via List View and you should be good. Dont let the Detail Tab Fool you =) If its still Yellow then there is 1 or more Defaults you missed or don’t match the format.

PS: Even when I had Integer set as 0… I set it back to 1 and saved and back to 0, triggered an update and I went green on a table. Even there the 0 didn’t really take until I re-triggered an update.

There really was no failure, it was just the Shape showed Table not in Sync because the Defaults didnt fit, as soon as I fixed it, it went green instantly.

2019-03-14_0915

3 Likes

Oh I do remember that. That’s what I get for late night e10Help review.

Did you ever get a ticket on that? I know we had a story about improving tool tips on the Yellow button or something from a ways back but since I have not been day to day on E10 I’ll have to pester the folks in charge for current thinking.

@hkeric.wci this solution worked great for me! I pitty the person who has 200-300 custom fields on a table tho haha :wink: . unless paste insert after modifying in excel works too.

1 Like

Support could not figure this out for us either. They gave us the old “its not you, its me” speech. They sent it to development.

Thanks for posting we will be trying this out.

2 Likes

FYI this worked for us.

This issue made us uneasy on what was wrong with the system. Mostly being that seeing a message that says something is not in sync can be concerning to some users. When Epicor says that its “probably OK” with no documentation backing that claim. My group was concerned there was a bigger underlying problem.

There was a KB article on this for the same issue but the resolution was kind of a cliff hanger.

1 Like

FYI, here’s another data point…

Here I was, 10pm on a Sunday night with the same issue (10.2.300.12) after adding a UD field in Customer… 2 Datamodel regens on the specific app server I’m on (#2 of 3) along with the stop/start of IIS, and table was in sync, but the data model was still NOT in sync.


15 minutes later, the Regenerating Data Model stopped progressing (no, the hidden "data model regen successful pop-under wasn’t there, unfortunately). The green Work In Progress bar kept cycling (10 minutes now, usually takes 3), so I hit cancel, closed and restarted the Epicor Admin Console.
image
This time the data model regen completed, stopped and started our 3 app pools, but the original issue of table in sync and data model not persisted. Our network admin rebooted the app servers, and all seems well now…
image

I’ll pop in an Epicare ticket just so there’s a record of it. Not sure if it matters, but it didn’t happen when I manually entered the new UD field in our 10.2.400.12 pilot environment first (which I copy/pasted the row from List View into 10.2.300.8 LIVE environment. Column order and headers is identical).

Step 1 :- Stop the Application Pool from Admin Console
Step 2 :- Regenerate the Data Model of respective database
Step 3 :- Start the Application and Recycle the Application Pool
Step 4 :- Restart the Task Agent Services.

Well, I started adding UD fields to a 10.2.400.11 database.
image


I followed @hkeric.wci’s advise and it still won’t process. The logs don’t show errors… Help? Please? :cry:

I’'l be doing a test upgrade to 10.2.400.11 this weekend, on .10 now, will test on both and report back.

Note: I upgraded from 10.2.100.5 to 10.2.400.11
I’m going to try a fresh install on the VM and see if it’s just leftover issues.

1 Like

So I tried on a Demo Database that was generated during a 10.2.400.5 install and upgraded to 10.2.400.10. Tested Ok, upgraded that db to 10.2.400.11 re-tested and no problems.

Took a copy of our Production database that was upgraded from 10.1.600.25 to 10.2.400.5 then to 10.2.400.10. Added a field no problems. Upgraded to 10.2.400.11, added a field and it would not regen. Even after following @hkeric.wci post!

Attached is a spreadsheet of the tests. 10.2.400.11 AddUDField Test.xlsx (9.9 KB)

I can take a look on my environment later… I’ve spent hours debugging it last time, maybe I can pinpoint the culprit… now I am on 10.2.500 (early release) lol need to downgrade.

I can see the tables in SQL look perfect. I’ve added new fields and deleted unused ones. However Epicor still expects these old fields to be there and the new ones aren’t recognized.

Disregard my input on the last test…I was regenerating on the wrong DB Duh :frowning:

Just redid it again and it is working. No changes needed to the defaults.

Might be worth looking at the regen log

So does the UD field data in the ice.Zdatafield table for the specific table you are wanting to add to match the fields in the actual erp. _UD table? (Sorry for the confusing question, I hope you get what I mean)