10.2.700 Upgrade - Broke Some Standard SSRS reports (but works in a second, similar test environment)

Epicor ERP 10
,
1

We’re testing our 10.2.500.9 -> 10.2.700.6 upgrade, and have several Standard-SSRS reports that don’t work in one environment, but do in another!

We upgraded our PILOT and End-Of-Year databases to have two test environments. These reports don’t work in PILOT, but do in EOY! As far as I can tell, they both went through the same upgrade process (but EOY didn’t get the customizations and BPM’s validated yet…). The other 30 or so reports we’ve tested do work in PILOT.

Both environments are on the the same App and DB server.

Our GoLive is scheduled for 2.12.21, so just 3 weeks left. I’ve got 3 cases in Epicor that are 1-2 weeks old, with our database uploaded.

This makes me very concerned if upgrading created 2 environments that behave differently, and one doesn’t work consistently.

Ideas on where we should dig next?

Here are the errors:

  • Sales Order Entry Proforma Invoice: Key cannot be null
  • AP Edit List Column ‘Calc_WithholdAcctToInterim’ does not belong to table APTran. (APTran isn’t even in the the RDD)
  • Count Variance Report Error - Column ‘Calc_AttributeSetShortDescription’ does not belong to table CCDtl

Sales Order Entry Proforma Invoice:

Program Ice.Services.Lib.RunTask raised an unexpected exception with the following message: RunTask:
System.ArgumentNullException: Value cannot be null.
Parameter name: key
at System.ThrowHelper.ThrowArgumentNullException(ExceptionArgument argument)
at System.Collections.Generic.Dictionary`2.FindEntry(TKey key)
at System.Collections.Generic.Dictionary`2.TryGetValue(TKey key, TValue& value)
at Epicor.Utilities.DictionaryExtensions.GetOrAdd[TKey,TValue](IDictionary`2 dictionary, TKey key, Func`2 valueFactory) in C:\_releases\ICE\ICE3.2.700.6\Source\Shared\Framework\Epicor.ServiceModel\Utilities\DictionaryExtensions.cs:line 24
at Ice.Core.RptBase.ReportDataBuilderBase.XMLDumpTable(IRow row, String rptTableId) in C:\_Releases\ICE\ICE3.2.700.0\Source\Server\Internal\Lib\TaskLib\RptBase\ReportDataBuilderBase.cs:line 333
at Erp.Internal.OM.ProFormaInvc.DoOrderDetails() in C:\_releases\ERP\ERP10.2.700.6\Source\Server\Internal\OM\ProFormaInvc\ProFormaInvc.cs:line 351
at Erp.Internal.OM.ProFormaInvc.doOrderHedCalc() in C:\_releases\ERP\ERP10.2.700.6\Source\Server\Internal\OM\ProFormaInvc\ProFormaInvc.cs:line 513
at Erp.Internal.OM.ProFormaInvc.RunProcess(Int64 instanceTaskNum, String outputFileName) in C:\_releases\ERP\ERP10.2.700.6\Source\Server\Internal\OM\ProFormaInvc\ProFormaInvc.cs:line 137
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.6\Source\Framework\Epicor.Ice\Hosting\TaskCaller\TaskCaller.cs:line 117
at Ice.Hosting.TaskCaller.ExecuteTask() in C:\_releases\ICE\ICE3.2.700.6\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

AP Edit List missing Calc field in APTrans table (which isn’t even in the the RDD):

Program Ice.Services.Lib.RunTask raised an unexpected exception with the following message: RunTask:
System.ArgumentException: Column 'Calc_WithholdAcctToInterim' does not belong to table APTran.
at System.Data.DataRow.GetDataColumn(String columnName)
at Erp.Internal.AP.APR20.SetColumnValues(String tableName, DataRow row) in C:\_releases\ERP\ERP10.2.700.0\Source\Server\Internal\AP\APR20\APR20.cs:line 413
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.AP.APR20.PrintReport() in C:\_releases\ERP\ERP10.2.700.0\Source\Server\Internal\AP\APR20\APR20.cs:line 322
at Erp.Internal.AP.APR20.RunProcess(Int64 instanceTaskNum, String outputFileName) in C:\_releases\ERP\ERP10.2.700.0\Source\Server\Internal\AP\APR20\APR20.cs:line 224
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.6\Source\Framework\Epicor.Ice\Hosting\TaskCaller\TaskCaller.cs:line 117
at Ice.Hosting.TaskCaller.ExecuteTask() in C:\_releases\ICE\ICE3.2.700.6\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

Count Variance Report Error - Column ‘Calc_AttributeSetShortDescription’ does not belong to table CCDtl

Program Ice.Services.Lib.RunTask raised an unexpected exception with the following message: RunTask:
System.ArgumentException: Column 'Calc_AttributeSetShortDescription' does not belong to table CCDtl.
at System.Data.DataRow.GetDataColumn(String columnName)
at Erp.Internal.IM.LogicCCVarianceCalc.SetColumnValues(String tableName, DataRow row) in C:\_releases\ERP\ERP10.2.700.0\Source\Server\Internal\IM\LogicCCVarianceCalc\LogicCCVarianceCalc.cs:line 933
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.IM.LogicCCVarianceCalc.ProcessRecords() in C:\_releases\ERP\ERP10.2.700.0\Source\Server\Internal\IM\LogicCCVarianceCalc\LogicCCVarianceCalc.cs:line 693
at Erp.Internal.IM.LogicCCVarianceCalc.RunProcess(Int64 instanceTaskNum, String outputFileName) in C:\_releases\ERP\ERP10.2.700.0\Source\Server\Internal\IM\LogicCCVarianceCalc\LogicCCVarianceCalc.cs:line 412
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.6\Source\Framework\Epicor.Ice\Hosting\TaskCaller\TaskCaller.cs:line 117
at Ice.Hosting.TaskCaller.ExecuteTask() in C:\_releases\ICE\ICE3.2.700.6\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
2

Did you use the SSRS migration tool? Is the Shared Data Source remapped?

3

After you restored Pilot did you Regenerate and recycle before you did the upgrade?

4

Our reporting manager used the Solutions Workbench to move the reports and yes the Shared Data Source has been remapped. He states that neither of those things have anything to do with the standard reports, though.

Yes & Yes.

We’re going to try running the Solutions Workbench from EOY and import that into PILOT as a custom report.

5

Ok. I usually use the migration tool to make sure my test reports match the live. The Solutions workbench should work too.

The shared data source does matter for standard reports. There have been times when I didn’t update it and no reports would work because it was looking to the wrong Report Database.

6

Solutions workbench…did you review the log closely, were there any errors? In the past I’ve needed to import the same solution twice as some of the dependencies get out our wack. I think it was related to was ud columns, but never really got to the bottom of it…

7

Thanks, guys.

Doug, I’ll find out about the shared data source.

Hally- Would the solutions workbench apply or be needed for the out of the box Standard SSRS
report style?

8

For standard reports it should not, however if you have custom reports that point to the standard RDDs you might get into trouble, someone correct me here, but if a standard report is changed over versions then the data in the default RDD might get altered, which may in turn break your report.

It has always been a bit of a black box to me what happens between you click on the submit button on the report to when the data arrives in the reports database tables.