1

When attempting to rebuild the links database on the master database I'm getting the following exception:

Job started: RebuildLinkDatabasesIndex|System.InvalidOperationException: This SqlTransaction has completed; it is no longer usable.
  at System.Data.SqlClient.SqlTransaction.ZombieCheck()
  at System.Data.SqlClient.SqlTransaction.Rollback()
  at Sitecore.Data.DataProviders.Sql.DataProviderTransaction.Dispose()
  at Sitecore.Links.SqlLinkDatabase.<>c__DisplayClassf.<UpdateLinks>b__d()
  at Sitecore.Data.DataProviders.NullRetryer.ExecuteNoResult(Action action, Action recover)
  at Sitecore.Links.SqlLinkDatabase.UpdateLinks(Item item, ItemLink[] links)
  at Sitecore.Links.LinkDatabase.RebuildItem(Item item)
  at Sitecore.Links.LinkDatabase.RebuildItem(Item item)
  at Sitecore.Links.LinkDatabase.RebuildItem(Item item)
  at Sitecore.Links.LinkDatabase.RebuildItem(Item item)
  at Sitecore.Links.LinkDatabase.RebuildItem(Item item)
  at Sitecore.Links.LinkDatabase.RebuildItem(Item item)
  at Sitecore.Links.LinkDatabase.RebuildItem(Item item)
  at Sitecore.Links.LinkDatabase.Rebuild(Database database)
  at Sitecore.Shell.Applications.Dialogs.RebuildLinkDatabase.RebuildLinkDatabaseForm.Builder.Build()|Job ended: RebuildLinkDatabasesIndex (units processed: )

It suggests in this article that this is due to a Sql timeout, controlled by the following setting:

<setting name="DefaultSQLTimeout" value="00:05:00" />

But the error appears after approximately 2 minutes, not 5.

Improve this question
3
  • What sitecore version? Do you have multiple CM servers?
    – Mark Gibbons
    Oct 31, 2018 at 22:42
  • 8.2 update 2. 1 cm & 1 cd (it's a test environment).
    – David Masters
    Nov 1, 2018 at 4:23
  • Two solutions suggested on this ticket. Although its fairly old they might be worth a try. stackoverflow.com/questions/13408625/…
    – TomT
    Nov 13, 2018 at 3:28

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Browse other questions tagged or ask your own question.