Service Queue Is Currently Disabled - I See This Error A Lot Of Times

Jun 4, 2007

I use ALTER QUEUE statement to disable a Service Broker QUEUE then i see message -Service Queue is currently disabled every 5 sec in SQL server error Log. How can i stop this messages it is enought to see it only one time?

View 1 Replies


ADVERTISEMENT

Error: The Service Queue ClientQueue Is Currently Disabled.

Nov 16, 2005

Well I downloaded an example (HelloWorld) from www.SQLServiceBroker.com yesterday and it WAS working this morning, however; now I'm getting this error:

View 3 Replies View Related

First Service Broker Attempt, Prajdic's Example, Error: Queue Has Been Disabled

Sep 17, 2007



I am using the Centralized Asynchronous Auditing with Service Broker article example to set up my first Service Broker attempt. We want to start logging search criteria and search results for our product search page. We wanted it to be asynchronous and be stored in another dbase, this seemed like the perfect example.

I modified the example above to save into an Audit table we created and to read a custom message that I generated the XML for. I'm pretty certain that should all work. However, I didn't change much else but I can't get the message to send.

This is the error I'm getting in profiler:
This message could not be delivered because the destination queue has been disabled. Queue ID: 197575742.

I am sending from one database to another within the same SQL server instance. Here are the profiler details
SQL:BatchStarting
EXEC dbo.usp_SendAuditData @X Microsoft SQL Server Management Studio - Query Larry APP1Larry
Broker:Conversation Group Microsoft SQL Server Management Studio - Query Larry
Broker:Conversation STARTED_OUTBOUND Microsoft SQL Server Management Studio - Query Larry
Broker:Conversation CONVERSING Microsoft SQL Server Management Studio - Query Larry
Broker:Message Classify Microsoft SQL Server Management Studio - Query Larry
Broker:Message Undeliverable This message could not be delivered because the destination queue has been disabled. Queue ID: 197575742. Microsoft SQL Server Management Studio - Query Larry APP1Larry
SQL:BatchCompleted
EXEC dbo.usp_SendAuditData @X Microsoft SQL Server Management Studio - Query Larry APP1Larry
Broker:Message Classify
Broker:Remote Message Acknowledgement
Broker:Remote Message Acknowledgement
Broker:Remote Message Acknowledgement
Broker:Message Classify
Broker:Message Undeliverable This message could not be delivered because the destination queue has been disabled. Queue ID: 197575742. sa
Broker:Message Undeliverable This message was dropped because it could not be dispatched on time. State: 2 sa
Broker:Message Undeliverable This message was dropped because it could not be dispatched on time. State: 2 sa


When I run SELECT * FROM sys.transmission_queue I get this in the transmission_status:
"One or more messages could not be delivered to the local service targeted by this dialog."


I'm hoping someone can point me in the right direciton, thanks.

View 11 Replies View Related

Service Queue Disabled

Jan 21, 2008



Hi all -

I have an event in my sql server 2005 box that is fired every 5 seconds. Source MSSQLSERVER event ID 9274.


The activated proc [dbo].[sp_sysmail_activate] running on queue msdb.dbo.ExternalMailQueue output the following: 'The service queue "ExternalMailQueue" is currently disabled.'

I don't know anything about this queue that is mentioned above. How do I disable this message or get rid of that queue?

TIA

View 11 Replies View Related

Target Queue Disabled

Mar 25, 2006

Hi,

I receive messages in my target queue but target queue continously become disabled even aften I enable and receive message it still says target queue is disabled?



Please Guide

View 1 Replies View Related

Error 8355 - Service Broker Is Disabled - How To Confirm?

Oct 26, 2007

During startup one of my servers, containing a default and a named instance of 2005, receives the following error.

Message
Service Broker is disabled in MSDB or MSDB failed to start. Server level event notifications can not be delivered. Event notifications with FAN_IN in other databases could be affected as well.

The system databases for both instances were restored using backups from another instance. How do I confirm if Service Broker is enabled or disabled and why would I get this message? Is it due to restoring master or msdb?

Thanks, Dave

View 5 Replies View Related

An Error Occurred In The Service Broker Internal Activator While Trying To Scan The User Queue '(null)' For Its Status. Error: 2

Apr 25, 2007

Hello - can't find any info on this error - can anyone shed some light?



There was a deadlock - which preceeded this message by 2 seconds.







