Upgraded from 2022.1 to 2023.2 and getting Method errors

Kinetic ERP
1

Hi team,

All of our crystal reports are giving the following error after upgrading from 2022.1 to 2023.2:
Program Ice.Services.Lib.RunTask raised an unexpected exception with the following message: RunTask:
System.MissingMethodException: Method not found: ‘System.String Ice.Tables.SysCompany.get_EmailFromAddr()’.
at Ice.Core.RptBase.TableCache.SysCompanyInformation.FindFirstSysCompany(IceContext context, String companyId)
at Ice.Core.RptBase.TableCache.SysCompanyInformation.<>c__DisplayClass1_0.<.ctor>b__0() in C:_releases\ICE\ICE4.2.100.0\Source\Server\Internal\Lib\TaskLib\RptBase\TableCache\SysCompanyInformation.cs:line 24
at System.Lazy1.ViaFactory(LazyThreadSafetyMode mode) at System.Lazy1.ExecutionAndPublication(LazyHelper executionAndPublication, Boolean useDefaultConstructor)
at System.Lazy1.CreateValue() at Ice.Core.RptBase.TableCache.SysCompanyInformation.GetRow() in C:\_releases\ICE\ICE4.2.100.0\Source\Server\Internal\Lib\TaskLib\RptBase\TableCache\SysCompanyInformation.cs:line 41 at Ice.Core.RptTaskBase1.XMLOpen(String fileName) in C:_releases\ICE\ICE4.2.100.0\Source\Server\Internal\Lib\TaskLib\RptBase\RptTaskBase.cs:line 330
at Erp.Internal.PM.POForm.RunProcess(Int64 instanceTaskNum, String outputFileName) in C:_releases\ERP\ERP11.2.100.0\Source\Server\Internal\PM\POForm\POForm.cs:line 291
at Ice.Core.TaskBase`1.StartProcess(Int64 instanceTaskNum, String outputFileName) in C:_releases\ICE\ICE4.2.100.0\Source\Server\Internal\Lib\TaskLib\TaskBase\TaskBase.cs:line 81
at Ice.Hosting.TaskCaller.InnerExecuteTask(IceDataContext newContext) in C:_releases\ICE\ICE4.2.100.4\Source\Server\Framework\Epicor.Ice\Hosting\TaskCaller\TaskCaller.cs:line 68
at Ice.Hosting.TaskCaller.ExecuteTask() in C:_releases\ICE\ICE4.2.100.4\Source\Server\Framework\Epicor.Ice\Hosting\TaskCaller\TaskCaller.cs:line 59
at Ice.Hosting.TaskCaller.ExecuteTask(IceDataContext dataContext, Boolean suppressTransaction) in C:_releases\ICE\ICE4.2.100.4\Source\Server\Framework\Epicor.Ice\Hosting\TaskCaller\TaskCaller.cs:line 39
at Ice.Services.Lib.RunTaskSvc.<>c__DisplayClass30_1.b__1() in C:_releases\ICE\ICE4.2.100.0\Source\Server\Services\Lib\RunTask\RunTask.cs:line 453
at Ice.Lib.RunTask.BpmFriendlyTaskLauncher.Run(String sessionIdPrefix, IceContext db, Action taskRunner) in C:_releases\ICE\ICE4.2.100.0\Source\Server\Services\Lib\RunTask\BpmFriendlyTaskLauncher.cs:line 57
at Ice.Services.Lib.RunTaskSvc.InnerRunTask(Int64 ipTaskNum, Boolean suppressTransaction) in C:_releases\ICE\ICE4.2.100.0\Source\Server\Services\Lib\RunTask\RunTask.cs:line 450

Has anyone found errors? We tried to modify the data definition of the reports and remove the fields and tables but it still gives the same error.

2

In Release 2022.2 Email options were extended and email values were moved from Ice.SysCompany to a new table - Ice.MailSetting. This work was done under ERP-39433.
In Release 2023.1 the email fields were removed from Ice.SysCompany.

Any reports that reference Email data previously held in the Ice.SysCompany table will need to be adjusted to reference the data from the Ice.MailSetting table.

1 Like
3

Hi Rich,

We saw a post regarding that change and removed the email fields from the reports definitions but still get the same error when trying to generate the report.

Any additional change shoudl be needed? when we dont get the method error then we get an error to run in preview mode.

Thanks for your input.

4

And then we get the same error. I would be like it never received the changes from the data report definition.

Does it need to be refreshed on the server or something?

5

Your error is referencing old assemblies. probably app server was not stopped when you upgraded the version and some files remained locked and was not updated.

1 Like
6

Thank you Olga!!! When i looked into it we found out that the reports folder being shared was still from 2022.1 and not 2023.2, we shared the reports folder from latest version and we could generate the reports!!! thank you!!!

1 Like