Macola by Exact is a software and database system that is marketed mainly to companies involved in manufacturing. The system handles everything from accounting, distribution, manufacturing, human resources, payroll, budgeting, financial reporting and e-commerce. At work I had to migrate an instance of Macola Progression 7.6.400 to new server. After the migration clients had to be re-installed on almost all workstations company wide. I had such a difficult time re-installing the Macola Progression clients that I decided to share the knowledge I had gained through this excruciatingly painful process so that others might not have to lose any their hair or spend hours beating their heads against the wall....you're welcome! :)
STEP 1: COMPLETE REMOVAL
NOTE: This was performed on a Windows 7 Professional 64 Workstation. This will differ on 32 and XP Machines but the process pretty much exactly the same.
Start by deleting the Macola Progression SQL Client folder and files from your program files folder located at C:\ProgramData\Microsoft\Windows\Start Menu\Programs\Macola Progression SQL Client.
Now go to Programs and Features(Add/Remove Programs) and look for Fujitsu COBOL Free Runtime and uninstall this if it exists.
Next, locate and delete the fujitsu and Macola Shared folders located in C:\Program Files (x86)\Common Files.
Now locate and delete the MACOLA7.INI file located in C:\Windows
Next you need to remove the registry keys for Macola and Fujitsu. Open regedit.exe and delete the following registry keys and their sub keys.
HKEY_CURRENT_USER\Software\Macola
HKEY_CURRENT_USER\Software\Classes\VirtualStore\MACHINE\SOFTWARE\Wow6432Node\Macola
HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Fujitsu
HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Macola
Finally, you will run the Setup.exe from the Macola App server. The location of this will differ depending how you mapped your drives or the location of your sever but the official documentation says M:\macsql\Install\Setup.exe. The official documentation recommends that you run this file from the mapped location and not the UNC path, \\ServerName\MACAPPS\macsql\Install\Setup.exe. To do this go to run and type, M:\macsql\Install\Setup.exe and press enter. I've tried it both ways and it seems to work either way. When the install dialog pops up select the option to remove and uninstall.
Once the uninstall process completes, reboot your computer and the Macola Progression SQL Client will be completely removed from your computer!
STEP 2: FRESH INSTALL
Now that you have completely removed Macola Progression SQL Client you are ready to install a clean instance. I recommend following the official documentation by running the Setup.exe again from the mapped location by going to run, typing M:\macsql\Install\Setup.exe and pressing Enter. When the setup dialog opens it might work just like a new install. It also might default back to the remove option. If it does don't worry everything is fine, just select the Repair option and continue with the installation. When the installation completes it will require you to reboot your computer. Restart the computer before you take any further actions.
After the computer restarts navigate to C:\Windows, locate the MACOLA7.INI file and give yourself modify access to the file. Once you have modify access, open the file in notepad and locate the variable, "70Root-Dir". Check to make sure that its value is NOT the UNC path, e.g. \\ServerName\\MACAPPS\macsql. Instead use the mapped location M:\macsql. Save your changes and exit notepad. Remove the modify access back to the way it was, read/execute. You can also just leave it be but of course it's more secure to remove the modify access after you have modified the file.
Next check the targets of the shortcuts to, again, make sure they are NOT pointing to the UNC path e.g. \\ServerName\MACAPPS\macsql\Macola32.exe and are instead pointing to the mapped locations, M:\macsql\Macola32.exe. Go into C:\ProgramData\Microsoft\Windows\Start Menu\Programs\Macola Progression SQL Client and make these changes for each shortcut.
Once you have made these changes to the MACOLA.INI file and the shortcuts, we will have to verify that the installation has set the environmental variables correctly. To do this go to Control Panel, System, Advanced Settings, and Environmental Variables. Locate a variable named "path" which should have a value beginning with C:\Program Files (x86)\Common Files\Fujitsu\COBOL. If you do not see this, that is OK just create a new variable. The full value should be the following. Just copy and paste the following.
C:\Program Files (x86)\Common Files\Fujitsu\COBOL;%SYSTEMROOT%\SYSTEM32;%SYSTEMROOT%;%SYSTEMROOT%\SYSTEM32\WBEM;%SYSTEMROOT%\SYSTEM32\WINDOWSPOWERSHELL\V1.0\;C:\PROGRAM FILES (X86)\INTEL\OPENCL SDK\2.0\BIN\X86;C:\PROGRAM FILES (X86)\INTEL\OPENCL SDK\2.0\BIN\X64;C:\PROGRA~2\COMMON~1\FUJITSU\COBOL;C:\Program Files (x86)\Common Files\Macola Shared;C:\Program Files (x86)\Microsoft SQL Server\80\Tools\Binn\;C:\Program Files (x86)\Microsoft SQL Server\90\Tools\binn\;C:\Program Files (x86)\Microsoft SQL Server\90\DTS\Binn\;C:\Program Files (x86)\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\;C:\Program Files (x86)\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies\
Click OK, and then OK once more.
Once you have completed these steps the Macola Progression SQL Client should be installed correctly.
Thanks for this!
ReplyDelete