insights
2023.10
false
UiPath logo, featuring letters U and I in white
Insights
Automation CloudAutomation Cloud Public SectorAutomation SuiteStandalone
Last updated Oct 25, 2024

Troubleshooting

This page provides an overview of common errors and mistakes that can occur during Insights installation, and potential methods to avoid or remedy them.

To improve the response time and efficency of the support team, make sure to find out how to capture logs if needed to debug by in Capturing logs page.

Important: Be sure that you have followed the Insights Installation instructions closely.

Configuring Log Rules

If logs aren't flowing in the intended pattern (ie all logs, or only last logs or error logs), make sure your configuration is correct.

Certificate Errors

  • If using self-signed certificates, you must use the FQDN for your server (i.e. insights.corp.uipath.com not insights).
  • The Orchestrator certificate must be placed in the Local Machine Trusted Root store on the Insights machine.
  • If you are encountering errors when trying to change your Insights certificate, make sure to follow the instructions provided in Updating Your Insights Certificate.

  • The Insights certificate must be placed in the Local Machine Trusted Root store on the Orchestrator machine.

    Note: If you are generating a self-signed certificate for Insights manually, please make sure it is marked as exportable with the private key and imported into the Personal store.


Changing the Insights Language

Selecting the Insights language is done from the Orchestrator tenant settings. All users in that tenant share the same language.



TLS Errors

The specified domain does not exist or cannot be contacted

  • The Orchestrator certificate must be placed in the Local Machine Trusted Root store on the Insights machine.
  • The Insights certificate must be placed in the Local Machine Trusted Root store on the Orchestrator machine.
  • Ensure Orchestrator and Insights have the same TLS setting.

Connection Issues

  • Check the port that you specified in the installation, to make sure it is enabled in the machine and in Windows Firewall.

Portal Showing 500 Error After Installation

The Portal may show a 500 because of a few reasons:

  1. Something went wrong with IIS.
  2. There may be an issue with the Insights application such as incorrect configuration or issues with the database connection.

To verify IIS issues,

After installing Insights, if you go to IIS Manager > UiPath Insights website > Logging, you may get the following error: 
There was an error while performing this operation.
Details:
Filename: \\?\C:\...your installation pathThere was an error while performing this operation.
Details:
Filename: \\?\C:\...your installation path

This error may occur if the IIS Hosting Bundle was not installed correctly.

To fix this issue, take the following steps:

  1. Go to Add or remove programs, search for Microsoft .NET Core, and click Modify.


  2. Click Repair in the newly open window.


To check for issues with the Insights application, please go to C:\ProgramData\UiPath Insights\ to check the Insights logs. If you cannot locate the issue, please contact UiPath support.
Note: If this does not solve the issue, we recommend uninstalling and then reinstalling the IIS Hosting Bundle.

World Wide Web Publishing Service (W3SVC) Does Not Start

During installation you can encounter IIS issues. If the W3SVC service fails to start, you can run the following command.

net start w3svcnet start w3svc

Database Migration Fails During Installation

The Orchestrator installation might fail during the Insights Database migration if it has to index a large set of data. If the installation fails and you get the following error log System.Exception: Migration failed then, you should use the following scripts to manually index the RobotLogs and Queueitems.

RobotLogs Index

IF NOT EXISTS(SELECT * FROM sys.indexes WHERE Name = 'IX_TenantId_ProcessName' and OBJECT_NAME(object_id) = 'RobotLogs')
    CREATE NONCLUSTERED INDEX [IX_TenantId_ProcessName] ON [dbo].[RobotLogs]
    (
        [TenantId] ASC,
        [ProcessName] ASC
    )IF NOT EXISTS(SELECT * FROM sys.indexes WHERE Name = 'IX_TenantId_ProcessName' and OBJECT_NAME(object_id) = 'RobotLogs')
    CREATE NONCLUSTERED INDEX [IX_TenantId_ProcessName] ON [dbo].[RobotLogs]
    (
        [TenantId] ASC,
        [ProcessName] ASC
    )

QueueItemEvents Index

if not exists (select * from sysindexes where id=object_id('dbo.QueueItemEvents') and name='TenantId_ProceStatus_QI_INDEX')
  CREATE NONCLUSTERED INDEX [TenantId_ProceStatus_QI_INDEX] ON dbo.QueueItemEvents (TenantId, ProcessingStatus) INCLUDE (QueueItemId);if not exists (select * from sysindexes where id=object_id('dbo.QueueItemEvents') and name='TenantId_ProceStatus_QI_INDEX')
  CREATE NONCLUSTERED INDEX [TenantId_ProceStatus_QI_INDEX] ON dbo.QueueItemEvents (TenantId, ProcessingStatus) INCLUDE (QueueItemId);

JobEvents Index

IF NOT EXISTS(SELECT * FROM sys.indexes WHERE Name = 'IX_JobEvents_JobId_TenantId' and OBJECT_NAME(object_id) = 'JobEvents')
CREATE NONCLUSTERED INDEX [IX_JobEvents_JobId_TenantId] ON [dbo].[JobEvents]
(
    [JobId] ASC,
    [TenantId] ASC
)IF NOT EXISTS(SELECT * FROM sys.indexes WHERE Name = 'IX_JobEvents_JobId_TenantId' and OBJECT_NAME(object_id) = 'JobEvents')
CREATE NONCLUSTERED INDEX [IX_JobEvents_JobId_TenantId] ON [dbo].[JobEvents]
(
    [JobId] ASC,
    [TenantId] ASC
)