04/25/2007 08:20:12,spid108,Unknown,An error occurred in the Service Broker internal activator while trying to scan the user queue '(null)' for its status. Error: 2905<c/> State: 1.
04/25/2007 08:20:12,spid108,Unknown,External dump process return code 0x20000001.<nl/>External dump process returned no errors.
04/25/2007 08:20:12,spid108,Unknown,Stack Signature for the dump is 0x1229B5AA
04/25/2007 08:20:12,spid108,Unknown,78132A36 Module(MSVCR80+00002A36)
04/25/2007 08:20:12,spid108,Unknown,781329AA Module(MSVCR80+000029AA)
04/25/2007 08:20:12,spid108,Unknown,01447720 Module(sqlservr+00447720)
04/25/2007 08:20:12,spid108,Unknown,0144789A Module(sqlservr+0044789A)
04/25/2007 08:20:12,spid108,Unknown,0144859B Module(sqlservr+0044859B)
04/25/2007 08:20:12,spid108,Unknown,01447562 Module(sqlservr+00447562)
04/25/2007 08:20:12,spid108,Unknown,01006DAB Module(sqlservr+00006DAB)
04/25/2007 08:20:12,spid108,Unknown,01006BBC Module(sqlservr+00006BBC)
04/25/2007 08:20:12,spid108,Unknown,01006A96 Module(sqlservr+00006A96)
04/25/2007 08:20:12,spid108,Unknown,0112F65C Module(sqlservr+0012F65C)
04/25/2007 08:20:12,spid108,Unknown,0112F70F Module(sqlservr+0012F70F)
04/25/2007 08:20:12,spid108,Unknown,0112CB04 Module(sqlservr+0012CB04)
04/25/2007 08:20:12,spid108,Unknown,0112D1D1 Module(sqlservr+0012D1D1)
04/25/2007 08:20:12,spid108,Unknown,0112EA61 Module(sqlservr+0012EA61)
04/25/2007 08:20:12,spid108,Unknown,0108A5CB Module(sqlservr+0008A5CB)
04/25/2007 08:20:12,spid108,Unknown,0108A56B Module(sqlservr+0008A56B)
04/25/2007 08:20:12,spid108,Unknown,01060A5A Module(sqlservr+00060A5A)
04/25/2007 08:20:12,spid108,Unknown,01476CB2 Module(sqlservr+00476CB2)
04/25/2007 08:20:12,spid108,Unknown,01476FD3 Module(sqlservr+00476FD3)
04/25/2007 08:20:12,spid108,Unknown,017FA720 Module(sqlservr+007FA720)
04/25/2007 08:20:12,spid108,Unknown,017FAADC Module(sqlservr+007FAADC)
04/25/2007 08:20:12,spid108,Unknown,01796B1B Module(sqlservr+00796B1B)
04/25/2007 08:20:12,spid108,Unknown,01793310 Module(sqlservr+00793310)
04/25/2007 08:20:12,spid108,Unknown,0179438B Module(sqlservr+0079438B)
04/25/2007 08:20:12,spid108,Unknown,* Short Stack Dump
04/25/2007 08:20:12,spid108,Unknown,* -------------------------------------------------------------------------------
04/25/2007 08:20:12,spid108,Unknown,* *******************************************************************************
04/25/2007 08:20:12,spid108,Unknown,* SegSs: 00000023:
04/25/2007 08:20:12,spid108,Unknown,* Esp: 1302E584: 13025387 80C87378 80C872F0 00000000 78140001 0009D9C2
04/25/2007 08:20:12,spid108,Unknown,* EFlags: 00010202: 00610067 00650074 0049003B 0076006E 006C0061 00640069
04/25/2007 08:20:12,spid108,Unknown,* SegCs: 0000001B:
04/25/2007 08:20:12,spid108,Unknown,* Ebp: 1302F67C: 1302F788 01793310 13025373 80C872F0 7093AB12 801E8B38
04/25/2007 08:20:12,spid108,Unknown,* Eip: 0179438B: 828B118B 000000E0 C085D0FF 00B9850F 9D890000 FFFFEF8C
04/25/2007 08:20:12,spid108,Unknown,* Edx: 00000E38:
04/25/2007 08:20:12,spid108,Unknown,* Ecx: 00000000:
04/25/2007 08:20:12,spid108,Unknown,* Ebx: 00000000:
04/25/2007 08:20:12,spid108,Unknown,* Eax: A99EE598: 00000000 00000000 A99EE5B0 00000000 00000000 00000000
04/25/2007 08:20:12,spid108,Unknown,* Esi: 00000000:
04/25/2007 08:20:12,spid108,Unknown,* Edi: 80C872F0: 7093AB12 80C87FF0 00000007 B8A20008 7093AB15 00000000
04/25/2007 08:20:12,spid108,Unknown,*
04/25/2007 08:20:12,spid108,Unknown,* dbghelp 14200000 14312FFF 00113000
04/25/2007 08:20:12,spid108,Unknown,* sqlevn70 76780000 76913FFF 00194000
04/25/2007 08:20:12,spid108,Unknown,* sqlevn70 764A0000 76633FFF 00194000
04/25/2007 08:20:12,spid108,Unknown,* sqlevn70 76300000 76493FFF 00194000
04/25/2007 08:20:12,spid108,Unknown,* sqlevn70 341D0000 343AFFFF 001e0000
04/25/2007 08:20:12,spid108,Unknown,* sqlevn70 33590000 33764FFF 001d5000
04/25/2007 08:20:12,spid108,Unknown,* sqlevn70 333F0000 33583FFF 00194000
04/25/2007 08:20:12,spid108,Unknown,* sqlevn70 14490000 1467AFFF 001eb000
04/25/2007 08:20:12,spid108,Unknown,* sqlevn70 13D10000 13EFBFFF 001ec000
04/25/2007 08:20:12,spid108,Unknown,* OLEDB32R 13770000 13780FFF 00011000
04/25/2007 08:20:12,spid108,Unknown,* MSDART 133D0000 133E9FFF 0001a000
04/25/2007 08:20:12,spid108,Unknown,* oledb32 13350000 133C8FFF 00079000
04/25/2007 08:20:12,spid108,Unknown,* msxml3 11BD0000 11CE1FFF 00112000
04/25/2007 08:20:12,spid108,Unknown,* msxmlsql 11AF0000 11BC5FFF 000d6000
04/25/2007 08:20:12,spid108,Unknown,* System.Xml 10FA0000 11193FFF 001f4000
04/25/2007 08:20:12,spid108,Unknown,* System.Security 10F20000 10F61FFF 00042000
04/25/2007 08:20:12,spid108,Unknown,* System 10C10000 10EF3FFF 002e4000
04/25/2007 08:20:12,spid108,Unknown,* System.Security.ni 10A90000 10B45FFF 000b6000
04/25/2007 08:20:12,spid108,Unknown,* System.Transactions 0FAD0000 0FB12FFF 00043000
04/25/2007 08:20:12,spid108,Unknown,* System.ni 7A440000 7ABFDFFF 007be000
04/25/2007 08:20:12,spid108,Unknown,* System.Data 102D0000 10596FFF 002c7000
04/25/2007 08:20:12,spid108,Unknown,* mscorjit 0F910000 0F962FFF 00053000
04/25/2007 08:20:12,spid108,Unknown,* SqlAccess 0F8A0000 0F8F5FFF 00056000
04/25/2007 08:20:12,spid108,Unknown,* SensApi 0F880000 0F884FFF 00005000
04/25/2007 08:20:12,spid108,Unknown,* cryptnet 0F680000 0F691FFF 00012000
04/25/2007 08:20:12,spid108,Unknown,* SOFTPUB 0F670000 0F674FFF 00005000
04/25/2007 08:20:12,spid108,Unknown,* mscorsec 0F640000 0F652FFF 00013000
04/25/2007 08:20:12,spid108,Unknown,* mscorlib.ni 0EAC0000 0F5A7FFF 00ae8000
04/25/2007 08:20:12,spid108,Unknown,* mscorwks 080E0000 08640FFF 00561000
04/25/2007 08:20:12,spid108,Unknown,* xplog70 07CA0000 07CA2FFF 00003000
04/25/2007 08:20:12,spid108,Unknown,* xplog70 07C80000 07C8BFFF 0000c000
04/25/2007 08:20:12,spid108,Unknown,* xpstar90 07C50000 07C75FFF 00026000
04/25/2007 08:20:12,spid108,Unknown,* odbcint 07C30000 07C46FFF 00017000
04/25/2007 08:20:12,spid108,Unknown,* ATL80 7C630000 7C64AFFF 0001b000
04/25/2007 08:20:12,spid108,Unknown,* BatchParser90 07A40000 07A5EFFF 0001f000
04/25/2007 08:20:12,spid108,Unknown,* ODBC32 07A00000 07A3CFFF 0003d000
04/25/2007 08:20:12,spid108,Unknown,* SQLSCM90 079E0000 079E8FFF 00009000
04/25/2007 08:20:12,spid108,Unknown,* xpstar90 07980000 079C7FFF 00048000
04/25/2007 08:20:12,spid108,Unknown,* xpsqlbot 07960000 07965FFF 00006000
04/25/2007 08:20:12,spid108,Unknown,* msftepxy 07490000 074A4FFF 00015000
04/25/2007 08:20:12,spid108,Unknown,* SQLNCLIR 007A0000 007D2FFF 00033000
04/25/2007 08:20:12,spid108,Unknown,* comdlg32 762B0000 762F9FFF 0004a000
04/25/2007 08:20:12,spid108,Unknown,* COMCTL32 77530000 775C6FFF 00097000
04/25/2007 08:20:12,spid108,Unknown,* sqlncli 337A0000 339C1FFF 00222000
04/25/2007 08:20:12,spid108,Unknown,* CLBCatQ 777B0000 77832FFF 00083000
04/25/2007 08:20:12,spid108,Unknown,* xpsp2res 10000000 102C4FFF 002c5000
04/25/2007 08:20:12,spid108,Unknown,* ntdsapi 766F0000 76704FFF 00015000
04/25/2007 08:20:12,spid108,Unknown,* wshtcpip 070B0000 070B7FFF 00008000
04/25/2007 08:20:12,spid108,Unknown,* hnetcfg 071F0000 07248FFF 00059000
04/25/2007 08:20:12,spid108,Unknown,* dssenh 070C0000 070E3FFF 00024000
04/25/2007 08:20:12,spid108,Unknown,* imagehlp 76C10000 76C38FFF 00029000
04/25/2007 08:20:12,spid108,Unknown,* WINTRUST 76BB0000 76BDAFFF 0002b000
04/25/2007 08:20:12,spid108,Unknown,* dbghelp 06C10000 06D22FFF 00113000
04/25/2007 08:20:12,spid108,Unknown,* msfte 069B0000 06C08FFF 00259000
04/25/2007 08:20:12,spid108,Unknown,* security 06190000 06193FFF 00004000
04/25/2007 08:20:12,spid108,Unknown,* rasadhlp 76F80000 76F84FFF 00005000
04/25/2007 08:20:12,spid108,Unknown,* winrnr 76F70000 76F76FFF 00007000
04/25/2007 08:20:12,spid108,Unknown,* DNSAPI 76ED0000 76EF8FFF 00029000
04/25/2007 08:20:12,spid108,Unknown,* RESUTILS 05D50000 05D62FFF 00013000
04/25/2007 08:20:12,spid108,Unknown,* CLUSAPI 05D30000 05D41FFF 00012000
04/25/2007 08:20:12,spid108,Unknown,* OLEAUT32 77D00000 77D8BFFF 0008c000
04/25/2007 08:20:12,spid108,Unknown,* WSOCK32 71BB0000 71BB8FFF 00009000
04/25/2007 08:20:12,spid108,Unknown,* VERSION 77B90000 77B97FFF 00008000
04/25/2007 08:20:12,spid108,Unknown,* MTXCLU 05D10000 05D28FFF 00019000
04/25/2007 08:20:12,spid108,Unknown,* msvcp60 780C0000 78120FFF 00061000
04/25/2007 08:20:12,spid108,Unknown,* MSDTCPRX 05C90000 05D07FFF 00078000
04/25/2007 08:20:12,spid108,Unknown,* XOLEHLP 05C80000 05C85FFF 00006000
04/25/2007 08:20:12,spid108,Unknown,* COMRES 77010000 770D5FFF 000c6000
04/25/2007 08:20:12,spid108,Unknown,* schannel 76750000 76776FFF 00027000
04/25/2007 08:20:12,spid108,Unknown,* cryptdll 766E0000 766EBFFF 0000c000
04/25/2007 08:20:12,spid108,Unknown,* kerberos 05BC0000 05C17FFF 00058000
04/25/2007 08:20:12,spid108,Unknown,* iphlpapi 76CF0000 76D09FFF 0001a000
04/25/2007 08:20:12,spid108,Unknown,* msv1_0 76C90000 76CB6FFF 00027000
04/25/2007 08:20:12,spid108,Unknown,* MSCOREE 05950000 05994FFF 00045000
04/25/2007 08:20:12,spid108,Unknown,* AUTHZ 76C40000 76C53FFF 00014000
04/25/2007 08:20:12,spid108,Unknown,* rsaenh 04E90000 04EBEFFF 0002f000
04/25/2007 08:20:12,spid108,Unknown,* WLDAP32 76F10000 76F3DFFF 0002e000
04/25/2007 08:20:12,spid108,Unknown,* SAMLIB 5CCF0000 5CCFEFFF 0000f000
04/25/2007 08:20:12,spid108,Unknown,* ole32 77670000 777A3FFF 00134000
04/25/2007 08:20:12,spid108,Unknown,* NTMARTA 77E00000 77E21FFF 00022000
04/25/2007 08:20:12,spid108,Unknown,* SQLOS 344D0000 344D4FFF 00005000
04/25/2007 08:20:12,spid108,Unknown,* sqlevn70 4F610000 4F7A3FFF 00194000
04/25/2007 08:20:12,spid108,Unknown,* instapi 48060000 48069FFF 0000a000
04/25/2007 08:20:12,spid108,Unknown,* psapi 76B70000 76B7AFFF 0000b000
04/25/2007 08:20:12,spid108,Unknown,* comctl32 77420000 77522FFF 00103000
04/25/2007 08:20:12,spid108,Unknown,* SHLWAPI 77DA0000 77DF1FFF 00052000
04/25/2007 08:20:12,spid108,Unknown,* SHELL32 7C8D0000 7D0D2FFF 00803000
04/25/2007 08:20:12,spid108,Unknown,* NETAPI32 71C40000 71C97FFF 00058000
04/25/2007 08:20:12,spid108,Unknown,* opends60 333E0000 333E6FFF 00007000
04/25/2007 08:20:12,spid108,Unknown,* USERENV 76920000 769E3FFF 000c4000
04/25/2007 08:20:12,spid108,Unknown,* WS2HELP 71BF0000 71BF7FFF 00008000
04/25/2007 08:20:12,spid108,Unknown,* WS2_32 71C00000 71C16FFF 00017000
04/25/2007 08:20:12,spid108,Unknown,* MSWSOCK 71B20000 71B60FFF 00041000
04/25/2007 08:20:12,spid108,Unknown,* Secur32 76F50000 76F62FFF 00013000
04/25/2007 08:20:12,spid108,Unknown,* MSASN1 76190000 761A1FFF 00012000
04/25/2007 08:20:12,spid108,Unknown,* CRYPT32 761B0000 76242FFF 00093000
04/25/2007 08:20:12,spid108,Unknown,* GDI32 77C00000 77C47FFF 00048000
04/25/2007 08:20:12,spid108,Unknown,* USER32 77380000 77411FFF 00092000
04/25/2007 08:20:12,spid108,Unknown,* RPCRT4 77C50000 77CEEFFF 0009f000
04/25/2007 08:20:12,spid108,Unknown,* ADVAPI32 77F50000 77FEBFFF 0009c000
04/25/2007 08:20:12,spid108,Unknown,* MSVCP80 7C420000 7C4A6FFF 00087000
04/25/2007 08:20:12,spid108,Unknown,* msvcrt 77BA0000 77BF9FFF 0005a000
04/25/2007 08:20:12,spid108,Unknown,* MSVCR80 78130000 781CAFFF 0009b000
04/25/2007 08:20:12,spid108,Unknown,* kernel32 77E40000 77F41FFF 00102000
04/25/2007 08:20:12,spid108,Unknown,* ntdll 7C800000 7C8BFFFF 000c0000
04/25/2007 08:20:12,spid108,Unknown,* sqlservr 01000000 02BCEFFF 01bcf000
04/25/2007 08:20:12,spid108,Unknown,* MODULE BASE END SIZE
04/25/2007 08:20:12,spid108,Unknown,*
04/25/2007 08:20:12,spid108,Unknown,*
04/25/2007 08:20:12,spid108,Unknown,* Access Violation occurred reading address 00000000
04/25/2007 08:20:12,spid108,Unknown,* Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
04/25/2007 08:20:12,spid108,Unknown,* Exception Address = 0179438B Module(sqlservr+0079438B)
04/25/2007 08:20:12,spid108,Unknown,*
04/25/2007 08:20:12,spid108,Unknown,*
04/25/2007 08:20:12,spid108,Unknown,* 04/25/07 08:20:12 spid 108
04/25/2007 08:20:12,spid108,Unknown,* BEGIN STACK DUMP:
04/25/2007 08:20:12,spid108,Unknown,*
04/25/2007 08:20:12,spid108,Unknown,* *******************************************************************************
04/25/2007 08:20:12,spid108,Unknown,SqlDumpExceptionHandler: Process 108 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
04/25/2007 08:20:12,spid108,Unknown,***Stack Dump being sent to D:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLLOGSQLDump0007.txt
04/25/2007 08:20:12,spid108,Unknown,Using 'dbghelp.dll' version '4.0.5'
04/25/2007 08:20:12,spid60,Unknown,An error occurred in the Service Broker internal activator while trying to scan the user queue '(null)' for its status. Error: 2905<c/> State: 1.
04/25/2007 08:20:12,spid60,Unknown,External dump process return code 0x20000001.<nl/>External dump process returned no errors.
04/25/2007 08:20:10,spid60,Unknown,Stack Signature for the dump is 0x1229B5AA
04/25/2007 08:20:10,spid60,Unknown,78132A36 Module(MSVCR80+00002A36)
04/25/2007 08:20:10,spid60,Unknown,781329AA Module(MSVCR80+000029AA)
04/25/2007 08:20:10,spid60,Unknown,01447720 Module(sqlservr+00447720)
04/25/2007 08:20:10,spid60,Unknown,0144789A Module(sqlservr+0044789A)
04/25/2007 08:20:10,spid60,Unknown,0144859B Module(sqlservr+0044859B)
04/25/2007 08:20:10,spid60,Unknown,01447562 Module(sqlservr+00447562)
04/25/2007 08:20:10,spid60,Unknown,01006DAB Module(sqlservr+00006DAB)
04/25/2007 08:20:10,spid60,Unknown,01006BBC Module(sqlservr+00006BBC)
04/25/2007 08:20:10,spid60,Unknown,01006A96 Module(sqlservr+00006A96)
04/25/2007 08:20:10,spid60,Unknown,0112F65C Module(sqlservr+0012F65C)
04/25/2007 08:20:10,spid60,Unknown,0112F70F Module(sqlservr+0012F70F)
04/25/2007 08:20:10,spid60,Unknown,0112CB04 Module(sqlservr+0012CB04)
04/25/2007 08:20:10,spid60,Unknown,0112D1D1 Module(sqlservr+0012D1D1)
04/25/2007 08:20:10,spid60,Unknown,0112EA61 Module(sqlservr+0012EA61)
04/25/2007 08:20:10,spid60,Unknown,0108A5CB Module(sqlservr+0008A5CB)
04/25/2007 08:20:10,spid60,Unknown,0108A56B Module(sqlservr+0008A56B)
04/25/2007 08:20:10,spid60,Unknown,01060A5A Module(sqlservr+00060A5A)
04/25/2007 08:20:10,spid60,Unknown,01476CB2 Module(sqlservr+00476CB2)
04/25/2007 08:20:10,spid60,Unknown,01476FD3 Module(sqlservr+00476FD3)
04/25/2007 08:20:10,spid60,Unknown,017FA720 Module(sqlservr+007FA720)
04/25/2007 08:20:10,spid60,Unknown,017FAADC Module(sqlservr+007FAADC)
04/25/2007 08:20:10,spid60,Unknown,01796B1B Module(sqlservr+00796B1B)
04/25/2007 08:20:10,spid60,Unknown,01793310 Module(sqlservr+00793310)
04/25/2007 08:20:10,spid60,Unknown,0179438B Module(sqlservr+0079438B)
04/25/2007 08:20:10,spid60,Unknown,* Short Stack Dump
04/25/2007 08:20:10,spid60,Unknown,* -------------------------------------------------------------------------------
04/25/2007 08:20:10,spid60,Unknown,* *******************************************************************************
04/25/2007 08:20:10,spid60,Unknown,* SegSs: 00000023:
04/25/2007 08:20:10,spid60,Unknown,* Esp: 1189E584: 11895387 80C87378 80C872F0 00000000 03E90001 00087C2D
04/25/2007 08:20:10,spid60,Unknown,* EFlags: 00010202: 00610067 00650074 0049003B 0076006E 006C0061 00640069
04/25/2007 08:20:10,spid60,Unknown,* SegCs: 0000001B:
04/25/2007 08:20:10,spid60,Unknown,* Ebp: 1189F67C: 1189F788 01793310 11895373 80C872F0 7093AB12 801E8B38
04/25/2007 08:20:10,spid60,Unknown,* Eip: 0179438B: 828B118B 000000E0 C085D0FF 00B9850F 9D890000 FFFFEF8C
04/25/2007 08:20:10,spid60,Unknown,* Edx: 00000E38:
04/25/2007 08:20:10,spid60,Unknown,* Ecx: 00000000:
04/25/2007 08:20:10,spid60,Unknown,* Ebx: 00000000:
04/25/2007 08:20:10,spid60,Unknown,* Eax: 5ADE8598: 00000000 00000000 5ADE85B0 00000000 00000000 00000000
04/25/2007 08:20:10,spid60,Unknown,* Esi: 00000000:
04/25/2007 08:20:10,spid60,Unknown,* Edi: 80C872F0: 7093AB12 80C87FF0 00000007 B8A20008 7093AB15 00000000
04/25/2007 08:20:10,spid60,Unknown,*
04/25/2007 08:20:10,spid60,Unknown,* dbghelp 14200000 14312FFF 00113000
04/25/2007 08:20:10,spid60,Unknown,* sqlevn70 76780000 76913FFF 00194000
04/25/2007 08:20:10,spid60,Unknown,* sqlevn70 764A0000 76633FFF 00194000
04/25/2007 08:20:10,spid60,Unknown,* sqlevn70 76300000 76493FFF 00194000
04/25/2007 08:20:10,spid60,Unknown,* sqlevn70 341D0000 343AFFFF 001e0000
04/25/2007 08:20:10,spid60,Unknown,* sqlevn70 33590000 33764FFF 001d5000
04/25/2007 08:20:10,spid60,Unknown,* sqlevn70 333F0000 33583FFF 00194000
04/25/2007 08:20:10,spid60,Unknown,* sqlevn70 14490000 1467AFFF 001eb000
04/25/2007 08:20:10,spid60,Unknown,* sqlevn70 13D10000 13EFBFFF 001ec000
04/25/2007 08:20:10,spid60,Unknown,* OLEDB32R 13770000 13780FFF 00011000
04/25/2007 08:20:10,spid60,Unknown,* MSDART 133D0000 133E9FFF 0001a000
04/25/2007 08:20:10,spid60,Unknown,* oledb32 13350000 133C8FFF 00079000
04/25/2007 08:20:10,spid60,Unknown,* msxml3 11BD0000 11CE1FFF 00112000
04/25/2007 08:20:10,spid60,Unknown,* msxmlsql 11AF0000 11BC5FFF 000d6000
04/25/2007 08:20:10,spid60,Unknown,* System.Xml 10FA0000 11193FFF 001f4000
04/25/2007 08:20:10,spid60,Unknown,* System.Security 10F20000 10F61FFF 00042000
04/25/2007 08:20:10,spid60,Unknown,* System 10C10000 10EF3FFF 002e4000
04/25/2007 08:20:10,spid60,Unknown,* System.Security.ni 10A90000 10B45FFF 000b6000
04/25/2007 08:20:10,spid60,Unknown,* System.Transactions 0FAD0000 0FB12FFF 00043000
04/25/2007 08:20:10,spid60,Unknown,* System.ni 7A440000 7ABFDFFF 007be000
04/25/2007 08:20:10,spid60,Unknown,* System.Data 102D0000 10596FFF 002c7000
04/25/2007 08:20:10,spid60,Unknown,* mscorjit 0F910000 0F962FFF 00053000
04/25/2007 08:20:10,spid60,Unknown,* SqlAccess 0F8A0000 0F8F5FFF 00056000
04/25/2007 08:20:10,spid60,Unknown,* SensApi 0F880000 0F884FFF 00005000
04/25/2007 08:20:10,spid60,Unknown,* cryptnet 0F680000 0F691FFF 00012000
04/25/2007 08:20:10,spid60,Unknown,* SOFTPUB 0F670000 0F674FFF 00005000
04/25/2007 08:20:10,spid60,Unknown,* mscorsec 0F640000 0F652FFF 00013000
04/25/2007 08:20:10,spid60,Unknown,* mscorlib.ni 0EAC0000 0F5A7FFF 00ae8000
04/25/2007 08:20:10,spid60,Unknown,* mscorwks 080E0000 08640FFF 00561000
04/25/2007 08:20:10,spid60,Unknown,* xplog70 07CA0000 07CA2FFF 00003000
04/25/2007 08:20:10,spid60,Unknown,* xplog70 07C80000 07C8BFFF 0000c000
04/25/2007 08:20:10,spid60,Unknown,* xpstar90 07C50000 07C75FFF 00026000
04/25/2007 08:20:10,spid60,Unknown,* odbcint 07C30000 07C46FFF 00017000
04/25/2007 08:20:10,spid60,Unknown,* ATL80 7C630000 7C64AFFF 0001b000
04/25/2007 08:20:10,spid60,Unknown,* BatchParser90 07A40000 07A5EFFF 0001f000
04/25/2007 08:20:10,spid60,Unknown,* ODBC32 07A00000 07A3CFFF 0003d000
04/25/2007 08:20:10,spid60,Unknown,* SQLSCM90 079E0000 079E8FFF 00009000
04/25/2007 08:20:10,spid60,Unknown,* xpstar90 07980000 079C7FFF 00048000
04/25/2007 08:20:10,spid60,Unknown,* xpsqlbot 07960000 07965FFF 00006000
04/25/2007 08:20:10,spid60,Unknown,* msftepxy 07490000 074A4FFF 00015000
04/25/2007 08:20:10,spid60,Unknown,* SQLNCLIR 007A0000 007D2FFF 00033000
04/25/2007 08:20:10,spid60,Unknown,* comdlg32 762B0000 762F9FFF 0004a000
04/25/2007 08:20:10,spid60,Unknown,* COMCTL32 77530000 775C6FFF 00097000
04/25/2007 08:20:10,spid60,Unknown,* sqlncli 337A0000 339C1FFF 00222000
04/25/2007 08:20:10,spid60,Unknown,* CLBCatQ 777B0000 77832FFF 00083000
04/25/2007 08:20:10,spid60,Unknown,* xpsp2res 10000000 102C4FFF 002c5000
04/25/2007 08:20:10,spid60,Unknown,* ntdsapi 766F0000 76704FFF 00015000
04/25/2007 08:20:10,spid60,Unknown,* wshtcpip 070B0000 070B7FFF 00008000
04/25/2007 08:20:10,spid60,Unknown,* hnetcfg 071F0000 07248FFF 00059000
04/25/2007 08:20:10,spid60,Unknown,* dssenh 070C0000 070E3FFF 00024000
04/25/2007 08:20:10,spid60,Unknown,* imagehlp 76C10000 76C38FFF 00029000
04/25/2007 08:20:10,spid60,Unknown,* WINTRUST 76BB0000 76BDAFFF 0002b000
04/25/2007 08:20:10,spid60,Unknown,* dbghelp 06C10000 06D22FFF 00113000
04/25/2007 08:20:10,spid60,Unknown,* msfte 069B0000 06C08FFF 00259000
04/25/2007 08:20:10,spid60,Unknown,* security 06190000 06193FFF 00004000
04/25/2007 08:20:10,spid60,Unknown,* rasadhlp 76F80000 76F84FFF 00005000
04/25/2007 08:20:10,spid60,Unknown,* winrnr 76F70000 76F76FFF 00007000
04/25/2007 08:20:10,spid60,Unknown,* DNSAPI 76ED0000 76EF8FFF 00029000
04/25/2007 08:20:10,spid60,Unknown,* RESUTILS 05D50000 05D62FFF 00013000
04/25/2007 08:20:10,spid60,Unknown,* CLUSAPI 05D30000 05D41FFF 00012000
04/25/2007 08:20:10,spid60,Unknown,* OLEAUT32 77D00000 77D8BFFF 0008c000
04/25/2007 08:20:10,spid60,Unknown,* WSOCK32 71BB0000 71BB8FFF 00009000
04/25/2007 08:20:10,spid60,Unknown,* VERSION 77B90000 77B97FFF 00008000
04/25/2007 08:20:10,spid60,Unknown,* MTXCLU 05D10000 05D28FFF 00019000
04/25/2007 08:20:10,spid60,Unknown,* msvcp60 780C0000 78120FFF 00061000
04/25/2007 08:20:10,spid60,Unknown,* MSDTCPRX 05C90000 05D07FFF 00078000
04/25/2007 08:20:10,spid60,Unknown,* XOLEHLP 05C80000 05C85FFF 00006000
04/25/2007 08:20:10,spid60,Unknown,* COMRES 77010000 770D5FFF 000c6000
04/25/2007 08:20:10,spid60,Unknown,* schannel 76750000 76776FFF 00027000
04/25/2007 08:20:10,spid60,Unknown,* cryptdll 766E0000 766EBFFF 0000c000
04/25/2007 08:20:10,spid60,Unknown,* kerberos 05BC0000 05C17FFF 00058000
04/25/2007 08:20:10,spid60,Unknown,* iphlpapi 76CF0000 76D09FFF 0001a000
04/25/2007 08:20:10,spid60,Unknown,* msv1_0 76C90000 76CB6FFF 00027000
04/25/2007 08:20:10,spid60,Unknown,* MSCOREE 05950000 05994FFF 00045000
04/25/2007 08:20:10,spid60,Unknown,* AUTHZ 76C40000 76C53FFF 00014000
04/25/2007 08:20:10,spid60,Unknown,* rsaenh 04E90000 04EBEFFF 0002f000
04/25/2007 08:20:10,spid60,Unknown,* WLDAP32 76F10000 76F3DFFF 0002e000
04/25/2007 08:20:10,spid60,Unknown,* SAMLIB 5CCF0000 5CCFEFFF 0000f000
04/25/2007 08:20:10,spid60,Unknown,* ole32 77670000 777A3FFF 00134000
04/25/2007 08:20:10,spid60,Unknown,* NTMARTA 77E00000 77E21FFF 00022000
04/25/2007 08:20:10,spid60,Unknown,* SQLOS 344D0000 344D4FFF 00005000
04/25/2007 08:20:10,spid60,Unknown,* sqlevn70 4F610000 4F7A3FFF 00194000
04/25/2007 08:20:10,spid60,Unknown,* instapi 48060000 48069FFF 0000a000
04/25/2007 08:20:10,spid60,Unknown,* psapi 76B70000 76B7AFFF 0000b000
04/25/2007 08:20:10,spid60,Unknown,* comctl32 77420000 77522FFF 00103000
04/25/2007 08:20:10,spid60,Unknown,* SHLWAPI 77DA0000 77DF1FFF 00052000
04/25/2007 08:20:10,spid60,Unknown,* SHELL32 7C8D0000 7D0D2FFF 00803000
04/25/2007 08:20:10,spid60,Unknown,* NETAPI32 71C40000 71C97FFF 00058000
04/25/2007 08:20:10,spid60,Unknown,* opends60 333E0000 333E6FFF 00007000
04/25/2007 08:20:10,spid60,Unknown,* USERENV 76920000 769E3FFF 000c4000
04/25/2007 08:20:10,spid60,Unknown,* WS2HELP 71BF0000 71BF7FFF 00008000
04/25/2007 08:20:10,spid60,Unknown,* WS2_32 71C00000 71C16FFF 00017000
04/25/2007 08:20:10,spid60,Unknown,* MSWSOCK 71B20000 71B60FFF 00041000
04/25/2007 08:20:10,spid60,Unknown,* Secur32 76F50000 76F62FFF 00013000
04/25/2007 08:20:10,spid60,Unknown,* MSASN1 76190000 761A1FFF 00012000
04/25/2007 08:20:10,spid60,Unknown,* CRYPT32 761B0000 76242FFF 00093000
04/25/2007 08:20:10,spid60,Unknown,* GDI32 77C00000 77C47FFF 00048000
04/25/2007 08:20:10,spid60,Unknown,* USER32 77380000 77411FFF 00092000
04/25/2007 08:20:10,spid60,Unknown,* RPCRT4 77C50000 77CEEFFF 0009f000
04/25/2007 08:20:10,spid60,Unknown,* ADVAPI32 77F50000 77FEBFFF 0009c000
04/25/2007 08:20:10,spid60,Unknown,* MSVCP80 7C420000 7C4A6FFF 00087000
04/25/2007 08:20:10,spid60,Unknown,* msvcrt 77BA0000 77BF9FFF 0005a000
04/25/2007 08:20:10,spid60,Unknown,* MSVCR80 78130000 781CAFFF 0009b000
04/25/2007 08:20:10,spid60,Unknown,* kernel32 77E40000 77F41FFF 00102000
04/25/2007 08:20:10,spid60,Unknown,* ntdll 7C800000 7C8BFFFF 000c0000
04/25/2007 08:20:10,spid60,Unknown,* sqlservr 01000000 02BCEFFF 01bcf000
04/25/2007 08:20:10,spid60,Unknown,* MODULE BASE END SIZE
04/25/2007 08:20:10,spid60,Unknown,*
04/25/2007 08:20:10,spid60,Unknown,*
04/25/2007 08:20:10,spid60,Unknown,* Access Violation occurred reading address 00000000
04/25/2007 08:20:10,spid60,Unknown,* Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
04/25/2007 08:20:10,spid60,Unknown,* Exception Address = 0179438B Module(sqlservr+0079438B)
04/25/2007 08:20:10,spid60,Unknown,*
04/25/2007 08:20:10,spid60,Unknown,*
04/25/2007 08:20:10,spid60,Unknown,* 04/25/07 08:20:10 spid 60
04/25/2007 08:20:10,spid60,Unknown,* BEGIN STACK DUMP:
04/25/2007 08:20:10,spid60,Unknown,*
04/25/2007 08:20:10,spid60,Unknown,* *******************************************************************************
04/25/2007 08:20:10,spid60,Unknown,SqlDumpExceptionHandler: Process 60 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
04/25/2007 08:20:10,spid60,Unknown,***Stack Dump being sent to D:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLLOGSQLDump0006.txt
04/25/2007 08:20:10,spid60,Unknown,Using 'dbghelp.dll' version '4.0.5'

