Copied to clipboard

Flag this post as spam?

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


  • Ras 66 posts 330 karma points
    Feb 28, 2024 @ 09:58
    Ras
    0

    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.

  • andrew shearer 512 posts 661 karma points
    Mar 12, 2024 @ 02:59
    andrew shearer
    0

    hi there - did you work this one out?

  • Ras 66 posts 330 karma points
    Mar 13, 2024 @ 16:08
    Ras
    102

    Hi Andrew, turns out we had unattended package migrations disabled. This required us to go into the packages tab and run the migration manually.

  • andrew shearer 512 posts 661 karma points
    Mar 13, 2024 @ 19:21
    andrew shearer
    0

    bingo! that's the nugget that fixed it for me. Thanks for pointing that out, Ras :)

  • Dave Mason 14 posts 95 karma points
    Apr 15, 2024 @ 22:01
    Dave Mason
    1

    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...

Please Sign in or register to post replies

Write your reply to:

Draft