No attachment link in Blackberry after BES 4.1 SP6 install

I updated my blackberry enterpriser server from 4.1 with the SP6 release.

After the update, some users get a message with an attachment but the blackberry device does not show the paper clip icon or the [1 Attachment] link in the body of the message. The user can click the menu button and the option to 'Open Attachment' is there. Of course, the user won't know there is an attachment to use this option. This does not happen on all users and all emails.

I sent a test pdf and the user with the issue sees the attachment as normal. But if I forward the message they are having issues, the attachment link does not show. My device sees the attachment as normal, but certain users do not get the attachment link.

Is this with the user's device or something directly on the BES or both?
LVL 2
gregurlAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Shekhar2coolCommented:
Can you try to delete the service book for any one of the user and resending it and see if the problem persists ?
gregurlAuthor Commented:
From additional testing, I have found that the email message with the issue is one sent from SQL Server reporting services with a PDF attachment. If I save that file and resend with Outlook, the same user having the issue can open the file. Some users can open the original email on their blackberry as normal and some cannot.

I read that it may be something in the formatting of the message that why some don't see the attachment. I found some article about the format may be TNEF(Transport Neutral Encapsulation Format), but I don't get yet why some see the attachment and some do not.

I will resend the service book and post my results.
gregurlAuthor Commented:
The service book did not seem to fix the issue.

If I swtich the email from HTML to Text in outlook, the user with the issue sees the attachment as normal. So, this tells me the email sent from the SQL Server job is formating the email message in a way the blackberry device cannot translate properly.
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

gregurlAuthor Commented:
I found the possible cause is the SQL Server is sending the message in Application: multipart/mixed mode. I looked at the headers of the message and see Content-Type: text/plain and Content-Type: text.html. The blackbery article kb11894 says only one type should be used.

My phone is able to view the message and I am using version 4.2.2 on my device. I noticed users with the issue had higher version 4.5 and above so far.
gregurlAuthor Commented:
After some testing from the SQL Server Reporting services, The closing <HTML> and <Body> tags are not part of the message. We included those tags, but SQL server wrap the entire message around a <table><tr><td><span> and thus the issue still exists. The message headers still show two content types of text and html.

Is there a proper way to format an email report from SQL services to go to the blackberry with one content type of text or html?
gregurlAuthor Commented:
The final verdict is that the type of email generated from the SQL Server repoting services when sending a PDF attachment has code that comes in plain/text and html. The blackberry will need the email to be in one or the other format but not both to work on blackberry OS 4.5.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
sffuser1Commented:
We had this same issue where Blackberry users could not see the Excel attachment when sent an email from SQL Server reporting services (2008 R2).  When the user forwarded the email to themselves they were able to see the attachment on their Blackberry.

We were however able to resolve the issue by removing text from the comment section for the SSRS subscription.  This text would normally display in the message body, it appears that SSRS is not rendering the mail message correctly when there is both comment text and an attachment as they both would normally appear in the message body on the Blackberry.

Regards

Ryan Thompson
Application Developer
Silver Fern Farms

email: ryan.thompson@silverfernfarms.co.nz
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Outlook

From novice to tech pro — start learning today.