View 5 Replies View Related

How To Log That A Message Has Been Retained In The Transmission_queue When The Queue Is Disabled.

Jun 16, 2007

Hi was wondering whether it is possible to log somewhere outside SB that there are messages in the transmission_queue because the Target queue was disabled.



I was testing this scenario:

try to send messages on a disabled queue and log the problem.



But the transmission_status from the trasmission_queue is always empty.



This is the code that I tried to execute between the send and the commit and after the commit:




WHILE (1=1)

BEGIN

BEGIN DIALOG CONVERSATION .....


SEND ON CONVERSATION ......


if select count(*) from sys.transmission_queue <> 0
BEGIN

set @transmission_status = (select transmission_status from sys.transmission_queue where conversation_handle=@dialog_handle);

if @transmission_status = ''

--Successful send - Exit the LOOP

BEGIN

UPDATE Mytable set isReceivedSuccessfully = 1 where ID = @IDMessageXML;

BREAK;

END

ELSE

raiserror(@transmission_status,1,1) with log;

END

ELSE

BEGIN

UPDATE [dbo].[tblDumpMsg] set isReceivedSuccessfully = 1 where ID = @IDMessageXML;

BREAK;

END

END

COMMIT TRANSACTION;

As I wrote before the @transmission_status variable is always empty and I have the same result even if I put the code after the commit transaction!



