Page History

Versions Compared

Key

This line was added.
This line was removed.
Formatting was changed.

Table of Contents

maxLevel	2

...

Version 3.1.5 - May 2023

Enhancements:

Tracking Agent:

Support for anonymous access in the modern Tracking Agent
Support for tracking clicks on document links in custom document library columns

Installer:

Support for Windows Server 2022
Support for SQL Server 2022

Administration:

Added the ability to not execute the Portal Tree Updates during maintenance windows

Resolved Issues:

"Object Reference not set to an instance of object" error in the Portal Tree Updates job when processing site welcome pages in SharePoint Online
"Exception has been thrown by the target of an invocation" error in the CardioLog Scheduling Service
"There was a problem retrieving user categories" error when adding new user categories after upgrade to 3.1.4
Pages created by users who are deleted are missing from the Portal Tree in the Analysis Center

Version 3.1.4 - February 2023

Enhancements:

Tracking Agent:

Support for custom claim-based authentication prefixes

Resolved Issues:

Processing the SharePoint portal tree after upgrade takes a long time
The website item filter is reset when changing the date range of the Navigation Summary report
"500 Internal Server Error" on drill down in the Navigation summary report when a custom date range is set
Occasionally incorrect Title/URL appears in the Navigation Summary report
"Cannot resolve the collation conflict" error in the Usage Data Processing job
"Value cannot be null." error when downloading the tracking agent deployment package in the SharePoint Online Adaptor page
"Thread was being aborted" error in Windows Event Viewer when the CardioLog application pool is recycled
"Keyword not supported" error when trying to save the authentication details in the SharePoint 2019 Adaptor page

Version 3.1.3 - August 2022

Enhancements:

UI:

Added support for new Android devices in the Mobile Devices report

Tracking Agent:

Support for triggering surveys programmatically using JavaScript code with the modern Tracking Agent

Resolved Issues:

"The operation failed because an index or statistics with name already exists" error in the Usage Data Processing job
"Failed to get farm sites from Central Admin Center. Getting farm sites directly from the database. Exception: Object reference not set to an instance of an object" error in the SharePoint Tree Adaptor settings page
"No web applications or site collections to load found" error in the Portal Tree Updates job
"Can't initialize web browser" error when exporting reports to PDF
"Sequence contains no elements" error when exporting survey reports to PDF
"(404) Not found error" when selecting custom date range in the date range filter in a generated report view
Occasionally chart images in export to PDF are not positioned correctly
Survey custom theme settings are not displayed properly in SharePoint
When filtering the Unique Users report by a specific user category value, users with no value for this category are included in the report results as well

...

Version 3.1.2 - June 2022

Enhancements:

UI:

Added the ability to export a report to a webpart to SharePoint modern pages

Administration:

New CardioLog Http Module for .NET framework version 4.5 or higher
Export to PDF feature is no longer dependant on Internet Explorer controls on the CardioLog application server
Updated the geolocation IP database
Updated 3rd party packages for Microsoft.Data.OData and System.Text.RegularExpressions to the latest version
Improved HTTP headers configuration

Resolved Issues:

Long explanations do not show up in surveys reports
Survey shows up on the page only after clearing browser cache
Survey font settings are not displayed properly in SharePoint
"An item with the same key has already been added" error in the SharePoint Tree Adaptor page after adding a new adaptor with a name that already exists in the database
"There was a problem retrieving user categories" error when configuring the import of user categories from Active Directory
"Failed to collect SQL statistics. Exception: Cannot insert the value NULL into column 'io_stall_queued_read_ms', table 'CardioLog.dbo.tab_maint_io_stats'" warning in the Usage Data Processing job
"Module initialization failed: CardioLogSurveyAndMessageBar ReferenceError: CardioLogAgentData is not defined" error in the browser console when running a survey
"Request failed when trying to get SharePoint Page related info. Error: Cannot invoke method or retrieve property from null object." error in the browser console when editing rich text fields in SharePoint 2019
Occasionally the modern Tracking Agent does not send a Pageview event when clicking on links from the navigation panel in modern document libraries
Occasionally the modern Tracking Agent sends a Search event with a NULL search term when performing a search on modern pages with the Activity web part
"Cannot read properties of undefined" error in the browser console when filtering a report by user categories
"500 internal server error" in caUser.aspx in the classic Tracking Agent

...

Version 3.1.1 - March 2022

Enhancements:

Administration:

Updated jQuery libraries to the latest version in the CardioLog application
Automatically remove unselected site collections from the tree table in the database

Resolved Issues:

"There is already an object named 'PK_tab_sharepoint_tree_spids' in the database" error when upgrading to version 3.1.0
Encoded characters are displayed in CSV when exporting data for a single widget
"Error during serialization or deserialization using the JSON JavaScriptSerializer. The length of the string exceeds the value set on the maxJsonLength property" error when drilling down to the Visitor Activity report from the Unique users or Visitors by events report
"500 internal server error" in tracking agent /events endpoint when access to internet is blocked on the CardioLog application server by company policy
"SharePoint Item not found" error when drilling down from Unique Users to Visitor Activity report
Manual activation URL in product activation page is not working
"The conversion of the varchar value overflowed an int column" in Usage Data Processing job on SQL 2019
"Arithmetic overflow error converting expression to data type int." error in the fix lost events procedure

...

Version 3.1.0 - January 2022

Enhancements:

UI:

Added the option to exclude file extensions in the Unmodified Document report

Tracking Agent:

Support for tracking the new SharePoint Online Search Experience

Installer:

Support for .NET Framework 4.8

Administration:

Enhanced performance for the automatic data archiving process

Resolved Issues:

"An item with the same key has already been added" error upon saving a new SharePoint tree adaptor with a name that was already used before
Prevent cross-site request forgery
"ERROR: Full validation failed for tab_sharepoint_tree" in the Portal Tree Updates job
tab_sharepoint_tree database table indexes are dropped on error and are not automatically recreated
"System.Data.SqlClient.SqlException (0x80131904): Subquery returned more than 1 value" error in Portal Tree Updates job
"Procedure or function 'stp_eventlog_fix_lost_events' expects parameter '@ptuStartTime', which was not supplied" error when executing stp_eventlog_fix_lost_events in order to map IIS Log Import entries to the tree after upgrade to 3.0.19
Title is not updated in the Analysis Center after changing the welcome page of a site when the Portal Tree Updates job is running in changes mode
Occasionally rows with a blank title value appear in the Page Views By Type table report
Error when applying a Visitor Segments filter to the Inactive Users table report
"Cannot activate online" error in the product activation page when using Chrome

...

Version 3.0.19 - October 2021

Enhancements:

Tracking Agent:

Support for tracking PnP search in SharePoint Online
Support for tracking the creation/deletion/liking of comments in SharePoint Online modern pages
Updated jQuery libraries to the latest version

Administration:

Added the ability to select which SharePoint on premise site collections to track in the SharePoint Tree Adaptor
Automatically exclude SharePoint system URLs such as 'ProcessQuery', '_vti_bin', '_layouts' when importing logs using the IIS Logs Import tool
Enhanced performance for the fix lost events by SharePoint IDs step in the Portal Tree Updates job

Resolved Issues:

Occasionally the modern Tracking Agent does not send a video Play event when the "Play" button is clicked after a video that was auto played was paused
Occasionally the modern Tracking Agent does not send a Pageview event when clicking on a search result located in a renamed document library
"ERROR: duplicated locations - tree Error number: 50000; Proc: stp_sharepoint_tree_persist_spids_validation" error in the Portal Tree Updates job
"429 TOO MANY REQUESTS" error in the Portal Tree Updates job when importing data from SharePoint Online
"Event migration failed: A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - The semaphore timeout period has expired.)" error in the Usage Data Processing job
"[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified at CardioLog.API.IISLogParser.Import" error when importing IIS logs with the IIS Logs Import tool
"SharePointItem not found" error when drilling down on the unique users table widget
"Object reference not set to an instance of an object" error when drilling down on the External Destinations table widget
"Could not retrieve report data: Invalid column name" error in the inactive users table widget when filtering it by visitor segments
"Could not retrieve report data: All queries combined using a UNION operator must have an equal number of expressions" error in the recently viewed table widget
Cached chart images are displayed in preview
Incorrect number of deletions in the Portal Actions chart report
Occasionally widgets with a lot of results that take a while to load are not displayed in the report when exported to PDF
Missing data for the last hour when exporting the page views chart widget to Excel
Incorrect titles in CSV export when exporting the unique users table widget to Excel
Unable to filter by user groups and categories in the Data Export API helper page
The "Include all file extensions" option in the IIS Import Logs tool is not available
Survey edit menu does not load when the survey font style is "Times New Roman"

