AR Invoices not printing after updating to 2024.1.10

Kinetic ERP
1

After the cloud update to 2024.1.10 our AR invoices will no longer print. We tested before the update and it worked (and still works in Pilot)

Has anyone else run into this?

I’ve created a ticket but do not expect action for some time from support.

Other reports are working, including some customized reports.

Program Ice.Services.Lib.RunTask when executing task 800906 raised an unexpected exception with the following message: RunTask:
System.MissingMethodException: Method not found: 'System.Func4<!!0,!!1,!!2,!!3> Epicor.Data.DBExpressionCompiler.Compile(System.Linq.Expressions.Expression1<System.Func4<!!0,!!1,!!2,!!3>>, Epicor.Data.Cache, Boolean)'. at Extensibility.CSF.Canada.ARInvFormExtension.RealPartLinesCount(ErpContext context, String company, Int32 invoiceNum) at Extensibility.CSF.Canada.ARInvFormExtension.XMLDumpTable(Object reportTask, IRow row, String rptTableId) at ConcreteClass257.XMLDumpTable(Object, IRow, String) at Ice.Core.RptTaskBase1.XMLDumpTable(IRow row, String rptTableId) in C:_releases\ICE\ICE4.3.100.10\Source\Server\Internal\Lib\TaskLib\RptBase\RptTaskBase.cs:line 269
at Erp.Internal.AR.ARInvForm.RunProcess(Int64 instanceTaskNum, String outputFileName) in C:_releases\ERP\ERP11.3.100.0\Source\Server\Internal\AR\ARInvForm\ARInvForm.cs:line 893
at Ice.Hosting.TaskCaller.InnerExecuteTask(IceDataContext newContext) in C:_releases\ICE\ICE4.3.100.10\Source\Server\Framework\Epicor.Ice\Hosting\TaskCaller\TaskCaller.cs:line 70
at Ice.Hosting.TaskCaller.ExecuteTask() in C:_releases\ICE\ICE4.3.100.10\Source\Server\Framework\Epicor.Ice\Hosting\TaskCaller\TaskCaller.cs:line 61
at Ice.Lib.RunTask.BpmFriendlyTaskLauncher.Run(String sessionIdPrefix, IceContext db, Action taskRunner) in C:_releases\ICE\ICE4.3.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.3.100.0\Source\Server\Services\Lib\RunTask\RunTask.cs:line 457

1 Like
2

We are US so I cant help out. Just out of curiosity, did your Pilot go from 2023.2.11 to 2024.1.3 to 2024.1.5 to 2024.1.8 to 2024.1.10 and
Production from 2023.2.11 to 2024.1.10 ?

That was our upgrade path and some random glitches are happening in production…wondering if things addressed in previous releases didn’t make the final conversion…??

Dean

1 Like
3

This looks correct. A good point, there could be something wrong with the CSF.

Also getting errors when trying to create menu items for new dashboards.

Our Pilot and Live versions are now the same so wondering why the vanilla report works in one and not the other. Find it hard to believe they didn’t try to print a stock AR report. There is no reason it should be erroring out but it wouldn’t be the first time a feature that has always worked just blows up immediately after an update.

We tested this thoroughly with our test plan and I just went back to pilot and the report prints fine…

4

I have a work around for the dashboard issue. If you create the menu option and save you cannot change the dashboard, so if it wasnt deployed or you picked the wrong name you are SOL.

In short when creating the menu item fill in the dashboard then save. Annoying. The error message states that you can only change the program for UD items - which these are, it is set to UD when you create the menu option.

5

Make sure CSF Canada was installed. It seems like the report is somehow missing, could be the RDL file or the data definition.

6

Thank you. That will be Epicors job to fix. We are in the cloud. That custom version of the report has been up and working since 2020. The RDD is there, I can verify that. The vanilla version is not working either. Is there somewhere I can look?

I checked the style and it said missing RDL. I clicked the button that said Missing RDL and it changed to OK. It still doesnt work though

They messed up. My thought is that if you are going to push an update it had better work. If the update is going to be months late it had really better work. We did a huge amount of testing on our end. Epicor updates are an expensive business for their customers.

1 Like
7

They will be applying hotfixes to correct their change. They are asking that we shut down production for 30 minutes. This is problematic as we are almost 24-7. We will be scheduling a time.

They let us know that the hotfixes had been applied to Pilot but not to Live.
Weirder and weirder. I have so many questions.

8

From the last communication the issue seemed to be that Live got a hotfix that Pilot did not and that may have been the issue.

They contacted me in the evening to test and the AR invoice report is now working.

I’ve asked for clarification on to what happened and am testing our most commonly used reports. They have all worked.

1 Like
9

They fixed it on their end on the 27th. I’ve asked for clarity on what happened. If they respond I will put it here.

They said a user changed a UD column on the ARForm.

As none of the tables on the report have UD columns and this was affecting the vanilla style from Epicor I am skeptical. The same report works in Pilot and there are no outstanding regenerations to be done in either environment. However, they closed the case before I could ask questions so I am unlikely to find out anything.

3 Likes
10

I just refreshed our 2024.1 dev database (on prem) and I can’t connect the app server to the DB. I received a similar error:

System.MissingMethodException: Method not found: 'System.Func`3<!!0,!!1,!!2> Epicor.Data.DBExpressionCompiler.Compile(System.Linq.Expressions.Expression`1<System.Func`3<!!0,!!1,!!2>>, Epicor.Data.Cache, Boolean)'.
   at Epicor.ServiceModel.Channels.ImplBase.CallWithCommunicationFailureRetry(String methodName, ProxyValuesIn valuesIn, ProxyValuesOut valuesOut, RestRpcValueSerializer serializer)
   at Epicor.ServiceModel.Channels.ImplBase.CallWithMultistepBpmHandling(String methodName, ProxyValuesIn valuesIn, ProxyValuesOut valuesOut, Boolean useSparseCopy)
   at Epicor.ServiceModel.Channels.ImplBase.Call(String methodName, ProxyValuesIn valuesIn, ProxyValuesOut valuesOut, Boolean useSparseCopy)
   at Ice.Proxy.BO.UserFileImpl.IsPasswordExpired(String userID, Int32& graceCount)
   at Epicor.Mfg.Administration.ServerManagement.ApplicationServerManager.Forms.NewSessionForm.BackgroundWorker_DoWork(Object sender, DoWorkEventArgs e)
   at System.ComponentModel.BackgroundWorker.OnDoWork(DoWorkEventArgs e)
   at System.ComponentModel.BackgroundWorker.WorkerThreadStart(Object argument)

I guess I’ll patch up to a higher update and see what happens. (It’s 2024.1.9 right now). I was hoping for a root cause in this thread. Rats.

11

I can help a little. When you make your case for Epicor feel free to reference our case number. They can look at their internal notes and that may help you!

CS0004520532

1 Like
12

I patched to 2024.1.13 and it’s connected now.

Maybe unrelated, and a total fluke. But anyway, it’s working for me.

13

That is fantastic Jason! We are on the cloud so had to wait until the Support Team was able to hotfix it. Weird it did not happen in Pilot which has the same SSRS reports, forms, UD columns etc.

14

Well, I better test the invoice reports now! I just got past connecting to the DB.

1 Like