Usage analytics data capture not happening
I'm trying to get the usage analytics module working (on premises setup). I've configured the reporting db server and updated the web.config for the front end server to capture the data. I'm also able to see the analytics page (that hopefully proves that I don't haven any issues connecting to the db server from the front end application).
Here's the problem.. I don't see any data getting collected for any queries being made on the front end server. Any ideas on what I might be missing?
Thanks in advance!
Did you configure the analytics settings in the web.config manually or via the Do more menu > Configure Front-End page? Via the configuration page, there is a test button that tries to connect to the SQL database using the provided connection string. Does the test succeed?
Also, the "Integrated Security=SSPI" option in the connection string does not always work. Even if the test button succeeds, the real connection to log actions may fail, because SQL Server may prevent logins from the application pool's identity (e.g. Network Service). In this case, replacing "Integrated Security=SSPI" in the connection string with "User ID=TheUsernameToUseHere;Password=ThePasswordHere" may help.
Seeing the Analytics link in the top bar of the search page does not mean that the connection to the SQL database succeeds.
Finally, when the .NET UI tries to log actions to the SQL database but the connection to it fails (this is done in a background thread), if you perform another action in the search page (e.g. clicking in a facet), an error is normally displayed in red at the top of the search page (if the connected user is an administrator). Do you see an error?
p.s. Note that the JS UI (integrated in Sitecore) cannot log actions to the on-premises analytics module.
I did use a username/password in the connection string instead of the SSPI option. I tested using the Configure Front End page, and it was successful. I have not seen any errors on the search page at all.