API Keys Not Syncing to one proxy
search cancel

API Keys Not Syncing to one proxy

book

Article ID: 260870

calendar_today

Updated On:

Products

CA API Developer Portal

Issue/Introduction

API Keys are not syncing to one of our proxies. It was previously working, but no longer.

The error seen on the Portal side is this:

<?xml version="1.0" encoding="UTF-8"?>
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/">
    <soapenv:Body>
        <soapenv:Fault>
            <faultcode>soapenv:Server</faultcode>
            <faultstring>Error in assertion processing</faultstring>
            <faultactor>https://localhost:8443/portalman/api-keys/storage</faultactor>
            <detail>
                <l7:policyResult
                    status="No row with the given identifier exists: [com.l7tech.gateway.common.jdbc.JdbcConnection#c40919968001c89330826af5eec134b2]; nested exception is org.hibernate.ObjectNotFoundException: No row with the given identifier exists: [com.l7tech.gateway.common.jdbc.JdbcConnection#c40919968001c89330826af5eec134b2]"
                    xmlns:l7="http://www.layer7tech.com/ws/policy/fault" />
            </detail>
        </soapenv:Fault>
    </soapenv:Body>
</soapenv:Envelope>

Environment

Release : 5.1

Cause

Portal API not in sync with one of the proxy gateway’s

2023-02-21T13:42:42.585-0800 WARNING 1572 com.l7tech.server.policy.assertion.composite.ServerTransactionAssertion: ssguid="0000018637fa1dc1-21a742": 9108: Assertion failed due to JDBC connection error: connection name "OAuth": Transaction failed: No row with the given identifier exists: [com.l7tech.gateway.common.jdbc.JdbcConnection#c40919968001c89330826af5eec134b2]; nested exception is org.hibernate.ObjectNotFoundException: No row with the given identifier exists: [com.l7tech.gateway.common.jdbc.JdbcConnection#c40919968001c89330826af5eec134b2]

023-02-21T13:42:42.584-0800 SEVERE  1572 com.l7tech.server.SoapMessageProcessingServlet: No row with the given identifier exists: [com.l7tech.gateway.common.jdbc.JdbcConnection#c40919968001c89330826af5eec134b2]; nested exception is org.hibernate.ObjectNotFoundException: No row with the given identifier exists: [com.l7tech.gateway.common.jdbc.JdbcConnection#c40919968001c89330826af5eec134b2]

org.springframework.orm.hibernate3.HibernateObjectRetrievalFailureException: No row with the given identifier exists: [com.l7tech.gateway.common.jdbc.JdbcConnection#c40919968001c89330826af5eec134b2]; nested exception is org.hibernate.ObjectNotFoundException: No row with the given identifier exists: [com.l7tech.gateway.common.jdbc.JdbcConnection#c40919968001c89330826af5eec134b2]

at org.springframework.orm.hibernate3.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:663)

at org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:412)

at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:411)

at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:339)

 

Resolution

This issue was the gateway connection to the mysql database for Oauth.  After restart and verify JDBC connection the API keys synced up