System.Data.SqlClient.SqlException error on admin homepage?


InstantForum Problem
My forum has worked great for over a year and all the sudden, I'm getting the following error on the homepage of and admin section. I have not changed anything in the code or the database...Anyone have any ideas???

Detailed error information follows:

Date and Time: 9/10/2008 6:51:01 PM
Machine Name: xxx-WEBSERVER
Process User: NT AUTHORITY\NETWORK SERVICE
Remote User: chris@xxxxxx.com
Remote Address: 10.xxxxxxxx
Remote Host: 10.xxxxxxxx
URL: https://xxxxxxm.com/fishingforum/Admin/AdminHome.aspx

NET Runtime version: 1.1.4322.2407
Application Domain: /LM/W3SVC/2104022981/Root/fishingforum-1-128655348563804965

Assembly Version BuildDate
-------- ------- ---------
mscorlib.dll 1.0.5000.0 4/18/2007 2:25:10 AM
system.web.dll 1.0.5000.0 9/7/2007 4:40:50 PM
system.dll 1.0.5000.0 9/7/2007 4:40:51 PM
system.xml.dll 1.0.5000.0 5/6/2007 1:20:18 PM
system.web.mobile.dll 1.0.5000.0 5/6/2007 1:20:19 PM
InstantASP.Common.DLL 1.1.3.0 9/26/2007 4:57:19 PM
InstantASP.InstantForum.DLL 4.1.4.0 9/26/2007 4:57:19 PM
InstantASP.Common.Configuration.DLL 1.0.0.0 9/26/2007 4:57:19 PM
microsoft.visualbasic.dll 7.0.5000.0 5/6/2007 1:20:17 PM
system.data.dll 1.0.5000.0 5/6/2007 1:20:18 PM
system.web.regularexpressions.dll 1.0.5000.0 5/6/2007 1:20:18 PM
InstantASP.InstantForum.UI.DLL 4.1.4.0 9/26/2007 4:50:33 PM
InstantASP.InstantForum.Data.DLL 4.1.4.0 9/26/2007 4:50:33 PM
InstantASP.Common.UI.DLL 1.1.2.0 9/26/2007 4:50:33 PM
RadSpell.DLL 1.0.0.0 9/26/2007 4:50:33 PM
system.enterpriseservices.dll 1.0.5000.0 5/6/2007 1:20:17 PM
system.drawing.dll 1.0.5000.0 5/6/2007 1:20:18 PM
InstantASP.Licensing.DLL 1.1.0.0 9/26/2007 4:50:33 PM
InstantForum.DLL 4.1.4.0 9/26/2007 4:50:33 PM
system.web.services.dll 1.0.5000.0 5/6/2007 1:20:18 PM
InstantASP.Common.Data.DLL 1.0.1.0 9/26/2007 4:50:33 PM

Exception Type: System.Data.SqlClient.SqlException
Exception Message: Arithmetic overflow error converting expression to data type int.
Exception Source: .Net SqlClient Data Provider
Exception Target Site: ExecuteReader

---- Stack Trace ----
System.Data.SqlClient.SqlCommand.ExecuteReader(cmdBehavior As CommandBehavior, runBehavior As RunBehavior, returnStream As Boolean)
(unknown file): N 00742
System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
(unknown file): N 00195
InstantASP.Common.Data.Helper.ExecuteSqlServerNonQuery(statement As String, commandType As CommandType, paramCollection As ArrayList, conn As SqlConnection, CommandTimeout As Int32)
(unknown file): N 00577
InstantASP.Common.Data.Helper.PrivateExecuteNonQuery(EnumProvider As Providers, statement As String, commandType As CommandType, paramCollection As ArrayList, conn As IDbConnection, CommandTimeout As Int16)
(unknown file): N 00057
InstantASP.Common.Data.Helper.ExecuteNonQuery(EnumProvider As Providers, statement As String, commandType As CommandType, paramCollection As ArrayList, conn As IDbConnection, CommandTimeout As Int16)
(unknown file): N 00036
InstantASP.InstantForum.Data.DataProvider.SelectCurrentLength(UserID As Int32)
(unknown file): N 00398
InstantASP.InstantForum.Business.Attachments.CurrentLength()
(unknown file): N 00094
InstantASP.InstantForum.UI.Controls.AdminAppOverview.InitializeControls()
(unknown file): N 00631
InstantASP.InstantForum.UI.Controls.AdminAppOverview.Initialize(ctlSkin As Control)
(unknown file): N 01002
InstantASP.Common.UI.Base.Skin.CreateChildControls()
(unknown file): N 00071
InstantASP.InstantForum.UI.Skinning.Base.CreateChildControls()
(unknown file): N 00075
System.Web.UI.Control.EnsureChildControls()
(unknown file): N 00100
System.Web.UI.Control.PreRenderRecursiveInternal()
(unknown file): N 00038
System.Web.UI.Control.PreRenderRecursiveInternal()
(unknown file): N 00125
System.Web.UI.Control.PreRenderRecursiveInternal()
(unknown file): N 00125
System.Web.UI.Control.PreRenderRecursiveInternal()
(unknown file): N 00125
System.Web.UI.Control.PreRenderRecursiveInternal()
(unknown file): N 00125
System.Web.UI.Control.PreRenderRecursiveInternal()
(unknown file): N 00125
System.Web.UI.Page.ProcessRequestMain()
(unknown file): N 01499
InstantForum Problem

