politicalpolt.blogg.se - Sterling integrator document info service content type zip

STERLING INTEGRATOR DOCUMENT INFO SERVICE CONTENT TYPE ZIP UPDATE
STERLING INTEGRATOR DOCUMENT INFO SERVICE CONTENT TYPE ZIP ARCHIVE

The Linkage Purge cleans the WORKFLOW_LINKAGE table. KPI : BP index count Select count(*) from ARCHIVE_INFO where ARCHIVE_FLAG in (-1,-2,-5) Linkage Purge

The Database BP transactional records in various tables (more than 50 tables) will NEVER be deleted if they are not marked by the Index (Risk of Database growth).

The Troubleshooter / Business Process Usage screen will not show if the index count is high.

BP recovery is responsible for recovering BPs and it will either terminate, resume, restart failing or hanging BPs.

High Index backlog affects the BP recovery performance.

Don’t ignore failing Index email alerts.

You can activate DEBUG logging for a short period to measure the performance of Index operations.

Investigate failing to index BPs (archive_flag -5).

For example: run the schedule every 5 minutes with a doubled batch size of 20k on busy systems.

Adjust the schedule frequency and the max to process parameter in the Index BP.

BP Index count should be always low (below 50000 records on average systems).

Index updates archive_info records with 10 years lifespan when the lifespan is reset following a mailbox delete.

Mailbox documents will have an initial 10 years archive_date (lifespan).Index works only on BPs that are Completed or Terminated.If a BP fails Index, it is remarked with an ARCHIVE_FLAG of -5.

Removal Method is either 0 (Archive/backup) or 1,2 (Purge).Lifespan is the date after which the process becomes eligible for the next service.Updates the records in ARCHIVE_INFO, setting the ARCHIVE_DATE equal to the Lifespan, and the ARCHIVE_FLAG equal to the Removal Method from WF_INST_S.Calculates the Lifespan and Removal Method for the BP based on the Workflow Definition.Schedule name is ‘Schedule_IndexBusinessProcessService’.

STERLING INTEGRATOR DOCUMENT INFO SERVICE CONTENT TYPE ZIP UPDATE

This important housekeeping process will update the archive_date and the removal_method (purge or archive) of completed BPs.

STERLING INTEGRATOR DOCUMENT INFO SERVICE CONTENT TYPE ZIP ARCHIVE

BP Index Service :Ĭalled also the BP business process moving service, is responsible for indexing new BP archive information and calculates their archive_date.Įvery time a BP is run, it will create two records in the ARCHIVE_INFO table with a NULL archive_date. I will also present some best practices and important KPI to avoid the Database unnecessary growth. In this blog, I will explain how these system processes work. Sterling B2B Integrator Database tables are maintained by several housekeeping jobs.