| Description |
Error in Script Deployment
Error SQL72014: .Net SqlClient Data Provider: Msg 120, Level 15, State 1, Procedure uspRKGenerateM2M, Line 2164 The select list for the INSERT statement contains fewer items than the insert list. The number of SELECT values must match the number of INSERT columns.Error SQL72045: Script execution error. The executed script:ALTER PROCEDURE [dbo].[uspRKGenerateM2M]@intM2MHeaderId INT OUTPUT, @strRecordName NVARCHAR (50)=NULL, @intCommodityId INT=NULL, @intM2MTypeId INT, @intM2MBasisId INT, @intFutureSettlementPriceId INT, @intQuantityUOMId INT, @intPriceUOMId INT, @intCurrencyId INT, @dtmEndDate DATETIME, @strRateType NVARCHAR (200), @intLocationId INT=NULL, @intMarketZoneId INT=NULL, @ysnByProducer BIT=NULL, @intCompanyId INT=NULL, @dtmPostDate DATETIME=NULL, @dtmReverseDate DATETIME=NULL, @dtmLastReversalDate DATETIME=NULL, @intUserId INT=NULLASSET QUOTED_IDENTIFIER OFF;SET ANSI_NULLS ON;SET NOCOUNT ON;SET XACT_ABORT ON;SET ANSI_WARNINGS OFF;BEGIN TRY IF OBJECT_ID('tempdb..#tblContractCost') IS NOT NULL
[https://irely.visualstudio.com/i21/_releaseProgress?_a=release-environment-logs&releaseId=246371&environmentId=385076]
|