The error suggests that some value in the system is either too big to be contained within the "int" type (which is pretty huge), or that an expected integer value is not correctly formatted (a string somehow where there should be an int), I've not seen this one before, have you opened a support ticket?

Kindest Regards,

James Trott

Thanks for the reply. No, I have not opened a support ticket but can.



Chris

Bump.... I did submit a support ticket on this and have not heard anything. I sent Ryan the requested information in an e-mail as well.



If you guys need access to the servers, let me know!

I always try to give the same advice on errors such as this, we are definately looking into it, but coupled with existing workloads, errors of this nature are tough to reproduce and take some time to investigate, thanks for the offer of access, I'll point Ryan over here incase it would assist his investigation to do so.

Kindest Regards,

James Trott

Hi Chris,

Hope your very well. Many thanks for your post. I'm sorry to hear of the trouble. After some investigation this looks like an issue that may effect InstantForum.NET 4.1.4 if you have a very large number of attachments.

I've attached to this post (below) an updated assembly which may help resolve the problem. This assembly should work with either InstantForum.NET 4.1.4 or InstantForum.NET SP1. Before you apply the DLL file please ensure you backup your current InstantASP.InstantForum.Data.dll file should you run into any problems.

Please let me know if the attached assembly helps. I look forward to your response and assisting further, This update will of course also be included in the forthcoming InstantForum.NET 4.2 update should it prove successful.

I look forward to your response and assisting further :)

http://www.instantasp.co.uk/images/line.gif
Kindest Regards,

Ryan Healey



ryan@instantasp.co.uk
www.instantasp.co.uk
Blog | Community | Docs

http://www.instantasp.co.uk/core/assets/images/email/facebook.png http://www.instantasp.co.uk/core/assets/images/email/twitter.png http://www.instantasp.co.uk/core/assets/images/email/google.png http://www.instantasp.co.uk/core/assets/images/email/linkedin.png

Attachments
InstantASP.InstantForum.Data.zip (194 views, 22.00 KB)

Thanks for the update. I will backup the existing DLL and put this one in it's place tomorrow and I will let you know the outcome!



Chris

Hi All,

I know this is quite an old topic, but I just came across a similar issues. Unfortunately for me the updated DLL didn't fix the problem, but I was able to track it down to the Content size instead of the number of attachments.

The solution for me was to simply edit the Stored Procedure: if_sp_SelectCurrentLength and change the int's to BigInt as such:

ALTER PROCEDURE [dbo].[if_sp_SelectCurrentLength] (@intUserID int,
@intCurrentLength Bigint output
)
AS
SET
NOCOUNT ON

/* Returns the total current length for all attachments and all attachments associated to a specific user */

IF (@intUserID >= 0)
BEGIN
SET @intCurrentLength = (SELECT SUM(CAST(InstantForum_Attachments.ContentLength AS BIGINT)) FROM InstantForum_Attachments (nolock) WHERE InstantForum_Attachments.UserID = @intUserID)
END
ELSE
IF (@intUserID < 0)
BEGIN
SET @intCurrentLength = (SELECT SUM(CAST(InstantForum_Attachments.ContentLength AS BIGINT)) FROM InstantForum_Attachments (nolock))
END



Thanks for sharing Phophet. I hope your well.

We've been heads down recently working on some significant updates. 'This includes the next InstantForum update. I'll ensure we take the comments on board from this thread and update this stored procedures to ensure this wont' affect others in the future.

If we can assist with anything further fo course please don't hesitate to respond,

http://www.instantasp.co.uk/images/line.gif
Kindest Regards,

Ryan Healey



ryan@instantasp.co.uk
www.instantasp.co.uk
Blog | Community | Docs

http://www.instantasp.co.uk/core/assets/images/email/facebook.png http://www.instantasp.co.uk/core/assets/images/email/twitter.png http://www.instantasp.co.uk/core/assets/images/email/google.png http://www.instantasp.co.uk/core/assets/images/email/linkedin.png
GO

Login
Existing Account
Email Address:


Password:


Social Logins

Select a Forum....







InstantASP Forums


Search