...

Tracking SharePoint Online by Configuring the CardioLog Analytics Tracking Agent on Azure App Service.

Resolved Issues:

The Title column tooltip is showing description for Type column.
Event Viewer errors: The process cannot access the file 'C:\Program Files\Intlock\CardioLog\CardioLogScheduleServices\Logs\CardioLogServiceComponents.log' because it is being used by another process.
Export to CSV place all data in one row separated by comma.
Reports emails subject shows %20 instead of space.
Columns that are added additionally to report widgets have no tooltips.
Unmodified Documents report widget does not show any data.

...

Version 3.0.17 - December 2020

Enhancements:

UI:

Display the current site title in the Site Statistics feature report page

Tracking Agent:

Support for tracking promoted search results (bookmarks) in SharePoint Online modern sites
Support for tracking non-SharePoint websites with the modern Tracking Agent
Support for mapping URL parameters with the modern Tracking Agent

Installer:

Support for SQL 2019
Support for Windows 2019

Administration:

Built-in support for the Site Statistics feature in SharePoint modern sites
Increased the default SQL timeout to rebuild the tree table indexes

Resolved Issues:

"Failed with error: Cannot convert argument "parameters"" error in the in the tracking agent deployment PowerShell script for SharePoint Online
"Error: PTU post processing failed. System.Data.SqlClient.SqlException (0x80131904): Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding." error in the Portal Tree Updates job
"Transaction (Process ID #) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction." error in the Portal Tree Updates job when using the new tree processing method by SharePoint IDs
"A transport-level error has occurred when receiving results from the server" error in the Portal Tree Updates job when using the new tree processing method by SharePoint IDs
"ERROR: Violation of PRIMARY KEY constraint 'PK__#idsToUp'. Cannot insert duplicate key in object 'dbo.#idsToUpdate'. Error number: 2627; Proc: stp_sharepoint_tree_persist_spids_map_locations" error in the Portal Tree Updates job after changing a site welcome page in SharePoint Online when using the new tree processing method by SharePoint IDs
Occasionally some SharePoint wiki library pages are not being imported to the tree by the Portal Tree Updates system job
"Request to /CardioLog/MarketingSuite/VoiceOfCustomer/RemoveCache.aspx?key=GlobalSettings failed with error: The remote server returned an error: (500) Internal Server Error." error in the CardioLog application log
When the Active User Categories chart report is added to a report template in the Analysis Center, it is not automatically filtered by the selected website item
"Cannot read property 'selectedIndex' of type null" error when using the Visitor Segments filter in default report templates in the Analysis Center
When exporting the Active User Categories table report to CSV the exported file includes the "categoryvalueid" hidden column
Installer fails to grant permissions to the "Everyone" security group on Windows servers with non-English system language
Occasionally system jobs do not start immediately when the service schedule type is set to "Once" after version upgrade
Occasionally surveys that are marked as inactive are still displayed in SharePoint
Occasionally the modern Tracking Agent does not send a pageview event in addition to a search result click event when clicking on documents in SharePoint 2013 customized search pages
Occasionally the modern Tracking Agent sends a search result click event with an incorrect URL in SharePoint Online modern sites global search
Occasionally the modern Tracking Agent sends a search event with an incorrect related event ID in document library search
Occasionally the modern Tracking Agent does not send a search result click events in asset libraries

Version 3.0.16 - August 2020

Enhancements:

UI:

Support for importing metadata information for SharePoint 2016, 2019 and Online via the SharePoint REST API

Tracking Agent:

Support for tracking the Highlighted Content, Document Library and Activity web parts in modern sites in SharePoint Online and SharePoint 2019
Support for tracking list items file attachments in SharePoint 2019 and SharePoint Online classic and modern lists

Administration:

Built-in support for MFA in the tracking agent deployment PowerShell script for SharePoint Online
Automatic deployment of the CardioLog Modern Tracking Agent App for SharePoint 2019 modern sites
Enhanced performance for the fix lost events step in the Portal Tree Updates job
Encrypted extended log files

Resolved Issues:

False alert in the Diagnostics Dashboard for the Portal Tree Updates job when it is scheduled to run weekly over the weekend and the job is completed in the following calendar week
"Error: Handling SharePoint adaptor failed: System.Data.SqlClient.SqlException (0x80131904): ERROR: Violation of PRIMARY KEY constraint 'PK__#idsToUp__3213E83F719F4C79'. Cannot insert duplicate key in object 'dbo.#idsToUpdate'. Error number: 2627; Proc: stp_sharepoint_tree_persist_spids_map_location" error in the Portal Tree Updates job after adding a new site collection when using with the new tree processing method by SharePoint IDs
"Error: Event migration failed: ERROR: Violation of PRIMARY KEY constraint 'PK_tab_event_log'. Cannot insert duplicate key in object 'dbo.tab_event_log'." error in the Usage Data Processing job
When re-selecting a web application that was previously removed from the SharePoint tree adaptor configuration page, the web application is not restored by the Portal Tree Updates job
"Error: Guid should contain 32 digits with 4 dashes" error when filtering a report by website item and the selected language in the UI is German or Spanish
No results found for table widgets when using the Data Export API
Occasionally web applications are marked as deleted in the Analysis Center when the "Failed to get web applications" error occurs in the Portal Tree Updates job
Occasionally pageview events for Asset Library pages are not mapped to the SharePoint tree structure when using the modern agent
Occasionally the modern Tracking Agent does not send a search result click event when the result is not located on the first page in document library search
Occasionally the modern Tracking Agent sends a search event with search results "0" in document library search when a successful search is performed right after a failed search with no results
Occasionally the modern Tracking Agent does not send a pageview event in addition to a search result click event when clicking on documents in SharePoint modern sites search
Occasionally the modern Tracking Agent sends duplicate pageview events for a folder that was clicked on from global search results
Occasionally the modern Tracking Agent does not send a pageview event when navigating from a classic page to a modern list/library
Occasionally the modern Tracking Agent sends search events with search term "0" in SharePoint Online

Version 3.0.15 - April 2020

Enhancements:

UI:

Added options to select the page size (A4/Letter/Custom) and page orientation (Portrait/Landscape) when exporting a report to PDF

Tracking Agent:

Support for tracking the Hero, Quick Links and Image Gallery web parts in modern sites in SharePoint Online and SharePoint 2019

Administration:

Support for forms based authentication in the SharePoint Tree Adaptor configuration page
Improved performance for the Portal Tree Updates job when processing updates in the database
Improved handling of SharePoint duplicate content in the Portal Tree Updates job in changes mode

Resolved Issues:

"Error: System.ArgumentException: The requested value 'Default' cannot be found." error in the Portal Tree Updates when importing data from SharePoint 2016 in Spanish
"Error: System.FormatException: Input string was not in a correct format." error in the Portal Tree Updates when importing data from SharePoint 2016
"Cannot insert the value NULL into column 'SiteSPID', table 'CardioLog.dbo.tab_sharepoint_tree_spids'; column does not allow nulls. UPDATE fails" error in the Portal Tree Updates job when importing data from SharePoint 2013 in DB mode
"Error converting data type nvarchar to bigint." error in the Onsite Search Phrases report when using the modern agent
"Event not found" error in the modern tracking agent when opening folders in document libraries with modern experience in SharePoint Online
"Access is denied" error in IE when using the Site Statistics feature in SharePoint with the modern agent
Survey "Thank you" message does not show up on search result pages upon submit when using the modern agent
"Who should be prompted to take the survey" options are not supported when using the modern agent
Occasionally search and search result click events are not mapped to the SharePoint tree structure when using the modern agent
Occasionally a page view event is registered in the database with a timestamp of the client timezone + 1 when using the modern agent
Occasionally an unnecessary search event is sent when navigating through search results pages for the same search keyword in SharePoint 2016 and SharePoint Online when using the modern agent
Occasionally a page view event for document clicks is sent twice by the modern tracking agent in SharePoint 2019 modern experience libraries
Onsite Searches - Failure Rate report displays the success rate in version 3.0.13

