DA Synchronization failure

Products

• Network Observability

Issue/Introduction

DA Synchronization failure when checked System status 

 

Environment

23.x, 24.x

Cause

SpeedINOverride and SpeedOutOverride values are incorrect

 

Multiple causes

Cause 1:
For some item ids IfSpeedIn / Out values are shown as NaN

DMService.log
(5,17448928,'physical','1234567','xe-1','xe-1/',593,2,'ethernet(6)',NaN,NaN,..................................)

nested exception is java.sql.SQLSyntaxErrorException: Unknown column 'NaN' in 'field list'

 

Cause 2:
For some item ids IfSpeedIn / Out  values are huge number 1.0E28, 29, 30, 27,'2.0E25','2.0E20'

wrapper.log

INFO | jvm 1 | 2025/04/17 23:29:04 | (5,173839400,'physical',1234567,,'xe-1','xe-1',123,8474,'vlan',2.0E20,2.0E20,' ','Active')

Error caused by com.mysql.cj.jdbc.exceptions.MysqlDataTruncation: Data truncation: Out of range value for column 'IfSpeedIn'

 

The range for signed BIGINT is from -9,223,372,036,854,775,808 to 9,223,372,036,854,775,807

Supported range

9,223,372,036,854,775,807
==
9.2E18

Any thing higher than E18 can cause DA Sync Failure issue

Resolution

We need to clean the incorrect SpeedInOverrides and SpeedOutOverrides

Note down the item id from the error

DMService.log
(5,17448928,'physical','1234567','xe-1','xe-1/',593,2,'ethernet(6)',NaN,NaN,..................................)

Run below curl command to clean

curl  -kv -u<username> --header "Content-Type: application/xml" --request PUT --data '<Port version="1.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"><SpeedInOverride xsi:nil="true"></SpeedInOverride><SpeedOutOverride xsi:nil="true"></SpeedOutOverride></Port>' --url http://proxy:8581/rest/ports/1234567

Highlighted parts need to be replaced with actual values from environment

Now overrides will be cleaned and values move to defaults

<Port version="1.0.0">

<ID>1234567<ID>

<MACAddress> </MACAddress>

<SpeedIn>1.0E10</SpeedIn>

<AdminStatus>1</AdminStatus>

<SpeedOut>1.0E10</SpeedOut>

 

To find out multiple entries you can run below curl command

Ran below query to find NaN entries

curl -kv --header "Content-Type: application/xml" -u <username> --request POST --data '<FilterSelect xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="filter.xsd"><Filter><Or><Port.SpeedInOverride type="EQUAL">NaN</Port.SpeedInOverride><Port.SpeedOutOverride type="EQUAL">NaN</Port.SpeedOutOverride></Or></Filter><Select use="exclude" isa="exclude"></Select></FilterSelect>' --url http://proxy:8581/rest/ports/filtered | xmllint --format - > /tmp/items.log

 

Cat /tmp/items.log will have entries as below

<?xml version="1.0"?>

<PortList>

<Port version="1.0.0">

<ID>1234567<ID>

</port>

<Port version="1.0.0">

<ID>2345678<ID>

</port>

<Port version="1.0.0">

<ID>3456789<ID>

</port>

</PortList>

Now run curl command for each ID

curl  -kv -u<username> --header "Content-Type: application/xml" --request PUT --data '<Port version="1.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"><SpeedInOverride xsi:nil="true"></SpeedInOverride><SpeedOutOverride xsi:nil="true"></SpeedOutOverride></Port>' --url http://proxy:8581/rest/ports/ID

Now go to Datasources and resync DA datasource.