• Introducing Dark Mode! Switch by clicking on the lightbulb icon next to Search or by clicking on Default style at the bottom left of the page!

rpz

Ricardo Paz

Reputable Poster
Hi list.... Actually I ´ve arround 450,000 records in the F42565 table...Is
it possible to purge all these records without causing any trouble???

OW 73.3.2 SP 10.1 / NT 4.0 / SQL 7.0

Greetings.
S.E. Ricardo Paz Castañón
Systems Chief
Comercial de Herramientas S.a de C.v.
+52(8)369-35-35
rpaz@cohesa.com.mx
www.cohesa.com



Lic. Ricardo Paz Castanon
Jefe Sistemas COHESA
 
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.

------_=_NextPart_001_01C0905F.821AEA4E
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

The F42565 file is a work file and when invoices are
not processing should be empty. We had a very large F42565 file which
caused the time to process an invoice to be exponentially longer than =
it
needed to be, as it was processing all the records over and over.

Make it a great day!

Dianne Cooper
EMAIL: Dianne_Cooper@contmtl.com
<mailto:Dianne_Cooper@contmtl.com>=20
 

Michelle D.

Active Member
Diane,

What else do you know about this file (F42565)? I just checked ours, and
it's huge! I can't quite figure out how the records are written to it ...
there's an assortment of program id's (EP4101, EP4210, EP42800, ER42535,
ER42565, R42996). Also, the most recent records are from January 24th. We
have certainly run invoices, sales update, etc. many times since then.

Michelle Dulay
ERP Coordinator
BFGoodrich Aerospace
Chandler Evans Control Systems
email: mdulay@chandlerevans.bfg.com

OneWorld B7322 with the MFG Mini-Cum, coexistent with World A7.3
AS400 V4R3 Enterprise Server
Windows NT SQL V6.5 Deployment Server
SynQuest V5.07.02
Oracle
NT Logic - between AS400 (OneWorld) and HP9000 (SynQuest)
 
We were told by JDE this is a work file and if
programs using it are terminated abnormally without coming to a normal
conclusion records may be stranded in this file. There is no program I am
aware of that clears this file so stranded records are never cleaned up.
Processing time for invoices must be kept at a minimum for us so we have a
query we run nightly to identify any stranded records.

Make it a great day!

Dianne Cooper
ONE WORLD
Product Code B73.2
Cum: 2
Service Pack Level 12.4
Enterprise Platform AS/400

Coexistant
EMAIL: Dianne_Cooper@contmtl.com
<mailto:Dianne_Cooper@contmtl.com>
 

KBohn

Active Member
Wow, we have 15,958 records in F42565......something's defintely not doing
it's job!!!

Kimberley :(
 
This is a multi-part message in MIME format.

------_=_NextPart_001_01C0907B.63620800
Content-Transfer-Encoding: quoted-printable
Content-Type: text/plain;
charset="iso-8859-1"

A temporary table used by invoice print. It isn't a data table it is an
internal table used possibly by Sales Update, Invoice Print. It usually
clears after invoice print.
 
Top