Uninstall Issues

Application Pool Not Removed

When you uninstall Insights, you can encounter the following error The port 443 (or 543) is being used by another web application or program. This can be caused by IIS or an Insight uninstall issue.


To solve this issue, open IIS and remove UiPath Insights from Sites.


Then remove UiPath Insights and Provisioning from Application Pools.


Uninstall Error Caused by Worker Process

When you uninstall Insights, you can encounter the following error The following applications should be closed before continuing the install: IIS Worker Process (Process Id: 6492 and Process Id: 8808) This can be caused by w3wp.exe worker process that is still running.


To solve this issue, open the console or PowerShell and run the following command and then click Retry in the error dialog to continue Insights uninstall. 

net stop was /y
net start w3svcnet stop was /y
net start w3svc

If the above command is unsuccessful, you may need to restart the machine and rerun it.

Miscellaneous Issues

  1. On first use of the product, if a dashboard is showing incomplete data, it may be because of a cache. Try going to "Dashboard actions" and then select "Clear cache and refresh".
  2. Update the Looker Settings on the Insights Linux Machine.

Accessing Logs

If you performed the Insights installation, take the following steps to find the logs generated by the installer:

  • Navigate to the %temp% or %temp%/<sessionID> folder, where the <sessionID> is the integer of the session you are in. Example: %temp% or %temp%/2. The name of the log file is MSI*****.log, where the asterisks represent random letters.
  • You can find the Looker Installation logs in the %programdata% folder.
    If you have upgraded to the latest version, the Looker installation logs are still located in the C:\Users\UserName\_insights folder.
  • You can find the Insights Portal logs and Provision logs in Windows Event Viewer. Use the Filter Current Log option to filter by Event source.


Insufficient Memory Error

Issue

When setting up Looker by either running looker-initialization.sh on a Linux machine or by remotely running Deploy-Looker.ps1 from a Windows machine, the setup runs a system check to ensure the environment meets the requirements. During this system check, the following error can occur:

The looker server requires at least 16G Memory.

Possible Cause

Due to conversion from binary to decimal that may differ between cloud providers, this error can occur even if you have 16 GB memory.

Solution

Depending on the situation, there are two ways in which you can bypass the system check:

  • If you are using looker-initialization.sh, use the -b flag.
  • If you are using Deploy-Looker.ps1 , you can pass the -BypassSystemCheck parameter.

Upgrade Issues

Dataset Migration Fails During Upgrade

During upgrade, the length of the ProcessingExceptionDetails column in the dbo.QueueItem and the HostMachineName column in the dbo.JobEvents table is altered. If you have a large dataset, this can cause a timeout during upgrade. To avoid this, use the following script to manually index the items: 
IF COL_LENGTH('[dbo].[QueueItems]', 'ProcessingExceptionDetails') IS NOT NULL 
AND 'Nvarchar' IN (
	SELECT DATA_TYPE FROM INFORMATION_SCHEMA.COLUMNS
	WHERE TABLE_NAME = 'QUEUEITEMS' 
		AND TABLE_SCHEMA = 'DBO' 
		AND COLUMN_NAME = 'PROCESSINGEXCEPTIONDETAILS'
)
BEGIN
	ALTER TABLE [dbo].[QueueItems]
	ALTER COLUMN ProcessingExceptionDetails NVARCHAR(MAX)
END

IF COL_LENGTH('[dbo].[JobEvents]', 'HostMachineName') IS NOT NULL 
AND 'Nvarchar' IN (
	SELECT DATA_TYPE FROM INFORMATION_SCHEMA.COLUMNS
	WHERE TABLE_NAME = 'JOBEVENTS' 
		AND TABLE_SCHEMA = 'DBO' 
		AND COLUMN_NAME = 'HOSTMACHINENAME'
)
BEGIN
	ALTER TABLE [dbo].[JobEvents]
	ALTER COLUMN HostMachineName NVARCHAR(MAX)
ENDIF COL_LENGTH('[dbo].[QueueItems]', 'ProcessingExceptionDetails') IS NOT NULL 
AND 'Nvarchar' IN (
	SELECT DATA_TYPE FROM INFORMATION_SCHEMA.COLUMNS
	WHERE TABLE_NAME = 'QUEUEITEMS' 
		AND TABLE_SCHEMA = 'DBO' 
		AND COLUMN_NAME = 'PROCESSINGEXCEPTIONDETAILS'
)
BEGIN
	ALTER TABLE [dbo].[QueueItems]
	ALTER COLUMN ProcessingExceptionDetails NVARCHAR(MAX)
END

IF COL_LENGTH('[dbo].[JobEvents]', 'HostMachineName') IS NOT NULL 
AND 'Nvarchar' IN (
	SELECT DATA_TYPE FROM INFORMATION_SCHEMA.COLUMNS
	WHERE TABLE_NAME = 'JOBEVENTS' 
		AND TABLE_SCHEMA = 'DBO' 
		AND COLUMN_NAME = 'HOSTMACHINENAME'
)
BEGIN
	ALTER TABLE [dbo].[JobEvents]
	ALTER COLUMN HostMachineName NVARCHAR(MAX)
END

Was this page helpful?

Support and Services
Get The Help You Need
UiPath Academy
Learning RPA - Automation Courses
UiPath Forum
UiPath Community Forum
Uipath Logo White
Trust and Security
Terms of Use
Privacy Policy
Cookies Policy
© 2005-2024 UiPath. All rights reserved.