Problem Note 53115: SAS® Content Server fails and generates the error message "java.sql.SQLException: Unable to create IStatement handle"
When you have a SAS® 9.2 Content Server clustered environment with an IBM WebSphere application–server configuration, the SAS Content Server periodic journal synchronization fails with the following errors:
[06/06/12 00:44:30:272 BST] 0000007a SystemOut O 2012-06-06 00:44:30,272[ClusterNode-SASG01WIP] ERROR org.apache.jackrabbit.core.util.db.ConnectionHelper - Failed to execute SQL (stacktrace on DEBUG log level)
java.sql.SQLException: Unable to create IStatement handle.
[06/06/12 00:44:32:042 BST] 0000007a SystemOut O 2012-06-06 00:44:32,042[ClusterNode-SASG01WIP] ERROR org.apache.jackrabbit.core.cluster.ClusterNode - Periodic sync of journal failed: Unable to return record iterator.
org.apache.jackrabbit.core.cluster.ClusterException: Unable to return record iterator.
at org.apache.jackrabbit.core.cluster.ClusterNode.sync(ClusterNode.java:305)
at org.apache.jackrabbit.core.cluster.ClusterNode.run(ClusterNode.java:274)
at java.lang.Thread.run(Thread.java:811)
Caused by:
java.sql.SQLException: Unable to create IStatement handle.
The failure occurs for the secondary WebSphere Java virtual machine (JVM) cluster instances of SASServer2 and SASServer 3.
To solve this problem, follow the steps below. (Note: This solution only applies to a situation with a SAS Content Server clustered environment that has a WebSphere application–server configuration.
- Navigate to the SAS-configuration-directory\Lev1\AppData\SASContentServer\appserver–instance\ folder. In this path, appserver–instance specifies the specific server instance (for example, SASServer1)
- Verify that the AppServer_Instance folder name is same as the actual ID name for the WebSphere application–server JVM instance. If the names match, continue to the next step. If the names do not match, rename the folder so that it is the same as the application-server instance ID name.
- Locate the following line in repository.xml file that resides in SAS-configuration-directory\Lev1\AppData\SASContentServer\AppServer_Instance2\:
Cluster id="appserver-instance1"
- Change the value to the correct application–server instance, as shown in this example:
Cluster id="appserver–instance2"
- Locate the following Java start-up command for the Websphere server node:
-Dsas.appserver.instance.id=appserver–instance1
In this command, appserver-instance1 indicates the primary application–server instance.
- Change the value for the Java command to the following:
-Dsas.appserver.instance.id=appserver–instance2
In this command, appserver-instance1 specifies the secondary application–server instance.
- Restart your WebSphere SASServer JVMs.
Operating System and Release Information
| SAS System | SAS Enterprise BI Server | Microsoft® Windows® for 64-Bit Itanium-based Systems | 4.2 | | 9.2 TS2M0 | |
| Microsoft Windows Server 2003 Datacenter 64-bit Edition | 4.2 | | 9.2 TS2M0 | |
| Microsoft Windows Server 2003 Enterprise 64-bit Edition | 4.2 | | 9.2 TS2M0 | |
| Microsoft Windows XP 64-bit Edition | 4.2 | | 9.2 TS2M0 | |
| Microsoft® Windows® for x64 | 4.2 | | 9.2 TS2M0 | |
| Microsoft Windows Server 2003 Datacenter Edition | 4.2 | | 9.2 TS2M0 | |
| Microsoft Windows Server 2003 Enterprise Edition | 4.2 | | 9.2 TS2M0 | |
| Microsoft Windows Server 2003 Standard Edition | 4.2 | | 9.2 TS2M0 | |
| Microsoft Windows Server 2003 for x64 | 4.2 | | 9.2 TS2M0 | |
| Microsoft Windows Server 2008 R2 | 4.2 | | 9.2 TS2M0 | |
| Microsoft Windows Server 2008 for x64 | 4.2 | | 9.2 TS2M0 | |
| Microsoft Windows XP Professional | 4.2 | | 9.2 TS2M0 | |
| Windows Vista | 4.2 | | 9.2 TS2M0 | |
| Windows Vista for x64 | 4.2 | | 9.2 TS2M0 | |
| 64-bit Enabled AIX | 4.2 | | 9.2 TS2M0 | |
| 64-bit Enabled HP-UX | 4.2 | | 9.2 TS2M0 | |
| 64-bit Enabled Solaris | 4.2 | | 9.2 TS2M0 | |
| HP-UX IPF | 4.2 | | 9.2 TS2M0 | |
| Linux | 4.2 | | 9.2 TS2M0 | |
| Linux for x64 | 4.2 | | 9.2 TS2M0 | |
| Solaris for x64 | 4.2 | | 9.2 TS2M0 | |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
| Type: | Problem Note |
| Priority: | medium |
| Date Modified: | 2014-07-03 11:08:02 |
| Date Created: | 2014-06-03 12:33:56 |