Version 3.0.14 - December 2019

Enhancements:

UI:

Portal Actions report - added filter by content type

Tracking Agent:

Enhanced support for tracking search in SharePoint Online modern sites
Store the query string parameters for SharePoint modern pages
Built-in support for the Site Statistics feature in the CardioLog Modern Tracking Agent

Administration:

Built-in support for switching to a SharePoint DR farm in the Portal Tree Updates job when importing data from SharePoint 2016 and 2019 via the SharePoint REST API
Automatically remove claims based authentication prefix from the user account name in the User and Group Updates and User Category Updates system jobs
Automatically remove claims based authentication prefix from the user account name of content owners in the Portal Tree Updates job
Allow empty values for user categories in the User Category Updates job when importing data from a custom source
Improved performance for the Portal Tree Updates job when importing data from the SharePoint REST API in full mode

Resolved Issues:

"Error: The CREATE UNIQUE INDEX statement terminated because a duplicate key was found for the object name 'dbo.tab_sharepoint_tree_spids' and the index name 'PK_tab_sharepoint_tree_spids'." error in the Portal Tree Updates job when importing data from SharePoint 2013 in DB mode
"Error: The CREATE UNIQUE INDEX statement terminated because a duplicate key was found for the object name 'dbo.tab_sharepoint_tree_spids' and the index name 'PK_tab_sharepoint_tree_spids'." error in the Portal Tree Updates job when restoring a site collection from a backup via PowerShell
"Error: Found records with same Locations (new_loc) in #mergedStg table. Items with duplicated locations moved into dbo.tab_mergedStg_duplicated_locations table. Process stopped." error in the Portal Tree Updates job
"Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. The Solution installation failed." error when deploying the Tracking Agent Feature for SharePoint 2019 via the Configuration Wizard
"Error: The CREATE UNIQUE INDEX statement terminated because a duplicate key was found for the object name 'dbo.tab_sharepoint_tree_preload' and the index name 'PK_tab_sharepoint_tree_preload'." error in the Portal Tree Updates job
"System.NullReferenceException: Object reference not set to an instance of an object." error in the Usage Data Processing job
"System.ArgumentException: An item with the same key has already been added." error in the User Category Updates job
"Could not retrieve report data: Cannot resolve the collation conflict between "Latin1_General_CI_AS" and "SQL_Latin1_General_CP1_CI_AS" in the equal to operation" error in the Page Load Time table report
The links to Visitor Engagement and Acquisition in the intro screen are broken
Occasionally an unnecessary search event with 0 search results is sent right after performing an unsuccessful search (without clicking on any of the search results) in modern experience document libraries in SharePoint Online
Occasionally a search event is not sent when searching for the same search term more than once in the same visit in modern experience document libraries in SharePoint Online
Occasionally a search event is not sent when searching in modern experience document libraries in SharePoint 2019
"Syntax error" in CardioLogSppage.min.js file in the Tracking Agent when browsing to list items in IE 11
"Object doesn't support property or method 'closest'" error in the Tracking Agent when browsing to modern pages in IE 11
Occasionally a page view event is sent twice by the tracking agent in SharePoint 2016 sub-sites with MDS enabled
Occasionally a page view event is not sent when opening documents that are opened in OWA in SharePoint 2019

Version 3.0.13 - July 2019

Enhancements:

Portal Adaptors and Environments:

SharePoint 2019 Adaptor

Tracking Agent:

Added warn and trace console functions to the tracking agent

Installer:

Support for SQL 2017

Administration:

Support for deploying the tracking agent solution on multiple SharePoint Online site collections automatically
Support for updating the modern pages tracking App version automatically in the tracking agent deployment script
Increased the timeout value of rebuilding indexes for the SharePoint tree table to 6 hours

Resolved Issues:

"Error in SharePointModel: The property or field has not been initialized." error in the tacking agent when navigating to blog site pages
Occasionally a video auto-play event is not sent by the tracking agent when using Chrome/FireFox
When using the modern tracking agent surveys and message bars do not show up in SharePoint Online pages
"Exception: System.Net.WebException: The remote server returned an error: (400) Bad Request." error in the Portal Tree Updates job in Changes mode when importing sub-sites from SharePoint on-prem via the SharePoint REST API
The tracking agent occasionally captures an incorrect URL for documents clicked on from document library search results in SharePoint Online
"Uncaught Error: SP.Runtime.js is already loaded" error in the tracking agent when navigating from a classic page to a modern one
"XML Parsing error: syntax error" error in the modern tracking agent when using SharePoint global search in Chrome and FireFox
Occasionally a page view event is not sent by the tracking agent when clicking on list items in modern lists
Occasionally a page view event is not sent by the tracking agent when clicking on folders and sub-folders in modern document libraries
The default content type for documents stored in the Site Assets library is list item instead of document when importing the tree structure via the SharePoint REST API
"Cannot resolve the collation conflict between 'Latin1_General_CI_AS' and 'SQL_Latin1_General_CP1_CI_AS'" error in the Portal Tree Updates job
"AddOssSearchResultsPageToSites failed: System.Data.SqlClient.SqlException (0x80131904): Conversion failed when converting the varchar value" error in the Portal Tree Updates job
Updates for user categories from SharePoint user profiles are occasionally not processed when importing the data from the SharePoint REST API
Updates for users and groups from multiple SharePoint on-premise farms are occasionally not processed when importing the data from the SharePoint REST API
"The SMTP username is not a valid address" error when trying to share a report via email in case user credentials are not specified in the Mail Settings
"Error: System.Net.WebException: Unable to connect to the remote server" error in the Portal Tree Updates job when importing data in changes mode for SharePoint 2016
"Error: System.Data.SqlClient.SqlException (0x80131904): Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding." error in the Portal Tree Updates job when importing data in changes mode for SharePoint 2016
"Warning: Couldn't find the IP database in location: [CardioLog Installation Folder]\CardioLog\MaxMind\GeoIP.dat" warning in the Event Collector web application
"Error : System.Data.SqlClient.SqlException (0x80131904): Cannot insert duplicate key row in object 'dbo.tab_users' with unique index 'IX_tab_users_useraccountname'. The statement has been terminated." error in the Users and Groups job
"Failed to store Site Collection, System.Data.SqlClient.SqlException (0x80131904): Execution Timeout Expired" error in the Portal Tree Updates job
Updates for users and groups from SharePoint online are occasionally not processed when importing the data from the SharePoint REST API
"There was a problem retrieving user categories" error when trying to add a new user category from SharePoint user profiles in system configuration
"Inactive Content" table report cannot be filtered by website item
"Inactive content" table report "Last viewed on" column is empty
"Minimum value" in Advanced settings shows results greater than and not equal to this value in Onsite Search reports
"Exception: System.Net.WebException: Unable to connect to the remote server" error in the Portal Tree Updates job when importing the data from the SharePoint REST API
Drill down from Active User Categories table report does not filter the results by the selected category
"404 (Not Found) error" for the CardioLogAgent.js file after upgrade
Search result click events for PDF and VSDX documents are not mapped to the tree
"The remote server returned an error: (500) Server Error." error in the Portal Tree Updates job when importing updates for titles of root site collections from the SharePoint REST API in changes mode
False alert in the Diagnostics Dashboard for the Portal Tree Updates job when it is scheduled to run earlier than 00:00
"The remote server returned an error: (400) Bad Request." error in the Portal Tree Updates job when importing new personal sites from the SharePoint REST API in changes mode
Search result click events for list items are not mapped to the tree when using the modern agent
"Min Failure" in Advanced settings shows results greater than and not equal or lower than this value in the Onsite Failed Search Phrases report when the value is set to 0
Campaign titles in the Internal Traffic Sources report end with "/#" when SharePoint MDS mode is enabled
"Error: System.DirectoryServices.DirectoryServicesCOMException (0x80072028): A more secure authentication method is required for this server." error in the Users and Groups job when using secure LDAP
"AddOssSearchResultsPageToSites failed: System.Data.SqlClient.SqlException (0x80131904): Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding." error in the Portal Tree Updates job
The number of page exits in the Exit Pages table report is incorrect when using the modern tracking agent
"Found records with same Locations in #mergedStg table. Process stopped." error in the Portal Tree Updates job

