Conversion Workbench Failure After Migration from Epicor 10.2.200.12 to Kinetic 11.3.100.11

[nikhil (Nikhil Patwa)]

We recently migrated our Epicor environment from version 10.2.200.12 to Kinetic 11.3.100.11. However, we are encountering a critical issue during the process, specifically with the Conversion Workbench. The conversion tasks are failing, and we are unable to proceed with post-migration activities.

Here are the key details:

Epicor Version Before Migration: 10.2.200.12
Current Version: Kinetic 11.3.100.11
Issue: Conversion Workbench fails to execute the necessary conversion tasks.
Error Details (if any): 

Conversion ID    System Code    Run Sequence    Program    Description    Run Level    Last Run Level    Auto Run    User Run    ReRunable    Program Status    Progress Percent    Last Run On    Run User ID    Conversion Type    System
SetPODetailRcvDtlQtyOption    ERP    1,110    Erp.Internal.Conversion.SetPODetailRcvDtlQtyOption.dll    Set PODetail.QtyOption and RcvDtl.QtyOption to Our when value is blank or invalid.    10.1.500        false    true    true    ERROR    0    10/22/2014        Once    true

Conversion ID    System Code    Run Sequence    Program    Description    Run Level    Last Run Level    Auto Run    User Run    ReRunable    Program Status    Progress Percent    Last Run On    Run User ID    Conversion Type    System
XACreateMESMenuSecurityForMES    ERP    1,350    Erp.Internal.Conversion.XACreateMESMenuSecurityForMES    Create company specific MESMenu and MESMenuSecurity records    10.2.300    11.3.100.11    true    false    false    ERROR    0    9/19/2024    manager    RunLevel    true

Conversion ID    System Code    Run Sequence    Program    Description    Run Level    Last Run Level    Auto Run    User Run    ReRunable    Program Status    Progress Percent    Last Run On    Run User ID    Conversion Type    System
Conversion ID    System Code    Run Sequence    Program    Description    Run Level    Last Run Level    Auto Run    User Run    ReRunable    Program Status    Progress Percent    Last Run On    Run User ID    Conversion Type    System
PMSetVendPartCurrencyCode    ERP    1,130    Erp.Internal.Conversion.PMSetVendPartCurrencyCode.dll    Update existing VendPart.CurrencyCode to match Vendor.CurrencyCode.    10.1.600        false    true    true    ERROR    0    9/19/2016    MANAGER    Once    true

We have tried several attempts to resolve the issue but have been unsuccessful. Could you please assist in identifying the root cause of this failure and guide on how to proceed with a fix?

Looking forward to your response.

[aosemwengie1 (Alisa Osemwengie)]

The first step would be to look at the error message on each of those conversions. You’ve only included the list of conversions that failed without any details.

[hkeric.wci (Haso Keric)]

Make sure you are Security Manager, some of the ERRORs will happen simply because you are not a Security Manager and second as Alisa said you can double click each row with an Error and it should give you more information why it errored.

[sanjeev.gupta]

Hi Alisa,

Thanks for the reply.
I have tried today again the conversion and getting below errors.