Maybe what I'm trying to reach has no sense?


With the event notification I can notify when the queue is disable because the receive rollsback 5 times but what if by mistake the target queue is disabled outside the SB environment? I can I catch it and handle it properly?

Thank you!Marina B

View 3 Replies View Related

Event Notification On Disabled Queue: The Conversation Must End?

Jun 19, 2007

Hello,

I have configured an Event Notification for BROKER_QUEUE_DISABLED.



I created a Queue different from the one the Receive my normal messages and on this queue I define an activation.



The Activated SP takes the [EventNotification] message and execute a

RAISEERROR('Message',0,1) WITH LOG.



The error is properly logged in the SQL server event log but I gave a look the Initiator and target sys.conversation_endpoints catalog view and I have see the the conversations are in the status CONVERSING or SI ...

Do I have to call the END CONVERSATION after the commit or these statuses are caused by some mistakes on the message process workflow?



Thank you

Marina B.

View 4 Replies View Related

Clarifications On Queue Service And Queue Readers

Jan 11, 2006

Hello,
This is info that I am still not certain about and I just need to make sure, my gut feeling is correct:

A.
When a procedure is triggered upon reception of a message in a queue, what happens when the procedure fails and rolls back?
1. Message is left on the Queue.
2. is the worker procedure triggered again for the same message by the queue?
3. I am hoping the Queue keeps on triggering workers until it is empty.

