Error: Invalid column name 'SessionId'

I got new error regarding entity OrigamIdentityGrant. I checked the model - entity and column SessionId exist and correspond to table in SQL database as well. Model version (Root, Secutiry) is from Master 7221.

Hosting environment: Production
Content root path: C:\inetpub\html5test2
Now listening on: http://*:8080/
Now listening on: https://*:8443/
Application started. Press Ctrl+C to shut down.
fail: Microsoft.AspNetCore.Diagnostics.ExceptionHandlerMiddleware[1]
      An unhandled exception has occurred while executing the request.
      Origam.OrigamException: Nastala chyba při načítání dat z tabulky 'OrigamIdentityGrant' do entity 'OrigamIdentityGrant'
      Chyba: Invalid column name 'SessionId'. Nastala chyba při ukládání dat. Pro více informací viz Podrobnosti.
       ---> System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'SessionId'.
         at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
         at System.Data.SqlClient.SqlInternalConnection.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)
         at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds)
         at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite, String method)
         at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
         at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)
         at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
         at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
         at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
         at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
         at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)
         at Origam.DA.Service.DataLoader.Fill() in D:\a\1\s\Origam.DA.Service\AbstractSqlDataService.cs:line 117
      ClientConnectionId:5be1f317-d210-40e4-867d-75b03a4e9a45
      Error Number:207,State:1,Class:16
         --- End of inner exception stack trace ---

You need to run deployment scripts on the Security package in Architect first.

I know, they were executed on package open in Architect. See attached image from SQL. The table is empty. The error persist.

image

The error message clearly states that the SessionId column is missing in the table OrigamIdentityGrant. The script must have not been executed.

The script was executed, when I try to run the deployment script manually I get error the column already exist. The column is visible in SQL as well. When I try to save the table data in Architect directly from datastructure, it don’t throw any error. There is no error in the browser windows, it shows only white blank screen (there is only some javascript code visible in the page source)

Must be a different database then. It is an SQL Server message that clearly states that the column is NOT there.

This topic was automatically closed after 6 days. New replies are no longer allowed.