Customized Customer Statements errors in Kinetic 2023.2

Kinetic ERP
1

I have 2 different customized versions of the customer statements that were created while running 10.2.200 and worked fine. Now in Kinetic, I get the error below for both of them. The stock report works correctly. I checked the server event viewer and it had basically the same error. Not sure where else to look to find what is broken.

Program Ice.Services.Lib.RunTask when executing task 2322626 raised an unexpected exception with the following message: RunTask:
System.InvalidOperationException: Sequence contains no matching element
at System.Linq.ThrowHelper.ThrowNoMatchException()
at Ice.Core.RptBase.DataSourceRelationship…ctor(RptRelation rptRelation, IEnumerable1 rptRelationFields, DataSourceCollection dataSources, IEnumerable1 whereItems) in C:_releases\ICE\ICE4.2.400.0FW\Source\Server\Internal\Lib\TaskLib\RptBase\DataSourceRelationship.cs:line 37
at Ice.Core.RptBase.ReportDefinitionLoader.<>c__DisplayClass11_0.b__0(RptRelation rptRelation) in C:_releases\ICE\ICE4.2.400.0FW\Source\Server\Internal\Lib\TaskLib\RptBase\ReportDefinitionLoader.cs:line 191
at System.Linq.Enumerable.SelectListIterator2.ToArray() at System.Linq.Buffer1…ctor(IEnumerable1 source) at System.Linq.OrderedEnumerable1.ToArray()
at Ice.Core.RptBase.ReportDefinitionLoader.LoadReport(CachedTables cachedTables, SqlTableSchemaCache sqlTableSchemaCache, Func2 getBaqInformation, IElectronicInterfaceReportingExtender eiReportingExtender, IEnumerable1 extensionTables, String reportParameterTableSystemCode, String reportParameterTableId, String languageFromReportParameter, String languageFromSession, Guid reportInstanceId) in C:_releases\ICE\ICE4.2.400.0FW\Source\Server\Internal\Lib\TaskLib\RptBase\ReportDefinitionLoader.cs:line 48
at Ice.Core.RptTaskBase`1.XMLOpen(String fileName) in C:_releases\ICE\ICE4.2.400.0FW\Source\Server\Internal\Lib\TaskLib\RptBase\RptTaskBase.cs:line 315
at Erp.Internal.AR.CustomerStatement.InternalRunProcess() in C:_releases\ERP\ERP11.2.400.0\Source\Server\Internal\AR\CustomerStatement\CustomerStatement.cs:line 744
at Erp.Internal.AR.CustomerStatement.RunProcess(Int64 instanceTaskNum, String outputFileName) in C:_releases\ERP\ERP11.2.400.0\Source\Server\Internal\AR\CustomerStatement\CustomerStatement.cs:line 726
at Ice.Hosting.TaskCaller.InnerExecuteTask(IceDataContext newContext) in C:_releases\ICE\ICE4.2.400.11\Source\Server\Framework\Epicor.Ice\Hosting\TaskCaller\TaskCaller.cs:line 69
at Ice.Hosting.TaskCaller.ExecuteTask() in C:_releases\ICE\ICE4.2.400.11\Source\Server\Framework\Epicor.Ice\Hosting\TaskCaller\TaskCaller.cs:line 65
at Ice.Lib.RunTask.BpmFriendlyTaskLauncher.Run(String sessionIdPrefix, IceContext db, Action taskRunner) in C:_releases\ICE\ICE4.2.400.0FW\Source\Server\Services\Lib\RunTask\BpmFriendlyTaskLauncher.cs:line 63
at Ice.Services.Lib.RunTaskSvc.InnerRunTask(Int64 ipTaskNum, Boolean suppressTransaction) in C:_releases\ICE\ICE4.2.400.0FW\Source\Server\Services\Lib\RunTask\RunTask.cs:line 457

2

Any resolution?
We have the same problem but with a custom Sales Order Ack SSRS after upgrading to 2024.2

3

Hey Rick. I just ran back through my notes and unfortunately I don’t remember how I worked my way through this problem.

4

I figured out the issue and I thought I’d document it for anyone else that runs across this.
The issue is in the RDD.
In my case this Report was a custom report that needed to pull in CSF UD fields which during the last upgrade somehow broke the RDD, where the RDD removed Data Source tables I had added but still kept the Relationships. So this error was thrown on a missing association in the Relationships. I just had to add the two missing tables and the Report started working again. Good reason to always backup the RDD’s? They might be able to reimport in a future version… maybe? If not, you can still read/compare the backed up RDD xml to the current running RDD exported xml to determine any differences.

This same error could also be raised in previous versions that used Crystal Reports because it’s an RDD issue:
Sequence does not contain no matching element while running crystal reports - Epicor ERP 10 - Epicor User Help Forum

1 Like