I have a lazily loaded screen, where there is a blob column with images in the main entity. The column is excluded from all fields. In a list data structure of the lazily-loaded screen it used to be modeled as an ordinary field. It used to take a lot of time to load the screen, because it used to load all the picture data during load of the list (about 700MB of data). I had set the property IsWriteOnly to true.
I was expecting everything works well and the list for the screen will be loaded fast.
Instead I’ve got an error, telling me the column is not found in the datastructure.
2023-06-07 10:53:38,414 [7] ERROR Origam.Server.Controller.AbstractController - Data structure entity Product[b43b3aaf-9694-4e05-a29a-5f33b752a884] is missing Picture column(s).
System.Exception: Data structure entity Product[b43b3aaf-9694-4e05-a29a-5f33b752a884] is missing Picture column(s).
at Origam.DA.Service.AbstractSqlCommandGenerator.GetSortedColumns(DataStructureEntity entity, List1 scalarColumnNames, List1 aggregatedColumns) in D:\a\1\s\backend\Origam.DA.Service\Generators\AbstractSqlCommandGenerator.cs:line 0
at Origam.DA.Service.AbstractSqlCommandGenerator.RenderSelectColumns(SelectParameters selectParameters, StringBuilder sqlExpression, StringBuilder orderByBuilder, StringBuilder groupByBuilder, Hashtable replaceParameterTexts, Hashtable selectParameterReferences, Boolean isInRecursion, Boolean concatScalarColumns, Boolean forceDatabaseCalculation, FilterCommandParser filterCommandParser, OrderByCommandParser orderByCommandParser) in D:\a\1\s\backend\Origam.DA.Service\Generators\AbstractSqlCommandGenerator.cs:line 1857
at Origam.DA.Service.AbstractSqlCommandGenerator.SelectSql(SelectParameters selectParameters, Hashtable replaceParameterTexts, Hashtable selectParameterReferences, Boolean restrictScalarToTop1, Boolean isInRecursion, Boolean forceDatabaseCalculation, FilterCommandParser filterCommandParser, OrderByCommandParser orderByCommandParser) in D:\a\1\s\backend\Origam.DA.Service\Generators\AbstractSqlCommandGenerator.cs:line 1035
at Origam.DA.Service.AbstractSqlCommandGenerator.BuildCommands(IDbDataAdapter adapter, SelectParameters selectParameters, Boolean forceDatabaseCalculation) in D:\a\1\s\backend\Origam.DA.Service\Generators\AbstractSqlCommandGenerator.cs:line 333
at Origam.DA.Service.AbstractSqlCommandGenerator.CreateDataAdapter(SelectParameters adParameters, Boolean forceDatabaseCalculation) in D:\a\1\s\backend\Origam.DA.Service\Generators\AbstractSqlCommandGenerator.cs:line 162
at Origam.DA.Service.AbstractDataService.GetAdapterNonCached(SelectParameters adParameters) in D:\a\1\s\backend\Origam.DA.Service\AbstractDataService.cs:line 215
at Origam.DA.Service.AbstractDataService.GetAdapter(SelectParameters selectParameters, UserProfile userProfile) in D:\a\1\s\backend\Origam.DA.Service\AbstractDataService.cs:line 157
at Origam.DA.Service.AbstractSqlDataService.ExecuteDataReader(DataStructureQuery query, IPrincipal principal, String transactionId) in D:\a\1\s\backend\Origam.DA.Service\AbstractSqlDataService.cs:line 1725
at Origam.DA.Service.AbstractSqlDataService.ExecuteDataReaderInternal(DataStructureQuery query)+MoveNext() in D:\a\1\s\backend\Origam.DA.Service\AbstractSqlDataService.cs:line 1821
at System.Linq.Enumerable.SelectEnumerableIterator2.ToList() at Origam.Server.Controller.AbstractController.ExecuteDataReader(DataStructureQuery dataStructureQuery, Guid methodId) in D:\a\1\s\backend\Origam.Server\Controller\AbstractController.cs:line 461 at Origam.Server.Controller.UIServiceController.<>c__DisplayClass35_0.<GetRows>b__3(DataStructureQuery dataStructureQuery) in D:\a\1\s\backend\Origam.Server\Controller\UIServiceController.cs:line 369 at CSharpFunctionalExtensions.ResultExtensions.Bind[T,K,E](Result2 result, Func2 func) at Origam.Server.Controller.UIServiceController.<>c__DisplayClass35_0.<GetRows>b__0() in D:\a\1\s\backend\Origam.Server\Controller\UIServiceController.cs:line 366 at Origam.Server.Controller.AbstractController.RunWithErrorHandler(Func1 func) in D:\a\1\s\backend\Origam.Server\Controller\AbstractController.cs:line 88