SF 4.1 Row Not Found (OptimisticVerificationException)
Not sure if it can be reproduced. We had a page with double quotes in the Meta Description we had to fix. Fix was applied on second computer connected to same database. First computer
did not display the page correctly (bad cache) and exception was thrown
after attempt to edit the page on first computer was made. Resetting
the web server seem to resolve it but definitely a concern for
production use.
Server Error in '/' Application.
Row not found: GenericOID@f2d2130a PageData content_id=afc15147-5e13-424d-b2ec-03372a583b03
Description: An unhandled exception occurred during
the execution of the current web request. Please review the stack trace
for more information about the error and where it originated in the
code.
UPDATE [sf_page_data] SET [locked_by]=?, [last_modified]=?, [voa_version]=? WHERE [content_id] = ? AND [voa_version]=?
(set event logging to all to see parameter values)
Exception Details: Telerik.OpenAccess.Exceptions.OptimisticVerificationException:
Row not found: GenericOID@f2d2130a PageData
content_id=afc15147-5e13-424d-b2ec-03372a583b03
UPDATE [sf_page_data] SET [locked_by]=?, [last_modified]=?, [voa_version]=? WHERE [content_id] = ? AND [voa_version]=?
(set event logging to all to see parameter values)
Source Error:
An unhandled exception was generated during the execution of the current
web request. Information regarding the origin and location of the
exception can be identified using the exception stack trace below.
Stack Trace:
[OptimisticVerificationException: Row not found: GenericOID@f2d2130a PageData content_id=afc15147-5e13-424d-b2ec-03372a583b03
UPDATE [sf_page_data] SET [locked_by]=?, [last_modified]=?, [voa_version]=? WHERE [content_id] = ? AND [voa_version]=?
(set event logging to all to see parameter values)]
DynamicModule.ns.Wrapped_OpenAccessPageProvider_fc8361ef58e34df286e72b01ee4554d4.CommitTransaction() +140
Telerik.Sitefinity.Data.ManagerBase`1.SaveChanges() +51
Telerik.Sitefinity.Modules.Pages.PageManager.SaveChanges() +12
Telerik.Sitefinity.Web.PageEditorRouteHandler.GetPageData(SiteMapNode node) +1195
Telerik.Sitefinity.Web.RouteHandler.GetHttpHandler(RequestContext requestContext) +120
Telerik.Sitefinity.Web.PageEditorRouteHandler.GetHttpHandler(RequestContext requestContext) +39
System.Web.Routing.UrlRoutingModule.PostResolveRequestCache(HttpContextBase context) +8912168
System.Web.Routing.UrlRoutingModule.OnApplicationPostResolveRequestCache(Object sender, EventArgs e) +86
System.Web.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +148
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +75
It is very serious issue in SF 4.1 that needs prompt attention. You can see in the attached image that the issue popped up on a 'locked' page - message box appeared when 'unlock' button was clicked. Nothing helped, to get it unlocked on second computer (page showed as published on one compuer, locked on second).
Please note: Resetting IIS again restored consistent state.
It would appear to me that there is inconsistency between IIS and database states.
Hi Pavel,
I am having hard time to replicate this issue. I see what the problem could be but we will need to investigate this further. It looks like the object gets locked. I logged a task with reference to the thread, so our QAs will make some tests.
Can you provide some more details about the environment you use. Is it NLB or just you make a request from another machine?
All the best,
Ivan Dimitrov
the Telerik team
Hi,
I want to report that this same thing happened to me just now, on Sitefinity 4.2.1650. Our environment is set up on 4 servers. I believe that the error occurred when I unlocked a page locked by a person on a different server. At first I could edit the page in Sitefinity and access it on the live site, whereas the other person got an error when trying access it on the live site
Suddenly I got an OptimisticVerificationException when trying to edit the page too, and the error looked pretty much like Pavel's. When trying to delete the page, I got the same error. It turned out that the servers were out of sync and one of them displayed the error on this particular page. None of the other pages were affected.
I logged onto one of the servers what didn't display the error and deleted the page. After that, the page was deleted on two of the servers, and on the other two, the page were still there. A mystery, I'd say...
Anyway, I will try to reset the IIS and I really hope that fixes the problem. I just wanted to let you know that Pavel isn't the only one this has happened to.
Cheers,
Carina Olsson
Hi,
I wanted to post an update about the problems I was experiencing yesterday. It seems that the error had something to do with the cache. When I opened Sitefinity today, the page was deleted from all servers, but still visible on the Pages section of backend Sitefinity when using Chrome (the same browser I used yesterday), but I couldn't access it (404 error). In other browsers/on other computers it was gone, although when entering the Template section, I could see that one of the templates was still used by the deleted page.
I created a brand new page, no one edited it but me, and suddenly the new page showed a Row-not-found-error on the same server that displayed the error yesterday. Upon recycling of the App pool, this error was resolved and the page from yesterday was also deleted, for real this time.
Regards,
Carina
Hello Carina,
We're working on a solution for this problem. Still we have problems reproducing it on our testing environments.
Regards,
Pavel Iliev
the Telerik team
any resolution to this? we have been dealing with issues like this for several weeks now. Either on pageData or pageTemplate.
We were able to get the error by having a dev workstation edit a page locally and a designer working from a staging server trying access the page gets the error.
Any update to this? We are Sitefijnity 5.x and are getting multiple row not found errors.
When clicking on pages the page architecture fails to load and we get a row not found .pagedraft
And while updating a page recently locked by someone we got a row not found genericOID on a template.
We have 3 load balanced servers.