Versions Compared

Old Version 7

changes.mady.by.user Former user

Saved on

compared with

New Version 8

changes.mady.by.user Former user

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  • UDRs, batches, and ECS statistics are removed from the ECS according to the settings in the Cleanup tab. See Cleanup Tab in ECS Maintenance System Task Configuration for further information.

    Info
    titleInfo!

    This information is only for customers using versions of that are older than 8.1.8.0!

    When using PostgreSQL as your Platform database, if you have a large number of UDRs or batches in ECS, the removal of the UDRs and batches will be slow and can sometimes be frozen. To speed up the process, you can remove the foreign key reference from the following tables:

    UDR or BatchTablesForeign Key ReferenceUDR

    mzowner.ecs_mim

    mzowner

    .

    ecs_udr

    mzowner.ecs_udr_error

    ecs_mim_txn_id_fkey

    ecs_udr_txn_id_fkey

    ecs_udr_error_ecs_udr_id_fkey

    Batch

    mzowner.ecs_mim

    mzowner.ecs_batch

    mzowner.ecs_batch_error

    ecs_mim_txn_id_fkey

    ecs_batch_txn_id_fkey

    ecs_batch_error_txn_id_fkey

    You can use the alter SQL command to drop the foreign key reference:

    Code Block
    languagesql
    alter table mzowner.ecs_mim drop constraint ecs_mim_txn_id_fkey;
alter table mzowner.ecs_udr drop constraint ecs_udr_txn_id_fkey;
alter table mzowner.ecs_batch drop constraint ecs_batch_txn_id_fkey;
alter table mzowner.ecs_batch_error drop constraint ecs_batch_error_txn_id_fkey;
alter table mzowner.ecs_udr_error drop constraint ecs_udr_error_ecs_udr_id_fkey;

    If the number of days after which data should be removed has been configured to 0 (zero) days, data is removed every time the ECS_Maintenance System Task is executed, with a minimum time interval of one hour.

  • An ECS Statistics Event is generated containing information about the number of UDRs associated with every error code.  This This occurs at time intervals configured in the ECS _ Maintenance system task, see ECS Maintenance System Task Configuration.

    See 4.3.22 ECS Statistics Event for further information about how to configure notifications for the ECS Statistics Event.

  • Statistical information is sent to the ECS Statistics, according to what is configured in the ECS_Maintenance system task. See the Report Tab in ECS Maintenance System Task Configuration.

  • An email containing statistical information is sent to the email recipient specified in the ECS_Maintenance system task. See the Report Tab in ECS Maintenance System Task Configuration.

    For further information on how to configure mailserver and port, see 2.6.4 Platform Properties in the System Adminstrator's Guide.


Note
titleNote!

The ECS is designed to store a fairly limited amount of erroneous UDRs and batches. It is therefore important that the data is extracted, reprocessed, or deleted from the ECS on a regular basis.

The section contains the following subsection:

Child pages (Children Display)

...