Issues with redirections of artifact URLs

Thursday, November 15, 2012
Avatar
Hello

We're using  SpiraTeam v3.2 (015). Prior to applying patch 15, we could access artifacts directly without providing project ID in the URL , ( http://spira.myserver.com/Incident/33256.aspx was automatically redirected to http://spira.myserver.com/19/Incident/33256.aspx). This is now broken while it was very useful for us to create links to artifacts in SVN/Hg comments. Could you fix this please?

There is another issue with these URLs. We noticed that we could provide any project ID in the URL, Spira would redirect to the right artifact URL with the actual project ID (for Incident 33256 from project 19,
http://spira.myserver.com/14/Incident/33256.aspx redirects to http://spira.myserver.com/19/Incident/33256.aspx ). However, if you provide a project ID that doesn't exist, the application freezes for a few minutes then crashes. Here is the stack trace

Using projectID 0 :

Offending URL: __Page
Source: Business
Message: Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached.
Stack trace: at APPLICATION.Business.DataAccess.RetrieveArtifactFieldsForLists(Int32 projectId, Int32 userId, ArtifactType artifactType) at APPLICATION.Web.PageLayout.CreateShowHideColumnsList(ArtifactType artifactType) at APPLICATION.Web.IncidentList.Page_Load(Object sender, EventArgs e) at System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) at System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) at System.Web.UI.Control.OnLoad(EventArgs e) at APPLICATION.Web.PageLayout.OnLoad(EventArgs e) at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)/


Using a projectID that doesn't exist (or has been deleted) :

Offending URL: __Page
Source: Web
Message: The underlying provider failed on Open.
Stack trace: at APPLICATION.Web.Classes.SpiraWebPartPersonalizationProvider.LoadPersonalizationBlobs(WebPartManager webPartManager, String path, String userName, Byte[]& sharedDataBlob, Byte[]& userDataBlob) at System.Web.UI.WebControls.WebParts.PersonalizationProvider.LoadPersonalizationState(WebPartManager webPartManager, Boolean ignoreCurrentUser) at System.Web.UI.WebControls.WebParts.WebPartPersonalization.Load() at System.Web.UI.WebControls.WebParts.WebPartPersonalization.LoadInternal() at System.Web.UI.WebControls.WebParts.WebPartManager.OnInit(EventArgs e) at System.Web.UI.Control.InitRecursive(Control namingContainer) at System.Web.UI.Control.InitRecursive(Control namingContainer) at System.Web.UI.Control.InitRecursive(Control namingContainer) at System.Web.UI.Control.InitRecursive(Control namingContainer) at System.Web.UI.Control.InitRecursive(Control namingContainer) at System.Web.UI.Control.InitRecursive(Control namingContainer) at System.Web.UI.Control.InitRecursive(Control namingContainer) at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

Here is a screenshot of Window's Task Manager when submitting such an URL, the dw20.exe process gets stuck.




1 Replies
Thursday, November 15, 2012
Avatar
re: nicolas.bernier Thursday, November 15, 2012

Hi Nicolas

Nothing was changed in patch 15 that would have affected this. I suspect that something else may be going on.

Could you please submit a help desk ticket on our website and attach a copy of the Application Event Log from the SpiraTeam server (saved in .EVTX format zipped). That way we can see what's causing the issue.

I would also suggest refreshing the database indexes since you seem to be getting frequent timeout errors from the database.

Regards

Adam

Spira Helps You Deliver Quality Software, Faster and With Lower Risk

And if you have any questions, please email or call us at +1 (202) 558-6885

 

Statistics
  • Started: Thursday, November 15, 2012
  • Last Reply: Thursday, November 15, 2012
  • Replies: 1
  • Views: 3132