7/1/2025 12:32:10 PM
|
| |
| slxdeveloper.com Community Forums |
|
| |
|
|
The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!
Forum to discuss the use of the SalesLogix Web Platform, Client and Customer Portals, and the Application Architect (For version 7.2 and higher only). View the code of conduct for posting guidelines.
|
|
|
|
Mail merge error through web (Record to History) - even though it works...
Posted: 06 May 09 12:20 PM
|
I have a client with a mail merge issue...
They'll log into SLX web (7.5.1) and download the ActiveX, all fine and dandy. Open Outlook and there is a 'Record to History' button as should be. Select an email sent to an email address that exists in SLX and click 'Record to History'. A couple seconds later, an error box is thrown in IE saying:
"The following error(s) occurred when uploading one or more attachments: File Name: $email$.msg; Error Message: Index 0 is out of range; Error Code 0; Save: False"
Only it's lying - it's been uploaded just perfectly and is fully visible and usable within SLX, yet this error still appears - every single time. (Outlook 2003 SP3 and Outlook 2007 SP1 and SP2 all behave identically.)
Sage Support doesn't have a clue and I've already completely ripped out mail merge entirely and put it back to get the exact same behavior...
(Web server is Windows Server 2003 R2 32 bit so this is all on IIS 6)..
Any thoughts?
|
|
|
|
Re: Mail merge error through web (Record to History) - even though it works...
Posted: 06 May 09 2:28 PM
|
First of all, what has been uploaded? The Email?
Are there any Images on the User's signature?
The error message is stating the the File Attachment didn't get uploaded, so that may be coming from the Send SLX functionality. Thus, it may be that a given Image on the Message didn't get through to the server.
Could you determine how many attachments were on the message and if any of them did/didn't get uploaded?
We ran through several issues like this on 7.2 and SAGE provided us with a Hotfix (for Send SLX). I do not know if an similar hotfix was generated for 7.5.1, so I suggest that you check. |
|
|
|
Re: Mail merge error through web (Record to History) - even though it works...
Posted: 06 May 09 2:33 PM
|
Thanks for the reply, Raul.
The email itself was successfully uploaded as an attachment, yes. If you look at the email within Outlook there are no attachments to it (if that makes sense.) It's a pure text email that was recorded to history.
I've talked to Sage about 7.5 HF 1 but that's redundant as it was included in SP1 which we're running....
|
|
|
|
Re: Mail merge error through web (Record to History) - even though it works...
Posted: 06 May 09 7:29 PM
|
You have 2 things going on:
- Mail Merge: Did you selected options in Mail Merge to Attach the document after merging?
That would be the document that you see on the Attachment tab.
- When you click on the Send SLX, it will:
* Add an entry on the History table for the Sent Email.
* Add any attachments within the Email message as Attachments (The Attachment table has a HistoryID column that allows to link the files to Email records).
(If you had any Images on the Template, when they make it into the Email message they become Attachments, which would then be uploaded to the server.)
The remaining question is what is the Message box Title? What component is issuing that error?
|
|
|
| |
|
Re: Mail merge error through web (Record to History) - even though it works...
Posted: 22 Jun 09 6:31 AM
|
Originally posted by Mike Spragg
Check for, and remove, any rows in the attachment table where the AttachDate is blank. You may have a bunch of them. |
|
I am encountering the same issue with SendSLX here and I've checked the attachment table and not found any fields where the AttachDate is blank, do you know if a fix for this was ever found?
Will |
|
|
| |
| |
|
Re: Mail merge error through web (Record to History) - even though it works...
Posted: 17 Dec 09 5:09 AM
|
Hi Will,
you could hold the HTTP Compression for the SLX Web Site, as specified at page 28 of Applying Service Pack 2 for Sage SalesLogix Version 7.5.pdf.
It's easy, and it works ALSO in the 7.5.1 version.
Bye!
----------------------------
Disable HTTP compression for mail merge and SendSLX
---------------------------------------------------
The components used by mail merge and SendSLX use zip compression to reduce the
size of mail merge requests and responses. When HTTP compression is enabled in IIS
this can conflict with mail merge and SendSLX when dynamic compression is applied to
ASHX (IIS6) or "*/*" (IIS7). In addition, if third-party compression is used, both mail
merge and SendSLX will fail unless compression is disabled.
When HTTP compression conflicts occur you will see the following HTTP error: "The result
for 1 queries was expected, but no data was returned. There may have been more than
1 HTTP data request active at the same time. The SQL syntax may also be incorrect."
Use one of the following sections to disable compression for your IIS version.
To disable IIS6 compression (Windows 2003)
------------------------------------------
1 Download and install Internet Information Services (IIS) 6.0 Resource Kit Tools. For
download information, go to www.microsoft.com and search on 6.0 resource kit
tools.
2 Stop the IIS Admin Service using the command: NET STOP "IIS Admin Service".
3 On the Start menu, point to Programs, point to IIS Resources, point to
Metabase Explorer, and then click Metabase Explorer.
4 Locate and select the node that represents the SalesLogix Web site (SlxClient):
Expand your server, expand LM, expand W3SVC, expand the Web site ID, expand
ROOT, and select your Web site.
5 Right-click the SalesLogix Web site, point to New, click Key, and then type
SLXMailMergeServer.ashx as the key name.
6 Right-click the new SLXMailMergeServer.ashx key, point to New and then click
DWORD Record.
The New Record dialog box opens.
7 In the Record Name or Indentifier drop-down list, select
DoDynamicCompression, and then click OK.
8 Right-click the DoDynamicCompression record in the grid, and click Properties.
The DoDynamicCompression Properties dialog box opens.
9 Click the General tab.
a In the User Type drop-down list, select File.
b In the Attributes section, select Inheritable.
c Click OK.
10 Reset IIS.
--------------------------------------------
 |
|
|
|
You can
subscribe to receive a daily forum digest in your
user profile. View the site code
of conduct for posting guidelines.
 Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!
|
|
|
|
|
|
|
|