Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 2 of 2 total
Thread Unable to create function or procedure on DB, EDBMgr just "hangs"
Wed, Jun 13 2012 10:51 AMPermanent Link

Adam Brett

Orixa Systems

Anyone got any idea why this might be happening?

I have EDBMgr open. I am logged on as Administrator to 2 databases

db 1: I can do anything, CREATE / DROP FUNCTION or PROCEDURE.

db 2: Whenever I try to do any of the above, even for just a "test" function with no content.

--

It feels to me as though somehow db 2's config files have become read only (or something) ... any experiences of this from anyone?
Wed, Jun 13 2012 11:04 AMPermanent Link

Adam Brett

Orixa Systems

Cancel this post ... the trusty old method of rebooting the server fixed it.

There was a ghost session which seemed to have locked the database, probably a function-create process which was interrupted by a network failure.
Image