Site Export exception

Paul Krysiak asked on September 17, 2024 19:05

I am trying to export all of the media file from Kentico and after i configured everything I hit next and i get the below exception.

Do i have to change the table Export_History's ExportSettings varchar length in the database to get this to work?

[DataConnection.HandleError]: Query: INSERT INTO Export_History ([ExportDateTime], [ExportFileName], [ExportSiteID], [ExportUserID], [ExportSettings]) VALUES (@ExportDateTime, @ExportFileName, @ExportSiteID, @ExportUserID, @ExportSettings); SELECT SCOPE_IDENTITY() AS [ID] Caused exception: String or binary data would be truncated. The statement has been terminated.

site export

Correct Answer

Juraj Ondrus answered on September 26, 2024 08:08

If you are using page attachments - it is possible there are some big attachments or, there are so many of them that you are hitting the SQL server limits. You may want to check the Content staging feature if you are looking to move content from one Kentico instance to another.

0 votesVote for this answer Unmark Correct answer

Recent Answers

Juraj Ondrus answered on September 18, 2024 09:34

It looks like that there are some big files in the media library and you are hitting the SQL server limits. I would recommend to not to export the physical files, just their DB representation. Then, import the package on the target and then copy over the physical media files to the target and preserve the folder structure.

1 votesVote for this answer Mark as a Correct answer

Paul Krysiak answered on September 18, 2024 16:04 (last edited on September 18, 2024 16:05)

Juraj
Thanks for the explanation. If I can get the urls then I am all good. I was hoping to get everything at once but that is fine. I have way of getting them.