Message Could Not Be Delivered Because The Conversation Endpoint Has Already Closed Error In Profiler

Poison Message. The Conversation Endpoint Is Not In A Valid State For SEND.
Hi all, i searched everywhere but couldn't find any info on the following error that i'm currently receiving:

"The conversation endpoint is not in a valid state for SEND. The current endpoint state is 'DI'."

I understand that this is due to some problem in my send/receive protocol but how do i fix this problem so that i can continue with my testing? Right now i'm forced to drop my entire test database and reinstall everytime this message shows up because i can't send/receive any messages at that point. Is there anyway to get rid of it?

Thanks in advance. This is driving me nuts.

View Replies !   View Related

---

&&"The Underlying Connection Was Closed: An Unexpected Error Occurred On A Receive.&&" Endpoint Error
what can cause the above error when connecting to an endpoint via a c# app? the app, and sql are both on my machine ( im just doing this for test purposes and to learn something new.)

View Replies !   View Related

---

This Message Could Not Be Delivered Because Its Message Timestamp Has Expired Or Is Invalid
I run SB between 2 SQL servers. In profiler on an initiator side I see next error: 'This message could not be delivered because its message timestamp has expired or is invalid'. For the conversation we use best practice, i.e. target closes a conversation. Target side succeed to close conversation, but initiator still stay in DO (disconnect_outbound).
What is a reasone for the error? What to do?

View Replies !   View Related

---

This Message Could Not Be Delivered Because Its Message Timestamp Has Expired Or Is Invalid.
I see in profiler this error: "This message could not be delivered because its message timestamp has expired or is invalid"
What is a reason for error?

View Replies !   View Related

---

Detailed Error Message For Conversation Marked With ER
 

Hello,
How can I find the cause on the error that marked one conversation with status 'ER' in sys.conversation_endpoints?
 
Thanks in advance.

View Replies !   View Related

---

Closed Conversation Endpoints Not Being Purged
We have been having a problem with service broker for quite a while now and searching on these forums and more generally on the web has not yielded any kind of answer...

Our application utilises service broker within a single database (there is no cross database, cross instance or cross server communication).  There are approximately 12 queues which are used to varying degrees.  A few of the queues have a throughput rate in the order of up to 100s per minute at peak periods.

In some scenarios we are able to make use of persistent conversations but the majority of messages are sent on their own conversation or in small batches on their own conversation.

Some time ago we found that the database was growing in size more than expected due to a build up of data in the service broker meta data internal tables, exposed via the sys.conversation_endpoints system view.

We identified a problem in the application that was preventing some conversations from being closed and have now fixed this.

However, we are still experiencing a build up in the service broker tables and sys.conversation_endpoints shows this is now due to a very large number of conversations in the "CLOSED" state.

I know that conversations are kept around to prevent replay attacks but thought they were supposed to be cleared after about 30 minutes.  This is certainly not happening as we currently have conversations that were opened on the 18th September, a full week ago.  We currently have about 350,000 closed conversations and this figure is increasing!

We have tried restarting the SQL Server instance with no effect.

I have been using a script to loop through all closed conversations and get rid of them using the "WITH CLEANUP" clause but I'm loath to create a scheduled task that does this in the background when service broker should be doing the job itself.

Has anybody experience this problem and, even better, have any idea how to solve it?

Daniel

 

View Replies !   View Related

---

Target Conversation Endpoint Not Clearing Out
Hi There

 

I am ending conversations properly for a dialog, the end conversation at the target properly marks the conversation as closed in sys.conversation_endpoints and sends the EndDialog message to the initiator.

The initiator get the EndDialog message from the target and ends the  conversation and it clears out of sys.conversation_endpoints.

 

I know that to avoid reply attacks that the conversation at the target will only clear out in 30 minutes.

 

However it has been a day now and the conversation is still sitting in sys.conversation_endpoints as CLOSED at the target.

 

How do i troubleshoot this ? Why is the conversation not clearing?

 

Thanx

View Replies !   View Related

---

This Message Could Not Be Delivered Because It Is Duplicate
    When I send message from Server1 to Server2,I found the error "This message could not be delivered because it is duplicate" in SQLProfiler on Target, why message can be duplicate ? who can help me?

View Replies !   View Related

---

SQL Server Profiler Error Message
Whenever I try to start a trace from my local machine I keep getting an error message stating,

"The operation could not be completed because your security context could not be impersonated. Use the SQL Server Client Configuration Application to ensure that ou are connecting using either the named pipes or multiprotocal network library."

