Debtor System Template form will not load where there are no templates in a 7.02.01 database

Owned by Beth Blok (Unlicensed)
Jul 30, 2020
1 min read

Problem

In 7.02.01 databases where there are no Debtor System Templates loading the Debtor System Template to create a new template errors.

Solution

SQL Management skills required

A working knowledge of SQL Management Studio is required to complete this task.



The issue will be addressed in the next full release of Jiwa Financials after 7.02.01.  In the interim, run the following script over the 7.02.01 database to allow the form to load and new templates to be created

DELETE FROM DB_DebtorSystemTemplateDefaultReference WHERE AssemblyFullName LIKE '%JiwaDBSysTemplate%'
DELETE FROM DB_DebtorSystemTemplateDefaultReference WHERE AssemblyFullName LIKE '%JiwaDBSysTemplateUI%'

GO

DELETE FROM DB_DebtorSystemTemplateReference WHERE AssemblyFullName LIKE '%JiwaDBSysTemplate%'
DELETE FROM DB_DebtorSystemTemplateReference WHERE AssemblyFullName LIKE '%JiwaDBSysTemplateUI%'

GO