When you are using SAS Real-Time Decision Manager, you might notice reduced performance as well as duplicate warning messages or diagnostic messages in the SAS Federation Server logs.

This problem occurs because the JDBC driver does not clear the SQL warnings that are attached to each statement prior to execution. As a result, the duplicate warnings occur, gradually increasing memory usage and affecting performance.

A temporary workaround is to increase the JVM (Java Virtual Machine) heap size, but this is only a short-term fix.

Click the Hot Fix tab in this note to access the hot fix for this issue.

Operating System and Release Information

A fix for this issue for SAS Decision Services 6.4_M1 is available at:

A fix for this issue for SAS Drivers for Federation Server 4.2 is available at:

A fix for this issue for SAS Management Console 9.4_M3 is available at:

A fix for this issue for SAS Middle Tier 9.4_M3 is available at: