Hugh Jazz Posted October 25, 2005 Share Posted October 25, 2005 Tried to access my pocket queries page and this was the result instead. Looks like "too many arguments" were supplied. I try not to get into too many arguments but I guess my argumentative nature finally caught up with me :-) Server Error in '/' Application. Procedure or function sppq_GetCacheQueries_ByUserID has too many arguments specified. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Data.SqlClient.SqlException: Procedure or function sppq_GetCacheQueries_ByUserID has too many arguments specified. Source Error: An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. Stack Trace: [sqlException: Procedure or function sppq_GetCacheQueries_ByUserID has too many arguments specified.] System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream) +742 System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) +45 System.Data.SqlClient.SqlCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) +5 System.Data.Common.DbDataAdapter.FillFromCommand(Object data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +304 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +77 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) +38 Groundspeak.Web.SqlData.SqlConnectionManager.FillDataSet(String sql, Database database, Int32 Timeout) +209 Groundspeak.Web.SqlData.SqlPocketQueryController.GetCacheQueryDataByUserWithFilter(Int64 UserID, String FilterSpec) +120 Groundspeak.Web.PocketQueries.GeocacheQuery.GetQueriesByUser(Int64 UserID, String PQFilterType) +94 Geocaching.PQListControl.GenerateList() +115 Geocaching.UI.pocket_default.Page_UserLoggedIn(Object sender, EventArgs e) +532 Geocaching.UI.WebformBase.IsLoggedIn() +1048 Geocaching.UI.pocket_default.Page_Load(Object sender, EventArgs e) +99 System.Web.UI.Control.OnLoad(EventArgs e) +67 System.Web.UI.Control.LoadRecursive() +35 System.Web.UI.Page.ProcessRequestMain() +772 Version Information: Microsoft .NET Framework Version:1.1.4322.2032; ASP.NET Version:1.1.4322.2032 Link to comment
+the hermit crabs Posted October 25, 2005 Share Posted October 25, 2005 I was just about to post the same message... Link to comment
+Moose Mob Posted October 25, 2005 Share Posted October 25, 2005 me too. Server Error in '/' Application. -------------------------------------------------------------------------------- Procedure or function sppq_GetCacheQueries_ByUserID has too many arguments specified. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Data.SqlClient.SqlException: Procedure or function sppq_GetCacheQueries_ByUserID has too many arguments specified. Source Error: . . . Link to comment
Jeremy Posted October 25, 2005 Share Posted October 25, 2005 Corrected. The database was adjusted during the patch and wasn't corrected in production. Link to comment
+the hermit crabs Posted October 25, 2005 Share Posted October 25, 2005 (edited) Still not working for me -- is there anything we need to do on our end? I tried logging out and back in, but still no go. edit: it's a different error message this time: Server Error in '/' Application. Invalid object name 'dbo.CsvToInt'. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Data.SqlClient.SqlException: Invalid object name 'dbo.CsvToInt'. Source Error: An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. Stack Trace: [sqlException: Invalid object name 'dbo.CsvToInt'.] System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream) +742 System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) +45 System.Data.SqlClient.SqlCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) +5 System.Data.Common.DbDataAdapter.FillFromCommand(Object data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +304 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +77 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) +38 Groundspeak.Web.SqlData.SqlConnectionManager.FillDataSet(String sql, Database database, Int32 Timeout) +209 Groundspeak.Web.SqlData.SqlPocketQueryController.GetCacheQueryDataByUserWithFilter(Int64 UserID, String FilterSpec) +120 Groundspeak.Web.PocketQueries.GeocacheQuery.GetQueriesByUser(Int64 UserID, String PQFilterType) +94 Geocaching.PQListControl.GenerateList() +115 Geocaching.UI.pocket_default.Page_UserLoggedIn(Object sender, EventArgs e) +532 Geocaching.UI.WebformBase.IsLoggedIn() +1080 Geocaching.UI.pocket_default.Page_Load(Object sender, EventArgs e) +99 System.Web.UI.Control.OnLoad(EventArgs e) +67 System.Web.UI.Control.LoadRecursive() +35 System.Web.UI.Page.ProcessRequestMain() +750 Edited October 25, 2005 by the hermit crabs Link to comment
Hugh Jazz Posted October 25, 2005 Author Share Posted October 25, 2005 Oops... Now I'm getting a different error: Server Error in '/' Application. Invalid object name 'dbo.CsvToInt'. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Data.SqlClient.SqlException: Invalid object name 'dbo.CsvToInt'. Source Error: An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. Stack Trace: [sqlException: Invalid object name 'dbo.CsvToInt'.] System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream) +742 System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) +45 System.Data.SqlClient.SqlCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) +5 System.Data.Common.DbDataAdapter.FillFromCommand(Object data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +304 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +77 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) +38 Groundspeak.Web.SqlData.SqlConnectionManager.FillDataSet(String sql, Database database, Int32 Timeout) +209 Groundspeak.Web.SqlData.SqlPocketQueryController.GetCacheQueryDataByUserWithFilter(Int64 UserID, String FilterSpec) +120 Groundspeak.Web.PocketQueries.GeocacheQuery.GetQueriesByUser(Int64 UserID, String PQFilterType) +94 Geocaching.PQListControl.GenerateList() +115 Geocaching.UI.pocket_default.Page_UserLoggedIn(Object sender, EventArgs e) +532 Geocaching.UI.WebformBase.IsLoggedIn() +1080 Geocaching.UI.pocket_default.Page_Load(Object sender, EventArgs e) +99 System.Web.UI.Control.OnLoad(EventArgs e) +67 System.Web.UI.Control.LoadRecursive() +35 System.Web.UI.Page.ProcessRequestMain() +750 Link to comment
+Raine Posted October 25, 2005 Share Posted October 25, 2005 If at first you don't succeed, try try again! Link to comment
Jeremy Posted October 25, 2005 Share Posted October 25, 2005 In other words, the problem has been fixed. Link to comment
Hugh Jazz Posted October 25, 2005 Author Share Posted October 25, 2005 Thanks... It 'Worky' just fine now. Link to comment
South Surrey Scavengers Posted October 25, 2005 Share Posted October 25, 2005 It seems that all of my pocket queries have disappeared (about 10). Link to comment
+the hermit crabs Posted October 25, 2005 Share Posted October 25, 2005 I used to have 8 or 10 PQs set up... now I'm down to 4... the others have disappeared. Link to comment
+fizzymagic Posted October 25, 2005 Share Posted October 25, 2005 In other words, the problem has been fixed. Um, no. All my saved pocket queries have disappeared, except one. Link to comment
+Raine Posted October 25, 2005 Share Posted October 25, 2005 Try checking again. Filtering was enabled so they might have been excluded. Link to comment
+the hermit crabs Posted October 25, 2005 Share Posted October 25, 2005 Looks good now Link to comment
Recommended Posts