Telerik.OpenAccess.Exceptions.OptimisticVerificationExceptio

Posted by Community Admin on 04-Aug-2018 08:42

Telerik.OpenAccess.Exceptions.OptimisticVerificationException: Row not found

All Replies

Posted by Community Admin on 16-Jun-2014 00:00

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)

Posted by Community Admin on 17-Jun-2014 00:00

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:
feedback.telerik.com/.../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
 

Posted by Community Admin on 05-Nov-2015 00:00

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?

Posted by Community Admin on 05-Nov-2015 00:00

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

Posted by Community Admin on 05-Nov-2015 00:00

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".

Posted by Community Admin on 10-Nov-2015 00:00

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
 

Posted by Community Admin on 10-Nov-2015 00:00

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?

Posted by Community Admin on 10-Nov-2015 00:00

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!

This thread is closed