Error when using array for GUID type parameter

After upgrade from 2024.6 to 2025.2 the use of an array context store for GUID type parameters ends with an error.

image

2025-02-13 21:49:40,277 [30] ERROR Origam.Workflow.WorkflowEngine - ServiceMethodCallTask UnavailablePickupAndDropoffTimes_API_Load/02_Call_WybyService_getUnavailablePickupAndDropoffTimes failed.
2025-02-13 21:49:40,277 [30] ERROR Origam.Workflow.WorkflowEngine - Function 'AS:LookupValue()' has failed.
Workflow stack trace
	Step: 'UnavailablePickupAndDropoffTimes_API_Load/01_LoadData_RentalObjectOffer_Candidates'
	Step: 'UnavailablePickupAndDropoffTimes_API_Load/02_Call_WybyService_getUnavailablePickupAndDropoffTimes'

Origam.OrigamException: Function 'AS:LookupValue()' has failed.
 ---> System.Xml.XPath.XPathException: Function 'AS:LookupValue()' has failed.
 ---> System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation.
 ---> Origam.OrigamException: Lookup-Text für Lookup nicht verfügbar: bb621e00-2ebf-458e-9cbe-08961d1af26c
 ---> System.Data.DataException: Beim Erhalt eines Einzelwerts ist ein Ausnahmefall aufgetreten. 
Error occured when setting parameter: @RentalObject_parId to value: System.Collections.Generic.List`1[System.String]
 ---> System.Exception: Error occured when setting parameter: @RentalObject_parId to value: System.Collections.Generic.List`1[System.String]
 ---> System.FormatException: Guid should contain 32 digits with 4 dashes (xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx).
   at System.Guid.GuidResult.SetFailure(ParseFailure failureKind)
   at System.Guid.TryParseExactN(ReadOnlySpan`1 guidString, GuidResult& result)
   at System.Guid.TryParseGuid(ReadOnlySpan`1 guidString, GuidResult& result)
   at System.Guid..ctor(String g)
   at Origam.DA.Service.AbstractDataService.BuildParameters(QueryParameterCollection parameters, IDataParameterCollection dsParameters, UserProfile currentProfile) in D:\a\1\s\backend\Origam.DA.Service\AbstractDataService.cs:line 374
   --- End of inner exception stack trace ---
   at Origam.DA.Service.AbstractDataService.BuildParameters(QueryParameterCollection parameters, IDataParameterCollection dsParameters, UserProfile currentProfile) in D:\a\1\s\backend\Origam.DA.Service\AbstractDataService.cs:line 543
   at Origam.DA.Service.AbstractSqlDataService.GetScalarValue(DataStructureQuery query, ColumnsInfo columnsInfo, IPrincipal principal, String transactionId) in D:\a\1\s\backend\Origam.DA.Service\AbstractSqlDataService.cs:line 1001
   --- End of inner exception stack trace ---
   at Origam.DA.Service.AbstractSqlDataService.GetScalarValue(DataStructureQuery query, ColumnsInfo columnsInfo, IPrincipal principal, String transactionId) in D:\a\1\s\backend\Origam.DA.Service\AbstractSqlDataService.cs:line 1114
   at Origam.Workflow.DataServiceAgent.GetScalarValue(DataStructureQuery query, ColumnsInfo columnsInfo) in D:\a\1\s\backend\Origam.Workflow\Service Agents\DataServiceAgent.cs:line 148
   at Origam.Workflow.DataServiceAgent.Run() in D:\a\1\s\backend\Origam.Workflow\Service Agents\DataServiceAgent.cs:line 482
   at Origam.Workbench.Services.DataLookupService.GetDisplayText(Guid lookupId, Dictionary`2 parameters, Boolean useCache, Boolean returnMessageIfNull, String transactionId) in D:\a\1\s\backend\Origam.Workbench.Services\DataLookupService.cs:line 223
   --- End of inner exception stack trace ---
   at Origam.Workbench.Services.DataLookupService.GetDisplayText(Guid lookupId, Dictionary`2 parameters, Boolean useCache, Boolean returnMessageIfNull, String transactionId) in D:\a\1\s\backend\Origam.Workbench.Services\DataLookupService.cs:line 247
   at Origam.Workbench.Services.DataLookupService.GetDisplayText(Guid lookupId, Object lookupValue, Boolean useCache, Boolean returnMessageIfNull, String transactionId) in D:\a\1\s\backend\Origam.Workbench.Services\DataLookupService.cs:line 127
   at Origam.Rule.XsltFunctions.LegacyXsltFunctionContainer.LookupValue(String lookupId, String recordId) in D:\a\1\s\backend\Origam.Rule\XsltFunctions\LegacyXsltFunctionContainer.cs:line 354
   at InvokeStub_LegacyXsltFunctionContainer.LookupValue(Object, Span`1)
   at System.Reflection.MethodBaseInvoker.InvokeWithFewArgs(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
   --- End of inner exception stack trace ---
   at System.Reflection.MethodBaseInvoker.InvokeWithFewArgs(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
   at Origam.Rule.Xslt.OrigamXsltContext.FuncExtension.Invoke(XsltContext xsltContext, Object[] args, XPathNavigator docContext) in D:\a\1\s\backend\Origam.Rule\Xslt\OrigamXsltContext.cs:line 285
   at MS.Internal.Xml.XPath.FunctionQuery.Evaluate(XPathNodeIterator nodeIterator)
   --- End of inner exception stack trace ---
   at MS.Internal.Xml.XPath.FunctionQuery.Evaluate(XPathNodeIterator nodeIterator)
   at System.Xml.XPath.XPathNavigator.Evaluate(XPathExpression expr, XPathNodeIterator context)
   at Origam.Rule.RuleEngine.EvaluateContext(String xpath, Object context, OrigamDataType dataType, AbstractDataStructure targetStructure) in D:\a\1\s\backend\Origam.Rule\RuleEngine.cs:line 434
   at Origam.Workflow.Tasks.ServiceMethodCallEngineTask.OnExecute() in D:\a\1\s\backend\Origam.Workflow\Tasks\ServiceMethodCallEngineTask.cs:line 100
   at Origam.Workflow.ProfilingTools.<>c__DisplayClass4_0.<ExecuteAndLogDuration>g__FuncToExecute|0() in D:\a\1\s\backend\Origam.Workflow\ProfilingTools.cs:line 63
   at Origam.Workflow.Tasks.ServiceMethodCallEngineTask.Execute() in D:\a\1\s\backend\Origam.Workflow\Tasks\ServiceMethodCallEngineTask.cs:line 66
   --- End of inner exception stack trace ---

This topic was automatically closed 2 days after the last reply. New replies are no longer allowed.

A post was split to a new topic: Data API page with array of guids parameter