My scenario is that my queue reader procedure only reads one message at a time, thus I do not loop to receive many messages.

B.
For my scenario messages are independent and ordering does not matter.
Thus I want to ensure my Queue reader procedures execute simultaneously. Is reading the Top message in one reader somehow blocking the queue for any other reader procedures? I.e. if I have BEGIN TRANSACTION when reading messages of the Queue, is that effectively going prevent many reader procedures working simultaneously. Again, I want to ensure that Service broker is effectively spawning procedures that work simultaneously.

Thank you very much for the time,

Lubomir

View 5 Replies View Related

Target Queue Disabled: Strange Message On The Event Viewer

Jun 15, 2007

Hello,

I have almost finished to design my Service Broker application and I found out something strange.



I was tring to handle the Target queue disabled scenario, because I want to save to message that was not sent so I can create an alert to the user to say that some messages as not been sent.



To disable to queue I run:

Alter queue [dbo].[Receivedqueue] with status = off



I had the Event Viewer in front of me and I have seen the suddenly it appeared a lot of this informational events:

Event Type: Information
Event Source: MSSQLSERVER
Event Category: (2)
Event ID: 9724
Date: 15/06/2007
Time: 15:00:47

Description:
The activated proc [dbo].[OnReceived] running on queue TestReceiver.dbo.Receivedqueue output the following: 'The current transaction cannot be committed and cannot support operations that write to the log file. Roll back the transaction.'

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.



What this message means?

I would like to avoid to have it because it appears a lot of time and I don't want to fill up my Event Viewer!!



I don't know of it is important but in the moment I executed the code there was not CONVERSING conversation and all the queues were empty.



Somebody has seen this error before or I have to send to the forum the [dbo].[OnReceived] code as well?

thankx



Marina B.

View 3 Replies View Related

Disabled Service Broker

Aug 8, 2007

I have a windows service that uses SqlDependency. It has been working fine until today where it has died. I have traced the problem back to the service broker being disabled, however I have not disabled the service broker. Is there anyway that the service broker can become disabled ?

View 1 Replies View Related

SQL 2012 :: Service Broker Endpoint Is In Disabled Or Stopped State

May 5, 2014

I have a SQL 2012 Enterprise edition HADR cluster with 2 nodes and my event log on the second node (current primary for the AG) is being filled with these messages

The Service Broker endpoint is in disabled or stopped state

I wasn't able to find too much on the issue. I did find this one open Microsoft connect bug report from back in April 2013 [URL] .....

O/S: Windows 2012
SQL Server 2012 v11.0.3412
Currently 1 AG with 1 DB

View 3 Replies View Related

Can See Service Broker Queue With SQL Server Login

Sep 7, 2006

I have an application that is reading a message from a Service Broker Queue. When I use integrated security with an NT account it works fine. When I use a SQL Server User through Management Studio I can select from the Queue however, when I use this same account through the web app with the SQL Server User, I cannot see the Queue. Is there a grant that I must do to this account to get it to see the Service Broker Objects?

Gary

View 2 Replies View Related

Service Broker Queue Reader Question

Aug 31, 2006

I'm creating an app that could potentially send thousands of messages to a Service Broker queue in a matter of seconds. The stored proc that reads records off the queue will call a remote stored procedure for each message to save data in a remote database.

My question is this. How does Service Broker determine how quickly to read those messages off the queue it was sent to? Ideally I'd like Service Broker to do most of its work when SQL Server isn't busy doing other things instead of contending with SQL Server while it's doing perhaps more important work. Is there any way to control this? How does this work?

Thanks very much - Amos

View 3 Replies View Related

The SQL Server Service Broker Or Database Mirroring Transport Is Disabled Or Not Configured

Jul 13, 2007

Hi,



I received an alert 'The SQL Server Service Broker or Database Mirroring transport is disabled or not configured'



How can I check the status of the two? and if they are disabled how do I enable them?

View 6 Replies View Related

SQL Server 2008 :: Service Broker Queue In Database

Feb 3, 2015

I had to restore a database in one of the staging servers the other day. However, upon completion, I found out that the service broker queue in the database is not working anymore. The service broker queue error was similiar to this error:
The activated proc dbo.procedure_name running on queue database_name.dbo.queue_name output the following: '<error message>.'

View 0 Replies View Related

Calling An SSIS Package From A Service Broker Queue

Feb 26, 2007

Posted the same message to the Service Broker forum. But the board is neither responsive nor active. So I am trying this forum. Hope someone can help.

I would like to call an SSIS package from a Service Broker Queue.

There is one way that I am aware of -

Using xp_cmdshell from within an activation stored procedure and using DTEXEC.

Is there a more elegant way of executing an SSIS package from within SSB?

Also,
I am not interested in writing a .NET external activator to process my
messages in the queue. I would like this operation to be strictly
database oriented. Having said this, I am also trying to avoid triggers
processing the messages in the queue.

Thank you!

View 5 Replies View Related

I Made A Mistake About Service Name And The Transmission Queue Got Filled Of Them

Jun 30, 2006

I want to use SSB as a mean to thread multiple SP invocation of the same procedure.

When I launched the initator processes it created in the transmission queue error messages saying for each of them that it is an invalid target service name.

The view (sys.transmission_queue) records them in this way in the status column:

"The target service name could not be found. Ensure that the service name is specified correctly and/or the routing information has been supplied."

Services and queues and activation procedure are all defined into the same database.

I drop services and queues, and i tried to create a service with the initial wrong name. Nothing happened.

Thanks vour your help

View 5 Replies View Related

Performance Counters On Service Broker Transmission Queue

Jan 26, 2007

Hello,

is there built-in support for monitoring the number of elements in the transmission queue via performance counters?

Thanks,

View 4 Replies View Related

Calling SSIS Packages From A Service Broker Queue

Feb 26, 2007

I would like to call an SSIS package from a Service Broker Queue.

There is one way that I am aware of -

Using xp_cmdshell from within an activation stored procedure and using DTEXEC.

Is there a more elegant way of executing an SSIS package from within SSB?

Also, I am not interested in writing a .NET external activator to process my messages in the queue. I would like this operation to be strictly database oriented. Having said this, I am also trying to avoid triggers processing the messages in the queue.

Thank you!

View 6 Replies View Related

