Groups | Blog | Home
all groups > sql server reporting services > december 2004 >

sql server reporting services : URGENT : Bug in SMTP delivery


Bruce L-C [MVP]
12/2/2004 10:45:25 AM
For #2, do you have SP1 installed. The format changed with SP1 allowing
support for Excel 97/2000. If the customer server does not have SP1 and they
have Excel 97/2000 then that would account for the problem.

--
Bruce Loehle-Conger
MVP SQL Server Reporting Services

[quoted text, click to view]

Jean-Marc PUGIN
12/2/2004 5:39:59 PM
Hi,

We are using Data Driven Subscription to deliver Excel files using SMTP.

Everything works fine on our Intranet.

However we have problems to put in in Production for some customer sites.

We have several VERY STRANGE behavior:

1. the Excel file when read on the customer PC is "nearly" EMPTY (78 bytes
for example)
AND the file is INCORRECT for Excel (unable to load it into Excel).

2. the Excel file when read on the customer PC has the right size (44 Ko for
example)
AND the file is INCORRECT for Excel (unable to load it into Excel).

There is NEARLY zero info on RS books we have (excellent books btw) so

ANY help will be appreciated.

Many Thanks

Jean-Marc PUGIN
12/2/2004 5:58:14 PM
Yes SP1 has been installed especially to target Excel 97 which is still
largely used in Main Corporations.

The SAME Excel file is OK when send to a provider and KO when send to
another.

We are searching Excel File characteristic that could put in trouble the
Corporation mail.

Best Regards,

[quoted text, click to view]

Tao Zuo
12/3/2004 7:19:08 AM
I posted this message below 11/18. Hope the hotfix (872774) can fix your
problem?

Tao

The hotfix actually fixed a similiar issue of ours:

Server A: Window 2003
Reporting Server: SP1 8.00.878.00
Issue: Excel Subscription Email Attachment Corrupted
Email Server: Novell Netware

Our two other environments/servers do not have problem:
Server B: Windows 2000
Reporting Server: RTM 8.00.743.00

Server C: Windows 2000
Reporting Server: SP1 8.00.878.00

So I think there is something to do with Windows2003 and Non-Exchange mail
server?

Tao

[quoted text, click to view]




Printer-Friendly Version Send This Page Add to Favorites Comments


[quoted text, click to view]
Jean-Marc PUGIN
12/3/2004 7:48:24 PM
Tao,

NICE SHOT.

Yes it has fixed the bug.

Many thanks as the Big Corp that we are targeting are often NOTES email
based.


Jean-Marc.


[quoted text, click to view]

AddThis Social Bookmark Button