Upgrading from an earlier version to Jiwa 7.00.175 or 7.01.00 may error with a DB_Notes issue on script 34114

Owned by Beth Blok (Unlicensed)

Last updated: Oct 20, 2017

1 min read

Problem

Upgrading from 6.5.13 or a version earlier than 7.0.175 may error on script 34114 when upgrading to 7.00.175 or 7.01.00

Solution

SQL skills are required

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

Run the following script to correct the data

ALTER TABLE [dbo].[DB_Notes] DROP CONSTRAINT [FK_DB_Notes_DebtorID]