My Oracle Support Banner

SOAINFRA Sensor Tables VARIABLE_SENSOR_VALUES, ACTIVITY_SENSOR_VALUES, COMPOSITE_SENSOR_VALUE, FAULT_SENSOR_VALUES are not Purged of Data After Running SOA Purge Scripts (Doc ID 1332374.1)

Last updated on MAY 15, 2023

Applies to:

Oracle SOA Suite - Version 11.1.1.1.0 to 11.1.1.6.0 [Release 11gR1]
Information in this document applies to any platform.

Symptoms

You have purged SOA instance data by following this documentation:

Oracle® Fusion Middleware Administrator's Guide for Oracle SOA Suite and Oracle Business Process Management Suite
11g Release 1 (11.1.1.5.0)
Part Number E10226-09

Section:  9.3 Deleting Large Numbers of Instances with the Purge Scripts

After the purge it is noticed that the SOAINFRA Tables VARIABLE_SENSOR_VALUES, ACTIVITY_SENSOR_VALUES, COMPOSITE_SENSOR_VALUE, FAULT_SENSOR_VALUES have not been purged of any data.  There may be many rows in these tables depending on the usage of Sensors.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.