HPE Community read-only access December 15, 2018
This is a maintenance upgrade. You will be able to read articles and posts, but not post or reply.
Hours:
Dec 15, 4:00 am to 10:00 am UTC
Dec 14, 10:00 pm CST to Dec 15, 4:00 am CST
Dec 14, 8:00 pm PST to Dec 15, 2:00 am PST
Server Management - Systems Insight Manager
cancel
Showing results for 
Search instead for 
Did you mean: 

RE: open sql transaction will not close; reopens after a reboot

 
Josh S.
Occasional Advisor

RE: open sql transaction will not close; reopens after a reboot

I am a HP SIM noob. I spent a couple weeks trying to read the myriad of doc's for SIM and all of the doc's that are associated with it for the agents, plug-in's, ..etc. Anyway, I made the plunge and installed 5.1 SP1 and the hotfix on a W2k3 sp2 vm guest with SQL 2005 db on a seperate server.

The problem that is being reported to me by the dba is that there is an open sql transaction to the vmm db and it will not close. It is not active and has been open since the first day of the install.

Any insight on the issue? Any ideas on how to prevent?

Thanks,
Josh