I'd say you hit the nail on the head! What I don't understand is why
this would happen with the InvceHead table. I thought this table
would only be written once for each order invoiced, regardless of
the order size. Then the InvoiceDtl table would have the data for
each line/release. This obviously isn't true, but I'd like to know
why it isn't true! :)
Ron Cole
IT Manager, IED Inc.
rcole@...
--- In vantage@yahoogroups.com, "Podlin, Michael"
<michael.podlin@v...> wrote:
recommend that you only select specific fields to watch (not select
all). Also makes the database grow rather quickly too.
access. )
http://groups.yahoo.com/group/vantage/files/.
this would happen with the InvceHead table. I thought this table
would only be written once for each order invoiced, regardless of
the order size. Then the InvoiceDtl table would have the data for
each line/release. This obviously isn't true, but I'd like to know
why it isn't true! :)
Ron Cole
IT Manager, IED Inc.
rcole@...
--- In vantage@yahoogroups.com, "Podlin, Michael"
<michael.podlin@v...> wrote:
>that it went beyond the 1000 char limit set on them? Epicor does
> Is it possible that "any changes" dumped so much into the log file
recommend that you only select specific fields to watch (not select
all). Also makes the database grow rather quickly too.
>Behalf
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On
> Of swinky68table.
> Sent: Thursday, January 26, 2006 4:17 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Interesting BAM problem
>
>
> Actually, there wasn't any custom code on my part. All I had done
> was set the BAM to keep a log of any changes to the InvceHead
> When we tried to invoice the order, the Server Log recorded thiswrote:
> error: [06/01/24@16:08:35.541-0500] P-005876 T-005796 1 AS --
> (Procedure:
> 'db/trg/InvcHead/WRITE.P' Line:3198) ** Attempt to expand record
> beyond the maximum allowed size. (444)
>
> Who knows what would have happened if I'd asked for emails to be
> sent as well!
>
> Ron Cole
> IT Manager, IED Inc.
> rcole@i...
>
> --- In vantage@yahoogroups.com, "Lepley, Scott A." <sal@m...>
> >)
> > Yeah, really scary. Ron, would you mind posting the criminal :-
> BAM alertinvoiced.
> > code?
> >
> >
> >
> > Regards,
> > Scott
> >
> >
> >
> > -----Original Message-----
> > From: RICH WAGNER [mailto:rwagner@b...]
> > Sent: Thursday, January 26, 2006 4:42 PM
> > To: vantage@yahoogroups.com
> > Subject: RE: [Vantage] Interesting BAM problem
> >
> >
> >
> > Scary
> >
> >
> > From: swinky68 [mailto:rcole@i...]
> > Sent: Thursday, January 26, 2006 4:42 PM
> > To: vantage@yahoogroups.com
> > Subject: [Vantage] Interesting BAM problem
> >
> > Hi all,
> >
> > An FYI tidbit I wanted to pass along to the list...
> > I had a problem where a fairly large order could not be
> > Every time it was brought into Invoice Entry, Vantage would hangin
> and
> > have to be shut down. I opened a support ticket on this 2 days
> ago. I
> > got a message from support this morning to check for any alerts
> > BAM. Turns out that I had an alert set to monitor the InvceHeadWHY
> table
> > and this was causing the problem. Once I turned off the alert,
> > everything ran fine again. I did not get an explanation as to
> thisknowledge
> > was causing the problem, but I thought I would share the
> > with everyone here.must have already linked your email address to a yahoo id to enable
> >
> > Thanks,
> >
> > Ron Cole
> > IT Manager, IED Inc.
> > rcole@i...
> >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
>
>
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You
access. )
> (1) To access the Files Section of our Yahoo!Group for ReportBuilder and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
> (2) To search through old msg's goto:http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto:http://groups.yahoo.com/group/vantage/links
> Yahoo! Groups Links
>