The ccsChangeDaemon Process Is Constantly Reporting "ORA-01002: fetch out of sequence" Errors
(Doc ID 1388081.1)
Last updated on AUGUST 19, 2019
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:
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 <SMS_HOSTNAME> ccsChangeDaemon: [ID 438867 user.warning] ccsChangeDaemon(21212) WARNING Oracle=-1002 ccsChangeDaemon_oracle.pcc@195: select pcq.id ,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.
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