Forum Stats

  • 3,758,248 Users
  • 2,251,359 Discussions
  • 7,870,124 Comments

Discussions

SOA Delete Instances not working when composite_name and composite_revision has value or wildcard

2878717
2878717 Member Posts: 1

I am trying to used the stored procedure soa.delete_instances but it is not purging my instances when I set composite_name and/or composite_revision to value or wildcard '%'. When i set composite_name and/or composite_revision to NULL the purge is working.

This is my input to soa.delete_instances with wildcard, i have tried COMPOSITE_NAME := 'BPELComposite1'; and COMPOSITE_REVISION := '1.0'; too instead of '%' but it is not working.

This is not working when processes are not purged:

MIN_CREATION_DATE := '2018-04-01 13:00:00';

  MAX_CREATION_DATE := '2019-02-19 11:00:00';

  BATCH_SIZE := 15000;

  MAX_RUNTIME := 720;

  RETENTION_PERIOD := NULL;

  PURGE_PARTITIONED_COMPONENT := false;

  COMPOSITE_NAME := '%';

  COMPOSITE_REVISION := '%';

  SOA_PARTITION_NAME := 'bz';

  IGNORE_STATE := true;

  PQS := 1;

  SQL_TRACE := false;

  INMEMORY := false;

It is working when COMPOSITE_NAME := NULL; and COMPOSITE_REVISION := NULL :

MIN_CREATION_DATE := '2018-04-01 13:00:00';

  MAX_CREATION_DATE := '2019-02-19 11:00:00';

  BATCH_SIZE := 15000;

  MAX_RUNTIME := 720;

  RETENTION_PERIOD := NULL;

  PURGE_PARTITIONED_COMPONENT := false;

  COMPOSITE_NAME := NULL;

  COMPOSITE_REVISION := NULL;

  SOA_PARTITION_NAME := 'bz';

  IGNORE_STATE := true;

  PQS := 1;

  SQL_TRACE := false;

  INMEMORY := false;

I am using 12.2.1.3 and i got the purge working with another partition, Composite name och revision. I have also tried soa.delete_instances in Version 11.1.1.7.0 and in 11.1.1.7.0 purge is working with wildcard "%" for Composite name och revision. Is wildcard not allowed for Composite name och revision in Version 12.2.1.3?

Meddelandet redigerades av: 2878717

Answers