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

Additionally, you will need to set the user specified to connect to the database to be part of the xa role created with the above SQL.

Next, you need to do next set of steps to avoid another SQL warning:

1) Open: Control Panel | Administrative Tools | Component Services

2) Open the Distributed Transaction Services item for the necessary computer(s)

3) Right click the "Local DTC" option

4) Select the security tab

5) Check "Enable XA Transactions", forcing the MS DTC service to restart.

6) Restart SQL Server to make sure it picks up the MS DTC changes.

7) Restart JBoss

Thanks go to Eduardo Fuentes for these instructions.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Michael Tan
Appian Employee
over 11 years ago

Additionally, you will need to set the user specified to connect to the database to be part of the xa role created with the above SQL.

Next, you need to do next set of steps to avoid another SQL warning:

1) Open: Control Panel | Administrative Tools | Component Services

2) Open the Distributed Transaction Services item for the necessary computer(s)

3) Right click the "Local DTC" option

4) Select the security tab

5) Check "Enable XA Transactions", forcing the MS DTC service to restart.

6) Restart SQL Server to make sure it picks up the MS DTC changes.

7) Restart JBoss

Thanks go to Eduardo Fuentes for these instructions.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data