I am currently using TCP/IP as my network library. Even if I try changing to one of the other network libraries I get the same error. I have no problem connecting to the server, its just when I try to create a trace. I have sysadmin permissions.

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

---

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 Replies !   View Related

---

From The Sql Profiler Constantly Displays Exec Sp_executesql N'BEGIN CONVERSATION TIMER ... It That Ok?
Hello,
I'm using SQL service Broker 2005 with ASP.NET 2.0 in order to use the sql cache dependency.
everything works fine...
I have only a doubt regarding  a query that is constantly executed on mu db ( i can see it be means of the SQL Profiler)

The query is:
exec sp_executesql N'BEGIN CONVERSATION TIMER ("'') TIMEOUT = 120; WAITFOR(RECEIVE TOP (1) message_type_name, conversation_handle,
cast(message_body AS XML) as message_body from [SqlQueryNotificationService-GUID]), TIMEOUT @p2;',N'@p2 int',@p2=60000

The web application is not running from a browser ...

It this ok or I forget to clean/reset something from my web application and/or sql server?

Thank you

Marina B.

 

 

 

View Replies !   View Related

---

Service Broker Sending Message To Self. Start Conversation With Self
I've got a situation where I want to put request message on a queue. Because starting a conversation is the only way to put messages on a queue I have to start a conversation with myself. So my Begin Dialog Statement looks something like this:

 

DECLARE @conversation_handle UNIQUEIDENTIFIER;

BEGIN DIALOG CONVERSATION @conversation_handle

FROM SERVICE [ServiceName1]

TO SERVICE 'ServiceName1'

ON CONTRACT [ContractName1]

WITH ENCRYPTION = OFF;

SELECT @conversation_handle AS ConversationHandle

 

I haven't noticed any problems with doing this but I wanted to know if there was anything wrong with it. Does someone know what problems this might cause?

View Replies !   View Related

---

Error Log Peppered With --&&> 'The Conversation Handle Is Missing. Specify A Conversation Handle.'
Hi

I'm using service broker and keep getting errors in the log even though everythig is working as expected

SQL Server 2005
Two databases
Two end points - 1 in each database
Two stored procedures:
SP1 is activated when a message enters the sending queue. it insert a new row in a table
SP2 is activated when a response is sent from the receiving queue. it cleans up the sending queue.

I have a table with an update trigger
In that trigger, if the updted row meets a certain condition a dialogue is created and a message is sent to the sending queue.
I know that SP1 and SP2 are behaving properly because i get the expected result.
Sp1 is inserteding the expected data in the table
SP2 is cleaning up the sending queue.

In the Sql Server log however i'm getting errors on both of the stored procs.
error #1
The activated proc <SP 1 Name> running on queue Applications.dbo.ffreceiverQueue output the following:  'The conversation handle is missing. Specify a conversation handle.'

error #2
The activated proc <SP 2 Name> running on queue ADAPT_APP.dbo.ffsenderQueue output the following:  'The conversation handle is missing. Specify a conversation handle.'

I would appreceiate anybody's help into why i'm getting this. have i set up the stored procs in correctly?

i can provide code of the stored procs if that helps.

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

---

In Service Broker Message &&" Dialog Security Is Not Available For This Conversation...&&"
when ever I send my message thru Service Broker I am getting an error message like this "

 

"Dialog security is not available for this conversation because there is no remote service binding for the target service. Create a remote service binding, or specify ENCRYPTION = OFF in the BEGIN DIALOG statement."

 

This I found in sys.transmission_queue

Please reply with your comments

View Replies !   View Related

---

Object Closed Error
I'm getting object closed when returning a recordset from a stored procedure. I've tested the select statement in Query Analyzer and a value is getting returned. So, I'm not sure if my code for my stored procedure is incorrect?

Here is the code for the procedure:

CREATE Procedure dbo.GetRepEmailByZip

@sessionid varchar(50),
@zip varchar(5)

AS

Begin Transaction

INSERT INTO dbo.SupportRequests(firstname,lastname,schoolname, address,city,state,zip,phone,email,currentcustomer ,implementationtype,producttype,comment)
(SELECT FirstName,LastName,SchoolName,Address,City,State,Z ip,Phone,Email,CurrentCustomer,ImplementationType, ProductType,Comment
FROM dbo.Temp_ContactInfo
WHERE sessionid = @sessionid)


--If Transacation fails, stop execution of procedure, return error code and Rollback Transaction

IF @@ERROR<>0 OR @@RowCount = 0
BEGIN
ROLLBACK TRANSACTION
--return value
RETURN 1
END

