Scheduled Tasks send me a error

Kinetic ERP
1

Hi everyone
We migrated to Kinetic 2023.1.25 but now I have some BAQ Reports that are not arriving in the email, since I am getting this error message. Has anyone on the forum seen this error?

Program Ice.Services.Lib.RunTask when executing task 2623365 raised an unexpected exception with the following message: RunTask:
System.InvalidOperationException: No break columns found for Break Action ‘0’.
at Ice.Core.RoutingAndBreaking.WorkflowBuilder.BuildNodesAndLinkToParents(IEnumerable1 parentNodes, WorkflowNode ruleNode, BreakAction breakAction) in C:\_releases\ICE\ICE4.2.300.25\Source\Server\Internal\Lib\TaskLib\RoutingAndBreaking\WorkflowBuilder.cs:line 391 at Ice.Core.RoutingAndBreaking.WorkflowBuilder.BuildNodesAndLinkToParents(IEnumerable1 parentNodes, WorkflowStep ruleNode) in C:_releases\ICE\ICE4.2.300.25\Source\Server\Internal\Lib\TaskLib\RoutingAndBreaking\WorkflowBuilder.cs:line 311
at Ice.Core.RoutingAndBreaking.WorkflowBuilder.BuildDescendantNodesAndLinks(IEnumerable1 parentNodes, WorkflowNode ruleNode) in C:\_releases\ICE\ICE4.2.300.25\Source\Server\Internal\Lib\TaskLib\RoutingAndBreaking\WorkflowBuilder.cs:line 209 at Ice.Core.RoutingAndBreaking.WorkflowBuilder.Build(RuleWorkflowDefinition ruleWorkflow, ReportDefinition reportDefinition, Func2 getRelationshipInformationForParent, Action8 printReport, Func2 getParameterValue, Func2 getBaqConstantValue, Func2 getReportStyleRow, Func1 getSysUserFile, Func1 isProductionEnvironment, Func2 sqlObjectNameBuilder, Func2 executeReader, Action1 partitionSqlViewBuilder, Func2 reportsRenderer, ReportPersister reportPersister, Int64 instanceTaskNum, Boolean enableRetry) in C:_releases\ICE\ICE4.2.300.25\Source\Server\Internal\Lib\TaskLib\RoutingAndBreaking\WorkflowBuilder.cs:line 170
at Ice.Core.RptBase.ReportSsrsDatabaseBuilder.CreateWorkflow(ByteArrayCacheWithTemporaryBackingFile reportCache, Func2 executeCommand, Func2 executeReader, SqlObjectsCreated sqlObjectsCreated) in C:_releases\ICE\ICE4.2.300.25\Source\Server\Internal\Lib\TaskLib\RptBase\ReportSsrsDatabaseBuilder.cs:line 0
at Ice.Core.RptBase.ReportSsrsDatabaseBuilder.RouteAndBreakReport(Func2 executeCommand, Func2 executeReader, SqlObjectsCreated sqlObjectsCreated) in C:_releases\ICE\ICE4.2.300.25\Source\Server\Internal\Lib\TaskLib\RptBase\ReportSsrsDatabaseBuilder.cs:line 395
at Ice.Core.RptBase.ReportDatabaseBuilder.XMLClose() in C:_releases\ICE\ICE4.2.300.25\Source\Server\Internal\Lib\TaskLib\RptBase\ReportDatabaseBuilder.cs:line 93
at Ice.Core.RptTaskBase`1.XMLClose() in C:_releases\ICE\ICE4.2.300.25\Source\Server\Internal\Lib\TaskLib\RptBase\RptTaskBase.cs:line 260
at Ice.Internal.XA.DataBuilders.DatabaseReportDataBuilder.RunReportWithErrorHandling(ReportDatabaseConnectionHelper reportDatabaseConnectionHelper) in C:_releases\ICE\ICE4.2.300.0\Source\Server\Internal\XA\XABaqRpt\DataBuilders\DatabaseReportDataBuilder.cs:line 70
at Ice.Internal.XA.DataBuilders.DatabaseReportDataBuilder.WriteData() in C:_releases\ICE\ICE4.2.300.0\Source\Server\Internal\XA\XABaqRpt\DataBuilders\DatabaseReportDataBuilder.cs:line 46
at Ice.Hosting.TaskCaller.InnerExecuteTask(IceDataContext newContext) in C:_releases\ICE\ICE4.2.300.25\Source\Server\Framework\Epicor.Ice\Hosting\TaskCaller\TaskCaller.cs:line 68
at Ice.Hosting.TaskCaller.ExecuteTask() in C:_releases\ICE\ICE4.2.300.25\Source\Server\Framework\Epicor.Ice\Hosting\TaskCaller\TaskCaller.cs:line 64
at Ice.Lib.RunTask.BpmFriendlyTaskLauncher.Run(String sessionIdPrefix, IceContext db, Action taskRunner) in C:_releases\ICE\ICE4.2.300.0\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.300.0\Source\Server\Services\Lib\RunTask\RunTask.cs:line 450

2

Looks like you need to go and check the Report Style that this report is linked to. Once there, you need the SSRS Report/Breaking Rules. Open the designer, and look at the Break item - you’ll probably find there is no column defined based upon that error.

If it was a custom UD field that you were breaking on, you may also have to check that it is “not excluded” from within the RDD (Report Data Definition) associated with that report style.

1 Like
3

markdamen
I found out that there is no column defined. You’re right

Thanks