Community
Showing results for 
Search instead for 
Do you mean 

Sage ACT! Premium Web Configuration #SageACT

by Administrator on ‎05-01-2012 01:28 PM (3,970 Views)

In the coming issue of ACT!ion eNews (the Sage ACT! customer newsletter, due out later this month), I spend significant time detailing all the information you should need to make a successful web server setup for web clients and mobile clients for Sage ACT! Premium. In the lengthy article, I dive into both the basic setup of the web server and more importantly the more advanced configuration options for setting up IIS when desired. This intentionally coincides with the latest release of service pack #2 (SP2) for Sage ACT! Premium 2012 as it was just released in the last few weeks and therefore many administrators who will be asked for mobile configuration will hopefully find the article of use. Please let me know what you think of that content and comment on this blog with any questions or issues you are having related to web server setup and configuration. Enjoy!

 

Brian

Comments
by Copper Super Contributor olanjouw
on ‎05-01-2012 03:00 PM

Looking forward to this article.

 

Like to see in depth info regarding:

 

using multiple databases on 1 server and multiple virtual directories

differences between 2003 server and 2008 server (imo premium mobile does not work on 2003 server with custom virtual directories)

using multiple application pools 

multiple APFW directories and upgrades

Outlook integration 

creating new Word mail merge templates (not working you need to edit an existing one...)

Email merges with pictures (hint with default settings it is not working)

ssl + certificates

setting default font + size for notes in ACT! for Web

Export to Excel , date fields are  not recognized as date (need to replace / with -, (dutch reginal settings) so that excel sees it as a date and you can sort it) 

telephone number formatting

by
on ‎05-02-2012 01:09 AM
  • Would also like details on SSL ...
  • Also on what functions might not work with Firefox version post the 4.0 supported one (FF now at V12)
  • Additionally, some pointers on scalability for larger sites - 20-200 users. Both for full APFW and HTML5
  • Any chance Sage will address issues with internetional dialing and times zones in the mobile web?

Regards,
Mike Lazarus
ACT! Evangelist
GL Computing, Australia
http://about.me/GLComputing
http://Blog.GLComputing.com.au
http://twitter.com/GLComputing

GL Computing Facebook Page - http://www.facebook.com/GLComputing
LinkedIN ACT! Fanatics Group - http://www.linkedin.com/groups/ACT-Fanatics-49896

by Administrator
on ‎05-02-2012 03:20 PM

The article goes into app pools and virt dirs, it shows screenshots using IIS 7.  There is not SSL configuration info in this article, but you just gave me a great Idea for another topic!  I'll blog on that next I think as there is confusion in that area, agreed.

When it comes to scaling there indeed are some good pointers, particularly it's important to segment app pools as they all have 2GB limits, so if you have 8GB machine, make 3-4 app pools as each pool will have 2BG to run all the virts' configured to run under it.  I believe I describe that in the article.  Obvious drawback is if you are trying to get all users on the same apppool without segmenting like this you really can't easily scale due to the 2GB limit (per apppool).

 

