After PIC Upgrade from 9 to 10.1.X, some Sessions Are Updating Slowly and UNDO Tablespace Is at 100%

Asset ID:	1-72-2219980.1
Update Date:	2017-11-12
Keywords:

Solution Type Problem Resolution Sure

Solution 2219980.1 : After PIC Upgrade from 9 to 10.1.X, some Sessions Are Updating Slowly and UNDO Tablespace Is at 100%

Applies to:

Oracle Communications Performance Intelligence Center (PIC) Software - Version 10.1.0 and later
Information in this document applies to any platform.

Symptoms

After PIC upgrade from 9.x to 10.x, there are several INAP sessions that are not updating correctly. Several stopped around 2 AM (start of nightly job).

Changes

IXP were upgraded to PIC 10.x and sessions were upgraded in upgrade utility.

Cause

Nightly job is not able to drop unused columns.

Last line of of /var/TKLC/log/ixp/IXP_NIGHTLY_JOB.log indicates "DEBUG IXP_DROP_UNUSED_COLS Begin"

UNDO tablespace is too small for nightly job to be able to complete this while store is writing into table.

Solution

With partial dataloss (fast recovery)

Procedure with dataloss on session for the concerned DWS:

Connect on IXP server as cfguser
Stop store:

pm.set off IXP_xxxxxx
Connect on DWS and drop table (remove <>):

drop table <SESSION_name>;
Start store:

pm.set on IXP_xxxxxx
Verify store log and query session in ProTrace

Note that nightly job must not run while doing this procedure.

Without dataloss

Mark the concerned DWS in MAINTENANCE mode and wait one night for nightly job.

Attachments

This solution has no attachment