Clean Up Transactions Directly From The Database (Doc ID 565041.1)

Last updated on OCTOBER 24, 2016

Applies to:

Oracle Communications IP Service Activator - Version 4.0.1 and later
Information in this document applies to any platform.
***Checked for relevance on 6-OCT-2015***

Goal

This document outlines how to delete transactions from the IP Service Activator (IPSA) database if it is not possible to start-up the Policy Server. This may be due, for instance, to a single corrupt user transaction.
 

NOTE: The transactions table should never be truncated using SQL access direct to the database, the recommended method is to use the UI to clear the transactions archive (by setting the archive limit to 0).

Solution

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