BRM 7.4 Installation Fails With ORA-14030 Error (Doc ID 1472364.1)

Last updated on JUNE 21, 2017

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.4.0.0.0 to 7.4.0.0.0 [Release 7.4.0]
Information in this document applies to any platform.

Goal

 In BRM 7.4,

Installation is failing with ORA-14030 Error.

When the following sql statement is issued by dm_oracle during pin_setup:-


SQL> CREATE TABLE susp_usage_edr_buf ( obj_id0 int , edr_buf blob  ) tablespace pin3112 initrans 2 storage (initial 500k next 500k maxextents unlimited pctincrease 0 freelists 2 ) partition by range (poid_id0) (partition partition_last values less than (MAXVALUE));
CREATE TABLE susp_usage_edr_buf ( obj_id0 int , edr_buf blob  ) tablespace pin3112 initrans 2 storage (initial 500k next 500k maxextents unlimited pctincrease 0 freelists 2 ) partition by range (poid_id0) (partition partition_last values less than (MAXVALUE))


The installation fails with the error:-


----------

E Tue Mar 27 18:45:18 2012  <m/c> dm:18682  dm_subr.c(124):1207 1:<m/c>:<no_name>:18617:
-134551872:21:1332899094:1
       ORACLE error: do_sql: PINStmtExecute: code 14030, op 0
       =ORA-14030: non-existent partitioning column in CREATE TABLE statement

E Tue Mar 27 18:45:18 2012  <m/c>dm:18682  sm_dd_obj_set.c(13):3007 1:<m/c>:<no_name>:1
8617:-134551872:21:1332899094:1
       "CREATE TABLE susp_usage_edr_buf ( obj_id0 int , edr_buf blob  ) tablespace pin3112 initrans 2 storage (initi
al 500k next 500k maxextents unlimited pctincrease 0 freelists 2 ) partition by range (poid_id0) (partition partition
_last values less than (MAXVALUE))"
E Tue Mar 27 18:45:18 2012  <m/c> dm:18682  dm_back.c(28):1394 1:<m/c>:<no_name>:18617:-
134551872:21:1332899094:1
       DMbe #7: process_op: op 21(PCM_OP_SET_DD), err 43(PIN_ERR_STORAGE)

-----------

 

 

 

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