Description |
Customer: Federated
Company: federa01
Current build: 18.1.1024.454
Error Build: 18.3.1206.525
Database:
Error Log:
Error SQL72014: .Net SqlClient Data Provider: Msg 8116, Level 16, State 1, Procedure uspMBDCMeterAccountMigration, Line 208 Argument data type nvarchar is invalid for argument 1 of formatmessage function.
Error SQL72045: Script execution error. The executed script:
IF (SELECT TOP 1 ysnUsed
FROM ##tblOriginMod
WHERE strPrefix = 'AP') = 1
BEGIN
EXECUTE ('
ALTER VIEW [dbo].[vyuAPOriginCCDTransaction]
AS
WITH APOriginCCDTransaction AS (
SELECT DISTINCT
[intEntityId] = D.intEntityId,
[strVendorOrderNumber] = (CASE WHEN DuplicateData.apivc_ivc_no IS NOT NULL
THEN dbo.fnTrim(A.apivc_ivc_no) + ''-DUP''
ELSE A.apivc_ivc_no END),
[intTermsId] = ISNULL((SELECT TOP 1 intTermsId FROM tblEMEntityLocation
WHERE intEntityId = (SELECT intEntityId FROM tblAPVendor
WHERE strVendorId COLLATE Latin1_General_CS_AS = A.apivc_vnd_no)), (SELECT TOP 1 intTermID FROM tblSMTerm WHERE strTerm = ''Due on Receipt''))
FROM apivcmst A
LEFT JOIN apcbkmst B
ON A.apivc_cbk_no = B.apcbk_no
INNER JOIN tblAPVendor D
ON A.apivc_vnd_no = D.strVendorId COLLATE Latin1_General_CS_AS
LEFT JOIN tblEMEntityLocation loc
ON D.intEntityId = loc.intEnti
|