Error 1222: Lock request time out period exceeded & SP4 ?

Hi,
After Spl Server 2000 w/ 16 G memory was applied SP4 and hotfix for AWE, it
got an error "Error 1222: Lock request time out period exceeded." while
running a stored procedure. It hung the process for much longer than normal.
It worked fine with SP3a. Is this error associated with SP4? Thanks.
Chuck
Check this KB http://support.microsoft.com/?kbid=888799
There are couple of fixes related to timing /performance issues
Thanks & Rate the Postings.
-Ravi-
"Chuck" wrote:

> Hi,
> After Spl Server 2000 w/ 16 G memory was applied SP4 and hotfix for AWE, it
> got an error "Error 1222: Lock request time out period exceeded." while
> running a stored procedure. It hung the process for much longer than normal.
> It worked fine with SP3a. Is this error associated with SP4? Thanks.
>
> Chuck

Error 1222: Lock request time out period exceeded & SP4 ?

Hi,
After Spl Server 2000 w/ 16 G memory was applied SP4 and hotfix for AWE, it
got an error "Error 1222: Lock request time out period exceeded." while
running a stored procedure. It hung the process for much longer than normal.
It worked fine with SP3a. Is this error associated with SP4? Thanks.
ChuckCheck this KB http://support.microsoft.com/?kbid=888799
There are couple of fixes related to timing /performance issues
--
Thanks & Rate the Postings.
-Ravi-
"Chuck" wrote:
> Hi,
> After Spl Server 2000 w/ 16 G memory was applied SP4 and hotfix for AWE, it
> got an error "Error 1222: Lock request time out period exceeded." while
> running a stored procedure. It hung the process for much longer than normal.
> It worked fine with SP3a. Is this error associated with SP4? Thanks.
>
> Chuck

Error 1222: Lock request time out period exceeded & SP4 ?

Hi,
After Spl Server 2000 w/ 16 G memory was applied SP4 and hotfix for AWE, it
got an error "Error 1222: Lock request time out period exceeded." while
running a stored procedure. It hung the process for much longer than normal.
It worked fine with SP3a. Is this error associated with SP4? Thanks.
ChuckCheck this KB http://support.microsoft.com/?kbid=888799
There are couple of fixes related to timing /performance issues
Thanks & Rate the Postings.
-Ravi-
"Chuck" wrote:

> Hi,
> After Spl Server 2000 w/ 16 G memory was applied SP4 and hotfix for AWE, i
t
> got an error "Error 1222: Lock request time out period exceeded." while
> running a stored procedure. It hung the process for much longer than norma
l.
> It worked fine with SP3a. Is this error associated with SP4? Thanks.
>
> Chuck

Error 1222 Lock Request time out period exceed

Hi, I'm getting this error when I tried to click on the Current Activity in
the Enterprise Manager. This is a SQL2000 running on Windows2000. Does
anyone know what causes this and how to fix it? I also get this error
sometimes when I run a crystal report in my C# application.
Thanks,
AlphaA transaction is being blocked to acquire a lock because another transaction
already locked the resource.
See "Customizing the Lock Time-out" in BOL.
AMB
"Alpha" wrote:
> Hi, I'm getting this error when I tried to click on the Current Activity in
> the Enterprise Manager. This is a SQL2000 running on Windows2000. Does
> anyone know what causes this and how to fix it? I also get this error
> sometimes when I run a crystal report in my C# application.
> Thanks,
> Alpha|||Do not use the GUI. Instead, get used to sp_who, sp_who2 or sp_who1 in Query
Analyzer.
"Alpha" <Alpha@.discussions.microsoft.com> wrote in message
news:16FC85B9-57C8-4906-AC47-3B9E826D9A79@.microsoft.com...
> Hi, I'm getting this error when I tried to click on the Current Activity
> in
> the Enterprise Manager. This is a SQL2000 running on Windows2000. Does
> anyone know what causes this and how to fix it? I also get this error
> sometimes when I run a crystal report in my C# application.
> Thanks,
> Alpha|||Thank you. That was very helpful.
"Alejandro Mesa" wrote:
> A transaction is being blocked to acquire a lock because another transaction
> already locked the resource.
> See "Customizing the Lock Time-out" in BOL.
>
> AMB
> "Alpha" wrote:
> > Hi, I'm getting this error when I tried to click on the Current Activity in
> > the Enterprise Manager. This is a SQL2000 running on Windows2000. Does
> > anyone know what causes this and how to fix it? I also get this error
> > sometimes when I run a crystal report in my C# application.
> >
> > Thanks,
> > Alpha

Error 1222 Lock request

