Originally posted by: Kepa_Screen

Hi, we are using a map at Aix 5.2 Box, with WSTX 8.1.0.3 ( 38 )
Are not able to send a mail to multiple recipients, using Mail Adapter, with PUT function, using INET protocol.

We get users to be sent this mail from a database, and getting them separated with ;
But it seems not work at Aix box, it does at WinXP, but not in aix.

This is our trace of the mail adapter:

e-mail Adapter, Version 8.1(37) Copyright M-) 2004, IBM Corporation.  All rights reserved Built 

for AIX on Oct  3 2007 at 20:52:53. Retry Count is 0. Retry Interval is 0. OnFailure is Rollback. Fetch Unit is 0.  Card Mode is Integral. Will process 18267 bytes of data. Run Started at 15:17:16.159 on 02/26/09. GetMailCoreInfo: Successful. e-mail Adapter, Version 8.1(37) Copyright M-) 2004, IBM Corporation.  All rights reserved Built 

for AIX on Oct  3 2007 at 20:52:53. Retry Count is 0. Retry Interval is 0. OnFailure is Rollback. Fetch Unit is 0.  Card Mode is Integral. Will process 18267 bytes of data. Run Started at 15:17:16.159 on 02/26/09. Options used: trace,name,subject,attach,text,server,to,name,from,name,proto SMTP Gateway 
'localhost' will be used. e-mail Adapter, Version 8.1(37) Copyright M-) 2004, IBM Corporation.  All rights reserved Built 

for AIX on Oct  3 2007 at 20:52:53. Retry Count is 0. Retry Interval is 0. OnFailure is Rollback. Fetch Unit is 0.  Card Mode is Integral. Will process 18267 bytes of data. Run Started at 15:17:16.160 on 02/26/09. GetMailCoreInfo: Successful. [WSAStart: Entering] [WSAStart: bWSStarted = 1, nWSClients = 3] Sockets Client ID 4 enabled. [WSAStart: Exiting (rc = 1)] Wrote 18267 bytes to /tmp/daaVtr4ad. Filename 
'xitfjalbdesc_20090220.log' will be used in the outbound message. Originator is prueba@prueba.es. *Recipient #1 is s8991;i0810;s7817.* Rollback specified; returning to map engine. Cleanup call from prior Rollback; re-initializing instance storage. Map 

return is 0. Wrote Header: Date: Thu, 26 Feb 2009 15:17:16 +0100 Wrote Header: X-Mailer: IBM WebSphere DataStage 1.0.6 Warning! Line too 

long (over 80 characters): 
'Se ha prod...'. It may be wrapped in transit. Local host is 
'SAX00010141'. Client host is 
'prueba.es'. Server host is 
'localhost'. Connecting to 
'localhost'. Socket Opened. Connected. >220 SAX00010141.eroski.es ESMTP Sendmail Thu, 26 Feb 2009 15:17:16 +0100 (S) <HELO prueba.es >250 SAX00010141.eroski.es Hello loopback [127.0.0.1], pleased to meet you (S) <RSET >250 2.0.0 Reset state (S) <MAIL FROM:<prueba@prueba.es> >250 2.1.0 <prueba@prueba.es>... Sender ok (S) *<RCPT TO:<s8991;i0810;s7817>* *>550 5.1.1 <s8991;i0810;s7817>... User unknown (F)* *Cannot deliver to recipient #1 (s8991;i0810;s7817).* Attempt #1 failed, no more retries allowed. Data in /tmp/daaVtr4ad deleted. Run Terminated at 15:17:16.344 on 02/26/09.

I know that we could do this with a functional map and send the mail each one by one, but we think this is not an operational solution , there must be another way to do this.

Could any one give some light ?

Thanx in advance.-
#IBMSterlingTransformationExtender
#DataExchange
#IBM-Websphere-Transformation-Extender

Originally posted by: phil2030

Whilst not having used the adapter for a long time, nor on an AIX box, the 550 suggests your smtp server on the AIX box is not set up to allow relaying.
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender
#DataExchange

Originally posted by: cemeinz

Hello!

Here is a copy of the online documentation from WTX (8.1.0.2)

---

Use the To Recipient adapter command (-TO) to identify a recipient of the message. -TO recipient Option Description recipient Required value. Supply the name of the recipient.Note: If you use the MAPI e-mail transport protocol the recipient name may be defined in your address book or as an SMTP type of address (user@host.com). If you use the INET e-mail transport protocol, only the SMTP type of addressing is applicable for a recipient name.

---

So, if you choose the the INET e-mail transport protocol, you must use the SMTP type of a address (user@host.com).

Try to change it from the numbers you inserted to this format and let us know the result.
#DataExchange
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender

Originally posted by: Kepa_Screen

Hi, thanks for the replys.

We tried with "user@domain.com" and the problem is the same,

-TO user1@domain.com ; user2@domain.com ; user3@domain.com

But finally we could resolve it...

If used

-TO user1@domain.com -TO user2@domain.com -TO user3@domain.com

at command, it runs well.....

So all we have done it's just SUBSTITUTE( row_from_db_with_users, ";", " -TO ")
and now goes ok. ( row_from_db_with_users uses ";" as separator, so our problem has been solved ).

Thanks again, a solution always can be found.
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender
#DataExchange

Originally posted by: SystemAdmin

We created a "group distribution list" with names that supposed to receive the email, then the "-to" will use that group distribution list to send out.
#DataExchange
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender