Error upgrading from 5.4 to 8.0

Posted by Community Admin on 04-Aug-2018 20:20

Error upgrading from 5.4 to 8.0

Sitefinity - Bugs & Issues

All Replies

Posted by Community Admin on 28-Apr-2015 00:00

Hi there,

I'm trying to upgrade a site from 5.4.4040.0 to 8.0 and I keep running into a database error. For reference, the site is running under IIS on my local dev box (Windows 8 64-bit) targeting .NET 4.5.1. The database is running on the same machine under SQL Server Express. The 5.4 site has been running fine and I upgraded the site's files using the 8.0 project manager, following the upgrade instructions here: docs.sitefinity.com/upgrade. When I then try to visit the site I get the error below (copied and pasted from the Error.log file, I apologize for the length). Has anyone run into this before, and if so how can I fix it? Thanks in advance!

The error message:

----------------------------------------
Timestamp: 4/28/2015 8:04:04 PM

Message: HandlingInstanceID: 9d2c41b2-48c3-46c9-9370-23a5943fa27e
An exception of type 'Telerik.OpenAccess.Exceptions.DataStoreException' occurred and was caught.
------------------------------------------------------------------------------------------------
04/28/2015 15:04:04
Type : Telerik.OpenAccess.Exceptions.DataStoreException, Telerik.OpenAccess, Version=2015.1.225.1, Culture=neutral, PublicKeyToken=7ce17eeaf1d59342
Message : Link table batch insert failed: System.NotSupportedException: Specified method is not supported. ---> System.NotSupportedException: Specified method is not supported.
   at System.Data.Common.DbDataAdapter.TerminateBatching()
   at System.Data.Common.DbDataAdapter.Update(DataRow[] dataRows, DataTableMapping tableMapping)
   at System.Data.Common.DbDataAdapter.Update(DataRow[] dataRows)
   at OpenAccessRuntime.Intellitrace.Update(String id, DbDataAdapter adapter, DataRow[] rows)
   at Telerik.OpenAccess.RT.sql.Batch.Perform(String connId, DbDataAdapter adapter, DataRow[] rows)
   at Telerik.OpenAccess.Runtime.Logging.LoggingDbCommand.ExecuteBatch(DbDataAdapter adapter, DataRow[] rows, Batch batch)
   at Telerik.OpenAccess.RT.Adonet2Generic.Impl.CommandImp.Execute(DbDataAdapter adapter, DataRow[] rows, Batch batch)
   at Telerik.OpenAccess.RT.Adonet2Generic.Impl.StatementImp.Execute(DbDataAdapter adapter, DataRow[] rows, Batch batch)
   --- End of inner exception stack trace ---
   at Telerik.OpenAccess.RT.Adonet2Generic.Impl.StatementImp.Execute(DbDataAdapter adapter, DataRow[] rows, Batch batch)
   at OpenAccessRuntime.Relational.conn.LoggingStatement.Execute(DbDataAdapter adapter, DataRow[] rows, Batch batch)
   at Telerik.OpenAccess.RT.sql.Batch.ExecuteBatchDataTable(Boolean withInfo)
