Dtyjlui

I have been trying to publish a Dynamic Component Presentation but for some reason it keeps on failing with the following error:

When I preview the same component in the CMS getting below error:

Execution Timeout Expired. The timeout period elapsed prior to
completion of the operation or the server is not responding. The wait
operation timed out

This looks like a typical timeout issue and there are a lot of similar question on this topic. The first thing to check is whether you have regular database maintenance performed? If not, do one (and start doing it on a regular basis, if possible daily) and try again. Database maintenance (Tridion specific) described here.

You could increase the timeouts as described here, but in most cases that is just masking the problem.

Similar questions:

• SDL Tridion 2011 GUI Performance for large components


• How to remove the transaction time out error?


• Unable to save Multimedia Component


• Timeout Expired for DecommissionPublicationTarget Tridion 8.5

Timeout errors on a database pointing to lacking database maintenance, so first things I would recommend to look at is updating the database stats and rebuilding the indexes.

Always make sure you do regular database maintenance or its performance will deteriorate over time.

Ask your DBA team to schedule to run this sp_updatestats daily every 2hr or 3hr interval, Its'depends on your business how frequent CME used by the editor for content creation and editing.

I hope it helps

The components which were failing while publishing/previewing due to the database error was due to the Razor template which was taking more 90 to 200sec to execute that was causing the issue.

To resolve the above issue:

On the CMS and Publisher server went to the Programs > SDL Web > SDL Web Content Manager configuration in the Microsoft Windows Start menu.

Navigate to the Timeout settings section

In that we increased the timeout value from 50sec to 900sec for the Seconds before a timeout error is generated when executing a query.

After increasing the timeout restarted COM+ and required services on both the server to ensure updated settings are used.

With the above changes publishing was going smooth but it was taking more time at rendering phase and apart from these few more observations are:

1. In the CMS DB when we checked the CPU usage was high sometimes it was reaching up to 99%.


2. In the Publisher server when checked the Event Viewer in the application and server logs -> navigate to tridion when we are publishing template issues related components getting "n" no of warnings.

After trying with multiple options we came to know that main culprit is "Razor Template".

In the razor template we are calling function called "GetTemplateId("CPTest_CT") which was causing the issue.

To resolve this issue as per time being wherever they are calling GetTemplateId passing the hardcoded id of component template. After doing this changes all the above issues got resolved.

I'm explaining in detail if next time anyone encounter this issue it may help.