I received the Error 1222 lock request time out period
when trying to open SQL Server Current Activity folder
under the Management folder to display locks.
This was caused by several locks.
This made it very difficult to resolve the locks without
the GUI.
What would cause the SQL Server GUI to be unable to
display the locks?
Thank You,
Mickey Autry
mautry@.ev1.netThat's know to happen when you have a lot of locks. You can
use Query Analyzer to execute sql statments and system
stored procedures to view the same info you look at in the
Current Activity part of Enterprise Manager. Check books
online for more information on sp_lock, sp_who, sp_who2 and
the sysprocesses table.
-Sue
On Tue, 23 Sep 2003 15:41:17 -0700, "Mickey"
<mautry@.ev1.net> wrote:
>I received the Error 1222 lock request time out period
>when trying to open SQL Server Current Activity folder
>under the Management folder to display locks.
>This was caused by several locks.
>This made it very difficult to resolve the locks without
>the GUI.
>What would cause the SQL Server GUI to be unable to
>display the locks?
>Thank You,
>Mickey Autry
>mautry@.ev1.net
>

Error 1053. The service did not respond to the start or control request in a timely fashio

I have a setup with SQL 2005 installed on x64 win2003.
After i register a 32 bit NT service, it fails to start.
Always get error "Error 1053. The service did not respond to the start
or control request in a timely fashion"
Is it related to "http://support.microsoft.com/kb/886695" ?
But this KB do not mention x64.
Anyone has any idea why the service control Manager returns error ?
trying using configuration mgr to reset the startup account. this should
ensure proper permissions are given to the acct/new sql local group.
-oj
<wn123456@.gmail.com> wrote in message
news:1172067716.276863.253090@.p10g2000cwp.googlegr oups.com...
>I have a setup with SQL 2005 installed on x64 win2003.
> After i register a 32 bit NT service, it fails to start.
> Always get error "Error 1053. The service did not respond to the start
> or control request in a timely fashion"
> Is it related to "http://support.microsoft.com/kb/886695" ?
> But this KB do not mention x64.
> Anyone has any idea why the service control Manager returns error ?
>
|||On Feb 22, 1:31 am, "oj" <nospam_oj...@.home.com> wrote:
> trying using configuration mgr to reset the startup account. this should
> ensure proper permissions are given to the acct/new sql local group.
> --
> -oj
> <wn123...@.gmail.com> wrote in message
> news:1172067716.276863.253090@.p10g2000cwp.googlegr oups.com...
>
>
>
> - Show quoted text -
Hi Oj,
Here my 32bit NT service fails to start. (SQL is up and running.)
This is observed only on the system with SQL 2005 - x64.
Is there some way to know what all steps "service control Manager"
perform before invoking the service.
Thanks,
wn
|||You can use ProcessMon
(http://www.microsoft.com/technet/sysinternals/utilities/processmonitor.mspx)
to step through the process.
-oj
<wn123456@.gmail.com> wrote in message
news:1172117914.387013.248870@.k78g2000cwa.googlegr oups.com...
> On Feb 22, 1:31 am, "oj" <nospam_oj...@.home.com> wrote:
> Hi Oj,
> Here my 32bit NT service fails to start. (SQL is up and running.)
> This is observed only on the system with SQL 2005 - x64.
> Is there some way to know what all steps "service control Manager"
> perform before invoking the service.
> Thanks,
> wn
>

Error 1053. The service did not respond to the start or control request in a timely fashio

I have a setup with SQL 2005 installed on x64 win2003.
After i register a 32 bit NT service, it fails to start.
Always get error "Error 1053. The service did not respond to the start
or control request in a timely fashion"
Is it related to "http://support.microsoft.com/kb/886695" ?
But this KB do not mention x64.
Anyone has any idea why the service control Manager returns error ?trying using configuration mgr to reset the startup account. this should
ensure proper permissions are given to the acct/new sql local group.
--
-oj
<wn123456@.gmail.com> wrote in message
news:1172067716.276863.253090@.p10g2000cwp.googlegroups.com...
>I have a setup with SQL 2005 installed on x64 win2003.
> After i register a 32 bit NT service, it fails to start.
> Always get error "Error 1053. The service did not respond to the start
> or control request in a timely fashion"
> Is it related to "http://support.microsoft.com/kb/886695" ?
> But this KB do not mention x64.
> Anyone has any idea why the service control Manager returns error ?
>|||On Feb 22, 1:31 am, "oj" <nospam_oj...@.home.com> wrote:
> trying using configuration mgr to reset the startup account. this should
> ensure proper permissions are given to the acct/new sql local group.
> --
> -oj
> <wn123...@.gmail.com> wrote in message
> news:1172067716.276863.253090@.p10g2000cwp.googlegroups.com...
>
> >I have a setup with SQL 2005 installed on x64 win2003.
> > After i register a 32 bit NT service, it fails to start.
> > Always get error "Error 1053. The service did not respond to the start
> > or control request in a timely fashion"
> > Is it related to "http://support.microsoft.com/kb/886695" ?
> > But this KB do not mention x64.
> > Anyone has any idea why the service control Manager returns error ... Hide quoted text -
> - Show quoted text -
Hi Oj,
Here my 32bit NT service fails to start. (SQL is up and running.)
This is observed only on the system with SQL 2005 - x64.
Is there some way to know what all steps "service control Manager"
perform before invoking the service.
Thanks,
wn|||You can use ProcessMon
(http://www.microsoft.com/technet/sysinternals/utilities/processmonitor.mspx)
to step through the process.
--
-oj
<wn123456@.gmail.com> wrote in message
news:1172117914.387013.248870@.k78g2000cwa.googlegroups.com...
> On Feb 22, 1:31 am, "oj" <nospam_oj...@.home.com> wrote:
>> trying using configuration mgr to reset the startup account. this should
>> ensure proper permissions are given to the acct/new sql local group.
>> --
>> -oj
>> <wn123...@.gmail.com> wrote in message
>> news:1172067716.276863.253090@.p10g2000cwp.googlegroups.com...
>>
>> >I have a setup with SQL 2005 installed on x64 win2003.
>> > After i register a 32 bit NT service, it fails to start.
>> > Always get error "Error 1053. The service did not respond to the start
>> > or control request in a timely fashion"
>> > Is it related to "http://support.microsoft.com/kb/886695" ?
>> > But this KB do not mention x64.
>> > Anyone has any idea why the service control Manager returns error ...
>> > Hide quoted text -
>> - Show quoted text -
> Hi Oj,
> Here my 32bit NT service fails to start. (SQL is up and running.)
> This is observed only on the system with SQL 2005 - x64.
> Is there some way to know what all steps "service control Manager"
> perform before invoking the service.
> Thanks,
> wn
>

Error "Lock Request Time Out" when deleting a record

Hi all,
I'm trying to delete one record from application but I get an Error :
"Lock request time out periode exceeded (37000) was experienced when
deleting a record from dbo.fe9srjh".
I'm using SQL Server 2000 SP3. What should I do ? Thank's a lot ..
rgds,
yuliusSomeone has a conflicting lock which cases your LOCK_TIMEOUT setting (set by
the programmer of your
client application) to time out. Use sp_who, sp_who2, sp_lock, Current Activ
ity in EM to find out
who is locking the resource. When you find that person, talk to the vendor o
f the application that
the person is using and have them figure out why the long lived lock.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Yulius Sutanto" <ysutanto@.atlas-sp.com> wrote in message
news:1130208619.276385.284300@.f14g2000cwb.googlegroups.com...
> Hi all,
> I'm trying to delete one record from application but I get an Error :
> "Lock request time out periode exceeded (37000) was experienced when
> deleting a record from dbo.fe9srjh".
> I'm using SQL Server 2000 SP3. What should I do ? Thank's a lot ..
> rgds,
> yulius
>

Erratic report execution

When we request reports through the Report Manager, sometimes they run
and sometimes they don't (ie they time out after 30 minutes.)
Specifically, when I run exactly the same report with exactly the same
parameters and examine the ExecutionLog I will see numbers such as:
First report request (does not run):
TimeEnd - TimeStart = 30:14.4
TimeDataRetrieval = 0
TimeProcessing = 1814137
Status = rsProcessingAborted
Second report request (does run):
TimeEnd - TimeStart = 00:27.7
TimeDataRetrieval = 14087
TimeProcessing = 12502
Status = rsSuccess
This situation occurs with different reports (not just one specific
one), different users (not just one specific user) and unpredictably (I
have not been able to define the conditions under which a report will
not run.) Sometimes running a second request immediately after the
first will appear to "trigger" the report to run (which made me suspect
a cache issue) but at other times the second request is made a day or
two later and the report runs correctly (ie long after the cache has
been flushed.) More often than not the reports do run.
We are running SP1 and all of the reports use multiple datasets via
stored procedures. Most of the stored procedures use (NOLOCK) on the
SELECT statements.
I searched the forum but could not find a discussion on this topic.
Does anyone have any suggestions as to how I can track this down?
Regards.I am also facing the same problem. In my case, the details when the report
didn't run are:
TimeDataRetrieval = 0
TimeProcessing = 29305548
Status = rsProcessingAborted
Can someone prescribe further course of action?
Thanks in advance!