Installation and deployment Questions on installation, system configuration and deployment to the live server.
Version 4.x > Installation and deployment > Installation problems. View modes: 
User avatar
Member
Member
bo-bg-webdesign - 9/26/2009 9:43:48 AM
   
Installation problems.
Hi All...
I'm all new at this program, and I have trouble installing the database, everytime I try, I get this failure:

ERROR: Error importing 'System tables' objects (Ecommerce - SKU)
Exception: [ TableManager.UpdateDocumentViews() ] An error occured. Original exception: [DataConnection.ExecuteQuery]: Query: CREATE VIEW View_CONTENT_Cellphone_Joined AS SELECT View_CMS_Tree_Joined.*, CONTENT_Cellphone.* FROM View_CMS_Tree_Joined INNER JOIN CONTENT_Cellphone ON View_CMS_Tree_Joined.DocumentForeignKeyValue = CONTENT_Cellphone.[cellphoneID] WHERE (ClassName = 'CMS.CellPhone') : caused exception: Could not allocate space for object 'sys.sysobjvalues'.'clst' in database 'ashaway_cms' because the 'PRIMARY' filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup.
Stack trace: at CMS.DataEngine.TableManager.RefreshDocumentViews() at CMS.DataEngine.TableManager.RefreshCustomViews(String tableName) 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)

Hope you can help me.

User avatar
Member
Member
mbenist-earthlink - 9/29/2009 5:11:52 AM
   
RE:Installation problems.
I think the issue is that you have run out of space. The key message in the exception is that your PRIMARY filegroup is full. SQL Server uses a lot of space for logging and regular maintenance is required to keep those logs at a manageable size.
Mike

User avatar
Member
Member
hortvision - 4/26/2011 3:34:47 AM
   
RE:Installation problems.
Can you please point me to the directions on how to maintain the size of the logs.
I will need to do it without logging in as the size of the event log is preventing me from logging in.

Exception Details: System.Exception: [DataConnection.ExecuteQuery]: Query: INSERT INTO CMS_EventLog ([EventType], [EventTime], [Source], [EventCode], [UserID], [UserName], [IPAddress], [NodeID], [DocumentName], [EventDescription], [SiteID], [EventUrl], [EventMachineName], [EventUserAgent], [EventUrlReferrer] ) VALUES ( @EventType, @EventTime, @Source, @EventCode, @UserID, @UserName, @IPAddress, @NodeID, @DocumentName, @EventDescription, @SiteID, @EventUrl, @EventMachineName, @EventUserAgent, @EventUrlReferrer); SELECT SCOPE_IDENTITY() AS [EventID]: caused exception: Could not allocate space for object 'dbo.CMS_EventLog'.'IX_CMS_EventLog_EventTime' in database 'kentico_hortvision_com_au' because the 'PRIMARY' filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup.



User avatar
Kentico Developer
Kentico Developer
kentico_helenag - 4/26/2011 4:40:22 AM
   
RE:Installation problems.
Hello,


you can set up the number of logs in Site manager -> Settings -> System -> Log size. You can also delete the logs directly in the database in the CMS_EventLog table.


Best regards,
Helena Grulichova