Description |
This issue relates to i21 Help Desk ticket. Click the link below to go to Help Desk ticket.
[HDTN-202817 - AP and CM Conversion - Training Week Of 3/1/2018 (18.1)|http://helpdesk.irely.com/iRelyi21live//#/HD/Ticket/?ticket=HDTN-202817]
Customers: Knapp Oil and CoMark Energy
Company: 01 (Please check also 02,03,99 and BB) for Knapp Oil
Company: testTE for CoMark
path for Knapp: [ftp://ftp.i21server.com/databases/knapp]
file: irely01_01142018.zip
path for CoMark: [ftp://ftp.i21server.com/databases/CoMark]
file: testTE_01142018.zip
Failed database upgrade from 17.3.1218.199 to 17.3.0112.242
Error Log:
Error SQL72014: .Net SqlClient Data Provider: Msg 195, Level 15, State 10, Procedure uspCTCreateContract, Line 121 'EOMONTH' is not a recognized built-in function name.
Error SQL72045: Script execution error. The executed script:
ALTER PROCEDURE [dbo].[uspCTCreateContract]
@intExternalId INT, @strScreenName NVARCHAR (50), @intUserId INT, @XML NVARCHAR (MAX), @intContractHeaderId INT OUTPUT
AS
BEGIN TRY
DECLARE @ErrMsg AS NVARCHAR (MAX), @idoc AS INT, @strStartingNumber AS NVARCHAR (100), @strTblXML AS NVARCHAR (MAX), @intContractTypeId AS INT, @intEntityId AS INT, @intCommodityId AS INT, @dblHeaderQuantity AS NUMERIC (18, 6), @intCommodityUOMId AS INT, @strContractNumber AS NVARCHAR (100), @dtmContractDate AS DATETIME, @intSalespersonId AS INT, @intContractDetailId AS INT, @intContractSeq AS INT, @intCompanyLocationId AS INT, @dtmStartDate AS DATETIME, @dtmEndDate AS DATETIME, @intContractStatusId AS INT, @intItemId AS INT, @dblQuantity AS NUMERIC (18, 6), @intItemUOMId AS INT, @dblBalance AS NUMERIC (18, 6), @intPricingTypeId AS INT, @intStorageScheduleRuleId AS INT, @intCreatedById AS INT, @dtmCreated AS DATETIME, @SQL AS NVARCHAR (MAX);
EXECUTE sp_xml_preparedocument @idoc OUTPUT, @XML;
IF OBJECT_ID('tempdb..#tmpC
|