"ORA-01653: unable to extend table..." Error for CCS_ADMIN.CCS_SP_HISTORY and/or CCS_ADMIN.CCS_SP_CHANGE Tables when Adding or Changing Subscriber Profiles (Doc ID 1371450.1)

Last updated on SEPTEMBER 06, 2016

Applies to:

Oracle Communications Network Charging and Control - Version 3.1.0 and later
Information in this document applies to any platform.

Symptoms

When attempting to run PI commands that update profile data the following errors occur in the syslog (/var/adm/messages) and /IN/service_packages/PI/tmp/PImanager.log on the SMS:

Oct 3 11:20:56 PIprocess:3100(3378) Oracle=-1653 PIcProfile_oracle.pcc@298: update CCS_ACCT_REFERENCE set PROFILE=:b0 where CLI=:b1: ORA-01653: unable to extend table CCS_ADMIN.CCS_SP_CHANGE by 6400 in t

 

Oct 27 23:58:20 PIprocess:3100(25714) Oracle=-1653 CCSCD1_oracle.pcc@2269: w¤TE /: ORA-01653: unable to extend table CCS_ADMIN.CCS_SP_HISTORY by 6400 in

 

Note: These messages can be truncated as shown in the examples


There will normally also be an associated command failure message. This is one known example:

Oct 27 22:02:35 PIprocess:3100(25714) Error ocurred running C function CCSCD1 in shared library PI_CCSCD1. Output is CCSCD1=ADD:NACK:69-Could not update msisdn xxxxxxxx profile

 

Note: Profiles may be updated via other mechanisms and cause similar messages in other log files.

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