Report Error after Upgrading to 10.2.700

[arthureynoso (Arturo)]

Hi there,

As I mentioned in other post, we are upgrading from 10.2.500 to 700 as some of you said it was most like transparent, but we still testing the 700 on our pilot environment, and one issue I got now is in AR Form Report, yes I’m trying to print a simple invoice. and I have no report coming but I have this error in the System Monitor.

Program Ice.Services.Lib.RunTask raised an unexpected exception with the following message: RunTask: System.ArgumentException: Column 'Calc_TotalAdvBillCred' does not belong to table InvcHead. at System.Data.DataRow.GetDataColumn(String columnName) at System.Data.DataRow.set_Item(String columnName, Object value) at Erp.Internal.AR.ARInvForm.SetColumnValues(String tableName, DataRow row) in C:\_releases\ERP\ERP10.2.700.22\Source\Server\Internal\AR\ARInvForm\ARInvForm.cs:line 5318 at Ice.Core.RptTaskBase`1.RunSetColumnValuesProcess(String tableName, DataRow row) in C:\_Releases\ICE\ICE3.2.700.0\Source\Server\Internal\Lib\TaskLib\RptBase\RptTaskBase.cs:line 212 at Ice.Core.RptBase.ReportRowDataWriter.WriteRow(IRow row) in C:\_Releases\ICE\ICE3.2.700.0\Source\Server\Internal\Lib\TaskLib\RptBase\ReportRowDataWriter.cs:line 65 at Erp.Internal.AR.ARInvForm.RunProcess(Int64 instanceTaskNum, String outputFileName) in C:\_releases\ERP\ERP10.2.700.22\Source\Server\Internal\AR\ARInvForm\ARInvForm.cs:line 1377 at Ice.Core.TaskBase`1.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.22\Source\Framework\Epicor.Ice\Hosting\TaskCaller\TaskCaller.cs:line 117 at Ice.Hosting.TaskCaller.ExecuteTask() in C:\_releases\ICE\ICE3.2.700.22\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 was looking at the report defiinition and I also reviewed the SSRS report looking for some ‘Calc_TotalAdvBillCred’, but I could’nt find anything.

Could you guys give an advice where else to look?
Our report is a copy of the original ARForm so we add a logo and modified the format. And I believed people from epicor made that custom report.

Thanks for your help

[aarong (Aaron Gulley)]

This is quite common. You want to look into the RDD file and see if you can locate Calc_TotalAdvBillCred

If your form was previously customised the upgrade would of broke that.

[Doug.C (Doug Crabtree)]

We had similar things happen in the past:

SSRS Reports from 10.2.500

We tested all of the custom reports when we tested the upgrade. We had to go into some of the RDDs and define those fields so the custom reports would work again. Look at the stock ARForm and look for the calculated field: TotAdvBillingAmount Create that same field in your RDD for your custom report.

Like @aarong said, you’ll need to go into the Report Data Definition and add the field to the Calculated fields.

[arthureynoso (Arturo)]

Thanks for your suggestions I did that and save the RDD but still have the error.
I wonder if I have to Sync Dataset on the Report Style. I did that and I had this error

[aarong (Aaron Gulley)]

[cfinley (Chance Finley)]

My favorite chrome extension

[MLamkin (Marjorie Lamkin)]

We had ARForm and OrderAck RDDs break for us doing the upgrade from 10.2.400 to 10.2.700. What we found was the Ice.RptCalcField table contained some records in the new RDD that didn’t exist in our copies. Copying those records into the copied RDDs fixed it. (just change RptDefID to the name of the copy) fixed the issue.