Version 3.0.12 - March 2019

Enhancements:

UI:

Performance enhancements to the reports data cache system
Performance enhancements to the External Destinations table report

Administration:

Import SharePoint users, groups and user attributes from SharePoint using the SharePoint REST API
The number of threads used by the Portal Tree Updates job is configurable
Updated URL Mapping for ViewPost.aspx
Removed personal OneDrive sites from the SharePoint Online Adaptor configuration page
Performance enhancements for getting the list of site collections from SharePoint Central Administration when importing the tree structure using the SharePoint REST API

Tracking Agent:

Support for Hybrid Search in SharePoint

Resolved Issues:

"Email address is not valid" error when adding a recipient to a report distribution list, due to email domain extension limit of 2 - 4 characters
Upgrade fails with error "There is already an object named '#control_prefs' in the database."
"Error: The CREATE UNIQUE INDEX statement terminated because a duplicate key was found for the object name 'dbo.tab_sharepoint_tree_spids' and the index name 'PK_tab_sharepoint_tree_spids'." error in the Portal Tree Updates job
The CardioLog Agent directory path is visible in the error message that is raised when sending a request with an invalid parameter value
The Page Views by Type table widget is not filtered by document extension when using Portal Tree Updates in "changes" mode
"Error during serialization or deserialization using the JSON JavaScriptSerializer. The length of the string exceeds the value set on the maxJsonLength property." error when clicking on Save in the SharePoint Tree Adaptor configuration page
"System.Exception: Operation failed. The index entry of length 922 bytes for the index 'IDX_sharepoint_tree_load_url' exceeds the maximum length of 900 bytes" error in the Portal Tree Updates job whe multiple adaptors are configured
"Error: Client found response content type of 'text/html; charset=utf-8', but expected 'text/xml'." error in the Social Updates job
"Exception: System.Net.WebException: Unable to connect to the remote server ---> System.Net.Sockets.SocketException: Only one usage of each socket address (protocol/network address/port) is normally permitted" error in the Portal Tree Updates job when using the SharePoint 2016 adaptor
"Error: Failed to persist SharePoint sites. System.Data.SqlClient.SqlException (0x80131904): The MERGE statement attempted to UPDATE or DELETE the same row more than once" error in the Portal Tree Updates job
Missing document titles when using the SharePoint 2016 adaptor
"The number of page views for import has reached the monthly limit for MM YYYY (#) Please select a different time range for import" error when importing IIS logs

Version 3.0.11 - October 2018

Enhancements:

UI:

Site Statistics feature for contributor permission level
Improved performance for the Active User Categories report

Administration:

Support for TLS 1.2
Support for durable document links in SharePoint 2016
Improved performance for Portal Tree Updates in "changes" mode
Added default mapping for the search results page in SharePoint 2013 and 2016
Added minor version updates to content modifications reports

Tracking Agent:

Support for tracking modern sites and pages in SharePoint Online

Resolved Issues:

Missing items in Portal Tree Updates in "changes" mode when the items no longer exist in the SharePoint change log
User categories value is empty in the Visitor Profile report
"Access is denied" error while trying to change the timeframe in the exported report Web Part in SharePoint
The report widget preference windows opened from the Analysis Center default templates show aggregate data preview and disregard the selected item in the Object Explorer
"Import document versions" checkbox is disabled in the SharePoint 2016 adaptor
"Error: WriteToServer requires an open and available Connection. The connection's current state is closed." in Portal Tree Updates job when loading document
"Error: AddOssSearchResultsPageToSites failed: dbo.stp_sharepoint_tree_add_osssearchresults_page System.Data.SqlClient.SqlException (0x80131904): Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding." error in Portal Tree Updates job
"Exception: System.Data.SqlClient.SqlException (0x80131904): Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression" error in Portal Tree Updates job
"Duplicate key was found for the object name dbo.#tbl_tree_data and the index name 'NonClusteredIndex_tbl_tree_data_location'' error in the Active Sites report
"Error caught in EventCollector: String or binary data would be truncated. Cannot insert the value NULL into column 'ToEventId', table 'CardioLog.dbo.tab_temp_event_log'; column does not allow nulls" error when tracking OWA documents in SharePoint 2016
"Error during serialization or deserialization using the JSON JavaScriptSerializer. The length of the string exceeds the value set on the maxJsonLength property" error in the CardioLog UI
"Exception occurred: Failed to process preloaded data. See inner exception for details." error in the Yammer adaptor
Create new segment dialog takes too long to open
"The XSS auditor blocked access" when uploading a report webpart to SharePoint in Chrome
"Input string was not in a correct format" error when exporting a single widget to CSV from the Analysis Center
"Error: Guid should contain 32 digits with 4 dashes" error when drilling down on a unique users table report that is filtered by more than one website item

Version 3.0.10 - August 2018

Enhancements:

UI:

Improved performance for the Portal Growth Trend report
Improved performance for the Page Views table report
SEO reports are available in the report center and shows results from the latest crawl

Administration:

Support for host named site collections in SharePoint 2016
Support for document versions in SharePoint 2016
Support for connecting to SharePoint Online with modern authentication - oAuth
Support for One Note documents in the Portal Tree Updates job when importing the SharePoint tree structure via the REST API
Exclude hidden system folders when importing the SharePoint tree structure via the REST API
Improved database indexes

Resolved Issues:

"Error : 'Users' process couldn't finish importing data because of the following error: Failed to load data. System.NullReferenceException: Object reference not set to an instance of an object." error in the Social Updates job when importing data from Yammer
"Error : 'Managers' process couldn't finish importing data because of the following error: Failed to load data. Intlock.Infra.FluentHttpClient.Exceptions.FailedRequestException: Failed response is received.
Status code: 404 NotFound." error in the Social Updates job when importing data from Yammer
"Error Processing changes: System.NullReferenceException: Object reference not set to an instance of an object." error in the Portal Tree Updates job when deleting and restoring a custom list from SharePoint Recycle Bin
Incorrect creation date for folders and sub folders when importing the SharePoint tree structure via the REST API with changes mode enabled
Discussions and replies in community sites are not updated when importing the SharePoint tree structure via the REST API with changes mode enabled
Posts and comments in blog sites are not updated when importing the SharePoint tree structure via the REST API with changes mode enabled
Duplicate locations may occur when importing the SharePoint tree structure via the REST API with changes mode enabled
"Failed to initialize report page.Please check the log file or contact support" error when trying to edit a report template
Documents opened in OWA in SharePoint Online are not processed properly in version 3.0.9
"HTTP error 500.23 - Internal Server Error" error when upgrading to versions lower than 3.0.8
"Error: Persist process stopped" error when importing the SharePoint tree structure via the REST API with changes mode enabled
Sites with no owner details do not show up in the Active Sites report
No results in the Active Sites report when selecting multiple sites in the Website Item filter
"Your product license does not support the 'Document Usage Tracking from within Office' feature." error in the CardioLog Professional edition even if the license is valid
"Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding." error in the Usage Data Processing job
"Object reference not set to an instance of an object." error when clicking on Send To in the Site Statistics feature
Occasionally the Portal Tree Updates starts and immediately stops in version 3.0.9
Removed the claims authentication prefix from the user name in the owner field when importing the SharePoint tree structure via the REST API with changes mode enabled
"Error: HandleFarmAdaptors failed. System.Exception: OMAgent did not complete successfully. Failed with an error. Exception: System.IndexOutOfRangeException: Index was outside the bounds of the array." error in the Portal Tree Updates job when importing the SharePoint tree structure via the REST API and not providing the user domain name in the credentials
No results in chart widgets when selecting "Last X days" in the date range filter and "Weekly" in the time interval
"Error: hexadecimal value 0x02, is an invalid character" error in the Portal Tree Updates job when using the Website Tree adaptor
"500 Internal Server error" in the CardioLog Tracking Agent caUser.aspx file
Occasionally the Site Statistics report page is blank and unresponssive
Occasionally system jobs fails with "Missing or invalid product license" error even if the licenses are valid
Occasionally duplicate entries appear in the tree structure following unsuccessful executions of the Portal Tree Updates job.

