Data Grid 2 datasource error when receiving data using xpath or database via Dataview association

1
Hello Everyone, I got the following errors with Data Grid 2 inside a dataview. The issue happen with Datasource type is Database or XPath which retreiving data via dataview association. It is fine for retreiving data directly from entity. XPath filter in that case also work well. System.AggregateException: One or more errors occurred. (Sequence contains no matching element) ---> System.InvalidOperationException: Sequence contains no matching element at System.Linq.ThrowHelper.ThrowNoMatchException() at System.Linq.Enumerable.Single[TSource](IEnumerable`1 source, Func`2 predicate) at Mendix.Modeler.WebUI.PluginWidgets.PropertyValues.ListValues.DatabaseObjectListValue.<>c__DisplayClass7_3.<Write>b__3(IJsArrayWriter argWriter) in Mendix.Modeler.WebUI\PluginWidgets\PropertyValues\ListValues\DatabaseObjectListValue.cs:line 62 at Mendix.Modeler.WebUI.Export.PluginWidgets.JsAsJsonWriter.WriteArray(Action`1 contentWriter) in Mendix.Modeler.WebUI.Export\PluginWidgets\JsAsJsonWriter.cs:line 42 at Mendix.Modeler.WebUI.PluginWidgets.PropertyValues.ListValues.DatabaseObjectListValue.<>c__DisplayClass7_2.<Write>b__2(ValueTuple`3 arg) in Mendix.Modeler.WebUI\PluginWidgets\PropertyValues\ListValues\DatabaseObjectListValue.cs:line 60 at Mendix.Common.Util.EnumerableUtil.ForEach[T](IEnumerable`1 source, Action`1 action) in Mendix.Common\Util\EnumerableUtil.cs:line 51 at Mendix.Modeler.WebUI.PluginWidgets.PropertyValues.ListValues.DatabaseObjectListValue.<>c__DisplayClass7_1.<Write>b__1(IJsObjectWriter argsWriter) in Mendix.Modeler.WebUI\PluginWidgets\PropertyValues\ListValues\DatabaseObjectListValue.cs:line 59 at Mendix.Modeler.WebUI.Export.PluginWidgets.JsAsJsonWriter.WriteObject(Action`1 contentWriter) in Mendix.Modeler.WebUI.Export\PluginWidgets\JsAsJsonWriter.cs:line 35 at Mendix.Modeler.WebUI.PluginWidgets.PropertyValues.ListValues.DatabaseObjectListValue.<>c__DisplayClass7_0.<Write>b__0(IJsObjectWriter paramWriter) in Mendix.Modeler.WebUI\PluginWidgets\PropertyValues\ListValues\DatabaseObjectListValue.cs:line 0 at Mendix.Modeler.WebUI.Export.PluginWidgets.JsAsJsonWriter.WriteProperty(String type, Action`1 paramsWriter) in Mendix.Modeler.WebUI.Export\PluginWidgets\JsAsJsonWriter.cs:line 50 at Mendix.Common.Util.EnumerableUtil.ForEach[T](IEnumerable`1 source, Action`1 action) in Mendix.Common\Util\EnumerableUtil.cs:line 51 at Mendix.Modeler.WebUI.Export.PluginWidgets.JsAsJsonWriter.WriteObject(Action`1 contentWriter) in Mendix.Modeler.WebUI.Export\PluginWidgets\JsAsJsonWriter.cs:line 35 at Mendix.Modeler.WebUI.Export.PluginWidgets.JsAsJsonWriter.WriteObject(Action`1 contentWriter) in Mendix.Modeler.WebUI.Export\PluginWidgets\JsAsJsonWriter.cs:line 35 at Mendix.Common.Util.EnumerableUtil.ForEach[T](IEnumerable`1 source, Action`1 action) in Mendix.Common\Util\EnumerableUtil.cs:line 51 at Mendix.Modeler.WebUI.Export.PluginWidgets.JsAsJsonWriter.WriteArray(Action`1 contentWriter) in Mendix.Modeler.WebUI.Export\PluginWidgets\JsAsJsonWriter.cs:line 42 at Mendix.Common.Util.EnumerableUtil.ForEach[T](IEnumerable`1 source, Action`1 action) in Mendix.Common\Util\EnumerableUtil.cs:line 51 at Mendix.Modeler.WebUI.Export.PluginWidgets.JsAsJsonWriter.WriteObject(Action`1 contentWriter) in Mendix.Modeler.WebUI.Export\PluginWidgets\JsAsJsonWriter.cs:line 35 at Mendix.Modeler.WebUI.Export.PluginWidgets.JsAsJsonWriter.WriteObject(Action`1 contentWriter) in Mendix.Modeler.WebUI.Export\PluginWidgets\JsAsJsonWriter.cs:line 35 at Mendix.Common.Util.EnumerableUtil.ForEach[T](IEnumerable`1 source, Action`1 action) in Mendix.Common\Util\EnumerableUtil.cs:line 51 at Mendix.Modeler.WebUI.Export.PluginWidgets.JsAsJsonWriter.WriteArray(Action`1 contentWriter) in Mendix.Modeler.WebUI.Export\PluginWidgets\JsAsJsonWriter.cs:line 42 at Mendix.Common.Util.EnumerableUtil.ForEach[T](IEnumerable`1 source, Action`1 action) in Mendix.Common\Util\EnumerableUtil.cs:line 51 at Mendix.Modeler.WebUI.Export.PluginWidgets.JsAsJsonWriter.WriteObject(Action`1 contentWriter) in Mendix.Modeler.WebUI.Export\PluginWidgets\JsAsJsonWriter.cs:line 35 at Mendix.Modeler.WebUI.Export.PluginWidgets.JsAsJsonWriter.WriteObject(Action`1 contentWriter) in Mendix.Modeler.WebUI.Export\PluginWidgets\JsAsJsonWriter.cs:line 35 at Mendix.Common.Util.EnumerableUtil.ForEach[T](IEnumerable`1 source, Action`1 action) in Mendix.Common\Util\EnumerableUtil.cs:line 51 at Mendix.Modeler.WebUI.Export.PluginWidgets.JsAsJsonWriter.WriteArray(Action`1 contentWriter) in Mendix.Modeler.WebUI.Export\PluginWidgets\JsAsJsonWriter.cs:line 42 at Mendix.Common.Util.EnumerableUtil.ForEach[T](IEnumerable`1 source, Action`1 action) in Mendix.Common\Util\EnumerableUtil.cs:line 51 at Mendix.Modeler.WebUI.Export.PluginWidgets.JsAsJsonWriter.WriteObject(Action`1 contentWriter) in Mendix.Modeler.WebUI.Export\PluginWidgets\JsAsJsonWriter.cs:line 35 at Mendix.Modeler.WebUI.Export.PluginWidgets.JsAsJsonWriter.WriteObject(Action`1 contentWriter) in Mendix.Modeler.WebUI.Export\PluginWidgets\JsAsJsonWriter.cs:line 35 at Mendix.Common.Util.EnumerableUtil.ForEach[T](IEnumerable`1 source, Action`1 action) in Mendix.Common\Util\EnumerableUtil.cs:line 51 at Mendix.Modeler.WebUI.Export.PluginWidgets.JsAsJsonWriter.WriteArray(Action`1 contentWriter) in Mendix.Modeler.WebUI.Export\PluginWidgets\JsAsJsonWriter.cs:line 42 at Mendix.Common.Util.EnumerableUtil.ForEach[T](IEnumerable`1 source, Action`1 action) in Mendix.Common\Util\EnumerableUtil.cs:line 51 at Mendix.Modeler.WebUI.Export.PluginWidgets.JsAsJsonWriter.WriteObject(Action`1 contentWriter) in Mendix.Modeler.WebUI.Export\PluginWidgets\JsAsJsonWriter.cs:line 35 at Mendix.Modeler.WebUI.Export.PluginWidgets.JsAsJsonWriter.WriteObject(Action`1 contentWriter) in Mendix.Modeler.WebUI.Export\PluginWidgets\JsAsJsonWriter.cs:line 35 at Mendix.Common.Util.EnumerableUtil.ForEach[T](IEnumerable`1 source, Action`1 action) in Mendix.Common\Util\EnumerableUtil.cs:line 51 at Mendix.Modeler.WebUI.Export.PluginWidgets.JsAsJsonWriter.WriteArray(Action`1 contentWriter) in Mendix.Modeler.WebUI.Export\PluginWidgets\JsAsJsonWriter.cs:line 42 at Mendix.Common.Util.EnumerableUtil.ForEach[T](IEnumerable`1 source, Action`1 action) in Mendix.Common\Util\EnumerableUtil.cs:line 51 at Mendix.Modeler.WebUI.Export.PluginWidgets.JsAsJsonWriter.WriteObject(Action`1 contentWriter) in Mendix.Modeler.WebUI.Export\PluginWidgets\JsAsJsonWriter.cs:line 35 at Mendix.Modeler.WebUI.Export.PluginWidgets.JsAsJsonWriter.WriteObject(Action`1 contentWriter) in Mendix.Modeler.WebUI.Export\PluginWidgets\JsAsJsonWriter.cs:line 35 at Mendix.Common.Util.EnumerableUtil.ForEach[T](IEnumerable`1 source, Action`1 action) in Mendix.Common\Util\EnumerableUtil.cs:line 51 at Mendix.Modeler.WebUI.Export.PluginWidgets.JsAsJsonWriter.WriteArray(Action`1 contentWriter) in Mendix.Modeler.WebUI.Export\PluginWidgets\JsAsJsonWriter.cs:line 42 at Mendix.Common.Util.EnumerableUtil.ForEach[T](IEnumerable`1 source, Action`1 action) in Mendix.Common\Util\EnumerableUtil.cs:line 51 at Mendix.Modeler.WebUI.Export.PluginWidgets.JsAsJsonWriter.WriteObject(Action`1 contentWriter) in Mendix.Modeler.WebUI.Export\PluginWidgets\JsAsJsonWriter.cs:line 35 at Mendix.Modeler.WebUI.Export.PluginWidgets.JsAsJsonWriter.WriteObject(Action`1 contentWriter) in Mendix.Modeler.WebUI.Export\PluginWidgets\JsAsJsonWriter.cs:line 35 at Mendix.Common.Util.EnumerableUtil.ForEach[T](IEnumerable`1 source, Action`1 action) in Mendix.Common\Util\EnumerableUtil.cs:line 51 at Mendix.Modeler.WebUI.Export.PluginWidgets.JsAsJsonWriter.WriteArray(Action`1 contentWriter) in Mendix.Modeler.WebUI.Export\PluginWidgets\JsAsJsonWriter.cs:line 42 at Mendix.Common.Util.EnumerableUtil.ForEach[T](IEnumerable`1 source, Action`1 action) in Mendix.Common\Util\EnumerableUtil.cs:line 51 at Mendix.Modeler.WebUI.Export.PluginWidgets.JsAsJsonWriter.WriteObject(Action`1 contentWriter) in Mendix.Modeler.WebUI.Export\PluginWidgets\JsAsJsonWriter.cs:line 35 at Mendix.Modeler.WebUI.Export.PluginWidgets.JsAsJsonWriter.WriteObject(Action`1 contentWriter) in Mendix.Modeler.WebUI.Export\PluginWidgets\JsAsJsonWriter.cs:line 35 at Mendix.Common.Util.EnumerableUtil.ForEach[T](IEnumerable`1 source, Action`1 action) in Mendix.Common\Util\EnumerableUtil.cs:line 51 at Mendix.Modeler.WebUI.Export.PluginWidgets.JsAsJsonWriter.WriteArray(Action`1 contentWriter) in Mendix.Modeler.WebUI.Export\PluginWidgets\JsAsJsonWriter.cs:line 42 at Mendix.Modeler.WebUI.PluginWidgets.PluginWidget.<>c__DisplayClass34_0.<WriteWidget>b__0(JsonWriter writer) in Mendix.Modeler.WebUI\PluginWidgets\PluginWidget.cs:line 75 at Mendix.Modeler.WebUI.Forms.Exporter.FormWriter.GetWidgetProperties(Action`1 writeProperties) in Mendix.Modeler.WebUI\Forms\Exporter\FormWriter.cs:line 155 at Mendix.Modeler.WebUI.PluginWidgets.PluginWidget.WriteWidget(IFormWriter formWriter, IWebExportContext context) in Mendix.Modeler.WebUI\PluginWidgets\PluginWidget.cs:line 80 at Mendix.Modeler.WebUI.Forms.Exporter.FormWriter.WriteArgument(String parameterName, IEnumerable`1 widgets) in Mendix.Modeler.WebUI\Forms\Exporter\FormWriter.cs:line 80 at Mendix.Modeler.WebUI.Forms.Exporter.FormWriter.WriteArguments(IDictionary`2 arguments) in Mendix.Modeler.WebUI\Forms\Exporter\FormWriter.cs:line 291 at Mendix.Modeler.WebUI.Forms.Exporter.FormWriter.<>c__DisplayClass21_0.<Write>b__0() in Mendix.Modeler.WebUI\Forms\Exporter\FormWriter.cs:line 187 at Mendix.Modeler.Common.ResolveCache.TrackResolves(Action code) in Mendix.Modeler.Core\Common\Problems\ResolveCache.cs:line 100 at Mendix.Modeler.WebUI.Forms.Exporter.FormWriter.Write() in Mendix.Modeler.WebUI\Forms\Exporter\FormWriter.cs:line 192 at Mendix.Modeler.Common.ResolveCache.TrackResolves(Action code) in Mendix.Modeler.Core\Common\Problems\ResolveCache.cs:line 100 at Mendix.Modeler.WebUI.Forms.Exporter.FormExporter.<>c__DisplayClass5_1.<ExportForms>b__2() in Mendix.Modeler.WebUI\Forms\Exporter\FormExporter.cs:line 92 at Mendix.Modeler.Common.ResolveCache.WithCache[T](IProject project, Func`1 action) in Mendix.Modeler.Core\Common\Problems\ResolveCache.cs:line 73 at Mendix.Modeler.WebUI.Forms.Exporter.FormExporter.<>c__DisplayClass5_0.<ExportForms>b__1(IDocument document) in Mendix.Modeler.WebUI\Forms\Exporter\FormExporter.cs:line 82 at Mendix.Modeler.Projects.Changes.ChangedDocumentsProcessor`1.<>c__DisplayClass6_0.<ProcessChangedDocuments>g__DoProcess|2(IDocument document) in Mendix.Modeler.Core\Projects\Changes\ChangedDocumentsProcessor.cs:line 90 at System.Linq.Parallel.ForAllOperator`1.ForAllEnumerator`1.MoveNext(TInput& currentElement, Int32& currentKey) at System.Linq.Parallel.ForAllSpoolingTask`2.SpoolingWork() at System.Linq.Parallel.SpoolingTaskBase.Work() at System.Linq.Parallel.QueryTask.BaseWork(Object unused) at System.Threading.ExecutionContext.RunFromThreadPoolDispatchLoop(Thread threadPoolThread, ExecutionContext executionContext, ContextCallback callback, Object state) --- End of stack trace from previous location --- at System.Threading.Tasks.Task.ExecuteWithThreadLocal(Task& currentTaskSlot, Thread threadPoolThread) --- End of inner exception stack trace --- at System.Linq.Parallel.QueryTaskGroupState.QueryEnd(Boolean userInitiatedDispose) at System.Linq.Parallel.SpoolingTask.SpoolForAll[TInputOutput,TIgnoreKey](QueryTaskGroupState groupState, PartitionedStream`2 partitions, TaskScheduler taskScheduler) at System.Linq.Parallel.MergeExecutor`1.Execute[TKey](PartitionedStream`2 partitions, Boolean ignoreOutput, ParallelMergeOptions options, TaskScheduler taskScheduler, Boolean isOrdered, CancellationState cancellationState, Int32 queryId) at System.Linq.Parallel.PartitionedStreamMerger`1.Receive[TKey](PartitionedStream`2 partitionedStream) at System.Linq.Parallel.ForAllOperator`1.WrapPartitionedStream[TKey](PartitionedStream`2 inputStream, IPartitionedStreamRecipient`1 recipient, Boolean preferStriping, QuerySettings settings) at System.Linq.Parallel.UnaryQueryOperator`2.UnaryQueryOperatorResults.ChildResultsRecipient.Receive[TKey](PartitionedStream`2 inputStream) at System.Linq.Parallel.ScanQueryOperator`1.ScanEnumerableQueryOperatorResults.GivePartitionedStream(IPartitionedStreamRecipient`1 recipient) at System.Linq.Parallel.UnaryQueryOperator`2.UnaryQueryOperatorResults.GivePartitionedStream(IPartitionedStreamRecipient`1 recipient) at System.Linq.Parallel.QueryOperator`1.GetOpenedEnumerator(Nullable`1 mergeOptions, Boolean suppressOrder, Boolean forEffect, QuerySettings querySettings) at System.Linq.Parallel.ForAllOperator`1.RunSynchronously() at System.Linq.ParallelEnumerable.ForAll[TSource](ParallelQuery`1 source, Action`1 action) at Mendix.Modeler.Projects.Changes.ChangedDocumentsProcessor`1.ProcessChangedDocuments(IProject project, ProjectChanges projectChanges, Func`2 processDocument) in Mendix.Modeler.Core\Projects\Changes\ChangedDocumentsProcessor.cs:line 82 at Mendix.Modeler.WebUI.Forms.Exporter.FormExporter.ExportForms(IProject project, Boolean updateRunningProject) in Mendix.Modeler.WebUI\Forms\Exporter\FormExporter.cs:line 63 at Mendix.Modeler.WebUI.Deployment.WebUIDeploymentWorker.ExportPages(IProject project, IProgressInfo info, Boolean updateRunningProject) in Mendix.Modeler.WebUI\Deployment\WebUIDeploymentWorker.cs:line 201 at Mendix.Modeler.WebUI.Deployment.WebUIDeploymentWorker.DoWork(DeploymentPhase phase, IProject project, DeploymentSettings settings, IProgressInfo info) in Mendix.Modeler.WebUI\Deployment\WebUIDeploymentWorker.cs:line 111 at Mendix.Modeler.Deployment.DeploymentProcessBuilder.ExecuteDeploymentWorkForPhase(DeploymentPhase phase, IProject project, DeploymentSettings settings, IProgressInfo info) in Mendix.Modeler.Deployment\DeploymentProcessBuilder.cs:line 187 at Mendix.Modeler.Deployment.DeploymentProcessBuilder.<>c__DisplayClass13_1.<AddBuildStepWithOverride>b__2() in Mendix.Modeler.Deployment\DeploymentProcessBuilder.cs:line 157 at Mendix.Modeler.Projects.ProjectStructureManager.<>c__DisplayClass2_0.<DoWithOverride>b__0() in Mendix.Modeler.Core\Projects\ProjectStructureManager.cs:line 40 at Mendix.Modeler.Projects.ProjectStructureManager.Do[T](IProject projectOverride, Func`1 action) in Mendix.Modeler.Core\Projects\ProjectStructureManager.cs:line 60 at Mendix.Modeler.Projects.ProjectStructureManager.DoWithOverride(IProject projectOverride, Action action) in Mendix.Modeler.Core\Projects\ProjectStructureManager.cs:line 38 at Mendix.Modeler.Deployment.DeploymentProcessBuilder.<>c__DisplayClass13_1.<AddBuildStepWithOverride>b__1() in Mendix.Modeler.Deployment\DeploymentProcessBuilder.cs:line 156 at Mendix.Modeler.ProtectedModules.ProtectedModulesUnlocker.<>c__DisplayClass3_0.<Do>b__0() in Mendix.Modeler.Core\ProtectedModules\ProtectedModulesUnlocker.cs:line 22 at Mendix.Modeler.ProtectedModules.ProtectedModulesUnlocker.ExecuteInContext[T](Boolean unlockImplementation, Func`1 code) in Mendix.Modeler.Core\ProtectedModules\ProtectedModulesUnlocker.cs:line 42 at Mendix.Modeler.ProtectedModules.ProtectedModulesUnlocker.Do(Boolean unlockImplementation, Action action) in Mendix.Modeler.Core\ProtectedModules\ProtectedModulesUnlocker.cs:line 20 at Mendix.Modeler.Deployment.DeploymentProcessBuilder.<>c__DisplayClass13_0.<AddBuildStepWithOverride>b__0(IProgressInfo info) in Mendix.Modeler.Deployment\DeploymentProcessBuilder.cs:line 155 at Mendix.Modeler.Deployment.FileIOExceptionHandlingProcess.<>c__DisplayClass2_1.<AddStep>b__1() in Mendix.Modeler.Deployment\FileIOExceptionHandlingProcess.cs:line 22 at Mendix.Modeler.Deployment.FileIOExceptionHandlingProcess.CatchDiskException(Action action) in Mendix.Modeler.Deployment\FileIOExceptionHandlingProcess.cs:line 31 at Mendix.Modeler.Deployment.FileIOExceptionHandlingProcess.<>c__DisplayClass2_0.<AddStep>b__0(IProgressInfo info) in Mendix.Modeler.Deployment\FileIOExceptionHandlingProcess.cs:line 22 at Mendix.Modeler.Utility.Progress.StepBase`1.Run(TProgressInfo info) in Mendix.Modeler.Utility\Progress\Step.cs:line 31 at Mendix.Modeler.Utility.Progress.StepBase`1.Mendix.Modeler.Utility.Progress.IStep.Run(Object progressInfo) in Mendix.Modeler.Utility\Progress\Step.cs:line 36 at Mendix.Modeler.UIFramework.Progress.ProcessRunner.RunStep(IStep step) in Mendix.Modeler.UIFramework\Progress\ProcessRunner.cs:line 167 at Mendix.Modeler.UIFramework.Progress.ProcessRunner.OnDoWork(Object sender, DoWorkEventArgs e) in Mendix.Modeler.UIFramework\Progress\ProcessRunner.cs:line 81 at System.ComponentModel.BackgroundWorker.OnDoWork(DoWorkEventArgs e) at System.ComponentModel.BackgroundWorker.WorkerThreadStart(Object argument) --- End of stack trace from previous location --- at Mendix.Modeler.UIFramework.Progress.ProcessRunner.Run() in Mendix.Modeler.UIFramework\Progress\ProcessRunner.cs:line 57 at Mendix.Modeler.Deployment.Deployer.RunProcess(IProcess process, String what, Boolean isPackage) in Mendix.Modeler.Deployment\Deployer.cs:line 85  
asked
0 answers