When i try to start the JBoss server for the first time i get the folowing error

raghunandanj3904

Certified Senior Developer

over 11 years ago

When i try to start the JBoss server for the first time i get the folowing error:

11:13:21,435 WARN [com.arjuna.ats.jta] (Periodic Recovery) ARJUNA016027: Local XARecoveryModule.xaRecovery go
t XA exception XAException.XAER_RMERR: javax.transaction.xa.XAException: com.microsoft.sqlserver.jdbc.SQLServe
rException: Failed to create the XA control connection. Error: "Could not find stored procedure 'master..xp_sq
ljdbc_xa_init_ex'."
May i know if i need to sdo any othr seting for this. I am tryin to install Appian 7.1...

Discussion posts and replies are publicly visible

Parents

0 Michael Tan
Appian Employee
over 11 years ago

I have run in to this recently. This is a warning and should not prevent you from starting up Jboss. Appian's technical support team recently provided thes the following:
This WARNING means you configured your data sources as XA-Datasources but your SQL Server is not configured to handle distributed transaction and XA support for the Microsoft JDBC Driver for SQL Server. This topic falls more into the SQL Server Technical Support scope, but in general here's what you have to do:

1. Download the latest version of the MS SQL Server JDBC Driver
2. Unzip the content in a temporary directory
3. Drop the sqljdbc4.jar in <JBOSS_HOME>\\bin\\server\\all\\lib
4. Inside the unzipped content from step #2 there's a directory called "xa" under <Microsoft JDBC Driver 4.0 for SQL Server>\\sqljdbc_4.0\\enu\\ navigate to that directory
5. In the directory you will find a file called "xa_install.sql" with the instructions on how to enable this feature in your SQL server which basically consist on:
----> 5.1 Identifying if you are running SQL Server 2008 64 or 32bits
----> 5.2 Depending on the answer from step 5.1 copy the sqljdbc_xa.dll from the unzipped folder <Microsoft JDBC Driver 4.0 for SQL Server>\\sqljdbc_4.0\\enu\\xa\\x64 for 64 bits or <Microsoft JDBC Driver 4.0 for SQL Server>\\sqljdbc_4.0\\enu\\xa\\x86 for 32bits
----> 5.3 Paste the sqljdbc_xa.dll you copied from step 5.2 into <SQL_SERVER_2008_HOME>\\Tools\\Binn and SQL_SERVER_2008_HOME>\\localDB\\Binn
----> 5.4 Execute the xa_install.sql script mentioned on step #5
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Michael Tan
Appian Employee
over 11 years ago

I have run in to this recently. This is a warning and should not prevent you from starting up Jboss. Appian's technical support team recently provided thes the following:
This WARNING means you configured your data sources as XA-Datasources but your SQL Server is not configured to handle distributed transaction and XA support for the Microsoft JDBC Driver for SQL Server. This topic falls more into the SQL Server Technical Support scope, but in general here's what you have to do:

1. Download the latest version of the MS SQL Server JDBC Driver
2. Unzip the content in a temporary directory
3. Drop the sqljdbc4.jar in <JBOSS_HOME>\\bin\\server\\all\\lib
4. Inside the unzipped content from step #2 there's a directory called "xa" under <Microsoft JDBC Driver 4.0 for SQL Server>\\sqljdbc_4.0\\enu\\ navigate to that directory
5. In the directory you will find a file called "xa_install.sql" with the instructions on how to enable this feature in your SQL server which basically consist on:
----> 5.1 Identifying if you are running SQL Server 2008 64 or 32bits
----> 5.2 Depending on the answer from step 5.1 copy the sqljdbc_xa.dll from the unzipped folder <Microsoft JDBC Driver 4.0 for SQL Server>\\sqljdbc_4.0\\enu\\xa\\x64 for 64 bits or <Microsoft JDBC Driver 4.0 for SQL Server>\\sqljdbc_4.0\\enu\\xa\\x86 for 32bits
----> 5.3 Paste the sqljdbc_xa.dll you copied from step 5.2 into <SQL_SERVER_2008_HOME>\\Tools\\Binn and SQL_SERVER_2008_HOME>\\localDB\\Binn
----> 5.4 Execute the xa_install.sql script mentioned on step #5
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data