Solution to dbo database schema problem?

Posted by Community Admin on 04-Aug-2018 00:44

Solution to dbo database schema problem?

Sitefinity - Bugs & Issues

All Replies

Posted by Community Admin on 04-Aug-2011 00:00

I just deployed my development database to Arvixe in conjunction with Sitefinity v. 4.1 SP3.

However, after deploying my database, I encountered this error message:

Row not found: GenericOID@b87d91d4 SchemaVersion id=5bb9d862-edc4-4979-98ec-0e08699a26cf
UPDATE [sf_schema_vrsns] SET [connection_hash]=?, [last_upgrade_date]=? WHERE [id] = ? AND [connection_hash]=?
(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@b87d91d4 SchemaVersion id=5bb9d862-edc4-4979-98ec-0e08699a26cf
UPDATE [sf_schema_vrsns] SET [connection_hash]=?, [last_upgrade_date]=? WHERE [id] = ? AND [connection_hash]=?
(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@b87d91d4 SchemaVersion id=5bb9d862-edc4-4979-98ec-0e08699a26cf
UPDATE [sf_schema_vrsns] SET [connection_hash]=?, [last_upgrade_date]=? WHERE [id] = ? AND [connection_hash]=?
(set event logging to all to see parameter values)]
   DynamicModule.ns.Wrapped_OpenAccessMetaDataProvider_9bfaeab10937455881a78e8008096776.CommitTransaction(Boolean updateSchema) +183
   Telerik.Sitefinity.Data.Metadata.MetadataManager.SaveChanges(Boolean updateSchema) +31
   Telerik.Sitefinity.Data.OA.OpenAccessConnection.UpdateMetadata(MetadataSource metadataSource, String moduleName, List`1 dynamicTypesToRegister, IOpenAccessMetadataProvider provider) +3466

[Exception: Unable to upgrade database schema metadataSource provided by 'SitefinityDynamicBase': Row not found: GenericOID@b87d91d4 SchemaVersion id=5bb9d862-edc4-4979-98ec-0e08699a26cf
UPDATE [sf_schema_vrsns] SET [connection_hash]=?, [last_upgrade_date]=? WHERE [id] = ? AND [connection_hash]=?
(set event logging to all to see parameter values)]
   DynamicModule.ns.Wrapped_OpenAccessUserActivityProvider_880a5e44014d4e53abd6d4761032efb1.Initialize(String providerName, NameValueCollection config, Type managerType) +195
   Telerik.Sitefinity.Data.ManagerBase`1.InstantiateProvider(IDataProviderSettings providerSettings, Type providerType, ExceptionPolicyName policy, ManagerBase`1 manager) +1250
   Telerik.Sitefinity.Data.ManagerBase`1.InstantiateProvider(IDataProviderSettings providerSettings, ExceptionPolicyName policy, ManagerBase`1 manager) +63
   Telerik.Sitefinity.Data.ManagerBase`1.SetProvider(String providerName, String transactionName) +297
   Telerik.Sitefinity.Data.ManagerBase`1..ctor(String providerName, String transactionName) +131
   Telerik.Sitefinity.Security.UserActivityManager..ctor() +12

[TargetInvocationException: Exception has been thrown by the target of an invocation.]
   System.RuntimeTypeHandle.CreateInstance(RuntimeType type, Boolean publicOnly, Boolean noCheck, Boolean& canBeCached, RuntimeMethodHandleInternal& ctor, Boolean& bNeedSecurityCheck) +0
   System.RuntimeType.CreateInstanceSlow(Boolean publicOnly, Boolean skipCheckThis, Boolean fillCache) +98
   System.RuntimeType.CreateInstanceDefaultCtor(Boolean publicOnly, Boolean skipVisibilityChecks, Boolean skipCheckThis, Boolean fillCache) +241
   System.Activator.CreateInstance() +103
   Telerik.Sitefinity.Data.ManagerBase`1.GetManager(String providerName, String transactionName) +80
   Telerik.Sitefinity.Security.SecurityManager.AuthenticateRequest(HttpContextBase context) +1014
   Telerik.Sitefinity.Web.SitefinityHttpModule.Context_AuthenticateRequest(Object sender, EventArgs e) +18
   System.Web.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +148
   System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +75

Fortunately, I was able to find this article which described how to fix the issue: 
http://www.sitefinity.com/devnet/forums/sitefinity-4-x/bugs-issues/error-invalid-root-node-configured-for-pages-no-root-node-with-the-name-of-quot-frontendsitemap-quot.aspx

However, having to perform the schema rename operation each and every time I deploy from my local development workstation to a shared hosting provider is extremely annoying.  It also makes restoring backups from production to my development database server particularly difficult as well.

Is there any way to fix this issue regarding the dbo schema without having to resort to the database schema rename each and every time prior to deployment?

Posted by Community Admin on 04-Aug-2011 00:00

Hi Samir Vaidya,

Looking the error, it seems it is not related to the database scheme. This exception could happen in a load balanced environment when more than on instances are trying to upgrade the database. Or, during the upgrade another process is making changes to the database.
Can you give us more details about your deployment process, so we could understand the problem better?

As to the database scheme issue, it is out of the control of Sitefinity. Sitefinity is connected to the database with a connection string and all access to the database is controlled by SQL Server based on the account provided in the connection string. What you can do is to rename or add another scheme (the same as on production) in order to avoid doing this every time you deploy.

Regards,
Vlad
the Telerik team

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 Public Issue Tracking system and vote to affect the priority of the items

This thread is closed