Description |
This issue relates to i21 Help Desk ticket. Click the link below to go to Help Desk ticket.
[HDTN-204203 - Upgrade Freedom LIVE and TEST 17.3.1017 Maintenance Build|http://helpdesk.irely.com/iRelyi21live/i21/#/HD/Ticket/?ticket=HDTN-204203]
Failed in database upgrading from 17.3.1013.83 to 17.3.1017.92
Database: testTE
Error SQL72014: .Net SqlClient Data Provider: Msg 207, Level 16, State 1, Procedure uspAPImportVendorTaxExemption, Line 20 Invalid column name 'ssvnd_st'.
Error SQL72045: Script execution error. The executed script:
IF OBJECT_ID('tempdb..##tblOriginMod') IS NOT NULL
DROP TABLE ##tblOriginMod;
GO
IF (SELECT count(\*)
FROM coctlmst) > 1
BEGIN
GOTO MULTIPLE_Rec;
END
IF (SELECT count(\*)
FROM coctlmst) = 0
BEGIN
GOTO NO_Rec;
END
CREATE TABLE ##tblOriginMod (
intModId INT IDENTITY (1, 1),
strDBName NVARCHAR (50) NOT NULL,
strPrefix NVARCHAR (5) NOT NULL UNIQUE,
strName NVARCHAR (30) NOT NULL UNIQUE,
ysnUsed BIT NOT NULL
);
IF EXISTS (SELECT TOP 1 1
FROM INFORMATION_SCHEMA.COLUMNS
WHERE COLUMN_NAME = 'coctl_ag')
BEGIN
EXECUTE ('INSERT INTO ##tblOriginMod (strDBName, strPrefix, strName, ysnUsed) SELECT TOP 1 db_name(), N''AG'', N''AG ACCOUNTING'', CASE ISNULL(coctl_ag, ''N'') WHEN ''Y'' THEN 1 else 0 END FROM coctlmst');
END
IF EXISTS (SELECT TOP 1 1
FROM INFORMATION_SCHEMA.COLUMNS
WHERE COLUMN_NAME = 'coctl_sp_yn')
BEGIN
|