Field: System.Collections.Generic.IList`1[[System.String, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]] Telerik.Sitefinity.Metadata.Model.SchemaVersion.metaTypes
INSERT INTO [sf_schema_vrsns_meta_types]([id], [seq], [val]) VALUES (@p0, @p1, @p2)
Batch Entry -1 (set event logging to all to see parameter data) System.NotSupportedException: Specified method is not supported. ---> System.NotSupportedException: Specified method is not supported.
   at System.Data.Common.DbDataAdapter.TerminateBatching()
   at System.Data.Common.DbDataAdapter.Update(DataRow[] dataRows, DataTableMapping tableMapping)
   at System.Data.Common.DbDataAdapter.Update(DataRow[] dataRows)
   at OpenAccessRuntime.Intellitrace.Update(String id, DbDataAdapter adapter, DataRow[] rows)
   at Telerik.OpenAccess.RT.sql.Batch.Perform(String connId, DbDataAdapter adapter, DataRow[] rows)
   at Telerik.OpenAccess.Runtime.Logging.LoggingDbCommand.ExecuteBatch(DbDataAdapter adapter, DataRow[] rows, Batch batch)
   at Telerik.OpenAccess.RT.Adonet2Generic.Impl.CommandImp.Execute(DbDataAdapter adapter, DataRow[] rows, Batch batch)
   at Telerik.OpenAccess.RT.Adonet2Generic.Impl.StatementImp.Execute(DbDataAdapter adapter, DataRow[] rows, Batch batch)
   --- End of inner exception stack trace ---
   at Telerik.OpenAccess.RT.Adonet2Generic.Impl.StatementImp.Execute(DbDataAdapter adapter, DataRow[] rows, Batch batch)
   at OpenAccessRuntime.Relational.conn.LoggingStatement.Execute(DbDataAdapter adapter, DataRow[] rows, Batch batch)
   at Telerik.OpenAccess.RT.sql.Batch.ExecuteBatchDataTable(Boolean withInfo)
Source : Unity_ILEmit_DynamicClasses
Help link : 
InnerExceptions : System.Exception[]
FailedObject : 
BackendError : 
Reason : Runtime
CanRetry : False
Data : System.Collections.ListDictionaryInternal
TargetSite : Void Initialize(System.String, System.Collections.Specialized.NameValueCollection, System.Type)
HResult : -2146233088
Stack Trace :    at DynamicModule.ns.Wrapped_OpenAccessTaxonomyProvider_094be0f33e354af596dcc3e0353a905d.Initialize(String providerName, NameValueCollection config, Type managerType)
   at Telerik.Sitefinity.Data.ManagerBase`1.InstantiateProvider(IDataProviderSettings providerSettings, Type providerType, ExceptionPolicyName policy, ManagerBase`1 manager)

Additional Info:

MachineName : JDANIELS2
TimeStamp : 4/28/2015 8:04:04 PM
FullName : Telerik.Sitefinity.Utilities, Version=8.0.5700.0, Culture=neutral, PublicKeyToken=b28c218413bdf563
AppDomainName : /LM/W3SVC/2/ROOT-1-130747250321153623
ThreadIdentity : 
WindowsIdentity : PCMA\jdaniels
Requested URL : http://127.0.0.1/
Inner Exception
---------------
Type : System.NotSupportedException, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
Message : Specified method is not supported.
Source : Telerik.OpenAccess.Runtime
Help link : 
Data : System.Collections.ListDictionaryInternal
TargetSite : Int32 Execute(System.Data.Common.DbDataAdapter, System.Data.DataRow[], Telerik.OpenAccess.RT.sql.Batch)
HResult : -2146233067
Stack Trace :    at Telerik.OpenAccess.RT.Adonet2Generic.Impl.StatementImp.Execute(DbDataAdapter adapter, DataRow[] rows, Batch batch)
  at OpenAccessRuntime.Relational.conn.LoggingStatement.Execute(DbDataAdapter adapter, DataRow[] rows, Batch batch)
  at Telerik.OpenAccess.RT.sql.Batch.ExecuteBatchDataTable(Boolean withInfo)

Inner Exception
---------------
Type : System.NotSupportedException, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
Message : Specified method is not supported.
Source : System.Data
Help link : 
Data : System.Collections.ListDictionaryInternal
TargetSite : Void TerminateBatching()
HResult : -2146233067
Stack Trace :    at System.Data.Common.DbDataAdapter.TerminateBatching()
  at System.Data.Common.DbDataAdapter.Update(DataRow[] dataRows, DataTableMapping tableMapping)
  at System.Data.Common.DbDataAdapter.Update(DataRow[] dataRows)
  at OpenAccessRuntime.Intellitrace.Update(String id, DbDataAdapter adapter, DataRow[] rows)
  at Telerik.OpenAccess.RT.sql.Batch.Perform(String connId, DbDataAdapter adapter, DataRow[] rows)
  at Telerik.OpenAccess.Runtime.Logging.LoggingDbCommand.ExecuteBatch(DbDataAdapter adapter, DataRow[] rows, Batch batch)
  at Telerik.OpenAccess.RT.Adonet2Generic.Impl.CommandImp.Execute(DbDataAdapter adapter, DataRow[] rows, Batch batch)
  at Telerik.OpenAccess.RT.Adonet2Generic.Impl.StatementImp.Execute(DbDataAdapter adapter, DataRow[] rows, Batch batch)



Category: ErrorLog

Priority: 0

EventId: 9010

Severity: Warning

Title:Enterprise Library Exception Handling

Machine: JDANIELS2

App Domain: /LM/W3SVC/2/ROOT-1-130747250321153623

ProcessId: 7144

Process Name: C:\windows\SysWOW64\inetsrv\w3wp.exe

Thread Name: 

Win32 ThreadId:6948

Extended Properties: 
----------------------------------------
----------------------------------------
Timestamp: 4/28/2015 8:04:04 PM

Message: HandlingInstanceID: 029c205f-4d2c-40aa-98a1-f90eaee22781
An exception of type 'Telerik.OpenAccess.Exceptions.DataStoreException' occurred and was caught.
------------------------------------------------------------------------------------------------
04/28/2015 15:04:04
Type : Telerik.OpenAccess.Exceptions.DataStoreException, Telerik.OpenAccess, Version=2015.1.225.1, Culture=neutral, PublicKeyToken=7ce17eeaf1d59342
Message : Link table batch insert failed: System.NotSupportedException: Specified method is not supported. ---> System.NotSupportedException: Specified method is not supported.
   at System.Data.Common.DbDataAdapter.TerminateBatching()
   at System.Data.Common.DbDataAdapter.Update(DataRow[] dataRows, DataTableMapping tableMapping)
   at System.Data.Common.DbDataAdapter.Update(DataRow[] dataRows)
   at OpenAccessRuntime.Intellitrace.Update(String id, DbDataAdapter adapter, DataRow[] rows)
   at Telerik.OpenAccess.RT.sql.Batch.Perform(String connId, DbDataAdapter adapter, DataRow[] rows)
   at Telerik.OpenAccess.Runtime.Logging.LoggingDbCommand.ExecuteBatch(DbDataAdapter adapter, DataRow[] rows, Batch batch)
   at Telerik.OpenAccess.RT.Adonet2Generic.Impl.CommandImp.Execute(DbDataAdapter adapter, DataRow[] rows, Batch batch)
   at Telerik.OpenAccess.RT.Adonet2Generic.Impl.StatementImp.Execute(DbDataAdapter adapter, DataRow[] rows, Batch batch)
   --- End of inner exception stack trace ---
   at Telerik.OpenAccess.RT.Adonet2Generic.Impl.StatementImp.Execute(DbDataAdapter adapter, DataRow[] rows, Batch batch)
   at OpenAccessRuntime.Relational.conn.LoggingStatement.Execute(DbDataAdapter adapter, DataRow[] rows, Batch batch)
   at Telerik.OpenAccess.RT.sql.Batch.ExecuteBatchDataTable(Boolean withInfo)
Field: System.Collections.Generic.IList`1[[System.String, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]] Telerik.Sitefinity.Metadata.Model.SchemaVersion.metaTypes
INSERT INTO [sf_schema_vrsns_meta_types]([id], [seq], [val]) VALUES (@p0, @p1, @p2)
Batch Entry -1 (set event logging to all to see parameter data) System.NotSupportedException: Specified method is not supported. ---> System.NotSupportedException: Specified method is not supported.
   at System.Data.Common.DbDataAdapter.TerminateBatching()
   at System.Data.Common.DbDataAdapter.Update(DataRow[] dataRows, DataTableMapping tableMapping)
   at System.Data.Common.DbDataAdapter.Update(DataRow[] dataRows)
   at OpenAccessRuntime.Intellitrace.Update(String id, DbDataAdapter adapter, DataRow[] rows)
   at Telerik.OpenAccess.RT.sql.Batch.Perform(String connId, DbDataAdapter adapter, DataRow[] rows)
   at Telerik.OpenAccess.Runtime.Logging.LoggingDbCommand.ExecuteBatch(DbDataAdapter adapter, DataRow[] rows, Batch batch)
   at Telerik.OpenAccess.RT.Adonet2Generic.Impl.CommandImp.Execute(DbDataAdapter adapter, DataRow[] rows, Batch batch)
   at Telerik.OpenAccess.RT.Adonet2Generic.Impl.StatementImp.Execute(DbDataAdapter adapter, DataRow[] rows, Batch batch)
   --- End of inner exception stack trace ---
   at Telerik.OpenAccess.RT.Adonet2Generic.Impl.StatementImp.Execute(DbDataAdapter adapter, DataRow[] rows, Batch batch)
   at OpenAccessRuntime.Relational.conn.LoggingStatement.Execute(DbDataAdapter adapter, DataRow[] rows, Batch batch)
   at Telerik.OpenAccess.RT.sql.Batch.ExecuteBatchDataTable(Boolean withInfo)
Source : Unity_ILEmit_DynamicClasses
Help link : 
InnerExceptions : System.Exception[]
FailedObject : 
BackendError : 
Reason : Runtime
CanRetry : False
Data : System.Collections.ListDictionaryInternal
TargetSite : Void Initialize(System.String, System.Collections.Specialized.NameValueCollection, System.Type)
HResult : -2146233088
Stack Trace :    at DynamicModule.ns.Wrapped_OpenAccessTaxonomyProvider_094be0f33e354af596dcc3e0353a905d.Initialize(String providerName, NameValueCollection config, Type managerType)
   at Telerik.Sitefinity.Data.ManagerBase`1.InstantiateProvider(IDataProviderSettings providerSettings, Type providerType, ExceptionPolicyName policy, ManagerBase`1 manager)

