Error Using partition_utils.pl (Doc ID 1105573.1)

Last updated on SEPTEMBER 19, 2016

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.3.0.0.0 and later
Information in this document applies to any platform.
***Checked for relevance on 23-Dec-2011***
***Checked for relevance on 31-Dec-2013***
*** Checked for relevance on 08-28-2015 ***


Goal

When using the partition_utils.pl script with an update option on new event sub class we receive
the following error:

SQL> INFO: Procedure update_partitions_exec
Processing the table EVENT_SES_MACHINE_HOST_BASIC_T
Error in give_partition_name
Inputs i_curpoid = 258552358294781952 i_tabName = EVENT_SES_MACHINE_HOST_BASIC_T
ORA-01403: no data found
ORA-06503: PL/SQL: Function returned without value
BEGIN PIN_PARTITION.update_partitions_exec(FALSE, TRUE, FALSE); END;


According to the documentation this should work but it does not.


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