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