Configuration

How can I monitor an additional web application in my SharePoint farm?

When I run the IIS Logs Import, I get the following error, "Cannot run process cmd.exe: Cannot open : Error opening files: Error opening file 'C:\inetpub\logs\LogFiles\W3SVC1\ex110101.log': The system cannot find the file specified. "

This issue occurs when running a 32-bit version in 64-bit systems. Ideally, upgrade to the latest 64-bit release version.

In order to workaround this issue, edit the CardioLog machine registry (and the CardioLog Installation key): 
Copy: HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\Intlock\CardioLog 
To: HKEY_LOCAL_MACHINE\SOFTWARE\Intlock\CardioLog

Why do I get "Missing or invalid product license" error, even though my license is valid?

The CardioLog Scheduling Service is started but all the jobs fail. Why do I see the "Exception has been thrown by the target of an invocation" error in my log file.

Why are my SharePoint Publishing Sites not being tracked when using the "CardioLog Analytics SharePoint Feature"

The CardioLog Analytics SharePoint Feature will work only for master pages which contain the following control in the head section: 
<SharePoint:DelegateControl runat="server" ControlId="AdditionalPageHead" AllowMultipleControls="true"/>

This control is included in the master pages for all SharePoint templates, except for the MOSS Publishing Site master page.

Add this control to each of your master pages, right before the closing </HEAD> tag. Alternatively, you can perform a single update, by using a top master file which is included in all of the Publishing Sites master pages.

Why do I get the error "Error: trying to remove main branch, persist stopped" when running Portal Tree Updates?

This is a safety mechanism which is triggered in order to prevent the removal of a monitored environment from CardioLog (eg. a SharePoint farm, a custom website). It is raised when removing a tree adaptor web service URL from the web services list in Portal Tree Updates service configuration.

If you wish to bypass the safety mechanism and remove a monitored environment (eg. a main tree branch in the CardioLog tree structure), follow these steps:

1. Execute the following query against the CardioLog database:
   

   SELECT [url],[location]
   FROM [CardioLog].[dbo].[tab_sharepoint_tree]
   WHERE LEN(location) = 12

2. Copy the [location] value of the monitored environment you wish to remove from the above query. Place it in the following query (replace 'location to remove' with the actual value):
   
   INSERT INTO [CardioLog].[dbo].[tab_exclude_main_branches]
   ([location])
   VALUES
   ('location to remove here')
   GO 
    
3. Run the Portal Tree Updates service.

Note: The monitored environment you have removed will be marked as deleted in the CardioLog tree structure. In order to view history usage data in reports for it, go to the Analysis Center and click Show Deleted Items.The removed monitored environment tree branch will appear in red in the tree structure and will be available for reporting.

Why do I get the error "Navigation to the webpage was canceled" when exporting a report to PDF?

When exporting a report to PDF and opening the PDF file, you may encounter the "Navigation to the webpage was cancelled" error. 

The export operation is executed on the CardioLog server. It opens a web browser object with the report, takes a screenshot of it and saves it as a PDF file. This process can fail if the report URL is inaccessible locally on the CardioLog server, due to insufficient permissions or security restrictions.

In order to resolve the issue, open [CardioLog Installation Folder]\CardioLog\web.config and edit the following key value: 

<add key="CardioLogPDFRoot" value="http://[CardioLog Host Name]:[CardioLog Port Number]/" />

[CardioLog Host Name] - the CardioLog server name
[CardioLog Port Number] - the CardioLog port number (the default port is 29999)

Change the [CardioLog Host Name] value to "localhost",  CardioLog server IP or to the CardioLog server name including the fully qualified domain name and try the export again.

If this did not resolve the error, try the following steps:

1. Verify that the CardioLog application pool user has local administrator permissions, and that there are no group policy settings or security restrictions (popup blockers, proxy rules, disable scripts etc.) on the CardioLog server default browser. 
2. Turn off User Account Control (UAC) on the CardioLog server. To do this: Open the system Control Panel > System and Security > Change User Account Control Settings > Adjust it to "Never Notify"
3. Make sure to have all CardioLog URLs (localhost, IP, server name, FQDN) in Trusted Sites both in server and client. If the CardioLog server's default browser is Internet Explorer, go to Internet Options, and in the Security tab, uncheck "Enable Protected Mode" and lower "Security Level For This Zone". Close IE. 
4. In order to test the Export to PDF exe: 
• Log in to the CardioLog server with the CardioLog user account and open CMD.
• Change directory to [CardioLog installation folder]\CardioLog\Data\ExportToPdf 
• Execute the following command:
  
  ExportToPDF.exe "http://[CardioLog Host Name]:[CardioLog Port Number]/CardioLog/clreport/index.aspx?action=open^^entityId=[Report EntityID]^^" "C:\Program^Files\Intlock\CardioLog\CardioLog\Data\ExportToPDF\temp\export_pdf_test.pdf" 
  
  [CardioLog Host Name]:[CardioLog Port Number] - should be the same value as in the "CardioLogPDFRoot" key in the CardioLog\web.config file.
  [Report EntityID] - Report Ids can be found in the CardioLog database, in the tab_virtual_tree table - EntityId column. You can also select a report in the CardioLog UI, click Browse and get the entity id from the URL.
  
  A pdf file named "pdf_test.pdf" will be created in the following location: [CardioLog Installation Folder]\CardioLog\Data\ExportToPdf\Temp

