Space or Site imports fail when URLs in import file are longer than 255 characters
This article only applies to Atlassian's server products. Learn more about the differences between cloud and server.
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>
TRACKBACKLINKS tables use a VARCHAR 255 data type for
URL and and
Edit the import file and shorten/remove URLs longer than 255 characters or increase the data storage type up from 255.