My Oracle Support Banner

TSAM 11gR1 - How To Purge Old Data From TSAM Database ? (Doc ID 1475173.1)

Last updated on DECEMBER 12, 2019

Applies to:

Oracle Tuxedo System and Applications Monitor (TSAM) - Version 11.1.1.2.0 and later
Information in this document applies to any platform.

Goal

How to purge older data from Tuxedo System and Applications Monitor (TSAM) database ?


When TSAM data management option for clean up it is not working. This process fails with below error :

<ERROR> <PurgeRunnable.run:107 data purging thread> - ORA-30036: unable to extend segment by 8 in undo tablespace 'UNDO'
<openjpa-1.2.2-r422266:898935 nonfatal general error> org.apache.openjpa.persistence.PersistenceException: ORA-30036: unable to extend segment by 8 in undo tablespace 'UNDO'
        at org.apache.openjpa.jdbc.sql.DBDictionary.narrow(DBDictionary.java:4246)
        at org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDictionary.java:4211)
        at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:102)
        at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:88)
        at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:64)
        at org.apache.openjpa.jdbc.kernel.SQLStoreQuery$SQLExecutor.executeUpdate(SQLStoreQuery.java:237)
        at org.apache.openjpa.kernel.QueryImpl.update(QueryImpl.java:1039)
        at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:809)
        at org.apache.openjpa.kernel.QueryImpl.updateAll(QueryImpl.java:884)
        at org.apache.openjpa.kernel.QueryImpl.updateAll(QueryImpl.java:880)
        at org.apache.openjpa.kernel.DelegatingQuery.updateAll(DelegatingQuery.java:565)
        at org.apache.openjpa.persistence.QueryImpl.executeUpdate(QueryImpl.java:339)
        at com.oracle.tsam.dao.JPAImpl.TimedMetricsDaoImpl.deleteMD(TimedMetricsDaoImpl.java:98)
        at com.oracle.tsam.dao.JPAImpl.CallpathDaoImpl.delete(CallpathDaoImpl.java:329)
        at com.oracle.tsam.purge.PurgeRunnable.run(PurgeRunnable.java:103)
        at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441)
        at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
        at java.util.concurrent.FutureTask.run(FutureTask.java:138)
        at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:98)
        at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:207)
        at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
        at java.lang.Thread.run(Thread.java:619)

Solution

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
Goal
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.