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!

Web Forums - SalesLogix Web Platform & Application Architect
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.

Forums RSS Feed

Back to Forum List | Back to SalesLogix Web Platform & Application Architect | New Thread

View: Search:

Author

Thread: Mail Merge error (Web client) 7.5 SP2

Jim
Posts: 15

Mail Merge error (Web client) 7.5 SP2 Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 19 Jan 10 10:36 AM

I get the following error when bringing up Mail Merge in the Web client: 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.

This in a test environment. Server 2003/IIS6. Upgraded from 6.2 (no Web client) to 7.0 to 7.5 (Web client first created at this stage) to 7.5 SP2. HF 1 applied. Upgrade bundles applied to Administrator and AA. Somewhere in the 6.2 to 7.5 process I also installed legacy components. I did extensive testing along the way and everything seemed to work great, but I failed to test Mail Merge until everything was upgraded. I'm not sure if it ever worked.

Any ideas where I can begin testing the problem or how to manually do a reinstall of Mail Merge at the 7.5 SP2 level? This is my first exposure to the slx environment. Everything I know is only from reading the implementation and upgrade manuals and from some web forums.

Thanks, Jim

[Reply][Quote]

Raul A. Chavez
Posts: 1300

Re: Mail Merge error (Web client) 7.5 SP2 Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 20 Jan 10 9:11 AM

Did you turned Compression on?

If so, turn it off, that typically clears this error message.

[Reply][Quote]

Jim
Posts: 15

Re: Mail Merge error (Web client) 7.5 SP2 Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 20 Jan 10 12:14 PM

Thanks Raul. I did have compression on since it was recommended in the upgrade guide as a performance enhancement. I've turned it off and that fixed the mail merge problem. Thank you much for the suggestion.

I now have a main viewport null error, but apparently that is a known bug in SP2 and everything else seems to be working now.

Jim

[Reply][Quote]

Mike Spragg
Posts: 1226

Re: Mail Merge error (Web client) 7.5 SP2 Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 21 Jan 10 3:41 AM

Jim, you can use compression - however, you must turn it off for mail-merge - see Step 62 on the Upgrading to SP2 document. You can also do this (more simply) by disabling compression for application within IIS.

[Reply][Quote]

Jim
Posts: 15

Re: Mail Merge error (Web client) 7.5 SP2 Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 25 Jan 10 7:45 AM

Thanks for the follow up Mike. I had turned it off completely, but I'll try this.

[Reply][Quote]

Page 1 of 1

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!

slxdeveloper.com is brought to you courtesy of Ryan Farley & Customer FX Corporation. This site, and all contents herein, are Copyright © 2025 Customer FX Corporation. The information and opinions expressed here are not endorsed by Sage Software.	code of conduct \|

page cache (param): 7/1/2025 2:51:47 AM