Masthead image for
Banner image for Cutting a Useragent's Value When It Exceeds the Maximum Possible Length for xDB Databases article

It's taken years of managing Sitecore sites for this one to come across my desk, but apparently there's no protection for the UserAgent value being longer than the maximum allowed length when saving the User's session to the xDB. Though it's fixed since version 10, there's no patch for earlier instances, so we're going to have to add our own pipeline processor to cut the offending UserAgent values short.

Read More
Banner image for Understanding 100% Database Usage Caused by Your Sitecore GenericProcessingPool Table article

While managing an instance of Sitecore I saw a bot got past the excludedUserAgents configuration, which means its traffic is recorded and we don't want that. Flushing the data out is simple with the Analytics Database Manager, but there are cases where there's transient data queued for processing in the GenericProcessingPool table, and it can be a problem.

Read More