Version 3.0.9 - April 2018

Enhancements:

UI:

New Page Load Time table report
New sample reports for visitor engagement, adoption, usability and portal resources
Added the "Last viewed on" date to the Inactive Content table report

Administration:

Retrieve changes only when importing the tree structure via the SharePoint REST API
Restored SharePoint content is restored in the tree structure as well to keep data consistency
Updated database indexes for the SharePoint tree tables
Alert emails are no longer sent for system jobs that are scheduled to "Never"

Resolved Issues:

New custom lists created under SharePoint 2013 team sites are not imported to the SharePoint Tree when the changes mechanism is enabled in the Portal Tree Updates job
List items under lists that do not have the DefaultDisplayFormUrl property are not retrieved when importing the tree structure via the SharePoint API
"Failed to load resource: the server responded with a status of 500 internal server error" error loading the Average Views per Hour of Day chart report
"Error: This handler didn't finish all its work completely. System.ApplicationException: Failed to create temp duration events" error in Usage Data Processing job when there are no events collected
"Error Table 'tab_sharepoint_tree' already has a primary key defined on it. Could not create constraint." error in Portal Tree Updates when recovery mode is enabled
OK button in "High Events Usage" warning screen is not clickable in Chrome
"String or binary data would be truncated. The data for table-valued parameter "@SpObjects" doesn't conform to the table type of the parameter." error in the Portal Tree Updates job when importing SharePoint 2016
The Last X Days and the Time Interval fields in the Custom Date Range filter menu always reset back to their default values each time the filter menu is opened
"System.NullReferenceException: Object reference not set to an instance of an object." error in Portal Tree Updates job when importing SharePoint 2016
"Server Error in '/CardioLog' Application" error in CardioLog configuration wizard step 3 when importing SharePoint Online
Chart images look blurry in report generated mode in lower screen resolutions
"Operation failed. The index entry of length 911 bytes for the index 'IX_tab_event_log_xxxxx' exceeds the maximum length of 900 bytes." error in Usage Data Processing job
Occasionally the Active Sites table report is empty
"ERROR: Found records with same Locations in #mergedStg table. Process stopped" error in Portal Tree Updates when importing SharePoint via the REST API after upgrade
"Edge" is not showing up in the Browsers table report
"Error Failed to get and parse ping interval value. System.Exception: Request to http://xxxx:29999/GetPingInterval.aspx failed." error in Usage Data Processing job
"System.Data.SqlClient.SqlException (0x80131904): The target table 'tab_event_log_archive' of the OUTPUT INTO clause cannot be on either side of a (primary key, foreign key) relationship. Found reference constraint 'FK_tab_event_log_tab_event_log_users_archive'." error in Usage Data Processing job
Message Bars targeted at SharePoint 2010 pages occasionally don't show up in IE 8/9/10
"There was a problem retrieving user categories. Please view log." error in User Category Management when importing from SharePoint profiles
Survey redirecting to another survey that should show the survey results on submit never stops loading

Version 3.0.8 - February 2018

Enhancements:

UI:

New Yammer reports - New Groups table report, New Members meter report, Conversations by Type Chart report

Installer:

Added trial limitations

Administration:

