I have an UI action Workflow where I pass data from ActualRecord such as
Context parCourseCoach is of type XML with correct DataStructure applied.
When I use DataService method LoadData and map parameter value from above mentioned parCourseCoach XML context I get an error that the the value was not supplied. Which is not true.
Parameter mapping is done this way
Error I get in UI
Workflow Trace stack says:
Error loading data from table 'Coach' into entity 'Coach'
Message: The parameterized query '(@Coach_parId uniqueidentifier,@Coach_parCurrentDate datetime)SE' expects the parameter '@Coach_parId', which was not supplied. Exception was encountered while updating data. For more information see Details.
--------------------------------
Error loading data from table 'Coach' into entity 'Coach'
Message: The parameterized query '(@Coach_parId uniqueidentifier,@Coach_parCurrentDate datetime)SE' expects the parameter '@Coach_parId', which was not supplied. Exception was encountered while updating data. For more information see Details.
--------------------------------
The parameterized query '(@Coach_parId uniqueidentifier,@Coach_parCurrentDate datetime)SE' expects the parameter '@Coach_parId', which was not supplied.
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.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.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\backend\Origam.DA.Service\AbstractSqlDataService.cs:line 120
So to me it seems like that the XPath part of parameter mapping is not processed correctly or at all.
Thank you for the response or fix.
ORIGAM version I have tested is 2024.11.1.3633
When I map the parameter form Uniqidentifier context like this
everything is just fine and working.