Is your DBBrowser.aspx page looping indefinitely ?

We all use Sitecore Admin Pages and DBBrowser is probably not the most frequent one. But  how many times DBBrowser.aspx saved your a.. when you needed?  When I joined my current team I notice that this Admin Page was looping indefinitely.  If that page is not responding for you, maybe you have same issue .

My colleague – Sébastien Boissonneault– found the source of the issue. Here is his blog entry.

DBBrowser is a great tool to investigate and fix content issues that would not be doable through the content editor.

 

On our project, for a while, me and my team were wondering why the DBBrowser would not load. And by not loading, I mean seeing a blank page, the process using all of the CPU cycles and way too much memory, for many hours (if we would let it run that long).

We attached to the process in Visual Studio to see if some code was throwing errors and failing silently, but with no success. We looked at the database and database profiler to see a sign of request taking too long, still no success. And then we looked at the source code for that page in DotPeek.

 

At first, by quickly glancing at the code, it looked fine, but I knew something was wrong. I created a copy of the dbbrowser aspx page, created a copy of the code-behind it was using and then started debugging. After waiting a while, when I finally paused the process, like a beacon of light pointing to the, I found the code issue highlighted: an infinite loop.

 

It is caused by a function that lists and sorts the branch templates by item name (independently of the folder they are located). That code has a loop that renames duplicates in the list, the problem is that if there was more than 2 duplicates, it loops forever.

 

I fixed the bug in my local copy, and it now runs like a charm.

 

I was able to reproduce the issue with a vanilla instance of Sitecore, so I created a support ticket and am now waiting for an official fix.

 

 

xDB Cloud service REST API explained

How to use REST API reference for the xDB Cloud service is described well here. But for someone it will use it for the first time may not be that obvious. Here is a description “for dummies”.

First we have to obtain valid authentication token to make a call to xDB Cloud API. it must to be included as a HTTP header in all requests. Here are a description of this call.  I use Fiddler as a tool.

Continue reading

How to track from where visitor downloaded a PDF file

For the Website owner it is important to know how the data is accessed in order to understand the flow. This information will be used in Website personalization process to optimize.  For the content page we can use Path Analyzer.  For media assets it is a different story.  In our case a visitor cans download from landing page, case study detail page and search results page. He has to find a way how to track in xDB all PDF downloads regardless from where the visitor access it.

Continue reading

Sitecore 8.2 Rendering Issues

We experienced issues with shared layout on few of our pages. Presentation assembling seemed not following Presentation Detail Information Flow.

Based on Sitecore documentation this is a flow

rendering

 

  • SharedLayout option uses __Rendering field
  • FinalLayout option uses __Final Rendering field
  • Going from right to left, if a field has a layout delta, it goes to the field to its left to gather more presentation information.

After the investigation we noticed that on Save Button click in Experience Editor, the full share layout is saved and not the delta in __rendering fields. ( in case when a page is inheriting renderings from standards values).

Sitecore provided us with a patch. You can request one – the reference number is 144214

Is your xDB Cloud Consumption plan right for you ?

When I join my current project first thing I did as architect is an audit.  Make sure that architecture is optimized for current traffic and all best practices has been followed.  The client website use Sitecore xDB Cloud with xDB Plus subscription. It allows you up to 250 000 contacts at anytime and up to 2 500 000 interactions per month.

Contacts

How it’s measured: Total identified contact stored at any time.

Interactions

How it’s measured: Net new interaction created in a given period of time.

I check our current consumption to find out that we can switch to xDB base subscription and pay 30% of what are paying right now.

In some cases you better pay overage price before switch to the next subscription plan.

2017-10-24 11_42_15-xDB - Sales Enablement - March 2015 V2.pptx [Protected View] - PowerPoint

In case you want to generate your own reports or load data directly from mongo, you can access to your xDB database using and mongo viewer application.
Open your connectionstrings.config file and find the “analytics” connection string:
mongodb://{user-name}:{password}@{host1}:{port1},{host2}:{port2}/{guid}-Analytics?ssl=true;replicaSet={hostX}
You have replicaset on XdbCloud so use the host1 and port1 to connect.
Set up values in the following way:

con 2

con 2

But the best approche is to use  sitecore xDB Cloud API

https://gateway-xdb-scs.cloud.sitecore.net/api/xdb/Consumption/licenseId/deploymentId/year/month

where

  • licenseId – your Sitecore license ID
  • deploymentId – the unique identification of the deployment
  • year – the consumption year
  • month – the consumption month

Important

To ensure that your customers only access their own xDB sets, you must use a valid authentication token whenever you make a call to the xDB Cloud API. You can generate these tokens by using a valid Sitecore license file to call the SSO Encode Sitecore License endpoint. You must include the generated token as a HTTP header in all other requests called X-ScS-Nexus-Auth.

Visit this page -> xDB Cloud Consumption