Publisher Emails not Delivered to Company Email addresses

scheduling XI Scheduler
1

Hi All,

I am using BOXI r3.1.6 on a windows 2003 server standard edition SP2.

I need to send a report burst to shops – using their external (to the company) email addresses. To test this I created a dummy report and recipient list using various hotmail accounts

I have created a publication using a dynamic recipient list - marked as refresh on open, it contains a recipient ID, a shop Name, and an Email Address in a Deski Report called Shop_Recipients. I have created a single Deski Report to be distributed by shop called Test BAL Due.rep. I want to burst Test BAL Due report to the relevant shop by email to the email address set out in dynamic recipient list Shop_Recipients.rep

I have created a publication as follows:
· Recurrence – Once originally – now using it to run Now for testing purposes
· Enterprise Recipients – left empty
· Dynamic Recipients – maps Shop_recipients.rep as follows:
Recipient Identifier (required): Recipient ID
Full Name: Full Name
Email: E-mail Address
I have checked use entire list
· Personalization
Links Shop Name in main report to Shop in the recipients list using Dynamic Recipient Mapping
· No Events
· No Prompts
· Formats Shows Test BAL Due
Output format is PDF
Output Format Details is greyed out – as there is only one report
· Destonations – Selected Email
Show Options are as follows:
Deliver objects to each user, From made up email BOXI@AUTOemail.com To: I have chosen the placeholder %SI_EMAIL_ADDRESS%.
Added a subject and message and ticked Deliver Documents as Attachment
Use Specific name and include the placeholder %EXT%

My data source for the recipient list is Excel. I ran the publication from the recipient list which contained hotmail accounts to test the publication. The publication failed with:
error address error. [[CrystalEnterprise.Smtp] ([1]/[4])]: [Error sending address(es) to SMTP server. Return code: [SMTP 550 - Requested action not taken: mailbox unavailable.]. Reason: [xxxxx@hotmail.com].] (FBE60013)

This implied that he issue was with the SMPTP Server. I used TELNET to try and send an email from the BOXI server via the exchange server to the hotmail accounts and it failed - unrecognised recipient. The Exchange team opened a different portfor me – and I can now TELNET to the hotmail account without issue from this new port.

I changed the Email port on the Publication Jobserver and rebooted the box – just in case. I sent the publication again – it fails with :
[Error sending address(es) to SMTP server. Return code: [SMTP 550 - Requested action not taken: mailbox unavailable.]. Reason: [denday101@hotmail.com].] (FBE60013)

Looks pretty similar to me?

So I changed my Excel spreadsheet and used my in house company address which TELNETS happily from either port from the BOXI server. Denise.day@xxxxx.com Now I get a success status on my publication – but no email(s) ever arrive – despite the success status

I have looked at the log and can’t see anything obvious on the success log.

Finally, and I know I read a post somewhere yesterday about this – but can’t find it now (despite ‘Search being my friend’)… I cannot see the attachments that are supposed to have been produced from the publication, When I click on the instance date time that is marked Success I get a new window open and the log file sort of displayed but no list of PDF attachments/recipients.

I have attached screen dumps of various things reports and Excel etc – and included the log file contents, for the Success and Failures.

Can anyone explain what is going on here – this is seriously doing my head in… thanks very much in anticipation.
Test BAL Due publication.zip (656.0 KB)

Denise (BOB member since 2006-03-09)

2

Hi All,

An update:

The exchange team opened a port on the exchange server that allowed emails to go to any external email account as well as all internal (enterprise) email accounts from the BOXI server.

I had to change all of the email destination ports to this new one on all of the Job Servers… not just the publication.jobserver.

I tested all of the existing schedules and they all worked to internal users using this port without any issues. Just to be clear here the email addresses (internal or external to the company) are always fully entered/declared e.g. xxx.smith@abc1.com etc

I removed the email address from the recipient list report page- but left it in the data provider.

I can now report burst using a dynamic recipient list - so long as all of the recipients are external accounts.

So a step forward!

However I am not as yet able to report burst using a dynamic recipient list, where the list contains a mixture of internal and external email accounts all fully declared. I have raised a support call for this and Business Objects are on the case.

Will let you all know what happens next.

Denise (BOB member since 2006-03-09)

3

That doesn’t make any sense at all, how does BOXI know whether the accounts are internal or external? It just passes a string with the recipient list to the mail server.

I’d be blaming the exchange team at this point.

Damocles :uk: (BOB member since 2006-10-05)

4

I am with you it doesn’t make any sense at all… but then so much of this doesn’t make sense!

Business Objects are still investigating and think it may be a bug. The exchange team say there is nothing wrong wit the exchange server or the configuration of the ports because I can send emails from the BOXI server to any address I like using telnet - and they arrive without issue.

I use the BOXI scheduler a lot, and I can send emails to any range of email addresses within a single schedule, internal external - you name it, and they all arrive without issue. At this point the exchange team jump and down and go hurrah - not our problem - understandably.

I have checked all of the configurations I can think of and cannot see anything obviously wrong.

I have one thing left to try – I am gong to set up the domain email addresses (internal) for the BOXI users - and try to get publisher to use these defaults – purely to send a publication internally. This is just a test to prove that publisher can actually send to domain accounts - if it is done through the enterprise.

However this in no way resolves the issue in that I cannot use dynamic recipients in a mix and match way, it still seems to be all external (not domain/enterprise) addresses or not at all.

I will let you know what happens – and what Business Objects have to say about the ‘bug’.

Denise (BOB member since 2006-03-09)

5

When you mail to internal recipients do you use the mail address on their BO account?

Damocles :uk: (BOB member since 2006-10-05)

6

I use the fully declared email addresses in all cases - so for internal recipients they look something like this: fred.smith@abc1.com and for external recipients they look something like this: manager@cardifftravelshops.com

As mentioned in my previous post - scheduler works using combinations of these addresses without any issue.

My last idea - setting up the internal recipient users email addresses in BOXI and using these as defaults for publisher - is just a test. I hope it will show that publisher can send to these email addresses if using the default enterprise email settings. But as I mentioned it won’t solve my problem of being able to send a publication to internal recipients email addresses as well as external shop addresses in one dynamic recipient list.

Denise (BOB member since 2006-03-09)

7

Have you considered upgrading to 3.2? I know this works there.

Damocles :uk: (BOB member since 2006-10-05)

8

Thanks for the advice - certainly something to think about!

My hope for this at the moment is that Business Objects will agree that it is a bug - and then I suspect their advice will be either patch or upgrade.

In the meantime it is quite frustrating… still it keeps me off the streets.

Denise (BOB member since 2006-03-09)

9

They’ll probably tell you to upgrade to 3.2

Damocles :uk: (BOB member since 2006-10-05)