I have just installed Data Import Schedule Manager and been through the set-up to create the tables. Now when I create a new Email Template and select "Send Email Preview" I receive an error "Error: Preview email not sent". Any idea what might be causing this? Is there other configuration that needs to be done to enable the sending of emails? This is a cloud deployment of OneStream and the first time we are looking at email notifications. Thanks.
Do you have a setting somewhere that is pointing to the "OneStream Email". Or do you see the "OneStream Email" under data adaptor under external table SQL?
Hi - the System Error Log doesn't provide any additional detail, just a description of "Exception Creating and Sending Email" which is the Exception Message generated by the DSM_SolutionHelper Extender rule.
If i were you I would test the Email of OneStreamEmail. You could create a BR extender rule and simply adjust the code below after adapting it to your needs. The idea is to receive and email from that.
Imports System Imports System.Collections.Generic Imports System.Data Imports System.Data.Common Imports System.Globalization Imports System.IO Imports System.Linq Imports System.Windows.Forms Imports Microsoft.VisualBasic Imports OneStream.Finance.Database Imports OneStream.Finance.Engine Imports OneStream.Shared.Common Imports OneStream.Shared.Database Imports OneStream.Shared.Engine Imports OneStream.Shared.Wcf Imports OneStream.Stage.Database Imports OneStream.Stage.Engine Namespace OneStream.BusinessRule.Extender.HAK_SendEmail Public Class MainClass Public Function Main(ByVal si As SessionInfo, ByVal globals As BRGlobals, ByVal api As Object, ByVal args As ExtenderArgs) As Object Try 'Connection to the mail server (Defined in Application Server setup) Dim emailConnectionName As String = "OnestreamEmail" 'Email content (Subject & Body) Dim subject As String = "Test OS Email" Dim messageBody As String = "Do you Get that email? " 'Add email addresses Dim toEmail As New List(Of String) Dim userEmailAddress1 As String = "UpdateThisPerson@domain.com" 'Marc Roest <firstname.lastname@example.org> toEmail.Add(userEmailAddress1) ''Add Attachments Dim attachments As New List(Of String) Dim fileAttachmentPath As String '= "\\Server\Folder\FileName.txt" If File.Exists(fileAttachmentPath) Then attachments.Add(fileAttachmentPath) End If 'Send the message BRApi.Utilities.SendMail(si, emailConnectionName, toEmail, subject, messageBody, attachments) Return Nothing Catch ex As Exception Throw ErrorHandler.LogWrite(si, New XFException(si, ex)) End Try End Function End Class End Namespace
Thanks for that - I'm getting "The SMTP server requires a secure connection or the client was not authenticated. The server response was: Authentication required". I guess I need to get OneStream to do some configuration to enable email.