My Oracle Support Banner

Troubleshooting Weekly CCS_BE_CDR Database Table Partitions and "ORA-01688: unable to extend table" Error Messages (Doc ID 1304330.1)

Last updated on DECEMBER 03, 2019

Applies to:

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

Purpose

This document provides a high level overview of the Network Charging and Control (NCC)  CCSPART/CCSCPART (ccsCdrPart package) software that is used for splitting database tables into weekly partitions.  There are also various tools and tips given in the document which will assist in debugging the Charging Control Service Partitioning (CCSPART) software.

Notes:
1) Veritas File System (VFS or VxFS) is required for CCSPART in a clustered environment, stand-alone installations don't require VFS.
2) There are various tables which can be used with partitioning software, one of the most popular table is CCS_BE_CDR table and hence used as an example throughout this document.
3) Refer to Note 1353008.1 for troubleshooting non-partitioned CCS_BE_CDR database


As well as giving a high level overview of CCSPART application, the main focus of this document is what to do if the following errors are reported in the syslog (/var/adm/messages).

Jan 11 22:50:27 <HOSTNAME> ccsCDRLoader: [ID 675952 user.error] ccsCDRLoader(20083) ERROR: flush: INSERT: ORA-01688: unable to extend table <OWNER>.CCS_BE_CDR partition CCS_BE_CDR_Y2011_W02 by 1600 in tablespace CCS_BE_CDR_Y2011_W02

Jan 11 21:30:01.529542 ccsCDRLoader(20083) ERROR: Plugin 'CDRStoreDBPlugin' failed when processing CDR

Jan 13 21:30:01.533258 ccsCDRLoader(20083) ERROR: Plugin 'FileWriterCDRLoaderPlugin' failed when processing CDR

This will occur when a CCS_BE_CDR weekly partition is full and new Event Data Records (EDR) - previously referred to as CDR (Call Data Records) - can not be inserted into the database.

Troubleshooting Steps

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
Purpose
Troubleshooting Steps
 1. What is partitioning?
 2. Partition rolling window
 3. ccsCdrPart partitioning package
 4. Partitioning tasks
 5. Debugging - Tips and Tools
 6. Issue Example: Unable to extend CCS_BE_CDR partition, or delete historical data
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.