--If Transaction succeeds, commit transaction, continue and process the select statement
COMMIT TRANSACTION

SELECT r.email
FROM PostalCodes p
INNER JOIN TerritoryList z ON p.ZipID = z.ZipID
INNER JOIN RepList r ON r.RepID = z.RepID
WHERE p.ZipCode = @zip
GO



This is the code I'm calling to execute the procedure and return the recordset:


set GetRepEmail = Server.CreateObject("ADODB.Command")
With GetRepEmail
.ActiveConnection = MM_DBConn_STRING
.CommandText = "dbo.GetRepEmailByZip"
.CommandType = 4
.CommandTimeout = 0
.Prepared = true
.Parameters.Append .CreateParameter("@RETURN_VALUE", 3, 4)
.Parameters.Append .CreateParameter("@sessionid", 200, 1,50,usrid)
.Parameters.Append .CreateParameter("@zip", 200, 1,5,zip)
set RepEmail = .Execute()
End With

Dim x, y
x = RepEmail.RecordCount
y = RepEmail.State
Response.Write(x)
Response.Write("<br>")
Response.Write(y)
'Response.Write(RepEmail("email"))
Response.End()


I'm getting "Operation is not allowed when the object is closed", which is occuring on the following line:

x = RepEmail.RecordCount

I'm trying to determine if this is problem within my procedure or in the application code.

Thanks in advance for any help.

View Replies !   View Related

---

Mirroring Setup Endpoint Error
Hi

I am having no luck trying to setup mirroring between remote servers. on local instances is ok.  I went thru both windows and certificate authenication version.  With windows authenication, I checked the troubleshooting steps,

in step 6, Make sure that the login from the other server has CONNECT permission, I ran the query

SELECT EP.name, SP.STATE,
   CONVERT(nvarchar(38), suser_name(SP.grantor_principal_id))
      AS GRANTOR,
   SP.TYPE AS PERMISSION,
   CONVERT(nvarchar(46),suser_name(SP.grantee_principal_id))
      AS GRANTEE
   FROM sys.server_permissions SP , sys.endpoints EP
   WHERE SP.major_id = EP.endpoint_id


but the result does not have the mirroring endpoint that I created and granted connect permission to?

GRANT CONNECT ON ENDPOINT::Mirroring TO [Windowsxxx]

I ran the above statement, but nothing.  Is this an error?

P

View Replies !   View Related

---

How To Fix This Error? (There Is Already An Open DataReader Associated With This Command Which Must Be Closed First.)
This is my code:1 If Session("ctr") = False Then
2
3 Connect()
4
5 SQL = "SELECT * FROM counter"
6 SQL = SQL & " WHERE ipaddress='" & Request.ServerVariables("REMOTE_ADDR") & "'"
7 dbRead()
8
9 If dbReader.HasRows = True Then
10
11 dbReader.Read()
12 hits = dbReader("hits")
13 hits = hits + 1
14 dbClose()
15
16 SQL = "UPDATE counter SET hits=" & hits
17 SQL = SQL & " WHERE ipaddress='" & Request.ServerVariables("REMOTE_ADDR") & "'"
18 dbExecute()
19
20 Else
21
22 SQL = "INSERT INTO counter(ipaddress,hits)"
23 SQL = SQL & " VALUES('" & Request.ServerVariables("REMOTE_ADDR") & "',1)"
24 dbExecute()
25
26 End If
27
28 Session("ctr") = True
29
30 End If
 1 Public Sub Connect()
2 Conn = New SqlConnection("Initial Catalog=NURSETEST;User Id=sa;Password=sa;Data Source=KSNCRUZ")
3 If Conn.State = ConnectionState.Open Then
4 Conn.Close()
5 End If
6 Conn.Open()
7 End Sub
8
9 Public Sub Close()
10 Conn.Close()
11 Conn = Nothing
12 End Sub
13
14 Public Sub dbExecute()
15 dbCommand = New SqlCommand(SQL, Conn)
16 dbCommand.ExecuteNonQuery()
17 End Sub
18
19 Public Sub dbRead()
20 dbCommand = New SqlCommand(SQL, Conn)
21 dbReader = dbCommand.ExecuteReader
22 End Sub
23
24 Public Sub dbClose()
25 SQL = ""
26 dbReader.Close()
27 End Sub
 

View Replies !   View Related

---

Create Endpoint Fails With Error 0x800704be
I am trying to create an endpoint with the code below and get the following error

An error ('0x800704be') occurred while attempting to register the endpoint 'getFormsEP'.


Anyone any ideas on what this error means?

Please help if you can.

