Do you have a question?

First Name:
Surname:
Email:
Phone:
Message:
Get Audio Code

Deleted study not quitting
Last Post 21 Feb 2013 09:52 AM by Steve Wranovsky. 1 Replies.
Printer Friendly
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
Ignacio EUser is Offline
New Member
New Member
Posts:18

--
01 Jan 2013 11:48 AM  

 Dear ImageServer community,

I am having a problem that is stucked in "Web delete scheduled" state.

I have just pressed the delete button and it has been in that state from that moment.

I have opened this new topic because I do not know if anyone is checking the topic where I had published this issue. Please if anyone had experience with anything similar or know what I can look for it will help me a lot because this is urgent for me.

In the application log I see this:

-----------------------------------------------------------------------

 

Exception thrown

Unexpected exception when processing WorkQueue item of type Web Delete Study. Failing Queue item. (GUID: fdc91c45-3d9f-471c-8948-733d4a14f3d9)

ClearCanvas.Enterprise.Core.PersistenceException: Unexpected error with stored procedure: DeleteStudyStorage ---> System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)

at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)

at System.Data.SqlClient.TdsParserStateObject.ReadSniError(TdsParserStateObject stateObj, UInt32 error)

at System.Data.SqlClient.TdsParserStateObject.ReadSni(DbAsyncResult asyncResult, TdsParserStateObject stateObj)

at System.Data.SqlClient.TdsParserStateObject.ReadNetworkPacket()

at System.Data.SqlClient.TdsParserStateObject.ReadBuffer()

at System.Data.SqlClient.TdsParserStateObject.ReadByte()

at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)

at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)

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.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)

at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()

at ClearCanvas.ImageServer.Enterprise.SqlServer2005.ProcedureUpdateBroker`1.Execute(TInput criteria)

--- End of inner exception stack trace ---

at ClearCanvas.ImageServer.Enterprise.SqlServer2005.ProcedureUpdateBroker`1.Execute(TInput criteria)

at ClearCanvas.ImageServer.Ser

--------------------------------------------------

 

If I press the Reprocess study button I get:

--------------------------------------------------

 

Message: Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index

Extra Info: An unspecified error occurred.

Source:mscorlib

Stack Trace:   at System.ThrowHelper.ThrowArgumentOutOfRangeException()
   at System.Collections.Generic.List`1.get_Item(Int32 index)
   at ClearCanvas.ImageServer.Web.Common.Data.StudyController.ReprocessStudy(String reason, ServerEntityKey key)
   at ClearCanvas.ImageServer.Web.Application.Pages.Studies.StudyDetails.Default.ReprocessStudy()


   at ClearCanvas.ImageServer.Web.Application.Controls.MessageBox.OKButton_Click(Object sender, EventArgs e)

   at System.Web.UI.WebControls.ImageButton.OnClick(ImageClickEventArgs e)

   at System.Web.UI.WebControls.ImageButton.RaisePostBackEvent(String eventArgument)

   at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument)

   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

-----------------------------------------

Please, help me with this issue. This is a production server.

Thank you very much in advanced,

Ignacio.

Steve WranovskyUser is Offline
Veteran Member
Veteran Member
Posts:2107

--
21 Feb 2013 09:52 AM  
Ignacio,

Did you try and create a new index on the DestStudyStorageGUID column of the StudyHistory table as mentioned in the other post? Can you check if there are a large number of rows in the StudyHistory table to see if that may be the problem? Otherwise, I'm not sure what to tell you. I believe we have a 30 second timeout on database transactions by default. There must be some operation on your system causing the slow down in database performance.

In any case, if you have any developer questions going forward, please post them in the github issues tracker. We are closing off this forum and want future developer questions to go there.

Steve
You are not authorized to post a reply.

Active Forums 4.1