Sage 200 Update - Failed to run SQL script

Question

Hello all, 
 Whilst trying to update Sage 200, I'm getting the following error message: Failed to run SQL script 'Sage.Manufacturing.Database.Sql.UpdateScripts.16000200.sql' against company dataset. 
 Has anyone come across this before? Or any ideas hope I can find out what that SQL script is trying to update? 
 Thanks 
 James

Steven Holden · Accepted Answer

Hi, 
 
If that is so then it has been seen where the WopIssue table is missing the ReservedQuantity column. The following script can be ran to resolve this. As ever run this against a copy of the database in a secure vanilla environment:

IF NOT EXISTS(SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'WOPIssue' AND COLUMN_NAME = 'ReversedQuantity') 
 
BEGIN 
 
-- TODO: Default Value 
 
exec('ALTER TABLE [dbo].WopIssue ADD ReversedQuantity StockQuantity null') 
 
exec('UPDATE [dbo].WopIssue SET ReversedQuantity = 0') 
 
exec('ALTER TABLE [dbo].WopIssue ALTER COLUMN ReversedQuantity StockQuantity NOT NULL') 
 
End 
 
GO 
 
Regards

Sage 200 UKI

Sage 200 Update - Failed to run SQL script

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING