[c-nsp] ICM 8 - webview reports show no data

John Snow john.snow at sait.ca
Thu Apr 7 16:11:13 EDT 2011 

No real-time or historical data available when using webview to pull reports.   How do I check the data on the SQL db to verify data integrity or is there something I should be checking prior?

At some point it looks like icm failed over to sideB, but replication doesn't seem to be running - or the data is corrupted; you can see the error messages on rgrA.

sideA awhds distributor

10:28:42 Feed activated to client at [net16cc-awhdsA1]/[127.0.0.1].
12:23:55 Client at [net16cc-awhdsA1]/[127.0.0.1] disconnected.
12:23:59 Feed activated to client at [net16cc-awhdsA1]/[127.0.0.1].
16:20:18 Feed activated to client at [net16cc-awhdsA1]/[127.0.0.1].
16:20:43 Client at [net16cc-awhdsA1]/[127.0.0.1] disconnected.
16:23:00 Feed activated to client at [net16cc-awhdsA1]/[127.0.0.1].
08:37:42 Client at [net16cc-awhdsA1]/[127.0.0.1] disconnected.
08:37:43 Client at [net16cc-awhdsA1]/[127.0.0.1] disconnected.
08:37:43 Client at [net16cc-awhdsA1]/[127.0.0.1] disconnected.
08:37:54 Feed activated to client at [net16cc-awhdsA1]/[127.0.0.1].
08:37:58 Client at [net16cc-awhdsA1]/[127.0.0.1] disconnected.
08:38:26 Feed activated to client at [net16cc-awhdsA1]/[127.0.0.1].
08:39:46 Client at [net16cc-awhdsA1]/[127.0.0.1] disconnected.
08:44:30 Feed activated to client at [net16cc-awhdsA1]/[127.0.0.1].
08:44:34 Client at [net16cc-awhdsA1]/[127.0.0.1] disconnected.
08:45:03 Feed activated to client at [net16cc-awhdsA1]/[127.0.0.1].
08:45:10 Client at [net16cc-awhdsA1]/[127.0.0.1] disconnected.
08:58:57 Feed activated to client at [net16cc-awhdsA1]/[127.0.0.1].
08:59:43 Feed activated to client at [net16cc-awhdsA1]/[127.0.0.1].
14:10:49 Client at [net16cc-awhdsA1]/[127.0.0.1] disconnected.
14:10:52 Client at [net16cc-awhdsA1]/[127.0.0.1] disconnected.
14:42:49 Feed activated to client at [net16cc-awhdsA1]/[127.0.0.1].
14:43:20 Client at [net16cc-awhdsA1]/[127.0.0.1] disconnected.
10:27:50 Feed activated to client at [net16cc-awhdsA1]/[127.0.0.1].
10:28:15 Feed activated to client at [net16cc-awhdsA1]/[127.0.0.1].
10:28:17 Client at [net16cc-awhdsA1]/[127.0.0.1] disconnected.
10:28:21 Client at [net16cc-awhdsA1]/[127.0.0.1] disconnected.


sideB awhds distributor

18:47:59 Trace: HDSType = 1 at Registry key: Software\Cisco Systems, Inc.\ICM\sait1\Distributor\RealTimeDistributor\CurrentVersion
18:47:59 Trace: Realtime data is enabled. mask = 7f
18:47:59 Preferred feed established from [net16cc-rgrB1]/[41007].
18:47:59 Feed activated to client at [net16cc-awhdsB1]/[127.0.0.1].
18:47:59 Feed activated to client at [net16cc-awhdsB1]/[127.0.0.1].
09:03:17 Feed activated to client at [net16cc-awhdsB1]/[127.0.0.1].
09:03:29 Client at [net16cc-awhdsB1]/[127.0.0.1] disconnected.
09:04:16 Feed activated to client at [net16cc-awhdsB1]/[127.0.0.1].
09:04:21 Feed activated to client at [net16cc-awhdsB1]/[127.0.0.1].
09:04:28 Client at [net16cc-awhdsB1]/[127.0.0.1] disconnected.
09:04:33 Feed activated to client at [net16cc-awhdsB1]/[127.0.0.1].
09:48:20 Client at [net16cc-awhdsB1]/[127.0.0.1] disconnected.
09:55:31 Client at [net16cc-awhdsB1]/[127.0.0.1] disconnected.
02:00:00 Preferred feed from [net16cc-rgrB1]/[41007] has been broken.
02:00:00 Attempting to establish backup feed from [net16cc-rgrA1]/[40007].
02:00:00 Trace: ConfigOnlyAW = 0 at Registry key: Software\Cisco Systems, Inc.\ICM\sait1\AW
02:00:00 Trace: HDSType = 1 at Registry key: Software\Cisco Systems, Inc.\ICM\sait1\Distributor\RealTimeDistributor\CurrentVersion
02:00:00 Trace: Realtime data is enabled. mask = 7f
02:00:00 Backup feed established from [net16cc-rgrA1]/[40007].
02:00:00 Feed activated to client at [net16cc-awhdsB1]/[127.0.0.1].
02:00:00 Feed activated to client at [net16cc-awhdsB1]/[127.0.0.1].
02:00:53 Trace: ConfigOnlyAW = 0 at Registry key: Software\Cisco Systems, Inc.\ICM\sait1\AW
02:00:53 Trace: HDSType = 1 at Registry key: Software\Cisco Systems, Inc.\ICM\sait1\Distributor\RealTimeDistributor\CurrentVersion
02:00:53 Trace: Realtime data is enabled. mask = 7f
02:00:53 Successfully switched feed from backup at [net16cc-rgrA1]/[40007] to preferred at [net16cc-rgrB1]/[41007].
02:00:53 Feed activated to client at [net16cc-awhdsB1]/[127.0.0.1].
02:00:53 Feed activated to client at [net16cc-awhdsB1]/[127.0.0.1].
13:50:37 Feed activated to client at [net16cc-awhdsB1]/[127.0.0.1].
13:50:47 Feed activated to client at [net16cc-awhdsB1]/[127.0.0.1].


