Friday, November 30, 2012

Accpac Slowness Due to Environment Variable Conflict

When installing Accpac on a windows platform it creates a Environment Variable(Environment variables are a set of dynamic named values that can affect the way running processes will behave on a computer). When you uninstall Accpac from a Windows operating system it doesn't remove the Environment Path Variable. When you perform a new installation on the same operating system it creates a Environment Variable again. So there will be two Environment Path Variables for Accpac. When it comes to a server client architecture we have to install Accpac application server and workstations in client machines. When installing workstations it also creates Environment Path Variable in that particular machine too. So if you uninstall and reinstall Accpac workstation in the same machine then there also will be two environment variables. This PATH variable will have the network address of the Application server. Ex : \\192.168.1.10\Sage\Sage Accpac\Runtime This becomes an issue when you shift the Accpac Application Server to a new network address and install workstations again for shifted Accpac application server. If you don't remove the Environment Variable of the previous installation then there will be two PATH variables for Accpac. When Accpac runs it refers this PATH variable and because of these two variables it will create a conflict. Ultimately this will cause a slowness in Accpac and previewing of crystal reports. Hence it is a good practice to remove Environment PATH Variable after uninstalling Accpac in a networked infrastructure(when you have client server architecture for Accpac) to avoid sallowness in Application and crystal report previewing. Below is how to find Environment PATH Variable Windows Vista and Windows 7 users 01. From the Desktop, right-click My Computer and click Properties. 02. Click Advanced System Settings link in the left column. 03. In the System Properties window click the Environment Variables button. Windows 2000 and Windows XP users The path is now managed by Windows 2000 and Windows XP and not the autoexec.bat or autoexec.nt files as was done with earlier versions of Windows. To change the system environment variables, follow the below steps. 01. From the Desktop, right-click My Computer and click Properties. 02. In the System Properties window, click on the Advanced tab. 03. In the Advanced section, click the Environment Variables button. Finally, in the Environment Variables window (as shown below), highlight the Path variable in the Systems Variable section and click the Edit button. Add or modify the path lines with the paths you wish the computer to access. Each different directory is separated with a semicolon as shown below. C:\Program Files;C:\Winnt;C:\Winnt\System32 After finding the environment variable click edit and find the PATH for Accpac in PATH variables. There can be one or more variables separated by semicolon ( ; ). So you have only to choose the one represents the Accpac it will look like this "\\192.168.1.10\Sage\Sage Accpac\Runtime" without quotations. You have to select the path for Accpac and delete it and save.