Error on SQL Script Release

Issue No: RM-2763
Created 3/28/2019 9:56:20 PM
Type Bug-QC
Priority Blocker
Status Closed
Resolution Fixed
Fixed Version 19.1
Description 2019-03-29T01:46:08.5609571Z ---> (Inner Exception #37) System.Management.Automation.RemoteException: SqlClient Data Provider: Msg 207, Level 16, State 1, Procedure uspRKAutoHedge, Line 102 Invalid column name 'intSelectedInstrumentTypeId'. 2019-03-29T01:46:08.5610216Z Error SQL72045: Script execution error. The executed script: 2019-03-29T01:46:08.5612021Z ALTER PROCEDURE uspRKAutoHedge 2019-03-29T01:46:08.5612835Z @XML NVARCHAR (MAX), @intFutOptTransactionId INT OUTPUT 2019-03-29T01:46:08.5613480Z AS 2019-03-29T01:46:08.5614104Z BEGIN TRY 2019-03-29T01:46:08.5614822Z DECLARE @dtmTransactionDate AS DATETIME, @intEntityId AS INT, @intBrokerageAccountId AS INT, @intFutureMarketId AS INT, @intFutureMonthId AS INT, @intInstrumentTypeId AS INT, @intCommodityId AS INT, @intLocationId AS INT, @intTraderId AS INT, @strInternalTradeNo AS NVARCHAR (10), @strBrokerTradeNo AS NVARCHAR (50), @strBuySell AS NVARCHAR (10), @dblNoOfContract AS NUMERIC (18, 6), @dblPrice AS NUMERIC (18, 6), @strStatus AS NVARCHAR (50), @dtmFilledDate<--- 2019-03-29T01:46:08.5615691Z 2019-03-29T01:46:08.5616625Z ---> (Inner Exception #38) System.Management.Automation.RemoteException: AS DATETIME, @strReserveForFix AS NVARCHAR (50), @intBookId AS INT, @intSubBookId AS INT, @ysnOffset AS BIT, @intFutOptTransactionHeaderId AS INT, @ErrMsg AS NVARCHAR (MAX), @intCurrencyId AS INT, @intContractHeaderId AS INT, @intContractDetailId AS INT, @strXml AS NVARCHAR (MAX), @intMatchedLots AS INT, @ysnMultiplePriceFixation AS BIT, @strXmlNew AS NVARCHAR (MAX), @dblNoOfLots AS NUMERIC (18, 6), @intSelectedInstrumentTypeId AS INT; 2019-03-29T01:46:08.5617394Z DECLARE @idoc 2019-03-29T01:46:08.5618034Z 2019-03-29T01:46:08.5618587Z <--- 2019-03-29T01:46:08.5619186Z 2019-03-29T01:46:08.5619714Z 2019-03-29T01:46:08.5635671Z Deployment status for machine 'i21server.eastus.cloudapp.azure.com:5986' : 'Failed' 2019-03-29T01:46:08.6103512Z 2019-03-29T01:46:08.6109988Z