How can we help you today? How can we help you today?
Coops
Activity overview Badges (0) Posts (1) Comments (6)

Comments

Sort by recent activity
Any update on this? It's still happening on 9.0.14 will install 9.0.18 today and see if it's any better. / comments
  1. Community
  2. Redgate Monitor
  3. Reports by email is not working
Any update on this? It's still happening on 9.0.14 will install 9.0.18 today and see if it's any better.
0 votes
No this is internal only and is running over HTTP. I can setup SSL if you think it might fix things? / comments
  1. Community
  2. Redgate Monitor
  3. Reports by email is not working
No this is internal only and is running over HTTP. I can setup SSL if you think it might fix things?
0 votes
Anything we can do to help debug this? / comments
  1. Community
  2. Redgate Monitor
  3. Reports by email is not working
Anything we can do to help debug this?
0 votes
I see it around the time a report is generated by the schedule - I don't recall seeing it when manually generating a report. I will test that later today. Yes i see it even if generating via the "Save as PDF" menu 2019-04-09 13:54:30,083 [&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 60] WARN&nbsp; RedGate.SqlMonitor.UI.Website.Areas.Reports.Controllers.ReportController - Phantom JS info: New URL: http://localhost:19600/Reports/Report/PrintReport?Report=AG%20Performance%20v1&EndDate=1554818058970&Period=86400000<br>2019-04-09 13:54:30,520 [&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 118] WARN&nbsp; RedGate.SqlMonitor.UI.Website.Areas.Reports.Controllers.ReportController - Phantom JS info: CONSOLE: JQMIGRATE: Migrate is installed, version 1.4.1 (from line # in "")<br>2019-04-09 13:54:32,422 [&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 118] WARN&nbsp; RedGate.SqlMonitor.UI.Website.Areas.Reports.Controllers.ReportController - Phantom JS info: New URL: about:blank<br>2019-04-09 13:54:40,016 [&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 60] WARN&nbsp; RedGate.SqlMonitor.Common.Utilities.UserAccountHelper - Error asking Active Directory for current user's principal name<br>System.InvalidCastException: Unable to cast object of type 'System.DirectoryServices.AccountManagement.GroupPrincipal' to type 'System.DirectoryServices.AccountManagement.UserPrincipal'.<br>&nbsp;&nbsp; at System.DirectoryServices.AccountManagement.UserPrincipal.FindByIdentity(PrincipalContext context, IdentityType identityType, String identityValue)<br>&nbsp;&nbsp; at System.DirectoryServices.AccountManagement.UserPrincipal.get_Current()<br>&nbsp;&nbsp; at RedGate.SqlMonitor.Common.Utilities.UserAccountHelper.GetUsernameFromAd()System.InvalidCastException: Unable to cast object of type 'System.DirectoryServices.AccountManagement.GroupPrincipal' to type 'System.DirectoryServices.AccountManagement.UserPrincipal'.<br>&nbsp;&nbsp; at System.DirectoryServices.AccountManagement.UserPrincipal.FindByIdentity(PrincipalContext context, IdentityType identityType, String identityValue)<br>&nbsp;&nbsp; at System.DirectoryServices.AccountManagement.UserPrincipal.get_Current()<br>&nbsp;&nbsp; at RedGate.SqlMonitor.Common.Utilities.UserAccountHelper.GetUsernameFromAd() / comments
  1. Community
  2. Redgate Monitor
  3. Reports by email is not working
I see it around the time a report is generated by the schedule - I don't recall seeing it when manually generating a report. I will test that later today.Yes i see it even if generating via the "Sa...
0 votes
Having the same issue here. Reports are emailed OK on a schedule but the attached PDF is actually just a web page when opened in a text editor : <div><!DOCTYPE html><br><html class="csstransforms3d csstransforms csstransitions background-color--grey--1"><br><br><head runat="server"><br>&nbsp;&nbsp;&nbsp; <title><br>&nbsp;&nbsp;&nbsp; Log in<br></title></div>.... / comments
  1. Community
  2. Redgate Monitor
  3. Reports by email is not working
Having the same issue here. Reports are emailed OK on a schedule but the attached PDF is actually just a web page when opened in a text editor :<div><!DOCTYPE html><br><html class="csstransforms3d ...
0 votes
Don't know if it's related but I am seeing the following in the logs around the same time the report is generated: <div><br></div><div>2019-04-09 13:16:18,760 [&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 83] WARN&nbsp; RedGate.SqlMonitor.Common.Utilities.UserAccountHelper - Error asking Active Directory for current user's principal name<br>System.InvalidCastException: Unable to cast object of type 'System.DirectoryServices.AccountManagement.GroupPrincipal' to type 'System.DirectoryServices.AccountManagement.UserPrincipal'.<br>&nbsp;&nbsp; at System.DirectoryServices.AccountManagement.UserPrincipal.FindByIdentity(PrincipalContext context, IdentityType identityType, String identityValue)<br>&nbsp;&nbsp; at System.DirectoryServices.AccountManagement.UserPrincipal.get_Current()<br>&nbsp;&nbsp; at RedGate.SqlMonitor.Common.Utilities.UserAccountHelper.GetUsernameFromAd()System.InvalidCastException: Unable to cast object of type 'System.DirectoryServices.AccountManagement.GroupPrincipal' to type 'System.DirectoryServices.AccountManagement.UserPrincipal'.<br>&nbsp;&nbsp; at System.DirectoryServices.AccountManagement.UserPrincipal.FindByIdentity(PrincipalContext context, IdentityType identityType, String identityValue)<br>&nbsp;&nbsp; at System.DirectoryServices.AccountManagement.UserPrincipal.get_Current()<br>&nbsp;&nbsp; at RedGate.SqlMonitor.Common.Utilities.UserAccountHelper.GetUsernameFromAd()</div> / comments
  1. Community
  2. Redgate Monitor
  3. Reports by email is not working
Don't know if it's related but I am seeing the following in the logs around the same time the report is generated:<div><br></div><div>2019-04-09 13:16:18,760 [&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n...
0 votes
Total activity
8
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
1