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

Forums / Bugs & Issues / Solution to dbo database schema problem?

Solution to dbo database schema problem?

2 posts, 0 answered
  1. Samir Vaidya
    Samir Vaidya avatar
    261 posts
    Registered:
    05 Feb 2005
    04 Aug 2011
    Link to this post
    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?

  2. Vlad
    Vlad avatar
    498 posts
    Registered:
    15 Jul 2016
    04 Aug 2011
    Link to this post
    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
2 posts, 0 answered