Space or Site imports fail when URLs in import file are longer than 255 characters

Still need help?

The Atlassian Community is here for you.

Ask the community


This article only applies to Atlassian's server products. Learn more about the differences between cloud and server.

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


Description Space or site imports fail when URLs in import file are longer than 255 characters
Product Confluence
Last modified on Aug 23, 2019

Was this helpful?

Yes
No
Provide feedback about this article
Powered by Confluence and Scroll Viewport.