We have almost completed a test upgrade from GP 2013 to 2018. GP is running normally until any VBA code is run. GP is installed on Server 2019 with SQL 2018. We have quite a few customizations in GP2013 using VBA. The project files imported without errors and all VBA code looks normal in the Editor. But GP crashes anytime VBA code is run.
To simplify testing I removed the modified Forms and Reports dictionaries and the Dynamics.vba files. I added a standard (unmodified) GP form and the "New" button on the form to VBA, and created this Sub;
Private Sub New_AfterUserChanged()
The form that I added to VBA works normally until I click the New button which fires the event and runs the Sub. This confirms that the issue is not due to specific code but with the VBA environment.
The Application log shows the following error;
GP01 1026 Error .NET Runtime Application 9/26/2019 9:53:21 AM
Framework Version: v4.0.30319
Description: The process was terminated due to an unhandled exception.
Exception Info: System.AccessViolationException
at <Module>.TNT_new_event_loop(Int16 (HWND__*, EVENT*, Int16*), Int16, Int16)
Searching the error found this post; https://community.dynamics.com/gp/f/microsoft-dynamics-gp-forum/110463/gp-2013-intermittent-crash/239914
A reply in the thread included 7 possible causes and resolutions but none of them resolved our issue.#VBA #Upgrade
If you've found this thread useful, dive deeper into User Group community content by role