sideA rogger replication

14:05:18 Trace: No MATCHING entry for table t_Route_Call_Detail, FromRecoveryKey = 580211865072.0 and ToRecoveryKey = 580211840829.0
14:05:18 Trace: No MATCHING entry for table t_Termination_Call_Variable, FromRecoveryKey = 580212909012.0 and ToRecoveryKey = 580212654177.0
14:05:21 Trace: No MATCHING entry for table t_Application_Gateway_Half_Hou, FromRecoveryKey = 580211758000.0 and ToRecoveryKey = 580211758000.0
14:05:21 Trace: No MATCHING entry for table t_Route_Call_Variable, FromRecoveryKey = 580212332230.0 and ToRecoveryKey = 580212208664.0
14:05:23 Trace: No MATCHING entry for table t_Call_Type_Half_Hour, FromRecoveryKey = 580211758000.0 and ToRecoveryKey = 580211758000.0
14:05:25 Trace: No MATCHING entry for table t_Call_Type_Interval, FromRecoveryKey = 580211826033.0 and ToRecoveryKey = 580211809956.0
14:05:27 Trace: No MATCHING entry for table t_Termination_Call_Detail, FromRecoveryKey = 580212060567.0 and ToRecoveryKey = 580211991844.0
14:05:27 Trace: No MATCHING entry for table t_Call_Type_SG_Half_Hour, FromRecoveryKey = 580211758000.0 and ToRecoveryKey = 580211758000.0
14:05:29 Trace: No MATCHING entry for table t_Call_Type_SG_Interval, FromRecoveryKey = 580211766356.0 and ToRecoveryKey = 580211764343.0
14:05:31 Trace: No MATCHING entry for table t_Campaign_Half_Hour, FromRecoveryKey = 580211758000.0 and ToRecoveryKey = 580211758000.0
14:05:33 Trace: No MATCHING entry for table t_Campaign_Query_Rule_Half_Hou, FromRecoveryKey = 580211758000.0 and ToRecoveryKey = 580211758000.0
14:05:35 Trace: No MATCHING entry for table t_Campaign_Query_Rule_Interval, FromRecoveryKey = 580211758000.0 and ToRecoveryKey = 580211758000.0
14:05:35 Trace: No MATCHING entry for table t_Route_Call_Detail, FromRecoveryKey = 580211865072.0 and ToRecoveryKey = 580211840829.0
14:05:35 Trace: No MATCHING entry for table t_Termination_Call_Variable, FromRecoveryKey = 580212909012.0 and ToRecoveryKey = 580212654177.0
14:05:37 Trace: No MATCHING entry for table t_Dialer_Detail, FromRecoveryKey = 580211758000.0 and ToRecoveryKey = 580211758000.0
14:05:38 Trace: No MATCHING entry for table t_Route_Call_Variable, FromRecoveryKey = 580212332230.0 and ToRecoveryKey = 580212208664.0
14:05:39 Trace: No MATCHING entry for table t_Dialer_Half_Hour, FromRecoveryKey = 580211758000.0 and ToRecoveryKey = 580211758000.0
14:05:41 Trace: No MATCHING entry for table t_Dialer_Interval, FromRecoveryKey = 580211758000.0 and ToRecoveryKey = 580211758000.0
14:05:43 Trace: No MATCHING entry for table t_Dialer_Skill_Group_Half_Hour, FromRecoveryKey = 580211758000.0 and ToRecoveryKey = 580211758000.0
14:05:44 Trace: No MATCHING entry for table t_Termination_Call_Detail, FromRecoveryKey = 580212060567.0 and ToRecoveryKey = 580211991844.0
14:05:47 Trace: No MATCHING entry for table t_Galaxy_Agent_Call_Count, FromRecoveryKey = 580211758000.0 and ToRecoveryKey = 580211758000.0
14:05:49 Trace: No MATCHING entry for table t_Galaxy_Agent_IGroup, FromRecoveryKey = 580211758000.0 and ToRecoveryKey = 580211758000.0
14:05:51 Trace: No MATCHING entry for table t_Galaxy_Agent_Performance, FromRecoveryKey = 580211758000.0 and ToRecoveryKey = 580211758000.0
14:05:52 Trace: No MATCHING entry for table t_Route_Call_Detail, FromRecoveryKey = 580211865072.0 and ToRecoveryKey = 580211840829.0
14:05:52 Trace: No MATCHING entry for table t_Termination_Call_Variable, FromRecoveryKey = 580212909012.0 and ToRecoveryKey = 580212654177.0
14:05:53 Trace: No MATCHING entry for table t_Galaxy_Alarm, FromRecoveryKey = 580211758000.0 and ToRecoveryKey = 580211758000.0
14:05:55 Trace: No MATCHING entry for table t_Galaxy_DNIS, FromRecoveryKey = 580211758000.0 and ToRecoveryKey = 580211758000.0
14:05:55 Trace: No MATCHING entry for table t_Route_Call_Variable, FromRecoveryKey = 580212332230.0 and ToRecoveryKey = 580212208664.0
14:05:57 Trace: No MATCHING entry for table t_Galaxy_Gate, FromRecoveryKey = 580211758000.0 and ToRecoveryKey = 580211758000.0
14:05:59 Trace: No MATCHING entry for table t_Galaxy_Gate_Delayed_Call, FromRecoveryKey = 580211758000.0 and ToRecoveryKey = 580211758000.0
14:06:01 Trace: No MATCHING entry for table t_Termination_Call_Detail, FromRecoveryKey = 580212060567.0 and ToRecoveryKey = 580211991844.0
14:06:01 Trace: No MATCHING entry for table t_Galaxy_Overflow, FromRecoveryKey = 580211758000.0 and ToRecoveryKey = 580211758000.0
14:06:03 Trace: No MATCHING entry for table t_Galaxy_PBX, FromRecoveryKey = 580211758000.0 and ToRecoveryKey = 580211758000.0
14:06:05 Trace: No MATCHING entry for table t_Galaxy_Single_Trunk, FromRecoveryKey = 580211758000.0 and ToRecoveryKey = 580211758000.0
14:06:07 Trace: No MATCHING entry for table t_Galaxy_Transaction_Code, FromRecoveryKey = 580211758000.0 and ToRecoveryKey = 580211758000.0

