Hi,
Thanks for your reply, but no, there are no BAM's in operation on the customer table.
To add to my original message, the memo data in question is 14,671 characters (inclusive of whitespace). Saved as a text file, the file size is 14.4Kb.
thanks,
Steve
Hello,
We are attempting to load customer memo data from our legacy system into Customer records within Epicor 9.05.702. However, some of these memos are apparently too large to be held in any Character field, or combination of Character fields.
For example, entering the data into the customer comments field results in the following error:
If I then reduce the memo to a size acceptable for saving, then try to paste the amount removed into another field (for example, Customer.Character01), the same error is reported. This also occurs if I attempt to split the data across several Character fields. This is despite character fields showing a capacity of x16,000?
The same result occurs if I exit customer maintenance / Epicor entirely and then try to save in the other fields after logging in again.
I understand error 12370 refers to a 32K limit on record update? If so, then why does my solution of breaking up the data and saving smaller chunks not work?
Many thanks,
Steve
margin-right:0in;
margin-left:0in;
font-size:12.0pt;
font-family:“Times New Roman”, “serif”;}
#ygrps-yiv-1699774388 code
{
font-family:“Courier New”;}
#ygrps-yiv-1699774388 pre
{
margin:0in;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:“Courier New”;}
#ygrps-yiv-1699774388 tt
{
font-family:“Courier New”;}
#ygrps-yiv-1699774388 span.ygrps-yiv-1699774388cat
{}
#ygrps-yiv-1699774388 span.ygrps-yiv-1699774388ct
{}
#ygrps-yiv-1699774388 span.ygrps-yiv-1699774388HTMLPreformattedChar
{
font-family:Consolas;}
#ygrps-yiv-1699774388 p.ygrps-yiv-1699774388attach, #ygrps-yiv-1699774388 li.ygrps-yiv-1699774388attach, #ygrps-yiv-1699774388 div.ygrps-yiv-1699774388attach
{
margin-right:0in;
margin-left:0in;
font-size:9.0pt;
font-family:“Arial”, “sans-serif”;}
#ygrps-yiv-1699774388 p.ygrps-yiv-1699774388bold, #ygrps-yiv-1699774388 li.ygrps-yiv-1699774388bold, #ygrps-yiv-1699774388 div.ygrps-yiv-1699774388bold
{
margin-right:0in;
margin-left:0in;
font-size:10.0pt;
font-family:“Arial”, “sans-serif”;
font-weight:bold;}
#ygrps-yiv-1699774388 p.ygrps-yiv-1699774388green, #ygrps-yiv-1699774388 li.ygrps-yiv-1699774388green, #ygrps-yiv-1699774388 div.ygrps-yiv-1699774388green
{
margin-right:0in;
margin-left:0in;
font-size:12.0pt;
font-family:“Times New Roman”, “serif”;
color:#628C2A;}
#ygrps-yiv-1699774388 p.ygrps-yiv-1699774388replbq, #ygrps-yiv-1699774388 li.ygrps-yiv-1699774388replbq, #ygrps-yiv-1699774388 div.ygrps-yiv-1699774388replbq
{
margin:3.0pt;
font-size:12.0pt;
font-family:“Times New Roman”, “serif”;}
#ygrps-yiv-1699774388 p.ygrps-yiv-1699774388ad, #ygrps-yiv-1699774388 li.ygrps-yiv-1699774388ad, #ygrps-yiv-1699774388 div.ygrps-yiv-1699774388ad
{
margin-right:0in;
margin-left:0in;
font-size:12.0pt;
font-family:“Times New Roman”, “serif”;}
#ygrps-yiv-1699774388 p.ygrps-yiv-1699774388underline, #ygrps-yiv-1699774388 li.ygrps-yiv-1699774388underline, #ygrps-yiv-1699774388 div.ygrps-yiv-1699774388underline
{
margin-right:0in;
margin-left:0in;
font-size:12.0pt;
font-family:“Times New Roman”, “serif”;}
#ygrps-yiv-1699774388 span.ygrps-yiv-1699774388yshortcuts
{}
#ygrps-yiv-1699774388 p.ygrps-yiv-1699774388ad1, #ygrps-yiv-1699774388 li.ygrps-yiv-1699774388ad1, #ygrps-yiv-1699774388 div.ygrps-yiv-1699774388ad1
{
margin-right:0in;
margin-left:0in;
font-size:12.0pt;
font-family:“Times New Roman”, “serif”;}
#ygrps-yiv-1699774388 p.ygrps-yiv-1699774388ad2, #ygrps-yiv-1699774388 li.ygrps-yiv-1699774388ad2, #ygrps-yiv-1699774388 div.ygrps-yiv-1699774388ad2
{
margin-right:0in;
margin-bottom:7.5pt;
margin-left:0in;
font-size:12.0pt;
font-family:“Times New Roman”, “serif”;}
#ygrps-yiv-1699774388 p.ygrps-yiv-1699774388underline1, #ygrps-yiv-1699774388 li.ygrps-yiv-1699774388underline1, #ygrps-yiv-1699774388 div.ygrps-yiv-1699774388underline1
{
margin-right:0in;
margin-left:0in;
font-size:12.0pt;
font-family:“Times New Roman”, “serif”;
text-decoration:underline;}
#ygrps-yiv-1699774388 span.ygrps-yiv-1699774388yshortcuts1
{
font-family:“Verdana”, “sans-serif”;
font-weight:bold;}
#ygrps-yiv-1699774388 span.ygrps-yiv-1699774388yshortcuts2
{
font-family:“Verdana”, “sans-serif”;
font-weight:normal;}
#ygrps-yiv-1699774388 span.ygrps-yiv-1699774388EmailStyle36
{
font-family:“Calibri”, “sans-serif”;
color:#1F497D;}
#ygrps-yiv-1699774388 .ygrps-yiv-1699774388MsoChpDefault
{
font-size:10.0pt;}
_filtered #ygrps-yiv-1699774388 {
margin:1.0in 1.0in 1.0in 1.0in;}
#ygrps-yiv-1699774388 div.ygrps-yiv-1699774388WordSection1
{}
#ygrps-yiv-1699774388
_filtered #ygrps-yiv-1699774388 {
}
_filtered #ygrps-yiv-1699774388 {
font-family:Symbol;}
_filtered #ygrps-yiv-1699774388 {
font-family:“Courier New”;
}
_filtered #ygrps-yiv-1699774388 {
font-family:Wingdings;}
_filtered #ygrps-yiv-1699774388 {
font-family:Wingdings;}
_filtered #ygrps-yiv-1699774388 {
font-family:Wingdings;}
_filtered #ygrps-yiv-1699774388 {
font-family:Wingdings;}
_filtered #ygrps-yiv-1699774388 {
font-family:Wingdings;}
_filtered #ygrps-yiv-1699774388 {
font-family:Wingdings;}
_filtered #ygrps-yiv-1699774388 {
font-family:Wingdings;}
#ygrps-yiv-1699774388 ol
{margin-bottom:0in;}
#ygrps-yiv-1699774388 ul
{margin-bottom:0in;}
–>
Just a thought- but do you have BAM set-up to record changes on those fields to the change log? Â It could be the changelog that is having the issue saving that much data?