VNA Fortinet Plugin not discovering many items and showing thousands of errors in DX NetOps 23.3.x
search cancel

VNA Fortinet Plugin not discovering many items and showing thousands of errors in DX NetOps 23.3.x

book

Article ID: 281468

calendar_today

Updated On:

Products

Network Observability Virtual Network Assurance CA Performance Management

Issue/Introduction

VNA FortiGate plugin is correctly configured in CAPM:

Some tunnels and SLA paths are shown, but the vast majority are not discovered. Checking the VNA wildfly logs shows an enormous number of differing errors.  In the gateway.log:

 

2024-03-14 11:31:50,288 ERROR (Camel (Fortinet Plugin-23.3.3-RELEASE) thread #73 - vm://global/plugin/fortinet/PERFORMANCE)  [PLUGIN_SYSTEM] CamelLogger 205  Failed delivery for (MessageId: queue_PerformanceUpdateQueue_ID_79d400ea-e189-11ee-b0e3-005056bc09c7 on ExchangeId: D1B1644F252DA40-00000000000001B2). Exhausted after delivery attempt: 1 caught: org.hibernate.exception.DataException: Could not extract column [7] from JDBC ResultSet [Cannot determine value type from string 'HAS_POLICY'] [n/a]
Message History (source location and message history is disabled)

---------------------------------------------------------------------------------------------------------------------------------------

Source                                   ID                             Processor                                          Elapsed (ms)

                                         plugin/fortinet/PERFORMANCE:90 from[vm://global/plugin/fortinet/PERFORMANCE?failI   1197955030

        ...

                                         plugin/fortinet/PERFORMANCE:90 null                                                          0

 

Stacktrace

---------------------------------------------------------------------------------------------------------------------------------------: org.hibernate.exception.DataException: Could not extract column [7] from JDBC Result

Set [Cannot determine value type from string 'HAS_POLICY'] [n/a]
        at [email protected]//org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:53)...
...
Caused by: com.mysql.cj.exceptions.DataConversionException: Cannot determine value type from string 'HAS_POLICY'

Then in the server log;

2024-03-12 21:15:01,486 WARN  [org.apache.activemq.artemis.utils.actors.OrderedExecutor] (Thread-12654 (ActiveMQ-server-org.apache.activemq.artemis.core.server.impl.ActiveMQServerImpl$6@4c8ee0a0)) Java heap space: java.lang.OutOfMemoryError: Java heap space
2024-03-12 21:15:01,486 ERROR [org.jboss.as.controller.management-operation] (Publish_Task) WFLYCTL0013: Operation ("read-resource-description") failed - address: ([
    ("subsystem" => "messaging-activemq"),
    ("server" => "default"),
    ("jms-queue" => "InventoryUpdateQueue")
]): java.lang.OutOfMemoryError: Java heap space
2024-03-12 21:15:01,488 ERROR [stderr] (Periodic Recovery) Exception in thread "Periodic Recovery" java.lang.OutOfMemoryError: Java heap space: failed reallocation of scalar replaced objects

 

And

2024-03-13 20:36:11,369 WARN  [org.apache.camel.component.vm.VmConsumer] (Camel (Fortinet Plugin-23.3.3-RELEASE) thread #73 - vm://global/plugin/fortinet/PERFORMANCE) Error processing exchange. Exchange[]. Caused by: [org.infinispan.persistence.spi.PersistenceException - SQL error while fetching stored entry with key: {"cacheKeyId":null,"cacheKeyType":"TUNNEL","keyString":"1Tunnel-01"}, lockingKey: {"cacheKeyId":null,"cacheKeyType":"TUNNEL","keyString":"1Tunnel-01"}]: org.infinispan.persistence.spi.PersistenceException: SQL error while fetching stored entry with key: {"cacheKeyId":null,"cacheKeyType":"TUNNEL","keyString":"1Tunnel-01"}, lockingKey: {"cacheKeyId":null,"cacheKeyType":"TUNNEL","keyString":"1Tunnel-01"}
        at deployment.core-23.3.3-RELEASE.war//org.infinispan.persistence.jdbc.common.impl.BaseJdbcStore.lambda$load$3(BaseJdbcStore.java:131)
        at java.base/java.util.concurrent.CompletableFuture$AsyncSupply.run(CompletableFuture.java:1768)
        ... 1 more
Caused by: java.sql.SQLException: Not a navigable ResultSet.
        at [email protected]//com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:130)
        ... 6 more

Environment

DX NetOps Virtual Network Assurance (VNA) 23.3.5,6

Cause

Issue is due to code changes resulting in incorrect device handling. 

Resolution

This defect will be fixed in the next release - 23.3.9.

Additional Information

DE595319