Recap of Auto Complete performance findings using Build Search Index for Enhanced Search:* Customer was purposely using the enhanced search created by running Build Search Index
* On weekly basis, they manually run Build Search Index to update index for new customers, items, vendors (should have used Task Scheduler to have it run unattended )
* NO performance issues until earlier this week
* Deleting the Index_AC folder restores performance but they don't want the basic search.
* We verified Sage executes Auto Complete search from server but uses a UNC path to find Index_AC folder
This comes from the Path= from wkstn SOTA.INI in [Servers] sections. It also sets ODBC path for Crystal forms and reports
* Directly at the server, Auto Complete was SLOW if PATH= used a UNC path.
* Directly at the server, Auto Complete was FAST if PATH= used a local drive path. But we can't have that setting on workstations.
* We figured WebRoot had a different set of scanning rules for network paths
*** Changes Required to Restore Performance of Auto Complete with Enhanced Search:1. Adding realtime scanning rules in Windows Defender (the Antivirus/Antimalware not the Firewall) not only based on what's in the Sage KB AntiVirus article but also the file extensions found in the Index_AC and Index_Role folders. IT was asked to do same with WebRoot but not sure they did. We are surprised installation of WebRoot didn't disable realtime scanning Defender.
2. Changing the Sage service account to use a domain account instead of LocalSystem, knowing Index_AC folder was being accessed via UNC path from server.
------------------------------
Alnoor Cassim
Email:
alnoor@asifocus.comPh:
Orange County, CA
------------------------------
Original Message:
Sent: 05-14-2021 10:56
From: Wayne Schulz
Subject: Delayed Typing Due to Auto-Complete Feature
Great follow-up - thank you!
------------------------------
Wayne Schulz - Schulz Consulting -
------------------------------
Original Message:
Sent: 05-14-2021 09:40
From: Chris Love
Subject: Delayed Typing Due to Auto-Complete Feature
Just wanted to let everyone know that I found the culprit to this issue. We requested the customer's IT make changes to AV/Firewall to include all of the Sage suggested exclusions in Webroot (not sure he ever completed this request). The issue was still happening this morning and I logged into the server and didn't see Webroot running in the task pane and then it hit me: WINDOWS DEFENDER!
Windows Defender was fully enabled on the Sage server. I added the exclusions to the Sage Directory, the various EXEs and to the file extensions. Tested it and the typing delay was gone! Next time you send out AV/Firewall Exclusions, remember to tell the IT person to make the same changes to Windows Defender if it is enabled on the Sage Server and Workstations.
------------------------------
Chris Love
Accounting Systems, Inc. (ASI)
Original Message:
Sent: 05-11-2021 16:53
From: Jim Woodhead
Subject: Delayed Typing Due to Auto-Complete Feature
You can use SY_Menu_ui and remove the routine off the menu LM Utilities .. that would be the fastest way to delete it or find the roles to restrict it.
Jim Woodhead | Principal Consultant
p: 800.627.9032 x125 | m: 619.990.3946
w: dsdinc.com
Original Message:
Sent: 5/11/2021 3:59:00 PM
From: Chris Love
Subject: RE: Delayed Typing Due to Auto-Complete Feature
We renamed Index_AC and tried rebuilding it again, but I don't think we tested the in between.
Renaming it and testing it does appear to run faster like it used to, so that may be the culprit. Not sure who or what would have ran the Build Search Index to cause that to happen, but that's good to know that we probably shouldn't allow that to happen again.
------------------------------
Chris Love
Accounting Systems, Inc. (ASI)
Original Message:
Sent: 05-11-2021 15:49
From: Jim Woodhead
Subject: Delayed Typing Due to Auto-Complete Feature
Delete the Index_AC's worked for me. Solved a Lot of problems
------------------------------
Jim Woodhead
DSD Business Systems
619-990-3946
Original Message:
Sent: 05-11-2021 15:47
From: Wayne Schulz
Subject: Delayed Typing Due to Auto-Complete Feature
x-ref
Auto-Complete no longer searches the beginning of text for Sage 100 (enhanced versus basic Auto-Complete)
|
Auto-Complete no longer searches beginning of Text after running Build Search Index utility
Build Search Index activates enhanced Auto-Complete feature
How to revert to the older, basic Auto-Complete
- Running the Build Search Index utility on the Library Master Utilities menu activates the Enhanced auto-complete feature.
- When using the Enhanced auto-complete feature, your search criteria is compared with all words within the searched fields. For example, if you have a customer named Allen's Appliance Repair and a customer named Appliance Services, typing Appl in the Customer No. field results in a list that includes both customers.
- In addition, the number of fields included in the search has been expanded. For example, to search for a vendor by phone number, start typing the phone number, digits only, in the Vendor No. field.
- The older, basic version of auto-complete search worked by comparing your entry to the beginning of the customer, vendor, or item name.
Sage 100 2019
- Browse to the ..\MAS90\MAS_SYSTEM directory on the server
- Rename or Delete the Index_AC and Index_ACencrypt directories that were created
- The basic Auto-Complete will now be used
Sage 100 2018
If the older, basic version of auto-complete is desired, perform the following steps:
- Browse to the ..\MAS90\MAS_SYSTEM directory on the server
- Rename or Delete the Index_AC directory that was created
- The basic Auto-Complete will now be used
For more information, in Sage 100 Help, search "Auto-Complete Search"
------------------------------
Wayne Schulz - Schulz Consulting - 860-516-8990