an ASP.NET Open Source CMS & eCommerce platform
Search:
Skip Navigation LinksHome > DotShoppingCart Forums > Support > Using DotShoppingCart > SQL Logs getting filled up
Last Post 11/23/2010 8:55:57 AM By lukezy. 1 replies.
11/21/2010 1:02:40 AM
bansal_db
Posts: 181
Joined: 4/13/2009
SQL Logs getting filled up
Hey Luke,
 
Our SQL server logs get filled every week and if we dont delete them the server runs out of space. Here is the snapshot of the log. Any idea what might be causing the issue?
 
Thanks
 
-D
 
An exception occurred while enqueueing a message in the target queue. Error: 15404, State: 11. Could not obtain information about Windows NT group/user 'W2008WEBX86\Administrator', error code 0x534.
2010-11-21 01:00:07.50 spid26s     Error: 28005, Severity: 16, State: 2.
2010-11-21 01:00:07.50 spid26s     An exception occurred while enqueueing a message in the target queue. Error: 15404, State: 11. Could not obtain information about Windows NT group/user 'W2008WEBX86\Administrator', error code 0x534.
2010-11-21 01:00:07.51 spid26s     Error: 28005, Severity: 16, State: 2.
2010-11-21 01:00:07.51 spid26s     An exception occurred while enqueueing a message in the target queue. Error: 15404, State: 11. Could not obtain information about Windows NT group/user 'W2008WEBX86\Administrator', error code 0x534.
2010-11-21 01:00:07.51 spid26s     Error: 28005, Severity: 16, State: 2.
2010-11-21 01:00:07.51 spid26s     An exception occurred while enqueueing a message in the target queue. Error: 15404, State: 11. Could not obtain information about Windows NT group/user 'W2008WEBX86\Administrator', error code 0x534.
2010-11-21 01:00:07.51 spid26s     Error: 28005, Severity: 16, State: 2.
2010-11-21 01:00:07.51 spid26s     An exception occurred while enqueueing a message in the target queue. Error: 15404, State: 11. Could not obtain information about Windows NT group/user 'W2008WEBX86\Administrator', error code 0x534.
2010-11-21 01:00:07.51 spid26s     Error: 28005, Severity: 16, State: 2.
2010-11-21 01:00:07.51 spid26s     An exception occurred while enqueueing a message in the target queue. Error: 15404, State: 11. Could not obtain information about Windows NT group/user 'W2008WEBX86\Administrator', error code 0x534.
2010-11-21 01:00:07.51 spid26s     Error: 28005, Severity: 16, State: 2.
2010-11-21 01:00:07.51 spid26s     An exception occurred while enqueueing a message in the target queue. Error: 15404, State: 11. Could not obtain information about Windows NT group/user 'W2008WEBX86\Administrator', error code 0x534.
2010-11-21 01:00:07.52 spid26s     Error: 28005, Severity: 16, State: 2.
2010-11-21 01:00:07.52 spid26s     An exception occurred while enqueueing a message in the target queue. Error: 15404, State: 11. Could not obtain information about Windows NT group/user 'W2008WEBX86\Administrator', error code 0x534.
2010-11-21 01:00:07.52 spid26s     Error: 28005, Severity: 16, State: 2.
2010-11-21 01:00:07.52 spid26s     An exception occurred while enqueueing a message in the target queue. Error: 15404, State: 11. Could not obtain information about Windows NT group/user 'W2008WEBX86\Administrator', error code 0x534.
2010-11-21 01:00:07.52 spid26s     Error: 28005, Severity: 16, State: 2.
2010-11-21 01:00:07.52 spid26s     An exception occurred while enqueueing a message in the target queue. Error: 15404, State: 11. Could not obtain information about Windows NT group/user 'W2008WEBX86\Administrator', error code 0x534.
2010-11-21 01:00:07.57 spid26s     Error: 28005, Severity: 16, State: 2.
2010-11-21 01:00:07.57 spid26s     An exception occurred while enqueueing a message in the target queue. Error: 15404, State: 11. Could not obtain information about Windows NT group/user 'W2008WEBX86\Administrator', error code 0x534.
2010-11-21 01:00:07.57 spid27s     The activated proc '[dbo].[SqlQueryNotificationStoredProcedure-74a012b4-df66-4e03-a1d0-0a339a1dd356]' running on queue 'dotshoppingcart.dbo.SqlQueryNotificationService-74a012b4-df66-4e03-a1d0-0a339a1dd356' output the following:  'Could not obtain information about Windows NT group/user 'W2008WEBX86\Administrator', error code 0x534.'
2010-11-21 01:00:07.57 spid28s     The activated proc '[dbo].[SqlQueryNotificationStoredProcedure-456c4324-ccb5-4ac2-958b-5947f8443b0f]' running on queue 'dotshoppingcart.dbo.SqlQueryNotificationService-456c4324-ccb5-4ac2-958b-5947f8443b0f' output the following:  'Could not obtain information about Windows NT group/user 'W2008WEBX86\Administrator', error code 0x534.'
2010-11-21 01:00:07.57 spid29s     The activated proc '[dbo].[SqlQueryNotificationStoredProcedure-47d86326-09c9-475a-b769-b7ebbcf67be5]' running on queue 'dotshoppingcart.dbo.SqlQueryNotificationService-47d86326-09c9-475a-b769-b7ebbcf67be5' output the following:  'Could not obtain information about Windows NT group/user 'W2008WEBX86\Administrator', error code 0x534.'
2010-11-21 01:00:07.57 spid30s     The activated proc '[dbo].[SqlQueryNotificationStoredProcedure-9ff8b9b1-5273-4f8c-9345-a629d1825e8e]' running on queue 'dotshoppingcart.dbo.SqlQueryNotificationService-9ff8b9b1-5273-4f8c-9345-a629d1825e8e' output the following:  'Could not obtain information about Windows NT group/user 'W2008WEBX86\Administrator', error code 0x534.'
2010-11-21 01:00:07.57 spid31s     The activated proc '[dbo].[SqlQueryNotificationStoredProcedure-384d4268-1abc-437f-bf11-9e964d5e7697]' running on queue 'dotshoppingcart.dbo.SqlQueryNotificationService-384d4268-1abc-437f-bf11-9e964d5e7697' output the following:  'Could not obtain information about Windows NT group/user 'W2008WEBX86\Administrator', error code 0x534.'
2010-11-21 01:00:07.57 spid34s     The activated proc '[dbo].[SqlQueryNotificationStoredProcedure-67ac3db0-8ba9-4faf-b981-cbad67a85c8c]' running on queue 'dotshoppingcart.dbo.SqlQueryNotificationService-67ac3db0-8ba9-4faf-b981-cbad67a85c8c' output the following:  'Could not obtain information about Windows NT group/user 'W2008WEBX86\Administrator', error code 0x534.'
2010-11-21 01:00:07.57 spid35s     The activated proc '[dbo].[SqlQueryNotificationStoredProcedure-1a2f632f-d3bc-40e2-accf-b5f319d0edad]' running on queue 'dotshoppingcart.dbo.SqlQueryNotificationService-1a2f632f-d3bc-40e2-accf-b5f319d0edad' output the following:  'Could not obtain information about Windows NT group/user 'W2008WEBX86\Administrator', error code 0x534.'
2010-11-21 01:00:07.57 spid36s     The activated proc '[dbo].[SqlQueryNotificationStoredProcedure-2ec42d8d-8107-4bd0-9363-b16aa0b6d769]' running on queue 'dotshoppingcart.dbo.SqlQueryNotificationService-2ec42d8d-8107-4bd0-9363-b16aa0b6d769' output the following:  'Could not obtain information about Windows NT group/user 'W2008WEBX86\Administrator', error code 0x534.'
2010-11-21 01:00:07.57 spid37s     The activated proc '[dbo].[SqlQueryNotificationStoredProcedure-0c440ea4-5149-4fd0-ac05-debc68ea97d7]' running on queue 'dotshoppingcart.dbo.SqlQueryNotificationService-0c440ea4-5149-4fd0-ac05-debc68ea97d7' output the following:  'Could not obtain information about Windows NT group/user 'W2008WEBX86\Administrator', error code 0x534.'
2010-11-21 01:00:07.57 spid38s     The activated proc '[dbo].[SqlQueryNotificationStoredProcedure-08ae8602-c177-4888-acb7-0343d986c1f7]' running on queue 'dotshoppingcart.dbo.SqlQueryNotificationService-08ae8602-c177-4888-acb7-0343d986c1f7' output the following:  'Could not obtain information about Windows NT group/user 'W2008WEBX86\Administrator', error code 0x534.'
2010-11-21 01:00:07.57 spid39s     The activated proc '[dbo].[SqlQueryNotificationStoredProcedure-615549b3-ed03-41d5-b944-c03946893dae]' running on queue 'dotshoppingcart.dbo.SqlQueryNotificationService-615549b3-ed03-41d5-b944-c03946893dae' output the following:  'Could not obtain information about Windows NT group/user 'W2008WEBX86\Administrator', error code 0x534.'
2010-11-21 01:00:07.57 spid40s     The activated proc '[dbo].[SqlQueryNotificationStoredProcedure-d57b8655-84ea-4117-b9db-e5fb8abced15]' running on queue 'dotshoppingcart.dbo.SqlQueryNotificationService-d57b8655-84ea-4117-b9db-e5fb8abced15' output the following:  'Could not obtain information about Windows NT group/user 'W2008WEBX86\Administrator', error code 0x534.'
2010-11-21 01:00:07.57 spid41s     The activated proc '[dbo].[SqlQueryNotificationStoredProcedure-58181c62-5dad-408d-94b1-224b607bb290]' running on queue 'dotshoppingcart.dbo.SqlQueryNotificationService-58181c62-5dad-408d-94b1-224b607bb290' output the following:  'Could not obtain information about Windows NT group/user 'W2008WEBX86\Administrator', error code 0x534.'
2010-11-21 01:00:07.57 spid42s     The activated proc '[dbo].[SqlQueryNotificationStoredProcedure-0fc500fa-a119-44dc-b4a8-08ca2ae99fc1]' running on queue 'dotshoppingcart.dbo.SqlQueryNotificationService-0fc500fa-a119-44dc-b4a8-08ca2ae99fc1' output the following:  'Could not obtain information about Windows NT group/user 'W2008WEBX86\Administrator', error code 0x534.'
2010-11-21 01:00:07.57 spid43s     The activated proc '[dbo].[SqlQueryNotificationStoredProcedure-4fc72037-6ad6-4d0c-9536-1b842303e193]' running on queue 'dotshoppingcart.dbo.SqlQueryNotificationService-4fc72037-6ad6-4d0c-9536-1b842303e193' output the following:  'Could not obtain information about Windows NT group/user 'W2008WEBX86\Administrator', error code 0x534.'
2010-11-21 01:00:07.57 spid44s     The activated proc '[dbo].[SqlQueryNotificationStoredProcedure-a6334766-7a62-402a-9bef-89732cd04620]' running on queue 'dotshoppingcart.dbo.SqlQueryNotificationService-a6334766-7a62-402a-9bef-89732cd04620' output the following:  'Could not obtain information about Windows NT group/user 'W2008WEBX86\Administrator', error code 0x534.'
2010-11-21 01:00:07.57 spid45s     The activated proc '[dbo].[SqlQueryNotificationStoredProcedure-c2deb0ad-b320-4598-8795-704ca874a338]' running on queue 'dotshoppingcart.dbo.SqlQueryNotificationService-c2deb0ad-b320-4598-8795-704ca874a338' output the following:  'Could not obtain information about Windows NT group/user 'W2008WEBX86\Administrator', error code 0x534.'
2010-11-21 01:00:07.57 spid46s     The activated proc '[dbo].[SqlQueryNotificationStoredProcedure-f12ba44e-7cef-46fb-b495-4406d3046791]' running on queue 'dotshoppingcart.dbo.SqlQueryNotificationService-f12ba44e-7cef-46fb-b495-4406d3046791' output the following:  'Could not obtain information about Windows NT group/user 'W2008WEBX86\Administrator', error code 0x534.'
 
11/23/2010 8:55:57 AM
lukezy
Posts: 2109
Joined: 6/12/2007
Location:WA, US
Re: SQL Logs getting filled up
Take a look at this. Basically you need to delete the stale SQLQueryNotification sprocs , SqlQueryNotificationService in Service Broker.
DotShoppingCart Staff