Layer 7 CA API Gateway - query did not return a unique result errror
search cancel

Layer 7 CA API Gateway - query did not return a unique result errror

book

Article ID: 192257

calendar_today

Updated On:

Products

CA API Developer Portal CA API Gateway CA Mobile API Gateway Layer7 API Security

Issue/Introduction

The following error may be seen:

2020-06-02T16:14:21.176+0300 WARNING 1 com.l7tech.server.boot.GatewayMain: Error starting server : Lifecycle error: Could not initialize Hazelcast cluster
com.l7tech.server.LifecycleException: Lifecycle error: Could not initialize Hazelcast cluster
        at com.l7tech.server.LifecycleExtensionComponent.start(Unknown Source)
      
        at com.l7tech.server.boot.GatewayMain.main(Unknown Source)
Caused by: com.ca.apim.gateway.extension.lifecycle.LifecycleException: Could not initialize Hazelcast cluster
        at com.l7tech.external.assertions.hazelcastembeddedprovider.server.a.start(Unknown Source)
        ... 6 more
Caused by: org.springframework.dao.IncorrectResultSizeDataAccessException: query did not return a unique result: 2
        at org.springframework.orm.hibernate3.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:669)
        at org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:412)
   

**** Unable to start the server: Error starting server : Lifecycle error: Could not initialize Hazelcast cluster

Environment

Release : All Releases

Component : Layer 7 CA API GATEWAY

Resolution

This may be caused by a duplicate firewall rule in the database for the Hazelcast port 8777 causing the error :

Caused by: org.springframework.dao.IncorrectResultSizeDataAccessException: query did not return a unique result: 2

To check this open  Policy Manager, access the Listen Ports and select firewall rules

Check if there is a duplicate entry for port 8777 

If this is the case remove one of them .

After that try restart the SSG service and the error message should be addressed.