Migration for Bug 23541983 Is Not Working on Large Model with about 8 Million Rows in Database Table DDS_ALARM_LOG (Doc ID 2298250.1)

Last updated on AUGUST 21, 2017

Applies to:

Oracle Utilities Network Management System - Version 2.3.0.0.0 to 2.3.0.0.0 [Release 2.3]
Oracle Network Management for Utilities - DMS - Version 2.3.0.0.0 to 2.3.0.0.0 [Release 2.3]
Information in this document applies to any platform.

Symptoms

The 2.3 migration for unpublished bug 23541983 is failing when applied on a model with about 8 million rows in database table DDS_ALARM_LOG.  Additional information on this migration can be found in $NMS_HOME/migration/manual/23541983.txt


Running migration for Bug# 23541983
ISQL.ces loading /scratch/users/opal1/migration/sql/pr23541983_migration.sql
Converting generic sql file to ORACLE file /scratch/users/opal1/logs/tmp/isql.opal1.8630
Error converting sql file [/scratch/users/opal1/migration/sql/pr23541983_migration.sql] - Check sql file format.
A sql statement or a block of plsql statements failed at input file line 39
error = ORA-01652: unable to extend temp segment by 128 in tablespace OPAL_TMP
The failed statement or block of statements are:


MERGE INTO dds_alarm_log dds
USING
(SELECT NVL(d2.user_time, d2.system_time) WHEN_D, d1.alarm_idx
FROM dds_alarm_log d1, dds_alarm_log d2
WHERE d1.alarm_type = 104 AND d1.active = 'N'
AND d1.device_cls = d2.device_cls
AND d1.device_idx = d2.device_idx
AND d2.alarm_type = 105
AND d2.alarm_idx = (SELECT MIN(alarm_idx) FROM dds_alarm_log d3 WHERE d3.device_cls = d2.device_cls
AND d3.device_idx = d2.device_idx
AND d3.alarm_type = 105
AND d3.alarm_idx >= d1.alarm_idx)) q ON (q.alarm_idx = dds.alarm_idx)
WHEN MATCHED THEN UPDATE
SET dds.when_deactivated = q.when_d;
08/16/17 23:45:24: 0x7f2945f01740,ctp=0x1c6c158,"<MAIN-TASK>" cessql failed!
ISQL Error encountered in file /scratch/users/opal1/migration/sql/pr23541983_migration.sql.

Changes

 

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