Regards, Major (that is my Christian name ;-)

 

Code

create endpoint getFormsEP
state = started
as http
(
 site='ictdwt10mt',
 path='/EndPoints',
 authentication=(integrated),
 ports=(clear),
 clear_port=84
)
for soap
(
 webmethod 'getForms'
 (
  name='EForms21.dbo.getForms',
  schema=standard,
  format=rowsets_only
 ),
 wsdl=default,
 login_type=windows,
 database='EForms21',
 schema=none
)

View Replies !   View Related

---

Failure To Create Endpoint, Error 15145
 

Hi,
I have system with SQL Server 2K5 SE 3042 SP2 . I was able to set up mirroring with primary-mirror-witness arrangement through GUI.
In this company I replaced another DBA who left,  and the way our sys admin arranged our logins  co-existed in domain for a while.  Then sys admin, after mirroring was done, removed my login, renamed other DBA's login with mine, and removed his.
 Now I cannot create endpoint, either by t-sql or through GUI: "An implicit login creation has failed. Reason: the login may have been dropped or its name may already be in use, error 1545".
 
After pressing Start Mirroring the following shows: "Database Mirroring Transport is disabled in the endpoint configuratin, error 1486". The 2nd error understandable in view of the 1st one.
I checked  sys.database_mirroring_endpoints, it is empty. Anyone has an idea what this implicit login is, and where to look for it?
 
Vladimir Kievsky
 

View Replies !   View Related

---

Large Reports - Error: &&"The Underlying Connection Was Closed: An Unexpected Error Occurred On A Receive.&&"
First off I understand that it is a horrible idea to run extremely large/long running reports, but sometimes it ends up being the best possible solution due to external forces.




I've got a 25,000 page report that we recently converted from crystal reports to SSRS. The SSRS server is a 64bit 2003 server with 32 gigs of ram running SSRS 2005. When running the report through the report manager web application, it renders in the browser/viewer after about 12 minutes. Exporting to pdf through the browser/viewer in the report manager takes an additional 55 minutes. It does work and it produces a whopping 1.03gb pdf.




Unfortunately, I've run into a problem when trying to do this from a console application using the SSRS client API. After about 30-35 minutes I get an exception on the client with the following error:
Exception Message: The underlying connection was closed: An unexpected error occurred on a receive.
InnerException = Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host.

Here is the api call:




Code Snippet

byte[] m_data = reportingService.Render(this.ReportPath, this.ExportFormat, null,
deviceInfo, selectedParameters, null, null, out encoding, out m_mimeType,

out usedParameters, out warnings, out streamIds);
Here are some things I've tried so far:


set the HttpRuntime ExecutionTimeout value to 3 hours on the report server
disabled http keep alives on the report server
increased the script timeout on the report server
set the report to never time out on the server
set the report timeout to several hours on the client call
Disabled antivirus on the client side, and verified there was no antivirus running on the reporting server.
Tried using default credentials in the ReportingService object as opposed to supplying credentailsAny ideas would be appreciated. I understand the best solution is to split the report up into smaller reports, which is the backup option, but being able to keep it as one report is the goal.

View Replies !   View Related

---

EM Error 'connection Forcibly Closed By The Remote Host' (ouch)
I am getting this error in Enterprise Manager:
TCP Provider: An existing connection was forcibly closed by the remote host.

But, my web app can still connect just fine to the db, so it's still in
the same place with the same login/password.  And my registration
in EM was working just fine (for years) until yesterday I got this
error.  I've tried deleting the registration and re-creating it
but the same thing.  What could have gone wrong to cause this to
happen? 

Thanks for any pointers, I have no idea where to start looking on this one, the host says they haven't changed anything...

View Replies !   View Related

---

Sql Server Reporting Services Error The Underlying Connection Was Closed
 

Hi,

 
We have a mature instance of SQL Server 2000 reporting services that has stopped working for no apparent reason. When browsing to http://reportserver/reports we receive the following error

 

Error



The underlying connection was closed: Unable to connect to the remote server.



Home

The installation is running on three servers - 1 sql cluster (sql 2000 sp4) and two IIS servers all running windows 2000 sp4.
 
The Reportserver website runs using identity impersonation using the .net machine.config file pointing to an encrypted registry key entry holding the userid and password. It has been moved from the default website to it's own website but has been working with no issues for years. No obvious patches have been applied or security changes made that could effect the application
 

When browsing to http://reportserver/reportserver we can view the loaded reports and even run them with no issues, only ther report manager isn't working.

