Solution to dbo database schema problem?
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
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_schema_vrsns] SET
[connection_hash]=?, [last_upgrade_date]=? WHERE [id] = ? AND
[connection_hash]=?
(set event logging to all to see parameter values)
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?
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