My Oracle Support Banner

BRM Partitioning.pl Can't Execute Event_partition.sql (Doc ID 1616465.1)

Last updated on DECEMBER 04, 2017

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.5.0.0.0 to 7.5.0.0.0 [Release 7.5.0]
Information in this document applies to any platform.
*** Checked for relevance on 02-11-2016 ***

Symptoms

BRM (Billing) partitioning.pl can't execute event_partition.sql

$ perl partitioning.pl
Running all the scripts
Started pin_upg_common.sql at Wed Sep 11 18:31:28 2013
Started tables_tobe_partitioned.sql at Wed Sep 11 18:31:29 2013
Started make_indexes_partition_ready.sql at Wed Sep 11 18:31:30 2013
Started event_partition.sql at Wed Sep 11 18:31:30 2013
Error executing event_partition.sql
Continue? (Y/N) Y
Continuing from error
Run event_partition.sql again after fixing the errors

Scripts completed successfully


Error in the log:

...
Processing the table SSG_EVENT_PLAN_PURCH_STATUS_T
INFO: SSG_EVENT_PLAN_PURCH_STATUS_T already contains PARTITION_LAST partition
Partitions dropped
PINPARTITION_ERROR_NO -20017
ORA-20017: PARTITION_LASTPartition not exists in table SSG_EVENT_PLAN_PURCH_STATUS_T
BEGIN PIN_PARTITION.add_partitions_exec(FALSE, TRUE, FALSE); END
...


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. perl partitioning.pl

Cause

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
Symptoms
Cause
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.