Hi,
I am setting up to recieve email notifications before an SSL certificate expires. I have set up the days in global config. I have hardcoded my email "nsharma@domain.com" in the "TO" section of the email template. When running the SSL expiry notification analytics, emails are not sent out.
I see below error in logs. If someone can help. I have hidden the confidential info like maild id, url and ip address
2023-02-20 13:09:42,659 [https-jsse-nio-443-exec-56] DEBUG analytics.AnalyticsESService - category-Expiry Notification
2023-02-20 13:09:42,659 [https-jsse-nio-443-exec-56] DEBUG analytics.AnalyticsESService - inside if
2023-02-20 13:09:42,659 [https-jsse-nio-443-exec-56] DEBUG analytics.AnalyticsESService - emailTemplate associated to control - SSL Certificate Expiry Email
2023-02-20 13:09:42,659 [https-jsse-nio-443-exec-56] DEBUG services.SaviyntCommonUtilityService - Start bindBaseUrlEmailTemplate
2023-02-20 13:09:42,659 [https-jsse-nio-443-exec-56] DEBUG services.SaviyntCommonUtilityService - baseUrlForEmail value in externalConfig : [:]
2023-02-20 13:09:42,659 [https-jsse-nio-443-exec-56] DEBUG services.SaviyntCommonUtilityService - baseUrlForEmail is missing in the externalConfig file. Please add it !
2023-02-20 13:09:42,722 [https-jsse-nio-443-exec-56] DEBUG analytics.AnalyticsESService - to field in email template - nsharma@domain.com
2023-02-20 13:09:42,722 [https-jsse-nio-443-exec-56] DEBUG analytics.AnalyticsESService - tofield after removing useremail - nsharma@domain.com
2023-02-20 13:09:42,729 [https-jsse-nio-443-exec-56] DEBUG analytics.AnalyticsESService - to in email - null
2023-02-20 13:09:42,729 [https-jsse-nio-443-exec-56] DEBUG analytics.AnalyticsESService - fromfield after removing useremail - SavintAdmin@saviynt.com
2023-02-20 13:09:42,737 [https-jsse-nio-443-exec-56] DEBUG analytics.AnalyticsESService - from in email using emailTemplate - [SavintAdmin@saviynt.com]
2023-02-20 13:09:42,737 [https-jsse-nio-443-exec-56] DEBUG analytics.AnalyticsESService - body after removing individual users analytics data - <!DOCTYPE html> <html> <head> <style> table { font-family: arial, sans-serif; border-collapse: collapse; width: 100%; } td, th { border: 1px solid #dddddd; text-align: left; padding: 8px; } tr:nth-child(even) { background-color: #dddddd; } </style> </head> <body> Hi ${ANALYTICSDATA.firstname[0]} ${ANALYTICSDATA.lastname[0]},<br><br> The below mentioned SSL Certificates are going to expire soon. Please update the certificates to aviod any connection disruption:<br><br> <table> <tr><th>Certificate Name</th><th>Certificate Expiry Date</th><th>Connection Name</th></tr> <% int count=Integer.parseInt("${ANALYTICSDATA.alias.size()}"); for(int i=0;i<count;i=i+1){%><tr><td>${ANALYTICSDATA.alias[i]}</td><td>${ANALYTICSDATA.valid_to[i]}</td><td>${ANALYTICSDATA.connectionname[i]}</td></tr> <% } %> </table> <br><br> Regards,<br> Saviynt Admin Team <br> </body> </html>
2023-02-20 13:09:42,758 [https-jsse-nio-443-exec-56] DEBUG analytics.AnalyticsESService - Error in notifyEmailToOwner::
groovy.lang.MissingPropertyException: No such property: ANALYTICSDATA for class: SimpleTemplateScript1376
at SimpleTemplateScript1376.run(SimpleTemplateScript1376.groovy:1)
at com.saviynt.ecm.analytics.AnalyticsESService.notifyEmailToOwner(AnalyticsESService.groovy:2924)
at com.saviynt.ecm.analytics.AnalyticsHistoryESController$_closure3.doCall(AnalyticsHistoryESController.groovy:313)
at grails.plugin.springsecurity.web.filter.GrailsAnonymousAuthenticationFilter.doFilter(GrailsAnonymousAuthenticationFilter.java:53)
at com.saviynt.webservice.SaviyntRestAuthenticationFilter.doFilter(SaviyntRestAuthenticationFilter.groovy:145)
at grails.plugin.springsecurity.web.authentication.logout.MutableLogoutFilter.doFilter(MutableLogoutFilter.java:62)
at grails.plugin.springsecurity.web.SecurityRequestHolderFilter.doFilter(SecurityRequestHolderFilter.java:59)
at com.mrhaki.grails.plugin.xframeoptions.web.XFrameOptionsFilter.doFilterInternal(XFrameOptionsFilter.java:69)
at com.brandseye.cors.CorsFilter.doFilter(CorsFilter.java:82)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)
2023-02-20 13:09:42,758 [https-jsse-nio-443-exec-56] DEBUG println.PrintlnToLogger - Println :: [1;31m| Error [22;39mgroovy.lang.MissingPropertyException: No such property: ANALYTICSDATA for class: SimpleTemplateScript1376[m
2023-02-20 13:09:42,758 [https-jsse-nio-443-exec-56] DEBUG println.PrintlnToLogger - Println :: [1;31m| Error [22;39m at SimpleTemplateScript1376.run(SimpleTemplateScript1376.groovy:1)[m
2023-02-20 13:09:42,758 [https-jsse-nio-443-exec-56] DEBUG println.PrintlnToLogger - Println :: [1;31m| Error [22;39m at com.saviynt.ecm.analytics.AnalyticsESService.notifyEmailToOwner(AnalyticsESService.groovy:2924)[m
2023-02-20 13:09:42,758 [https-jsse-nio-443-exec-56] DEBUG println.PrintlnToLogger - Println :: [1;31m| Error [22;39m at com.saviynt.ecm.analytics.AnalyticsHistoryESController$_closure3.doCall(AnalyticsHistoryESController.groovy:313)[m
2023-02-20 13:09:42,758 [https-jsse-nio-443-exec-56] DEBUG println.PrintlnToLogger - Println :: [1;31m| Error [22;39m at grails.plugin.springsecurity.web.filter.GrailsAnonymousAuthenticationFilter.doFilter(GrailsAnonymousAuthenticationFilter.java:53)[m
2023-02-20 13:09:42,758 [https-jsse-nio-443-exec-56] DEBUG println.PrintlnToLogger - Println :: [1;31m| Error [22;39m at com.saviynt.webservice.SaviyntRestAuthenticationFilter.doFilter(SaviyntRestAuthenticationFilter.groovy:145)[m
2023-02-20 13:09:42,758 [https-jsse-nio-443-exec-56] DEBUG println.PrintlnToLogger - Println :: [1;31m| Error [22;39m at grails.plugin.springsecurity.web.authentication.logout.MutableLogoutFilter.doFilter(MutableLogoutFilter.java:62)[m
2023-02-20 13:09:42,758 [https-jsse-nio-443-exec-56] DEBUG println.PrintlnToLogger - Println :: [1;31m| Error [22;39m at grails.plugin.springsecurity.web.SecurityRequestHolderFilter.doFilter(SecurityRequestHolderFilter.java:59)[m
2023-02-20 13:09:42,758 [https-jsse-nio-443-exec-56] DEBUG println.PrintlnToLogger - Println :: [1;31m| Error [22;39m at com.mrhaki.grails.plugin.xframeoptions.web.XFrameOptionsFilter.doFilterInternal(XFrameOptionsFilter.java:69)[m
2023-02-20 13:09:42,758 [https-jsse-nio-443-exec-56] DEBUG println.PrintlnToLogger - Println :: [1;31m| Error [22;39m at com.brandseye.cors.CorsFilter.doFilter(CorsFilter.java:82)[m
2023-02-20 13:09:42,758 [https-jsse-nio-443-exec-56] DEBUG println.PrintlnToLogger - Println :: [1;31m| Error [22;39m at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)[m
2023-02-20 13:09:42,758 [https-jsse-nio-443-exec-56] DEBUG println.PrintlnToLogger - Println :: [1;31m| Error [22;39m at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)[m
2023-02-20 13:09:42,758 [https-jsse-nio-443-exec-56] DEBUG println.PrintlnToLogger - Println :: [1;31m| Error [22;39m at java.lang.Thread.run(Thread.java:748)[m
2023-02-20 13:09:47,206 [https-jsse-nio-443-exec-27] DEBUG println.PrintlnToLogger - Println :: Authentication failed: Bad credentials
2023-02-20 13:09:47,206 [https-jsse-nio-443-exec-27] DEBUG println.PrintlnToLogger - Println :: Not authenticated. Rest authentication token not generated.
2023-02-20 13:09:53,079 [https-jsse-nio-443-exec-51] DEBUG services.UsersService - Query is
SELECT a FROM Users a
where 1=1 ORDER BY a.username asc
2023-02-20 13:09:58,093 [https-jsse-nio-443-exec-56] DEBUG println.PrintlnToLogger - Println :: allowed hosts = ssm-prodv5-domain.saviyntcloud.com
2023-02-20 13:09:58,093 [https-jsse-nio-443-exec-56] DEBUG println.PrintlnToLogger - Println :: host ip-1-2-3-4 is not valid
2023-02-20 13:09:58,122 [https-jsse-nio-443-exec-19] DEBUG println.PrintlnToLogger - Println :: Authentication failed: Bad credentials
2023-02-20 13:09:58,122 [https-jsse-nio-443-exec-19] DEBUG println.PrintlnToLogger - Println :: Not authenticated. Rest authentication token not generated.
Thanks
Nidhi
