Was the member directory functioning before you did your bulk import?

What tool did you use to bulk import?

Its possible that the bulk import has corrupted some values that the member directory is expecting to see?

Did you attempt to rename any of the core user profile elements?

Westa

Hi,

I found the following error in the logs.

<br>2013-08-15 08:24:24,124 [][Thread:11][ERROR] DotNetNuke.Modules.MemberDirectory.Services.MemberDirectoryController - System.Data.SqlClient.SqlException (0x80131904): The column name "Email" specified in the PIVOT operator conflicts with the existing column name in the PIVOT argument.
<br>The column 'Email' was specified multiple times for 'pivotTable'.
<br>   at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
<br>   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
<br>   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
<br>   at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
<br>   at System.Data.SqlClient.SqlDataReader.get_MetaData()
<br>   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
<br>   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite)
<br>   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
<br>   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
<br>   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
<br>   at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
<br>   at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
<br>   at DotNetNuke.Data.PetaPoco.PetaPocoExt.ExecuteReader(Database database, String sql, Object[] args)
<br>   at DotNetNuke.Data.SqlDataProvider.ExecuteReader(String procedureName, Object[] commandParameters)
<br>   at DotNetNuke.Data.DataProvider.GetUsersAdvancedSearch(Int32 portalId, Int32 userId, Int32 filterUserId, Int32 fitlerRoleId, Int32 relationTypeId, Boolean isAdmin, Int32 pageIndex, Int32 pageSize, String sortColumn, Boolean sortAscending, String propertyNames, String propertyValues)
<br>   at DotNetNuke.Security.Membership.AspNetMembershipProvider.GetUsersAdvancedSearch(Int32 portalId, Int32 userId, Int32 filterUserId, Int32 filterRoleId, Int32 relationshipTypeId, Boolean isAdmin, Int32 pageIndex, Int32 pageSize, String sortColumn, Boolean sortAscending, String propertyNames, String propertyValues)
<br>   at DotNetNuke.Entities.Users.Internal.UserControllerImpl.GetUsersAdvancedSearch(Int32 portalId, Int32 userId, Int32 filterUserId, Int32 filterRoleId, Int32 relationshipTypeId, Boolean isAdmin, Int32 pageIndex, Int32 pageSize, String sortColumn, Boolean sortAscending, String propertyNames, String propertyValues)
<br>   at DotNetNuke.Modules.MemberDirectory.Services.MemberDirectoryController.AdvancedSearch(Int32 userId, Int32 groupId, Int32 pageIndex, Int32 pageSize, String searchTerm1, String searchTerm2, String searchTerm3, String searchTerm4)

Now I was wondering how can I change the pivot table?

Can i  delete the email property?