Hi,

Does anyone know what a general lock failure means?  Two clients have been
getting this message a lot lately.

Alex

"Al Vas" <noreply@noreply.com> wrote in message
news:ECF09700-69EC-4C8B-A04F-69A2E621A173@news.elevatesoft.com...
> Hi,
>
> Does anyone know what a general lock failure means?  Two clients have been
> getting this message a lot lately.
>

What OS are they running on the file server?

Robert

Windows 2003 I believe but I'll confirm (its either that or Windows 2000)

"Robert" <ngsemail2005withoutthis@yahoo.com.ar> wrote in message
news:553894AE-6F5C-4CEB-AA48-6BEFF9737B31@news.elevatesoft.com...
>
> "Al Vas" <noreply@noreply.com> wrote in message
> news:ECF09700-69EC-4C8B-A04F-69A2E621A173@news.elevatesoft.com...
>> Hi,
>>
>> Does anyone know what a general lock failure means?  Two clients have
>> been getting this message a lot lately.
>>
>
> What OS are they running on the file server?
>
> Robert
>

Yep Windows 2003.  Does the operating system make a difference?

Any comments?

Thanks

Alex
"Al Vas" <noreply@noreply.com> wrote in message
news:8AD6A1F5-8892-440B-8D14-9B63062149A5@news.elevatesoft.com...
> Windows 2003 I believe but I'll confirm (its either that or Windows 2000)
>
> "Robert" <ngsemail2005withoutthis@yahoo.com.ar> wrote in message
> news:553894AE-6F5C-4CEB-AA48-6BEFF9737B31@news.elevatesoft.com...
>>
>> "Al Vas" <noreply@noreply.com> wrote in message
>> news:ECF09700-69EC-4C8B-A04F-69A2E621A173@news.elevatesoft.com...
>>> Hi,
>>>
>>> Does anyone know what a general lock failure means?  Two clients have
>>> been getting this message a lot lately.
>>>
>>
>> What OS are they running on the file server?
>>
>> Robert
>>
>

Alex,

<< Does anyone know what a general lock failure means?  Two clients have
been getting this message a lot lately. >>

This error usually means that you've got a transaction locking issue
(dangling transaction locks that are due to transactions that aren't getting
rolled back properly) or that you've got an issue with so much activity that
is causing write locks to never get granted (doubtful).

--
Tim Young
Elevate Software
www.elevatesoft.com

Thanks Tim,

So this issue could be caused by a user who in their wisdom decides to
CTRL-ALT-DEL an application (due to the database engine never getting a
command to roll back the transaction)?

Alex
"Tim Young [Elevate Software]" <timyoung@elevatesoft.com> wrote in message
news:BDAB5FDD-26C1-466A-B34F-4AD4D7E0B4FA@news.elevatesoft.com...
> Alex,
>
> << Does anyone know what a general lock failure means?  Two clients have
> been getting this message a lot lately. >>
>
> This error usually means that you've got a transaction locking issue
> (dangling transaction locks that are due to transactions that aren't
> getting rolled back properly) or that you've got an issue with so much
> activity that is causing write locks to never get granted (doubtful).
>
> --
> Tim Young
> Elevate Software
> www.elevatesoft.com
>

Alex,

<< So this issue could be caused by a user who in their wisdom decides to
CTRL-ALT-DEL an application (due to the database engine never getting a
command to roll back the transaction)? >>

Only with non-C/S clients.  With C/S clients, the database server will kill
their session eventually (dead session expiration time setting on the
database server), thus removing the transaction.

--
Tim Young
Elevate Software
www.elevatesoft.com

Hmm,

All our clients for this particular product are client/server.
Interestingly though havent encountered it as an issue for a little while
and maybe it was associated with other problems ie out of memory error on
server engine.

Thanks

Alex

"Tim Young [Elevate Software]" <timyoung@elevatesoft.com> wrote in message
news:18FCF74F-986B-41EA-BF04-45D2AB22BFE4@news.elevatesoft.com...
> Alex,
>
> << So this issue could be caused by a user who in their wisdom decides to
> CTRL-ALT-DEL an application (due to the database engine never getting a
> command to roll back the transaction)? >>
>
> Only with non-C/S clients.  With C/S clients, the database server will
> kill their session eventually (dead session expiration time setting on the
> database server), thus removing the transaction.
>
> --
> Tim Young
> Elevate Software
> www.elevatesoft.com
>