Here's the full error:

AssemblyVersion:7.3.2

PortalID:-1

PortalName:

UserID:-1

UserName:

ActiveTabID:-1

ActiveTabName:

RawURL:

AbsoluteURL:

AbsoluteURLReferrer:

UserAgent:

DefaultDataProvider:DotNetNuke.Data.SqlDataProvider, DotNetNuke

ExceptionGUID:eecde0fe-15fd-484a-a2c9-3891a2b5a1eb

InnerException:Conversion failed when converting the nvarchar value 'SELECT * FROM (SELECT U.UserID, U.DisplayName, U.LastModifiedOnDate, V.[Prefix],V.[FirstName],V.[MiddleName],V.[LastName],V.[Suffix],V.[Unit],V.[Street],V.[City],V.[Region],V.[Country],V.[PostalCode],V.[Telephone],V.[Cell],V.[Fax],V.[Website],V.[IM],V.[Biography],V.[PreferredTimeZone],V.[PreferredLocale],V.[Photo], ROW_NUMBER() OVER(ORDER BY U.UserID) AS RowNum FROM ( SELECT UserID, PropertyName, PropertyValue + '$$$' + CAST(Visibility AS VARCHAR(5)) + '$$$' + ExtendedVisibility + '$$$' + CONVERT(VARCHAR(20), LastUpdatedDate, 20) AS PropertyValue FROM dbo.[vw_Profile] WHERE Deleted = 0 AND (PortalID ' to data type int.

FileName:

FileLineNumber:0

FileColumnNumber:0

Method:System.Data.SqlClient.SqlConnection.

StackTrace:

Message:

System.Data.SqlClient.SqlException (0x80131904): Conversion failed when converting the nvarchar value 'SELECT * FROM (SELECT U.UserID, U.DisplayName, U.LastModifiedOnDate, V.[Prefix],V.[FirstName],V.[MiddleName],V.[LastName],V.[Suffix],V.[Unit],V.[Street],V.[City],V.[Region],V.[Country],V.[PostalCode],V.[Telephone],V.[Cell],V.[Fax],V.[Website],V.[IM],V.[Biography],V.[PreferredTimeZone],V.[PreferredLocale],V.[Photo], ROW_NUMBER() OVER(ORDER BY U.UserID) AS RowNum FROM ( SELECT UserID, PropertyName, PropertyValue + '$$$' + CAST(Visibility AS VARCHAR(5)) + '$$$' + ExtendedVisibility + '$$$' + CONVERT(VARCHAR(20), LastUpdatedDate, 20) AS PropertyValue FROM dbo.[vw_Profile] WHERE Deleted = 0 AND (PortalID ' to data type int.
at System.Data.SqlClient.SqlConnection. (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.GetAvailableUsersForIndex(Int32 portalId, DateTime startDate, Int32 startUserId, Int32 numberOfUsers)
at DotNetNuke.Services.Search.UserIndexer.GetSearchDocuments(Int32 portalId, DateTime startDate)
ClientConnectionId:5be0c0a4-76fa-4d8f-988d-1f0dd885221e


Source:

Server Name: SQL