When you are running a SAS Real-Time Decision Manager campaign, you might notice a failure message from the SOAP envelope, such as the following:

<SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/"><SOAP-ENV:Header/>
<SOAP-ENV:Body><SOAP-ENV:Fault><faultcode>SOAP-ENV:Server</faultcode><faultstring xml:lang="en">
   org.apache.commons.dbcp.SQLNestedException: Borrow callableStatement from pool failed</faultstring>
</SOAP-ENV:Fault></SOAP-ENV:Body></SOAP-ENV:Envelope> 

The following error appears in the Federation Server directory\server1\var\log\dfs_*.log file.

Access Violation occurred during PREPARE at TKETSQLGenExpression+0x6c4:

2016-02-16T10:53:27,066 ERROR [00088635] App.Program 156:sasdmadm
-/opt/sas/sashome/SASFederationServer/4.1/fedserver/lib/tkepre.so(tktracex+0x2e)
[0x7fc30402b21e]

For example, when an outer query does not contain a table reference (such as in a FROM clause), but a subquery does (such as in a SELECT list), the problem occurs. The SAS Federated Query Language (FedSQL) incorrectly handles this situation by requiring that the column variable be initialized, which causes an invalid pointer.

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 Federation Server 4.2 is available at:

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