UCCE Live Data

Create an SQL user cuicuser and give read access to aw, hds and master database. Then using admin sql execute the below on each HDS Server.

USE master
GO
GRANT CONTROL ON CERTIFICATE :: UCCESymmetricKeyCertificate TO "cuicuser"
GRANT VIEW DEFINITION ON SYMMETRIC KEY :: UCCESymmetricKey TO "cuicuser"

Configured Live Data with AW

admin:set live-data aw-access primary 123.123.123.123 1433 ucce_awdb cuicuser <Password>

Primary AW access information:

 address          | port | db_name   | user
------------------+------+-----------+----------
 123.123.123.123  | 1433 | ucce_awdb | cuicuser

Test: Succeeded
Executed command successfully

Configure Live Data Machine Services

Use the user@domain format to specify the AW database domain user with write-access permission. The domain is a fully qualified domain name (FQDN), and the username is a user principal name. You must be authorized to change Unified CCE configuration.

Command: set live-data machine-services awdb-user awdb-pwd

admin:set live-data machine-services admin@purplepi.ie <password>

Warning: failed to retrieve Subscriber FQDN
  ad.ucce-dev.mydomain.pri: side A
        | ACTIVE_MQ               | 61616 |                                  |
        | STORM_DRPC              |  3772 |                                  |
        | LIVE_DATA_WEB_SOCKETS   | 12008 |                                  |
        | LIVE_DATA_API           | 12005 | livedata                         |
        | LIVE_DATA_CASSANDRA     | 12000 |                                  |
  UNKNOWN: side B
        | ACTIVE_MQ               | 61616 |                                  |
        | STORM_DRPC              |  3772 |                                  |
        | LIVE_DATA_WEB_SOCKETS   | 12008 |                                  |
        | LIVE_DATA_API           | 12005 | livedata                         |
        | LIVE_DATA_CASSANDRA     | 12000 |                                  |
admin:

CUIC Datasource

set live-data cuic-datasource cuic-addr cuic-port cuic-user cuic-pwd

set live-data cuic-datasource 123.123.123.123 8444 CUIC\admin <password>

Warning: Live Data Side B is not configured.  Failover will be disabled.

Id: AF4627EF1000015B0000015E0A18230C
Name: Live Data Streaming Data Source
Type: Streaming
Time Zone: UTC
Side A:
   CCE Live Data Service host: ad.mydomain.pri
   CCE Live Data Web Service port: 12005
   CCE Live Data Socket.IO Service port: 12008
   CCE Live Data Schema URL: livedata/livedataSchema.xml
   CCE Live Data Token Service URL: livedata/token/new
   Credentials not displayed
admin:

Import Reports

For LiveData reports, the Data Source for ReportDefinition is LiveData Streaming and the Data Source for ValueList is UCCE Realtime

Logs

file get activelog livedata/logs/*/*
file list activelog livedata/logs/livedata-storm/*
file tail activelog livedata/logs/livedata-storm/worker-6702.log
file tail activelog livedata/logs/livedata-storm/nimbus.log