Space or Site imports fail when URLs in import file are longer than 255 characters
Platform notice: Server and Data Center only. This article only applies to Atlassian products on the Server and Data Center platforms.
Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
Problem
When importing a space or site which contains URLs longer than 255 characters, the following error is encountered:
ERROR [Long running task: Importing data] [engine.jdbc.spi.SqlExceptionHelper] logExceptions Data truncation: Data too long for column 'LOWERURL' at row 1
ERROR [Long running task: Importing data] [confluence.importexport.xmlimport.DefaultImportProcessor] persist Error while saving object: Imported[com.atlassian.confluence.links.ReferralLink] [Id[id]=75925448, Property[viewCount]=1, Property[url]=<URL>[lowerUrl]=<URL>Cause
Currently the EXTRNLNKS and TRACKBACKLINKS tables use a VARCHAR 255 data type for URL and and LOWERURL columns.
Workaround
Edit the import file and shorten/remove URLs longer than 255 characters or increase the data storage type up from 255.
Feature Request
There is a suggestion logged to request Confluence support the storage of longer URLs, please see CONFSERVER-58754 - Getting issue details... STATUS