DA showing synch failure on portal

Products

• Network Observability
• CA Performance Management

Issue/Introduction

You are seeing the DA failing to synch.

DA is up and responsive to rest.

Cause

• In DMService.log you see:
  

  ERROR | pool-4-thread-3          | 2024-02-21 21:15:48,787 | com.ca.im.portal.dm.productsync.DataSourcePoller                

  CAPC encountered an error while trying to sync with data source Data Aggregator@DA-NAME.  The problem is in CAPC, not the data source.  The following stack trace shows the invalid SQL statement in CAPC:

  org.springframework.dao.DataIntegrityViolationException: PreparedStatementCallback; SQL [INSERT INTO dst_interface (SourceID, UpdatedOn, `ItemSubTypeName`, `LocalID`, `ItemName`, `ItemDesc`, `IfIndex`, `DomainID`, `IfType`, `IfSpeedIn`, `IfSpeedOut`, `IfAlias`, `LifeCycleState`, `LifeCycleStateLastChangedOn`, `Polling`, `custp_User_AssetOrganization`, `custp_User_AssetTag`, `custp_User_AssetDescription`, `custp_User_AssetID`, `custp_User_AssetOwner`) VALUES (5,#####,'physical','66987','em1','em1',23,2,'ethernetCsmacd (6)',1.0E9,1.0E9,'','ACTIVE',######,'Enabled',NULL,NULL,NULL,NULL,NULL),

  …

  Caused by: com.mysql.cj.jdbc.exceptions.MysqlDataTruncation: Data truncation: Out of range value for column 'IfSpeedIn' at row 3145

• And, you find that someone has set an Interface override speed of 1.0E19 (that’s 19 0’s)

  Docketing n Alarm Notification n Performance','#######OK','INTERFACE-NAME'),

  (5,#######,'physical','1117854','ae14','ae14',817,2,'ieee8023adLag (161)',1.0E19,1.0E19,example~Apr21~##### #####-#######','ACTIVE',1##########,'Enabled','######','Retired','NO-Auto Docketing n Alarm Notification in Performance','example','ALIAS'),

Resolution

1. Check the speed in the DA rest:
   http://daproxy:8581/rest/ports/1117854
   

   …………………..

   <Port version="1.0.0">

   <SpeedIn>1.0E10</SpeedIn>

   <SpeedOut>1.0E10</SpeedOut>

   <SpeedOutOverride>1.0E19</SpeedOutOverride>

   <SpeedInOverride>1.0E19</SpeedInOverride>

   </Port>

   …………………………..

2. Use curl on the DA to PUT the correct value:
   
   curl -kv -u admin:admin -H 'Content-type: application/xml' -X PUT -d '<Port version="1.0.0"><SpeedOutOverride>1.0E10</SpeedOutOverride><SpeedInOverride>1.0E10</SpeedInOverride></Port>'http://DAPROXY:8581/rest/ports/1117854

   1. REPLACE admin:admin with your admin portal user.

   2. Leave off password for prompt.

   3. REPLACE DAPROXY with your DA or proxy.

3. Check the above end-point to confirm the new values.