xa_start (40000) returns -7 error message coming from SQL Server 2000

[eborisow]

Hi everyone,

First time post, so please be gentle. We are using an application that uses BEA Weblogic as the app server and SQL Server 2000 database. On startup of the node for this server, we are seeing a SQL Exception being thrown by SQL Server. The error is:

SQLException: SQLState(HY000) vendor code(20001)
xa_start (40000) returns -7

I can't find any information at all on this error.

Thanks,
Eric

 

[ptheriault]

Have you checked weblogic? That is definetly a weblogic error.

- Paul
- Experience is the name every one gives to their mistakes.

 

[gmmastros]

Also check for errors in the event viewer.

Click Start -> Run
Type: eventvwr.msc
Click OK

SQL Server errors are in the 'Application' node.

 

[eborisow]

Paul, this error is appearing in the JDBC logs, so my guess is that it has something to do with the database connectivity or the database itself throwing some kind of error.

I will check on the database server to see if there are any errors in the Event Viewer.

Thanks,
Eric

 

[eborisow]

By the way... I also see this message:

XA error: XAER_RMFAIL : Resource manager is unavailable

 

[ptheriault]

Take a look at this post, it may be helpful.

http://forums.bea.com/thread.jspa?threadID=400004068

xa_start is not a sql server procedure.



- Paul
- Experience is the name every one gives to their mistakes.

 

[eborisow]

Everyone,

Thanks for the help. We found out that the problem was an orphaned transaction in MSDTC and it was blocking other processes. This blog helped us figure out and kill the orphaned process:

http://robkraft.spaces.live.com/Blog/cns!E6687F3AB6372637!161.entry

Thanks,
Eric