In the TechRefGuide_PerfTuneSQL_905700.pdf it recommends Bt of 40960. I set it to that and eliminated almost all of my temp files. the server has 48GB, so they are mostly in ram. I thinks this may only apply to the Dbi temp files.
Greg Payne
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Chris Thompson
Sent: Wednesday, June 12, 2013 3:16 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Epicor creates temp files at a alarming rate.....
We get the temp files daily. Often if a report crashes. We have a script that clears out the temp folder daily as sometimes if something like inv wip reconciliation crashes it will drop a 6gb temp file.
Chris Thompson
Greg Payne
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Chris Thompson
Sent: Wednesday, June 12, 2013 3:16 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Epicor creates temp files at a alarming rate.....
We get the temp files daily. Often if a report crashes. We have a script that clears out the temp folder daily as sometimes if something like inv wip reconciliation crashes it will drop a 6gb temp file.
Chris Thompson
On 12 Jun 2013, at 20:04, "Ned" <TechnoBabbly@...<mailto:TechnoBabbly%40gmail.com>> wrote:
> The temp files are created when the Server runs out of allotted space in
> the temp table buffers(-Bt in the .pf)
>
> This could be related to reports, or possibly related to a dashboard or
> tracker, or some BAQ that someone has written poorly.
>
> -----Original Message-----
> From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf Of
> Ephraim Feldman
> Sent: Wednesday, June 12, 2013 1:10 PM
> To: Vantage Yahoo Group
> Subject: Re: [Vantage] Epicor creates temp files at a alarming rate.....
>
> I dont recall doing that in the last few days
>
> how can i find out which report casues this?
>
> Ephraim
>
> On Wed, Jun 12, 2013 at 1:07 PM, Jose Gomez <jose@...<mailto:jose%40josecgomez.com>> wrote:
>
> > Big Reports can cause this, also bad RDDs have you created or modified
> > a report recently?
> >
> >
> > *Jose C Gomez*
> > *Software Engineer*
> > *
> > *
> > *
> > *T: 904.469.1524 mobile
> > E: jose@...<mailto:jose%40josecgomez.com>
> > http://www.josecgomez.com
> > <http://www.linkedin.com/in/josecgomez> <
> > http://www.facebook.com/josegomez>
> > <http://www.google.com/profiles/jose.gomez> <
> > http://www.twitter.com/joc85>
> > <http://www.josecgomez.com/professional-resume/>
> > <http://www.josecgomez.com/feed/>
> > <http://www.usdoingstuff.com>
> >
> > *Quis custodiet ipsos custodes?*
> >
> >
> > On Wed, Jun 12, 2013 at 1:04 PM, Ephraim Feldman <effgroups@...<mailto:effgroups%40gmail.com>
> > >wrote:
> >
> > > **
> > >
> > >
> > > Hi All
> > > Epicor version 9.05.701 Progress
> > >
> > > Since yesterday epicor started creating big temp files on our server.
> > > I tried restarting the server but within a half hour it used already
> > > as much as 10GB for temp files.
> > >
> > > I have no idea what happened. we didn't do any new BAQ or BPM that
> > > can cause this.
> > > I checked the log files and found no errors or anything suspicious.
> > >
> > > If anyone has a idea how i can find out what causes this i would
> > appreciate
> > >
> > > Ephraim
> > >
> > > [Non-text portions of this message have been removed]
> > >
> > >
> > >
> >
> >
> > [Non-text portions of this message have been removed]
> >
> >
> >
> > ------------------------------------
> >
> > Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
> > have already linked your email address to a yahoo id to enable access.
> > )
> > (1) To access the Files Section of our Yahoo!Group for Report Builder
> > and Crystal Reports and other 'goodies', please goto:
> > http://groups.yahoo.com/group/vantage/files/.<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/linksYahoo! Groups Links
> >
> >
> >
> >
>
> [Non-text portions of this message have been removed]
>
> ------------------------------------
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
> already linked your email address to a yahoo id to enable access. )
> (1) To access the Files Section of our Yahoo!Group for Report Builder and
> Crystal Reports and other 'goodies', please goto:
> http://groups.yahoo.com/group/vantage/files/.<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/linksYahoo! Groups Links
>
>
[Non-text portions of this message have been removed]
________________________________
CONFIDENTIALITY NOTICE
The information contained in this communication, including attachments, is privileged and confidential. It is intended only for the exclusive use of the addressee. If the reader of this message is not the intended recipient, or the employee or agent responsible for delivering it to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us at 727-578-6280 and immediately delete the communication.
"This (document/presentation) may contain technical data as defined in the International Traffic In Arms Regulations (ITAR) 22 CFR 120.10. Export of this material is restricted by the Arms Export Control Act (22 U.S.C. 2751 et seq.) and may not be exported to foreign persons without prior approval form the U.S. Department of State."
[Non-text portions of this message have been removed]