Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Srdjan 19 posts 52 karma points
    Jul 19, 2017 @ 08:45
    Srdjan
    0

    Compatibility with Umbraco Forms 6.0.2?

    Hi Tim,

    is there an option to migrate Contour forms to Umbraco v7.6.3 with Umbraco Forms v6.0.2? I needed to upgrade Umbraco v6.2.4 to v.7.6.3, in original website Contour forms were used so I need to migrate those firms and entries to latest Umbraco Form package. I followed steps from 'Steps to use?' post but stuck with the next error.

    When I run the tool I am getting this error:

    Oops something whent wrong

    Umbraco Exception (DataLayer): SQL helper exception in ExecuteReader

    at umbraco.DataLayer.SqlHelper'1.ExecuteReader(String commandText, IParameter[] parameters) at Umbraco.Forms.Migration.Data.Storage.FormStorage.GetAllForms(Boolean archived) in c:\Users\timgeyssens\Documents\Visual Studio 2013\Projects\Umbraco.Forms.Migration\Umbraco.Forms.Migration\Contour\Data\FormStorage\FormStorage.cs:line 45 at Umbraco.Forms.Migration.MigrationService.Migrate(String connString) in c:\Users\timgeyssens\Documents\Visual Studio 2013\Projects\Umbraco.Forms.Migration\Umbraco.Forms.Migration\MigrationService.cs:line 26 at Umbraco.Forms.Migration.ContourToForms.Button1_Click(Object sender, EventArgs e) in c:\Users\timgeyssens\Documents\Visual Studio 2013\Projects\Umbraco.Forms.Migration\Umbraco.Forms.Migration\ContourToForms.ascx.cs:line 23

    I know this issue the same with one Monammad had in this comment but here are more details on stack trace. Umbraco log file contains next error:

    2017-07-19 10:26:46,298 [P13464/D18/T60] ERROR umbraco.DataLayer.SqlHelper'1[[System.Data.SqlClient.SqlParameter, System.Data, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]]

    -Error executing query SELECT * FROM UFforms where archived = @archived order by name ASC;

    System.Data.SqlClient.SqlException (0x80131904): Invalid object name 'UFforms'.

    at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action'1 wrapCloseInAction)

    at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)

    at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)

    at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()

    at System.Data.SqlClient.SqlDataReader.get_MetaData()

    at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption)

    at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)

    at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource'1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)

    at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)

    at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)

    at System.Data.SqlClient.SqlCommand.ExecuteReader()

    at umbraco.DataLayer.SqlHelpers.SqlServer.SqlServerHelper.ExecuteReader(String commandText, SqlParameter[] parameters)

    at umbraco.DataLayer.SqlHelper`1.ExecuteReader(String commandText, IParameter[] parameters)

    ClientConnectionId:766b544e-8ba1-4409-afee-95ca18bff835

    Error Number:208,State:1,Class:16

    Thanks in advance,

    Srdjan

  • Gavin Williams 20 posts 120 karma points
    May 23, 2018 @ 14:43
    Gavin Williams
    0

    Ever get a response to this one? Experiencing the same issue trying to migrate contour from a 6.2.6 site to 7.9

  • Srdjan 19 posts 52 karma points
    May 23, 2018 @ 15:06
    Srdjan
    0

    Hi Gavin,

    no I have not. Maybe the way is to first try to migrate to 4.x and if that succeed then to try upgrade forms to version 6.x and then to version 7.x. But that means you need to upgrade umbraco version by version in order to support specific versions of umbraco forms. To be honest I did not find time for this as I had too many problems with uComponents as we needed to preserve content of Umbraco 4.x (upgrading to v7.6.3) so I spent to much time on upgrades of umbraco version by version, converters etc. and client decided to recreate forms after upgrade so I did not need to spend more time on this.

Please Sign in or register to post replies

Write your reply to:

Draft