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>
Release : 5.1
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)
This issue was the gateway connection to the mysql database for Oauth. After restart and verify JDBC connection the API keys synced up