SQL Service Broker - How To Resend Messages In Sender Transmission Queue?

Nov 26, 2007



I have a question about SQL Service Broker.

Here are the steps I use to produce the issue.

1) I drop the Service Broker on the Receiver by running the following sql script:


if exists (select * from sys.services where name = N'//TyMetrix360Audit/DataWriter') drop service [//TyMetrix360Audit/DataWriter]

2) I send some messages using the SQL Service broker on the sender side

3) The messages I send stay in sender transmission queue. Here is an example of what my transmission queue looks like after running select * from sys.transmission_queue on the sender.


02C54400-309C-DC11-8EED-0002B3D9F7B5 //TyMetrix360Audit/DataWriter 386DDD04-7E55-466A-BE83-37EFC20910B9 tcp://SFT3DEVSQL01:4022/TyMetrix360Audit/DataSender //TyMetrix360Audit/Contract 2007-11-26 14:58:10.207 0 //TyMetrix360Audit/Message 0 0 0x3C003F0078006D006C002000760065007200730069006F006E003D00220031002E0030002200200065006E0063006F00640069006E0067003D0022007500740066002D003100360022003F003E000D000A003C0045006E0074006500720070007200690073006500410075006400690074004400610074006100200078006D006C006E0073003A007800730069003D00220068007400740070003A002F002F007700770077002E00770033002E006F00720067002F0032003000300031002F0058004D004C0053006300680065006D0061002D0069006E007300740061006E00630065002200200078006D006C006E0073003A007800730064003D00220068007400740070003A002F002F007700770077002E00770033002E006F00720067002F0032003000300031002F0058004D004C0053006300680065006D00610022003E000D000A00200020003C005400610062006C0065004E0061006D0065003E004E004500540057004F0052004B003C002F005400610062006C0065004E0061006D0065003E000D000A00200020003C005000720069006D0061007200790043006F006C0075006D006E004E0061006D0065003E006E006500740077006F0072006B005F00690064003C002F005000720069006D0061007200790043006F006C0075006D006E004E0061006D0065003E000D000A00200020003C004F007000650072006100740069006F006E003E0055003C002F004F007000650072006100740069006F006E003E000D000A00200020003C004400620055007300650072003E00640062006F003C002F004400620055007300650072003E000D000A00200020003C004400610074006100620061007300650020002F003E000D000A00200020003C0044006100740061003E000D000A0020002000200020003C00780073003A0073006300680065006D0061002000690064003D0022004E006500770044006100740061005300650074002200200078006D006C006E0073003D0022002200200078006D006C006E0073003A00780073003D00220068007400740070003A002F002F007700770077002E00770033002E006F00720067002F0032003000300031002F0058004D004C0053006300680065006D0061002200200078006D006C006E0073003A006D00730064006100740061003D002200750072006E003A0073006300680065006D00610073002D006D006900630072006F0073006F00660074002D0063006F006D003A0078006D006C002D006D007300640061007400610022003E000D000A002000200020002000200020003C00780073003A0065006C0065006D0065006E00740020006E0061006D0065003D0022004E00650077004400610074006100530065007400220020006D00730064006100740061003A004900730044006100740061005300650074003D0022007400720075006500220020006D00730064006100740061003A004D00610069006E0044006100740061005400610062006C0065003D0022004400610074006100220020006D00730064006100740061003A00550073006500430075007200720065006E0074004C006F00630061006C0065003D002200740072007500650022003E000D000A00200020002000200020002000200020003C00780073003A0063006F006D0070006C006500780054007900700065003E000D000A0020002000200020002000200020002000200020003C00780073003A00630068006F0069006300650020006D0069006E004F00630063007500720073003D0022003000220020006D00610078004F00630063007500720073003D00220075006E0062006F0075006E0064006500640022003E000D000A002000200020002000200020002000200020002000200020003C00780073003A0065006C0065006D0065006E00740020006E0061006D0065003D002200440061007400610022003E000D000A00200020002000200020002000200020002000200020002000200020003C00780073003A0063006F006D0070006C006500780054007900700065003E000D000A0020002000200020002000200020002000200020002000200020002000200020003C00780073003A00730065007100750065006E00630065003E000D000A002000200020002000200020002000200020002000200020002000200020002000200020003C00780073003A0065006C0065006D0065006E00740020006E0061006D0065003D0022006E006500740077006F0072006B005F00690064002200200074007900700065003D002200780073003A0069006E007400220020006D0069006E004F00630063007500720073003D0022003000220020002F003E000D000A002000200020002000200020002000200020002000200020002000200020002000200020003C00780073003A0065006C0065006D0065006E00740020006E0061006D0065003D0022006E006500740077006F0072006B005F006E0061006D0065002200200074007900700065003D002200780073003A0073007400720069006E006700220020006D0069006E004F00630063007500720073003D0022003000220020002F003E000D000A0020002000200020002000200020002000200020002000200020002000200020003C002F00780073003A00730065007100750065006E00630065003E000D000A00200020002000200020002000200020002000200020002000200020003C002F00780073003A0063006F006D0070006C006500780054007900700065003E000D000A002000200020002000200020002000200020002000200020003C002F00780073003A0065006C0065006D0065006E0074003E000D000A0020002000200020002000200020002000200020003C002F00780073003A00630068006F006900630065003E000D000A00200020002000200020002000200020003C002F00780073003A0063006F006D0070006C006500780054007900700065003E000D000A002000200020002000200020003C002F00780073003A0065006C0065006D0065006E0074003E000D000A0020002000200020003C002F00780073003A0073006300680065006D0061003E000D000A0020002000200020003C006400690066006600670072003A0064006900660066006700720061006D00200078006D006C006E0073003A006D00730064006100740061003D002200750072006E003A0073006300680065006D00610073002D006D006900630072006F0073006F00660074002D0063006F006D003A0078006D006C002D006D00730064006100740061002200200078006D006C006E0073003A006400690066006600670072003D002200750072006E003A0073006300680065006D00610073002D006D006900630072006F0073006F00660074002D0063006F006D003A0078006D006C002D0064006900660066006700720061006D002D007600310022003E000D000A002000200020002000200020003C0044006F00630075006D0065006E00740045006C0065006D0065006E0074003E000D000A00200020002000200020002000200020003C00440061007400610020006400690066006600670072003A00690064003D00220044006100740061003100220020006D00730064006100740061003A0072006F0077004F0072006400650072003D002200300022003E000D000A0020002000200020002000200020002000200020003C006E006500740077006F0072006B005F00690064003E0031003C002F006E006500740077006F0072006B005F00690064003E000D000A0020002000200020002000200020002000200020003C006E006500740077006F0072006B005F006E0061006D0065003E00780066006400660064006600640066003C002F006E006500740077006F0072006B005F006E0061006D0065003E000D000A00200020002000200020002000200020003C002F0044006100740061003E000D000A002000200020002000200020003C002F0044006F00630075006D0065006E00740045006C0065006D0065006E0074003E000D000A0020002000200020003C002F006400690066006600670072003A0064006900660066006700720061006D003E000D000A00200020003C002F0044006100740061003E000D000A00200020003C004F007000650072006100740069006F006E00540069006D0065003E0032003000300037002D00310031002D00320036005400310034003A00350038003A00310030002E0030003900380036003100350035005A003C002F004F007000650072006100740069006F006E00540069006D0065003E000D000A00200020003C0042006C006F00620043006F006C0075006D006E004E0061006D006500730020002F003E000D000A00200020003C0042006C006F00620047005500490044003E00630061006200610037006500660039002D0066003500650065002D0034006200370035002D0061006400360030002D003000390063003500330038003500640031003100310031003C002F0042006C006F00620047005500490044003E000D000A003C002F0045006E00740065007200700072006900730065004100750064006900740044006100740061003E00 Service Broker received an error message on this conversation. Service Broker will not transmit the message; it will be held until the application ends the conversation.
F620FA2D-309C-DC11-8EED-0002B3D9F7B5 //TyMetrix360Audit/DataWriter 386DDD04-7E55-466A-BE83-37EFC20910B9 tcp://SFT3DEVSQL01:4022/TyMetrix360Audit/DataSender //TyMetrix360Audit/Contract 2007-11-26 14:59:26.813 0 //TyMetrix360Audit/Message 0 0 0x3C003F0078006D006C002000760065007200730069006F006E003D00220031002E0030002200200065006E0063006F00640069006E0067003D0022007500740066002D003100360022003F003E000D000A003C0045006E0074006500720070007200690073006500410075006400690074004400610074006100200078006D006C006E0073003A007800730069003D00220068007400740070003A002F002F007700770077002E00770033002E006F00720067002F0032003000300031002F0058004D004C0053006300680065006D0061002D0069006E007300740061006E00630065002200200078006D006C006E0073003A007800730064003D00220068007400740070003A002F002F007700770077002E00770033002E006F00720067002F0032003000300031002F0058004D004C0053006300680065006D00610022003E000D000A00200020003C005400610062006C0065004E0061006D0065003E004E004500540057004F0052004B003C002F005400610062006C0065004E0061006D0065003E000D000A00200020003C005000720069006D0061007200790043006F006C0075006D006E004E0061006D0065003E006E006500740077006F0072006B005F00690064003C002F005000720069006D0061007200790043006F006C0075006D006E004E0061006D0065003E000D000A00200020003C004F007000650072006100740069006F006E003E0055003C002F004F007000650072006100740069006F006E003E000D000A00200020003C004400620055007300650072003E00640062006F003C002F004400620055007300650072003E000D000A00200020003C004400610074006100620061007300650020002F003E000D000A00200020003C0044006100740061003E000D000A0020002000200020003C00780073003A0073006300680065006D0061002000690064003D0022004E006500770044006100740061005300650074002200200078006D006C006E0073003D0022002200200078006D006C006E0073003A00780073003D00220068007400740070003A002F002F007700770077002E00770033002E006F00720067002F0032003000300031002F0058004D004C0053006300680065006D0061002200200078006D006C006E0073003A006D00730064006100740061003D002200750072006E003A0073006300680065006D00610073002D006D006900630072006F0073006F00660074002D0063006F006D003A0078006D006C002D006D007300640061007400610022003E000D000A002000200020002000200020003C00780073003A0065006C0065006D0065006E00740020006E0061006D0065003D0022004E00650077004400610074006100530065007400220020006D00730064006100740061003A004900730044006100740061005300650074003D0022007400720075006500220020006D00730064006100740061003A004D00610069006E0044006100740061005400610062006C0065003D0022004400610074006100220020006D00730064006100740061003A00550073006500430075007200720065006E0074004C006F00630061006C0065003D002200740072007500650022003E000D000A00200020002000200020002000200020003C00780073003A0063006F006D0070006C006500780054007900700065003E000D000A0020002000200020002000200020002000200020003C00780073003A00630068006F0069006300650020006D0069006E004F00630063007500720073003D0022003000220020006D00610078004F00630063007500720073003D00220075006E0062006F0075006E0064006500640022003E000D000A002000200020002000200020002000200020002000200020003C00780073003A0065006C0065006D0065006E00740020006E0061006D0065003D002200440061007400610022003E000D000A00200020002000200020002000200020002000200020002000200020003C00780073003A0063006F006D0070006C006500780054007900700065003E000D000A0020002000200020002000200020002000200020002000200020002000200020003C00780073003A00730065007100750065006E00630065003E000D000A002000200020002000200020002000200020002000200020002000200020002000200020003C00780073003A0065006C0065006D0065006E00740020006E0061006D0065003D0022006E006500740077006F0072006B005F00690064002200200074007900700065003D002200780073003A0069006E007400220020006D0069006E004F00630063007500720073003D0022003000220020002F003E000D000A002000200020002000200020002000200020002000200020002000200020002000200020003C00780073003A0065006C0065006D0065006E00740020006E0061006D0065003D0022006E006500740077006F0072006B005F006E0061006D0065002200200074007900700065003D002200780073003A0073007400720069006E006700220020006D0069006E004F00630063007500720073003D0022003000220020002F003E000D000A0020002000200020002000200020002000200020002000200020002000200020003C002F00780073003A00730065007100750065006E00630065003E000D000A00200020002000200020002000200020002000200020002000200020003C002F00780073003A0063006F006D0070006C006500780054007900700065003E000D000A002000200020002000200020002000200020002000200020003C002F00780073003A0065006C0065006D0065006E0074003E000D000A0020002000200020002000200020002000200020003C002F00780073003A00630068006F006900630065003E000D000A00200020002000200020002000200020003C002F00780073003A0063006F006D0070006C006500780054007900700065003E000D000A002000200020002000200020003C002F00780073003A0065006C0065006D0065006E0074003E000D000A0020002000200020003C002F00780073003A0073006300680065006D0061003E000D000A0020002000200020003C006400690066006600670072003A0064006900660066006700720061006D00200078006D006C006E0073003A006D00730064006100740061003D002200750072006E003A0073006300680065006D00610073002D006D006900630072006F0073006F00660074002D0063006F006D003A0078006D006C002D006D00730064006100740061002200200078006D006C006E0073003A006400690066006600670072003D002200750072006E003A0073006300680065006D00610073002D006D006900630072006F0073006F00660074002D0063006F006D003A0078006D006C002D0064006900660066006700720061006D002D007600310022003E000D000A002000200020002000200020003C0044006F00630075006D0065006E00740045006C0065006D0065006E0074003E000D000A00200020002000200020002000200020003C00440061007400610020006400690066006600670072003A00690064003D00220044006100740061003100220020006D00730064006100740061003A0072006F0077004F0072006400650072003D002200300022003E000D000A0020002000200020002000200020002000200020003C006E006500740077006F0072006B005F00690064003E0031003C002F006E006500740077006F0072006B005F00690064003E000D000A0020002000200020002000200020002000200020003C006E006500740077006F0072006B005F006E0061006D0065003E00780066006400660064006600640066003C002F006E006500740077006F0072006B005F006E0061006D0065003E000D000A00200020002000200020002000200020003C002F0044006100740061003E000D000A002000200020002000200020003C002F0044006F00630075006D0065006E00740045006C0065006D0065006E0074003E000D000A0020002000200020003C002F006400690066006600670072003A0064006900660066006700720061006D003E000D000A00200020003C002F0044006100740061003E000D000A00200020003C004F007000650072006100740069006F006E00540069006D0065003E0032003000300037002D00310031002D00320036005400310034003A00350039003A00320036002E0037003800340036003400330031005A003C002F004F007000650072006100740069006F006E00540069006D0065003E000D000A00200020003C0042006C006F00620043006F006C0075006D006E004E0061006D006500730020002F003E000D000A00200020003C0042006C006F00620047005500490044003E00350034006300380036006200330036002D0061006300330066002D0034006600300034002D0062006600660066002D003400310062003800310065003500360035006500360066003C002F0042006C006F00620047005500490044003E000D000A003C002F0045006E00740065007200700072006900730065004100750064006900740044006100740061003E00 Service Broker received an error message on this conversation. Service Broker will not transmit the message; it will be held until the application ends the conversation.