As far as other things like timezone/dialing can you post some specific examples?  When you say mobile web are you talking about the new update to Sage ACT! Premium  called Sage ACT! Premium Mobile?  OR are you talking about our "Sage ACT! Connect"?  (I've heard some confussion exits out there. 

by
on ‎05-03-2012 08:17 AM

You'll also need to identify differences with IIS6 ..

 

FWIW: I wrote guides on IIS security that Symantec used to train their technical staff.

 

As for as timezone/dialling, there are major issues in BOTH Premium Mobile and Connect ... I'm currently working on an article that says users should wait until these are fixed before rolling out - but, as Sage has had these bugs for 4 years in the Mobile Live testing and release, I'm not holding my breath.

 

I did tell Larry Ritter about these ... his response was that it works well enough for him and that I should stop bugging him and his team with bugs that I found.

 

And yes, there is a lot of confusion about the naming of the products ... Connect HTML5, Connect client and Premium Mobile (which looks the same as Connect HTML5)

 

Regards,
Mike Lazarus
ACT! Evangelist
GL Computing, Australia
http://about.me/GLComputing
http://Blog.GLComputing.com.au
http://twitter.com/GLComputing

GL Computing Facebook Page - http://www.facebook.com/GLComputing
LinkedIN ACT! Fanatics Group - http://www.linkedin.com/groups/ACT-Fanatics-49896

by Copper Super Contributor olanjouw
on ‎05-04-2012 03:22 AM

the most important thing:

How to install ACT! for Web on a 64 bit system with other applications running in IIS 64 bit

 

by
on ‎05-04-2012 12:20 PM

And how to install on SBS  ...  and why there are different "official" statements about SBS support from Sage US and the UK

 

See: http://lnkd.in/CXvC2h

 

Regards,
Mike Lazarus
ACT! Evangelist
GL Computing, Australia
http://about.me/GLComputing
http://Blog.GLComputing.com.au
http://twitter.com/GLComputing

GL Computing Facebook Page - http://www.facebook.com/GLComputing
LinkedIN ACT! Fanatics Group - http://www.linkedin.com/groups/ACT-Fanatics-49896

by Administrator
on ‎05-04-2012 12:58 PM

I'm really interested in the issues with phone dialing.  We've discussed many different approaches and maybe if you have some examples I can review the issue(s) and get with team to discuss and possible revise it.  Can't promise anything, but helping me to understand the situation will go a long way getting a satisfactory solution.  I know we leverage the same api's as our framework and therefore we may need to do some things differently for mobile devices that we overlooked.  I do know that at this point we are running in a browser and that does limit us technically in some aspects of what a "True" application on android/ios device. 

 

Brian

by
on ‎05-04-2012 03:44 PM

It's really very simple ... and I've passed on this information several times to Sage.

 

No offence, Brian ... but considering how Sage management has treated me and refused me any form of free support (they even want to charge me to report bugs), I'll be happy to re-document the methods to fix it at my normal rates.

 

I might add, I made this offer to Larry and Brandon previously ... and you can assume by the fact that these very obvious (and easily fixed) bugs are in even mobile link developed by Sage, as well as the Outlook and Google sync that neither of them decided to take that path.

 

I have the knowledge to fix these and the skills to explain it ... but, I find it difficult to provide those for free to an organisation that has repetedly tried to close my business.

 

Should Larry Ritter's replacement choose to contact me to find a way to a partnership, that is always open to them.

by Administrator
on ‎05-29-2012 03:16 PM

Ok, here is a link to the "Live" Article, it will come out via eNews Tomorrow - but why wait?

 

http://community.act.com/t5/Newsletters-Fast-Tips/ACT-ion-eNews-Spring-2012/m-p/198560/highlight/tru...

by
on ‎05-31-2012 02:30 AM

Brian,

Nice article. Clear and the right depth to give confidence in web appllication installations.

However, in making this information available and with SAPFM increasing in popularity, it encourages people to install APFW whereas before ACT! Premium was installed and on SBS servers. So a typical situation is SBS Server 2011 with ACT! Premium installed, yes not 'supported' by Sage but never the less the commercial reality is that people do this, frequently.

What's more, they hang the business communications off IIS; IP telephony, Active Sync, OWA, Sharepoint etc. This is the modern day Titanic, few lifeboats, charging out into the night. So how much more can we get out of it, well what about APFW now we get this free mobile application?. Well disaster, it will, not possibly, it will break IIS. I know, we have done it, the business communications just stop, dead. You might as well have a 2 day outage of broadband because that is how long it can take to rebuild a server. If there are sufficient sys skills you can stand it up in 2 hours or so but most people will resort to a rebuild, including IT companies.

 

OK so please, before Sage ACT! do anything else start detecting OS systems at install to arrest the possibility of people breaking servers. It needs to happen and it needs to happen now.        

by Administrator
on ‎05-31-2012 03:59 AM
Gleo, is this something you are seeing with service pack 2? I'm surprised in particular because, if anything, it's much more isolated due to the fact that both act web client, as well as mobile client are running in it own application pool - which was intentionally done to isolate us from all the other apps that run under "default" application pools. We feel this is much cleaner, and it was changed starting in service pack 2 and will continue this in the future - in fact other things are getting moved to sage act application pool in next release. So, if there are problems with other iis apps, it should not be possible that it's due to act, its kind of like if word crashes in windows it does not bring down other open apps (unless it reboots windows;-)). Hope this helps, but if you are experiencing issues currently, please give details and I will do what I can to address.
by
on ‎05-31-2012 07:39 AM

Installing SP2 has broken my web server ... and I'm not running IIS and have still NOT been able to resolve it with Greig's help

by Administrator
on ‎05-31-2012 07:55 AM

Not sure where to start here - IIS is the web server software we run within.  Are you saying after you upgraded to ACT! 2012 SP2 it broke the machine?  It broke web clients from accessing web server for ACT! purposes?  I just need more info... Did you make any changes to IIS outside of the upgrade of note?  I'm willing to help or remote desktop in to take a look but I need more details please.

by
on ‎05-31-2012 08:00 AM

Happy to let you remote in, if you like

by Administrator
on ‎05-31-2012 08:48 AM

appears by the log file that IIS is confused as to which version of infragistics dll to use as it's finding both the 8.1 and 11 versions of those dlls.  I believe we use 8.1 but I'll check.  I would do a test to see if you rename 11.0 version dll and see if that changes the error message and it my lead to the solution.

by
on ‎05-31-2012 08:54 AM

Rename from where?

by Administrator
on ‎05-31-2012 09:07 AM

honesly, anywhere you find it on system for the test... best to eliminte variables in my experiance.

 

Infragistics2.WebUI.UltraWebGrid.v11.1.DLL
by
on ‎05-31-2012 10:46 AM

Did a sys wide search and came up with the following:

http://glcomputing.cable.nu/Infragistics2.JPG

 

Which would you recommend I remove?

by Administrator
on ‎05-31-2012 10:51 AM

Ok, I just checked with my web dev lead and he says to get rid of the 8.1 versions of the dll from those folders as we have upgraded to 11 for 2012. (Probably best to rename actualy those 8.1 ones)

 

Brian

by
on ‎05-31-2012 11:00 AM

And the 8.2 ones in the top folder as well?

by Administrator
on ‎05-31-2012 11:10 AM

yes

by
on ‎05-31-2012 12:31 PM

Nearly there ... wonder why the update left the old versions there?

 

Anyway, the demo db in defaul location seems fine

 

Production db in seperate virtual folder (same but requiring windows authentication) ... normal web seems ok, but mobile (/m) returns "The page cannot be found"

by Administrator
on ‎05-31-2012 12:49 PM
This is the 1st I've heard of this, we do many upgrade tests so I'm quite surprised. If mobile is not working but web is not I would check the event viewer and ser if you have a error in there to help. I have a couple of things in mind that it could be, but if we have error details - that would isolate quickly.
by
on ‎05-31-2012 12:59 PM

A couple of errors:

 

Event Type:	Error
Event Source:	AFW
Event Category:	(96)
Event ID:	0
Date:		1/06/2012
Time:		5:15:23 AM
User:		N/A
Computer:	MONTY
Description:
Event "Connected" on interface type "Act.Framework.Workflow.Services.IFrameworkService" for instance id "043bcef4-644d-4aac-872f-79f4d53a3d35" cannot be delivered.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

 

Event Type:	Error
Event Source:	AFW
Event Category:	(98)
Event ID:	0
Date:		1/06/2012
Time:		5:26:28 AM
User:		N/A
Computer:	MONTY
Description:
0:Error occured on page: Global Message:Global error: System.Web.HttpException (0x80004005): Unable to validate data.
   at System.Web.Configuration.MachineKeySection.EncryptOrDecryptData(Boolean fEncrypt, Byte[] buf, Byte[] modifier, Int32 start, Int32 length, Boolean useValidationSymAlgo, Boolean useLegacyMode, IVType ivType, Boolean signData)
   at System.Web.Security.FormsAuthentication.Decrypt(String encryptedTicket)
   at Act.Web.Global.FormsAuthentication_OnAuthenticate(Object sender, FormsAuthenticationEventArgs e)

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

 

Could it be related to the Authentication?

by Administrator
on ‎05-31-2012 01:01 PM
Those appear quite old, unless your clock is set incorrectly?
by
on ‎05-31-2012 01:03 PM

International date format ... I'm in Australia :-)

June 1st

by Administrator
on ‎05-31-2012 01:16 PM
Lol, so it's tomorrow there;-). Anyway, I will send this to my web dev but it looks to me like it may be an impersonation error and if so its an easy fix. Hope o get back to you soon I'm just into a meeting now.
by
on ‎05-31-2012 01:23 PM

Ta ... get me going and I'll tell you tomorrow's lottery results ;-)

by Administrator
on ‎05-31-2012 01:35 PM
Ok, devs are chatting about it now, they want you to check if isapi has wild card mapping done for virtual directory.
Labels