1
Vote

PTB 2.0 Oracle Support

description

After upgrading from from 1.9.3 to 2.0 (CMS 6 R2) on a development site using Oracle.DataAccess.Client, EPiServer now throws errors whenever any page is served. I'm thinking it has something to do with the database property row change, but that's nothing more than a hunch... I ended up rolling my site back to 1.9.3, but here is my stack trace:
 
[OracleException (0x80004005): ORA-00923: FROM keyword not found where expected]
Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck) +996
Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, Boolean bCheck) +50
Oracle.DataAccess.Client.OracleCommand.ExecuteNonQuery() +4268
EPiServer.Data.Dynamic.Providers.c__DisplayClass24.b__23() +141
EPiServer.Data.Dynamic.Providers.c__DisplayClass7.b__6() +199
EPiServer.Data.Dynamic.Providers.DbDataStoreProvider.InternalExecute(Func1 method) +128
EPiServer.Data.Dynamic.Providers.DbDataStoreProvider.ExecuteTransaction(Action action) +87
EPiServer.Data.Dynamic.Providers.DbDataStoreProvider.SaveStoreDefinition(StoreDefinition storeDefinition) +76
EPiServer.Data.Dynamic.c__DisplayClass6.b__3() +319
EPiServer.Data.Cache.LocalCache
2.Add(TKey key, Boolean cacheNullValues, Boolean overwriteExistingValue, Func1 action) +127
EPiServer.Data.Dynamic.StoreDefinition.InternalCreate(String storeName, IDictionary
2 typeBag, StoreDefinitionParameters parameters) +175
EPiServer.Data.Dynamic.EPiServerDynamicDataStoreFactory.CreateStore(String storeName, IDictionary2 typeBag, StoreDefinitionParameters parameters) +117
EPiServer.Data.Dynamic.EPiServerDynamicDataStoreFactory.CreateStore(String storeName, Type type, StoreDefinitionParameters parameters) +247
EPiServer.Data.Dynamic.EPiServerDynamicDataStoreFactory.CreateStore(String storeName, Type type) +12
PageTypeBuilder.Migrations.MigrationsHook.GetStore() +58
PageTypeBuilder.Migrations.MigrationsHook.ValidateMigrations(IEnumerable
1 migrations) +141
PageTypeBuilder.Migrations.MigrationsHook.PreSynchronization(ISynchronizationHookContext context) +171
PageTypeBuilder.Synchronization.Hooks.HooksHandler.b__1(IPreSynchronizationHook h) +41
System.Collections.Generic.List1.ForEach(Action1 action) +56
PageTypeBuilder.Synchronization.Hooks.HooksHandler.InvokePreSynchronizationHooks() +166
PageTypeBuilder.Synchronization.PageTypeSynchronizer.SynchronizePageTypes() +15
PageTypeBuilder.Initializer.Initialize(InitializationEngine context) +77
EPiServer.Framework.Initialization.InitializationEngine.InitializeModules() +343
EPiServer.Framework.Initialization.InitializationEngine.Initialize(HostType hostType) +82
EPiServer.Framework.Initialization.InitializationModule.Initialize(HostType hostType) +163
EPiServer.Framework.Initialization.InitializationModule.FrameworkInitialization(HostType hostType) +68
EPiServer.Global..ctor() +54
ASP.global_asax..ctor() +4
 
[TargetInvocationException: Exception has been thrown by the target of an invocation.]
System.RuntimeTypeHandle.CreateInstance(RuntimeType type, Boolean publicOnly, Boolean noCheck, Boolean& canBeCached, RuntimeMethodHandle& ctor, Boolean& bNeedSecurityCheck) +0
System.RuntimeType.CreateInstanceSlow(Boolean publicOnly, Boolean fillCache) +86
System.RuntimeType.CreateInstanceImpl(Boolean publicOnly, Boolean skipVisibilityChecks, Boolean fillCache) +230
System.Activator.CreateInstance(Type type, Boolean nonPublic) +67
System.RuntimeType.CreateInstanceImpl(BindingFlags bindingAttr, Binder binder, Object[] args, CultureInfo culture, Object[] activationAttributes) +1051
System.Activator.CreateInstance(Type type, BindingFlags bindingAttr, Binder binder, Object[] args, CultureInfo culture, Object[] activationAttributes) +111
System.Web.HttpApplicationFactory.GetNormalApplicationInstance(HttpContext context) +221
System.Web.HttpApplicationFactory.GetApplicationInstance(HttpContext context) +107
System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr) +289
 
Joel suggested:
 
"Could it be that you previously didn't have PageTypeBuilder.Migrations.dll referenced but added that when you upgraded? It seems the exception is thrown when the Migrations extension tries to create a DDS store to save the current migration number in."
 
I can verify that PageTypeBuilder.Migrations.dll is and was referenced for this project, and I am still seeing this issue. I have rolled back to 1.9.3 on this site, but would very much like to integrate 2.0 with this application.

comments