Geting ErrorT His Message Could Not Be Delivered Because The Destination Queue Has Been Disabled
hi,
i have created a service broker appplication between two instances. i have configured all the objects and certificate.
when i am sending a message from initiator i am getting a error like
This message could not be delivered because the destination queue has been disabled
but my destination and source queue both are in enable state.
i am getting this error statement when i am attaching the profiler to the target in the event broker:message undeliverable.
i have activated Security Audit/Audit Broker Conversation but nothing is coming.
and my message remains in the source's sys.transmission_queue with transmission_status column empty.
please help me!!!!!! it is very urgent.
View Complete Forum Thread with Replies
Sponsored Links:
Related Messages:
How To Log That A Message Has Been Retained In The Transmission_queue When The Queue Is Disabled.
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 Replies !
View Related
Target Queue Disabled: Strange Message On The Event Viewer
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 Replies !
View Related
Service Queue Disabled
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 Replies !
View Related
Message Could Not Be Delivered Errors In Service Broker
Hi, I am using service broker in between two database servers. following is the way i am sending and receiving messages Send BEGIN TRAN BEGIN DIALOG CONVERSATION @handle FROM SERVICE @SendService TO SERVICE @ReceiveService ON CONTRACT @Contract WITH LIFETIME = @lifetime; SEND ON CONVERSATION @handle MESSAGE TYPE @xmlMessageType(@xmlMessage); COMMIT Receive BEGIN TRAN; RECEIVE TOP(1) @xmlMessage = message_body, @handle = conversation_handle, @message_type = message_type_name FROM TransactionQueue; ---------------------------------------------------------------------------------------------------- -- Check to make sure a message was returned to process. In theory this should never happen. ---------------------------------------------------------------------------------------------------- IF @@rowcount = 1 BEGIN IF @message_type = 'http://schemas.microsoft.com/SQL/ServiceBroker/EndDialog' BEGIN END CONVERSATION @handle; COMMIT RETURN 0 END IF @message_type = N'http://schemas.microsoft.com/SQL/ServiceBroker/Error' BEGIN RAISERROR(N'Received error %s from service [Target]', 10, 1) END CONVERSATION @handle; COMMIT RETURN 0 END SET @sql = 'EXEC '+@message_processor_name+' @xml' BEGIN TRAN EXEC sp_executesql @sql, N'@xml XML', @xml=@xmlMessage COMMIT TRAN END CONVERSATION @handle; END COMMIT I see Messages are delivered to the target every thing working fine other than following errors which i am seeing in profiler. 1) "This message could not be delivered because the conversation endpoint has already been closed." I see this error on initiator end. Is it like ending conversation on initiator end when i get "EndDialog" send an acknowledgement, which cannot be recieved by target as it has already ended conversation. 2) "An error occurred while receiving data: '64(The specified network name is no longer available.)'." I don't have much idea about the reason for this error. But in profiler i see value for GUID is different for this error and the real message. Let me know if you need any other information
View Replies !
View Related
Event Notification On Disabled Queue: The Conversation Must End?
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 Replies !
View Related
Message Could Not Be Delivered Because The Conversation Endpoint Has Already Closed Error In Profiler
Hi, I already had a thread for same problem but didn't recieved any response in last 4-5 months so I created a new thread for this I am using service broker in between two database servers. following is the way i am sending and receiving messages Send BEGIN TRAN BEGIN DIALOG CONVERSATION @handle FROM SERVICE @SendService TO SERVICE @ReceiveService ON CONTRACT @Contract WITH LIFETIME = @lifetime; SEND ON CONVERSATION @handle MESSAGE TYPE @xmlMessageType(@xmlMessage); COMMIT Receive BEGIN TRAN; RECEIVE TOP(1) @xmlMessage = message_body, @handle = conversation_handle, @message_type = message_type_name FROM TransactionQueue; ---------------------------------------------------------------------------------------------------- -- Check to make sure a message was returned to process. In theory this should never happen. ---------------------------------------------------------------------------------------------------- IF @@rowcount = 1 BEGIN IF @message_type = 'http://schemas.microsoft.com/SQL/ServiceBroker/EndDialog' BEGIN END CONVERSATION @handle; COMMIT RETURN 0 END IF @message_type = N'http://schemas.microsoft.com/SQL/ServiceBroker/Error' BEGIN RAISERROR(N'Received error %s from service [Target]', 10, 1) END CONVERSATION @handle; COMMIT RETURN 0 END SET @sql = 'EXEC '+@message_processor_name+' @xml' BEGIN TRAN EXEC sp_executesql @sql, N'@xml XML', @xml=@xmlMessage COMMIT TRAN END CONVERSATION @handle; END COMMIT I see Messages are delivered to the target every thing working fine other than following errors which i am seeing in profiler. 1) "This message could not be delivered because the conversation endpoint has already been closed." I see this error on initiator end. Is it like ending conversation on initiator end when i get "EndDialog" send an acknowledgement, which cannot be recieved by target as it has already ended conversation. 2) "An error occurred while receiving data: '64(The specified network name is no longer available.)'." I don't have much idea about the reason for this error. But in profiler i see value for GUID is different for this error and the real message. Let me know if you need any other information
View Replies !
View Related
First Service Broker Attempt, Prajdic's Example, Error: &&"queue Has Been Disabled&&"
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 Replies !
View Related
Message Queue Task
Ok, im making some progress. So what i have is a Message Queue Task which is bound to a message queue connection manager (which 'tests' ok). The Message Queue Task is set to recieve, variable from string message (declared a variable of type string) and to remove the message from the queue. The output of that task is piped into the data flow task. The data flow task expands into a XML Source which is configured to get its input from the string i declared in the Message Queue Task and i point the schemas path to an appropriate schema. I then pipe the output of that into a SQL server destination which ive mapped all the columns from the XML message to a table (which the SQL server destination created for me). It all looks good on paper, and builds properly with no errors etc. There is already a message in the appropriate private queue. When i go to debug it, it just sits on the Message Queue Task node (its yellow) and goes no further. No data is put into the DB. I have put a watcher on the link between the XML Source and the SQL server destination, and can see no data being piped through. Even if i send another message, the execution of my package doesnt step passed the Message Queue Task. Its just sitting there waiting for something? what? I thought it would block until there was a message on that queue, and then process it if and when it arrives. But it doesnt seem to do that. Any ideas?? I read on MSDN that you need integration services installed. I have checked and i do, and its running. Is theres something else i need to configure? Help!
View Replies !
View Related
Message Queue Task
Simple Question. I have a requirement to read XML Messages from a Remote private MSMQ. These messages are essentially Database records that will need cleaning up and insterting into a Local Database table. Is this possible with SSIS? Would Biztalk be a more suitable tool for this type of process? If its possible, are there any resources taht can point me in the right direction? Thanks for your help! J.
View Replies !
View Related
Message Queue Reminder System
Hello all, I am trying to develop a message queue reminder system. The concept is fairly simple i run a job that checks a table in a database. The table is sorted by datetime. I take the top rows off the table until the date is greater than the current time.(I only send emails after or when there date is reached) Any rows that are popped off the queue are sent by email to whomever. This job runs every five minutes. So far I can send emails using aspmail component. I can use a stored procedure to transfer emails into the queue. I am having trouble with : getting jobs not to fail, writing the code for jobs, writing vbscript, creating a loop in vbscript to process rows. Does anyone know of any good resources to learn about vbscript and jobs? or any examples of such coding? Or does anyone know of any components that might provide such a resource? Does anyone know of a better way that this could be done? Any suggestions are more than welcome. Cheers, Padraic
View Replies !
View Related
Using Message Queue Task And Serialization
I have a C# application that get data (i.e. select Firstname, LastName from person) to form a DataSet object (i.e. PersonName variable inside my code). Then I want to post this DataSet object into a local private queue (the path is: .privatemyTestQ). Note that I carefully labled the message to be "Variables Message" (as needed per anothre thread discussion here in this forum). I created a receiving package, in which I want to use SSIS's Message Queue task to retreive the above DataSet object (from C# application). I got failure: [Message Queue Task] Error: An error occurred with the following error message: "Root element is missing.". However, As a comparison research, I created another SSIS sending-package. And I used ADO.NET provider to get the same data to store the sull result set in a package-level variable. Then I use Message Queue task to post this variable (i.e. object) to the same private queue above. Then I run my above receiving package. I was successful to read back the messge that I posted from SSIS sending package. (Please note that if I use OLEDB provider for sending package to get data from database, the MSMQ task for sending failed due to serializtion issue for __ComObject. With ADO.NET provider, the result set is represented as a type of DataSet). I then curiously looked into message body from Computer Management Counsol. I found that message sent from SSIS is in SOAP format while message from my C# application is NOT in SOAP (but only in XML format). Obviously SSIS MSMQ task serialize objects into SOAP format. Can anyone here please help on how to serialize my DataSet object from my C# app) in compliance with the MSMQ task's spec so that I can read message from Q using SSIS package. I use Visual Studio 2005 and MSMQ 3.0 version. Your help is appreciated.
View Replies !
View Related
Receiving Messages In A Message Queue
I am new to message queues, so please excuse my ignorance... but when I set a Message Queue as a receive queue... shouldn't it poll for each message in the queue? It is running once and I am receiving the value within that queue, but then it just finishes with success. I have tried created a For Each container around it, but that just jumbles the whole mess of it. I have tried various options, but am currently using the "String message to variable" option. Any help would be greatly appreciated. I would really like to delve into transferring more interesting objects, but will settle for just strings at this point. If there are any good articles any of you know in regards to receiving on the message queue, please let me know... everything I have seen is about sending data.
View Replies !
View Related
Modify Message Order In Queue?
Is it possible to modify the sequence of messages in a SSB queue? Or to create messages so that their sequence is based on a value in the message rather than the order in which they were sent to the queue? I am trying to determine if SSB will help me solve a situation where BizTalk needs to process a prescribed sequence of messages that may not be received in the correct order. (i.e. I need to resequence the messages). Each message contains a field with the sequence number and also a field identifying the total number of messages in the sequence. I realise that the Sequential Convoy Aggregrator EAI pattern can potentially provide a solution to this, or even the Sequence Guards pattern by McGeeky, but I guess I was hoping that SSB might provide a slightly more efficient solution(?) Thanks, Dan
View Replies !
View Related
Message Queue Task 64 Bit Cluster Issue
Hello, I'm using the Message Queuing task to create a local private queue message. Everything works great on a 32 bit machine. When I try this on a 64 bit Itanium Cluster I keep getting the message "Message queue service is not available" in my SSIS log. I've using this string as my path "ClusterNameprivate$QueueName". Does anyone know of any issues with the Message Queue task on 64 bit or a cluster? The Message Queue service is up and running, it doesn't make sense. Thanks, Andy
View Replies !
View Related
Junk Characters In Message Queue Task
I have a strange situation in an Message queue task in SSIS. I serialize an object in a C# application and add that to an MSMQ as a string. I also ensure that I set the label to "String Message" so that my Message Queue Task can actually receive the message as a String message to variable. I created an SSIS package that has an Message Queue listener that feeds into a Script task inside a for-each loop. For each message that I obtain, I invoke a script task that retrieves the value of the variable and then processes this information. When I enter the entry into the MSMQ, it goes in perfectly fine (since I also tested retrieving this entry from a C# app). However when I use the same logic on the SSIS package using the Script task, I get junk chinese characters. Has this happened to anyone else? Any feedback would be great! Anup Here is the code for the script task: mports System Imports System.Data Imports System.Math Imports Microsoft.SqlServer.Dts.Runtime Public Class ScriptMain Public Sub Main() Dim statusMessage As String statusMessage = CType(ReadVariable("ReviewerHealthXmlMessage"), String) System.Windows.Forms.MessageBox.Show(statusMessage) Dts.TaskResult = Dts.Results.Success End Sub Private Function ReadVariable(ByVal varName As String) As Object Dim result As Object Try Dim vars As Variables Dts.VariableDispenser.LockForRead(varName) Dts.VariableDispenser.GetVariables(vars) Try result = vars(varName).Value Catch ex As Exception Throw ex Finally vars.Unlock() End Try Catch ex As Exception Throw ex End Try Return result End Function Private Sub WriteVariable(ByVal varName As String, ByVal varValue As Object) Try Dim vars As Variables Dts.VariableDispenser.LockForWrite(varName) Dts.VariableDispenser.GetVariables(vars) Try vars(varName).Value = varValue Catch ex As Exception Throw ex Finally vars.Unlock() End Try Catch ex As Exception Throw ex End Try End Sub End Class
View Replies !
View Related
Implementing Message Queue In SQL Server 2000
I am implementing a message queue system in SQL Server 2000. My queue table looks something like this: [MessageId] [uniqueidentifier] NOT NULL, [MessageType] [uniqueidentifier] NOT NULL, [Status] [tinyint] NOT NULL, [SubmittedTime] [datetime] NOT NULL, [StartTime] [datetime] NOT NULL, [DispatchedTime] [datetime] NULL, [CompletedTime] [datetime] NULL, [MessageData] [image] NULL This is how I retrieve the next message for processing: SELECT TOP 1 * FROM [Queue].[MessageQueue] WITH (ROWLOCK, UPDLOCK, READPAST) WHERE [StartTime]=@pStartTime AND [MessageType]=@pMessageType AND [Status]=@pStatus ORDER BY [StartTime] and mark it as being processed: UPDATE [Queue].[MessageQueue] SET [Status]=1 WHERE [MessageId]=@pMessageId After message has been processed I delete it from the queue: DELETE FROM [Queue].[MessageQueue] WHERE [MessageId]=@pMessageId All database accesses are transactional with default READ COMMITTED. The problems start when there are a few concurrent accesses: I get deadlocks when retrieving next message. If I do not delete message after processing then there is no deadlock. But this is not what I need. I played with different isolation levels and locking hints and was able to avoid deadlock using TABLOCKX: SELECT .... FROM [Queue].[MessageQueue] WITH (TABLOCKX) But in this case you cannot concurrently retrieve messages which was my goal from the beginning. How do I achieve this? Thank you, Alex
View Replies !
View Related
Can't Receive Message From Queue (Async Trigger)
Hi Folks, I've found a pretty good code example on http://www.dotnetfun.com for a Asynchronous Trigger. I've parsed through the Code, to understand how to wirte my own Async Trigger with a Service Broker, but the Code isn't working! It seems that the stored procedure don't receive the messages in the queue, but the queue get's filled. MessageType CREATE MESSAGE TYPE myMsgXML VALIDATION = WELL_FORMED_XML; Contract CREATE CONTRACT myContractANY (myMsgXML SENT BY ANY) Queue CREATE QUEUE myQueue WITH STATUS = ON, RETENTION = ON, ACTIVATION ( STATUS = ON, PROCEDURE_NAME = sp_myServiceProgram, MAX_QUEUE_READERS = 5, EXECUTE AS SELF ) Service CREATE SERVICE myService ON QUEUE myQueue (myContractANY) Procedure (greped from http://www.dotnetfun.com/) CREATE PROC sp_myServiceProgram AS -- This procedure will get triggered automatically -- when a message arrives at the -- Let's retrieve any messages sent to us here: DECLARE @XML XML, @MessageBody VARBINARY(MAX), @MessageTypeName SYSNAME, @ID INT, @COL2 VARCHAR(MAX); DECLARE @Queue TABLE ( MessageBody VARBINARY(MAX), MessageTypeName SYSNAME); WHILE (1 = 1) BEGIN WAITFOR ( RECEIVE message_body, message_type_name FROM myQueue INTO @Queue ), TIMEOUT 5000; -- If no messages exist, then break out of the loop: IF NOT EXISTS(SELECT * FROM @Queue) BREAK; DECLARE c_Test CURSOR FAST_FORWARD FOR SELECT * FROM @Queue; OPEN c_Test; FETCH NEXT FROM c_Test INTO @MessageBody, @MessageTypeName; WHILE @@FETCH_STATUS = 0 BEGIN -- Let's only deal with messages of Message Type -- myMsgXML: IF @MessageTypeName = 'myMsgXML' BEGIN SET @XML = CAST(@MessageBody AS XML); -- Now let's save the XML records into the -- historical table: INSERT INTO tblDotNetFunTriggerTestHistory SELECT tbl.rows.value('@ID', 'INT') AS ID, tbl.rows.value('@COL2', 'VARCHAR(MAX)') AS COL2, GETDATE() AS UPDATED FROM @XML.nodes('/inserted') tbl(rows); END FETCH NEXT FROM c_Test INTO @MessageBody, @MessageTypeName; END CLOSE c_Test; DEALLOCATE c_Test; -- Purge the temporary in-proc table: DELETE FROM @Queue; END Send Message in a Update Trigger SELECT @XML = (SELECT * FROM inserted FOR XML AUTO); -- Send the XML records to the Service Broker queue: DECLARE @DialogHandle UNIQUEIDENTIFIER, @ConversationID UNIQUEIDENTIFIER; /* The target Service Broker service is the same service as the initiating service; however, you can set up this type of trigger to send messages to a remote server or another database. */ BEGIN DIALOG CONVERSATION @DialogHandle FROM SERVICE myService TO SERVICE 'myService' ON CONTRACT myContractANY; SEND ON CONVERSATION @DialogHandle MESSAGE TYPE myMsgXML (@XML); -- Let's detect an error state for this dialog -- and rollback the entire transaction if one is -- detected: IF EXISTS(SELECT * FROM sys.conversation_endpoints WHERE conversation_handle = @DialogHandle AND state = 'ER') RAISERROR('Dialog in error state.', 18, 127); ELSE BEGIN --I want to list the queue after the trigger so I disabled --END CONVERSATION @DialogHandle; COMMIT TRAN; END The Problem is, that the Procedure doesn't even get started! So I tried to receive the Queues manually WAITFOR ( RECEIVE message_body, message_type_name FROM myQueue INTO @Queue ), TIMEOUT 5000; and I run always into the timeout and get nothing back. A Select * FROM myQueue gives me some results back. Why I can't recevie? Would be grateful for help, or at least a good tutorial, I haven't found one yet.... thx and greez Karsten
View Replies !
View Related
Message Queue Task - Invalid Path Problem
I'm trying to use the message queue task in SSIS 2005 and not getting very far. Right off the bat I'm trying to create a Message Queue Connection Manager and when I enter the path, trying both "seawxxxx estq" (my local computer name) or ". estq" and test it, it comes back with "invalid path". Have done quite a bit of searching around and can't find anything on this particular error. Suggestions? Thanks in advance.
View Replies !
View Related
Problem With Distributed Transactions - Multiple Threads Pop The Same Message From Queue
Hi, I am using distributed transactions where in I start a TransactionScope in BLL and receive data from service broker queue in DAL, perform various actions in BLL and DAL and if everything is ok call TransactionScope.Commit(). I have a problem where in if i run multiple instances of the same app ( each app creates one thread ), the threads pop out the same message and I get a deadlock upon commit. My dequeue SP is as follows: CREATE PROC [dbo].[queue_dequeue] @entryId int OUTPUT AS BEGIN DECLARE @conversationHandle UNIQUEIDENTIFIER; DECLARE @messageTypeName SYSNAME; DECLARE @conversationGroupId UNIQUEIDENTIFIER; GET CONVERSATION GROUP @conversationGroupId FROM ProcessingQueue; if (@conversationGroupId is not null) BEGIN RECEIVE TOP(1) @entryId = CONVERT(INT, [message_body]), @conversationHandle = [conversation_handle], @messageTypeName = [message_type_name] FROM ProcessingQueue WHERE conversation_group_id=@conversationGroupId END if @messageTypeName in ( 'http://schemas.microsoft.com/SQL/ServiceBroker/EndDialog', 'http://schemas.microsoft.com/SQL/ServiceBroker/Error' ) begin end conversation @conversationHandle; end END Can anyone explain to me why the threads are able to pop the same message ? I thought service broker made sure this cannot happen?
View Replies !
View Related
Message Queue Task Error: The ServicedComponent Being Invoked Is Not Correctly Configured (Use Regsvcs To Re-register).
This is the first time I've used SQL Server Integration Services, and I have it installed with SP2 applied on my local machine. I have created a Package, and dropped a Message Queue Task on it. I have pointed the Message Queue Connection Manager at a private queue on my machine. I have set the "Message" property to "Send message", I have changed the message type to "String Message" and entered "Test string" into the StringMessage property. When I execute the package (by clicking the "Start debugging" button on the toolbar), I get the following error message in the Execution Results: [Message Queue Task] Error: An error occurred with the following error message: "The ServicedComponent being invoked is not correctly configured (Use regsvcs to re-register).". There is no more diagnostic data that I can see in the Execution Results. Can anyone please explain to me how I can get this working? Thanks! Bryan
View Replies !
View Related
How To Return The True OleDb Destination Message
Good morning, I couldn't find a solution through searching so I thought I would post. I have an OleDb destination and am trying to get the "true" errors raised when inserting records. I am -not- using fast load and am redirecting the error rows into an Excel spreadsheet. I did the script component transformation workaround to get an error description but the error description I get is "The data value violates integrity constraints.", which must be an SSIS wrapper and not very helpful. What I am looking for is the true error of why the record failed, such as: Violation of PRIMARY KEY constraint 'XPKYEAR'. Cannot insert duplicate key in object 'dbo.year'. Thanks for the help.
View Replies !
View Related
Data Flow Job Failing, Destination = Microsoft SQL Native Client, Error Message Not Too Helpful...
Hi there, I have a Data Flow task which uses an XML File Source with six parellell Outputs, each going firstly to a Data Conversion Task, then the results of each end in a SQL Server Destination Object. (All using the SQL Native Client) To eplain this further, the Xml file contains 6 different types of elements, the Dataflow splits out each type of element and processes them into different tables. The Data Transformation object exists only because the XML fields are Uni-code and the table fields are VarChar not nVarChar. Initially using this setup I found that the Connection would timeout using the SQL Native Client so I changed the Timout on the Destination Objects to 0. This fixed the problem to some degree, however at present I can run the Pakage using the Visual Studio enviroment and everything works fine, no problem. When I run the Dtsx file using the SQL Server Agent, I end up getting the error below... Error: 2007-12-14 14:33:19.16 Code: 0xC0202009 Source: Import XML File to SQL SQL - CP [2746] Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E14. An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80040E14 Description: "Cannot fetch a row from OLE DB provider "BULK" for linked server "(null)".". An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80040E14 Description: "The OLE DB provider "BULK" for linked server "(null)" reported an error. The provider did not give any information about the error.". An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80040E14 Description: "Reading from I understand that this error is somewhat of a 'catch all' and that the way the Native SQL Server Connection object works makes Error Capturing difficult. I have tried a few things which I will list as I'm sure they will be suggested... I have played around with the 'MaxInsertCommitSize' property of the SQL Server Destination Objects to no avail (IE, changing to 50000, 10000, 1000 all of which resulted in the same problem) I am running the ssis pakage from the server which is the destination As mentioned above the Timeout on the SQL Server Destination Objects is set to 0 What I have already mentioned and still don'tt quite understand is that I can run the job successfully from the Visual Studio enviroment but as a job run off the SQL Server it fails... Can
View Replies !
View Related
Clarifications On Queue Service And Queue Readers
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 Replies !
View Related
Geting Wrong Data
See the following query: " select a.name from tbcity a, tbemp b " There is a column "name" common in both the tables tbcity & tbemp. Here we are not referencing or getting the column name from tbemp but still it will give the records from the table tbemp also. It is returning the number of records from tbcity multiplied by the number of records of table tbemp. if there are 10 records in table tbcity & 5 records in table tbemp then instead of returning only 10 records it is returning 50 records.Very strange...! if there is no records in table tbemp then it is returning zero records. So please suggest me the solution and why it is behaving in such a strange manner. Prashant.
View Replies !
View Related
Geting The Last Inserted Row For Each CLIENT. How?
Hi, I have a CLIENTS table with pk CLIENT_ID, and a CONVERSATIONS table where CONV_ID and CLIENT_ID form the pk, there is another column CONVERSATION_DATE where the conversation data is registered (and other columns). Now I need to retrieve, for each client, the last N (for some clients, eventually, less then N) conversations with one T-SQL statement. Does anyone knows how to do this? Is it possible with T-SQL only? Thanks.
View Replies !
View Related
Geting Event From ActiveX Into Database
Hello everyone,I was wondering. Is it possible, to recive an event from ActiveX intodatabase?I was looking alredy with notification services, but I think that'sthe wrong way.Lets say, that there is a ActiveX which realize some tasks.The database trigers the ActiveX like below:================================================== =============declare @iRetValintdeclare @iObjectintdeclare @sPropertyvarchar(2560)declare @sSource varchar(1000)declare @sDescription varchar(1000)declare @sLog varchar(1000)declare @dDateEVT datetimedeclare @sText1varchar(10)declare @sText2varchar(10)declare @iProperty intset @iObject = 0set @dDateEVT = getdate()set @iRetVal = 0set @sText1 = '0000000000'set @sText2 = '0000000000'set @iProperty = 7exec @iRetVal = sp_OACreate 'MComponent.pidMess', @iObject OUTPUT,1EXEC sp_OAGetErrorInfo @iObject, @sSource OUT, @sDescription OUTIF @iRetVal <> 0beginset @sLog = 'LOG1: No object created. Source: ' + @sSource + 'Description: ' + @sDescriptionprint @sLogend-- Methodexec @iRetVal = sp_OAMethod @iObject,'Send_FromA', @iPropertyOUT,@nMessageNr = 5, @bstrDateTime = @dDateEVT, @textFromA1 = @sText1,@textFromA2 = @sText2EXEC sp_OAGetErrorInfo @iObject, @sSource OUT, @sDescription OUTIF @iRetVal <> 0beginset @sLog = 'LOG3: Source: ' + @sSource + ' Description: ' +@sDescriptionprint @sLogendPRINT 'Property from method:'PRINT @iProperty================================================== =============This function works properly. I recive the data into ActiveX.After the ActiveX process the data, it returns the event, wit aresponse for this call of method.Now ... how do I can get, this event into SQL server?Is it possible to do that enyhow, without acctions like:- do, that the ActiveX writes the data in to a interface table, wherefrom it will be readed.Any help would be appreciatedMateusz
View Replies !
View Related
No Reports Has Delivered After Subscription
Hi I tried to deliver a report using data driven subscriptions option. But It does not process. In report manager, under status bar, it indicates 0 processing of 12 total; 0 errors. Although there is no error I can not see any reports on the shared folder. But when I go to Mngt Studio and select the specific report and try to refresh that reports subscription I get the following error. ================================== invalid node. (Microsoft.SqlServer.SmoEnum) ------------------------------ For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476 ------------------------------ Program Location: at Microsoft.SqlServer.Management.Smo.XPathExpression.Load(AstNode ast) at Microsoft.SqlServer.Management.Smo.XPathExpression.Compile(String strXPathExpression) at Microsoft.SqlServer.Management.Smo.Urn.get_XPathExpression() at Microsoft.SqlServer.Management.Smo.Urn.Compare(Urn u1, Urn u2, CompareOptions[] compInfoList, CultureInfo cultureInfo) at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItemBuilder.RebuildItem(INavigableItem item, Boolean applyItemParentFilter) at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItem.RequeryProperties() at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItem.Refresh(Boolean autoRefresh) at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItem.Refresh() at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ExplorerHierarchyNode.Refresh() Does any body know how to fix this ? Thanks
View Replies !
View Related
Error On VB Sample Which Is Delivered By Installation.
Hi, after i try to build the web application "Web Development - Data Entry Form" i get the following error message. I already change the variable username to system which is defined in Machine.Config. The Error messega is like following: SQL Server does not exist or access denied. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Data.SqlClient.SqlException: SQL Server does not exist or access denied. Thanks,
View Replies !
View Related
Sp_addmergereplication And @sync_type='None': Snapshot Is Still Delivered
Hello, I'm hoping someone can help me with this. We use t-sql scripts to install merge replication and we have run into a bit of a problem. Sometimes the subscriber already has a database with data and we don't want to apply the snapshot. I thought that if you call sp_addmergereplication with the @sync_type set to 'none' then for that subscriber it will forgo the initial snapshot. It looks like it is still applying it and I'm getting foreign key constraint errors. This occurs on both 2k and 2k5. What's more we could swear that this used to work... Anyway, any advice would be greatly appreciated. Thanks for reading! Scott
View Replies !
View Related
Not All The Reports Are Delivered To The Shared Folder
Hi All, I'm delivering some reports through data driven to a shared folder in another computer in my network. In report manager, under status, it shows the following message. Processing: 10 processed of 12 total; 0 errors. When I chek in the folder, I can see sometimes only 6 reports. I rescheduled and run it again. Then I could see only 10 out of 12 reports. I opened the Management Studio and tried to refreshed the report subscription under subscription. Then I got the following error message. " nvalid node. (Microsoft.SqlServer.SmoEnum) ------------------------------ For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476 ------------------------------ Program Location: at Microsoft.SqlServer.Management.Smo.XPathExpression.Load(AstNode ast) at Microsoft.SqlServer.Management.Smo.XPathExpression.Compile(String strXPathExpression) at Microsoft.SqlServer.Management.Smo.Urn.get_XPathExpression() at Microsoft.SqlServer.Management.Smo.Urn.Compare(Urn u1, Urn u2, CompareOptions[] compInfoList, CultureInfo cultureInfo) at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItemBuilder.RebuildItem(INavigableItem item, Boolean applyItemParentFilter) at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItem.RequeryProperties() at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItem.Refresh(Boolean autoRefresh) at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItem.Refresh() at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ExplorerHierarchyNode.Refresh() Even If see error log file, I can not see any file there. This is actually a file of the previous run. <Header> <Product>Microsoft SQL Server Reporting Services Version 9.00.2047.00</Product> <Locale>en-US</Locale> <TimeZone>Pacific Standard Time</TimeZone> <Path>C:Program FilesMicrosoft SQL ServerMSSQL.3Reporting ServicesLogFilesReportServerService__11_05_2007_11_29_11.log</Path> <SystemName>DEV02</SystemName> <OSName>Microsoft Windows NT 5.1.2600 Service Pack 2</OSName> <OSVersion>5.1.2600.131072</OSVersion> </Header> ReportingServicesService!library!4!11/5/2007-11:29:12:: i INFO: Initializing ConnectionType to '0' as specified in Configuration file. ReportingServicesService!library!4!11/5/2007-11:29:12:: i INFO: Initializing IsSchedulingService to 'True' as specified in Configuration file. ReportingServicesService!library!4!11/5/2007-11:29:12:: i INFO: Initializing MaxQueueThreads to '0' thread(s) as specified in Configuration file. ReportingServicesService!library!4!11/5/2007-11:29:12:: i INFO: Initializing IsWebServiceEnabled to 'True' as specified in Configuration file. ReportingServicesService!configmanager!4!11/5/2007-11:29:12:: w WARN: WebServiceAccount is not specified in the config file. Using default: DEV02ASPNET ReportingServicesService!library!4!11/5/2007-11:29:12:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file. ReportingServicesService!library!4!11/5/2007-11:29:12:: i INFO: Initializing WatsonDumpOnExceptions to 'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException' as specified in Configuration file. ReportingServicesService!library!4!11/5/2007-11:29:12:: i INFO: Initializing WatsonDumpExcludeIfContainsExceptions to 'System.Data.SqlClient.SqlException,System.Threading.ThreadAbortException' as specified in Configuration file. ReportingServicesService!library!4!11/5/2007-11:29:12:: i INFO: Initializing SecureConnectionLevel to '0' as specified in Configuration file. ReportingServicesService!library!4!11/5/2007-11:29:12:: i INFO: Initializing DisplayErrorLink to 'True' as specified in Configuration file. ReportingServicesService!library!4!11/5/2007-11:29:12:: i INFO: Initializing WebServiceUseFileShareStorage to 'False' as specified in Configuration file. ReportingServicesService!library!8!11/5/2007-11:29:20:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDatabaseUnavailableException: The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing., ; Info: Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDatabaseUnavailableException: The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. ---> System.Data.SqlClient.SqlException: Cannot open database "ReportServer" requested by the login. The login failed. Login failed for user 'ZOPAratnayake'. at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK) at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) at System.Data.SqlClient.SqlConnection.Open() at Microsoft.ReportingServices.Library.ConnectionManager.OpenConnection() --- End of inner exception stack trace --- ReportingServicesService!library!8!11/5/2007-11:29:21:: Exception caught while starting service. Error: Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDatabaseUnavailableException: The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. ---> System.Data.SqlClient.SqlException: Cannot open database "ReportServer" requested by the login. The login failed. Login failed for user 'ZOPAratnayake'. at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) ReportingServicesService!library!4!11/05/2007-11:43:03:: Status: The file "Members - Awaiting Approval.xls" has been saved to the "\derbyReports" file share. ReportingServicesService!notification!4!11/05/2007-11:43:03:: Notification 77fc9843-80f6-4392-9c26-3a84b087dafb completed. Success: True, Status: The file "Members - Awaiting Approval.xls" has been saved to the "\derbyReports" file share., DeliveryExtension: Report Server FileShare, Report: Members - Awaiting Approval, Attempt 0 ReportingServicesService!dbpolling!4!11/05/2007-11:43:03:: NotificationPolling finished processing item 77fc9843-80f6-4392-9c26-3a84b087dafb ReportingServicesService!library!4!11/5/2007-11:43:03:: i INFO: Initializing SqlStreamingBufferSize to default value of '64640' Bytes because it was not specified in Server system properties. ReportingServicesService!library!4!11/5/2007-11:43:03:: i INFO: Initializing SnapshotCompression to 'SQL' as specified in Server system properties. ReportingServicesService!library!d!11/05/2007-11:43:03:: Data Driven Notification for activation id 668b2d9c-d5ea-46e9-8efd-e2824e9a8c64 was saved. ReportingServicesService!library!d!11/05/2007-11:43:03:: Status: The file "Members - Awaiting Approval.xls" has been saved to the "\derbyReports" file share. ReportingServicesService!notification!d!11/05/2007-11:43:03:: Notification 5fa50ecb-1b0f-4e40-86c8-4c4700c4b820 completed. Success: True, Status: The file "Members - Awaiting Approval.xls" has been saved to the "\derbyReports" file share., DeliveryExtension: Report Server FileShare, Report: Members - Awaiting Approval, Attempt 0 ReportingServicesService!dbpolling!d!11/05/2007-11:43:03:: NotificationPolling finished processing item 5fa50ecb-1b0f- ReportingServicesService!library!d!11/05/2007-11:43:03:: Data Driven Notification for activation id 668b2d9c-d5ea-46e9-8efd-e2824e9a8c64 was saved. ReportingServicesService!library!d!11/05/2007-11:43:03:: Status: The file "Members - Awaiting Approval_1.xls" has been saved to the "\derbyReports" file share. ReportingServicesService!notification!d!11/05/2007-11:43:03:: Notification 3a282979-9cab-44fd-b4e8-a083558c494e completed. Success: True, Status: The file "Members - Awaiting Approval_1.xls" has been saved to the "\derbyReports" file share., DeliveryExtension: Report Server FileShare, Report: Members - Awaiting Approval, Attempt 0 ReportingServicesService!dbpolling!d!11/05/2007-11:43:03:: NotificationPolling finished processing item 3a282979-9cab-44fd-b4e8-a083558c494e ReportingServicesService!subscription!4!11/05/2007-11:43:03:: System.IO.IOException: The process cannot access the file '\derbyReportsMembers - Awaiting Approval_1.xls' because it is being used by another process. at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath) at System.IO.FileStream.Init(String path, FileMode mode, FileAccess access, Int32 rights, Boolean useRights, FileShare share, Int32 bufferSize, FileOptions options, SECURITY_ATTRIBUTES secAttrs, String msgPath, Boolean bFromProxy) at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access) at Microsoft.ReportingServices.FileShareDeliveryProvider.FileShareProvider.SaveReport(Notification notification, SubscriptionData data) ReportingServicesService!subscription!4!11/05/2007-11:43:03:: Error writing file Members - Awaiting Approval_1.xls to path \derbyReports ReportingServicesService!library!4!11/05/2007-11:43:03:: Data Driven Notification for activation id 668b2d9c-d5ea-46e9-8efd-e2824e9a8c64 was saved. ReportingServicesService!library!4!11/05/2007-11:43:03:: Status: Failure writing file Members - Awaiting Approval_1.xls : The process cannot access the file '\derbyReportsMembers - Awaiting Approval_1.xls' because it is being used by another process. ReportingServicesService!dbpolling!4!11/05/2007-11:43:03:: NotificationPolling finished processing item 09e28175-ce44-41cd-ab55-56199a58885f ReportingServicesService!dbpolling!d!11/5/2007-11:43:03:: NotificationPolling processing item 41cfd72e-bda0-4e8f-87dd-a22789eb340f ReportingServicesService!dbpolling!c!11/5/2007-11:43:03:: NotificationPolling processing 2 more items. 2 Total items in internal queue. ReportingServicesService!dbpolling!4!11/5/2007-11:43:03:: NotificationPolling processing item 34e19ce1-b298-48e6-a2fc-b7637765968c ReportingServicesService!subscription!11!11/05/2007-13:18:10:: Auto increment filename = Members - Awaiting Approval_5.xls ReportingServicesService!subscription!11!11/05/2007-13:18:10:: System.IO.IOException: The process cannot access the file '\derbyReportsMembers - Awaiting Approval_5.xls' because it is being used by another process. at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath) at System.IO.FileStream.Init(String path, FileMode mode, FileAccess access, Int32 rights, Boolean useRights, FileShare share, Int32 bufferSize, FileOptions options, SECURITY_ATTRIBUTES secAttrs, String msgPath, Boolean bFromProxy) at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access) at Microsoft.ReportingServices.FileShareDeliveryProvider.FileShareProvider.SaveReport(Notification notification, SubscriptionData data) ReportingServicesService!subscription!11!11/05/2007-13:26:15:: Auto increment filename = Members - Awaiting Approval_11.xls ReportingServicesService!library!11!11/05/2007-13:26:15:: Data Driven Notification for activation id 7bd68b9c-855f-4f2a-9482-43ac5f7c9589 was saved. ReportingServicesService!library!11!11/05/2007-13:26:15:: Status: The file "Members - Awaiting Approval_11.xls" has been saved to the "\derbyReports" file share. ReportingServicesService!notification!11!11/05/2007-13:26:15:: Notification 76aedee6-e860-4c60-aebc-2c3aeb854bed completed. Success: True, Status: The file "Members - Awaiting Approval_11.xls" has been saved to the "\derbyReports" file share., DeliveryExtension: Report Server FileShare, Report: Members - Awaiting Approval, Attempt 1 ReportingServicesService!dbpolling!11!11/05/2007-13:26:15:: NotificationPolling finished processing item 76aedee6-e860-4c60-aebc-2c3aeb854bed ReportingServicesService!library!11!11/5/2007-13:29:12:: i INFO: Cleaned 0 batch records, 0 policies, 12 sessions, 0 cache entries, 12 snapshots, 36 chunks, 0 running jobs, 0 persisted streams Here I did not post the whole error log, because its too long. Does any one know why I can not deliver all the reports?
View Replies !
View Related
Possible To Create Subscription Delivered To A Netware Share?
I am running SQL Server 2005 Reporting Services. I created a subscription delivered by "Report Server File Share" and the UNC path points to a share on a Netware server. I get the following error when the schedule runs: Failure writing file Completed.pdf : The network path was not found The UNC path is \rmh5vol1deptimsoperhiscommon. I can create the same subscription, but have it write to a Windows file share and everything works fine. Does SQL Server 2005 Reporting Services support writing to a Netware share?
View Replies !
View Related
Is It Possible To Use RS To Subit A Request For A Report To Be Delivered By Email?
I would like to be able to let a user fill out the normal parameters for a report but also include their email address and the attachment type for the report result. When they click on the View Report button the report request is submitted to the RS and lets them know if it was accepted. I suppose this is almost like building a onetime subscription on the fly. We have some very long running reports that have issues with the browser losing communication with the reporting server. The report is continuing to run but since the browser has lost the connection the user will never be able to see the results. Any ideas? Thanks --sean
View Replies !
View Related
Default Params In E-Mail Delivered Reports
Hi all, [Reporting Services 2005] I have reports delivered by email subscription. My "date from - to" parameters are set to "default" as "=Today()" and "=Now()". Report is delivered fine but I have problems with "link" to that report (attached to email). RS don't add my default parameter values to this link so every time user click this link, report is generated with new "date from" and "date to" and I want to generate exact the same report (same parameters) as in the email. Is there a way to send default parameter values as static values in email delivered report link ? Thanks Maciej
View Replies !
View Related
SQL Mail - Mail Delivered Days Late
I am having a problem with SQL Mail. Setup was no problem, and the initial mail test on SQL, worked fine. Very slow mail delivery has generally occurred ever since then. Mail only seems to get delivered when I log on to NT as `sqlexec` account (that was setup for SQL Mail), and open Exchange to find all the undelivered mail. Even then not all of it is delivered. I have `Check for new mail` option set on Exchange, but there is no delivery except when I log on to the SQL Executive account (which you are not supposed to do). Has anyone had similiary problems - any ideas ?!? Thanks in advance Jasper
View Replies !
View Related
Can't Find Or Load Message DLL. Message DLL Must Be In Path Or In Current Directory.
In my SQL Server, I see the below message in the Application Event Viewer "18265 : Log backed up: Database: HSD, creation date(time): 2007/01/06(05:05:05), first LSN: 1439:495055:1, last LSN: 1439:496675:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'D:MSSQLBACKUPHSDHSD_tlog_200707141300.TRN'})." When I save the application event viewer and open it in another server, I do not see the above message, instead I get the following message: " Can't find or load message DLL. Message DLL must be in path or in current directory." Any thoughts to overcome this problem is appreciated. Thanks Santhosh
View Replies !
View Related
Who Disabled My Job?!
I must introduce myself... Kris Allain. I am a VERY new DBA. Basically I as sort of pushed into the position even though I have no previous DBA experience. I come more from a Net Admin background although I've only graduated with a degree in MIS 2.5 years ago. With that said, I ran into a problem last week in which took down a mission critical application for 4 hours. We have an app that his highly transactional and I'm using the Full Recovery method for this DB with weekly full backups, daily differential backups, and hourly log backups. Someone (could have been me) disabled the log backup job and a couple of days later the log grew until there was no more disk space (35+ gb). Well, it took me 4 hours to back up and shrink the log and get the system up and running again. I told my boss what had happened and now he wants to know who did it. I told him it could've possibly been me, but I highly doubt it because it appears to have been disabled between 7-8pm on my "work from home" day, which I specifically remeber packing it up and playing xbox at 4:30pm. Could someone help me figure out what happened and if there it is possible to track these changes in the future?
View Replies !
View Related
|
TRACKER
