Member
|
vinci
-
2/1/2012 3:52:16 AM
Error during importing 5.5R2 backup files after upgraded to 6.0
Hi,
After upgraded system from version 5.x to version 6.0, I would like to import all my previous files and folder back into system which i back up early. But it seems like got problem during import process. How to solve this problem ? Please help.
The error messages shown during import process. Greatly appreciate and thanks in advance.
ERROR: Error importing 'Form controls' objects (CheckboxTnC)
Message: [DataConnection.ExecuteQuery]: Query: INSERT INTO CMS_FormUserControl ([UserControlDisplayName], [UserControlCodeName], [UserControlFileName], [UserControlForText], [UserControlForLongText], [UserControlForInteger], [UserControlForDecimal], [UserControlForDateTime], [UserControlForBoolean], [UserControlForFile], [UserControlShowInBizForms], [UserControlDefaultDataType], [UserControlDefaultDataTypeSize], [UserControlShowInDocumentTypes], [UserControlShowInSystemTables], [UserControlShowInWebParts], [UserControlShowInReports], [UserControlGUID], [UserControlLastModified], [UserControlForGuid], [UserControlShowInCustomTables], [UserControlForVisibility], [UserControlParameters], [UserControlForDocAttachments], [UserControlForLongInteger], [UserControlResourceID], [UserControlType] ) VALUES ( @UserControlDisplayName, @UserControlCodeName, @UserControlFileName, @UserControlForText, @UserControlForLongText, @UserControlForInteger, @UserControlForDecimal, @UserControlForDateTime, @UserControlForBoolean, @UserControlForFile, @UserControlShowInBizForms, @UserControlDefaultDataType, @UserControlDefaultDataTypeSize, @UserControlShowInDocumentTypes, @UserControlShowInSystemTables, @UserControlShowInWebParts, @UserControlShowInReports, @UserControlGUID, @UserControlLastModified, @UserControlForGuid, @UserControlShowInCustomTables, @UserControlForVisibility, @UserControlParameters, @UserControlForDocAttachments, @UserControlForLongInteger, @UserControlResourceID, @UserControlType); SELECT SCOPE_IDENTITY() AS [UserControlID]: caused exception: Cannot insert the value NULL into column 'UserControlForGuid', table 'KenticoCMS5.5R2to6.0.dbo.CMS_FormUserControl'; column does not allow nulls. INSERT fails.
The statement has been terminated. Stack Trace: at CMS.DataProviderSQL.DataConnection.ExecuteScalar(String queryText, QueryDataParameters queryParams, QueryTypeEnum queryType, Boolean requiresTransaction)
at CMS.DataEngine.GeneralConnection.ExecuteScalar(QueryParameters query)
at CMS.DataEngine.GeneralConnection.ExecuteScalar(String queryName, QueryDataParameters parameters, String where, String orderBy, Int32 topN, String columns)
at CMS.DataEngine.GeneralConnection.ExecuteScalar(String queryName, QueryDataParameters parameters)
at CMS.DataEngine.SimpleDataClass.Insert(Boolean getId)
at CMS.DataEngine.SimpleDataClass.Insert()
at CMS.DataEngine.AbstractInfo`1.InsertData()
at CMS.Synchronization.SynchronizedInfo`1.InsertData()
at CMS.SiteProvider.FormUserControlInfoProvider.SetFormUserControlInfoInternal(FormUserControlInfo infoObj)
at CMS.SiteProvider.FormUserControlInfo.SetObject()
at CMS.CMSImportExport.ImportProvider.SetObject(SiteImportSettings settings, GeneralizedInfo infoObj, GeneralizedInfo parentInfo, List`1 affectedObjects)
at CMS.CMSImportExport.ImportProvider.UpdateObject(SiteImportSettings settings, GeneralizedInfo infoObj, Boolean siteObject, DataSet ds, TranslationHelper th, Boolean updateChild, Int32 targetSiteId, ProcessObjectEnum process, Dictionary`2 importedParentIDs, List`1 postProcessList, List`1 affectedObjects, BaseInfo parentObject)
at CMS.CMSImportExport.ImportProvider.ImportObjects(SiteImportSettings settings, DataSet ds, String objectType, Boolean siteObjects, TranslationHelper th, Boolean importChild, ProcessObjectEnum processType, Dictionary`2 importedParentIDs) at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
at System.Data.SqlClient.SqlDataReader.get_MetaData()
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteScalar()
at CMS.DataProviderSQL.DataConnection.ExecuteScalar(String queryText, QueryDataParameters queryParams, QueryTypeEnum queryType, Boolean requiresTransaction)
|