Return
-
Title
Problems with uninstalling and reinstall. "Problem with this Windows Installer package" -
Description
After restoring the server Toad Intelligence Central is no longer working. The Toad Intelligence Centra service will not start up.
Trying to uninstall noted some error, as the Suite did not give the option to "remove". Instead it only noted "none" which is not expected. After trying to uninstall via Windows Add/Remove Programs, TIC and the services seem to be uninstalled.
But upon trying to reinstall, errors are encountered. The Suite gave the option to "install". It would start but soon after starting the install process, it would error out with:
"There is a problem with this Windows Installer package. A program run as part of the setup did not finish as expected. Contact your support personnel or package vendor."In Windows Event Viewer, 2 errors were noted:First - MySQL error:The description for Event ID 100 from source MySQL cannot be found. Either the component that raises this event is not installed on your local computer or the installation is corrupted. You can install or repair the component on the local computer.If the event originated on another computer, the display information had to be saved with the event.The following information was included with the event:"Cannot find or open table hub_information_schema/hub_users from the internal data dictionary of InnoDB though the .frm file for the table exists. Maybe you have deleted and recreated InnoDB data files but have forgotten to delete the corresponding .frm files of InnoDB tables, or you have moved .frm files to another database?or, the table contains indexes that this version of the engine doesn't support."Second - MSI error:Product: Toad Intelligence Central -- Error 1722. There is a problem with this Windows Installer package. A program run as part of the setup did not finish as expected. Contact your support personnel or package vendor. Action CreateHubSchema, location: C:\Program Files (x86)\Dell\Toad Intelligence Central\bin\mysql.exe, command: -u root -P 2166 -popenODBC2014! --execute="source C:/Program Files (x86)/Dell/Toad Intelligence Central/conf/hub_information_schema/createHubSchema.sql" -
Cause
Corruption in the existing ProgramData directory. -
Resolution
1. Rename the "C:\ProgramData\Dell\Toad Intelligence Central" folder to backup and clean up the old installation.
Note: This is the default data directory if a user has specified a non default directory then rename that one.2. Re-installing Toad Intelligence Central.Once the installation is complete you may restore the files from the backup ProgramData into the default data directory. Stop the services first then carry over the full Toad Intelligence Central.Note: Both the Data and the Conf folders need to be carried over as they store information needed to re-store previous connections and information. -
Additional Information
Also note restoring the backup may inactive the registered users on TIC. Check after restore is done. It may be necessary to reset the connection details. Try to do this by re-entering the username/password in each connection properties (i.e right click | Connection Properties for each connection noted after connecting to the root). If that doesn't help, also go into the Users node | Administrator and check the Authentication keys. Try edit or delete these if needed to reset. If errors continue after re-installing, i.e. if user cannot carry over ProgramData and have trouble connecting, please refer to KB Article 142413 "'Access denied', cannot connect via root" for further info.