come on people, no one knows where this error is coming from?
The strange thing is, this appeared after i batch loaded some users using UserImporter.
I checked this post but it doesn't seem like my case, although the userImporter sets the ProfileDefinitionIDs to the default instead of using the specified Portal ProfileDefinitionIDs, Which i rectified in my db.
But what could be causing this problem???
I'm also seeing this in my event log , which query is returning more than one result???
AssemblyVersion
6.2.3
PortalID
-1
PortalName
UserID
-1
UserName
ActiveTabID
-1
ActiveTabName
RawURL
AbsoluteURL
AbsoluteURLReferrer
UserAgent
DefaultDataProvider
DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider
ExceptionGUID
5cb26fe4-de13-4625-84e1-d3d96c4b0b7e
InnerException
Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
The statement has been terminated.
FileName
FileLineNumber
0
FileColumnNumber
0
Method
System.Data.SqlClient.SqlConnection.
StackTrace
Message
System.Data.SqlClient.SqlException: Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
The statement has been terminated.
at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
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)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters)
at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters)
at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, String spName, Object[] parameterValues)
at DotNetNuke.Security.Membership.Data.SqlDataProvider.DeleteUsersOnline(Int32 timeWindow)
at DotNetNuke.Security.Membership.AspNetMembershipProvider.DeleteUsersOnline(Int32 timeWindow)
at DotNetNuke.Entities.Users.UserOnlineController.UpdateUsersOnline()
at DotNetNuke.Entities.Users.PurgeUsersOnline.UpdateUsersOnline()
at DotNetNuke.Entities.Users.PurgeUsersOnline.DoWork()
Source