String or binary data would be truncated

[nickc]

Just installed Live meeting, and look at my cool new user-agent string:

Code: Select all

Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 1.0.3705; .NET CLR 1.1.4322; Media Center PC 4.0; .NET CLR 2.0.50727; InfoPath.2; .NET CLR 3.0.04506.30; .NET CLR 3.0.04506.648; .NET CLR 3.5.21022; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729; MS-RTC LM 8)

It's a nifty 266 characters long!

Oops... Able no likely...

Code: Select all

[SqlException (0x80131904): String or binary data would be truncated. The statement has been terminated.]
 ...
   CommerceBuilder.Reporting.PageView.Save() +1469
 ...

Recommend changing all columns in ac_PageViews with nvarchar(255) to nvarchar(MAX).

[jmestep]

Does that happen even with this patch in the Global.asax?

protected void Session_OnStart()
{
//SAVE THE REFERRER FOR USE BY THE ORDER MODULE
if (Request.UrlReferrer != null) Session["SessionReferrerUrl"] = StringHelper.Truncate(Request.UrlReferrer.ToString(), 255);
}

[nickc]

Yes, the UA is being written as ac_PageViews.UserAgent.
It would be nice if one could disconnect the page logging in Able completely. It lacks the notion of session; I've written a custom logger that does session, records common objects (like product page views) as separate columns, also can be used to capture ad-hoc events (button, link clicks; other specific actions; etc.). Splitting into 2 tables (SessionLog, PageViewLog) makes page view storage more compact as session data is not stored in every PageView record - just the session id.
This one was a head scratcher because I expected it to be the referrer - except IE was failing while FF worked.
MS appears to be using the UA as a dumping ground for installed .NET versions - Live Meeting pushed it over the edge.
No way of knowing how many site users may have encountered this in the past, but I'm guessing the long UA is not that common.