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 NOVEMBER 03, 2016

Applies to:

Oracle SOA Platform - Version 11.1.1.1.0 and later
Information in this document applies to any platform.
***Checked for relevance on 13-Dec-2012***

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

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms