I recently started seeing a new description in the deadlock event. Anyone
have any idea what the underlying issue might be?
"Parallel query worker thread was involved in a deadlock"
Thanks
Richard
Hi Richard
"Richard Douglass" wrote:
> I recently started seeing a new description in the deadlock event. Anyone
> have any idea what the underlying issue might be?
> "Parallel query worker thread was involved in a deadlock"
> Thanks
> Richard
>
Your query has been chosen to be be run in parallel, check out the topic
"Degree of Parallelism" in books online for more background.
From http://msdn2.microsoft.com/en-us/library/ms178104(SQL.90).aspx
"Coordinator, producer, or consumer threads associated with an exchange port
may block each other causing a deadlock usually when including at least one
other process that is not a part of the parallel query. Also, when a parallel
query starts execution, SQL Server determines the degree of parallelism, or
the number of worker threads, based upon the current workload. If the system
workload unexpectedly changes, for example, where new queries start running
on the server or the system runs out of worker threads, then a deadlock could
occur."
If you use the MAXDOP option to specify fewer processors you should not get
this, changing settings such as "cost threshold for parallelism" would affect
the whole system so it is probably not a great idea to change that.
John
Showing posts with label event. Show all posts
Showing posts with label event. Show all posts
Thursday, March 22, 2012
Deadlock question
I recently started seeing a new description in the deadlock event. Anyone
have any idea what the underlying issue might be'
"Parallel query worker thread was involved in a deadlock"
Thanks
RichardHi Richard
"Richard Douglass" wrote:
> I recently started seeing a new description in the deadlock event. Anyone
> have any idea what the underlying issue might be'
> "Parallel query worker thread was involved in a deadlock"
> Thanks
> Richard
>
Your query has been chosen to be be run in parallel, check out the topic
"Degree of Parallelism" in books online for more background.
From http://msdn2.microsoft.com/en-us/library/ms178104(SQL.90).aspx
"Coordinator, producer, or consumer threads associated with an exchange port
may block each other causing a deadlock usually when including at least one
other process that is not a part of the parallel query. Also, when a parallel
query starts execution, SQL Server determines the degree of parallelism, or
the number of worker threads, based upon the current workload. If the system
workload unexpectedly changes, for example, where new queries start running
on the server or the system runs out of worker threads, then a deadlock could
occur."
If you use the MAXDOP option to specify fewer processors you should not get
this, changing settings such as "cost threshold for parallelism" would affect
the whole system so it is probably not a great idea to change that.
Johnsql
have any idea what the underlying issue might be'
"Parallel query worker thread was involved in a deadlock"
Thanks
RichardHi Richard
"Richard Douglass" wrote:
> I recently started seeing a new description in the deadlock event. Anyone
> have any idea what the underlying issue might be'
> "Parallel query worker thread was involved in a deadlock"
> Thanks
> Richard
>
Your query has been chosen to be be run in parallel, check out the topic
"Degree of Parallelism" in books online for more background.
From http://msdn2.microsoft.com/en-us/library/ms178104(SQL.90).aspx
"Coordinator, producer, or consumer threads associated with an exchange port
may block each other causing a deadlock usually when including at least one
other process that is not a part of the parallel query. Also, when a parallel
query starts execution, SQL Server determines the degree of parallelism, or
the number of worker threads, based upon the current workload. If the system
workload unexpectedly changes, for example, where new queries start running
on the server or the system runs out of worker threads, then a deadlock could
occur."
If you use the MAXDOP option to specify fewer processors you should not get
this, changing settings such as "cost threshold for parallelism" would affect
the whole system so it is probably not a great idea to change that.
Johnsql
Deadlock question
I recently started seeing a new description in the deadlock event. Anyone
have any idea what the underlying issue might be'
"Parallel query worker thread was involved in a deadlock"
Thanks
RichardHi Richard
"Richard Douglass" wrote:
> I recently started seeing a new description in the deadlock event. Anyone
> have any idea what the underlying issue might be'
> "Parallel query worker thread was involved in a deadlock"
> Thanks
> Richard
>
Your query has been chosen to be be run in parallel, check out the topic
"Degree of Parallelism" in books online for more background.
From http://msdn2.microsoft.com/en-us/library/ms178104(SQL.90).aspx
"Coordinator, producer, or consumer threads associated with an exchange port
may block each other causing a deadlock usually when including at least one
other process that is not a part of the parallel query. Also, when a paralle
l
query starts execution, SQL Server determines the degree of parallelism, or
the number of worker threads, based upon the current workload. If the system
workload unexpectedly changes, for example, where new queries start running
on the server or the system runs out of worker threads, then a deadlock coul
d
occur."
If you use the MAXDOP option to specify fewer processors you should not get
this, changing settings such as "cost threshold for parallelism" would affec
t
the whole system so it is probably not a great idea to change that.
John
have any idea what the underlying issue might be'
"Parallel query worker thread was involved in a deadlock"
Thanks
RichardHi Richard
"Richard Douglass" wrote:
> I recently started seeing a new description in the deadlock event. Anyone
> have any idea what the underlying issue might be'
> "Parallel query worker thread was involved in a deadlock"
> Thanks
> Richard
>
Your query has been chosen to be be run in parallel, check out the topic
"Degree of Parallelism" in books online for more background.
From http://msdn2.microsoft.com/en-us/library/ms178104(SQL.90).aspx
"Coordinator, producer, or consumer threads associated with an exchange port
may block each other causing a deadlock usually when including at least one
other process that is not a part of the parallel query. Also, when a paralle
l
query starts execution, SQL Server determines the degree of parallelism, or
the number of worker threads, based upon the current workload. If the system
workload unexpectedly changes, for example, where new queries start running
on the server or the system runs out of worker threads, then a deadlock coul
d
occur."
If you use the MAXDOP option to specify fewer processors you should not get
this, changing settings such as "cost threshold for parallelism" would affec
t
the whole system so it is probably not a great idea to change that.
John
Deadlock Problem in SQL Trigger Urgent
Hello Db experts,
Recently I am facing a problem as, I have a trigger on table1 in after insert
event. When i tried to insert data on table from 4 different source deadlock problem for causing trigger fire. Whenever I removed the trigger no dead lock occured. Can any one help me to handle this deadlock problem.What does the trigger do?|||I'd bet that we can. Check out the FAQ entry for How to get quick and correct answers (http://www.dbforums.com/showthread.php?t=1212452#post4527530) for help.
-PatP|||if you want it fixed you need to give us code.|||Dear Coolberg
Please know thrigger do some calculation for Table1's last inserted record and insert or Update in an another table like Control1 table|||Hello Db experts,
Recently I am facing a problem as, I have a trigger on table1 in after insert
event. When i tried to insert data on table from 4 different source deadlock problem for causing trigger fire. Whenever I removed the trigger no dead lock occured. Can any one help me to handle this deadlock problem.
Nomoskar Mahfuz,
Ami apnake ekta private message diyechi.Doyakore oti porben.Ar apnar problem ti bhalo kore amay bolle kuub balo hoy.Ar apni je trigger ta likhechen ,otar code akhane likle bhalo hoy, mane akhane sobai apnake Banglay likhe bolte anurod koreche.Apni amar likkhe pathan, ba banglay akhane likhun,tahole DBA ra kuub sohoje apnake sahajjo korte parbe.
Bhalo Thakben!!|||Nomoskar Mahfuz,
Ami apnake ekta private message diyechi.Doyakore oti porben.Ar apnar problem ti bhalo kore amay bolle kuub balo hoy.Ar apni je trigger ta likhechen ,otar code akhane likle bhalo hoy, mane akhane sobai apnake Banglay likhe bolte anurod koreche.Apni amar likkhe pathan, ba banglay akhane likhun,tahole DBA ra kuub sohoje apnake sahajjo korte parbe.
Bhalo Thakben!!Easy for you to say! ;) Thanks for the Bengali assistance, I'm sure it will help.
-PatP|||Hello Again,
Sorry for not posting the code before. Please have a look at my code below. Now let me explain what problem I faced,there is a table named Table1 where data being inserted from 4 different sources in huge number (Almost 1000 records/sec), The After Insert trigger(Trigger1) written on Table1 inserts or updates the extracted information from Table1 to Table1_Backup.
Most of the times during Insertion to Table1 I am getting a message as:
"Transaction (Process ID 57) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. "
and I am loosing data in Table1 i.e not all records were inserted.
But when I removed the Trigger , I didn't get this error message and there were no data loss. Looking Forward For any help to come out of this problem.
Code:
create table Table1
(sId int,
sName varchar(50),
sPhone varchar(50),
sBalance bigint
)
create table Table1_Backup
(sId int,
sName varchar(50),
sPhone varchar(50),
sBalance bigint
)
Create TRIGGER Trigger1
ON Table1
After INSERT
AS
Declare
@.counter int,
@.sId int,
@.sName varchar(50),
@.sPhone varchar(30),
@.sBalance bigint;
Begin
set @.counter = 0;
set @.sId = 0;
set @.sName = null;
set @.sPhone = null;
set @.sBalance = 0;
select @.sId = sId,
@.sName = sName,
@.sPhone = sPhone,
@.sBalance = sBalance
from INSERTED Table1;
Select @.counter = @.sId From Table1_Backup WHERE sId = @.sId;
IF (@.counter < 1 )
insert into Table1_Backup
values(@.sId,@.sName,@.sPhone,@.sBalance);
ELSE
Update Table1_Backup
set sBalance = sBalance + @.sBalance
Where sId = @.sId;
End|||Hi Dada,
Nin bangaly bolchi, kintu ami to problem ta post korechi shudhu bangali der jonno noy, ekhane to non bangali o ache. Kintu apnar shahajjo korar icche dhekhe khub valo laglo. Tai apnake bangaly likchi. Amra bangalay kotha (chat) bolte pari jodi apni chan, amar yahoo id hocche "mahfuz_onsky@.yahoo.com".
Asha kori shomadhan ta apnar kachei pabo ebong ekjon bangali dada er kache pele valoi lagbe.
Kotha hobe.
Mahfuz.
Nomoskar Mahfuz,
Ami apnake ekta private message diyechi.Doyakore oti porben.Ar apnar problem ti bhalo kore amay bolle kuub balo hoy.Ar apni je trigger ta likhechen ,otar code akhane likle bhalo hoy, mane akhane sobai apnake Banglay likhe bolte anurod koreche.Apni amar likkhe pathan, ba banglay akhane likhun,tahole DBA ra kuub sohoje apnake sahajjo korte parbe.
Bhalo Thakben!!|||Can you show me the Insert statement that you are using to insert data? By the way which version of Sql server are you running?
It may be a problem in your application code,plz provide the code where you are inserting the data.|||In SQL Server, a trigger fires once for each SQL Statement that launches the trigger, no matter how many rows the original statement might have affected. There could be 1000 or more rows in the INSERTED table for any given execution of your trigger.
There appears to be a logic error inside your trigger, but without knowing exactly what you are trying to do, I can't fix that. The code translated to use sets instead of working one row at a time would be:CREATE TRIGGER Trigger1
ON Table1
After INSERT
AS
INSERT INTO Table1_Backup (
sId, sName, sPhone, sBalance)
SELECT sId, sName, sPhone, sBalance
FROM INSERTED
WHERE sID < 1
UPDATE Table1_Backup
SET sBalance = sBalance + (SELECT Sum(INSERTED.sBalance)
FROM INSERTED
WHERE INSERTED.sId = Table1_Backup.sId)
END-PatPsql
Recently I am facing a problem as, I have a trigger on table1 in after insert
event. When i tried to insert data on table from 4 different source deadlock problem for causing trigger fire. Whenever I removed the trigger no dead lock occured. Can any one help me to handle this deadlock problem.What does the trigger do?|||I'd bet that we can. Check out the FAQ entry for How to get quick and correct answers (http://www.dbforums.com/showthread.php?t=1212452#post4527530) for help.
-PatP|||if you want it fixed you need to give us code.|||Dear Coolberg
Please know thrigger do some calculation for Table1's last inserted record and insert or Update in an another table like Control1 table|||Hello Db experts,
Recently I am facing a problem as, I have a trigger on table1 in after insert
event. When i tried to insert data on table from 4 different source deadlock problem for causing trigger fire. Whenever I removed the trigger no dead lock occured. Can any one help me to handle this deadlock problem.
Nomoskar Mahfuz,
Ami apnake ekta private message diyechi.Doyakore oti porben.Ar apnar problem ti bhalo kore amay bolle kuub balo hoy.Ar apni je trigger ta likhechen ,otar code akhane likle bhalo hoy, mane akhane sobai apnake Banglay likhe bolte anurod koreche.Apni amar likkhe pathan, ba banglay akhane likhun,tahole DBA ra kuub sohoje apnake sahajjo korte parbe.
Bhalo Thakben!!|||Nomoskar Mahfuz,
Ami apnake ekta private message diyechi.Doyakore oti porben.Ar apnar problem ti bhalo kore amay bolle kuub balo hoy.Ar apni je trigger ta likhechen ,otar code akhane likle bhalo hoy, mane akhane sobai apnake Banglay likhe bolte anurod koreche.Apni amar likkhe pathan, ba banglay akhane likhun,tahole DBA ra kuub sohoje apnake sahajjo korte parbe.
Bhalo Thakben!!Easy for you to say! ;) Thanks for the Bengali assistance, I'm sure it will help.
-PatP|||Hello Again,
Sorry for not posting the code before. Please have a look at my code below. Now let me explain what problem I faced,there is a table named Table1 where data being inserted from 4 different sources in huge number (Almost 1000 records/sec), The After Insert trigger(Trigger1) written on Table1 inserts or updates the extracted information from Table1 to Table1_Backup.
Most of the times during Insertion to Table1 I am getting a message as:
"Transaction (Process ID 57) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. "
and I am loosing data in Table1 i.e not all records were inserted.
But when I removed the Trigger , I didn't get this error message and there were no data loss. Looking Forward For any help to come out of this problem.
Code:
create table Table1
(sId int,
sName varchar(50),
sPhone varchar(50),
sBalance bigint
)
create table Table1_Backup
(sId int,
sName varchar(50),
sPhone varchar(50),
sBalance bigint
)
Create TRIGGER Trigger1
ON Table1
After INSERT
AS
Declare
@.counter int,
@.sId int,
@.sName varchar(50),
@.sPhone varchar(30),
@.sBalance bigint;
Begin
set @.counter = 0;
set @.sId = 0;
set @.sName = null;
set @.sPhone = null;
set @.sBalance = 0;
select @.sId = sId,
@.sName = sName,
@.sPhone = sPhone,
@.sBalance = sBalance
from INSERTED Table1;
Select @.counter = @.sId From Table1_Backup WHERE sId = @.sId;
IF (@.counter < 1 )
insert into Table1_Backup
values(@.sId,@.sName,@.sPhone,@.sBalance);
ELSE
Update Table1_Backup
set sBalance = sBalance + @.sBalance
Where sId = @.sId;
End|||Hi Dada,
Nin bangaly bolchi, kintu ami to problem ta post korechi shudhu bangali der jonno noy, ekhane to non bangali o ache. Kintu apnar shahajjo korar icche dhekhe khub valo laglo. Tai apnake bangaly likchi. Amra bangalay kotha (chat) bolte pari jodi apni chan, amar yahoo id hocche "mahfuz_onsky@.yahoo.com".
Asha kori shomadhan ta apnar kachei pabo ebong ekjon bangali dada er kache pele valoi lagbe.
Kotha hobe.
Mahfuz.
Nomoskar Mahfuz,
Ami apnake ekta private message diyechi.Doyakore oti porben.Ar apnar problem ti bhalo kore amay bolle kuub balo hoy.Ar apni je trigger ta likhechen ,otar code akhane likle bhalo hoy, mane akhane sobai apnake Banglay likhe bolte anurod koreche.Apni amar likkhe pathan, ba banglay akhane likhun,tahole DBA ra kuub sohoje apnake sahajjo korte parbe.
Bhalo Thakben!!|||Can you show me the Insert statement that you are using to insert data? By the way which version of Sql server are you running?
It may be a problem in your application code,plz provide the code where you are inserting the data.|||In SQL Server, a trigger fires once for each SQL Statement that launches the trigger, no matter how many rows the original statement might have affected. There could be 1000 or more rows in the INSERTED table for any given execution of your trigger.
There appears to be a logic error inside your trigger, but without knowing exactly what you are trying to do, I can't fix that. The code translated to use sets instead of working one row at a time would be:CREATE TRIGGER Trigger1
ON Table1
After INSERT
AS
INSERT INTO Table1_Backup (
sId, sName, sPhone, sBalance)
SELECT sId, sName, sPhone, sBalance
FROM INSERTED
WHERE sID < 1
UPDATE Table1_Backup
SET sBalance = sBalance + (SELECT Sum(INSERTED.sBalance)
FROM INSERTED
WHERE INSERTED.sId = Table1_Backup.sId)
END-PatPsql
Wednesday, March 21, 2012
Deadlock message
We are seeing deadlock message in the event viewer when
running a transaction in sql server 7.0 database.
Following is the message:
"The description for Event ID ( 4 ) in Source ( TEST)
cannot be found. The local computer may not have the
necessary registry information or message DLL files to
display messages from a remote computer. The following
information is part of the event:
User Id: msqi1
E7009 : The database returned the following message:
com.ms.wfc.data.AdoException: Your transaction (process ID
#36) was deadlocked with another process and has been
chosen as the deadlock victim. Rerun your transaction.
at
com/server/fm/dataservices/ObjectBinder.executeUpdate01_Loc
ks at java/lang/reflect/Method.invoke
at com/server/fm/dataservices/DataServices.update
at com/server/fm/dataservices/DataServices.update
at
com/server/fm/util/dataservices/testLockDataServices.modify
at com/server/test/CCRAInfoEngine.processOutgoingInfo"
The transaction that deadlocks is an execute of a stored
procedure called Update01_locks. This procedure does a
select of a particular row in a table called Locks and
then updates that row. When another transaction selects a
different row and tries to update that row, it deadlocks.
Why is it deadlocked when they are 2 different rows in the
same table. The table Locks has only 3 rows and there are
no indexes.
Please let me know if there is a way to find the cause of
the deadlock and how to resolve it.
Thanks
I am also seeing a deadlock message and trying to investigate the cause
of it.
In the past, I seem to recall being able to set the SQL Server logs so
that they record more information. It seems that these logs, if
detailed enough, should be able to provide clues.
Currently, all I see in the log is a record that my backups are being
done. I know it can be configured to show logon attempts and all sorts
of things, but I can't seem to find the opeions and settings for this
Does anyone know where they are?
Rick.
Gayathri wrote:
> We are seeing deadlock message in the event viewer when
> running a transaction in sql server 7.0 database.
> Following is the message:
> "The description for Event ID ( 4 ) in Source ( TEST)
> cannot be found. The local computer may not have the
> necessary registry information or message DLL files to
> display messages from a remote computer. The following
> information is part of the event:
> User Id: msqi1
> E7009 : The database returned the following message:
> com.ms.wfc.data.AdoException: Your transaction (process ID
> #36) was deadlocked with another process and has been
> chosen as the deadlock victim. Rerun your transaction.
> at
> com/server/fm/dataservices/ObjectBinder.executeUpdate01_Loc
> ks at java/lang/reflect/Method.invoke
> at com/server/fm/dataservices/DataServices.update
> at com/server/fm/dataservices/DataServices.update
> at
> com/server/fm/util/dataservices/testLockDataServices.modify
> at com/server/test/CCRAInfoEngine.processOutgoingInfo"
> The transaction that deadlocks is an execute of a stored
> procedure called Update01_locks. This procedure does a
> select of a particular row in a table called Locks and
> then updates that row. When another transaction selects a
> different row and tries to update that row, it deadlocks.
> Why is it deadlocked when they are 2 different rows in the
> same table. The table Locks has only 3 rows and there are
> no indexes.
> Please let me know if there is a way to find the cause of
> the deadlock and how to resolve it.
> Thanks
running a transaction in sql server 7.0 database.
Following is the message:
"The description for Event ID ( 4 ) in Source ( TEST)
cannot be found. The local computer may not have the
necessary registry information or message DLL files to
display messages from a remote computer. The following
information is part of the event:
User Id: msqi1
E7009 : The database returned the following message:
com.ms.wfc.data.AdoException: Your transaction (process ID
#36) was deadlocked with another process and has been
chosen as the deadlock victim. Rerun your transaction.
at
com/server/fm/dataservices/ObjectBinder.executeUpdate01_Loc
ks at java/lang/reflect/Method.invoke
at com/server/fm/dataservices/DataServices.update
at com/server/fm/dataservices/DataServices.update
at
com/server/fm/util/dataservices/testLockDataServices.modify
at com/server/test/CCRAInfoEngine.processOutgoingInfo"
The transaction that deadlocks is an execute of a stored
procedure called Update01_locks. This procedure does a
select of a particular row in a table called Locks and
then updates that row. When another transaction selects a
different row and tries to update that row, it deadlocks.
Why is it deadlocked when they are 2 different rows in the
same table. The table Locks has only 3 rows and there are
no indexes.
Please let me know if there is a way to find the cause of
the deadlock and how to resolve it.
Thanks
I am also seeing a deadlock message and trying to investigate the cause
of it.
In the past, I seem to recall being able to set the SQL Server logs so
that they record more information. It seems that these logs, if
detailed enough, should be able to provide clues.
Currently, all I see in the log is a record that my backups are being
done. I know it can be configured to show logon attempts and all sorts
of things, but I can't seem to find the opeions and settings for this
Does anyone know where they are?
Rick.
Gayathri wrote:
> We are seeing deadlock message in the event viewer when
> running a transaction in sql server 7.0 database.
> Following is the message:
> "The description for Event ID ( 4 ) in Source ( TEST)
> cannot be found. The local computer may not have the
> necessary registry information or message DLL files to
> display messages from a remote computer. The following
> information is part of the event:
> User Id: msqi1
> E7009 : The database returned the following message:
> com.ms.wfc.data.AdoException: Your transaction (process ID
> #36) was deadlocked with another process and has been
> chosen as the deadlock victim. Rerun your transaction.
> at
> com/server/fm/dataservices/ObjectBinder.executeUpdate01_Loc
> ks at java/lang/reflect/Method.invoke
> at com/server/fm/dataservices/DataServices.update
> at com/server/fm/dataservices/DataServices.update
> at
> com/server/fm/util/dataservices/testLockDataServices.modify
> at com/server/test/CCRAInfoEngine.processOutgoingInfo"
> The transaction that deadlocks is an execute of a stored
> procedure called Update01_locks. This procedure does a
> select of a particular row in a table called Locks and
> then updates that row. When another transaction selects a
> different row and tries to update that row, it deadlocks.
> Why is it deadlocked when they are 2 different rows in the
> same table. The table Locks has only 3 rows and there are
> no indexes.
> Please let me know if there is a way to find the cause of
> the deadlock and how to resolve it.
> Thanks
Deadlock message
We are seeing deadlock message in the event viewer when
running a transaction in sql server 7.0 database.
Following is the message:
"The description for Event ID ( 4 ) in Source ( TEST)
cannot be found. The local computer may not have the
necessary registry information or message DLL files to
display messages from a remote computer. The following
information is part of the event:
User Id: msqi1
E7009 : The database returned the following message:
com.ms.wfc.data.AdoException: Your transaction (process ID
#36) was deadlocked with another process and has been
chosen as the deadlock victim. Rerun your transaction.
at
com/server/fm/dataservices/ObjectBinder.executeUpdate01_Loc
ks at java/lang/reflect/Method.invoke
at com/server/fm/dataservices/DataServices.update
at com/server/fm/dataservices/DataServices.update
at
com/server/fm/util/dataservices/testLockDataServices.modify
at com/server/test/CCRAInfoEngine.processOutgoingInfo"
The transaction that deadlocks is an execute of a stored
procedure called Update01_locks. This procedure does a
select of a particular row in a table called Locks and
then updates that row. When another transaction selects a
different row and tries to update that row, it deadlocks.
Why is it deadlocked when they are 2 different rows in the
same table. The table Locks has only 3 rows and there are
no indexes.
Please let me know if there is a way to find the cause of
the deadlock and how to resolve it.
ThanksI am also seeing a deadlock message and trying to investigate the cause
of it.
In the past, I seem to recall being able to set the SQL Server logs so
that they record more information. It seems that these logs, if
detailed enough, should be able to provide clues.
Currently, all I see in the log is a record that my backups are being
done. I know it can be configured to show logon attempts and all sorts
of things, but I can't seem to find the opeions and settings for this
Does anyone know where they are?
Rick.
Gayathri wrote:
> We are seeing deadlock message in the event viewer when
> running a transaction in sql server 7.0 database.
> Following is the message:
> "The description for Event ID ( 4 ) in Source ( TEST)
> cannot be found. The local computer may not have the
> necessary registry information or message DLL files to
> display messages from a remote computer. The following
> information is part of the event:
> User Id: msqi1
> E7009 : The database returned the following message:
> com.ms.wfc.data.AdoException: Your transaction (process ID
> #36) was deadlocked with another process and has been
> chosen as the deadlock victim. Rerun your transaction.
> at
> com/server/fm/dataservices/ObjectBinder.executeUpdate01_Loc
> ks at java/lang/reflect/Method.invoke
> at com/server/fm/dataservices/DataServices.update
> at com/server/fm/dataservices/DataServices.update
> at
> com/server/fm/util/dataservices/testLockDataServices.modify
> at com/server/test/CCRAInfoEngine.processOutgoingInfo"
> The transaction that deadlocks is an execute of a stored
> procedure called Update01_locks. This procedure does a
> select of a particular row in a table called Locks and
> then updates that row. When another transaction selects a
> different row and tries to update that row, it deadlocks.
> Why is it deadlocked when they are 2 different rows in the
> same table. The table Locks has only 3 rows and there are
> no indexes.
> Please let me know if there is a way to find the cause of
> the deadlock and how to resolve it.
> Thanks
running a transaction in sql server 7.0 database.
Following is the message:
"The description for Event ID ( 4 ) in Source ( TEST)
cannot be found. The local computer may not have the
necessary registry information or message DLL files to
display messages from a remote computer. The following
information is part of the event:
User Id: msqi1
E7009 : The database returned the following message:
com.ms.wfc.data.AdoException: Your transaction (process ID
#36) was deadlocked with another process and has been
chosen as the deadlock victim. Rerun your transaction.
at
com/server/fm/dataservices/ObjectBinder.executeUpdate01_Loc
ks at java/lang/reflect/Method.invoke
at com/server/fm/dataservices/DataServices.update
at com/server/fm/dataservices/DataServices.update
at
com/server/fm/util/dataservices/testLockDataServices.modify
at com/server/test/CCRAInfoEngine.processOutgoingInfo"
The transaction that deadlocks is an execute of a stored
procedure called Update01_locks. This procedure does a
select of a particular row in a table called Locks and
then updates that row. When another transaction selects a
different row and tries to update that row, it deadlocks.
Why is it deadlocked when they are 2 different rows in the
same table. The table Locks has only 3 rows and there are
no indexes.
Please let me know if there is a way to find the cause of
the deadlock and how to resolve it.
ThanksI am also seeing a deadlock message and trying to investigate the cause
of it.
In the past, I seem to recall being able to set the SQL Server logs so
that they record more information. It seems that these logs, if
detailed enough, should be able to provide clues.
Currently, all I see in the log is a record that my backups are being
done. I know it can be configured to show logon attempts and all sorts
of things, but I can't seem to find the opeions and settings for this
Does anyone know where they are?
Rick.
Gayathri wrote:
> We are seeing deadlock message in the event viewer when
> running a transaction in sql server 7.0 database.
> Following is the message:
> "The description for Event ID ( 4 ) in Source ( TEST)
> cannot be found. The local computer may not have the
> necessary registry information or message DLL files to
> display messages from a remote computer. The following
> information is part of the event:
> User Id: msqi1
> E7009 : The database returned the following message:
> com.ms.wfc.data.AdoException: Your transaction (process ID
> #36) was deadlocked with another process and has been
> chosen as the deadlock victim. Rerun your transaction.
> at
> com/server/fm/dataservices/ObjectBinder.executeUpdate01_Loc
> ks at java/lang/reflect/Method.invoke
> at com/server/fm/dataservices/DataServices.update
> at com/server/fm/dataservices/DataServices.update
> at
> com/server/fm/util/dataservices/testLockDataServices.modify
> at com/server/test/CCRAInfoEngine.processOutgoingInfo"
> The transaction that deadlocks is an execute of a stored
> procedure called Update01_locks. This procedure does a
> select of a particular row in a table called Locks and
> then updates that row. When another transaction selects a
> different row and tries to update that row, it deadlocks.
> Why is it deadlocked when they are 2 different rows in the
> same table. The table Locks has only 3 rows and there are
> no indexes.
> Please let me know if there is a way to find the cause of
> the deadlock and how to resolve it.
> Thanks
Deadlock message
We are seeing deadlock message in the event viewer when
running a transaction in sql server 7.0 database.
Following is the message:
"The description for Event ID ( 4 ) in Source ( TEST)
cannot be found. The local computer may not have the
necessary registry information or message DLL files to
display messages from a remote computer. The following
information is part of the event:
User Id: msqi1
E7009 : The database returned the following message:
com.ms.wfc.data.AdoException: Your transaction (process ID
#36) was deadlocked with another process and has been
chosen as the deadlock victim. Rerun your transaction.
at
com/server/fm/dataservices/ObjectBinder.executeUpdate01_Loc
ks at java/lang/reflect/Method.invoke
at com/server/fm/dataservices/DataServices.update
at com/server/fm/dataservices/DataServices.update
at
com/server/fm/util/dataservices/testLockDataServices.modify
at com/server/test/CCRAInfoEngine.processOutgoingInfo"
The transaction that deadlocks is an execute of a stored
procedure called Update01_locks. This procedure does a
select of a particular row in a table called Locks and
then updates that row. When another transaction selects a
different row and tries to update that row, it deadlocks.
Why is it deadlocked when they are 2 different rows in the
same table. The table Locks has only 3 rows and there are
no indexes.
Please let me know if there is a way to find the cause of
the deadlock and how to resolve it.
ThanksI am also seeing a deadlock message and trying to investigate the cause
of it.
In the past, I seem to recall being able to set the SQL Server logs so
that they record more information. It seems that these logs, if
detailed enough, should be able to provide clues.
Currently, all I see in the log is a record that my backups are being
done. I know it can be configured to show logon attempts and all sorts
of things, but I can't seem to find the opeions and settings for this
Does anyone know where they are?
Rick.
Gayathri wrote:
> We are seeing deadlock message in the event viewer when
> running a transaction in sql server 7.0 database.
> Following is the message:
> "The description for Event ID ( 4 ) in Source ( TEST)
> cannot be found. The local computer may not have the
> necessary registry information or message DLL files to
> display messages from a remote computer. The following
> information is part of the event:
> User Id: msqi1
> E7009 : The database returned the following message:
> com.ms.wfc.data.AdoException: Your transaction (process ID
> #36) was deadlocked with another process and has been
> chosen as the deadlock victim. Rerun your transaction.
> at
> com/server/fm/dataservices/ObjectBinder.executeUpdate01_Loc
> ks at java/lang/reflect/Method.invoke
> at com/server/fm/dataservices/DataServices.update
> at com/server/fm/dataservices/DataServices.update
> at
> com/server/fm/util/dataservices/testLockDataServices.modify
> at com/server/test/CCRAInfoEngine.processOutgoingInfo"
> The transaction that deadlocks is an execute of a stored
> procedure called Update01_locks. This procedure does a
> select of a particular row in a table called Locks and
> then updates that row. When another transaction selects a
> different row and tries to update that row, it deadlocks.
> Why is it deadlocked when they are 2 different rows in the
> same table. The table Locks has only 3 rows and there are
> no indexes.
> Please let me know if there is a way to find the cause of
> the deadlock and how to resolve it.
> Thankssql
running a transaction in sql server 7.0 database.
Following is the message:
"The description for Event ID ( 4 ) in Source ( TEST)
cannot be found. The local computer may not have the
necessary registry information or message DLL files to
display messages from a remote computer. The following
information is part of the event:
User Id: msqi1
E7009 : The database returned the following message:
com.ms.wfc.data.AdoException: Your transaction (process ID
#36) was deadlocked with another process and has been
chosen as the deadlock victim. Rerun your transaction.
at
com/server/fm/dataservices/ObjectBinder.executeUpdate01_Loc
ks at java/lang/reflect/Method.invoke
at com/server/fm/dataservices/DataServices.update
at com/server/fm/dataservices/DataServices.update
at
com/server/fm/util/dataservices/testLockDataServices.modify
at com/server/test/CCRAInfoEngine.processOutgoingInfo"
The transaction that deadlocks is an execute of a stored
procedure called Update01_locks. This procedure does a
select of a particular row in a table called Locks and
then updates that row. When another transaction selects a
different row and tries to update that row, it deadlocks.
Why is it deadlocked when they are 2 different rows in the
same table. The table Locks has only 3 rows and there are
no indexes.
Please let me know if there is a way to find the cause of
the deadlock and how to resolve it.
ThanksI am also seeing a deadlock message and trying to investigate the cause
of it.
In the past, I seem to recall being able to set the SQL Server logs so
that they record more information. It seems that these logs, if
detailed enough, should be able to provide clues.
Currently, all I see in the log is a record that my backups are being
done. I know it can be configured to show logon attempts and all sorts
of things, but I can't seem to find the opeions and settings for this
Does anyone know where they are?
Rick.
Gayathri wrote:
> We are seeing deadlock message in the event viewer when
> running a transaction in sql server 7.0 database.
> Following is the message:
> "The description for Event ID ( 4 ) in Source ( TEST)
> cannot be found. The local computer may not have the
> necessary registry information or message DLL files to
> display messages from a remote computer. The following
> information is part of the event:
> User Id: msqi1
> E7009 : The database returned the following message:
> com.ms.wfc.data.AdoException: Your transaction (process ID
> #36) was deadlocked with another process and has been
> chosen as the deadlock victim. Rerun your transaction.
> at
> com/server/fm/dataservices/ObjectBinder.executeUpdate01_Loc
> ks at java/lang/reflect/Method.invoke
> at com/server/fm/dataservices/DataServices.update
> at com/server/fm/dataservices/DataServices.update
> at
> com/server/fm/util/dataservices/testLockDataServices.modify
> at com/server/test/CCRAInfoEngine.processOutgoingInfo"
> The transaction that deadlocks is an execute of a stored
> procedure called Update01_locks. This procedure does a
> select of a particular row in a table called Locks and
> then updates that row. When another transaction selects a
> different row and tries to update that row, it deadlocks.
> Why is it deadlocked when they are 2 different rows in the
> same table. The table Locks has only 3 rows and there are
> no indexes.
> Please let me know if there is a way to find the cause of
> the deadlock and how to resolve it.
> Thankssql
Monday, March 19, 2012
Deadlock isn't logging SQL statements
Hi,
I'm running SQL 2005 SP1 and we're getting some deadlocks. There is nothing
written to the event log. I've turned on 1204 and the log is showing the
deadlock however again, no SQL statements. I see this in the SQL Server log:
Log Viewer could not read information for this log entry. Cause: Data is
Null. This method or property cannot be called on Null values.. Content:.
I've also tried profiling deadlock and deadlock chain events and I can't get
the SQL still. Anyone tell me what I'm doing wrong?
ThanksHi
http://blogs.msdn.com/bartd/archive/2006/09/09/747119.aspx
http://blogs.msdn.com/bartd/archive/2006/09/25/770928.aspx
"sqlboy2000" <sqlboy2000@.discussions.microsoft.com> wrote in message
news:03FDEDA3-935F-458F-81AA-9489BAB1C2B5@.microsoft.com...
> Hi,
> I'm running SQL 2005 SP1 and we're getting some deadlocks. There is
> nothing
> written to the event log. I've turned on 1204 and the log is showing the
> deadlock however again, no SQL statements. I see this in the SQL Server
> log:
> Log Viewer could not read information for this log entry. Cause: Data is
> Null. This method or property cannot be called on Null values.. Content:.
> I've also tried profiling deadlock and deadlock chain events and I can't
> get
> the SQL still. Anyone tell me what I'm doing wrong?
> Thanks
I'm running SQL 2005 SP1 and we're getting some deadlocks. There is nothing
written to the event log. I've turned on 1204 and the log is showing the
deadlock however again, no SQL statements. I see this in the SQL Server log:
Log Viewer could not read information for this log entry. Cause: Data is
Null. This method or property cannot be called on Null values.. Content:.
I've also tried profiling deadlock and deadlock chain events and I can't get
the SQL still. Anyone tell me what I'm doing wrong?
ThanksHi
http://blogs.msdn.com/bartd/archive/2006/09/09/747119.aspx
http://blogs.msdn.com/bartd/archive/2006/09/25/770928.aspx
"sqlboy2000" <sqlboy2000@.discussions.microsoft.com> wrote in message
news:03FDEDA3-935F-458F-81AA-9489BAB1C2B5@.microsoft.com...
> Hi,
> I'm running SQL 2005 SP1 and we're getting some deadlocks. There is
> nothing
> written to the event log. I've turned on 1204 and the log is showing the
> deadlock however again, no SQL statements. I see this in the SQL Server
> log:
> Log Viewer could not read information for this log entry. Cause: Data is
> Null. This method or property cannot be called on Null values.. Content:.
> I've also tried profiling deadlock and deadlock chain events and I can't
> get
> the SQL still. Anyone tell me what I'm doing wrong?
> Thanks
Sunday, March 11, 2012
Deadlock
I recently started seeing a new description in the deadlock event. Anyone
have any idea what the underlying issue might be?
"Parallel query worker thread was involved in a deadlock"
Thanks
Richard
Hi Richard
"Richard Douglass" wrote:
> I recently started seeing a new description in the deadlock event. Anyone
> have any idea what the underlying issue might be?
> "Parallel query worker thread was involved in a deadlock"
> Thanks
> Richard
>
There are quite a few posts for this message if you googled it, such as
http://tinyurl.com/2e346d
John
have any idea what the underlying issue might be?
"Parallel query worker thread was involved in a deadlock"
Thanks
Richard
Hi Richard
"Richard Douglass" wrote:
> I recently started seeing a new description in the deadlock event. Anyone
> have any idea what the underlying issue might be?
> "Parallel query worker thread was involved in a deadlock"
> Thanks
> Richard
>
There are quite a few posts for this message if you googled it, such as
http://tinyurl.com/2e346d
John
Thursday, March 8, 2012
Deadlock
I recently started seeing a new description in the deadlock event. Anyone
have any idea what the underlying issue might be'
"Parallel query worker thread was involved in a deadlock"
Thanks
RichardHi Richard
"Richard Douglass" wrote:
> I recently started seeing a new description in the deadlock event. Anyone
> have any idea what the underlying issue might be'
> "Parallel query worker thread was involved in a deadlock"
> Thanks
> Richard
>
There are quite a few posts for this message if you googled it, such as
http://tinyurl.com/2e346d
John
have any idea what the underlying issue might be'
"Parallel query worker thread was involved in a deadlock"
Thanks
RichardHi Richard
"Richard Douglass" wrote:
> I recently started seeing a new description in the deadlock event. Anyone
> have any idea what the underlying issue might be'
> "Parallel query worker thread was involved in a deadlock"
> Thanks
> Richard
>
There are quite a few posts for this message if you googled it, such as
http://tinyurl.com/2e346d
John
Deadlock
I recently started seeing a new description in the deadlock event. Anyone
have any idea what the underlying issue might be'
"Parallel query worker thread was involved in a deadlock"
Thanks
RichardHi Richard
"Richard Douglass" wrote:
> I recently started seeing a new description in the deadlock event. Anyone
> have any idea what the underlying issue might be'
> "Parallel query worker thread was involved in a deadlock"
> Thanks
> Richard
>
There are quite a few posts for this message if you googled it, such as
http://tinyurl.com/2e346d
John
have any idea what the underlying issue might be'
"Parallel query worker thread was involved in a deadlock"
Thanks
RichardHi Richard
"Richard Douglass" wrote:
> I recently started seeing a new description in the deadlock event. Anyone
> have any idea what the underlying issue might be'
> "Parallel query worker thread was involved in a deadlock"
> Thanks
> Richard
>
There are quite a few posts for this message if you googled it, such as
http://tinyurl.com/2e346d
John
Wednesday, March 7, 2012
ddl trigger question
I made a ddl trigger on database for event group which is
ddl_table_events.
The question is: can I know inside the trigger logic
(after "as" keyword)
which event type of this event group has fired the
trigger?
my code:
use AdventureWorks
go
create trigger
TableEvents
on database
for ddl_table_events
as
select * from
sys.trigger_events
go
I found nothing in sys.trigger_events has
changed inside the trigger.
So finally, I want to know which of "create
table" , "alter table" or "drop
table" has fired the trigger?
Please take a look at the EVENTDATA function. This returns the event that was fired, the command that raised the event and so on. See below topic for more details:
http://msdn2.microsoft.com/en-us/library/ms173781.aspx
DDL Trigger and drop table causes error
I have a DDL Trigger that writes a record into a table when any DDL event happens.
It works great except when I try dropping any object. I get an error at that point and the object is not dropped. The trigger and error are listed below.
Thanks.
J
Trigger:
/****** Object: DdlTrigger [MonitorDBChanges] Script Date: 07/24/2007 11:02:02 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TRIGGER [MonitorDBChanges]
ON DATABASE
FOR DDL_DATABASE_LEVEL_EVENTS
AS
set nocount on
declare @.EventType varchar(100)
declare @.SchemaName varchar(100)
declare @.ObjectName varchar(100)
declare @.ObjectType varchar(100)
declare @.Script varchar(2000)
SELECT
@.EventType = EVENTDATA().value('(/EVENT_INSTANCE/EventType)[1]','nvarchar(max)')
,@.SchemaName = EVENTDATA().value('(/EVENT_INSTANCE/SchemaName)[1]','nvarchar(max)')
,@.ObjectName = EVENTDATA().value('(/EVENT_INSTANCE/ObjectName)[1]','nvarchar(max)')
,@.ObjectType = EVENTDATA().value('(/EVENT_INSTANCE/ObjectType)[1]','nvarchar(max)')
,@.Script = EVENTDATA().value('(/EVENT_INSTANCE/TSQLCommand/CommandText)[1]','nvarchar(max)')
-- Is the default schema used
if @.SchemaName = ' ' select @.SchemaName = default_schema_name from sys.sysusers u join sys.database_principals p
on u.uid = p.principal_id where u.name = CURRENT_USER
insert into MonitorDBChanges
select @.EventType, @.SchemaName, @.ObjectName, @.ObjectType, getdate(), SUSER_SNAME(), CURRENT_USER, ORIGINAL_LOGIN(),@.Script
GO
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER OFF
GO
ENABLE TRIGGER [MonitorDBChanges] ON DATABASE
*******************************************************************************
Error Msg:
SELECT failed because the following SET options have incorrect settings: 'ARITHABORT'. Verify that SET options are correct for use with indexed views and/or indexes on computed columns and/or query notifications and/or xml data type methods. (Microsoft SQL Server, Error: 1934)
Have you tried placing SET ARITHABORT ON along with the ANSI_NULLS and QUOTED_IDENTIFIER options?
WesleyB
Visit my SQL Server weblog @. http://dis4ea.blogspot.com
|||Tried that but I am going to give it another try.|||Confirmed. No difference
Any other ideas?
DCOM Error, Event ID 10016, DTS Server
Hi all,
I have a new SQL Server 2005 Standard SP2 install with just database
services and workstation components installed.
I've noticed the following system event error that appears twice each
time a maintenance task runs (the maintenance tasks do run
successfully):
--
Event Type: Error
Event Source: DCOM
Event Category: None
Event ID: 10016
Date: 20/12/2007
Time: 11:00:00
User: [domain sql agent account]
Computer: [server name]
Description:
The application-specific permission settings do not grant Local Launch
permission for the COM Server application with CLSID
{SID}
to the user [domain sql agent account] SID (SID). This security
permission can be modified using the Component Services administrative
tool.
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
--
I've matched the CLSID given in the error to an entry an entry in the
registry that identifies Microsoft.SqlServer.Dts.Server.DtsServer. In
Component Services, there's a MsDtsServer listed under DCOM config.
Giving the domain sql agent account Local Launch access to this sorts
the error.
I'm a bit confused about this and am tempted to rebuild the server,
but would obviously like to avoid that if possible. I don't have SSIS
installed, so I don't understand why DTS is being used. I'd rather not
have an unnecessary service running, but I also don't want errors
showing up in the event log.
Any idea why this is happening? Does DTS need to be running even
though SSIS isn't installed? Any insight/suggestions are appreciated.
Regards.Hi
Have you checked out http://support.microsoft.com/kb/931355/en-us
John
"RJGiskard" wrote:
> Hi all,
> I have a new SQL Server 2005 Standard SP2 install with just database
> services and workstation components installed.
> I've noticed the following system event error that appears twice each
> time a maintenance task runs (the maintenance tasks do run
> successfully):
> --
> Event Type: Error
> Event Source: DCOM
> Event Category: None
> Event ID: 10016
> Date: 20/12/2007
> Time: 11:00:00
> User: [domain sql agent account]
> Computer: [server name]
> Description:
> The application-specific permission settings do not grant Local Launch
> permission for the COM Server application with CLSID
> {SID}
> to the user [domain sql agent account] SID (SID). This security
> permission can be modified using the Component Services administrative
> tool.
> For more information, see Help and Support Center at
> http://go.microsoft.com/fwlink/events.asp.
> --
> I've matched the CLSID given in the error to an entry an entry in the
> registry that identifies Microsoft.SqlServer.Dts.Server.DtsServer. In
> Component Services, there's a MsDtsServer listed under DCOM config.
> Giving the domain sql agent account Local Launch access to this sorts
> the error.
> I'm a bit confused about this and am tempted to rebuild the server,
> but would obviously like to avoid that if possible. I don't have SSIS
> installed, so I don't understand why DTS is being used. I'd rather not
> have an unnecessary service running, but I also don't want errors
> showing up in the event log.
> Any idea why this is happening? Does DTS need to be running even
> though SSIS isn't installed? Any insight/suggestions are appreciated.
> Regards.
>|||On 20 Dec, 16:41, John Bell <jbellnewspo...@.hotmail.com> wrote:
> Have you checked outhttp://support.microsoft.com/kb/931355/en-us
No, hadn't found that one. We are running SP2 on the W2K3 server, but
I gave that a go. I reveresed the changes I made earlier, tried the
changes suggested, but still get the error.
So is DTS required even though I don't have SSIS isn't installed? I
thought SSIS was the SQL Server 2005 replacement for DTS and that this
DTS Server was just a legacy naming thing but that it's actually SSIS.|||Hi
DTS is still the name behind the scenes.
I think Maintenance plans will use SSIS components, you could replace them
with the T-SQL scripts that do the equivalent tasks if you are using
Maintenance tasks.
John
"RJGiskard" wrote:
> On 20 Dec, 16:41, John Bell <jbellnewspo...@.hotmail.com> wrote:
> > Have you checked outhttp://support.microsoft.com/kb/931355/en-us
> No, hadn't found that one. We are running SP2 on the W2K3 server, but
> I gave that a go. I reveresed the changes I made earlier, tried the
> changes suggested, but still get the error.
> So is DTS required even though I don't have SSIS isn't installed? I
> thought SSIS was the SQL Server 2005 replacement for DTS and that this
> DTS Server was just a legacy naming thing but that it's actually SSIS.
>
I have a new SQL Server 2005 Standard SP2 install with just database
services and workstation components installed.
I've noticed the following system event error that appears twice each
time a maintenance task runs (the maintenance tasks do run
successfully):
--
Event Type: Error
Event Source: DCOM
Event Category: None
Event ID: 10016
Date: 20/12/2007
Time: 11:00:00
User: [domain sql agent account]
Computer: [server name]
Description:
The application-specific permission settings do not grant Local Launch
permission for the COM Server application with CLSID
{SID}
to the user [domain sql agent account] SID (SID). This security
permission can be modified using the Component Services administrative
tool.
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
--
I've matched the CLSID given in the error to an entry an entry in the
registry that identifies Microsoft.SqlServer.Dts.Server.DtsServer. In
Component Services, there's a MsDtsServer listed under DCOM config.
Giving the domain sql agent account Local Launch access to this sorts
the error.
I'm a bit confused about this and am tempted to rebuild the server,
but would obviously like to avoid that if possible. I don't have SSIS
installed, so I don't understand why DTS is being used. I'd rather not
have an unnecessary service running, but I also don't want errors
showing up in the event log.
Any idea why this is happening? Does DTS need to be running even
though SSIS isn't installed? Any insight/suggestions are appreciated.
Regards.Hi
Have you checked out http://support.microsoft.com/kb/931355/en-us
John
"RJGiskard" wrote:
> Hi all,
> I have a new SQL Server 2005 Standard SP2 install with just database
> services and workstation components installed.
> I've noticed the following system event error that appears twice each
> time a maintenance task runs (the maintenance tasks do run
> successfully):
> --
> Event Type: Error
> Event Source: DCOM
> Event Category: None
> Event ID: 10016
> Date: 20/12/2007
> Time: 11:00:00
> User: [domain sql agent account]
> Computer: [server name]
> Description:
> The application-specific permission settings do not grant Local Launch
> permission for the COM Server application with CLSID
> {SID}
> to the user [domain sql agent account] SID (SID). This security
> permission can be modified using the Component Services administrative
> tool.
> For more information, see Help and Support Center at
> http://go.microsoft.com/fwlink/events.asp.
> --
> I've matched the CLSID given in the error to an entry an entry in the
> registry that identifies Microsoft.SqlServer.Dts.Server.DtsServer. In
> Component Services, there's a MsDtsServer listed under DCOM config.
> Giving the domain sql agent account Local Launch access to this sorts
> the error.
> I'm a bit confused about this and am tempted to rebuild the server,
> but would obviously like to avoid that if possible. I don't have SSIS
> installed, so I don't understand why DTS is being used. I'd rather not
> have an unnecessary service running, but I also don't want errors
> showing up in the event log.
> Any idea why this is happening? Does DTS need to be running even
> though SSIS isn't installed? Any insight/suggestions are appreciated.
> Regards.
>|||On 20 Dec, 16:41, John Bell <jbellnewspo...@.hotmail.com> wrote:
> Have you checked outhttp://support.microsoft.com/kb/931355/en-us
No, hadn't found that one. We are running SP2 on the W2K3 server, but
I gave that a go. I reveresed the changes I made earlier, tried the
changes suggested, but still get the error.
So is DTS required even though I don't have SSIS isn't installed? I
thought SSIS was the SQL Server 2005 replacement for DTS and that this
DTS Server was just a legacy naming thing but that it's actually SSIS.|||Hi
DTS is still the name behind the scenes.
I think Maintenance plans will use SSIS components, you could replace them
with the T-SQL scripts that do the equivalent tasks if you are using
Maintenance tasks.
John
"RJGiskard" wrote:
> On 20 Dec, 16:41, John Bell <jbellnewspo...@.hotmail.com> wrote:
> > Have you checked outhttp://support.microsoft.com/kb/931355/en-us
> No, hadn't found that one. We are running SP2 on the W2K3 server, but
> I gave that a go. I reveresed the changes I made earlier, tried the
> changes suggested, but still get the error.
> So is DTS required even though I don't have SSIS isn't installed? I
> thought SSIS was the SQL Server 2005 replacement for DTS and that this
> DTS Server was just a legacy naming thing but that it's actually SSIS.
>
DCOM Error, Event ID 10016, DTS Server
Hi all,
I have a new SQL Server 2005 Standard SP2 install with just database
services and workstation components installed.
I've noticed the following system event error that appears twice each
time a maintenance task runs (the maintenance tasks do run
successfully):
Event Type: Error
Event Source: DCOM
Event Category: None
Event ID: 10016
Date: 20/12/2007
Time: 11:00:00
User: [domain sql agent account]
Computer: [server name]
Description:
The application-specific permission settings do not grant Local Launch
permission for the COM Server application with CLSID
{SID}
to the user [domain sql agent account] SID (SID). This security
permission can be modified using the Component Services administrative
tool.
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
--
I've matched the CLSID given in the error to an entry an entry in the
registry that identifies Microsoft.SqlServer.Dts.Server.DtsServer. In
Component Services, there's a MsDtsServer listed under DCOM config.
Giving the domain sql agent account Local Launch access to this sorts
the error.
I'm a bit confused about this and am tempted to rebuild the server,
but would obviously like to avoid that if possible. I don't have SSIS
installed, so I don't understand why DTS is being used. I'd rather not
have an unnecessary service running, but I also don't want errors
showing up in the event log.
Any idea why this is happening? Does DTS need to be running even
though SSIS isn't installed? Any insight/suggestions are appreciated.
Regards.Hi
Have you checked out http://support.microsoft.com/kb/931355/en-us
John
"RJGiskard" wrote:
> Hi all,
> I have a new SQL Server 2005 Standard SP2 install with just database
> services and workstation components installed.
> I've noticed the following system event error that appears twice each
> time a maintenance task runs (the maintenance tasks do run
> successfully):
> --
> Event Type: Error
> Event Source: DCOM
> Event Category: None
> Event ID: 10016
> Date: 20/12/2007
> Time: 11:00:00
> User: [domain sql agent account]
> Computer: [server name]
> Description:
> The application-specific permission settings do not grant Local Launch
> permission for the COM Server application with CLSID
> {SID}
> to the user [domain sql agent account] SID (SID). This security
> permission can be modified using the Component Services administrative
> tool.
> For more information, see Help and Support Center at
> http://go.microsoft.com/fwlink/events.asp.
> --
> I've matched the CLSID given in the error to an entry an entry in the
> registry that identifies Microsoft.SqlServer.Dts.Server.DtsServer. In
> Component Services, there's a MsDtsServer listed under DCOM config.
> Giving the domain sql agent account Local Launch access to this sorts
> the error.
> I'm a bit confused about this and am tempted to rebuild the server,
> but would obviously like to avoid that if possible. I don't have SSIS
> installed, so I don't understand why DTS is being used. I'd rather not
> have an unnecessary service running, but I also don't want errors
> showing up in the event log.
> Any idea why this is happening? Does DTS need to be running even
> though SSIS isn't installed? Any insight/suggestions are appreciated.
> Regards.
>|||On 20 Dec, 16:41, John Bell <jbellnewspo...@.hotmail.com> wrote:
> Have you checked outhttp://support.microsoft.com/kb/931355/en-us
No, hadn't found that one. We are running SP2 on the W2K3 server, but
I gave that a go. I reveresed the changes I made earlier, tried the
changes suggested, but still get the error.
So is DTS required even though I don't have SSIS isn't installed? I
thought SSIS was the SQL Server 2005 replacement for DTS and that this
DTS Server was just a legacy naming thing but that it's actually SSIS.|||Hi
DTS is still the name behind the scenes.
I think Maintenance plans will use SSIS components, you could replace them
with the T-SQL scripts that do the equivalent tasks if you are using
Maintenance tasks.
John
"RJGiskard" wrote:
> On 20 Dec, 16:41, John Bell <jbellnewspo...@.hotmail.com> wrote:
> No, hadn't found that one. We are running SP2 on the W2K3 server, but
> I gave that a go. I reveresed the changes I made earlier, tried the
> changes suggested, but still get the error.
> So is DTS required even though I don't have SSIS isn't installed? I
> thought SSIS was the SQL Server 2005 replacement for DTS and that this
> DTS Server was just a legacy naming thing but that it's actually SSIS.
>
I have a new SQL Server 2005 Standard SP2 install with just database
services and workstation components installed.
I've noticed the following system event error that appears twice each
time a maintenance task runs (the maintenance tasks do run
successfully):
Event Type: Error
Event Source: DCOM
Event Category: None
Event ID: 10016
Date: 20/12/2007
Time: 11:00:00
User: [domain sql agent account]
Computer: [server name]
Description:
The application-specific permission settings do not grant Local Launch
permission for the COM Server application with CLSID
{SID}
to the user [domain sql agent account] SID (SID). This security
permission can be modified using the Component Services administrative
tool.
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
--
I've matched the CLSID given in the error to an entry an entry in the
registry that identifies Microsoft.SqlServer.Dts.Server.DtsServer. In
Component Services, there's a MsDtsServer listed under DCOM config.
Giving the domain sql agent account Local Launch access to this sorts
the error.
I'm a bit confused about this and am tempted to rebuild the server,
but would obviously like to avoid that if possible. I don't have SSIS
installed, so I don't understand why DTS is being used. I'd rather not
have an unnecessary service running, but I also don't want errors
showing up in the event log.
Any idea why this is happening? Does DTS need to be running even
though SSIS isn't installed? Any insight/suggestions are appreciated.
Regards.Hi
Have you checked out http://support.microsoft.com/kb/931355/en-us
John
"RJGiskard" wrote:
> Hi all,
> I have a new SQL Server 2005 Standard SP2 install with just database
> services and workstation components installed.
> I've noticed the following system event error that appears twice each
> time a maintenance task runs (the maintenance tasks do run
> successfully):
> --
> Event Type: Error
> Event Source: DCOM
> Event Category: None
> Event ID: 10016
> Date: 20/12/2007
> Time: 11:00:00
> User: [domain sql agent account]
> Computer: [server name]
> Description:
> The application-specific permission settings do not grant Local Launch
> permission for the COM Server application with CLSID
> {SID}
> to the user [domain sql agent account] SID (SID). This security
> permission can be modified using the Component Services administrative
> tool.
> For more information, see Help and Support Center at
> http://go.microsoft.com/fwlink/events.asp.
> --
> I've matched the CLSID given in the error to an entry an entry in the
> registry that identifies Microsoft.SqlServer.Dts.Server.DtsServer. In
> Component Services, there's a MsDtsServer listed under DCOM config.
> Giving the domain sql agent account Local Launch access to this sorts
> the error.
> I'm a bit confused about this and am tempted to rebuild the server,
> but would obviously like to avoid that if possible. I don't have SSIS
> installed, so I don't understand why DTS is being used. I'd rather not
> have an unnecessary service running, but I also don't want errors
> showing up in the event log.
> Any idea why this is happening? Does DTS need to be running even
> though SSIS isn't installed? Any insight/suggestions are appreciated.
> Regards.
>|||On 20 Dec, 16:41, John Bell <jbellnewspo...@.hotmail.com> wrote:
> Have you checked outhttp://support.microsoft.com/kb/931355/en-us
No, hadn't found that one. We are running SP2 on the W2K3 server, but
I gave that a go. I reveresed the changes I made earlier, tried the
changes suggested, but still get the error.
So is DTS required even though I don't have SSIS isn't installed? I
thought SSIS was the SQL Server 2005 replacement for DTS and that this
DTS Server was just a legacy naming thing but that it's actually SSIS.|||Hi
DTS is still the name behind the scenes.
I think Maintenance plans will use SSIS components, you could replace them
with the T-SQL scripts that do the equivalent tasks if you are using
Maintenance tasks.
John
"RJGiskard" wrote:
> On 20 Dec, 16:41, John Bell <jbellnewspo...@.hotmail.com> wrote:
> No, hadn't found that one. We are running SP2 on the W2K3 server, but
> I gave that a go. I reveresed the changes I made earlier, tried the
> changes suggested, but still get the error.
> So is DTS required even though I don't have SSIS isn't installed? I
> thought SSIS was the SQL Server 2005 replacement for DTS and that this
> DTS Server was just a legacy naming thing but that it's actually SSIS.
>
Saturday, February 25, 2012
dcdiag error
Hi all,
This morning my dcdiag command show this error
Starting test: systemlog
An Error Event occured. EventID: 0x00000457
Time Generated: 08/24/2007 08:41:46
(Event String could not be retrieved)
An Error Event occured. EventID: 0x00000457
Time Generated: 08/24/2007 08:41:48
(Event String could not be retrieved)
................... myDC failed test systemlog
Anybody can help me with this? or explain to me the error.
Tks
JFBHi
This is not a SQL Server issue, you may want to post in a more appropriate
newsgroup.
John
"JFB" wrote:
> Hi all,
> This morning my dcdiag command show this error
> Starting test: systemlog
> An Error Event occured. EventID: 0x00000457
> Time Generated: 08/24/2007 08:41:46
> (Event String could not be retrieved)
> An Error Event occured. EventID: 0x00000457
> Time Generated: 08/24/2007 08:41:48
> (Event String could not be retrieved)
> ................... myDC failed test systemlog
> Anybody can help me with this? or explain to me the error.
> Tks
> JFB
>
>|||Ups... sorry...
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:5A1ADB7C-D22F-4A9B-A1A3-0DA7A68F5437@.microsoft.com...
> Hi
> This is not a SQL Server issue, you may want to post in a more appropriate
> newsgroup.
> John
> "JFB" wrote:
>> Hi all,
>> This morning my dcdiag command show this error
>> Starting test: systemlog
>> An Error Event occured. EventID: 0x00000457
>> Time Generated: 08/24/2007 08:41:46
>> (Event String could not be retrieved)
>> An Error Event occured. EventID: 0x00000457
>> Time Generated: 08/24/2007 08:41:48
>> (Event String could not be retrieved)
>> ................... myDC failed test systemlog
>> Anybody can help me with this? or explain to me the error.
>> Tks
>> JFB
>>
This morning my dcdiag command show this error
Starting test: systemlog
An Error Event occured. EventID: 0x00000457
Time Generated: 08/24/2007 08:41:46
(Event String could not be retrieved)
An Error Event occured. EventID: 0x00000457
Time Generated: 08/24/2007 08:41:48
(Event String could not be retrieved)
................... myDC failed test systemlog
Anybody can help me with this? or explain to me the error.
Tks
JFBHi
This is not a SQL Server issue, you may want to post in a more appropriate
newsgroup.
John
"JFB" wrote:
> Hi all,
> This morning my dcdiag command show this error
> Starting test: systemlog
> An Error Event occured. EventID: 0x00000457
> Time Generated: 08/24/2007 08:41:46
> (Event String could not be retrieved)
> An Error Event occured. EventID: 0x00000457
> Time Generated: 08/24/2007 08:41:48
> (Event String could not be retrieved)
> ................... myDC failed test systemlog
> Anybody can help me with this? or explain to me the error.
> Tks
> JFB
>
>|||Ups... sorry...
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:5A1ADB7C-D22F-4A9B-A1A3-0DA7A68F5437@.microsoft.com...
> Hi
> This is not a SQL Server issue, you may want to post in a more appropriate
> newsgroup.
> John
> "JFB" wrote:
>> Hi all,
>> This morning my dcdiag command show this error
>> Starting test: systemlog
>> An Error Event occured. EventID: 0x00000457
>> Time Generated: 08/24/2007 08:41:46
>> (Event String could not be retrieved)
>> An Error Event occured. EventID: 0x00000457
>> Time Generated: 08/24/2007 08:41:48
>> (Event String could not be retrieved)
>> ................... myDC failed test systemlog
>> Anybody can help me with this? or explain to me the error.
>> Tks
>> JFB
>>
Subscribe to:
Posts (Atom)