10.2 Report Error

Epicor ERP 10
1

Testing 10.2 now and I ran across this when i was trying to run Order Acknowledgement. I have looked in the report style and data definitions and everything looks good. The issue is that the Calc_LineTaxAmt that is being referenced, I cannot find it anywhere; not even in the SSRS report.

Program Ice.Services.Lib.RunTask raised an unexpected exception with the following message: RunTask: Column ‘Calc_LineTaxAmt’ does not belong to table OrderDtl.
Stack Trace:
at System.Data.DataRow.GetDataColumn(String columnName)
at Erp.Internal.OM.SalesOrderAck.SetColumnValues(String tableName, DataRow row) in C:_Releases\ERP\UD10.2.200.13\Source\Server\Internal\OM\SalesOrderAck\SalesOrderAck.cs:line 1714
at Ice.Core.RptBase.ReportRowDataWriter.WriteRow(IRow row) in C:_Releases\ICE\ICE3.2.200.13\Source\Server\Internal\Lib\TaskLib\RptBase\ReportRowDataWriter.cs:line 66
at Erp.Internal.OM.SalesOrderAck.RunProcess(Int64 instanceTaskNum, String outputFileName) in C:_Releases\ERP\UD10.2.200.13\Source\Server\Internal\OM\SalesOrderAck\SalesOrderAck.cs:line 561
at Ice.Hosting.TaskCaller.InnerExecuteTask(IceDataContext newContext) in C:_Releases\ICE\RL3.2.200.0\Source\Framework\Epicor.Ice\Hosting\TaskCaller\TaskCaller.cs:line 98
at Ice.Hosting.TaskCaller.ExecuteTask() in C:_Releases\ICE\RL3.2.200.0\Source\Framework\Epicor.Ice\Hosting\TaskCaller\TaskCaller.cs:line 57
at Ice.Lib.RunTask.BpmFriendlyTaskLauncher.Run(String sessionIdPrefix, IceContext db, Action taskRunner) in C:_Releases\ICE\ICE3.2.200.13\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.200.13\Source\Server\Services\Lib\RunTask\RunTask.cs:line 549calc_lineTaxAmt

2

Are you running the Standard SSRS or Custom SSRS?

For us, Standard SSRS ran successfully, but custom does not. We are trying to go from 10.1.400.32 to 10.2.200.14 and we were told by support that our modified/custom reports will all have to be rewritten.

Exact wording from Support: Mod. RS will have to be rewritten based on the current RS and RDD.

1 Like
3

Oh boy! That is going to be a BIG challenge for me!! We have a bunch of them! But, that is nice to know. We are going from 10.1.400.37 to 10.2.200.13. Crazy, Crazy, Crazy!! Thanks for the heads-up!

4

Just went from 10.1.400.9 to 10.2.200.12 two weeks ago. Its a case by case basis. Some work, others are little tweaks, while others were rewrites. I pulled the usage from SSRS to see what is really used to get a list to focus on. The default is 60 days usage stats in SSRS.

Here is a query to look at that usage.

  WITH Reps
AS 
( 
SELECT	ReportPath, CAST(MAX(TimeEnd) AS smalldatetime) LastRun, AVG(TimeDataRetrieval) AvgTimeDataRetrieval, AVG(TimeProcessing) AvgTimeProcessing, 
		AVG(TimeRendering) AvgTimeRendering, AVG(ByteCount) AvgBytes, AVG([RowCount]) AvgRows, COUNT(*) Runs,
		ROW_NUMBER() OVER (PARTITION BY ReportPath ORDER BY ReportPath) AS RowNumber
FROM	ExecutionLog2 
GROUP BY ReportPath
) 
SELECT	ReportPath, LastRun, AvgTimeDataRetrieval, AvgTimeProcessing, AvgTimeRendering, AvgBytes, AvgRows, Runs
FROM	Reps 
ORDER BY Runs DESC;
1 Like
5

Thanks! Much appreciated!

6

I am not very skilled with SQL so I just copied and pasted the query. Got an eror and not sure what it means.

Msg 208, Level 16, State 1, Line 1
Invalid object name ‘ExecutionLog2’.

7

No problem. You want to run that guy against ReportServer database on the SQL instance where SSRS is hosted.

8

Ah, i was running it against the SSRS database. I was wondering if it was the ReportServer with the way it was written. Thanks!

9

The ExecutionLog2 is a view within that database.

1 Like