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

Forums / Bugs & Issues / Error upgrading from 5.4 to 8.0

Error upgrading from 5.4 to 8.0

2 posts, 0 answered
  1. Josh
    Josh avatar
    16 posts
    Registered:
    15 May 2012
    28 Apr 2015
    Link to this post
    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: http://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: 
    ----------------------------------------

  2. Sabrie Nedzhip
    Sabrie Nedzhip avatar
    534 posts
    Registered:
    09 Dec 2016
    01 May 2015
    Link to this post
    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
     
2 posts, 0 answered