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:
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.
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
Ever get a response to this one? Experiencing the same issue trying to migrate contour from a 6.2.6 site to 7.9
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.
is working on a reply...
This forum is in read-only mode while we transition to the new forum.
You can continue this topic on the new forum by tapping the "Continue discussion" link below.