Description |
This issue relates to i21 Help Desk ticket. Click the link below to go to Help Desk ticket.
[HDTN-202474 - Install 17.31.0829.67 to Freedom Oil TEST environment|http://helpdesk.irely.com/iRelyi21live/i21/#/HD/Ticket/?ticket=HDTN-202474]
Installing 17.3.0901.75 in Freedom Oil Test
Error in Company MF
Here is the log:
Error SQL72014: .Net SqlClient Data Provider: Msg 468, Level 16, State 9, Procedure uspARImportPTTax, Line 1592 Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CS_AS" and "Latin1_General_CI_AS" in the equal to operation.
Error SQL72045: Script execution error. The executed script:
ALTER PROCEDURE [dbo].[uspARImportPTTax]
AS
BEGIN
EXECUTE [uspARImportPTTaxXref] ;
IF EXISTS (SELECT TOP 1 1
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_NAME = 'temp_sst')
DROP TABLE temp_sst;
IF EXISTS (SELECT TOP 1 1
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_NAME = '#itmnotax')
DROP TABLE #itmnotax;
IF EXISTS (SELECT TOP 1 1
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_NAME = '#itmnotax1')
DROP TABLE #itmnotax1;
IF EXISTS (SELECT TOP 1 1
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_NAME = '#temp_ptstm')
DROP TABLE #temp_ptstm;
IF EXISTS (SELECT TOP 1 1
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_NAME = '#tempDTL')
DROP TABLE #tempDTL;
IF EXISTS (SELECT TOP 1 1
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_NAME = '#IVCTAX')
|