/
Upgrading from an earlier version to Jiwa 7.00.175 or 7.01.00 may error with a DB_Notes issue on script 34114
Upgrading from an earlier version to Jiwa 7.00.175 or 7.01.00 may error with a DB_Notes issue on script 34114
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]
Related articles
, multiple selections available,
Related content
Jiwa 7.00.175.00 Service Release 4
Jiwa 7.00.175.00 Service Release 4
More like this
Opening Debtor System Template form after update may error with "Could not load file or assembly 'JiwaApplication, Version=7.1.0.0"
Opening Debtor System Template form after update may error with "Could not load file or assembly 'JiwaApplication, Version=7.1.0.0"
More like this
Error performing a yearly roll-over in a Azure 7.00.157 database 'Master.dbo.SysProcess .. is not supported in this version of SQL'
Error performing a yearly roll-over in a Azure 7.00.157 database 'Master.dbo.SysProcess .. is not supported in this version of SQL'
More like this
Activating a transaction reports an error - '...unable to insert into GL_Ledger ...'
Activating a transaction reports an error - '...unable to insert into GL_Ledger ...'
More like this
Scrolling debtor records errors "The value property .....'MinValue' and MaxValue' ....'
Scrolling debtor records errors "The value property .....'MinValue' and MaxValue' ....'
More like this
Error when loading sales orders - Key not found. Drill to Source Order'
Error when loading sales orders - Key not found. Drill to Source Order'
More like this