Technical Support for Environmental Data Collection Software
Views: 356
Attachments: 0
Related Articles: 1
Feedback: 0
Helpful: 0
Not Helpful: 0
File Attachments
No attachments were found.

CWMS CCP Subscriber Restart

  • Author: Michael Maloney
  • Create Time: 05/28/2013 09:51:25
  • Last Update Time: 05/28/2013 09:52:29
 When new Time Series Data is added to the CWMS database, the API places an entry in a queue indicating what just happened. The CCP Subscriber handles data from that queue. It determines if any computation depend on the new data, and if so, it adds entries to the CP_COMP_TASKLIST table. This causes the computations to be run.

We have seen cases where the subscriber fails. This is not a normal use case. Please contact HEC CWMS tech support if you suspect this has happened.

To restart the subscriber:

A) Login as CCP DB user;

B) Run the commands from SQL*PLUS

define subscriber_name = CCP_SUBSCRIBER;
Begin
  cwms_ccp.reload_callback_proc(
  	p_subscriber_name   =>	'&subscriber_name'
  );

  cwms_ccp.start_check_callback_proc_job; 
End;
/
Post Feedback
This article is:
Name: *
Email: *
Comment:
Verification Code: *
*Required Field
Related Articles
Feedback
No Feedback was found.