elfz-wp wrote: Hello,

I have the same problem in version 7, latest hotfix.

Site Manager/Settings/System/DB object schema: dbo

What should I do to fix it?

This is exact issue:

ERROR: Error importing 'System tables' objects (Ecommerce - SKU)
Message: [ TableManager.UpdateDocumentViews() ] An error occurred. Original exception: [DataConnection.HandleError]: Query: CREATE VIEW View_CMS_Tree_Joined_Regular WITH SCHEMABINDING AS SELECT S.SiteName, C.ClassName, C.ClassDisplayName, T.[NodeID], T.[NodeAliasPath], T.[NodeName], T.[NodeAlias], T.[NodeClassID], T.[NodeParentID], T.[NodeLevel], T.[NodeACLID], T.[NodeSiteID], T.[NodeGUID], T.[NodeOrder], T.[IsSecuredNode], T.[NodeCacheMinutes], T.[NodeSKUID], T.[NodeDocType], T.[NodeHeadTags], T.[NodeBodyElementAttributes], T.[NodeInheritPageLevels], T.[NodeChildNodesCount], T.[RequiresSSL], T.[NodeLinkedNodeID], T.[NodeOwner], T.[NodeCustomData], T.[NodeGroupID], T.[NodeLinkedNodeSiteID], T.[NodeTemplateID], T.[NodeWireframeTemplateID], T.[NodeWireframeComment], T.[NodeTemplateForAllCultures], T.[NodeInheritPageTemplate], T.[NodeWireframeInheritPageLevels], T.[NodeAllowCacheInFileSystem], D.[DocumentID], D.[DocumentName], D.[DocumentNamePath], D.[DocumentModifiedWhen], D.[DocumentModifiedByUserID], D.[DocumentForeignKeyValue], D.[DocumentCreatedByUserID], D.[DocumentCreatedWhen], D.[DocumentCheckedOutByUserID], D.[DocumentCheckedOutWhen], D.[DocumentCheckedOutVersionHistoryID], D.[DocumentPublishedVersionHistoryID], D.[DocumentWorkflowStepID], D.[DocumentPublishFrom], D.[DocumentPublishTo], D.[DocumentUrlPath], D.[DocumentCulture], D.[DocumentNodeID], D.[DocumentPageTitle], D.[DocumentPageKeyWords], D.[DocumentPageDescription], D.[DocumentShowInSiteMap], D.[DocumentMenuItemHideInNavigation], D.[DocumentMenuCaption], D.[DocumentMenuStyle], D.[DocumentMenuItemImage], D.[DocumentMenuItemLeftImage], D.[DocumentMenuItemRightImage], D.[DocumentPageTemplateID], D.[DocumentMenuJavascript], D.[DocumentMenuRedirectUrl], D.[DocumentUseNamePathForUrlPath], D.[DocumentStylesheetID], D.[DocumentContent], D.[DocumentMenuClass], D.[DocumentMenuStyleOver], D.[DocumentMenuClassOver], D.[DocumentMenuItemImageOver], D.[DocumentMenuItemLeftImageOver], D.[DocumentMenuItemRightImageOver], D.[DocumentMenuStyleHighlighted], D.[DocumentMenuClassHighlighted], D.[DocumentMenuItemImageHighlighted], D.[DocumentMenuItemLeftImageHighlighted], D.[DocumentMenuItemRightImageHighlighted], D.[DocumentMenuItemInactive], D.[DocumentCustomData], D.[DocumentExtensions], D.[DocumentCampaign], D.[DocumentTags], D.[DocumentTagGroupID], D.[DocumentWildcardRule], D.[DocumentWebParts], D.[DocumentRatingValue], D.[DocumentRatings], D.[DocumentPriority], D.[DocumentType], D.[DocumentLastPublished], D.[DocumentUseCustomExtensions], D.[DocumentGroupWebParts], D.[DocumentCheckedOutAutomatically], D.[DocumentTrackConversionName], D.[DocumentConversionValue], D.[DocumentSearchExcluded], D.[DocumentLastVersionName], D.[DocumentLastVersionNumber], D.[DocumentIsArchived], D.[DocumentLastVersionType], D.[DocumentLastVersionMenuRedirectUrl], D.[DocumentHash], D.[DocumentLogVisitActivity], D.[DocumentGUID], D.[DocumentWorkflowCycleGUID], D.[DocumentSitemapSettings], D.[DocumentIsWaitingForTranslation], D.[DocumentSKUName], D.[DocumentSKUDescription], D.[DocumentSKUShortDescription], D.[DocumentWorkflowActionStatus] FROM dbo.CMS_Tree T INNER JOIN dbo.CMS_Document D ON T.NodeID = D.DocumentNodeID INNER JOIN dbo.CMS_Site S ON T.NodeSiteID = S.SiteID INNER JOIN dbo.CMS_Class C ON T.NodeClassID = C.ClassID: caused exception: Invalid object name 'dbo.CMS_Tree'. Stack Trace: at CMS.DataEngine.TableManager.RefreshDocumentViews()
at CMS.DataEngine.TableManager.RefreshCustomViews(String tableName)
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, Boolean postProcessing)
at CMS.CMSImportExport.ImportProvider.ImportObjects(SiteImportSettings settings, DataSet ds, String objectType, Boolean siteObjects, TranslationHelper th, Boolean importChild, ProcessObjectEnum processType, Dictionary`2 importedParentIDs)

ERROR: Error during import process
Message: [ TableManager.UpdateDocumentViews() ] An error occurred. Original exception: [DataConnection.HandleError]: Query: CREATE VIEW View_CMS_Tree_Joined_Regular WITH SCHEMABINDING AS SELECT S.SiteName, C.ClassName, C.ClassDisplayName, T.[NodeID], T.[NodeAliasPath], T.[NodeName], T.[NodeAlias], T.[NodeClassID], T.[NodeParentID], T.[NodeLevel], T.[NodeACLID], T.[NodeSiteID], T.[NodeGUID], T.[NodeOrder], T.[IsSecuredNode], T.[NodeCacheMinutes], T.[NodeSKUID], T.[NodeDocType], T.[NodeHeadTags], T.[NodeBodyElementAttributes], T.[NodeInheritPageLevels], T.[NodeChildNodesCount], T.[RequiresSSL], T.[NodeLinkedNodeID], T.[NodeOwner], T.[NodeCustomData], T.[NodeGroupID], T.[NodeLinkedNodeSiteID], T.[NodeTemplateID], T.[NodeWireframeTemplateID], T.[NodeWireframeComment], T.[NodeTemplateForAllCultures], T.[NodeInheritPageTemplate], T.[NodeWireframeInheritPageLevels], T.[NodeAllowCacheInFileSystem], D.[DocumentID], D.[DocumentName], D.[DocumentNamePath], D.[DocumentModifiedWhen], D.[DocumentModifiedByUserID], D.[DocumentForeignKeyValue], D.[DocumentCreatedByUserID], D.[DocumentCreatedWhen], D.[DocumentCheckedOutByUserID], D.[DocumentCheckedOutWhen], D.[DocumentCheckedOutVersionHistoryID], D.[DocumentPublishedVersionHistoryID], D.[DocumentWorkflowStepID], D.[DocumentPublishFrom], D.[DocumentPublishTo], D.[DocumentUrlPath], D.[DocumentCulture], D.[DocumentNodeID], D.[DocumentPageTitle], D.[DocumentPageKeyWords], D.[DocumentPageDescription], D.[DocumentShowInSiteMap], D.[DocumentMenuItemHideInNavigation], D.[DocumentMenuCaption], D.[DocumentMenuStyle], D.[DocumentMenuItemImage], D.[DocumentMenuItemLeftImage], D.[DocumentMenuItemRightImage], D.[DocumentPageTemplateID], D.[DocumentMenuJavascript], D.[DocumentMenuRedirectUrl], D.[DocumentUseNamePathForUrlPath], D.[DocumentStylesheetID], D.[DocumentContent], D.[DocumentMenuClass], D.[DocumentMenuStyleOver], D.[DocumentMenuClassOver], D.[DocumentMenuItemImageOver], D.[DocumentMenuItemLeftImageOver], D.[DocumentMenuItemRightImageOver], D.[DocumentMenuStyleHighlighted], D.[DocumentMenuClassHighlighted], D.[DocumentMenuItemImageHighlighted], D.[DocumentMenuItemLeftImageHighlighted], D.[DocumentMenuItemRightImageHighlighted], D.[DocumentMenuItemInactive], D.[DocumentCustomData], D.[DocumentExtensions], D.[DocumentCampaign], D.[DocumentTags], D.[DocumentTagGroupID], D.[DocumentWildcardRule], D.[DocumentWebParts], D.[DocumentRatingValue], D.[DocumentRatings], D.[DocumentPriority], D.[DocumentType], D.[DocumentLastPublished], D.[DocumentUseCustomExtensions], D.[DocumentGroupWebParts], D.[DocumentCheckedOutAutomatically], D.[DocumentTrackConversionName], D.[DocumentConversionValue], D.[DocumentSearchExcluded], D.[DocumentLastVersionName], D.[DocumentLastVersionNumber], D.[DocumentIsArchived], D.[DocumentLastVersionType], D.[DocumentLastVersionMenuRedirectUrl], D.[DocumentHash], D.[DocumentLogVisitActivity], D.[DocumentGUID], D.[DocumentWorkflowCycleGUID], D.[DocumentSitemapSettings], D.[DocumentIsWaitingForTranslation], D.[DocumentSKUName], D.[DocumentSKUDescription], D.[DocumentSKUShortDescription], D.[DocumentWorkflowActionStatus] FROM dbo.CMS_Tree T INNER JOIN dbo.CMS_Document D ON T.NodeID = D.DocumentNodeID INNER JOIN dbo.CMS_Site S ON T.NodeSiteID = S.SiteID INNER JOIN dbo.CMS_Class C ON T.NodeClassID = C.ClassID: caused exception: Invalid object name 'dbo.CMS_Tree'. Stack Trace: at CMS.CMSImportExport.ImportProvider.ImportObjects(SiteImportSettings settings, DataSet ds, String objectType, Boolean siteObjects, TranslationHelper th, Boolean importChild, ProcessObjectEnum processType, Dictionary`2 importedParentIDs)
at CMS.CMSImportExport.ImportProvider.ImportObjectType(SiteImportSettings settings, String objectType, Boolean siteObject, TranslationHelper th, ProcessObjectEnum process, Dictionary`2 importedParentIDs)
at CMS.CMSImportExport.ImportProvider.ImportObjectsData(SiteImportSettings settings)

Best regards,
Robert Ratajczak