Hello all,

you can also use standard BPCS depuration programs to delete message records en TELB.
Go to ECM, option 53 (program ecm803d), then type 10 in front of ECM804B.

Here you can delete by date and ECA all the records in TELB file previous to the selected date.

Regards
Enrique Calvín


From: "Davide Roveda" <Davide.Roveda@xxxxxxxxxxxxx>
Reply-To: "SSA's BPCS ERP System" <bpcs-l@xxxxxxxxxxxx>
To: "SSA's BPCS ERP System" <bpcs-l@xxxxxxxxxxxx>
Subject: RE: [BPCS-L] URGENT!      ECM - TELB file question
Date: Mon, 12 Dec 2005 18:41:45 +0100
MIME-Version: 1.0
Received: from bay0-mc8-f4.bay0.hotmail.com ([65.54.244.236]) by bay0-imc3-s34.bay0.hotmail.com with Microsoft SMTPSVC(6.0.3790.211); Mon, 12 Dec 2005 10:18:00 -0800 Received: from mail.midrange.com ([69.3.23.28]) by bay0-mc8-f4.bay0.hotmail.com with Microsoft SMTPSVC(6.0.3790.211); Mon, 12 Dec 2005 10:15:59 -0800 Received: from rivendell.midrange.com (localhost [127.0.0.1])by mail.midrange.com (8.13.1/8.13.1) with ESMTP id jBCHg04t012887for <enriquecalvin@xxxxxxxxxxx>; Mon, 12 Dec 2005 11:42:23 -0600 Received: from nlbaxiportp1.ssainternal.net (nlsmtpp1.ssaglobal.com[194.149.81.53])by mail.midrange.com (8.13.1/8.13.1) with ESMTP id jBCHfmIM012842for <bpcs-l@xxxxxxxxxxxx>; Mon, 12 Dec 2005 11:41:53 -0600 Received: from unknown (HELO itmiwexcu1.ssainternal.net) ([10.4.68.25])by nlbaxiportp1.ssainternal.net with ESMTP; 12 Dec 2005 18:41:52 +0100
X-Message-Info: JGTYoYF78jHs1Zq9McXmM/5kgYTbecEz1q197E0pKUM=
X-SBRS: None
X-MimeOLE: Produced By Microsoft Exchange V6.5.7226.0
Content-class: urn:content-classes:message
X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: [BPCS-L] URGENT! ECM - TELB file question
Thread-Index: AcX/Nq/9Svn7MX+aRHahzhqMBG89/gAC3CTg
X-Virus-Scanned: ClamAV 0.87.1/1209/Mon Dec 12 09:48:01 2005 onrivendell.midrange.com
X-Virus-Status: Clean
X-MIME-Autoconverted: from quoted-printable to 8bit by mail.midrange.com idjBCHfmIM012842
X-BeenThere: bpcs-l@xxxxxxxxxxxx
X-Mailman-Version: 2.1.5
Precedence: list
List-Id: SSA's BPCS ERP System <bpcs-l.midrange.com>
List-Unsubscribe: <http://lists.midrange.com/mailman/listinfo/bpcs-l>,<mailto:bpcs-l-request@xxxxxxxxxxxx?subject=unsubscribe>
List-Archive: <http://archive.midrange.com/bpcs-l>
List-Post: <mailto:bpcs-l@xxxxxxxxxxxx>
List-Help: <mailto:bpcs-l-request@xxxxxxxxxxxx?subject=help>
List-Subscribe: <http://lists.midrange.com/mailman/listinfo/bpcs-l>,<mailto:bpcs-l-request@xxxxxxxxxxxx?subject=subscribe>
Errors-To: bpcs-l-bounces+enriquecalvin=hotmail.com@xxxxxxxxxxxx
Return-Path: bpcs-l-bounces+enriquecalvin=hotmail.com@xxxxxxxxxxxx
X-OriginalArrivalTime: 12 Dec 2005 18:16:00.0125 (UTC) FILETIME=[1ABD02D0:01C5FF48]

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.

--
This is the SSA's BPCS ERP System (BPCS-L) mailing list
To post a message email: BPCS-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/bpcs-l
or email: BPCS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/bpcs-l.

Delivered-To: davide.roveda@xxxxxxxxxxxxx

--
This is the SSA's BPCS ERP System (BPCS-L) mailing list
To post a message email: BPCS-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/bpcs-l
or email: BPCS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/bpcs-l.

Delivered-To: enriquecalvin@xxxxxxxxxxx



As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2021 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.