Error in the tomcat log on the Spectrum Report Manager (SRM) system

Products

• Network Observability
• Spectrum

Issue/Introduction

The following error is see in the $SPECROOT/tomcat/logs/stdout.log (Windows) or catalina.out (Linux):

Feb 24, 2023 20:09:59.469 (Thread-78) (AssetManagerLogging) - (ERROR) - addDeviceModel() 
Caused by: java.lang.NumberFormatException: For input string: "3284370383"
    at java.lang.NumberFormatException.forInputString(NumberFormatException.java:65)
    at java.lang.Integer.parseInt(Integer.java:583)
    at java.lang.Integer.<init>(Integer.java:867)
    at com.aprisma.spectrum.app.repmgr.dc.asset.AssetManager.getEnterprise(AssetManager.java:1451)
    at com.aprisma.spectrum.app.repmgr.dc.asset.AssetManager.addDeviceModel(AssetManager.java:569)
    at com.aprisma.spectrum.app.repmgr.dc.asset.DeviceManager$SingleDeviceRead.run(DeviceManager.java:88)
    at com.aprisma.spectrum.app.repmgr.dc.asset.DeviceManager$DeviceThreads.run(DeviceManager.java:131)

Environment

Release : Any
Component: Spectrum Report Manager (SRM)

Cause

The value of the sysObjectID for some devices contain a value to large for a Java Integer datatype which is 32 bits with a range of -2147483648 to 2147483647.

In the error highlighted above, the value "3284370383" is to large for a Java Integer datatype.

Due to this exception, SRM will fail to Insert the devicemodel record into the devicemodel tables of the reporting database for these models in the Spectrum database.

Resolution

This is a limitation of Java and not Spectrum Report Manager.

Additional Information

The sysObjectID attribute on the device is read only ad cannot be changed by the user.

Verify with the vendor the value of the sysObjectID for these devices are correct.