[DataConnection.HandleError]: Query: /* DECLARE @Guid NVARCHAR(64) = '1D93249E-72BB-4573-9F82-F37616891F74', --Attachment: EA717116-4F9D-4DD4-B793-91C004228501 --Email: 19A21CE2-CE0E-45EF-BAF2-B4A3020E9720 --oneIM: 1D93249E-72BB-4573-9F82-F37616891F74 @UserId INT = 132, @SiteId INT = 4, @Referrer NVARCHAR(255) = '', @ClientIp NVARCHAR(32) = '127.0.0.1', @SessionId NVARCHAR(64) = 'KenticoSessionIdHere' */ DECLARE @Attachments NVARCHAR(255), @FormFiles NVARCHAR(255), @oneIMFiles NVARCHAR(255) DECLARE @Data TABLE ( Source NVARCHAR(255), FileSource NVARCHAR(255), FileName NVARCHAR(255), MimeType NVARCHAR(255), Size INT, Binary VARBINARY(MAX) ) SELECT @Attachments = dbo.Sfn_GetCMSSetting(@SiteId, 'CMSFilesFolder') + IIF(dbo.Sfn_GetCMSSetting(@SiteId, 'CMSUseFilesSiteFolder') IN ('1', 'True'), '\' + SiteName, '') + '\', @FormFiles = dbo.Sfn_GetCMSSetting(@SiteId, 'CMSBizFormFilesFolder') + IIF(dbo.Sfn_GetCMSSetting(@SiteId, 'CMSUseBizFormsSiteFolder') IN ('1', 'True'), '\' + SiteName, '') + '\', @oneIMFiles = dbo.Sfn_GetCMSSetting(@SiteId, 'CMSBizFormFilesFolder') + '\one.ingrammicro.eu\' FROM dbo.CMS_Site WITH (NOLOCK) WHERE SiteID = @SiteId INSERT INTO @Data SELECT TOP 1 * FROM ( SELECT 'CMS_Attachment' Source, CONCAT(@Attachments, LEFT(AttachmentGUID, 2), '\', AttachmentGUID, AttachmentExtension) FileSource, AttachmentName FileName, AttachmentMimeType MimeType, AttachmentSize Size, AttachmentBinary Binary FROM dbo.CMS_Attachment WITH (NOLOCK) WHERE AttachmentGUID = @Guid AND AttachmentSiteID = @SiteId UNION SELECT 'CMS_EmailAttachment', CONCAT(@FormFiles, AttachmentGUID, AttachmentExtension), AttachmentName, AttachmentMimeType, AttachmentSize, AttachmentBinary FROM dbo.CMS_EmailAttachment WITH (NOLOCK) WHERE AttachmentGUID = @Guid AND AttachmentSiteID = @SiteId UNION SELECT 'oneIM_Attachments', CONCAT(@oneIMFiles, ItemGUID, FileExtension), RIGHT(FileName, CHARINDEX('\', REVERSE('\' + FileName)) - 1), FileMimeType, FileSize, Data FROM dbo.oneIM_Attachments WITH (NOLOCK) WHERE ItemGUID = @Guid --AND No SiteID field! = @SiteId ) A INSERT INTO dbo.Analytics_FileDownloads (TimeStamp, UserID, SiteID, Source, FileGUID, Referrer, ClientIP, SessionId) SELECT GETDATE(), @UserId, @SiteId, Source, @Guid, @Referrer, @ClientIp, @SessionId FROM @Data SELECT * FROM @Data Caused exception: String or binary data would be truncated in table 'KENTICO.dbo.Analytics_FileDownloads', column 'ClientIP'. Truncated value: '2600:1f28:365:80b0:2b2a:1ff8:c7e'. The statement has been terminated.