Installation and deployment Questions on installation, system configuration and deployment to the live server.
Version 5.x > Installation and deployment > Error during import process View modes: 
User avatar
Member
Member
sophiepvm - 7/13/2010 10:47:34 AM
   
Error during import process
Hello,

I am using the trial version of Kentico v5.5.3789.

I am trying to export/import a site. When I import I get this error.


Error during import process
Importing 'Document types' objects
Importing 'Users' objects
Importing 'Time zones' objects
Importing 'Badges' objects
Importing 'Avatars' objects
Importing 'System tables' objects
Importing 'Modules' objects
Importing 'Form controls' objects
Importing 'Web part containers' objects
Importing 'Widgets' objects
Importing 'Widget categories' objects
Importing 'Web parts' objects
Importing 'Web part categories' objects
Importing 'Inline controls' objects
Importing 'Scheduled tasks' objects
Importing 'Relationship names' objects
Importing 'E-mail templates' objects
Importing 'Cultures' objects
Importing 'Page templates' objects
Importing 'Page template categories' objects
Importing 'Page layouts' objects
Importing 'Countries' objects
Importing 'UI cultures' objects
Importing 'CSS stylesheets' objects
Importing 'Settings' objects
Importing 'Settings categories' objects
Importing 'Settings' objects
Importing 'Settings categories' objects
Importing 'License keys' objects

Objects are being imported






ERROR: Error importing 'Document types' objects (Simple article)
Message: [DataConnection.ExecuteQuery]: Query: ALTER TABLE CONTENT_SimpleArticle ALTER COLUMN [ArticleText] nvarchar(max) NOT NULL: caused exception: Cannot create a row of size 8082 which is greater than the allowable maximum row size of 8060.
The statement has been terminated. Stack Trace: at CMS.DataProviderSQL.DataConnection.ExecuteQuery(String queryText, Object[,] queryParams, QueryTypeEnum queryType)
at CMS.DataEngine.AbstractDataConnection.CMS.IDataConnectionLibrary.IDataConnection.ExecuteQuery(String queryText, Object[,] queryParams, QueryTypeEnum queryType)
at CMS.DataEngine.AbstractTableManager.AlterTableColumnWithDefaultValue(String tableName, String columnName, String newColumnName, String newColumnType, Boolean newColumnAllowNull, String newColumnDefaultValue, IDataConnection conn)
at CMS.DataEngine.AbstractTableManager.AlterTableColumn(String tableName, String columnName, String newColumnName, String newColumnType, Boolean newColumnAllowNull, String newColumnDefaultValue)
at CMS.DataEngine.TableManager.AlterTableColumn(String tableName, String columnName, String newColumnName, String newColumnType, Boolean newColumnAllowNull, String newColumnDefaultValue)
at CMS.DataEngine.TableManager.UpdateTableBySchema(String tableName, String schema, String excludeColumns)
at CMS.DataEngine.TableManager.UpdateTableBySchema(String tableName, String schema)
at CMS.CMSImportExport.ImportProvider.UpdateObject(SiteImportSettings settings, IInfoObject infoObj, Boolean siteObject, DataSet ds, TranslationHelper th, Boolean updateChild, Int32 targetSiteId, ProcessObjectEnum process, Hashtable importedParentIDs, ArrayList postProcessList)
at CMS.CMSImportExport.ImportProvider.ImportObjects(SiteImportSettings settings, DataSet ds, String objectType, Boolean siteObjects, TranslationHelper th, Boolean importChild, ProcessObjectEnum processType, Hashtable importedParentIDs)

User avatar
Kentico Support
Kentico Support
kentico_radekm - 7/19/2010 6:35:58 AM
   
RE:Error during import process
Hello.

What is your SQL Server´s version, please? For version 5.5, you need to have SQL Server 2005 at least. SQL 2000 is not supported. Could you please check it? Thank you.

Best Regards,
Radek Macalik

User avatar
Member
Member
sophiepvm - 7/19/2010 11:11:32 AM
   
RE:Error during import process
SqlServer 2008