Description |
Issue:
Customer: Knapp Oil
Company: TE
Current Version: 19.1.1026.466
Applied Version for Upgrade: 19.1.1211.522
Database: \\fileserver\d$\PROJECTS\i21\Databases\Knapp
testTE_12112019.zip
Logs:
Error SQL72014: .Net SqlClient Data Provider: Msg 195, Level 15, State 10, Procedure uspCFEncodeCard, Line 165 'FORMAT' is not a recognized built-in function name.
Error SQL72045: Script execution error. The executed script:
CREATE PROCEDURE [dbo].[uspCFEncodeCard]
@userId INT
AS
BEGIN
DELETE tblCFEncodingPrinterSoftware;
DECLARE @EncodeCardStagingTable TABLE (
intId INT IDENTITY (1, 1),
strISO NVARCHAR (MAX),
intAccountLength INT ,
intCardLength INT ,
strNetworkISO NVARCHAR (MAX),
intNetworkAccountLength INT ,
intNetworkCardLength INT ,
strCardTypeISO NVARCHAR (MAX),
intCardTypeAccountLength INT ,
intCardTypeCardLength INT ,
intEntryCode INT ,
strNetworkType NVARCHAR (MAX),
strCustomerNumber NVARCHAR (MAX),
strCustomerName NVARCHAR (MAX),
strCardNumber NVARCHAR (MAX),
strCardDescription NVARCHAR (MAX),
Steps:
Update i21 App to version 19.1.1111.522 (Using SQL2008R2)
Acceptance:
Should be able to upgrade i21 App using version higher than 19.1.1111.522
|