Failed to import user

Jon Tibbetts asked on March 10, 2015 18:47

Hi I have the following stack trace. Failed to import user... both kentico systems are 8.1.6

ERROR: Error importing 'Users' objects (espn) Message:

INSERT INTO CMS_UserSettings ([UserNickName], [UserPicture], [UserSignature], [UserURLReferrer], [UserCampaign], [UserMessagingNotificationEmail], [UserCustomData], [UserRegistrationInfo], [UserPreferences], [UserActivationDate], [UserActivatedByUserID], [UserTimeZoneID], [UserAvatarID], [UserBadgeID], [UserShowSplashScreen], [UserActivityPoints], [UserForumPosts], [UserBlogComments], [UserGender], [UserDateOfBirth], [UserMessageBoardPosts], [UserSettingsUserGUID], [UserSettingsUserID], [WindowsLiveID], [UserBlogPosts], [UserWaitingForApproval], [UserDialogsConfiguration], [UserDescription], [UserUsedWebParts], [UserUsedWidgets], [UserFacebookID]) VALUES (@UserNickName, @UserPicture, @UserSignature, @UserURLReferrer, @UserCampaign, @UserMessagingNotificationEmail, @UserCustomData, @UserRegistrationInfo, @UserPreferences, @UserActivationDate, @UserActivatedByUserID, @UserTimeZoneID, @UserAvatarID, @UserBadgeID, @UserShowSplashScreen, @UserActivityPoints, @UserForumPosts, @UserBlogComments, @UserGender, @UserDateOfBirth, @UserMessageBoardPosts, @UserSettingsUserGUID, @UserSettingsUserID, @WindowsLiveID, @UserBlogPosts, @UserWaitingForApproval, @UserDialogsConfiguration, @UserDescription, @UserUsedWebParts, @UserUsedWidgets, @UserFacebookID); SELECT SCOPE_IDENTITY() AS [ID]

Caused exception: Invalid column name 'UserShowSplashScreen'.

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.ExecuteQuery(QueryParameters query) at CMS.DataEngine.GeneralConnection.ExecuteQuery(QueryParameters query, Int32& totalRecords) at CMS.DataEngine.DataQueryBase1.GetDataFromDB() at CMS.DataEngine.DataQueryBase1.GetData() at CMS.DataEngine.DataQueryBase1.Execute() at CMS.DataEngine.SimpleDataClass.Insert(Boolean getId) at CMS.DataEngine.AbstractInfo1.InsertData() at CMS.DataEngine.AbstractInfoProvider2.SetInfo(TInfo info) at CMS.Membership.UserSettingsInfoProvider.SetUserSettingsInfoInternal(UserSettingsInfo userSettings) at CMS.Membership.UserInfoProvider.SetUserInfoInternal(UserInfo user) at CMS.CMSImportExport.ImportProvider.SetObject(SiteImportSettings settings, GeneralizedInfo infoObj, GeneralizedInfo parentInfo, List1 importedObjects) at CMS.CMSImportExport.ImportProvider.ProcessMainObject(SiteImportSettings settings, GeneralizedInfo infoObj, GeneralizedInfo parentObject, TranslationHelper th, ImportParameters parameters) at CMS.CMSImportExport.ImportProvider.UpdateObject(SiteImportSettings settings, GeneralizedInfo infoObj, Boolean siteObject, DataSet data, TranslationHelper th, Boolean updateChildren, ProcessObjectEnum process, List1 importedParentIds, List1 postProcessList, List1 importedObjects, GeneralizedInfo parentObject, Boolean postProcessing) at CMS.CMSImportExport.ImportProvider.ImportObjects(SiteImportSettings settings, DataSet data, String objectType, Boolean siteObject, TranslationHelper th, Boolean importChild, ProcessObjectEnum processType, List1 importedParentIds)

Message: Invalid column name 'UserShowSplashScreen'.

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) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource1 completion, Int32 timeout, Task& task, Boolean asyncWrite) 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.DataEngine.AbstractDataConnection.ExecuteQuery(String queryText, QueryDataParameters queryParams, QueryTypeEnum queryType, Boolean requiresTransaction)

ERROR: Error during import process Message:

Caused exception: Invalid column name 'UserShowSplashScreen'.

Message: Invalid column name 'UserShowSplashScreen'.

user import

Correct Answer

Juraj Ondrus answered on March 11, 2015 14:26

Hi,

Was the instance upgraded from an older version? The error is very similar to an issue reported [here].(http://devnet.kentico.com/questions/error-after-upgrade-kentico-from-7-8)

0 votesVote for this answer Unmark Correct answer

Recent Answers

Brenden Kehren answered on March 10, 2015 18:55

Does the site you're importing into contain the UserShowSplashScreen field?

Caused exception: Invalid column name 'UserShowSplashScreen'

0 votesVote for this answer Mark as a Correct answer

Jon Tibbetts answered on March 10, 2015 19:04

I just looked neither of the systems contain a column named UserShowSplashScreen in the CMS.UserSettings table... Can I just go ahead and add this column? Do you know what type it should be?

0 votesVote for this answer Mark as a Correct answer

Jon Tibbetts answered on March 10, 2015 19:05

by the way both kentico cms are 8.1.6 and upgrades were successful in both.

0 votesVote for this answer Mark as a Correct answer

Jon Tibbetts answered on March 12, 2015 20:34

Following the fix provided in that link posted by Juraj was a big help. I can now create users. thanks

0 votesVote for this answer Mark as a Correct answer