No Telemetry data.
Article ID: 381981
Updated On:
Products
Issue/Introduction
All configuration looks fine but we do not get the data;
"no telemetry data available"
Environment
Any supported Dx NetOps Performance Management
Cause
There are few possibilities including a defect;
See below.
Resolution
1. Make sure the 'Company Domain' parameter does not contain spaces
2. Test telemetry sources manually:
We should see if you can reach the following endpoints from Portal to Spectrum and Data Aggregator (VNA should be included in below responses)
curl -skv -u <specUser> https://<OCHostName>:443/spectrum/restful/telemetry/usageTelemetry
curl -skv -u <DAUser> https://<DAHostName>:8582/genericWS/usagetelemetry
3. Did you wait at least 24h ?
Data is collected every 24h starting after the Portal start/restart.
Restart Portal to trigger a collection if needed.
Additional Information
There is a defect DE155803 that breaks Telemetry if the Tenant name contains an apostrophe ' and the symptom is the following event:
INFO | jvm 1 | 2024/10/28 02:08:11 | ERROR | Inventory Usage Data Service Scheduler-1 | 2024-10-28 02:08:11,705 | org.springframework.scheduling.support.TaskUtils$LoggingErrorHandler
INFO | jvm 1 | 2024/10/28 02:08:11 | | Unexpected error occurred in scheduled task
INFO | jvm 1 | 2024/10/28 02:08:11 | org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [REPLACE INTO telemetry_inventory (SourceID, TenantName, ItemType, ItemCount, Resolution, MaxPortCount, SourceTimestamp, LoadTime, LoadYear, LoadQuarter, LoadMonth, LoadWeek, LoadDayOfMonth, LoadDayOfYear )VALUES( 4, 'xxxxxxxx's', 'Standard Device:200' , 23, 86400, 200, 1730073600, 1730081291, YEAR(FROM_UNIXTIME(1730081291)), QUARTER(FROM_UNIXTIME(1730081291)), MONTH(FROM_UNIXTIME(1730081291)), WEEK(FROM_UNIXTIME(1730081291)), DAYOFMONTH(FROM_UNIXTIME(1730081291)), DAYOFYEAR(FROM_UNIXTIME(1730081291)) ); REPLACE INTO telemetry_inventory (SourceID, TenantName, ItemType, ItemCount, Resolution, MaxPortCount, SourceTimestamp, LoadTime, LoadYear, LoadQuarter, LoadMonth, LoadWeek, LoadDayOfMonth, LoadDayOfYear )VALUES( 4, 'zzzzzzzz's', 'Standard Device:200' , 1, 86400, 200, 1730073600, 1730081291, YEAR(FROM_UNIXTIME(1730081291)), QUARTER(FROM_UNIXTIME(1730081291)), MONTH(FROM_UNIXTIME(1730081291)), WEEK(FROM_UNIXTIME(1730081291)), DAYOFMONTH(FROM_UNIXTIME(1730081291)), DAYOFYEAR(FROM_UNIXTIME(1730081291)) ); REPLACE INTO telemetry_inventory (SourceID, TenantName, ItemType, ItemCount, Resolution, MaxPortCount, SourceTimestamp, LoadTime, LoadYear, LoadQuarter, LoadMonth, LoadWeek, LoadDayOfMonth, LoadDayOfYear )VALUES( 4, 'xxxxxxxx's', 'Standard Device:200' , 9, 86400, 200, 1730073600, 1730081291, YEAR(FROM_UNIXTIME(1730081291)), QUARTER(FROM_UNIXTIME(1730081291)), MONTH(FROM_UNIXTIME(1730081291)), WEEK(FROM_UNIXTIME(1730081291)), DAYOFMONTH(FROM_UNIXTIME(1730081291)), DAYOFYEAR(FROM_UNIXTIME(1730081291)) ); REPLACE INTO telemetry_inventory (SourceID, TenantName, ItemType, ItemCount, Resolution, MaxPortCount, SourceTimestamp, LoadTime, LoadYear, LoadQuarter, LoadMonth, LoadWeek, LoadDayOfMonth, LoadDayOfYear )VALUES( 4, 'yyyyyyyyyyy's', 'Standard Device:200' , 1611, 86400, 200, 1730073600, 1730081291, YEAR(FROM_UNIXTIME(1730081291)), QUARTER(FROM_UNIXTIME(1730081291)), MONTH(FROM_UNIXTIME(1730081291)), WEEK(FROM_UNIXTIME(1730081291)), DAYOFMONTH(FROM_UNIXTIME(1730081291)), DAYOFYEAR(FROM_UNIXTIME(1730081291)) )]; nested exception is java.sql.BatchUpdateException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's', 'Standard Device:200' , 1611, 86400, 200, 1730073600, 1730081291, YEAR(FROM_' at line 1
Feedback
