Overview of the Issue

This issue occurs in the following circumstances:

1. An organization installs the vFunction Agent on a Java Application
2. The vFunction Agent’s $BASE_DIRECTORY/vfunction/var/log/vfunction/instances/$INSTANCE_NAME/vfagent.log.dbtracking throws the following warning:

2024-08-29 17:36:46 sql-parsing-thread-2 WARN  SqlParsingService - SQL cache exceeded, consider increasing max size from 5000 

Steps to Resolve the Issue

This issue can be resolved by taking the following steps:

1. SSH to the Linux VM where the Java Application is running
2. Open the $BASE_DIRECTORY/vfunction/etc/sysconfig/vfunction/installation/instances/$INSTANCE_NAME/installation.yaml
3. Under the Agent key, add a new string to the override_properties subkey which increases the SQL Cache Max Size:

agent:
  override_properties:
    - com.vfunction.jdbc.tracking.SqlParsingService.parsedCacheSize=10000

4. Save the changes and run the vFunction upgrade script:

bash $BASE_DIRECTORY/vfunction/opt/vfunction/controller-installation/upgrade.sh -i $INSTANCE_NAME

5. Restart the Application