Forums (Obsolete)

Member

Snarrak - 11/24/2011 7:22:02 AM

Errors during import

Hi,

I'm trying to import new site objects but I'm getting errors both with deleting and importing:
- delete failed because: 'The DELETE statement conflicted with the REFERENCE constraint'
- import failed because: Could not allocate space for object 'dbo.CMS_ObjectVersionHistory'.'PK_CMS_ObjectVersionHistory' in database 'mydatabase' because the 'PRIMARY' filegroup is full. The second one is not only for 'PK_CMS_ObjectVersionHistory'.
I googled the second one, and found that i needed to set the database files to unrestricted. I tried to edit properties of my database trough sql management studio, but there are no database files...

Error 1 (delete)


ERROR:  Error during site deletion.
Message: [DataConnection.ExecuteQuery]: Query: Proc_CMS_Site_DeleteRoot: caused exception: The DELETE statement conflicted with the REFERENCE constraint "FK_CMS_Attachment_AttachmentDocumentID_CMS_Document". The conflict occurred in database "arnoldmaassen", table "dbo.CMS_Attachment", column 'AttachmentDocumentID'.
The DELETE statement conflicted with the REFERENCE constraint "FK_CMS_Document_DocumentNodeID_CMS_Tree". The conflict occurred in database "arnoldmaassen", table "dbo.CMS_Document", column 'DocumentNodeID'.
The statement has been terminated.
The statement has been terminated. Stack Trace: at CMS.DataProviderSQL.DataConnection.ExecuteQuery(String queryText, QueryDataParameters queryParams, QueryTypeEnum queryType, Boolean requiresTransaction)
at CMS.DataEngine.AbstractDataConnection.CMS.SettingsProvider.IDataConnection.ExecuteQuery(String queryText, QueryDataParameters queryParams, QueryTypeEnum queryType, Boolean requiresTransaction)
at CMS.DataEngine.GeneralConnection.RunQuery(QueryParameters query)
at CMS.DataEngine.GeneralConnection.ExecuteQuery(QueryParameters query)
at CMS.DataEngine.GeneralConnection.ExecuteQuery(String queryName, QueryDataParameters parameters, String where, String orderBy, Int32 topN, String columns)
at CMS.DataEngine.GeneralConnection.ExecuteQuery(String queryName, QueryDataParameters parameters)
at CMS.WorkflowEngine.DocumentHelper.DeleteSiteTree(String siteName, TreeProvider tree, OnAfterDocumentDeletedEventHandler deleteCallback, String webRootFullPath)
at CMS.WorkflowEngine.DocumentHelper.DeleteSiteTree(String siteName, TreeProvider tree)
at CMS.CMSImportExport.ImportProvider.ImportObjectsData(SiteImportSettings settings) 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.ExecuteReader(CommandBehavior behavior, String method)
at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)
at CMS.DataProviderSQL.DataConnection.ExecuteQuery(String queryText, QueryDataParameters queryParams, QueryTypeEnum queryType, Boolean requiresTransaction)

Error 2&3:


ERROR:  Error during import process
Message: [DataConnection.ExecuteQuery]: Query: INSERT INTO CMS_ObjectVersionHistory ([VersionObjectID], [VersionObjectType], [VersionObjectSiteID], [VersionObjectDisplayName], [VersionXML], [VersionBinaryDataXML], [VersionModifiedByUserID], [VersionModifiedWhen], [VersionDeletedByUserID], [VersionDeletedWhen], [VersionNumber], [VersionSiteBindingIDs] ) VALUES ( @VersionObjectID, @VersionObjectType, @VersionObjectSiteID, @VersionObjectDisplayName, @VersionXML, @VersionBinaryDataXML, @VersionModifiedByUserID, @VersionModifiedWhen, @VersionDeletedByUserID, @VersionDeletedWhen, @VersionNumber, @VersionSiteBindingIDs); SELECT SCOPE_IDENTITY() AS [VersionID]: caused exception: Could not allocate space for object 'dbo.CMS_ObjectVersionHistory'.'PK_CMS_ObjectVersionHistory' in database 'arnoldmaassen' 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.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) 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) 

ERROR:  Error importing 'Page templates' objects (Three columns, top, bottom (Dashboard))
Message: [DataConnection.ExecuteQuery]: Query: INSERT INTO CMS_ObjectVersionHistory ([VersionObjectID], [VersionObjectType], [VersionObjectSiteID], [VersionObjectDisplayName], [VersionXML], [VersionBinaryDataXML], [VersionModifiedByUserID], [VersionModifiedWhen], [VersionDeletedByUserID], [VersionDeletedWhen], [VersionNumber], [VersionSiteBindingIDs] ) VALUES ( @VersionObjectID, @VersionObjectType, @VersionObjectSiteID, @VersionObjectDisplayName, @VersionXML, @VersionBinaryDataXML, @VersionModifiedByUserID, @VersionModifiedWhen, @VersionDeletedByUserID, @VersionDeletedWhen, @VersionNumber, @VersionSiteBindingIDs); SELECT SCOPE_IDENTITY() AS [VersionID]: caused exception: Could not allocate space for object 'dbo.CMS_ObjectVersionHistory'.'PK_CMS_ObjectVersionHistory' in database 'arnoldmaassen' 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.Synchronization.ObjectVersionManager.CreateVersion(GeneralizedInfo infoObj, Boolean forceVersion)
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)

btw: I tried importing several times, it isn't always about the same tables...


Member	Snarrak - 11/24/2011 7:35:29 AM RE:Errors during import Ps. I'm still in test-fase, so it's not what I want in the future, but I thought deleting the site en importing a new one, might help. But deleting the site gives me a same kind of error: 'The DELETE statement conflicted with the REFERENCE constraint'


Kentico Support	kentico_jurajo - 11/25/2011 2:10:18 AM RE:Errors during import Hi, It seems there is some inconsistence in your DB. Have you made any changes directly in the DB? Or, what was changed prior these errors? Have you tried to create a new DB from scratch? Best regards, Juraj Ondrus

Member

Snarrak - 11/25/2011 4:29:28 AM

RE:Errors during import

HI juraj,

I didn't make any changes to the database directly. The last thing I changed.. I can't remember, but I can't imagine that it was something big.
How can I create the database from scratch? Is there a way in Kentico. Because when I run the installation wizard from the beginning, when I need to select the database, I'm getting errors that tables already exist.
Can I do this with the Kentico software, or do I need to do it through sql server?


Kentico Support	kentico_jurajo - 11/25/2011 8:35:19 AM RE:Errors during import Hi, You can remove the connection string from the web.config file and this should start the DB installer again (if not, you can run the /CMSInstall/install.aspx page) and go through the DB installation again and create new, fresh database. Best regards, Juraj Ondrus


Member	Snarrak - 11/25/2011 9:22:57 AM RE:Errors during import Hi, I already tried this. Problem: can't create a new database on the server (rule of hosting provider). Is it possible to delete everything related to kentio off the database?


Kentico Support	kentico_jurajo - 11/28/2011 1:15:56 AM RE:Errors during import Hi, In this case it would be better do destroy the whole DB via some hosting interface for managing databases. Or, if there is such an interface, you can delete the DB objects through it. Just one more idea - what is set as the database owner/schema of the DB? By default it should be set to DBO. Best regards, Juraj Ondrus