Forms throws "Unable to load form: Invalid column name 'NodeId'." after upgrade to 12.2.0
Hi, I have a Umbraco 12 website where we're trying to go to 13, but are running into an error when we try to up the Forms version specifically version 12.2.0. Every existing form and when trying to create a new form throws the same error:
Unable to load form: Invalid column name 'NodeId'.
I'm not able to find this column in any of the old versions of forms, I would assume it used to exist but no longer does?
Seems like maybe it's occuring at some workflow, but I can't pinpoint which one it would be.
`{"@t":"2024-02-28T09:40:21.0741198Z","@mt":"Exception ({InstanceId}).","@l":"Error","@x":"Microsoft.Data.SqlClient.SqlException (0x80131904): Invalid column name 'NodeId'.\r\n at Microsoft.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)\r\n at Microsoft.Data.SqlClient.SqlIn`ternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)\r\n at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)\r\n at Microsoft.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)\r\n at Microsoft.Data.SqlClient.SqlDataReader.TryConsumeMetaData()\r\n at Microsoft.Data.SqlClient.SqlDataReader.get_MetaData()\r\n at Microsoft.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)\r\n at Microsoft.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean isAsync, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)\r\n at Microsoft.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry, String method)\r\n at Microsoft.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)\r\n at Microsoft.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)\r\n at StackExchange.Profiling.Data.ProfiledDbCommand.ExecuteDbDataReader(CommandBehavior behavior) in C:\\projects\\dotnet\\src\\MiniProfiler.Shared\\Data\\ProfiledDbCommand.cs:line 224\r\n at Umbraco.Cms.Infrastructure.Persistence.FaultHandling.RetryPolicy.ExecuteAction[TResult](Func`1 func)\r\n at NPoco.Database.ExecuteReaderHelper(DbCommand cmd)\r\n at NPoco.Database.ExecuteDataReader(DbCommand cmd, Boolean sync)\r\nClientConnectionId:7a9e281e-0869-47e3-aed9-8383d40bef98\r\nError Number:207,State:1,Class:16","InstanceId":"2124695d","SourceContext":"Umbraco.Cms.Infrastructure.Persistence.UmbracoDatabase","ActionId":"ef738bf9-aca9-42c5-b8d5-4fa811609356","ActionName":"Umbraco.Forms.Web.Editors.FormController.GetWithWorkflowsByGuid (Umbraco.Forms.Web)","RequestId":"80000012-0004-f500-b63f-84710c7967bb","RequestPath":"/umbraco/backoffice/UmbracoForms/Form/GetWithWorkflowsByGuid","ProcessId":352,"ProcessName":"iisexpress","ThreadId":15,"ApplicationId":"54449a41bdfc67b1387ee6da00b9292a45c1f633","MachineName":"DESKTOP-CO1L9UK","Log4NetLevel":"ERROR","HttpRequestId":"f4626c05-1962-4fcc-94ed-275d7def2c4f","HttpRequestNumber":8,"HttpSessionId":"d1cdf21f-6ecd-4f9e-cfb6-afd70ec628e3"}
Tried deleting all the workflows directly from the db but this makes no difference.
I had this after an upgrade to 13 on an azure web app, and the solution was to wipe the temp folder in the app service editor and restart the web app, and the problem went away...
Forms throws "Unable to load form: Invalid column name 'NodeId'." after upgrade to 12.2.0
Hi, I have a Umbraco 12 website where we're trying to go to 13, but are running into an error when we try to up the Forms version specifically version 12.2.0. Every existing form and when trying to create a new form throws the same error: Unable to load form: Invalid column name 'NodeId'.
I'm not able to find this column in any of the old versions of forms, I would assume it used to exist but no longer does?
Seems like maybe it's occuring at some workflow, but I can't pinpoint which one it would be.
Tried deleting all the workflows directly from the db but this makes no difference.
hi there - did you work this one out?
Hi Andrew, turns out we had unattended package migrations disabled. This required us to go into the packages tab and run the migration manually.
bingo! that's the nugget that fixed it for me. Thanks for pointing that out, Ras :)
I had this after an upgrade to 13 on an azure web app, and the solution was to wipe the temp folder in the app service editor and restart the web app, and the problem went away...
is working on a reply...