Getting 504 request getway timeout issue.

harshal bundelkhandi asked on September 4, 2019 13:08

Hi All, While creating any article or publishing any article. sometime i am getting below issue. Can you please help me out below issue.

Thanks, Harshal An error occurred when saving data. Please see event log for more details. Message:

UPDATE CMS_Tree SET [NodeAliasPath] = @NodeAliasPath, [NodeName] = @NodeName, [NodeAlias] = @NodeAlias, [NodeClassID] = @NodeClassID, [NodeParentID] = @NodeParentID, [NodeLevel] = @NodeLevel, [NodeACLID] = @NodeACLID, [NodeSiteID] = @NodeSiteID, [NodeGUID] = @NodeGUID, [NodeOrder] = @NodeOrder, [IsSecuredNode] = @IsSecuredNode, [NodeCacheMinutes] = @NodeCacheMinutes, [NodeSKUID] = @NodeSKUID, [NodeDocType] = @NodeDocType, [NodeHeadTags] = @NodeHeadTags, [NodeBodyElementAttributes] = @NodeBodyElementAttributes, [NodeInheritPageLevels] = @NodeInheritPageLevels, [RequiresSSL] = @RequiresSSL, [NodeLinkedNodeID] = @NodeLinkedNodeID, [NodeOwner] = @NodeOwner, [NodeCustomData] = @NodeCustomData, [NodeGroupID] = @NodeGroupID, [NodeLinkedNodeSiteID] = @NodeLinkedNodeSiteID, [NodeTemplateID] = @NodeTemplateID, [NodeTemplateForAllCultures] = @NodeTemplateForAllCultures, [NodeInheritPageTemplate] = @NodeInheritPageTemplate, [NodeAllowCacheInFileSystem] = @NodeAllowCacheInFileSystem, [NodeHasChildren] = @NodeHasChildren, [NodeHasLinks] = @NodeHasLinks, [NodeOriginalNodeID] = @NodeOriginalNodeID, [NodeIsContentOnly] = @NodeIsContentOnly, [NodeIsACLOwner] = @NodeIsACLOwner WHERE [NodeID] = @NodeID

Caused exception: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

savedocument pagetype

Recent Answers

Roman Hutnyk answered on September 4, 2019 13:12

Have you tried to capture sql query and run it with sql management studio?

0 votesVote for this answer Mark as a Correct answer

Juraj Ondrus answered on September 4, 2019 13:34

The time out error means the SQL query cannot be completed in time - there is either some issue with the DB server, high traffic, slow network or maybe something else is consuming the resources and saving the article is just the last drop. You should use SQL debug or SQL profiler to see what are the most expensive SQL queries.

0 votesVote for this answer Mark as a Correct answer

Peter Mogilnitski answered on September 4, 2019 13:44

Your query is pretty basic. Kentico has a index on nodeid in cms_tree. So update should be done fairly fast. I would assume that your lock is collateral. I would look use sql command sp_who or sp_who2 to whose is blocking your process. It might give you a clue who is blocking the update.

0 votesVote for this answer Mark as a Correct answer