I didn't notice a problem with the member directory until after I installed and was configuring the AD-Pro suite from Glanton. I have since removed the suite in an attempt to fix this but the issue still persists.
The module displays, "An error occurred while processing the request:error".
I am logged in with the host account and am attempting to integrate this intranet site with Active Directory.
Version 07.02.02 (303)
2014-06-20 11:18:07,055 [FinWebApps][Thread:9][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.
The column 'Email' was specified multiple times for 'pivotTable'.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 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, TaskCompletionSource`1 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 DotNetNuke.Data.PetaPoco.PetaPocoExt.ExecuteReader(Database database, String sql, Object[] args)
at DotNetNuke.Data.PetaPoco.PetaPocoHelper.ExecuteReader(String connectionString, CommandType type, String sql, Object[] args)
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)
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)
at DotNetNuke.Modules.MemberDirectory.Services.MemberDirectoryController.AdvancedSearch(Int32 userId, Int32 groupId, Int32 pageIndex, Int32 pageSize, String searchTerm1, String searchTerm2, String searchTerm3, String searchTerm4)
ClientConnectionId:e10c9009-d6a7-4439-961b-f51a60ffbcb0