Additional Info:

MachineName : JDANIELS2
TimeStamp : 4/28/2015 8:04:04 PM
FullName : Telerik.Sitefinity.Utilities, Version=8.0.5700.0, Culture=neutral, PublicKeyToken=b28c218413bdf563
AppDomainName : /LM/W3SVC/2/ROOT-1-130747250321153623
ThreadIdentity : 
WindowsIdentity : PCMA\jdaniels
Requested URL : http://127.0.0.1/
Inner Exception
---------------
Type : System.NotSupportedException, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
Message : Specified method is not supported.
Source : Telerik.OpenAccess.Runtime
Help link : 
Data : System.Collections.ListDictionaryInternal
TargetSite : Int32 Execute(System.Data.Common.DbDataAdapter, System.Data.DataRow[], Telerik.OpenAccess.RT.sql.Batch)
HResult : -2146233067
Stack Trace :    at Telerik.OpenAccess.RT.Adonet2Generic.Impl.StatementImp.Execute(DbDataAdapter adapter, DataRow[] rows, Batch batch)
  at OpenAccessRuntime.Relational.conn.LoggingStatement.Execute(DbDataAdapter adapter, DataRow[] rows, Batch batch)
  at Telerik.OpenAccess.RT.sql.Batch.ExecuteBatchDataTable(Boolean withInfo)

