The ccsChangeDaemon Process Is Constantly Reporting "ORA-01002: fetch out of sequence" Errors

(Doc ID 1388081.1)

Last updated on MARCH 27, 2015

Applies to:

Oracle Communications Network Charging and Control - Version: 3.2.0 to 4.4.0 - Release: 3.2.0 to 4.4
Information in this document applies to any platform.


The ccsChangeDaemon is a process running on the Service Management System (SMS) server and handles changes in Periodic Charges for Subscribers that swap their product type amongst other tasks. (Another instance of ccsChangeDaemon runs on the Vouchers and Wallet Server (VWS) and handles different tasks).

From the Network Charging and Control Charging Control Services (CCS) Technical guide:

ccsChangeDaemon updates assignment of periodic charges to wallets.

On the SMS ccsChangeDaemon handles periodic charge changes when:
  • a subscriber is associated with a new wallet, or
  • a subscriber changes product type for a wallet.

For further information about ccsChangeDaemon, refer to the CCS technical guide. A link to a document describing how the Network Charging and Control documentation can be downloaded is available in this document's references.

The error message logged in the system's syslog (usually located at /var/adm/messages) is the following:

Sep 19 12:46:33 sms01 ccsChangeDaemon: [ID 438867 user.warning] ccsChangeDaemon(21212) WARNING Oracle=-1002 ccsChangeDaemon_oracle.pcc@195: select ,pcq.subscriber_id ,pcq.wallet_id ,pcq.change_type ,pcq.: ORA-01002: fetch out of sequence


No particular changes are required for this issue to start.


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