Umbraco Examine Indexer exception when rebuilding index

Question

When updating Umbraco to the latest version 7.4.3, we get a Sqlexception when Index rebuilds on app start. The message is: "Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding".

We have a db with extremely much content. The rebuild works if we set supportUnpublished="false". Does anyone recognize this error?

I have seen this error message when we try to republish large websites with 1000s of nodes. this is mainly due to connection timeout between umbraco and sql server. Is your sql server live in the same sever as that IIS placed or in a different server? Checking your sql server timeout setting would be helpful. — Dimuthu Nilanka, Jun 08 '16 at 16:23
Hi. Did you find a solution to this problem? I get exactly the same, and have "fixed" it by setting supportUnpublished="false" — Engern, Feb 08 '17 at 08:41

score 0 · Answer 1 · edited May 23 '17 at 12:33

0

I think you might need to add the 'ConnectionTimeout' property to your connection string. See the post below:

Connection timeout for SQL server

Goodluck

Craig

edited May 23 '17 at 12:33

Community

1
1

answered Jun 09 '16 at 12:55

Craig Mayers

185
2
9

I have tried setting 'ConnectionTimeout' to wait unlimited amount of time but it still does not work. – Fredrik Palmér Jun 14 '16 at 06:38
You must have a lot of data! What about if you delete the indexes then restart your App and let Umbraco regenerate them on startup? – Craig Mayers Jun 15 '16 at 08:05

Umbraco Examine Indexer exception when rebuilding index

1 Answers1