sideB rogger replication

21:58:51 Trace: Read Replication Client from site net16cc-awhdsB1 and HDS Type 1
21:58:51 Trace: Sending Replication Server Ack message to site net16cc-awhdsB1
21:58:51 Trace: Successfully registered Replication Client from site net16cc-awhdsB1 and HDS Type 1
21:58:51 Connected To Client system net16cc-awhdsb1 on port 41026.
21:58:51 Trace: Read Replication Client from site net16cc-awhdsB1 and HDS Type 1
21:58:51 Trace: Sending Replication Server Ack message to site net16cc-awhdsB1
21:58:51 Trace: Successfully registered Replication Client from site net16cc-awhdsB1 and HDS Type 1
21:58:53 Connected To Client system net16cc-awhdsb1 on port 41026.
21:58:53 Trace: Read Replication Client from site net16cc-awhdsB1 and HDS Type 1
21:58:53 Trace: Sending Replication Server Ack message to site net16cc-awhdsB1
21:58:53 Trace: Successfully registered Replication Client from site net16cc-awhdsB1 and HDS Type 1
21:59:02 Connected To Client system net16cc-awhdsb1 on port 41028.
21:59:02 Connection to MDS process established.
21:59:02 Trace: Replication is registered with MDS; handle = 129
22:23:17 Connection to MDS process has failed.
  Last EMT Error [-519897069]: The remote process has exited.
22:23:20 Connection to MDS process established.
22:23:20 Reconnection to MDS process completed successfully.
18:47:48 Connection to MDS process has failed.
  Last EMT Error [-519897069]: The remote process has exited.
18:47:51 Connection to MDS process established.
18:47:51 Reconnection to MDS process completed successfully.


John

More information about the cisco-nsp mailing list