Support for using anchors (#) in URL for Shorten Links
Improved performance for automatic archiving
Added recovery mode for the Portal Tree Updates job
Improved handling of SharePoint duplicate content when importing metadata fields

Resolved Issues:

"String or binary data would be truncated" error in the Yammer Updates job
Import Yammer metrics in UTC in the Yammer Updates job
Filter Yammer reports by local time zone (convert to UTC)
"'Users' process couldn't finish importing data because of the following error: Nullable object must have a value" error in the Yammer Updates job
Incorrect number of followers imported by the Yammer Updates job
Store information about deleted followers in Yammer
Messages of deleted conversations in Yammer do not appear in reports
"System.NullReferenceException: Object reference not set to an instance of an object." error in the Portal Tree Updates job when importing SharePoint 2016
"Cannot read property 'page' of undefined" error in the Tracking Agent on SharePoint pages with Angular
"Violation of PRIMARY KEY constraint 'PK_tab_sharepoint_tree_metadata_records_load'. Cannot insert duplicate key in object 'dbo.tab_sharepoint_tree_metadata_records_load'" error in the Portal Tree Updates job when importing metadata
Occasionally the CardioLog Tracking Agent folder is not converted to an application in IIS during installation
When filtering the page views by type table report by metadata columns, the report is not refreshed
"Could not create Value for Category. System.Data.SqlClient.SqlException: Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression" error in the User Categories Updates job
"Exception occurred on sending report by email. System.IO.FileNotFoundException: Could not find file" error when sending report via email as a PDF attachment
When filtering the social user activity table report by date range, the report is not refreshed
Cannot add custom user attributes columns to the unique users table report
"The MERGE statement attempted to UPDATE or DELETE the same row more than once" error in the Portal Tree Updates job
Display user email if user name is not provided in Yammer reports
"'Users' process couldn't finish importing data because of the following error: Year, Month, and Day parameters describe an un-representable DateTime." error in the Yammer Updates job
"TypeError: document.__Page is undefined" error in the Tracking Agent when using the Extended Tracking API
Occasionally the CardioLog Tracking Agent captures duplicate search events in SharePoint Online
"Permission denied" error in the Site Statistics feature when inheriting SharePoint permissions
Occasionally SharePoint term set field values are imported as value|GUID or GUID for metadata attributes in the Portal Tree Updates job
Occasionally the CardioLog Tracking Agent captures incorrect position for search result clicks
Occasionally message Bars with no show/hide time settings appear for a second when the page is visited and then immediately go back up and hide/close
Occasionally double entries of survey responses are submitted
"Console is undefined" error in the Tracking Agent in SharePoint 2010
"Object expected" error in the CardioLog Tracking Agent when using the message bar's option "Call For Action: Show the user a survey"
"An existing connection was forcibly closed by the remote host" error in the Portal Tree Updates job when importing metadata
Table widgets with date range of this hour/last hour do not return results in report generated mode

Version 3.0.7 - September 2017

Enhancements:

UI:

New and improved reports - Average Page Views by Hour of Day Chart, Yammer Active Groups Chart, Yammer Active Groups Ratio Meter, Yammer Top Groups Table, Yammer Inactive Groups Table, Yammer Active Users Meter, Yammer Active Users Chart, Yammer Active Users Ratio Meter, Yammer Inactive Users Table, Yammer Influential Users Table

Installer:

Support for Windows 2016

Administration:

Enhanced support for fixing lost events for lists, my sites and community sites
Added support for engagement tools in a load balanced environment

Tracking Agent:

Added tracking for wopiframe2.aspx pages for Office Web Apps in the Tracking Agent

Resolved Issues:

"Failed to get personal space relative URL for user" error in the Portal Tree Updates job when importing SharePoint 2013 MySites via the REST API
Page Views by Type report columns are not aligned properly when adding metadata columns
Ignore empty search keyword in search reports
"Cannot read property 'split' of undefined" error in the SharePoint Online tracking agent feature configuration page
Occasionally the search result click position in SharePoint 2013 is not captured correctly when navigating through search results pages
German Unicode characters do not show up correctly when exporting reports to CSV
"Access Denied. You do not have permission to perform this action or access this resource" error in the Tracking Agent
Occasionally missing metadata information for pages, list items and documents
The permissions option is disabled in the Report Center for users with the Information Worker and Analysts roles
"Object Reference not set to an object" error in Site Statistics reports when PII concealment is enabled
"Value cannot be null" error in the Default Category Template
Incorrect number of search results is captured when there is a comma or a dot in the number of results (i.e. 1,000)
The "Load more" option in survey reports is not available after loading more results twice
Occasionally duplicate search events are captured on Mozilla and Chrome when MDS is activated for SharePoint 2013 and 2016
Some links on the Visitor activity reports are not clickable
"Object reference not set to an instance of an object" error in the Default Category Template
Ignore the website item set in templates in drill down/analysis center/site statistics and inherit it from the selected item
Occasionally no search events are captured on Mozilla, Chrome and IE 10 when MDS is activated for SharePoint 2013 and 2016
Occasionally the same users and groups appear twice in search results in the users and groups filter
Added the current website label to Site Statistics reports
"Cannot insert the value NULL into column 'Description'" error in the User and Groups Updates job when loading users and groups from SharePoint
"Could not find matching object in the portal tree" error in Site Statistics reports when the URL contains encoded characters
Missing Advanced tab in the "Onsite Searches - Failed vs. Successful" chart report
When creating an advanced segment based on a user category, changes are not saved
Occasionally the URL and Title columns are swapped when exporting reports to CSV
"The failed with an error. Violation of PRIMARY KEY constraint 'PK_tab_farms_location'. Cannot insert duplicate key in object 'dbo.tab_farms_location'." error in the Portal Tree Updates job
"Error occurred while trying to get widget data: Index was out of range" error in the Onsite failed search phrases table report
Occasionally clicks on external links are not captured in IE 8 in SharePoint 2013, 2016 and Online
Some chart widgets are not grouped by dimension
"The CREATE UNIQUE INDEX statement terminated because a duplicate key was found for the object name" error in the Active Sites table report when there is duplicate content in SharePoint
"Could not load Handler: Object reference not set to an instance of an object." error when editing the CardioLog Diagnostics Service schedule type in System Disagnostics
Changed the default minimum value for failed searches in the Failed vs. Successful Searches chart report to 0
The Active User Categories chart not grouped by category
"Failed to update summary table: Arithmetic overflow error converting expression to data type int." error in the Usage Data Processing job
Updated formatting for meter KPI alert emails

Version 3.0.6 - July 2017

Enhancements:

Installer:

Upgraded SQLPackage to v.17 to ignore database tables column order in upgrades

Administration:

Enhanced performance for the Yammer Adaptor

Resolved Issues:

CardioLog application pool in IIS is stopped after an upgrade
Deleted questions and ideas in Sitrion are not marked as deleted in the database
Added search phrases drill down options to sample reports and predefined templates
Number of results in the Unique Users table report is configured per results page and not for all results
SharePoint Categories Source is not available in the User Category Management screen
"Exception: Warning! The maximum key length is 900 bytes. The index 'IDX_sharepoint_tree_parentid' has maximum length of 2017 bytes" error in the Portal Tree Updates job
"The CardioLog Scheduling Service service terminated unexpectedly." error when executing the Portal Tree Updates job
"String or binary data would be truncated. The data for table-valued parameter @Properties" doesn't conform to the table type of the parameter." error in the Social Updates job when importing data from Sitrion
"Invalid URL, missing SharePoint item" error when using drill down in table reports
Message bar that is set to disappear after X seconds, disappears and re-appears immediately
Incorrect number of clicks in the Clicked By template when drilling down on External Destinations
Removed the Clicked by and Searched By drill down options from several reports
Meter widgets are placed on top of other widgets when exporting a report to PDF
When importing the SharePoint tree structure using the REST API and the SharePoint Central Administration is not available, items are occasionally marked as deleted
Occasionally the user account name is captured as a 'null' value by the Tracking Agent

Version 3.0.5 - May 2017

Enhancements:

Installer:

Install prerequisites (.NET framework, Windows Server Roles) automatically

Administration:

Enhanced performance for the Portal Tree Updates job when importing data from SharePoint Online using the REST API

Resolved Issues:

"Cannot read property 'split' of undefined" error in Yammer reports
"Invalid column name" error in Yammer reports
"Unable to get property 'handleLinksState' of undefined or null reference" in the Tracking Agent in IE 8 mode
"Cannot insert duplicate key row in object 'dbo.tab_yammer_item' with unique index 'IX_tab_yammer_item'. The duplicate key value is (user_xxxxxxx)." error in the Social Updates job when retrieving updates from Yammer
"The failed with an error. Violation of PRIMARY KEY constraint 'PK_tab_farms_location'. Cannot insert duplicate key in object 'dbo.tab_farms_location'. The duplicate key value is (x)" error in the Portal Tree Updates job
"The conversion of the varchar value overflowed an int column." error in installer
DB recovery mode is changed from Simple to Full in upgrade to version 3.0.4
"Found Records With Same Url In tab_sharepoint_tree_preload Table" error in Portal Tree Updates when importing SharePoint 2016 using the CSV method
Syntax Error: "AND operator not followed by a valid <term1>: near 'TO_TIMESTAMP(' " when importing IIS logs
The "Show first level child items only" option in the Page Views and Page Views by Type report is not available on the root level
Missing indexes on database table tab_event_log in upgrade to version 3.0.4
Survey configured to "show as long as visitor did not answer or closed survey" does not show up anymore after a page refresh
When using a custom date range in the Onsite Search Phrases table report, drilling down on a specific search term and selecting the Searched By template, the results are not filtered correctly
"All queries combined using a UNION, INTERSECT or EXCEPT operator must have an equal number of expressions in their target lists" error in the Page Views table report when filtering by a group and a user who is a member of that group
Message bars do not show up on certain non-SharePoint website pages as the URL is case sensitive
New custom reports do not show up in the reports catalog menu automatically
Cannot click on the Next button in the Service Account Dialog in the installer
Website Item filter value is occasionally set to undefined in the Analysis Center in upgrade to version 3.0.4
"Error converting data type nvarchar to datetime" when launching CardioLog
Ocassionally the search term in search web parts is not captured by the Tracking Agent

Version 3.0.4 - March 2017

Enhancements:

UI:

Added the ability to resize the left panel

Administration:

Added the ability to configure a SharePoint profile database when it is hosted on a separate instance

Resolved Issues:

The duration column in the Page Views report is 00:00:00
Incorrect results in the Page Views report when selecting multiple items in the Website Item filter
Comments under posts are missing when importing SharePoint 2016 using the REST API
"404 resource not found" error in the Tracking Agent when included in SharePoint Online sub sites
"The timeout period elapsed prior to completion of the operation or the server is not responding" error in the Portal Tree Updates job
"Error converting data type nvarchar to bigint" in the Unique Users report
"The type or namespace name 'SPWeb' could not be found" error in the Tracking Agent when importing metadata fields
Website item filter value ocassionally becomes "Current Page" after an upgrade
"The given path's format is not supported" error in the Analysis Center object explorer
"Procedure stp_maint_collect_stats, Line 16 The select list for the INSERT statement contains more items than the insert list. The number of SELECT values must match the number of INSERT columns." error in installer on SQL 2014
"Could not get context based report. Server response: Object reference not set to an instance of an object" error in drill down from table widgets
"The remote server returned an error: (500) Internal Server Error" error in Portal Tree Updates job when importing items without the Author property from SharePoint 2016 using the REST API
"Unexpected end of file has occurred. The following elements are not closed: entityName, prefs, call, calls" error in the Analysis Center when selecting website item with '&' in its title
"Prefs textContent not valid, using default one..." error in the Report Center when the widget title contains a single quote
"Exception: Operation failed. The index entry of length 1103 bytes for the index 'IDX_sharepoint_tree_load_cov_2' exceeds the maximum length of 900 bytes." error in the Portal Tree Updates job when loading multiple SharePoint farms
"The DELETE statement conflicted with the REFERENCE constraint FK_tab_sharepoint_site_roles_tab_sharepoint_sites" error in the Portal Tree Updates job
"SCRIPT5009: surveys is not defined" error in multi-page surveys
Sub replies are missing when importing SharePoint 2016 using the REST API
Extended web applications are not imported to the tree when importing SharePoint 2016 using the REST API
Collation error in Yammer reports
"Exception: An item with the same key has already been added" error in the User and Groups Updates job when loading users and groups from SharePoint and Active Directory
Widgets preferences are blank when website item URL contains parameter "ID="
"CardioLog tracking agent deployment failed at step 'Check Deployment Operation'" error in step 2 of the Configuration Wizard
Title is missing in reports for some SharePoint 2013 items
"SCRIPT5007: Unable to get property 'body'of undefined or null reference" error in IE 8, 9, 10 when tracking SharePoint 2007
When loading user categories from SharePoint User Profiles, only the first user is imported
Search result click event is ocassionally registered twice when tracking SharePoint 2013, 2016, Online
"There was a problem retrieving user categories" error when configuring AD users and groups
"Unknown error (0x80005000)" error when testing the connection to AD while configuring AD users and groups
"Exception: System.Net.Mail.SmtpException: Server does not support secure connections." error in System Diagnostics service when sending email alerts
"The remote server returned an error: (400) Bad Request." error in the Portal Tree Updates job when loading SharePoint 2013 using the REST API
Cannot select the folder location when copying a report
Post titles are blank in the Most Popular Content report
Error in Search Phrases report due to invalid search phrases
"An item with the same key has already been added" error in the Social Updates job
"The remote certificate is invalid according to the validation procedure" error in Mail Settings when sendind a test email
Search event is occasionally missing when tracking SharePoint 2007, 2010
"The type or namespace name 'SPFolder' could not be found" error in the Tracking Agent when importing social information
"Violation of PRIMARY KEY constraint 'PK_tab_sharepoint_tree_metadata_records_load'. Cannot insert duplicate key in object 'dbo.tab_sharepoint_tree_metadata_records_load'. " error in the Portal Tree Updates job when importing metadata
Drill down error in the Content Contributors table fails if users and groups were not configured
Retrieving user properties from SharePoint in Category Management fails with error "Value cannot be null"
"Loading tenant Failed with error: System.Data.SqlClient.SqlException (0x80131904): Timeout expired." error in the Portal Tree Updates job when importing SharePoint Online via REST API

...

Version 3.0.3 - December 2016

Enhancements:

Portal Adaptors and Environments:

...

Limited titles length in the Analysis Center to 50 characters
Added the "Show first level child items only" option to the Portal Growth and Content Size reports
Added the Document Type filter to the Content Contributions, Content Modifications and Page Views by Type table reports
Filter the Content Contributions table report by owner and not viewer when using the Users and Groups filter

Administration:

Increased the maximum length of the widget preferences in the database
Support for SQL 2016

Resolved Issues:

"Error occurred while trying to send email" error when using the Send To option in the Report Center
Cannot find AD groups in when using the search option in Roles
"Violation of UNIQUE KEY constraint 'UQ#tbl_XXXXX'. Cannot insert duplicate key in object 'dbo.#tbl'." error in the Sitrion Community Activity report
Social updates job fails to import data from Sitrion when an item contains more than 400 characters
The permissions option is disabled in the Report Center in upgrade to version 3.0.1
"Stack empty" error in the Portal Tree Updates job
"You are not authorized to view this report" error when creating a new report the in the Report center
"Timeout expired" error in counting inventory in the Portal Tree Updates job
"Error occurred while trying to send email" error when using the Send To option in the Site Statistics feature
Portal Tree Updates job fails when there are deleted records with the same location in the tree structure
Removed the "No answer - free text" option from the answer types in Surveys
"Object doesn't support property or method in 'get attribute'" error in the Tracking Agent in SharePoint 2010
Incorrect sort order in the External Destinations table report
"Could not load CardioLogPage from template" error when drilling down on users in the Content Contributors table report
"Could not load type 'System.Runtime.CompilerServices.ExtensionAttribute' from assembly 'mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089'." error in the SharePoint Tree Adaptor configuration page under System Configuration
"Illegal characters in path" error in the Portal Tree Updates job when retrieving updates from SharePoint Online
When retrieving updates from multiple websites with the Website Tree adaptor and only one of the websites crawl fails, the Portal Tree Updates job fails
When exporting a report to PDF the file size is 0 bytes

Version 3.0.2 - October 2016

Enhancements:

Administration:

Database schema updates in the installer are performed automatically using Microsoft SQL Server Data-Tier Application Framework

Tracking Agent:

Track documents opened in Office Web Apps (OWA) in SharePoint Online

Resolved Issues:

When drilling down from table widgets in the Site Statistics feature, the report template is blank
The INSERT statement conflicted with the FOREIGN KEY constraint FK_tab_yammer_items_relations_tab_yammer_item" error in Social Updates job when importing data from Yammer
Surveys and message bars do not show up in SharePoint Online in upgrade to version 3.0.1
List item views are occasionally registered as search result clicks in SharePoint 2013 on IE 11 and Chrome
"Access Denied" error message in SharePoint file explorer (WEBDAV)

Version 3.0.1 - August 2016

Enhancements:

Portal Adaptors and Environments:

...

New custom theme in survey appearance options
Added new content types for activity feeds in the Content Contributions, Content Contributors, Portal Growth Trend, Portal Inventory, Portal Item Types, Liked Content, and Most Popular Content reports
Added the activity feed posts and comments columns to the User Activity table report
Removed the "Share" options from report webparts

Administration:

Ability to configure the LDAP port in the Active Directory Updates job

Tracking Agent:

Track documents opened in Office Web Apps (OWA) in SharePoint 2013
Enhanced support for tracking search webparts in SharePoint 2013
Ability to configure a regular expression for the user account name format captured by the tracking agent

Resolved Issues:

Added a safety mechanism to the Version Maintenance service, to avoid incomplete database transactions
"Load error! (Error loading from server)" in the Analysis Center when expanding items with special characters in their title
Occasionally the widget preferences window is not opened correctly
Occasionally when in report edit mode, nothing happens when clicking customize date range filter
Occasionally when in report edit mode, the Object Explorer view is blank when clicking customize website item filter
"Exception: Persist Process Stopped" error in Portal Tree Updates when a deleted tree adaptor identical to an active one exists in the database
Occasionally missing service components from the UI under System Configuration > CardioLog Scheduling Service in upgrade to version 3.0.0
"Unterminated String Constant" error in the Report Center
Configuring user categories from AD is not available in upgrade to version 3.0.0
"Object reference isn't set to object instance" error in Portal Tree Updates when crawling a SharePoint Online site collection
The Visitor Activity report template is not working in drill down
"Failed to truncate table tab_sharepoint_social_follows_load" error in Social Updates job
"Timeout expired" error in the Portal Tree Updates job when updating the tab_sharepoint_sites_load table
"Exception: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding." error in the Social Updates job
Export to CSV in Analysis center shows realtime data only (for this day) and ignores the selected date range

Version 3.0.0 - July 2016

Enhancements:

UI:

Added Android devices to the Mobile Devices report
Added Windows 10 to the Operating Systems report
Added a loading image to the Site Statistics feature when selecting a template or changing the date range
Changed the definition of a Yammer active group to be a group whose members added posts, replies, likes, shares or attachments
Removed the "Show preferences" and "Show help" appearance options from the widget preferences window
Updated the design for the Administration > Roles page
Updated the design for the Entrance Paths and Navigation Summary reports
Replaced the label of action buttons from OK to Save

Administration:

New installer with automatic updates
The system alerts email sender is configurable
Apply URL Mappings when using Site Statistics feature
Added SharePoint web applications zone selection in step 3 of the Configuration Wizard
Improved performance for fixing lost events in the Portal Tree Updates job
Improved performance for the Broken Links report
Improved performance for updating geographical data in the Usage Data Processing job
Removed the "Transfer the tree structure through file system" option from the SharePoint Adaptor settings
Renamed the "Active Directory Updates" job to "User and Group Updates"

Tracking Agent:

Tracking Office 365 OneDrive documents
Tracking document library search in SharePoint 2013
A click on a list item that is opened in a dialog window is registered as a preview event instead of a view event
Added caching for the tracking agent files

Resolved Issues:

"The report does not exist" error when changing the date range in the Site Statistics feature
"Cannot insert the value NULL into column 'UserNameOld'" error in the Usage Data Processing job
The Website Item URL field is "undefined" in the Events table report
Occasional credentials prompts in SharePoint Online
"Timeout expired" error in the Portal Tree Updates job when creating indexes on the tab_sharepoint_tree_versions_load table
"Cannot read property 'questionId'" error when clicking on "Load more" in survey reports
"Exception: Subquery returned more than 1 value" error in the Report Scheduling job
"The remote server returned an error: (404) Not Found" error in the SharePoint Online adaptor when retrieving a page that its owner is deleted
Occasionally the survey thank you message does not disappear after X seconds
Collation error in the Social Influential Users table report
Occasionally the SEO reports button in reports history is not available
Missing ID label in Settings > Goals
"The SMTP user name is not a valid email address" error in the Report Center in the Share > Send To option
Occasionally cannot navigate through table widget results via the bottom paging options
Occasionally in chart widgets when selecting a custom date range that includes last year and this year and grouping the results by months, there is no data for this year
"Unable to get property 'wid' of undefined or null reference" error when moving widgets in reports
Occasionally when implementing the Tracking Agent feature in a Sharepoint Online site collection it is searching for the tracking code on the tenant level
When selecting "Show survey results" after submitting a survey, the label "Loading Results..." is displayed even after the results show up
User Categories Management configuration screen is hidden
New report creation wizards ends with "Next" instead of "OK"
"Failed to run bat file: The SharePoint Administration service is not started." error in wizard step 2 fails with error even though the feature installation was completed successfully
"(500) Internal server error" when selecting a new published template in the Site Statistics feature
The credentials when selecting the "Windows Integrated" authentication type for the AD source in Users and Group Management are incorrect
Adding the domain controller server name when configuring AD users and groups is no longer mandatory
Missing jQuery in the CardioLog Agent
Overflow error in the Onsite Search Phrases table report
Missing icons in the Analysis Center for SharePoint Online when site templates are in Japanese
Some list items title in the Analysis Center for SharePoint Online ends with "_.000"
"Permission refused" error in the tracking agent when a SharePoint page is opened in an iFrame
When filtering by date range and selecting "Last X days", the selected value is not displayed correctly when re-opening the widget preferences
Removed the Metadata filters from all reports except Page Views and Page Views by Type table reports
Scrolling down a page does not trigger a survey and fails with error "unable to get property 'scrollTo'"
Added recipients in the Mail Settings configuration screen are not saved unless clicking on Save
Average time spent in the Referring Sites table report is displayed in hours:minutes instead of minutes:seconds
The report date range label in generated reports is not updated after selecting a new date range
"Input string was not in a correct format" error when moving widgets in templates
"Could not find based on item" error when drilling down on content items

Version 2.0.9.0 - March 2016

Enhancements:

UI:

Brand new user interface supported in all common browsers (IE 8 and up, Chrome, FireFox)
Flexible report dashboard - easily drag and drop and re-size widgets
Enhanced table widgets - with search, paging and comparing date ranges
New reports such as Depth of Visit, Length of Visit, Visitor Loyalty, Visitor Recency, Inactive Users, Inactive Content, Yammer User Activity
Enable drill down in the Onsite Search Phrases and External Destinations reports
Send a report via email as an attachment (CSV, PDF)
Export survey reports and SEO reports to CSV, PDF

Version 2.0.8.4.14 - November 2015

Enhancements:

Portal Adaptors and Environments:

...

Support for filtering by website item in the Sitrion Community Activity table report
Support for filtering by date range in the Sitrion User Activity table and Activity Log chart reports
Support for filtering by date range in the Sitrion Community Activity table report
Social activities by deleted or suspended users in Yammer are included in the Yammer reports
Both unresolved and resolved questions (with good answers) in Sitrion are included in the Sitrion reports
Removed multiple meta data fields with the same name in filters in the Page Views by Type table report when imported from multiple farms
Added a total column to the Most Popular Content table report

Administration:

Load all site collections for a SharePoint Online tenant automatically, in the SharePoint Tree Adaptor settings
Improved handling of duplicate SharePoint content in the Portal Tree Updates job when importing SharePoint list items and documents meta data field values
URL Mappings for SharePoint Online discussions
Enhanced support for importing social followers data from multiple SharePoint 2013 farms

Tracking Agent:

Tracking HTML 5 and SilverLight SharePoint videos
Tracking documents opened in Office Web Apps (OWA) using the HTTP Module for tracking document usage from within Office
Ability to ignore searches for the default search keyword in SharePoint 2013
Improved handling of JavaScript code conflicts with third party scripts
Improved performance for the HTTP Module for tracking document usage from within Office
Ability to ignore consecutive views to documents when using the HTTP Module for tracking document usage from within Office (for example when opening a document and then clicking on Enable Editing it generates two view events)
Enhanced support for SharePoint 2010 search result clicks tracking
Enhanced support for search tracking in multiple subdomains (cookies are stored at the root domain)

Resolved Issues:

"Exception: invalid column min_urls" error in the Portal Tree Updates job when retrieving updates from a non-SharePoint site using the Website Tree adaptor
"Exception: hexadecimal value 0x0B, is an invalid character" error in the Portal Tree Updates job when retrieving updates from SharePoint Online
"Exception: The given key was not present in the dictionary" error in the Portal Tree Updates job when retrieving updates from SharePoint Online with SAP Workflow sites
Some folders under document libraries are missing in the SharePoint Online tree structure
"The given value of type String from the data source cannot be converted to type nvarchar of the specified target column" error in the Portal Tree Updates job when importing meta data field values with more than 255 characters
"Client found response content type of 'text/html; charset=utf-8', but expected 'text/xml'." error in the Portal Tree Updates job when importing meta data field values with invalid characters
"Column 'nvarcharX' does not belong to table" error in the Portal Tree Updates job when importing meta data fields with the same name from multiple farms
SharePoint 2010 posts content type is "Folder" instead of "Post" in the SharePoint tree structure
Some list items are marked as deleted in the SharePoint 2013 tree structure in upgrade to version 2.0.8.4.8
"Exception: Object reference not set to an instance of an object" error in the Social Updates job when retrieving updates from Sitrion in upgrade to version 2.0.8.4.8
The external links cookies are not cleared when browsing to a different domain in the Tracking Agent
In browsers with JQuery version 1.8 and lower the survey answers of type check box are not captured by the Tracking Agent
Search result preview is occasionally captured as a view event by the Tracking Agent
No data for list items meta data field of type term set is returned, if the given title of the meta data field in the UI differs from the SharePoint term set title
Incorrect results when comparing quarters in the Page Views chart report
"Cannot resolve the collation conflict" error in the Most Popular Content table report when the CardioLog database collation differs from the system temp database collation
"Index out of range" error message in the Onsite Search reports due to and overflow exception
"Incorrect syntax near the keyword 'and'" error in the Average Visit Duration (time on site) chart and meter reports when filtering in by Users and Groups
"Index was out of range" in Sitrion reports in upgrade from version 2.0.8.4.7 and up
"Cannot resolve the collation conflict" error in the Sitrion reports with widget type table when the CardioLog database collation differs from the system temp database collation
Incorrect values for comments, likes, questions and answers in the Sitrion Community Activity table report
Missing community site URL in the Sitrion Community Activity table report when the community site is not imported to the SharePoint tree structure yet
"Msg 2627, Level 14, State 1, Procedure stp_social_sitrion_community_activity_table, Line 37" Violation of UNIQUE KEY constraint" error in the Sitrion Community Activity report
"Parameter is not valid" error when exporting a report with the maximum number of widgets allowed to PDF
Exporting a report to PDF creates a blank document