The main point is that the sys.transmission queue retains the messages with the error 'Service Broker will not transmit the message; it will be held until the application ends the conversation.'

4. I execute the following sql statment on the sender:

select * from sys.conversation_endpoints

and see that the conversation that sent the messages are in state 'ER'

5. I then recreate the receiver with the following script:


create service [//TyMetrix360Audit/DataWriter] authorization dbo on queue dbo.TyMetrix360AuditQueue([//TyMetrix360Audit/Contract])

6. I send some more messages and see that the new messages are being received and processed correctly.

7. But what of the messages stuck in the sender transmission queue. How are these messages to be resent? Since the conversations are in state 'ER' it seems they are not being resent. Do I need to write a custom SQL script to resend them? I do not want to end the conversation because the message will be lost and not resent.


So, in conclusion, the main question is:

When the receiver goes down, or the receiver service broker simply does not exist and messages pile up the sender transmission queue like in my example how do these messages get resent when the receiver is restored?

By the way when I run

select service_broker_guid from sys.databases where database_id = db_id()

I get the same GUID after the server is restored.

Thanks

View 5 Replies View Related

SQL Service Broker - How To Resend Messages Stuck In Sender Transmission Queue

Nov 26, 2007

Here is a description:

1. drop receiver side service broker with sql command : drop service [//TyMetrix360Audit/DataWriter]

2. send a message from the sender.

3. now the sys.transmission_queue on the sender keeps the message.

The relevant tables on the sender and receiver no look like this:

the following summarizes the transmission queue on the SENDER:

conversation handle message_body transmission status
5A0F1D1F-449C-DC11-8EED-0002B3D9F7B5 my message in binary, ie 0x.F4E1.... <blank>

the following summarizes the sys.conversation_endpoints on the SENDER:

conversation handle conversation_id state
5A0F1D1F-449C-DC11-8EED-0002B3D9F7B5 461891C8-5D53-4D89-A7C6-097FE2EDB22A CO

the following summarizes the transmission queue on the RECEIVER:

conversation handle message_body transmission status
5A0F1D1F-449C-DC11-8EED-0002B3D9F7B5 message body of error message...... One or more messages could not be delivered to the local service targeted by this dialog.

the following summarizes the sys.conversation_endpoints on the RECEIVER:

conversation handle conversation_id state
5A0F1D1F-449C-DC11-8EED-0002B3D9F7B5 461891C8-5D53-4D89-A7C6-097FE2EDB22A DO


What do I do now?

There is a message stuck in the sender transmission queue. You responded in my last post that I need to do a RECIEVE on the sender and end the conversation myself? This is not helping me. I am still confused about the answer to this. Can you provide some sort of code outline or steps to resolve this issue. As of now I do not know how to resend my messages stuck in the sender transmission queue and they can not be lost when the conversation is ended.

Also, I thought SQL Service broker was supposed to hadle things like this. It is common for the receiver to not be there. In this case the messages should resend automatically once the receiver is back up. Please help as there is no documentation online about how to resolve this issue and your last response was not adequate.

Thanks

View 3 Replies View Related

Service Broker Is Disabled In MSDB Or MSDB Failed To Start

Nov 21, 2005

Whenever I start my SQL Express 2005 database, I get the following in the logs :

View 10 Replies View Related

The Account Is Disabled. (MSSQL, Error: 18470)

Jan 1, 2006

Hi, need help

Yesterday Installed MSSQL Server 2005 Developer Edition
on Windows XP SP2
IIS 5.1
Windows Authentication
login/psw the same as login to Windows

Everything was ok, can log to server and play with Database Engine

But today can't login.


================================================== =====

TITLE: Connect to Server
Cannot connect to MyPCName.
ADDITIONAL INFORMATION:
Login failed for user 'MyPCNameMyLogin'. Reason: The account is disabled. (MS Server, Error: 18470)

------------------------------
Server Name: MyPCName
Error Number: 18470
Severity: 14
State: 1
Line Number: 65536

------------------------------
Program Location:

at System.Data.SqlClient.SqlInternalConnection.OnErro r(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndW arning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlInternalConnectionTds.Com pleteLogin(Boolean enlistOK)
at System.Data.SqlClient.SqlInternalConnectionTds.Ope nLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlInternalConnectionTds..ct or(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlConnectionFactory.CreateC onnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionFactory.Creat eNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup)
at System.Data.ProviderBase.DbConnectionFactory.GetCo nnection(DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenCo nnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.SqlClient.SqlConnection.Open()
at Microsoft.SqlServer.Management.UI.VSIntegration.Ob jectExplorer.ObjectExplorer.ValidateConnection(UIC onnectionInfo ci, IServerType server)
at Microsoft.SqlServer.Management.UI.ConnectionDlg.Co nnector.ConnectionThreadUser()
================================================== ====

Is it possible to enable this account again?

View 3 Replies View Related

Error: Generating Instances In SQL Server Is Disabled...

Mar 13, 2007

Use sp_configure 'user instances enabled' to generate user instances.

I get the above error when I attempt to add an SQL Database item into my VS (C#) project. I do not understand what needs to be done to correct the problem.

Any help is appreciated.

Thank You,

Klaus

View 15 Replies View Related

ERROR [HY000] Or ERROR [23000] At Random Times When Using Sql Native Client Via ODBC

Apr 16, 2008

The following (VB.Net) code causes exceptions at seemingly random times.
Any suggestions?
Not sure if the problem is in .Net's ODBC support or in Sql Native Client.

If MARS is off, usually after less than 100 loops:



Code Snippet

System.Data.Odbc.OdbcException was unhandled
ErrorCode=-2146232009
Message="ERROR [HY000] [Microsoft][SQL Native Client]Connection is busy with results for another command"
Source="SQLNCLI.DLL"
Turning MARS is on bypasses that error, so it will sometimes survive a thousand or so runs before hitting:




Code Snippet

System.Data.Odbc.OdbcException was unhandled
ErrorCode=-2146232009
Message="ERROR [23000] [Microsoft][SQL Native Client][SQL Server]Cannot insert the value NULL into column 'Number', table 'tempdb.dbo.#TempTable___..(shortened to fit).. _________000000002F3F'; column does not allow nulls. INSERT fails.
Source="SQLNCLI.DLL"
Code here:
(Console Application, empty database,
Visual Studio 2005, .Net 2.0, Windows XP,SQL Server 2005 or SQL Express 2005, Local or Remote)





Code Snippet

Module Module1

Sub Main()

'Dim connection As New SqlClient.SqlConnection("database=TestDB;server=.sqlexpress;Integrated Security=SSPI;") 'Doesn't crash
'Dim connection As New OleDb.OleDbConnection("Provider=SQLNCLI;database=TestDB;Server=.sqlexpress;Trusted_Connection=yes;") 'Doesn't crash

'Dim connection As New Odbc.OdbcConnection("Driver={SQL Native Client};Database=TestDB;Server=.sqlexpress;Trusted_Connection=yes;") 'Crashes
Dim connection As New Odbc.OdbcConnection("Driver={SQL Native Client};Database=TestDB;Server=.sqlexpress;Trusted_Connection=yes;MARS_Connection=yes") 'Crashes

VBMath.Randomize()

Dim run_count As Integer = 1
connection.Open()
Console.WriteLine("Connected!!")

While True
'connection.Open()

Dim testcmd As New Odbc.OdbcCommand("CREATE TABLE [#TempTable] (Number int PRIMARY KEY)", connection)
testcmd.ExecuteNonQuery()
testcmd.Dispose()
testcmd = Nothing

Dim dtTemp As New DataTable
Dim daTemp As New Odbc.OdbcDataAdapter("SELECT * FROM [#TempTable]", connection)
daTemp.MissingSchemaAction = MissingSchemaAction.AddWithKey
daTemp.Fill(dtTemp)
Dim cbTemp As New Odbc.OdbcCommandBuilder(daTemp)
Dim viewTemp As New DataView(dtTemp, Nothing, "Number", DataViewRowState.CurrentRows)

Dim i As Integer
For i = 1 To 1000
Dim test_number As Integer = CInt(Rnd() * 2000)
If viewTemp.Find(test_number) = -1 Then 'Keep it unique
Dim new_temp_row As DataRowView = viewTemp.AddNew()
new_temp_row("Number") = test_number
new_temp_row.EndEdit()
End If
Next

daTemp.Update(dtTemp)

'daTemp.Dispose()
'daTemp = Nothing

'cbTemp.Dispose()
'cbTemp = Nothing

'dtTemp.Dispose()
'dtTemp = Nothing

'viewTemp.Dispose()
'viewTemp = Nothing


Dim testcmd2 As New Odbc.OdbcCommand("DROP TABLE [#TempTable]", connection)
testcmd2.ExecuteNonQuery()
testcmd2.Dispose()
testcmd2 = Nothing

'connection.Close()
'GC.Collect()

'Console.Write(".")
run_count += 1
End While

End Sub

End Module

Usually the ".Update" triggers the exception, but sometimes the other sql commands do it.
Have tried various experiments with disposing of objects immediately when finished, but no effect.
Opening and closing the connection each loop seems to delay the errors, but it still happens eventually.

View 7 Replies View Related

Error Processing Cube With Disabled Lowest Level Of Shared Dimension

Jul 23, 2005

Hi,This is probably a classic scenario with a shared dimension that weneed to use in different cubes, where all fact tables do not offer thesame level of detail. Dimension is snow-flaked.The cube that's causing me troubles was designed by marking the lowestdimension level Diabled and not Visible. This allows me to get rid ofone of the snow-flake tables (the one with the lowest level), thusallowing an INNER JOIN with the remaining table which has a level ofdetail corresponding to the fact table.When processing the cube, I get a 'member with key '[blah]' was foundin the fact table but was not found in the level '[blah]' of thedimension '[blah]'' that seems to indicate that none of my fact foreignkeys exist as primary keys in the dimension table. However if I thenattempt to query the cube, all data seems to be there.Would anybody be in a position (and willing ;-)) to share his/her ownexperience working around a similar issue?Thanks,SRL

View 2 Replies View Related

Getting An Error While Activating Stored Proc On Queue

Apr 20, 2007

Hi,

I am having an SQL CLR stored proc which looks like this in SQL Svr



CREATE PROCEDURE [dbo].[callspGetMessage]

@strMsg [nvarchar](4000) OUTPUT

WITH EXECUTE AS CALLER

AS

EXTERNAL NAME [GetSSBMSG].[StoredProcs].[callspGetMessage]

GO

EXEC sys.sp_addextendedproperty @name=N'AutoDeployed', @value=N'yes' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'PROCEDURE', @level1name=N'callspGetMessage'

GO

EXEC sys.sp_addextendedproperty @name=N'SqlAssemblyFile', @value=N'StoredProcs.cs' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'PROCEDURE', @level1name=N'callspGetMessage'

GO

EXEC sys.sp_addextendedproperty @name=N'SqlAssemblyFileLine', @value=14 ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'PROCEDURE', @level1name=N'callspGetMessage'







When I am trying to alter the queue to attach to this procedure using following code



alter queue q1 with activation (

status = on,

max_queue_readers = 1,

procedure_name = [callspGetMessage],

execute as owner);



I am getting following error.

The signature of activation stored procedure 'callspGetMessage' is invalid. Parameters are not allowed.



Parameters to the stored proc are not allowed or am I doing anything wrong.



Any help is greatly appreciated.



Thanks,

Don

View 2 Replies View Related

Updatable Transactional Replication, Queue Reader Error

Jul 3, 2007

I have just started getting the following error from the queue reader but I can't see why.



The Queue Reader Agent has encountered the error ''Row handle is invalid.'' when connecting to ''Database'' on ''ServerName''. Ensure that the publication and subscription are defined properly and that both servers are running.



Does anybody know what it means / how I can fix the problem?



Thanks

View 11 Replies View Related

Error Message: Setup Failed Because MSSQL$SQLExpress Is Disabled For The Current Hardware Profile

Oct 19, 2006

When installing SQLEXPRESS I am getting this message:

Setup failed because service MSSQL$SQLExpress is disabled for the current hardware profile. Services must be set with the current Hardware Profile logon property enabled.

Anybody knows how to fix this problem?

Eitan

View 6 Replies View Related

The SQL Server (SQLEXPRESS) Service Terminated With Service-specific Error 10013.

Jul 12, 2007

I have an almost virgin install of SQLExpres running on a WIN2K Pro system.

Have been able to create and connect db to Access 2000 without problem.



Now I wish to extend to remote connections. Using Surface Area Configuration tool, I changed Remote Connections to Local and Remote.

Whenever this setting contains TCP/IP and I try to restart the service I receive the following errors:



System Log:



The SQL Server (SQLEXPRESS) service terminated with service-specific error 10013.



Application Log:



Server TCP provider failed to listen on [ 'any' <ipv4> 0]. Tcp port is already in use.



TDSSNIClient initialization failed with error 0x271d, status code 0xa.



TDSSNIClient initialization failed with error 0x271d, status code 0x1.



Could not start the network library because of an internal error in the network library. To determine the cause, review the errors immediately preceding this one in the error log.



SQL Server could not spawn FRunCM thread. Check the SQL Server error log and the Windows event logs for information about possible related problems.





If I change back to Local Connections Only or Local and Remote using named pipes only, the service starts up again without a problem.



After five days of investigating, researching, reinstalling and waiting I have to ask for help.



Any suggestions or leads?



Thank You in advance.

View 14 Replies View Related

An Error 1069 - )The Service Did Not Start Due To Logon Failure) Occurred While Performing This Service Operation ...

Oct 10, 2007

Hi All,

We seem to be being plagued by the error below by our SQL Server agent. This happens almost everytime we restart the server that has been running for a day or two.

Our SQL Server Agent uses a none expiring domain credential. I understand that this problem only happens when the profile being used by the SQL Servr Agent has changed (password change). What puzzles me is that the login is A ok and no changes has been made to it's password.

We always resolve this problem by changing the login used in the SQL Server Agent to local and after that, returning it back to it's original domain login. Unfortunately, we cant always do this everytime something goes wrong.

Can anyone please help us shed a light on this? We're using SQL2k with SP3a. Thanks!

Error:

An error 1069 - )The service did not start due to logon failure) occurred while performing this service operation on the SQLServerAgent service.


Regards,
Joseph

View 29 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved