SSRS Relationship Error

Epicor ERP 10
,
1

Have one order we are running for SO Pick List and we are getting this error:

Program Ice.Services.Lib.RunTask raised an unexpected exception with the following message: RunTask:
System.InvalidOperationException: The data source column type ‘Ice.Core.RptBase.GeneratedDataColumn’ in the ‘WhseBin.Calc_OrderLine’ data source is not supported for relationships.
at Ice.Core.RptBase.RelatedDataSqlBuilder.BuildCriteriaForKeys(DataColumnCollection keyColumns) in C:_Releases\ICE\ICE3.2.700.0\Source\Server\Internal\Lib\TaskLib\RptBase\RelatedDataSqlBuilder.cs:line 65
at Ice.Core.RptBase.OutputRelationDataWriter.WriteTable(DataSourceRelationship relationship, IDataSource relatedTable, DataColumnCollection keyColumns, UniqueKeyCollection keyValues) in C:_Releases\ICE\ICE3.2.700.0\Source\Server\Internal\Lib\TaskLib\RptBase\OutputRelationDataWriter.cs:line 189
at Ice.Core.RptBase.OutputRelationDataWriter.WriteTables() in C:_Releases\ICE\ICE3.2.700.0\Source\Server\Internal\Lib\TaskLib\RptBase\OutputRelationDataWriter.cs:line 44
at Ice.Core.RptBase.ReportDataBuilderBase.XMLClose() in C:_Releases\ICE\ICE3.2.700.0\Source\Server\Internal\Lib\TaskLib\RptBase\ReportDataBuilderBase.cs:line 226
at Ice.Core.RptBase.ReportDatabaseBuilder.XMLClose() in C:_Releases\ICE\ICE3.2.700.0\Source\Server\Internal\Lib\TaskLib\RptBase\ReportDatabaseBuilder.cs:line 91
at Ice.Core.RptTaskBase1.XMLClose() in C:\_Releases\ICE\ICE3.2.700.0\Source\Server\Internal\Lib\TaskLib\RptBase\RptTaskBase.cs:line 229 at Ice.Core.TaskBase1.StartProcess(Int64 instanceTaskNum, String outputFileName) in C:_Releases\ICE\ICE3.2.700.0\Source\Server\Internal\Lib\TaskLib\TaskBase\TaskBase.cs:line 83
at Ice.Hosting.TaskCaller.InnerExecuteTask(IceDataContext newContext) in C:_releases\ICE\ICE3.2.700.11\Source\Framework\Epicor.Ice\Hosting\TaskCaller\TaskCaller.cs:line 117
at Ice.Hosting.TaskCaller.ExecuteTask() in C:_releases\ICE\ICE3.2.700.11\Source\Framework\Epicor.Ice\Hosting\TaskCaller\TaskCaller.cs:line 59
at Ice.Lib.RunTask.BpmFriendlyTaskLauncher.Run(String sessionIdPrefix, IceContext db, Action taskRunner) in C:_Releases\ICE\ICE3.2.700.0\Source\Server\Services\Lib\RunTask\BpmFriendlyTaskLauncher.cs:line 63
at Ice.Services.Lib.RunTaskSvc.InnerRunTask(Int64 ipTaskNum, Boolean suppressTransaction) in C:_Releases\ICE\ICE3.2.700.0\Source\Server\Services\Lib\RunTask\RunTask.cs:line 454

I checked the RDD and everything seems to be setup for proper relationships. And, this is the only order that is doing this. So, was curious on what others thought and on the Calc portion. How can I get a peak at that info?

image
image1308×649 32.3 KB

2

What information are you trying to get? I ask because it may already be there in the Linked Tables.

3

The calc_OrderLine in the pic above.

4

Why did you change the Relation Type to Output? The base report is already outputting the data when it is run.

5

That was prior tome, so I do not know why he did that. Thing is, only this one order isn’t running. All the others do. So, I was thinking something in the Calc_OrderLine. Do you think the output is more likely?

6

Not sure what is going on and that report seems to be a monster to unravel. Sorry I cannot be more help.

1 Like