Program Ice.Services.Lib.RunTask when executing task 44239659 raised an unexpected exception with the following message: RunTask:
System.Exception: Conversion program ‘XACreateMESMenuSecurityForMES’ has already been run on 19/09/2024 4:23:21 pm.
at Ice.Core.ConversionTaskBase1.PreRunConversion(Int64 instanceTaskNum) in C:\_releases\ICE\ICE4.3.100.11\Source\Server\Internal\Lib\TaskLib\ConversionBase\ConversionTaskBase.cs:line 156 at Ice.Core.ConversionTaskBase1.RunProcess(Int64 instanceTaskNum, String outputFileName) in C:_releases\ICE\ICE4.3.100.11\Source\Server\Internal\Lib\TaskLib\ConversionBase\ConversionTaskBase.cs:line 62
at Ice.Core.TaskBase`1.StartProcess(Int64 instanceTaskNum, String outputFileName) in C:_releases\ICE\ICE4.3.100.11\Source\Server\Internal\Lib\TaskLib\TaskBase\TaskBase.cs:line 83
at Ice.Hosting.TaskCaller.InnerExecuteTask(IceDataContext newContext) in C:_releases\ICE\ICE4.3.100.11\Source\Server\Framework\Epicor.Ice\Hosting\TaskCaller\TaskCaller.cs:line 113
at Ice.Hosting.TaskCaller.ExecuteTask(IceDataContext dataContext, Boolean suppressTransaction) in C:_releases\ICE\ICE4.3.100.11\Source\Server\Framework\Epicor.Ice\Hosting\TaskCaller\TaskCaller.cs:line 47
at Ice.Services.Lib.RunTaskSvc.<>c__DisplayClass30_2.b__1() in C:_releases\ICE\ICE4.3.100.0\Source\Server\Services\Lib\RunTask\RunTask.cs:line 460
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

Program Ice.Services.Lib.RunTask when executing task 44239660 raised an unexpected exception with the following message: RunTask:
System.Exception: Conversion program ‘LibUpgradeAESEncryption’ has already been run on 19/09/2024 4:23:48 pm.
at Ice.Core.ConversionTaskBase1.PreRunConversion(Int64 instanceTaskNum) in C:\_releases\ICE\ICE4.3.100.11\Source\Server\Internal\Lib\TaskLib\ConversionBase\ConversionTaskBase.cs:line 156 at Ice.Core.ConversionTaskBase1.RunProcess(Int64 instanceTaskNum, String outputFileName) in C:_releases\ICE\ICE4.3.100.11\Source\Server\Internal\Lib\TaskLib\ConversionBase\ConversionTaskBase.cs:line 62
at Ice.Core.TaskBase`1.StartProcess(Int64 instanceTaskNum, String outputFileName) in C:_releases\ICE\ICE4.3.100.11\Source\Server\Internal\Lib\TaskLib\TaskBase\TaskBase.cs:line 83
at Ice.Hosting.TaskCaller.InnerExecuteTask(IceDataContext newContext) in C:_releases\ICE\ICE4.3.100.11\Source\Server\Framework\Epicor.Ice\Hosting\TaskCaller\TaskCaller.cs:line 113
at Ice.Hosting.TaskCaller.ExecuteTask(IceDataContext dataContext, Boolean suppressTransaction) in C:_releases\ICE\ICE4.3.100.11\Source\Server\Framework\Epicor.Ice\Hosting\TaskCaller\TaskCaller.cs:line 47
at Ice.Services.Lib.RunTaskSvc.<>c__DisplayClass30_2.b__1() in C:_releases\ICE\ICE4.3.100.0\Source\Server\Services\Lib\RunTask\RunTask.cs:line 460
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

[aosemwengie1 (Alisa Osemwengie)]

Well it says right there that you already ran it. Make sure you are not trying to run everything, it marks the ones you are supposed to run and then you just do run pending conversions.

[hkeric.wci (Haso Keric)]

I would say you can safely ignore that error then if it has already been run.

[sanjeev.gupta]

Hi,

I closed the conversion workbench and login Kinetic then again same form open means conversion workbench

[hkeric.wci (Haso Keric)]

Well in that case you might need to reach out to Support who may have an official workaround or fix. Ive seen this in the past in Epicor 10.

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.

Conversion Workbench error on Create MESMenu Security

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).

[sanjeev.gupta]

Yes I got same solution from here. However, I have already raised the concern to Epicor and waiting for the solution.

[sanjeev.gupta]

Hi,

Same solution provided by Epicor

2024-09-30 22:36:24 -Serge Bosque

Hi Sanjeev,

These conversions are old. On my 2024.1 system, both 1350 and 1580 were last run at 10.2.300.

The message indicates that the conversions have already been run and will not run again, hence the error: Conversion program xxxxxxx has already been run.

If these conversions are preventing you from entering the ERP Main Menu ( meaning the conversion workbench keeps popping up and will not let you in all the way), you can use the following script in SQL to mark the conversions as Complete.

1. Open MSSQL Man Studio
2. Open a New Query window and paste the update script below.
   This is set for conversion 1350. So you’ll also need to do it for 1580.

---

update ice.CnvProgs set ProgStatus=‘COMPLETE’,ProgressPercent=100 where RunSequence=1350
update ice.CnvProgs set autorun = ‘0’ where RunSequence = 1350

3. Ensure you select the appropriate database from the DB name drop-down to the left of the [! Execute button].
4. Execute the script by pressing the [! Execute button].
5. If you have multiple conversions that were not completed, repeat using the script with other numbers as necessary.
6. Once complete, open IIS Manager Console and Recycle the App Pool for the database appserver being worked with.
7. Log back in
8. If the Conversion Workbench reappears after the scripting was used while looking at the Conversion Workbench screen

• Go to the top menu and Select Actions> Run Pending conversions.
• Close and reopen your Client session.
• The ERP Main Menu should appear after that.