I have tried changing the impersonation registry key ( using aspnet_setreg ) and the account the reportserver web service runs under ( using the rsconfig utiltity) to be a domain admin to no effect and I have checked and set specififc permission for the reportserver database on all registry keys to no effect.
 
None of the online solutions for this issue have worked for me. Any help or ideas would be greatly appreciated
 

Cheers
 

Daniel Worby

Database Administrator

AMP Capital Investors

(p) +61 2 9257 1746

(m)+61 434 327 150

(f) + 61 2 9257 1090

(e) daniel.worby@ampcapital.com

(w) www.ampcapital.com.au

View Replies !   View Related

---

Conversation ID Cannot Be Associated With An Active Conversation
Hi:

My service broker was working perfectly fine earlier. As I was testing...I recreated the whole service broker once again.

Now I am able to get the message at the server end from intiator. When trying to send message from my server to the intiator it gives this error in sql profiler.

broker:message undeliverable:  This message could not be delivered because the Conversation ID cannot be associated with an active conversation. The message origin is: 'Transport'.

broker:message undeliverable This message could not be delivered because the 'receive sequenced message' action cannot be performed in the 'ERROR' state.

How do I proceed now ?

Thanks,

Pramod

View Replies !   View Related

---

TCP Provider, Error: 0 - An Existing Connection Was Forcibly Closed By The Remote Host
We are getting a problem when the below error Log

Server: SQL Server 2005 and SP1.

 

Then, All the Web Servers will drop all connections and stop the network service. Later, the network service will start up automatically but all the before service is dropped.

We would like to know the error coming from?

 

Error Log

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

 TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host 

 

Event Type: Warning
Event Source: ASP.NET 2.0.50727.0
Event Category: Web Event
Event ID: 1309
Date:  4/29/2006
Time:  10:48:47 AM
User:  N/A
Computer: 88DBWEB0
Description:
Event code: 3005
Event message: An unhandled exception has occurred.
Event time: 4/29/2006 10:48:47 AM
Event time (UTC): 4/29/2006 2:48:47 AM
Event ID: 77910e6688484582bb1c29808feef883
Event sequence: 128
Event occurrence: 13
Event detail code: 0
 
Application information:
    Application domain: /LM/W3SVC/24978983/Root/ph-3-127907437121075328
    Trust level: Full
    Application Virtual Path: /ph
    Application Path: D:DB88ph
    Machine name: 88DBWEB0
 
Process information:
    Process ID: 1568
    Process name: w3wp.exe
    Account name: NT AUTHORITYNETWORK SERVICE
 
Exception information:
    Exception type: SqlException
    Exception message: A transport-level error has occurred when sending the request to the server. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.)
 
Request information:
    Request URL: http://88db.jobsdb.com/ph/Views/MediaUpload.aspx?PostID=50202&Type=I&panelid=postimagediv
    Request path: /ph/Views/MediaUpload.aspx
    User host address: 192.168.10.10
    User: 50077
    Is authenticated: True
    Authentication Type: Forms
    Thread account name: NT AUTHORITYNETWORK SERVICE
 
