Are you 100% sure you have a record to break on and the field is not null?
2 Likes
the field shouldn’t be NULL as it is orderNUM and that is part of the primary key.
However I have tried many break tables. What would be the correct use of the break table?
For this, you would want to use OrderHed.
1 Like
the mystery continues. I have created a new form with new SSRS/ Breaking/Routing.
I have set the break table to OrderHed.
same result.
Emails get sent and appear in the log with only system.constents
Emails do not get sent and do not appear in the log as soon as a field is inserted.
tested purely by only inserting orderhed\ordernum and naming it aaaa
Perhaps the table is NULL and doesn’t contain any data. The pdf attachment is for the correct order so I dont see why it would and if the report style doesnt contain any data I dont see the point of having the option to add a field in the first place.
Thanks for all you efforts. Any other ideas would be greatly received.
I have had an epicor case open for a few days awaiting a reply. When it gets resolved I will post the info to help people in the future.
1 Like
Did you create a new report data definition?
1 Like
Will you screenshot your routing setup? Like the view of the widgets?
2 Likes
What is the RDD you are using? If it is the base system one, I wonder what would happen if you created a copy of it and used that one instead?
1 Like
apologies I have had to wait over 20 hours as I am a new user 
(although I have subscribed and paying to support)
However here are the screen shots of the RDD
1 Like
Can yo also check the System Monitor? Any errors there?
1 Like
This is a custom RDD, can you try adding a routing rule on base?
1 Like
Thank you for the advice. The system log shows the errors (see below)
Program Ice.Services.Lib.RunTask when executing task 762825 raised an unexpected exception with the following message: RunTask:
System.InvalidOperationException: A Break node is required in the workflow for this functionality.
I will also try with a routing rule on base see what happens
1 Like
Program Ice.Services.Lib.RunTask when executing task 762830 raised an unexpected exception with the following message: RunTask: System.InvalidOperationException: A Break node is required in the workflow for this functionality. at Ice.Core.RoutingAndBreaking.TableDataRetrieverCache.GetTableDataRetriever(Partition partition, IDataSource dataSource) in C:_releases\ICE\ICE4.3.100.10\Source\Server\Internal\Lib\TaskLib\RoutingAndBreaking\TableDataRetrieverCache.cs:line 105 at Ice.Core.RoutingAndBreaking.TableDataRetrieverCache.<>c__DisplayClass7_0.b__1(IDataSource thisDataSource) in C:_releases\ICE\ICE4.3.100.10\Source\Server\Internal\Lib\TaskLib\RoutingAndBreaking\TableDataRetrieverCache.cs:line 97 at Epicor.Utilities.DictionaryExtensions.GetOrAdd[TKey,TValue](IDictionary
2 dictionary, TKey key, Func2 valueFactory) in C:_releases\ICE\ICE4.3.100.0\Source\Shared\Framework\Epicor.ServiceModel\Utilities\DictionaryExtensions.cs:line 30 at Ice.Core.RoutingAndBreaking.TableDataRetrieverCache.GetCache(Partition partition, IDataSource dataSource) in C:_releases\ICE\ICE4.3.100.10\Source\Server\Internal\Lib\TaskLib\RoutingAndBreaking\TableDataRetrieverCache.cs:line 95 at Ice.Core.RoutingAndBreaking.TableDataRetrieverCache.Get(Partition partition, IDataSource dataSource) in C:_releases\ICE\ICE4.3.100.10\Source\Server\Internal\Lib\TaskLib\RoutingAndBreaking\TableDataRetrieverCache.cs:line 60 at Ice.Core.RoutingAndBreaking.PartitionLinkedMessageItemEvaluatorFactory.<>c__DisplayClass4_0.b__0(IDataSource dataSource, IDataColumn columnName) in C:_releases\ICE\ICE4.3.100.10\Source\Server\Internal\Lib\TaskLib\RoutingAndBreaking\PartitionLinkedMessageItemEvaluatorFactory.cs:line 49 at Ice.Core.RoutingAndBreaking.ColumnsValueEvaluator.GetFirstColumnValue(DataSourceAndColumn dataSourceAndColumn) in C:_releases\ICE\ICE4.3.100.10\Source\Server\Internal\Lib\TaskLib\RoutingAndBreaking\ColumnsValueEvaluator.cs:line 84 at Ice.Core.RoutingAndBreaking.ColumnsValueEvaluator.b__8_0(DataSourceAndColumn dataSourceAndColumn) in C:_releases\ICE\ICE4.3.100.10\Source\Server\Internal\Lib\TaskLib\RoutingAndBreaking\ColumnsValueEvaluator.cs:line 150 at System.Linq.Utilities.<>c__DisplayClass2_03.<CombineSelectors>b__0(TSource x) at System.Linq.Enumerable.SelectListIterator2.ToArray() at Ice.Core.RoutingAndBreaking.ColumnsValueEvaluator.Evaluate(IEnumerable1 dataSourceAndColumns, EvaluatorRowRangeType rowRangeType, String valueSeparator) in C:\_releases\ICE\ICE4.3.100.10\Source\Server\Internal\Lib\TaskLib\RoutingAndBreaking\ColumnsValueEvaluator.cs:line 45 at Ice.Core.RoutingAndBreaking.PartitionLinkedMessageItemEvaluatorFactory.<>c__DisplayClass4_0.<Create>b__2(LinkedMessageItem linkedItem) in C:\_releases\ICE\ICE4.3.100.10\Source\Server\Internal\Lib\TaskLib\RoutingAndBreaking\PartitionLinkedMessageItemEvaluatorFactory.cs:line 57 at Ice.Core.RoutingAndBreaking.LinkedMessageFieldEvaluator.Evaluate(LinkedMessageField field, Func2 linkedMessasgeItemEvaluator) in C:_releases\ICE\ICE4.3.100.10\Source\Server\Internal\Lib\TaskLib\RoutingAndBreaking\LinkedMessageFieldEvaluator.cs:line 30 at Ice.Core.RoutingAndBreaking.EmailReportAction.CreateSettings(ReportInstanceInformation reportInstance, Func2 linkedMessageItemEvaluator) in C:\_releases\ICE\ICE4.3.100.10\Source\Server\Internal\Lib\TaskLib\RoutingAndBreaking\EmailReportAction.cs:line 498 at Ice.Core.RoutingAndBreaking.EmailReportAction.EmailReportsFromReportRequests(RetryChildNodeSettings retrySettings) in C:\_releases\ICE\ICE4.3.100.10\Source\Server\Internal\Lib\TaskLib\RoutingAndBreaking\EmailReportAction.cs:line 318 at Ice.Core.RoutingAndBreaking.EmailReportAction.HandleProcess(Object sender, ProcessEventArgs e) in C:\_releases\ICE\ICE4.3.100.10\Source\Server\Internal\Lib\TaskLib\RoutingAndBreaking\EmailReportAction.cs:line 188 at Ice.Core.RoutingAndBreaking.BaseNode.OnProcess(ProcessEventArgs e) in C:\_releases\ICE\ICE4.3.100.10\Source\Server\Internal\Lib\TaskLib\RoutingAndBreaking\BaseNode.cs:line 193 at Ice.Core.RoutingAndBreaking.BaseNode.HandleProcess(Object sender, ProcessEventArgs e) in C:\_releases\ICE\ICE4.3.100.10\Source\Server\Internal\Lib\TaskLib\RoutingAndBreaking\BaseNode.cs:line 139 at Ice.Core.RoutingAndBreaking.Workflow.OnProcess(ProcessEventArgs e) in C:\_releases\ICE\ICE4.3.100.10\Source\Server\Internal\Lib\TaskLib\RoutingAndBreaking\Workflow.cs:line 330 at Ice.Core.RoutingAndBreaking.Workflow.Run(ReportInstanceInformation reportInstance) in C:\_releases\ICE\ICE4.3.100.10\Source\Server\Internal\Lib\TaskLib\RoutingAndBreaking\Workflow.cs:line 269 at Ice.Core.RptBase.ReportSsrsDatabaseBuilder.RouteAndBreakReport(Func2 executeCommand, Func2 executeReader, SqlObjectsCreated sqlObjectsCreated) in C:\_releases\ICE\ICE4.3.100.10\Source\Server\Internal\Lib\TaskLib\RptBase\ReportSsrsDatabaseBuilder.cs:line 397 at Ice.Core.RptBase.ReportSsrsDatabaseBuilder.ProcessReportWithDataInPlace(Func2 executeCommand, Func2 executeReader, SqlObjectsCreated sqlObjectsCreated) in C:\_releases\ICE\ICE4.3.100.10\Source\Server\Internal\Lib\TaskLib\RptBase\ReportSsrsDatabaseBuilder.cs:line 117 at Ice.Core.RptBase.ReportDatabaseBuilder.ProcessReportWithDataInPlace(SqlConnection connection) in C:\_releases\ICE\ICE4.3.100.10\Source\Server\Internal\Lib\TaskLib\RptBase\ReportDatabaseBuilder.cs:line 135 at Ice.Core.RptBase.ReportDatabaseBuilder.XMLClose() in C:\_releases\ICE\ICE4.3.100.10\Source\Server\Internal\Lib\TaskLib\RptBase\ReportDatabaseBuilder.cs:line 96 at Ice.Core.RptTaskBase1.XMLClose() in C:_releases\ICE\ICE4.3.100.10\Source\Server\Internal\Lib\TaskLib\RptBase\RptTaskBase.cs:line 230 at Erp.Internal.OM.ProFormaInvc.RunProcess(Int64 instanceTaskNum, String outputFileName) in C:_releases\ERP\ERP11.3.100.0\Source\Server\Internal\OM\ProFormaInvc\ProFormaInvc.cs:line 146 at Ice.Core.TaskBase`1.StartProcess(Int64 instanceTaskNum, String outputFileName) in C:_releases\ICE\ICE4.3.100.10\Source\Server\Internal\Lib\TaskLib\TaskBase\TaskBase.cs:line 83 at Ice.Hosting.TaskCaller.InnerExecuteTask(IceDataContext newContext) in C:_releases\ICE\ICE4.3.100.10\Source\Server\Framework\Epicor.Ice\Hosting\TaskCaller\TaskCaller.cs:line 113 at Ice.Hosting.TaskCaller.ExecuteTask() in C:_releases\ICE\ICE4.3.100.10\Source\Server\Framework\Epicor.Ice\Hosting\TaskCaller\TaskCaller.cs:line 61 at Ice.Hosting.TaskCaller.ExecuteTask(IceDataContext dataContext, Boolean suppressTransaction) in C:_releases\ICE\ICE4.3.100.10\Source\Server\Framework\Epicor.Ice\Hosting\TaskCaller\TaskCaller.cs:line 41 at Ice.Services.Lib.RunTaskSvc.<>c__DisplayClass30_2.b__1() in C:_releases\ICE\ICE4.3.100.0\Source\Server\Services\Lib\RunTask\RunTask.cs:line 460 at Ice.Lib.RunTask.BpmFriendlyTaskLauncher.Run(String sessionIdPrefix, IceContext db, Action taskRunner) in C:_releases\ICE\ICE4.3.100.0\Source\Server\Services\Lib\RunTask\BpmFriendlyTaskLauncher.cs:line 57 at Ice.Services.Lib.RunTaskSvc.InnerRunTask(Int64 ipTaskNum, Boolean suppressTransaction) in C:_releases\ICE\ICE4.3.100.0\Source\Server\Services\Lib\RunTask\RunTask.cs:line 457
1 Like
Mr. Simon: It looks to me like you may be missing a Break Node (or it may not be configured correctly)
6 Likes
Thank you so much. Your are quite right I was missing a break Node.
Thanks everyone for all your advice and help. It was greatly received.
4 Likes