Why do I get the error "Server Error in '/CardioLog' Application - Access is denied." when I open Administration > System Diagnostics?

First, verify that the CardioLog application user account has local administrator permissions on the CardioLog application server and has permissions for starting and stopping the CardioLog services.

Secondly, open IIS Manager and navigate to IIS > Connections > Application Pools > Actions > Stop, and restart the CardioLogApplicationPool.

What is my product version number?

Why does the 'Last Event #' in the tracking agent display as 'None' or 'N/A'?

Why do I get the error "A configuration error has occurred." on my SharePoint WFEs?

The following error may occur on the SharePoint WFEs Event Log when installing the CardioLog Analytics Tracking Agent Feature:

3008 
A configuration error has occurred. 
6/17/2013 3:01:05 PM 
/LM/W3SVC/12345/ROOT-1
WSS_Minimal
C:\inetpub\wwwroot\wss\VirtualDirectories\SharePoint - 80\ 
WFESERVER01 

1032 
w3wp.exe 
MYCOMPANY\useraccount
ConfigurationErrorsException 
It is an error to use a section registered as allowDefinition='MachineToApplication' beyond application level. This error can be caused by a virtual directory not being configured as an application in IIS. (C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\template\layouts\cardiologagent\web.config line 36) 
http://sharepoint/_layouts/CardioLogAgent/CardioLogAgent.js 
/_layouts/CardioLogAgent/CardioLogAgent.js 

at System.Configuration.ConfigurationSchemaErrors.ThrowIfErrors(Boolean ignoreLocal) at System.Configuration.BaseConfigurationRecord.GetSectionRecursive(String configKey, Boolean getLkg, Boolean checkPermission, Boolean getRuntimeObject, Boolean requestIsHere, Object& result, Object& resultRuntimeObject) at System.Configuration.BaseConfigurationRecord.GetSection(String configKey) at System.Web.Configuration.RuntimeConfig.GetSectionObject(String sectionName) at System.Web.Configuration.RuntimeConfig.GetSection(String sectionName, Type type, ResultsIndex index) at System.Web.Configuration.RuntimeConfig.get_Identity() at System.Web.HttpContext.SetImpersonationEnabled() at System.Web.HttpRuntime.ProcessRequestNotificationPrivate(IIS7WorkerRequest wr, HttpContext context)

These errors may appear when the CardioLogAgent web application under the SharePoint website /_layouts folder in IIS is not configured as a web application.

In order to resolve it, open IIS Manager > Right click the CardioLogAgent directory located under the SharePoint website (http://sharepoint in this example) /_layouts folder and select "Convert to Application"

Why do I get the error "Invalid object name 'tab_iis_log_import_temp'" when I run the IIS Logs Import?

CardioLog Analytics uses the Log Parser tool in order to parse the IIS log files. 

Verify that the following key in the [CardioLog Installation Folder]\CardioLog\web.config file contains the correct path to the Log Parser tool installation folder, which should be:

<add key="IISLogParserPath" value="C:\Program Files (x86)\Log Parser 2.2\LogParser.dll" />

You can download the latest version of Log Parser from Microsoft.

 How do I change my user interface's language and date format?

In order to change your user interface language and date format, perform the following steps:

1. Open CardioLog Analytics > Administration > System Configuration > Configuration Wizard.
2. In Step 1 select the language and date format.
3.  Click Next and close the browser.
4. Perform IISRESET on the CardioLog application server.
5. It is recommended for end users to delete their browser cache after changing the language. 

Available languages:

• English - Great Britain
• English - United States
• French - France
• German - Germany
• Japanese
• Portuguese - Portugal
• Spanish - Spain (Traditional)

In order to change the user interface language to Japanese (Only available in versions higher than 2.0.8.2):

Execute the following SQL script against the CardioLog database (using SQL Management Studio):

Why do I get the warning "Failed to collect SQL statistics" when I run the Usage Data processing job?

How do I create the CSV of my Site Collection for the SharePoint Online Adaptor?

To import your SharePoint Online Site Collection using CSV that will then be applied via the SharePoint Online Tree Adaptor, follow these steps:

1) Create a folder on the root drive (If not C:/ just change location in script) called Scripts.
2) Make a .CSV file called NewSiteCollections.csv (c:\scripts\NewSiteCollections.csv)
3) Open the SharePoint Online Management Shell and input these lines of code:

$csvfile = 'c:\scripts\NewSiteCollections.csv'

Connect-SPOService -Url https://[login]-admin.sharepoint.com/ -Credential [Login].onmicrosoft.com

Get-SPOSite | Export-CSV $csvfile

4) Change login to correct variable.
5) If you get an error that reads "Failure to recognize Connect-SPOService" , update to the latest Sharepoint Online Management Shell from Microsoft.
6) Place the attached file in [CardioLog Installation Folder]\CardioLog\Bin
7) Open CardioLog and via the navigation pane, go to Administration > System Configuration > SharePoint Tree Adaptor and select the relevant version of SharePoint.
8) Enter the location of the CSV file containing the Site Collection list and click apply.
9) Choose the websites you would like to track.

Please run this script on a regular basis either manually or using automation to update the CSV frequently. We recommend keeping this updated daily in order to keep all changes made in your Online environment in sync with your Portal Tree and your reports.