[SqlException (0x80131904): Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
The 'sp_getAlbumId' procedure attempted to return a status of NULL, which is not allowed. A status of 0 will be returned instead.]
System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) +3335088
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) +334
System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) +4679
System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) +514
System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) +3392
System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) +725
System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) +551
System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +391
System.Data.Linq.SqlClient.SqlProvider.Execute(Expression query, QueryInfo queryInfo, IObjectReaderFactory factory, Object[] parentArgs, Object[] userArgs, ICompiledSubQuery[] subQueries, Object lastResult) +410
System.Data.Linq.SqlClient.SqlProvider.ExecuteAll(Expression query, QueryInfo[] queryInfos, IObjectReaderFactory factory, Object[] userArguments, ICompiledSubQuery[] subQueries) +189
System.Data.Linq.SqlClient.SqlProvider.System.Data.Linq.Provider.IProvider.Execute(Expression query) +428
DAL.MACDataContext.sp_getAlbumId(String bandUrlFriendlyName, String cDUrlFriendlyName) in c:\inetpub\wwwroot\metalmusicarchives.com\App_Code\DAL\MAC.designer.cs:244
AlbumsBLL.GetAlbumId(String artistUrlFriendlyName, String albumUrlFriendlyName) in c:\inetpub\wwwroot\metalmusicarchives.com\App_Code\BLL\AlbumsBLL.cs:30
[TargetInvocationException: Exception has been thrown by the target of an invocation.]
System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor) +0
System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments) +269
System.Delegate.DynamicInvokeImpl(Object[] args) +160
System.Data.Linq.CommonDataServices.GetKeyFromPredicate(MetaType type, Dictionary`2 keys, Expression mex, Expression vex) +565
System.Data.Linq.CommonDataServices.GetKeysFromPredicate(MetaType type, Dictionary`2 keys, Expression expr) +330
System.Data.Linq.CommonDataServices.GetKeyValues(MetaType type, LambdaExpression predicate) +114
System.Data.Linq.CommonDataServices.GetCachedObject(Expression query) +730
System.Data.Linq.SqlClient.SqlProvider.GetCachedResult(Expression query) +72
System.Data.Linq.SqlClient.SqlProvider.System.Data.Linq.Provider.IProvider.Execute(Expression query) +107
System.Data.Linq.DataQuery`1.System.Linq.IQueryProvider.Execute(Expression expression) +51
AlbumsBLL.GetAlbum(String artistUrlFriendlyName, String albumUrlFriendlyName) in c:\inetpub\wwwroot\metalmusicarchives.com\App_Code\BLL\AlbumsBLL.cs:36
Album.LoadContextObjects() in c:\inetpub\wwwroot\metalmusicarchives.com\Album.aspx.cs:29
BasePage.Page_PreInit(Object sender, EventArgs e) in c:\inetpub\wwwroot\metalmusicarchives.com\App_Code\BasePage.cs:26
System.EventHandler.Invoke(Object sender, EventArgs e) +0
System.Web.UI.Page.OnPreInit(EventArgs e) +11692096
System.Web.UI.Page.PerformPreInit() +47
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +335
|