Remote Cache Tacical assertion to large to be loaded in policy manager

Products

• CA API Gateway

Issue/Introduction

I requested and received the latest version of the remote cache tacical assertion.

However this assertion is over 40MB in size which leads to various problems:

-while uploading this as a server module file, the following error appears:

"Unable to open module file: Files greater than 20.0 MB are not supported."

I could fix this by increasing the size of the cluster-wide property: serverModuleFile.upload.maxSize

-However hereafter I get the following error: 

"java.sql.BatchUpdateException :Packet for query is too large"

Environment

Release : 10.0

Component : API GATEWAY

Resolution

You first have to set the serverModuleFile.upload.maxSize cwp  to a value which is larger as the tactical assertion file size to be able to load it.

The second error is raised by MySQL, you have to increase the allowed max packet size within the /etc/my.cnf file.

max_allowed_packet=32M

Increase it to 48M 

restart mysql and ssg .