Sending Outgoing Email V9

[JoshK131]

Hello,

I am getting this error when trying to send an email.
"Internal system errorTransaction exception Nonexistent attribute: OutgoingEmailHost"

Here is the process used to test.

IF EXISTS OutgoingEmailAccount WHERE (OutgoingEmailAccount.FromAddress CONTAINS 'xxxxx' ) THEN
FIND OutgoingEmailAccount WHERE (OutgoingEmailAccount.FromAddress CONTAINS 'xxxxx' )
CREATE OutgoingEmail WITH OutgoingEmail.Message='test message', OutgoingEmail.Subject='Test Subject'

IF EXISTS Customer WHERE (Customer.EmailAddress CONTAINS 'aaaaa' ) THEN
FIND Customer WHERE (Customer.EmailAddress CONTAINS 'aaaaa' )
SEND OutgoingEmail TO Customer USING OutgoingEmailAccount

OutgoingEmailAccount was created by the system in business objects.
I am not using the OA Fields at all.

OutgoingEmail is a system created notification.

Customer has got communication enabled to "E-mail"


The server logs show a similar message


Nonexistent attribute: OutgoingEmailHost
at org.openadaptor.dataobjects.FixedDOType.getAttribute(FixedDOType.java:346)
at org.openadaptor.dataobjects.AbstractDataObject.getAttributeValue(AbstractDataObject.java:786)
at com.bas.shared.domain.operation.EntityImpl.getAttributeValue(EntityImpl.java:401)
at com.bas.basserver.iopipes.EmailSink.A(Unknown Source)
at com.bas.basserver.iopipes.EmailSink.handleDelayedNotifications(Unknown Source)
at com.bas.basserver.bsmanager.D.A(Unknown Source)
at com.bas.basserver.bsmanager.E.A(Unknown Source)
at com.bas.basserver.bsmanager.E.A(Unknown Source)
at com.bas.basserver.iopipes.ComponentSink.processMessage(Unknown Source)
at org.openadaptor.adaptor.STPipelineController.processMessage(STPipelineController.java:68)
at com.bas.openadaptor.NonTransactionalController.processMessage(NonTransactionalController.java:136)
at org.openadaptor.adaptor.AbstractSimplePipe.processMessage(AbstractSimplePipe.java:222)
at org.openadaptor.adaptor.STPipelineController.processMessage(STPipelineController.java:68)
at com.bas.openadaptor.NonTransactionalController.processMessage(NonTransactionalController.java:136)
at org.openadaptor.adaptor.AbstractSimpleSource.processMessage(AbstractSimpleSource.java:403)
at org.openadaptor.adaptor.AbstractSimpleSource.sourceProcess(AbstractSimpleSource.java:1049)
at org.openadaptor.adaptor.AbstractSimpleSource.sourceProcess(AbstractSimpleSource.java:1012)
at com.bas.openadaptor.MTJMSListener$JMSMessageHandler.run(MTJMSListener.java:275)
at java.base/java.lang.Thread.run(Thread.java:833)
Exception org.openadaptor.dataobjects.InvalidParameterException trying to commit transaction Nonexistent attribute: OutgoingEmailHost
com.bas.basserver.bsmanager.U: Nonexistent attribute: OutgoingEmailHost
at com.bas.basserver.bsmanager.D.A(Unknown Source)
at com.bas.basserver.bsmanager.E.A(Unknown Source)
at com.bas.basserver.bsmanager.E.A(Unknown Source)
at com.bas.basserver.iopipes.ComponentSink.processMessage(Unknown Source)
at org.openadaptor.adaptor.STPipelineController.processMessage(STPipelineController.java:68)
at com.bas.openadaptor.NonTransactionalController.processMessage(NonTransactionalController.java:136)
at org.openadaptor.adaptor.AbstractSimplePipe.processMessage(AbstractSimplePipe.java:222)
at org.openadaptor.adaptor.STPipelineController.processMessage(STPipelineController.java:68)
at com.bas.openadaptor.NonTransactionalController.processMessage(NonTransactionalController.java:136)
at org.openadaptor.adaptor.AbstractSimpleSource.processMessage(AbstractSimpleSource.java:403)
at org.openadaptor.adaptor.AbstractSimpleSource.sourceProcess(AbstractSimpleSource.java:1049)
at org.openadaptor.adaptor.AbstractSimpleSource.sourceProcess(AbstractSimpleSource.java:1012)
at com.bas.openadaptor.MTJMSListener$JMSMessageHandler.run(MTJMSListener.java:275)
at java.base/java.lang.Thread.run(Thread.java:833)
2024-04-28 22:16:29,966 ERROR sample#admin -Transaction exception Nonexistent attribute: OutgoingEmailHost

[Jaymer]

I’ve had two different issues with the new OA fields relating to missing fields. Yours is the 3rd field now.
Just add the field and be done.
You probably can’t publish now either.

[JoshK131]

Added some fields and a rule in the update to fix the problem.

OutgoingEmailAccount.OutgoingEmailUserName=OutgoingEmailAccount.MailUser
OutgoingEmailAccount.OutgoingEmailHost=OutgoingEmailAccount.MailHost
OutgoingEmailAccount.OutgoingEmailPassword=OutgoingEmailAccount.MailPassword
OutgoingEmailAccount.OutgoingEmailPort=OutgoingEmailAccount.MailPort
OutgoingEmailAccount.OutgoingEmailSSL=OutgoingEmailAccount.MailSSL
OutgoingEmailAccount.OutgoingEmailTLS=OutgoingEmailAccount.MailTLS
OutgoingEmailAccount.OutgoingEmailFromAddress=OutgoingEmailAccount.FromAddress


I know Host, UserName and from address are necessary, the rest were extrapolated and it works now.

[Powerm]

Hi,

I have migrated my one of my v8 app to V9, sending emails using my existing SMTP setting was working fine during the first day of testing then it suddenly stopped ( logs giving a random timeout or authentifacation failure ).
Do you send your email using the "System Settings" too? The new "OutgoingEmailAccount" BO is not clear to me and there no new tutorial about it.
Are you using a normal domain email ( [email protected]), Gmail or a SMTP provider? A sample app/bsv would be great to have as the new CRM sample app has nothing on this ....Thanks!

[Jaymer]

OutgoingEmail Account has been around a few years, FYI.

I have an outgoing email BO, renamed to StaffEmail:

outgoing email acct.jpg (75.2 KiB) Viewed 28 times

A field in RegularUser attaches a StaffEmail record to each user:

RegularUser.jpg (48.74 KiB) Viewed 28 times

After the click on the User screen, they can enter their email login details here:

user setup.jpg (80.18 KiB) Viewed 28 times

[Jaymer]

Here's the process that gets called to email a PO to a Vendor.
A process has already created the OutgoingEmail_PO record.
A scheduler process checks every minute and calls this passing the record to send.

send process.jpg (188.51 KiB) Viewed 22 times

[Powerm]

Thank you for your screenshots and explanation. About "OutgoingEmail Account has been around a few years, FYI." I just remembered it now, I started with AwareIM in 2010 but never used it
Do using a Gmail account to send emails still works in 2024, no OA fields no Gmail Apps needed? Many thanks