I have added a few UD fields to the Vendor table using the Extended UD Table Maintenance screen. I ran the "Sync Current Table to DB" (which created the Vendor_UD table with the fields I defined), then I "Regenerated the Data model in System Administration for the correct environment, finally I bounced the IIS Application Pool associated with the environment (truth be told, after recycling the app pool, I restarted the entire server just to be sure). However, when I attempt to write a BAQ or bind a field in a Customization using these new fields...they are no where to be found.
I reboot again and go check my UD Table Maintenance on that table and both the "Table in Sync" and "Data Model in Sync" green buttons are highlighted.
Is there another step I'm missing so that I can see them? Any helpful hints out there?
Thank you in advance!
Brian Smith
Sent from my iPhone
On Feb 16, 2015, at 5:42 PM, brian_david_smith@... [vantage] <vantage@yahoogroups.com> wrote:
Group,
I have added a few UD fields to the Vendor table using the Extended UD Table Maintenance screen. I ran the "Sync Current Table to DB" (which created the Vendor_UD table with the fields I defined), then I "Regenerated the Data model in System Administration for the correct environment, finally I bounced the IIS Application Pool associated with the environment (truth be told, after recycling the app pool, I restarted the entire server just to be sure). However, when I attempt to write a BAQ or bind a field in a Customization using these new fields...they are no where to be found.
I reboot again and go check my UD Table Maintenance on that table and both the "Table in Sync" and "Data Model in Sync" green buttons are highlighted.
Is there another step I'm missing so that I can see them? Any helpful hints out there?
Thank you in advance!
Brian Smith
Sent from my iPhone
On Feb 16, 2015, at 5:42 PM, brian_david_smith@... [vantage] <vantage@yahoogroups.com> wrote:
Group,
I have added a few UD fields to the Vendor table using the Extended UD Table Maintenance screen. I ran the "Sync Current Table to DB" (which created the Vendor_UD table with the fields I defined), then I "Regenerated the Data model in System Administration for the correct environment, finally I bounced the IIS Application Pool associated with the environment (truth be told, after recycling the app pool, I restarted the entire server just to be sure). However, when I attempt to write a BAQ or bind a field in a Customization using these new fields...they are no where to be found.
I reboot again and go check my UD Table Maintenance on that table and both the "Table in Sync" and "Data Model in Sync" green buttons are highlighted.
Is there another step I'm missing so that I can see them? Any helpful hints out there?
Thank you in advance!
Brian Smith
Please make sure you stop the task server and application pool in the Administration Console before regenerating the DB. Without these steps the UD fields may not get generated.
Tech Support has a document on the complete process but summary is:
running versions 10.0.600.4 or later, you need to do the following:
1. Exit Epicor 10 and have all others log off.
2. Stop the Task Agent Service on the E10 server
(Epicor Administration Console. Expand Server Management / <servername> / <application server> / Task Agent Configuration button / Actions / Stop Service)
3. Stop the AppPool
(Epicor Administration Console. Expand Server Management / <servername> / <application server>. On the right under Actions / Stop Application Pool)
4. Regenerate the Data Model
(Epicor Administration Console / Expand Database Server Management / <servername> / <Database>. On the right under Actions > Regenerate the Data Model)
5. Start the AppPool
6. Restart the Task Agent.
7. Log back into Epicor 10.
Hope this helps - I personally prefer 12 steps.
Thank you in advance,
Calvin Dekker
[cid:image001.jpg@01D04A0D.8DA2C770]<http://www.codabears.com/>
630-672-7688 x1484
[cid:image002.jpg@01D04A0D.8DA2C770] <https://www.facebook.com/CodaBearsInc> [cid:image003.jpg@01D04A0D.8DA2C770] <http://www.linkedin.com/company/codabears-inc> [cid:image004.jpg@01D04A0D.8DA2C770] <https://twitter.com/CodaBearsInc> [cid:image005.png@01D04A0D.8DA2C770] <http://google.com/+CodaBearsIncRoselle>
[cid:image011.png@01D04A0D.3E525DC0]
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Monday, February 16, 2015 5:09 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Epicor 10.0.700.2 - New UD Fields not available in BAQ or Customization
In some instances restating the iis want enough. We had to reboot the server.
Sent from my Verizon Wireless 4G LTE smartphone
-------- Original message --------
From: "Anthony Gercar agercar@...<mailto:agercar@...> [vantage]"
Date:02/16/2015 4:49 PM (GMT-06:00)
To: vantage@yahoogroups.com<mailto:vantage@yahoogroups.com>
Subject: Re: [Vantage] Epicor 10.0.700.2 - New UD Fields not available in BAQ or Customization
You need to re-deploy the app server... I think that's what it's called...
Sent from my iPhone
On Feb 16, 2015, at 5:42 PM, brian_david_smith@...<mailto:brian_david_smith@...> [vantage] <vantage@yahoogroups.com<mailto:vantage@yahoogroups.com>> wrote:
Group,
I have added a few UD fields to the Vendor table using the Extended UD Table Maintenance screen. I ran the "Sync Current Table to DB" (which created the Vendor_UD table with the fields I defined), then I "Regenerated the Data model in System Administration for the correct environment, finally I bounced the IIS Application Pool associated with the environment (truth be told, after recycling the app pool, I restarted the entire server just to be sure). However, when I attempt to write a BAQ or bind a field in a Customization using these new fields...they are no where to be found.
I reboot again and go check my UD Table Maintenance on that table and both the "Table in Sync" and "Data Model in Sync" green buttons are highlighted.
Is there another step I'm missing so that I can see them? Any helpful hints out there?
Thank you in advance!
Brian Smith
[Non-text portions of this message have been removed]
In Epicor’s admin tools, databases – make sure the ICE and ERP versions are correct.
I have found that if they show an older version (10.0.700.1) the dB would generate but it would not add to allow bindings
If that’s the case, you need to update your ice.ICEVER table to have dates of 700.2 be latest date
<div id="ygrps-yiv-1892235881yiv2286445629ygrp-text">
<div></div><div class="ygrps-yiv-1892235881yiv2286445629MsoNormal">In Epicor’s admin tools, databases – make sure the ICE and
ERP versions are correct.
</div>
<div style="color:#fff;height:0;"></div></div>
#ygrps-yiv-1892235881 #ygrps-yiv-1892235881yiv2286445629 #ygrps-yiv-1892235881yiv2286445629ygrp-mkp hr {
border:1px solid #d8d8d8;}
#ygrps-yiv-1892235881 #ygrps-yiv-1892235881yiv2286445629 #ygrps-yiv-1892235881yiv2286445629ygrp-mkp #ygrps-yiv-1892235881yiv2286445629hd {
color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}
#ygrps-yiv-1892235881 #ygrps-yiv-1892235881yiv2286445629 #ygrps-yiv-1892235881yiv2286445629ygrp-mkp #ygrps-yiv-1892235881yiv2286445629ads {
margin-bottom:10px;}
#ygrps-yiv-1892235881 #ygrps-yiv-1892235881yiv2286445629 #ygrps-yiv-1892235881yiv2286445629ygrp-mkp .ygrps-yiv-1892235881yiv2286445629ad {
padding:0 0;}
#ygrps-yiv-1892235881 #ygrps-yiv-1892235881yiv2286445629 #ygrps-yiv-1892235881yiv2286445629ygrp-mkp .ygrps-yiv-1892235881yiv2286445629ad p {
margin:0;}
#ygrps-yiv-1892235881 #ygrps-yiv-1892235881yiv2286445629 #ygrps-yiv-1892235881yiv2286445629ygrp-mkp .ygrps-yiv-1892235881yiv2286445629ad a {
color:#0000ff;text-decoration:none;}
#ygrps-yiv-1892235881 #ygrps-yiv-1892235881yiv2286445629 #ygrps-yiv-1892235881yiv2286445629ygrp-sponsor #ygrps-yiv-1892235881yiv2286445629ygrp-lc {
font-family:Arial;}
#ygrps-yiv-1892235881 #ygrps-yiv-1892235881yiv2286445629 #ygrps-yiv-1892235881yiv2286445629ygrp-sponsor #ygrps-yiv-1892235881yiv2286445629ygrp-lc #ygrps-yiv-1892235881yiv2286445629hd {
margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}
#ygrps-yiv-1892235881 #ygrps-yiv-1892235881yiv2286445629 #ygrps-yiv-1892235881yiv2286445629ygrp-sponsor #ygrps-yiv-1892235881yiv2286445629ygrp-lc .ygrps-yiv-1892235881yiv2286445629ad {
margin-bottom:10px;padding:0 0;}
#ygrps-yiv-1892235881 #ygrps-yiv-1892235881yiv2286445629 #ygrps-yiv-1892235881yiv2286445629actions {
font-family:Verdana;font-size:11px;padding:10px 0;}
#ygrps-yiv-1892235881 #ygrps-yiv-1892235881yiv2286445629 #ygrps-yiv-1892235881yiv2286445629activity {
background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}
#ygrps-yiv-1892235881 #ygrps-yiv-1892235881yiv2286445629 #ygrps-yiv-1892235881yiv2286445629activity span {
font-weight:700;}
#ygrps-yiv-1892235881 #ygrps-yiv-1892235881yiv2286445629 #ygrps-yiv-1892235881yiv2286445629activity span:first-child {
text-transform:uppercase;}
#ygrps-yiv-1892235881 #ygrps-yiv-1892235881yiv2286445629 #ygrps-yiv-1892235881yiv2286445629activity span a {
color:#5085b6;text-decoration:none;}
#ygrps-yiv-1892235881 #ygrps-yiv-1892235881yiv2286445629 #ygrps-yiv-1892235881yiv2286445629activity span span {
color:#ff7900;}
#ygrps-yiv-1892235881 #ygrps-yiv-1892235881yiv2286445629 #ygrps-yiv-1892235881yiv2286445629activity span .ygrps-yiv-1892235881yiv2286445629underline {
text-decoration:underline;}
#ygrps-yiv-1892235881 #ygrps-yiv-1892235881yiv2286445629 .ygrps-yiv-1892235881yiv2286445629attach {
clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}
#ygrps-yiv-1892235881 #ygrps-yiv-1892235881yiv2286445629 .ygrps-yiv-1892235881yiv2286445629attach div a {
text-decoration:none;}
#ygrps-yiv-1892235881 #ygrps-yiv-1892235881yiv2286445629 .ygrps-yiv-1892235881yiv2286445629attach img {
border:none;padding-right:5px;}
#ygrps-yiv-1892235881 #ygrps-yiv-1892235881yiv2286445629 .ygrps-yiv-1892235881yiv2286445629attach label {
display:block;margin-bottom:5px;}
#ygrps-yiv-1892235881 #ygrps-yiv-1892235881yiv2286445629 .ygrps-yiv-1892235881yiv2286445629attach label a {
text-decoration:none;}
#ygrps-yiv-1892235881 #ygrps-yiv-1892235881yiv2286445629 blockquote {
margin:0 0 0 4px;}
#ygrps-yiv-1892235881 #ygrps-yiv-1892235881yiv2286445629 .ygrps-yiv-1892235881yiv2286445629bold {
font-family:Arial;font-size:13px;font-weight:700;}
#ygrps-yiv-1892235881 #ygrps-yiv-1892235881yiv2286445629 .ygrps-yiv-1892235881yiv2286445629bold a {
text-decoration:none;}
#ygrps-yiv-1892235881 #ygrps-yiv-1892235881yiv2286445629 dd.ygrps-yiv-1892235881yiv2286445629last p a {
font-family:Verdana;font-weight:700;}
#ygrps-yiv-1892235881 #ygrps-yiv-1892235881yiv2286445629 dd.ygrps-yiv-1892235881yiv2286445629last p span {
margin-right:10px;font-family:Verdana;font-weight:700;}
#ygrps-yiv-1892235881 #ygrps-yiv-1892235881yiv2286445629 dd.ygrps-yiv-1892235881yiv2286445629last p span.ygrps-yiv-1892235881yiv2286445629yshortcuts {
margin-right:0;}
#ygrps-yiv-1892235881 #ygrps-yiv-1892235881yiv2286445629 div.ygrps-yiv-1892235881yiv2286445629attach-table div div a {
text-decoration:none;}
#ygrps-yiv-1892235881 #ygrps-yiv-1892235881yiv2286445629 div.ygrps-yiv-1892235881yiv2286445629attach-table {
width:400px;}
#ygrps-yiv-1892235881 #ygrps-yiv-1892235881yiv2286445629 div.ygrps-yiv-1892235881yiv2286445629file-title a, #ygrps-yiv-1892235881 #ygrps-yiv-1892235881yiv2286445629 div.ygrps-yiv-1892235881yiv2286445629file-title a:active, #ygrps-yiv-1892235881 #ygrps-yiv-1892235881yiv2286445629 div.ygrps-yiv-1892235881yiv2286445629file-title a:hover, #ygrps-yiv-1892235881 #ygrps-yiv-1892235881yiv2286445629 div.ygrps-yiv-1892235881yiv2286445629file-title a:visited {
text-decoration:none;}
#ygrps-yiv-1892235881 #ygrps-yiv-1892235881yiv2286445629 div.ygrps-yiv-1892235881yiv2286445629photo-title a, #ygrps-yiv-1892235881 #ygrps-yiv-1892235881yiv2286445629 div.ygrps-yiv-1892235881yiv2286445629photo-title a:active, #ygrps-yiv-1892235881 #ygrps-yiv-1892235881yiv2286445629 div.ygrps-yiv-1892235881yiv2286445629photo-title a:hover, #ygrps-yiv-1892235881 #ygrps-yiv-1892235881yiv2286445629 div.ygrps-yiv-1892235881yiv2286445629photo-title a:visited {
text-decoration:none;}
#ygrps-yiv-1892235881 #ygrps-yiv-1892235881yiv2286445629 div#ygrps-yiv-1892235881yiv2286445629ygrp-mlmsg #ygrps-yiv-1892235881yiv2286445629ygrp-msg p a span.ygrps-yiv-1892235881yiv2286445629yshortcuts {
font-family:Verdana;font-size:10px;font-weight:normal;}
#ygrps-yiv-1892235881 #ygrps-yiv-1892235881yiv2286445629 .ygrps-yiv-1892235881yiv2286445629green {
color:#628c2a;}
#ygrps-yiv-1892235881 #ygrps-yiv-1892235881yiv2286445629 .ygrps-yiv-1892235881yiv2286445629MsoNormal {
margin:0 0 0 0;}
#ygrps-yiv-1892235881 #ygrps-yiv-1892235881yiv2286445629 o {
font-size:0;}
#ygrps-yiv-1892235881 #ygrps-yiv-1892235881yiv2286445629 #ygrps-yiv-1892235881yiv2286445629photos div {
float:left;width:72px;}
#ygrps-yiv-1892235881 #ygrps-yiv-1892235881yiv2286445629 #ygrps-yiv-1892235881yiv2286445629photos div div {
border:1px solid #666666;height:62px;overflow:hidden;width:62px;}
#ygrps-yiv-1892235881 #ygrps-yiv-1892235881yiv2286445629 #ygrps-yiv-1892235881yiv2286445629photos div label {
color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}
#ygrps-yiv-1892235881 #ygrps-yiv-1892235881yiv2286445629 #ygrps-yiv-1892235881yiv2286445629reco-category {
font-size:77%;}
#ygrps-yiv-1892235881 #ygrps-yiv-1892235881yiv2286445629 #ygrps-yiv-1892235881yiv2286445629reco-desc {
font-size:77%;}
#ygrps-yiv-1892235881 #ygrps-yiv-1892235881yiv2286445629 .ygrps-yiv-1892235881yiv2286445629replbq {
margin:4px;}
#ygrps-yiv-1892235881 #ygrps-yiv-1892235881yiv2286445629 #ygrps-yiv-1892235881yiv2286445629ygrp-actbar div a:first-child {
margin-right:2px;padding-right:5px;}
#ygrps-yiv-1892235881 #ygrps-yiv-1892235881yiv2286445629 #ygrps-yiv-1892235881yiv2286445629ygrp-mlmsg {
font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}
#ygrps-yiv-1892235881 #ygrps-yiv-1892235881yiv2286445629 #ygrps-yiv-1892235881yiv2286445629ygrp-mlmsg table {
font-size:inherit;font:100%;}
#ygrps-yiv-1892235881 #ygrps-yiv-1892235881yiv2286445629 #ygrps-yiv-1892235881yiv2286445629ygrp-mlmsg select, #ygrps-yiv-1892235881 #ygrps-yiv-1892235881yiv2286445629 input, #ygrps-yiv-1892235881 #ygrps-yiv-1892235881yiv2286445629 textarea {
font:99% Arial, Helvetica, clean, sans-serif;}
#ygrps-yiv-1892235881 #ygrps-yiv-1892235881yiv2286445629 #ygrps-yiv-1892235881yiv2286445629ygrp-mlmsg pre, #ygrps-yiv-1892235881 #ygrps-yiv-1892235881yiv2286445629 code {
font:115% monospace;}
#ygrps-yiv-1892235881 #ygrps-yiv-1892235881yiv2286445629 #ygrps-yiv-1892235881yiv2286445629ygrp-mlmsg * {
line-height:1.22em;}
#ygrps-yiv-1892235881 #ygrps-yiv-1892235881yiv2286445629 #ygrps-yiv-1892235881yiv2286445629ygrp-mlmsg #ygrps-yiv-1892235881yiv2286445629logo {
padding-bottom:10px;}
#ygrps-yiv-1892235881 #ygrps-yiv-1892235881yiv2286445629 #ygrps-yiv-1892235881yiv2286445629ygrp-msg p a {
font-family:Verdana;}
#ygrps-yiv-1892235881 #ygrps-yiv-1892235881yiv2286445629 #ygrps-yiv-1892235881yiv2286445629ygrp-msg p#ygrps-yiv-1892235881yiv2286445629attach-count span {
color:#1E66AE;font-weight:700;}
#ygrps-yiv-1892235881 #ygrps-yiv-1892235881yiv2286445629 #ygrps-yiv-1892235881yiv2286445629ygrp-reco #ygrps-yiv-1892235881yiv2286445629reco-head {
color:#ff7900;font-weight:700;}
#ygrps-yiv-1892235881 #ygrps-yiv-1892235881yiv2286445629 #ygrps-yiv-1892235881yiv2286445629ygrp-reco {
margin-bottom:20px;padding:0px;}
#ygrps-yiv-1892235881 #ygrps-yiv-1892235881yiv2286445629 #ygrps-yiv-1892235881yiv2286445629ygrp-sponsor #ygrps-yiv-1892235881yiv2286445629ov li a {
font-size:130%;text-decoration:none;}
#ygrps-yiv-1892235881 #ygrps-yiv-1892235881yiv2286445629 #ygrps-yiv-1892235881yiv2286445629ygrp-sponsor #ygrps-yiv-1892235881yiv2286445629ov li {
font-size:77%;list-style-type:square;padding:6px 0;}
#ygrps-yiv-1892235881 #ygrps-yiv-1892235881yiv2286445629 #ygrps-yiv-1892235881yiv2286445629ygrp-sponsor #ygrps-yiv-1892235881yiv2286445629ov ul {
margin:0;padding:0 0 0 8px;}
#ygrps-yiv-1892235881 #ygrps-yiv-1892235881yiv2286445629 #ygrps-yiv-1892235881yiv2286445629ygrp-text {
font-family:Georgia;}
#ygrps-yiv-1892235881 #ygrps-yiv-1892235881yiv2286445629 #ygrps-yiv-1892235881yiv2286445629ygrp-text p {
margin:0 0 1em 0;}
#ygrps-yiv-1892235881 #ygrps-yiv-1892235881yiv2286445629 #ygrps-yiv-1892235881yiv2286445629ygrp-text tt {
font-size:120%;}
#ygrps-yiv-1892235881 #ygrps-yiv-1892235881yiv2286445629 #ygrps-yiv-1892235881yiv2286445629ygrp-vital ul li:last-child {
border-right:none !important;}
#ygrps-yiv-1892235881
If you had BAQ or customization created BEFORE UD field was added, you may want to use base customization or blank BAQ and recreate.
I had similar situation. I was able to see the UD fields on new BAQ and customizations, but not on the customization/BAQ that was created before UD field was added.
Brian,
What do your using statements on the custom code look like? I remember having to change mine. And then have you tried re-compiling your BAQs in the system management section?
from:
using Epicor.Mfg.BO;
using Epicor.Mfg.UI;
using Epicor.Mfg.UI.Adapters;
using Epicor.Mfg.UI.Customization;
using Epicor.Mfg.UI.ExtendedProps;
using Epicor.Mfg.UI.FormFunctions;
using Epicor.Mfg.UI.FrameWork;
using Epicor.Mfg.UI.Searches;
To:
using Erp.UI;
using Ice.Lib.Customization;
using Ice.Lib.ExtendedProps;
using Ice.Lib.Framework;
using Ice.Lib.Searches;
using Ice.UI.FormFunctions;
Brenda
From:
vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Tuesday, February 17, 2015 8:51 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Epicor 10.0.700.2 - New UD Fields not available in BAQ or Customization
Thank you everyone for the responses and I have attempted/verified all four suggestions without success. The fields appear in the actual database but still are not available when working with BAQs or Customizations. I will have to wait for the response from Support at this point.
Thank you again!
Brian
On Tuesday, February 17, 2015 7:02 AM, "mseal@... [vantage]" <vantage@yahoogroups.com> wrote:
In Epicor’s admin tools, databases – make sure the ICE and ERP versions are correct.
I have found that if they show an older version (10.0.700.1) the dB would generate but it would not add to allow bindings
If that’s the case, you need to update your ice.ICEVER table to have dates of 700.2 be latest date
Jose C Gomez
T: 904.469.1524 mobile
Quis custodiet ipsos custodes?
On Wed, Feb 18, 2015 at 11:35 AM, brian_david_smith@... [vantage] <vantage@yahoogroups.com> wrote:Â<div> <p>Thanks for the response Brenda! I am just attempting to build a form customization and bind a textbox to one of the fields that I created. However, they don't show as an available option in the EpiBind option.</p> </div> <div style="color:#fff;min-height:0;"></div>
Jose C Gomez
T: 904.469.1524 mobile
Quis custodiet ipsos custodes?
On Wed, Feb 18, 2015 at 1:09 PM, brian_david_smith@... [vantage] <vantage@yahoogroups.com> wrote:Â<div> <p>That I do and that is why this is driving me crazy.</p> </div><span class="ygrps-yiv-1297383897"> <div style="color:#fff;min-height:0;"></div>