Hello Guys,
I exported a website from Kentico v10 and I want to import it in Kenico v12
On import I am getting the bellow error message.Any solution?
Thank you
Error during import process
ERROR: Error during import process
Message:
UPDATE CMS_SearchIndex SET [IndexSettings] = @IndexSettings, [IndexLastModified] = @IndexLastModified, [IndexLastRebuildTime] = @IndexLastRebuildTime, [IndexIsOutdated] = @IndexIsOutdated, [IndexProvider] = @IndexProvider
WHERE [IndexID] = @IndexID
Caused exception:
Cannot insert the value NULL into column 'IndexProvider', table 'eurobank_dev_new.dbo.CMS_SearchIndex'; column does not allow nulls. UPDATE fails.
The statement has been terminated.
Exception type: System.Exception
Stack trace:
at CMS.DataEngine.AbstractDataConnection.HandleError(String queryText, Exception ex)
at CMS.DataEngine.AbstractDataConnection.ExecuteQuery(String queryText, QueryDataParameters queryParams, QueryTypeEnum queryType, Boolean requiresTransaction)
at CMS.DataEngine.GeneralConnection.RunQuery(QueryParameters query)
at CMS.DataEngine.GeneralConnection.RunQueryWithRetry(QueryParameters query, Int32 retryCount)
at CMS.DataEngine.GeneralConnection.ExecuteQuery(QueryParameters query, Int32& totalRecords)
at CMS.DataEngine.DataQueryBase1.GetDataFromDBInternal()
at CMS.DataEngine.DataQueryBase1.GetDataFromDB()
at CMS.DataEngine.DataQueryBase1.GetData()
at CMS.DataEngine.SimpleDataClass.Update()
at CMS.DataEngine.AbstractInfoBase1.UpdateData()
at CMS.DataEngine.AbstractInfoProvider3.SetInfo(TInfo info)
at CMS.Search.SearchIndexInfoProvider.SetSearchIndexInfoInternal(SearchIndexInfo searchIndex)
at CMS.Search.SearchIndexInfo.SetObject()
at CMS.CMSImportExport.ImportProvider.ProcessMainObject(SiteImportSettings settings, GeneralizedInfo infoObj, ImportParameters parameters)
at CMS.CMSImportExport.ImportProvider.ImportObject(SiteImportSettings settings, GeneralizedInfo infoObj, ImportParameters parameters, List1 importedParentIds)
at CMS.CMSImportExport.ImportProvider.ImportObjects(SiteImportSettings settings, DataSet data, String objectType, Boolean siteObject, TranslationHelper th, Boolean importChild, ProcessObjectEnum processType, List1 importedParentIds)
at CMS.CMSImportExport.ImportProvider.ImportObjectType(SiteImportSettings settings, String objectType, Boolean siteObject, TranslationHelper th, ProcessObjectEnum processType, List1 importedParentIds)
at CMS.CMSImportExport.ImportProvider.ImportObjectsDataInternal(SiteImportSettings settings)
Message: Cannot insert the value NULL into column 'IndexProvider', table 'eurobank_dev_new.dbo.CMS_SearchIndex'; column does not allow nulls. UPDATE fails.
The statement has been terminated.
Exception type: System.Data.SqlClient.SqlException
Stack trace:
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
at System.Data.SqlClient.SqlDataReader.get_MetaData()
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
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.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.DataEngine.AbstractDataConnection.ExecuteQuery(String queryText, QueryDataParameters queryParams, QueryTypeEnum queryType, Boolean requiresTransaction)
ERROR: Error importing 'Smart search indexes' objects (IT - Forums)
Message:
UPDATE CMS_SearchIndex SET [IndexSettings] = @IndexSettings, [IndexLastModified] = @IndexLastModified, [IndexLastRebuildTime] = @IndexLastRebuildTime, [IndexIsOutdated] = @IndexIsOutdated, [IndexProvider] = @IndexProvider
WHERE [IndexID] = @IndexID
Caused exception:
Cannot insert the value NULL into column 'IndexProvider', table 'eurobank_dev_new.dbo.CMS_SearchIndex'; column does not allow nulls. UPDATE fails.
The statement has been terminated.