Insights Error While Sending Emails Via Dashboards

News Knowledge Base
,
1

Insights error while sending emails via dashboards.

Issue Description:

  • [ERROR] [] [galaxy] [29268]:[executePhantomJS] [C:\Program Files\Sisense\app\galaxy-service\src\features\reporting\dashboard.js:206] [] [Failed to do report: Error loading 1 or more plugins: Failed to load resource: http://127.0.0.1:14991/app/reporting]

[870.801] [2022-03-16T07:38:20.421Z] [INFO] [] [galaxy] [7816]:[ReportingFlowController] [C:\Program Files\Sisense\app\galaxy-service\src\features\reporting\standalone\ReportingFlowController.js:105] [] [Reporting process for data group "612f2a582da3792548d426c6" started]

[870.802] [2022-03-16T07:38:20.421Z] [INFO] [] [galaxy] [7816]:[reporting-service] [C:\Program Files\Sisense\app\galaxy-service\src\features\reporting\reporting.service.js:252] [] [Report execute for users: 612f2a582da3792548d426c6]

[870.81] [2022-03-16T07:38:20.430Z] [INFO] [] [galaxy] [7816]:[executePhantomJS] [C:\Program Files\Sisense\app\galaxy-service\src\features\reporting\dashboard.js:145] [] [Reporting URL: http://127.0.0.1:14991/app/reporting#/dashboards/621c88e5b819041ec0cf57fd?full-narration=true]

[870.828] [2022-03-16T07:38:20.447Z] [INFO] [] [galaxy] [7816]:[common.exportService] [C:\Program Files\Sisense\app\galaxy-service\src\common\services\export.service.js:149] [] [Exporting URL "http://127.0.0.1:14991/app/reporting?lang=en-US#/dashboards/621c88e5b819041ec0cf57fd?title=true&filters=true&ds=true&showNarration=undefined"]

[872.547] [2022-03-16T07:38:22.167Z] [ERROR] [] [galaxy] [7816]:[executePhantomJS] [C:\Program Files\Sisense\app\galaxy-service\src\features\reporting\dashboard.js:206] [] [Failed to do report: Error loading 1 or more plugins: Failed to load resource: http://127.0.0.1:14991/app/reporting

]

[874.359] [2022-03-16T07:38:23.979Z] [INFO] [] [galaxy] [7816]:[] [C:\Program Files\Sisense\app\galaxy-service\appInit.js:61] [ef2016c3-3074-411f-865f-03f7edc03a78] [incoming request => GET /api/extplugins/config?v=dbaa78905c20bd55bd21dd3dba1c85e3]

[874.37] [2022-03-16T07:38:23.990Z] [INFO] [] [galaxy] [7816]:[] [C:\Program Files\Sisense\app\galaxy-service\appInit.js:61] [f57e07ec-2364-4f71-ab25-8ac3c2e805e4] [incoming request => GET /api/extplugins/config?v=dbaa78905c20bd55bd21dd3dba1c85e3]

[874.374] [2022-03-16T07:38:23.994Z] [INFO] [] [galaxy] [7816]:[] [C:\Program Files\Sisense\app\galaxy-service\appInit.js:61] [9bc78683-b02e-40ea-bb32-43b39dbcc6dd] [incoming request => GET /api/dashboards/621c88e5b819041ec0cf57fd]

[874.418] [2022-03-16T07:38:24.037Z] [INFO] [] [galaxy] [7816]:[] [C:\Program Files\Sisense\app\galaxy-service\appInit.js:61] [c4790d6d-8fd9-4a6a-b17f-651d731d095f] [incoming request => GET /api/dashboards/621c88e5b819041ec0cf57fd]

[874.446] [2022-03-16T07:38:24.066Z] [INFO] [] [galaxy] [7816]:[] [C:\Program Files\Sisense\app\galaxy-service\appInit.js:61] [135f87d6-e15d-4c2a-ae38-2f7181a27fe4] [incoming request => GET /api/v1/elasticubes/getElasticubes]

[874.495] [2022-03-16T07:38:24.115Z] [INFO] [] [galaxy] [7816]:[] [C:\Program Files\Sisense\app\galaxy-service\appInit.js:61] [24e71357-c7ca-47c2-bd2f-f06d0b127724] [incoming request => GET /api/v1/elasticubes/getElasticubes]

[875.297] [2022-03-16T07:38:24.917Z] [INFO] [] [galaxy] [7816]:[] [C:\Program Files\Sisense\app\galaxy-service\appInit.js:61] [1562447f-b32e-4570-97d7-5fa4a3375dcd] [incoming request => POST /api/activities]

[875.333] [2022-03-16T07:38:24.952Z] [INFO] [] [galaxy] [7816]:[] [C:\Program Files\Sisense\app\galaxy-service\appInit.js:61] [2d2e8003-ec00-4f10-8301-cc9b36942454] [incoming request => POST /api/activities]

[889.524] [2022-03-16T07:38:39.143Z] [WARN] [] [galaxy] [7816]:[common.exportService] [C:\Program Files\Sisense\app\galaxy-service\src\common\services\export.service.js:173] [] [Exporting URL "http://127.0.0.1:14991/app/reporting?lang=en-US#/dashboards/621c88e5b819041ec0cf57fd?title=true&filters=true&ds=true&showNarration=undefined" phantomjs warning: Error loading 1 or more plugins: Failed to load resource: http://127.0.0.1:14991/app/reporting?lang=en-US]

[889.554] [2022-03-16T07:38:39.174Z] [ERROR] [] [galaxy] [7816]:[executePhantomJS] [C:\Program Files\Sisense\app\galaxy-service\src\features\reporting\dashboard.js:118] [] []

[889.561] [2022-03-16T07:38:39.181Z] [INFO] [] [galaxy] [7816]:[ReportingFlowController] [C:\Program Files\Sisense\app\galaxy-service\src\features\reporting\standalone\ReportingFlowController.js:111] [] [Reporting process for data group "612f2a582da3792548d426c6" finished]

  • [889.579] [2022-03-16T07:38:39.208Z] [INFO] [] [galaxy] [16616]:[oxygen-tracking-dal] [C:\Program Files\Sisense\app\galaxy-service\src\features\activities\oxygenTracking.service.js:59] [] [Calling to Oxygen service with 127.0.0.1:31112]

Resolution: Test the below script

  • Send-MailMessage -From 'User01 <user01@fabrikam.com>' -To 'User02 <user02@fabrikam.com>' -Subject 'Test mail'

Issue Root Cause : ESOCKET Error

  1. This is a connection error. It could be a general connection problem or it could be caused by the SMTP server.
  2. Try sending a test email using PowerShell from the Insights server. Make sure to use the same configuration as specified for the application. Read Send - MailMessage .
    1. For port 25 (no authentication): Send-MailMessage -From 'User01 <user01@fabrikam.com>' -To 'User02 <user02@fabrikam.com>' -Subject 'Test mail' -SmtpServer <Server Name>
  3. With authentication:
    1. $Credentials = New-Object System.Net.NetworkCredential(<Username>, <password>)
      1. Send-MailMessage -From 'User01 <user01@fabrikam.com>' -To 'User02 <user02@fabrikam.com>' -Subject 'Test mail' -SmtpServer <Server Name> -Port <port number> -Credential $Credentials
  4. If sending an email with PowerShell does not work, it will not work from within Insights. At this point involve your network team or your smtp server admin.
  5. If sending an email works, share the SMTP PowerShell command that worked with the UiPath support team and also shares a screenshot of the SMTP configuration specified in the Insights installer (accessed via Add/Remove Programs->Insights Installer->Modify).