Fail To Install Remote Cache Assertion

Products

• CA API Gateway

Issue/Introduction

Trying to install the RemoteCacheAssertion-1.5.0.saar file via policy manager fails with the following error:

Error while uploading Server Module:

Could not deserialize result from HTTP invoker remote service [https://securespangateway/ssg/manager/ClusterStatusAdmin]; nested exception is java.lang.classnotfoundexception: com.mysql.cj.jdbc.exceptions.packettoobigexception

We had already updated the following cluster wide property to 50 MB but the problem persists:

serverModuleFile.upload.maxSize = 52428800

Environment

CA API Gateway 10.1

Cause

When a MySQL client or the mysqld server receives a packet bigger than max_allowed_packet bytes, it issues an ER_NET_PACKET_TOO_LARGE error and closes the connection.

Resolution

We updated the following setting within the /etc/my.cnf file accordingly:

max_allowed_packet=100M

We then restarted mysql and attempted to upload the RemoteCacheAssertionxxx.saar file again and it was now successful.

We then reverted the change and set the max_allowed_packet value back to it's original value and restarted mysql once again so the original value would take place once again.