×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

MTS Package Hanging

MTS Package Hanging

MTS Package Hanging

(OP)
I have a MTS package that uses VB6 components running in a server package in MTS 2 on NT 4 Server, using ODBC to connect to a SQL Server 7 database. All latest service packs have been applied.

Occasionally, the MTS application just appears to stop. It doesn't generate an error message. Nothing is written to the event logs and the %Processor use for both processors on the server drops to practically zero - it is used as a dedicated Business objects server. Killing the MTX process for the application via Task Manager resolves the problem. A new MTX process is immediately created and everything picks up as before.

The VB6 components have the Retained in Memory flag set. SQL Server doesn't record any error msgs. We have used SQL Profiler to monitor all Txns, and when the problem occurs, no new transactions occur. There are no open transactions waiting to complete and no deadlocks have been detected. Other applications (running on separate Business Objects servers) can carry on and can still use the database as normal. SQL Server doesn't show any connections being blocked either.

There are up to 300 users on this application and MTS can process up to 1,000,000 transactions a day. Most of the time it is fine, but every now and then it just stops for no apparent reason. This has happened 3 times this
week.

Anyone any ideas?

RE: MTS Package Hanging

Well, ppl will tell u to check if all of your objects are released and set to nothing. That's good.

I experienced something similar to yours. Check out the event log of NT to see if the HD has been complaining. My app hung no reason, we finally noticed a bad sector on the drive that caused accessing data from the drive was impossible and the whole thing came to a halt.  :(

I hope you solve your problem. Good luck.


Min.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login


Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close