Inner Exception
---------------
Type : System.NotSupportedException, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
Message : Specified method is not supported.
Source : System.Data
Help link : 
Data : System.Collections.ListDictionaryInternal
TargetSite : Void TerminateBatching()
HResult : -2146233067
Stack Trace :    at System.Data.Common.DbDataAdapter.TerminateBatching()
  at System.Data.Common.DbDataAdapter.Update(DataRow[] dataRows, DataTableMapping tableMapping)
  at System.Data.Common.DbDataAdapter.Update(DataRow[] dataRows)
  at OpenAccessRuntime.Intellitrace.Update(String id, DbDataAdapter adapter, DataRow[] rows)
  at Telerik.OpenAccess.RT.sql.Batch.Perform(String connId, DbDataAdapter adapter, DataRow[] rows)
  at Telerik.OpenAccess.Runtime.Logging.LoggingDbCommand.ExecuteBatch(DbDataAdapter adapter, DataRow[] rows, Batch batch)
  at Telerik.OpenAccess.RT.Adonet2Generic.Impl.CommandImp.Execute(DbDataAdapter adapter, DataRow[] rows, Batch batch)
  at Telerik.OpenAccess.RT.Adonet2Generic.Impl.StatementImp.Execute(DbDataAdapter adapter, DataRow[] rows, Batch batch)



Category: ErrorLog

Priority: 0

EventId: 90030

Severity: Error

Title:Enterprise Library Exception Handling

Machine: JDANIELS2

App Domain: /LM/W3SVC/2/ROOT-1-130747250321153623

ProcessId: 7144

Process Name: C:\windows\SysWOW64\inetsrv\w3wp.exe

Thread Name: 

Win32 ThreadId:6948

Extended Properties: 
----------------------------------------

Posted by Community Admin on 01-May-2015 00:00

Hi Josh,

As we have discussed in the ticket, it appeared that the below issue is related to the incompatibility between the Glimpse plugin which you are using and our OpenAccess StatementBatchingEnabled feature.

The fix for this issue is to disable our OpenAccess ORM's StatementBatchingEnabled feature, for more information about it you can check this article from the product documentation.

I am pasting the solution in this forum thread as well in order to share it with the community:

What you can try on your side is to apply the fix on a backup of your project and disable the OpenAccess ORM's StatementBatchingEnabled feature. 

In order to do this, you need to subscribe to the Telerik.Sitefinity.Data.OA.OpenAccessConnection.BackendConfigurationInit event in the application's Global.asax and set the StatementBatchingEnabled to false.

Here's an example of the implementation:

void Application_Start(object sender, EventArgs e)
    
        Telerik.Sitefinity.Data.OA.OpenAccessConnection.BackendConfigurationInit += new Telerik.Sitefinity.Data.OA.OpenAccessConnection.BackendConfigurationInitializer(OpenAccessConnection_BackendConfigurationInit);
    
   
    void OpenAccessConnection_BackendConfigurationInit(Telerik.Sitefinity.Data.OA.OpenAccessConnection connection, Telerik.OpenAccess.BackendConfiguration configuration)
    
        configuration.Runtime.StatementBatchingEnabled = false;
    

Please restart the application after you add the above code to your Global.asax file and test the behavior again.

If you need to use Glimpse you will need to keep the StatementBatchingEnabled turned off as demonstrated above. Please note that turning StatementBatchingEnabled might have some performance impact when the database server is located remotely form the application server, as it affects the way SQL statements are executed.

If you remove Glimpse you can safely remove the Global.asax modifications for turning 
StatementBatchingEnabled off, as its default value is true, and you will benefit from the performance optimization it brings.

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
 

This thread is closed