+1-888-365-2779
Try Now
More in this section

Forums / Bugs & Issues / Telerik.OpenAccess.Exceptions.OptimisticVerificationException: Row not found

Telerik.OpenAccess.Exceptions.OptimisticVerificationException: Row not found

8 posts, 0 answered
  1. Krishnamorrthy
    Krishnamorrthy avatar
    10 posts
    Registered:
    20 Jun 2013
    16 Jun 2014
    Link to this post
    we upgraded the sitefinity version from 3.7 to 6.2 .when i clicking some page I Encountered this error Some times but not all the times .

    Row not found: GenericOID@7e09805f User id=429c01cf-1fa8-6f4a-89ea-ff0000545f3c
    UPDATE [sf_users] SET [last_activity_date]=?, [last_modified]=? WHERE [id] = ? AND [last_activity_date]=? AND [last_modified]=?
    (set event logging to all to see parameter values)

    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.

    Exception Details: Telerik.OpenAccess.Exceptions.OptimisticVerificationException: Row not found: GenericOID@7e09805f User id=429c01cf-1fa8-6f4a-89ea-ff0000545f3c
    UPDATE [sf_users] SET [last_activity_date]=?, [last_modified]=? WHERE [id] = ? AND [last_activity_date]=? AND [last_modified]=?
    (set event logging to all to see parameter values)
  2. Vassil Vassilev
     Vassil Vassilev avatar
    308 posts
    Registered:
    21 Jan 2015
    17 Jun 2014
    Link to this post
    Hello,

    We have had similar reports of this issue as discussed in this forum thread:
    http://www.sitefinity.com/developer-network/forums/bugs-issues-/-optimisticverificationexception-row-not-found-exception

    There is also a logged feedback item regarding this:
    http://feedback.telerik.com/Project/153/Feedback/Details/100974-optimisticverificationexception-for-pages
    Anther option is this to be caused by L2 cache. Sitefiniy Steve also recommends this as a solution to the problem, which you can also try.

    I hope this helps.
     
    Regards,
    Vassil Vassilev
    Telerik
     
    Do you want to have your say in the Sitefinity development roadmap? Do you want to know when a feature you requested is added or when a bug fixed? Explore the Telerik Sitefinity CMS Ideas&Feedback Portal and vote to affect the priority of the items
     
  3. Jared
    Jared avatar
    122 posts
    Registered:
    04 Apr 2013
    05 Nov 2015 in reply to Vassil Vassilev
    Link to this post
    We have got a similar issue when upgrading from 5.4 to 8.1.  Is there a known solution to this error that someone has got to work?
  4. RJ Cuthbertson
    RJ Cuthbertson avatar
    41 posts
    Registered:
    01 Jun 2015
    05 Nov 2015
    Link to this post

    Strange, I just came to see if there was an update on this issue, and this thread was the most recent in the forum. I get this roughly 1 in 4 times I rebuild my solution. The only fix I've found is to build again and then wait another 2-3 minutes for the site to warm up.

     

    Here's a more complete stack trace (side note, "directory" is misspelled on line 24):

     

    01.[OptimisticVerificationException: Row not found: GenericOID@2bf2c581 XmlConfigItem id=099f904c-9fb5-4e96-b5f8-02c01c6d4b06
    02.UPDATE [sf_xml_config_items] SET [dta] = ?, [last_modified] = ? WHERE [id] = ? AND [last_modified] = ?
    03.(set event logging to all to see parameter values)]
    04.   OpenAccessRuntime.ExceptionWrapper.Throw() +7
    05.   OpenAccessRuntime.DataObjects.OpenAccessPersistenceManagerImp.handleException(Exception x, Boolean needsRollback) +553
    06.   OpenAccessRuntime.DataObjects.OpenAccessPersistenceManagerImp.internalCommit(Boolean phase) +406
    07.   OpenAccessRuntime.DataObjects.OpenAccessPersistenceManagerImp.commit() +77
    08.   OpenAccessRuntime.DataObjects.UnsynchronizedPMProxy.commit() +34
    09.   OpenAccessRuntime.EnlistableObjectScope.CommitChanges() +103
    10.   Telerik.OpenAccess.OpenAccessContextBase.SaveChanges(ConcurrencyConflictsProcessingMode failureMode) +112
    11.   Telerik.Sitefinity.Configuration.Data.OpenAccessXmlConfigStorageProvider.SaveElement(IXmlConfigItem configElement) +685
    12.   Telerik.Sitefinity.Configuration.Data.XmlConfigProvider.SaveXml(XmlDocument xml, String relativePath, Boolean updateFile) +176
    13.   Telerik.Sitefinity.Configuration.Data.XmlConfigProvider.SaveElement(ConfigElement config, Func`2 getXmlElement, String relativePath, Boolean updateFile) +78
    14.   Telerik.Sitefinity.Configuration.Data.XmlConfigProvider.SaveElement(ConfigElement config, ConfigElement defaultConfig, Boolean isPolicy, Boolean updateFile) +103
    15.   Telerik.Sitefinity.Configuration.Data.XmlConfigProvider.SaveSectionInternal(ConfigSection section, Boolean updateFile) +52
    16.   Telerik.Sitefinity.Configuration.Data.XmlConfigProvider.SaveSection(ConfigSection section) +88
    17.   Telerik.Sitefinity.Configuration.ConfigManager.SaveSection(ConfigSection section) +27
    18.   Telerik.Sitefinity.Frontend.GridSystem.GridWidgetRegistrator.RegisterToolboxItem(String fileName, String packageName, String oldFileName) +184
    19.   Telerik.Sitefinity.Frontend.FilesMonitoring.GridFileManager.AddToToolboxAndFileData(FileMonitorDataManager fileMonitorDataManager, String newFileName, String newFilePath, String packageName, FileData fileData, String oldFileName) +67
    20.   Telerik.Sitefinity.Frontend.FilesMonitoring.GridFileManager.FileAdded(String fileName, String filePath, String packageName) +435
    21.   Telerik.Sitefinity.Frontend.FilesMonitoring.<>c__DisplayClass12.<GetFileChangedDelegate>b__11(Object[] p) +85
    22.   Telerik.Sitefinity.Services.SystemManager.RunWithElevatedPrivilege(RunWithElevatedPrivilegeDelegate delegateToRun, Object[] parameters, String urlRequest) +316
    23.   Telerik.Sitefinity.Frontend.FilesMonitoring.FileMonitor.FileChanged(String filePath, FileChangeType changeType, String oldFilePath) +423
    24.   Telerik.Sitefinity.Frontend.FilesMonitoring.FileMonitor.ProcessDirecotryFiles(DirectoryInfo dirInfo) +111
    25.   Telerik.Sitefinity.Frontend.FilesMonitoring.FileMonitor.Start(IList`1 directoriesInfo) +303
    26.   Telerik.Sitefinity.Frontend.FilesMonitoring.FileMonitoringInitializer.RegisterFileObservers() +124
    27.   Telerik.Sitefinity.Frontend.FilesMonitoring.FileMonitoringInitializer.Initialize() +433
    28.   Telerik.Sitefinity.Frontend.FrontendModule.Bootstrapper_Initialized(Object sender, ExecutedEventArgs e) +67
    29.   System.EventHandler`1.Invoke(Object sender, TEventArgs e) +0
    30.   Telerik.Sitefinity.Abstractions.Bootstrapper.OnInitialized(Object sender, ExecutedEventArgs args) +22
    31.   Telerik.Sitefinity.Abstractions.Bootstrapper.Bootstrap() +803
    32.   Telerik.Sitefinity.Web.SitefinityHttpModule.Init(HttpApplication context) +200
    33.   System.Web.Routing.UrlRoutingModule.System.Web.IHttpModule.Init(HttpApplication application) +12
    34.   System.Web.HttpApplication.RegisterEventSubscriptionsWithIIS(IntPtr appContext, HttpContext context, MethodInfo[] handlers) +534
    35.   System.Web.HttpApplication.InitSpecial(HttpApplicationState state, MethodInfo[] handlers, IntPtr appContext, HttpContext context) +172
    36.   System.Web.HttpApplicationFactory.GetSpecialApplicationInstance(IntPtr appContext, HttpContext context) +352
    37.   System.Web.Hosting.PipelineRuntime.InitializeApplication(IntPtr appContext) +296
    38. 
    39.[HttpException (0x80004005): Row not found: GenericOID@2bf2c581 XmlConfigItem id=099f904c-9fb5-4e96-b5f8-02c01c6d4b06
    40.UPDATE [sf_xml_config_items] SET [dta] = ?, [last_modified] = ? WHERE [id] = ? AND [last_modified] = ?
    41.(set event logging to all to see parameter values)]
    42.   System.Web.HttpRuntime.FirstRequestInit(HttpContext context) +9920760
    43.   System.Web.HttpRuntime.EnsureFirstRequestInit(HttpContext context) +101
    44.   System.Web.HttpRuntime.ProcessRequestNotificationPrivate(IIS7WorkerRequest wr, HttpContext context) +261

  5. Jared
    Jared avatar
    122 posts
    Registered:
    04 Apr 2013
    05 Nov 2015
    Link to this post

    Here is what we are getting:

    Timestamp: 11/4/2015 1:51:35 PM

    Message: HandlingInstanceID: a8df3e86-42d2-450d-862d-4669753496e3
    An exception of type 'Telerik.OpenAccess.Exceptions.OptimisticVerificationException' occurred and was caught.

    Type : Telerik.OpenAccess.Exceptions.OptimisticVerificationException, Telerik.OpenAccess, Version=2015.2.624.1, Culture=neutral, PublicKeyToken=7ce17eeaf1d59342
    Message : Row not found: GenericOID@814284d6 NewsItem content_id=74cc6859-2815-67ee-b272-ff0000a566aa
    UPDATE [sf_news_items] SET [description_] = ?, [description_de_de] = ?, [description_en] = ?, [description_en_bz] = ?, [description_en_gb] = ?, [description_en_ph] = ?, [description_es_ar] = ?, [description_es_es] = ?, [description_fr_fr] = ?, [description_it_it] = ?, [description_ja_jp] = ?, [description_ko_kr] = ?, [description_pt_br] = ?, [description_ru_ru] = ?, [description_tr_tr] = ?, [description_zh_cn] = ?, [title_] = ?, [title_de_de] = ?, [title_en] = ?, [title_en_bz] = ?, [title_en_gb] = ?, [title_en_ph] = ?, [title_es_ar] = ?, [title_es_es] = ?, [title_fr_fr] = ?, [title_it_it] = ?, [title_ja_jp] = ?, [title_ko_kr] = ?, [title_pt_br] = ?, [title_ru_ru] = ?, [title_tr_tr] = ?, [title_zh_cn] = ?, [url_name_] = ?, [url_name_de_de] = ?, [url_name_en] = ?, [url_name_en_bz] = ?, [url_name_en_gb] = ?, [url_name_en_ph] = ?, [url_name_es_ar] = ?, [url_name_es_es] = ?, [url_name_fr_fr] = ?, [url_name_it_it] = ?, [url_name_ja_jp] = ?, [url_name_ko_kr] = ?, [url_name_pt_br] = ?, [url_name_ru_ru] = ?, [url_name_tr_tr] = ?, [url_name_zh_cn] = ?, [last_modified] = ?, [vrsion] = ?, [approval_workflow_state_] = ?, [approval_workflow_state_en] = ?, [article_date] = ?, [author_] = ?, [content_] = ?, [display_order] = ?, [imge] = ?, [item_default_url_] = ?, [summary_] = ?, [voa_version] = ? WHERE [content_id] = ? AND [voa_version] = ?
    (set event logging to all to see parameter values)
    Source : Telerik.Sitefinity

    Reason : OptimisticVerification

    Stack Trace :    at Telerik.Sitefinity.Workflow.WorkflowManager.MessageWorkflow(Guid itemId, Type itemType, String providerName, String operationName, Boolean isCheckedOut, Dictionary`2 contextBag)
       at Telerik.Sitefinity.Modules.ContentServiceBase`5.SaveContentUsingWorkflow(ContentItemContext`1 context, String parentId, String providerName, String workflowOperation)
       at Telerik.Sitefinity.Modules.ContentServiceBase`5.SaveContentInternal(ContentItemContext`1 context, String providerName, String workflowOperation)
       at SyncInvokeSaveContent(Object , Object[] , Object[] )
       at System.ServiceModel.Dispatcher.SyncMethodInvoker.Invoke(Object instance, Object[] inputs, Object[]& outputs)
       at System.ServiceModel.Dispatcher.DispatchOperationRuntime.InvokeBegin(MessageRpc& rpc)
       at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage5(MessageRpc& rpc)
       at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage31(MessageRpc& rpc)
       at System.ServiceModel.Dispatcher.MessageRpc.Process(Boolean isOperationContextSet)

     

    This error is occurring when users try to Save item as Draft, Send for Approval or Publish.  From waht I have read, it appears to be an issue with data caching.  For some unknown reason the data that is being cached does not contain the item(s).  I checked the DB directly and this row/item does exist in the DB, but it does not exist in the "data cahce".

  6. Sabrie Nedzhip
    Sabrie Nedzhip avatar
    534 posts
    Registered:
    28 Sep 2016
    10 Nov 2015
    Link to this post
    Hi Jared and Richard,

    Based on our experience the "Row not found ..."  exception you have received might be related to caching issue. It seems that the rows which are in the description of the error has been already deleted/updated in the database but are still "present" in some cache - thus resulting in this error. 

    In order to reduce this type of errors I can suggest that you go to Administration -> Settings -> Advanced -> Data and set the Enable data caching property to False. We have positive feedback from our clients experiencing similar issues that disabling the data caching resolves the issue.

    The cache is cleared when you recycle the application and the application gets fresh data from the database and this should resolve the issue. So, what I can suggest is to restart the application and then test again. This way we can check if the issue is related to caching.

    This issue may also occur if you are in a load balancing environment if the cache is not invalidated and on some nodes you still have some cached data.

    What you can try is to set the project on your local machine and test the behavior when you run the project locally? This way we can see if the issue is related to environment settings.

    Regards,
    Sabrie Nedzhip
    Telerik
     
    Do you want to have your say in the Sitefinity development roadmap? Do you want to know when a feature you requested is added or when a bug fixed? Explore the Telerik Sitefinity CMS Ideas&Feedback Portal and vote to affect the priority of the items
     
  7. Jared
    Jared avatar
    122 posts
    Registered:
    04 Apr 2013
    10 Nov 2015 in reply to Sabrie Nedzhip
    Link to this post
    What effect on performance would we see if we turned data caching off?  Also, we are load balanced.  Our Pre-Production environment is set up for load balancing as well and we do not see this behavior in that environment.  I also have the project set up locally and have not come across the issue there either.  Is the only fix to disable data caching?
  8. Jared
    Jared avatar
    122 posts
    Registered:
    04 Apr 2013
    10 Nov 2015
    Link to this post

    I have a support ticket open in regards to this issue and just got the following response:

    Please note that although disabling the L2 cache manually could fix the problem, it will impact the performance of the whole site. It has been enabled by default since Sitefinity 7.1 for a performance improvement. The first article was written before the version 7.1 was released, when there was no communication for L2 cache messages of OpenAceess. For a better performance this field should be left in blank.

     

    It is a little frustrating to me that within 5 hours I received 2 different responses regarding this issue and both were from a Telerik representative!

8 posts, 0 answered