RE: URGENT! ECM - TELB file question

Hello

Generally you have on the ECM files the creation date. Use it to properly 
delete when needed, after a check. 

For TELB you can clean easy the one that well answer on:

SELECT * FROM telb WHERE ELERR like 'UMN035%'
as
Msg ID   Message Text 132                     
UMN0350  Function Started                     
UMN0351  Function Completed Successfully      
UMN0353  Cycle Completed Successfully         

This one you have to take care
Msg ID   Message Text 132                     
UMN0352  Function Completed With Error(s)     

Or you can use ELGID of such a log to properly delete the file you feel old as 
information with (huge as time consuming for your data) SQL IN, lined via GUID. 

ECM803 BPCS Std function allows you to purge ECM. Do you try it? 

Best regards

-----Original Message-----
From: bpcs-l-bounces+davide.roveda=ssaglobal.com@xxxxxxxxxxxx 
[mailto:bpcs-l-bounces+davide.roveda=ssaglobal.com@xxxxxxxxxxxx] On Behalf Of 
SCarper@xxxxxxxx
Sent: lunedì 12 dicembre 2005 15.24
To: bpcs-l@xxxxxxxxxxxx
Subject: [BPCS-L] URGENT! ECM - TELB file question

Our TELB file set up in our sister environment keeps growing and growing 
out of control.
I have tried to match the setup of the main environment to see if there is 
a discrepancy in the set up, but cannot pinpoint anything.
I have gone into the notification log and tried deleting very old entries, 
but it does not seem to affect it.
The file's size has become an major problem.  There are records in it from 
2004.  I am reluctant to simply drop records using SQL  for fear it is not 
the proper way to handle, given ECM' s link to other files with the guid.
If anyone has any insight on what we are missing.......Please help!
Thanks,
Sheila

This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom
they are addressed.
If you have received this email in error please notify the
originator of the message. This footer also confirms that this
email message has been scanned for the presence of computer viruses.
Any views expressed in this message are those of the individual
sender, except where the sender specifies and with authority,
states them to be the views of ESAB Welding & Cutting.