<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<body link="#355491" alink="#4262a1" vlink="#355491" style="background: #e2e2e2; margin: 0; padding: 20px;">
<div>
<table cellpadding="0" bgcolor="#FFFFFF" border="0" cellspacing="0" style="border: 1px solid #dadada; margin-bottom: 30px; width: 100%; -moz-border-radius: 6px; -webkit-border-radius: 6px;">
<tbody>
<tr>
<td>
<table border="0" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF" style="border: solid 2px #ccc; background: #dadada; width: 100%; -moz-border-radius: 6px; -webkit-border-radius: 6px;">
<tbody>
<tr>
<td bgcolor="#000000" valign="middle" height="58px" style="border-bottom: 1px solid #ccc; padding: 20px; -moz-border-radius-topleft: 3px; -moz-border-radius-topright: 3px; -webkit-border-top-right-radius: 5px; -webkit-border-top-left-radius: 5px;">
<h1 style="color: #333333; font: bold 22px Arial, Helvetica, sans-serif; margin: 0; display: block !important;">
<!-- To have a header image/logo replace the name below with your img tag -->
<!-- Email clients will render the images when the message is read so any image -->
<!-- must be made available on a public server, so that all recipients can load the image. -->
<a href="http://community.jboss.org/index.jspa" style="text-decoration: none; color: #E1E1E1">JBoss Community</a></h1>
</td>
</tr>
<tr>
<td bgcolor="#FFFFFF" style="font: normal 12px Arial, Helvetica, sans-serif; color:#333333; padding: 20px; -moz-border-radius-bottomleft: 4px; -moz-border-radius-bottomright: 4px; -webkit-border-bottom-right-radius: 5px; -webkit-border-bottom-left-radius: 5px;"><h3 style="margin: 10px 0 5px; font-size: 17px; font-weight: normal;">
E_FAILED_TO_GET_DATASOURCE Error - JBoss & Filenet
</h3>
<span style="margin-bottom: 10px;">
created by <a href="http://community.jboss.org/people/jonis1974">jonis1974</a> in <i>Datasource Configuration</i> - <a href="http://community.jboss.org/message/633683#633683">View the full discussion</a>
</span>
<hr style="margin: 20px 0; border: none; background-color: #dadada; height: 1px;">
<div class="jive-rendered-content"><p>Hi everybody,</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p><p><p>since April 2009 we've got a J2EE application that accesses a Filenet P8 Content Engine (4.0</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p>) running on a JBoss AS. </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p>We had not had any problems with the infraestructure until a month ago, when the activity (accesses) in the Filenet system increased. Since this happened we have seen that in the JBoss logs always appears the message:</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>"<em>2011-10-25 08:58:19,172 ERROR [org.jboss.ejb.plugins.LogInterceptor] RuntimeException in method: public abstract com.filenet.apiimpl.transport.ExecuteChangesResponse com.filenet.engine.ejb.EngineCoreLocal.executeChanges(com.filenet.apiimpl.transport.ClientCallContext,com.filenet.apiimpl.transport.ExecuteChangesRequest):</em></p><p><em>com.filenet.api.exception.EngineRuntimeException: E_FAILED_TO_GET_DATASOURCE: Failed to get DataSource java:jdbc/PoolDarXA."</em></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p><p>A week ago we increased the size of the connection pool and we have seen that the pool is big enough now to support the users accessing the system, but the problem and the message still appear. </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p>We have also seen that other error messages appear mixed with the one stated before:</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>"<em>2011-10-25 08:58:19,157 WARN  [org.jboss.tm.TransactionImpl] XAException: tx=TransactionImpl:XidImpl[FormatId=257, GlobalId=WNDARP02/83, BranchQual=, localId=83] errorCode=XA_UNKNOWN(0)</em></p><p><em>javax.transaction.xa.XAException: java.sql.SQLException: DTC_XA_START:No transaction cookie returned</em>"</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>"<em>2011-10-25 08:58:19,172 WARN  [org.jboss.tm.TransactionImpl] XAException: tx=TransactionImpl:XidImpl[FormatId=257, GlobalId=WNDARP02/83, BranchQual=, localId=83] errorCode=XA_UNKNOWN(0)</em></p><p><em>javax.transaction.xa.XAException: java.sql.SQLException: ROLLBACK:Status:0 msg:*** SQLJDBC_XA DTC_ERROR Context: xa_rollback, state=1, StatusCode:-4 (0xFFFFFFFC) ***</em>"</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>The database is MS SQL Server (version 9.00.3042), the driver is MS SQL Server 2005 JDBC Driver (version 1.2.2828.203) and the datasource configurations are:</p><p><span lang="EN-US" style="color: #000000;"><datasources></span></p><p><span lang="EN-US" style="color: #000000;"><xa-datasource></span></p><p><span lang="EN-US" style="color: #000000;"><jndi-name>jdbc/PoolDarXA</jndi-name></span></p><p><span lang="EN-US" style="color: #000000;"><track-connection-by-tx></track-connection-by-tx></span></p><p><span lang="EN-US" style="color: #000000;"><isSameRM-override-value>false</isSameRM-override-value></span></p><p><span lang="EN-US" style="color: #000000;"><xa-datasource-class>com.microsoft.sqlserver.jdbc.SQLServerXADataSource</xa-datasource-class></span></p><p><span lang="EN-US" style="color: #000000;"><xa-datasource-property name="ServerName">10.30.2.234</xa-datasource-property></span></p><p><span lang="EN-US" style="color: #000000;"><xa-datasource-property name="PortNumber">1433</xa-datasource-property> </span></p><p><span lang="EN-US" style="color: #000000;"><xa-datasource-property name="DatabaseName">CE_DAR</xa-datasource-property></span></p><p><span lang="EN-US" style="color: #000000;"><xa-datasource-property name="SelectMethod">cursor</xa-datasource-property></span></p><p><span lang="EN-US" style="color: #000000;"><user-name>ce_login</user-name></span></p><p><span lang="EN-US" style="color: #000000;"><password>XXXXXXX</password></span></p><p><span lang="EN-US" style="color: #000000;"><min-pool-size>10</min-pool-size></span></p><p><span lang="EN-US" style="color: #000000;"><max-pool-size>100</max-pool-size></span></p><p><span lang="EN-US" style="color: #000000;"><idle-timeout-minutes>5</idle-timeout-minutes></span></p><p><span lang="EN-US" style="color: #000000;"><check-valid-connection-sql>select count(*) from SysObjects</check-valid-connection-sql></span></p><p><span lang="EN-US" style="color: #000000;"><!-- corresponding type-mapping in the standardjbosscmp-jdbc.xml (optional) --></span></p><p><span lang="EN-US" style="color: #000000;"><metadata></span></p><p><span lang="EN-US" style="color: #000000;"><type-mapping>MS SQLSERVER</type-mapping></span></p><p><span style="color: #000000;"></metadata></span></p><p><span style="color: #000000;"></xa-datasource></span></p><p><span style="color: #000000;"></datasources></span></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p><span lang="EN-US" style="color: #000000;"><datasources></span></p><p><span lang="EN-US" style="color: #000000;"><xa-datasource></span></p><p><span lang="EN-US" style="color: #000000;"><jndi-name>jdbc/PoolGCDJ_XA</jndi-name></span></p><p><span lang="EN-US" style="color: #000000;"><track-connection-by-tx></track-connection-by-tx></span></p><p><span lang="EN-US" style="color: #000000;"><isSameRM-override-value>false</isSameRM-override-value></span></p><p><span lang="EN-US" style="color: #000000;"><xa-datasource-class>com.microsoft.sqlserver.jdbc.SQLServerXADataSource</xa-datasource-class></span></p><p><span lang="EN-US" style="color: #000000;"><xa-datasource-property name="ServerName">10.30.2.234</xa-datasource-property></span></p><p><span lang="EN-US" style="color: #000000;"><xa-datasource-property name="PortNumber">1433</xa-datasource-property> </span></p><p><span lang="EN-US" style="color: #000000;"><xa-datasource-property name="DatabaseName">GCDJ</xa-datasource-property></span></p><p><span lang="EN-US" style="color: #000000;"><xa-datasource-property name="SelectMethod">cursor</xa-datasource-property></span></p><p><span lang="EN-US" style="color: #000000;"><user-name>ce_login</user-name></span></p><p><span lang="EN-US" style="color: #000000;"><password>XXXXXXX</password></span></p><p><span lang="EN-US" style="color: #000000;"><min-pool-size>10</min-pool-size></span></p><p><span lang="EN-US" style="color: #000000;"><max-pool-size>50</max-pool-size></span></p><p><span lang="EN-US" style="color: #000000;"><check-valid-connection-sql>select count(*) from SysObjects</check-valid-connection-sql></span></p><p><span lang="EN-US" style="color: #000000;"><!-- corresponding type-mapping in the standardjbosscmp-jdbc.xml (optional) --></span></p><p><span lang="EN-US" style="color: #000000;"><metadata></span></p><p><span lang="EN-US" style="color: #000000;"><type-mapping>MS SQLSERVER</type-mapping></span></p><p><span style="color: #000000;"></metadata></span></p><p><span style="color: #000000;"></xa-datasource></span></p><p><span style="color: #000000;"></datasources></span></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p><span style="color: #000000;">I would like to know if anybody knows what else has to be done just not to get these datasource access errors. If you need more information to help me solve the problem please tell me. Thank you in advance.</span></p></div>
<div style="background-color: #f4f4f4; padding: 10px; margin-top: 20px;">
<p style="margin: 0;">Reply to this message by <a href="http://community.jboss.org/message/633683#633683">going to Community</a></p>
<p style="margin: 0;">Start a new discussion in Datasource Configuration at <a href="http://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2077">Community</a></p>
</div></td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
</div>
</body>
</html>