Thread information:
    Thread ID: 15
    Thread account name: NT AUTHORITYNETWORK SERVICE
    Is impersonating: False
    Stack trace:    at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParserStateObject.WriteSni()
   at System.Data.SqlClient.TdsParserStateObject.ExecuteFlush()
   at System.Data.SqlClient.TdsParser.TdsExecuteRPC(_SqlRPC[] rpcArray, Int32 timeout, Boolean inSchema, SqlNotificationRequest notificationRequest, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteReader()
   at System.Web.SessionState.SqlSessionStateStore.DoGet(HttpContext context, String id, Boolean getExclusive, Boolean& locked, TimeSpan& lockAge, Object& lockId, SessionStateActions& actionFlags)
 
 
Custom event details:

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


 

View Replies !   View Related

---

Framework 2.0 Changes - TCP Provider, Error: 0 - An Existing Connection Was Forcibly Closed By The Remote Host.
If you connect to a server and open a query in SQL Managment studio (2005) and looses connection and then regain the connection, when you try to run the query it gives me a "TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host."   This happens against both 2005 and 2000 servers.   If I re-run the query it works.   However, this happens in our VB.NET app as well for clients with Wireless connections.   So, something has changed in Framework 2.0 regarding this, does anyone know how to tell the client to not throw this error and just try connecting the server instead which will work?  

View Replies !   View Related

---

An Error Occurred While Receiving Data: '10054(An Existing Connection Was Forcibly Closed By The Remote Host.)'.
What does this error mean? I get this in the transmission_status column of  sys.transmission_queue

An error occurred while receiving data: '10053(An established connection was aborted by the software in your host machine.)'.

Also, does the number in this message correspond to error 10053 in sys.messages?

Thanks

 

 

 

View Replies !   View Related

---

Can No Longer Access Report Manager - The Underlying Connection Was Closed: An Unexpected Error Occurred On A Receive.
 

Hi,
 
For a long time I've had SQL Server 2000 with RS on a Server2003 machine. 
When I want to publish a report from my Dev box, I remove anon. access on the Production machine, deploy the report, then go into report manager to tweak a couple of parameters.  I then re-enable anon. access so users can continue.

 
Yesterday, I removed anon. access and deployed the report but when I went into Report Manager I received the above error message... "The underlying connection was closed: An unexpected error occurred on a receive."

 
I can get into report manager with anonymous access enabled, but I don't have authority to do anything.
 
 
What's happened!!!?   More importantly, how do I fix it?

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 With Profiler
I get the following error when I try to run Profiler from my client to any of our SQL Servers:
[Microsoft][ODBC SQL Server driver][SQL Server] The operation could not
be completed because your security context could not be impersonated.

Use the SQL Server client configuation application to ensure that you are
connecting using either the Named Pipes or Multiprotocol network library.

We'd like to be able to use TCP/IP for this but I've tried it with Multiprotocol also and still get the same error message.

I would appreciate any suggestions for resolving this.

Thanks.
Jane

View Replies !   View Related

---

Provider: TCP Provider, Error: 0 - An Existing Connection Was Forcibly Closed By The Remote Host.
Hi,

One of our customers is getting this error about 3-4 times a day, in an .NET application that runs 24/7:

(provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.)

They have several App servers, Windows 2003 SP1 32 bit... connecting to several SQL 2005 SP 1 servers, 64 bit. All of their 4 application servers have had this error with 3 or 4 different SQL instances running on 4 different SQL servers.

There is a firewall in between but that does not seem to be the problem. We use the same firewall setup in dozens of environments without any issues like this, and the firewalls are not imposing any maximum TCP session times.

There are lots of people reporting this same problem with SQL 2005 only - it does not seem to be an issue with the same applications running against SQL 2000.

Any hints as to how to fix these errors? I am going to try adjusting the Keep Alive setting in the SQL client config to 10000 instead of 30000 but judging by the number of people getting this error, this seems to be some sort of bug with .NET's connection pooling and SQL 2005.

People are saying the easiest way to reproduce this is to do a SQL query.... unplug the network cable and plug it back in again... then run another query. They say it causes this error every time, but I have not tested this since we are only seeing this problem in a production environment.

Thanks for your help,
Jeremy

View Replies !   View Related

---

[XML Task] Error: An Error Occurred With The Following Error Message: There Are Multiple Root Elements.
I'm trying to use an XML Task to do a simple XSLT operation, but it fails with this error message:

[XML Task] Error: An error occurred with the following error message: "There are multiple root elements. Line 5, position 2.".

The source XML file validates fine and I've successfully used it as the XML Source in a data flow task to load some SQL Server tables.  It has very few line breaks, so the first 5 lines are pretty long: almost 4000 characters, including 34 start-tags, 19 end-tags, and 2 empty element tags.  Here's the very beginning of it:

<?xml version="1.0" encoding="UTF-8"?>
<ESDU releaselevel="2006-02" createdate="26 May 2006"><package id="1" title="_standard" shorttitle="_standard" filename="pk_stan" supplementdate="01/05/2005" supplementlevel="1"><abstract><![CDATA[This package contains the standard ESDU Series.]]></abstract>

There is only 1 ESDU root element and only 1 package element.

Of course, the XSLT stylesheet is also an XML document in its own right.  I specify it directly in the XML Task:

<?xml version="1.0" encoding="UTF-8"?>

<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"/>

<xsl:template name="identity" match="@*|node()">
  <xsl:copy>
    <xsl:apply-templates select="@*|node()"/>
  </xsl:copy>
</xsl:template>

<xsl:template match="kw">
  <xsl:copy>
    <xsl:apply-templates select="@*"/>
      <xsl:attribute name="ihs_cats_seq" select="position()"/>
    <xsl:apply-templates select="node()"/>
  </xsl:copy>
</xsl:template>

</xsl:stylesheet>


Its 5th line is the first xsl:template element.

What is going on here?  I do not see multiple root elements in either the XML document or the XSLT stylesheet.

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

---

DTS Exception Error In Profiler. Help!
I'm doing a large DTS operation across systems and it is going REALLY slowly. This has been running over 24 hours. The disc is constantly pegged at 100% usage and I don't see any reason why it should be.

There are no recent entries in the "SQL Server Logs". I started a profile and am watching for data file grows, log file grows, and exceptions. I get lots of exception records with application name "DTS Designer". TextData is:

Error: 911, Severity: 16, State: 1

I've looked through BOL and Google and I can't find anything on diagnosing these errors. Any ideas?

View Replies !   View Related

---

XML Sample Gets Error: &&"CREATE ENDPOINT&&" Not Supported
I installed the latest version of SQLX and tried to run the XML sample.

C:Program FilesMicrosoft SQL Server90SamplesEnginexmlXmlManuInstructionsReadMe_OnlineManuInstr.htm

The first part of the install.sql ran ok, but it chokes on the CREATE ENDPOINT line: is this really a limitation on the Express edition or did I miss something on installation or configuration?

Msg 7878, Level 16, State 1, Line 3

This "CREATE ENDPOINT" statement is not supported on this edition of SQL Server.

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

---

Profiler Error Data Column
I run Profiler against my production Db to keep an eye on poorly performing t-SQL batches and SPs.  There's an "Error" column in the profiler output.  According to BOL (topic:Describing Events by Using Data Columns), Error = The error number of a given event. Often this is the error number stored in sysmessages.

The profiler output usually shows "0 - OK" in the error column.  But it sometimes shows "1 - Error" or "2 - Abort" in this column.  What do these error messages mean?  I've looked around but haven't been able to find anything more detailed about what these two messages mean and how I can perhaps dig deeper to figure out what's going on.  (When these values are displayed, CPU is usually taking a beating and the SPID runs this for at least 30 seconds before displaying information pertaining to this SPID).

Thanks much,

Smitha

View Replies !   View Related

---

SQL Server 2005 Profiler Error
I SQL Server 2005 Profiler when ran the T- SQL template against some Stored Procedures, in the error column i get 2 - Abort. Can some one help me on this issue.

 

Thanks

 

View Replies !   View Related

---

Sql Profiler And Error: 2627, Severity: 14, State: 1
I am running trace with properies
Event classes
--> Exeptions
-->TSQL (all events)

result

event class text
----------- ----
exeption Error: 2627, Severity: 14, State: 1

What event classes should be added to capture what cause this error ?

from BOL
----------------------------------------------------------------
Severity Levels 11 through 16
These messages indicate errors that can be corrected by the user.

(2627 14 Violation of %ls constraint '%.*ls'. Cannot insert duplicate key
in object '%.*ls'. )
------------------------------------------------------------------

Alex

View Replies !   View Related

---

Profiler Does Not Comment Out Security Related Commands When There Is An Error In The Batch
i am testing some encryption
scenarios ,in profiler the statements like "OPEN KEY" and all "Encrypt"
and "Decrypt" functions are removed automaticly from the trace
and replaced with a comment ,create a trace and try the code i attached ,
you will see in profiler trace that that all encryption related commands
are commented out ,this is what expected.

but now go to the batch and comment out the "SELECT @rrr' statment,
and run the batch ,this batch will fail beacuse "@rrr" is not declared,
now go back to profiler and you will see that for the failed batch
all the encryption command are NOT COMMENTED OUT !!!
esspecially important is the visibility of the password of the open key command.


seems like a very dangerous bug to me!!!

CREATE CERTIFICATE test1
     ENCRYPTION BY PASSWORD = 'pGFD4bb925DGvbd2439587y'
     WITH SUBJECT = 'Sammamish Shipping Records',
     EXPIRY_DATE = '10/31/2009';
    GO
    
    CREATE SYMMETRIC KEY Key09 WITH ALGORITHM = TRIPLE_DES
     ENCRYPTION BY CERTIFICATE test1;
    GO
    declare @Str nvarchar(100)
    declare @Enc varbinary(max)
    set @Str = 'encrypt this'
    OPEN SYMMETRIC KEY Key09
     decryption by CERTIFICATE test1 WITH PASSWORD = 'pGFD4bb925DGvbd2439587y'
    
    SET @Enc
     = EncryptByKey(Key_GUID('Key09'), @Str);
    ---select @rrr
    select CONVERT(nvarchar(100), DecryptByKey(@Enc))
    go


 

 

View Replies !   View Related

---

[File System Task] Error: An Error Occurred With The Following Error Message: &&"Access To The Path Is Denied&&"
Hi -
 
I have an File System Task that copies a file from one directory ot another. When I hard code the  target directory (c:dirfile.txt) it works fine. When I change it to a virtual directory (\serverdirfile.txt) I get a security error:
 
[File System Task] Error: An error occurred with the following error message: "Access to the path '\gracehbtest oS2TMM_Live_Title_000002.xml' is denied.".
 
Where do I change the security settings?
 
Thanks - Grace

View Replies !   View Related

---

SQL Server Error Message - Operating System Error 10038: An Operation Was Attempted On Something That Is Not A Socket...
My apologies...I wasn't for sure where to post an error like this...

Over the last 2 months I have gotten this SQL Server error (twice).  All existing processes will continue to work, however no new processes can be created and users cannot connect to the server.  This is the exact text of the message in the SQL Server error log.

Operating system error 10038: An operation was attempted on something that is not a socket...

Error: 17059, Severity: 18, State: 0

Error accepting connection request via Net-Library 'SSNETLIB'. Execution continuing.

Error: 17882, Severity: 18, State:

While we can typically just stop SQL Server Service and restart the services...I have found it is best to restart the machine during non-production times to take care of any 'residual' effects of this error.

The SQL Server 2000 SP4 box with Windows 2003 Standard SP1 is well maintained by our I.T. team and it typically will run 4 or 5 months without a reboot.

 

Thank you...

...cordell...

View Replies !   View Related

---

Error While Calling The Roles.AddUserToRole (error Message: Cannot Resolve Collation Conflict For Equal To Operation)
Hi, I have developed a website in asp.net 2. I have tester it and it is working fine on my computer but when I have uploaded it to my server I'm getting an error message when the user signup. The error occurs when I'm setting the user role to 'members'.
 
Error line > Roles.AddUserToRole(user.UserName, "members")
 
The strage thig is that it is working on my computer but not on the server. My home computer and the server are running the same software versions and the website database is the same as well.
 
To double check that my code is not generating the error I have lonched 'SQL Query Analizer' and executed the folowing code on my database:
NOTE: In my database I have create the user “teeluk12� and a role “members�
 
aspnet_UsersInRoles_AddUsersToRoles "/", "teeluk12", "members", "5/02/2006 4:44:33 pm"
 
Once again the code is working on my home computer but not on the server. On the server I'm getting the following error:
 
Server: Msg 446, Level 16, State 9, Procedure aspnet_UsersInRoles_AddUsersToRoles, Line 76
Cannot resolve collation conflict for equal to operation.
 
 
 
Does anybody know what could cause the error?
Could it be some permissions that I didn't set on my server?
 
 
Thanks for my help and suggestions...
Regards,
Gonzal
 

View Replies !   View Related

---

Error 7399: OLE DB Driver 'MSDAORA' Reported An Error Message.
Hello,

I am trying to create a Linked Server to Oracle via SQL Server 7.0. The OS on the machine is Windows NT 4.0 and the version of the MDAC is 2.6. I have installed Oracle 8.1.7 client on my machine. I created the linked server using the follwoing scripts:


exec sp_addlinkedserver 'Link', 'Oracle', 'MSDAORA', 'Link'

exec sp_addlinkedsrvlogin 'Link', false, null , 'scott', 'tiger'

The messgage is shown as "Server Added". But when I go to Enterprise Manager and expand the LINK server, it give me the follwoing error:

Error 7399: OLE DB driver 'MSDAORA' reported an error message.

I am able to conenct to the Oracle DB using SQL Plus.

Please let me know if anyone has faced a similar issue.

Thanks

View Replies !   View Related

---

Famous Named Pipes Provider, Error 40 Error Message
Trying to connect to remote server croaktoad.simpli.biz
I have SQL 2005 Developer on XP SP2 ,  I have disabled my windows firewall.  I can ping to my server (croaktoad.simpli.biz) and i get no error message. My remote connection using both TCP/IP and named pipes are checkeed. My SQL Server Browser is running as well.
 
 However when I try to connect using Managment Studio or running SQLCMD /Scroaktoad. simpli.biz /E I get the following error message
 
C:sqlcmd /Scroaktoad.simpli.biz /E
HResult 0x52E, Level 16, State 1
Named Pipes Provider: Could not open a connection to SQL Server [1326].
Sqlcmd: Error: Microsoft SQL Native Client : An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections..
Sqlcmd: Error: Microsoft SQL Native Client : Login timeout expired
 

So I've read all the forums for past 2 days and tried everything, nothing changed Any ideas?

View Replies !   View Related

---

Error List With Appropriate Error Number And Error Message
where can i find it?
 
 thanks

View Replies !   View Related

---