Insights is Missing Custom Tables or the UiPath Analytics Connector is Throwing Errors

How to resolve when Insights is missing custom data or process specific tables?

Insights is Missing Custom Tables or the UiPath Analytics Connector is throwing errors.

UiPath Analytics connector is throwing the error: Could not start connector.
com.sisense.connectors.exceptions.ConnectorException: Could not connect to SiSense.


Resolution:

  1. Check %programdata%\Sisense\DataConnectors\JVMContainer\Connectors\UiFrost\Connector.log for the following error:

    <ul><li>
    	<p>Could not start connector. com.sisense.connectors.exceptions.ConnectorException: Could not connect to SiSense.</p>
    	</li></ul>
    </li><li>
    <p>If the above error is not present, look for other exceptions and try to identify the issue based on the error message. Usually the other errors are informative enough to find the issue.&nbsp;</p>
    </li><li>
    <p>If the 'Could not start connector' error was seen, try importing the Insights Certificate into Trusted Root.</p>
    
    <ul><li>
    	<p>Open certlm.msc from the Windows Search bar.</p>
    	</li><li>
    	<p>Go to the personal node, right click the certificate used by Insights and select 'Open'. Then go to the Details section and select 'Copy To File'.</p>
    
    	<ul><li>
    		<p>When asked if the private keys should be exported, select 'No'.</p>
    		</li></ul>
    	</li></ul>
    </li><li>
    <p>After this is done, double click the .CER file and import it into Trusted Root. Read <a href="https://docs.uipath.com/installation-and-upgrade/docs/using-a-certificate-for-the-https-protocol#installing-self-signed-certificates" target="_blank">Using Certificate for Https Protocol</a> .</p>
    </li><li>
    <p>Wait at least 15 minutes and see if the connector log starts to work as expected.<br>	<br>	<b>Note:</b> For 20.10, processes need to be manually whitelisted to show up in Insights. See <a href="https://docs.uipath.com/installation-and-upgrade/docs/insights-admin-tool#manage-custom-tables" target="_blank">Insights Admin tool</a>.</p>
    </li></ol>