Conversion Workbench error on Create MESMenu Security

I am currently upgrading one of our environments from ERP10.2.100.12 to ERP10.2.400.3 and am encountering one error that will not allow me to move forward in the upgrade.

In the conversion workbench I am getting the following:
Program: “Erp.Internal.Conversion.XACreateMESMenuSecurityForMES”
Description: “Create company specific MESMenu and MESMenuSecurity records”

Does anyone have an idea on how to get passed this error?

Yes, after you upgrade you have to Initialize per Company the MES and HandHeld Securities.

Just run Handheld / MES Menu Security Maintenance from System Setup/Security Maintenance or find it via Menu Search.

Once you run it the first time per Company it will prompt you to Initialize Default Securities, just click yes and you are done.

I couldn’t get the Conversion Workbench one to work either, I just did it manually, like stated above. Also that conversion is new, it didnt exist in 10.2.300.13, so perhaps a bit buggy.

1 Like

Unfortunately, I cannot get passed the conversion workbench to get to the menus

So if you close Conversion Workbench, Exit out of Epicor and run Epicor again, it doesn’t land you on the Main Menu?

Unfortunately not

Well in that case you might need to reach out to Support who may have an official workaround or fix.

In the past when I break the Conversion WorkBench I use SQL and UPDATE the Conversion thats stuck on the Ice.CnvProgs table, simply marking it as ProgStatus = ‘COMPLETE’ - or - blank so I can run it again. But that’s me, don’t want to encourage SQL Updates, not knowing your technical skillset. For example if I accidently click Run Pending Conversions twice, stuff gets stuck. forever. Then when I restart Epicor it sees that there are no Pending ones, it takes me to the Main Menu.

I do have a call with support and waiting. I did contemplate updating the table with a complete, but without knowing the impact, I am awaiting to see if they can provide a fix.

I have tried rerunning that specific sequence 1350, and it gives me the following:

“Program Ice.Services.Lib.RunTask raised an unexpected exception with the following message: RunTask: Conversion program ‘XACreateMESMenuSecurityForMES’ has already been run on 5/31/2019 1:56:58 PM.
Stack Trace:
at Ice.Core.ConversionTaskBase1.preRunConversion(Int64 instanceTaskNum) in C:\_Releases\ICE\ICE3.2.400.3\Source\Server\Internal\Lib\TaskLib\ConversionBase\ConversionTaskBase.cs:line 143 at Ice.Core.ConversionTaskBase1.RunProcess(Int64 instanceTaskNum, String outputFileName) in C:_Releases\ICE\ICE3.2.400.3\Source\Server\Internal\Lib\TaskLib\ConversionBase\ConversionTaskBase.cs:line 65
at Ice.Core.TaskBase`1.StartProcess(Int64 instanceTaskNum, String outputFileName) in C:_Releases\ICE\ICE3.2.400.3\Source\Server\Internal\Lib\TaskLib\TaskBase\TaskBase.cs:line 47
at Ice.Hosting.TaskCaller.InnerExecuteTask(IceDataContext newContext) in C:_Releases\ICE\ICE3.2.400.3\Source\Framework\Epicor.Ice\Hosting\TaskCaller\TaskCaller.cs:line 98
at Ice.Hosting.TaskCaller.ExecuteTask(IceDataContext dataContext, Boolean suppressTransaction) in C:_Releases\ICE\ICE3.2.400.3\Source\Framework\Epicor.Ice\Hosting\TaskCaller\TaskCaller.cs:line 43
at Ice.Lib.RunTask.BpmFriendlyTaskLauncher.Run(String sessionIdPrefix, IceContext db, Action taskRunner) in C:_Releases\ICE\ICE3.2.400.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.400.0\Source\Server\Services\Lib\RunTask\RunTask.cs:line 592”

You can only via SQL - Change the ProgStatus to Blank and the LastRunOn to null and the RunUserID to Blank and it should let you run it again.

I will try it out

If I recall that Conversion Program basically Initializes these tables for you:

SELECT * FROM Erp.MESMenu;
SELECT * FROM Erp.MESMenuSecurity;

I remember me saying to our IT Analyst “Would be nice if they had a conversion to do it for you” when we went to 10.2.300 and had to manually Initialize it per Company which can be time consuming when you have 14+

Ok, sounds good

Have have a test environment and this exact issue occurred, any solution to this? Epicor actually help?

As said by Hasokeric I was able to “complete” it on the table but would be nice if I could fix conversion. I could open a ticket with Epicor but feel they would tell me there is some customization on a mes screen so they will not support it (although we do not have many customization).

Even I had same error. Executed the below query in SQL
.
update Ice.CnvProgs
set ProgStatus=‘ERROR’,
AutoRun=0,
UserRun=0,
ReCoverable=0,
ReRunable=1,
LastRunOn=NULL,
ConversionType=‘Once’
where
RunSequence =1350.

Thanks! I see it updates the table but what exactly does this do? I will try this the next test upgrade I do which might be a week or 2.

If it states complete with errors and shows in the error that it was already run. you need to run the following:
update ice.CnvProgs set ProgStatus=‘COMPLETE’,ProgressPercent=100 where RunSequence=1350

update ice.CnvProgs set autorun = ‘0’ where RunSequence = 1350

1 Like