unhandled SQL exception, IE8 only help!

For general questions and discussions specific to the AbleCommerce 7.0 Asp.Net product.
Post Reply
User avatar
William_firefold
Commander (CMDR)
Commander (CMDR)
Posts: 186
Joined: Fri Aug 01, 2008 8:38 am

unhandled SQL exception, IE8 only help!

Post by William_firefold » Thu Apr 30, 2009 12:51 pm

We have a local customer who cannot access our website on any computers at his office using IE8.
All he gets is our 404. I turn off remote errors and this is the error he gets.
He is unable to load any page of the site, and it 404s even on the default page.
We cannot diagnose this error, and we have checked our server and it is registering errors.
Is there any known conflict between IE8 and ABLE, or IIS that can cause such an error?

ps.His computers are running IE 8.0.6 on windows XP. The website loads for firefox and chrome, but ie8 fails hard.

Code: Select all

String or binary data would be truncated.
The statement has been terminated. 
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: String or binary data would be truncated.
The statement has been terminated.

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 (0x80131904): String or binary data would be truncated.
The statement has been terminated.]
   System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +1950890
   System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +4846875
   System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +194
   System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +2392
   System.Data.SqlClient.SqlDataReader.ConsumeMetaData() +33
   System.Data.SqlClient.SqlDataReader.get_MetaData() +83
   System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +297
   System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) +954
   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +162
   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +32
   System.Data.SqlClient.SqlCommand.ExecuteScalar() +139
   Microsoft.Practices.EnterpriseLibrary.Data.Database.DoExecuteScalar(DbCommand command) +179
   Microsoft.Practices.EnterpriseLibrary.Data.Database.ExecuteScalar(DbCommand command) +69
   CommerceBuilder.Reporting.PageView.Save() +1472
   CommerceBuilder.Services.AbleCommerceHttpModule.a(Object A_0, EventArgs A_1) +5110
   System.Web.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +68
   System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +75


Version Information: Microsoft .NET Framework Version:2.0.50727.3082; ASP.NET Version:2.0.50727.3082

User avatar
nickc
Captain (CAPT)
Captain (CAPT)
Posts: 276
Joined: Thu Nov 29, 2007 3:48 pm

Re: unhandled SQL exception, IE8 only help!

Post by nickc » Thu Apr 30, 2009 12:59 pm

CommerceBuilder.Reporting.PageView.Save() +1472
User-Agent is most likely the problem. Update the column in ac_PageViews to nvarchar(max).

viewtopic.php?f=47&t=9684

User avatar
William_firefold
Commander (CMDR)
Commander (CMDR)
Posts: 186
Joined: Fri Aug 01, 2008 8:38 am

Re: unhandled SQL exception, IE8 only help!

Post by William_firefold » Thu Apr 30, 2009 1:19 pm

EUREKA!
This fixed it.Thank you very much.

Post Reply