Opening Debtor System Template form after update may error with "Could not load file or assembly 'JiwaApplication, Version=7.1.0.0"

Owned by Beth Blok (Unlicensed)
Feb 17, 2022
1 min read

Problem

Loading the Debtor System Template form in a newly upgraded database could error.

Solution

The upgrade process (post 7.02.01) now correctly updates the Jiwa references in the DB_DebtorSystemTemplateReference.

The work-around is to run this script after upgrade if the error occurs:



UPDATE DB_DebtorSystemTemplateReference SET AssemblyFullName = SUBSTRING(AssemblyFullName, 0, PATINDEX('%,%', AssemblyFullName)) + ', Version=7.2.1.0, Culture=neutral, PublicKeyToken=e30ce81e37f29c8c' WHERE (AssemblyFullName LIKE 'Jiwa%' OR AssemblyFullName LIKE 'LumenWorks%')