Install and Update Problems

Problem

On installing or deleting Foresight Analytics Platform the following error message is displayed:

Error "Database: <path to the *.ipi file>. Cannot Open Database File. System error -2147287035"/"Database: <path to the *.ipi file>. Cannot open database file. System error -2147287035".

Cause

Possible causes:

• User variables have been changed in the TEMP and TMP environments.

• Incorrect permissions have been set for the folder with one of the installed files.

Solution

Below are the variants of solving the problem. If the variant does not work, go to the next variant.

1. If a user variable has been changed and differs from the default value, return the value of these variables: %USERPROFILE%\AppData\Local\Temp.

2. Create a new user, add him to the administrators group and start the installation or deletion.

3. Disable antivirus software during the installation or deletion.

Problem

When installing or deleting via remote desktop, the installation or deletion has been rolled back. The problem occurs on installation or deletion of the Full, Standard, and BIServer kits.

NOTE. This problem may be accompanied with opening of the Windows Installer Coordinator and Windows Installer dialog boxes. The Windows Installer dialog box will contain the message "Install server not responding".

Cause

This problem may occur if the install folder contains an MSI file of help system setup package (FP9Help_RU.msi or FP9Help_EN.msi).

Solution

For correct remote installation or deletion of Foresight Analytics Platform install separately Foresight Analytics Platform and help system. To separately install or delete Foresight Analytics Platform, the folder with Foresight Analytics Platform installer must not contain help system MSI installer. After installing or deleting Foresight Analytics Platform start help system MSI installer (FP9Help_RU.msi or FP9Help_EN.msi).

Problem

On installing the BIServer kit installation rollback occurred. The error occurs if installation is executed by means of the FP9BIServer[Apache/IIS]_x86.exe or FP9BIServer[Apache/IIS]_x64.exe installers.

Cause

This problem may occur if not all necessary IIS components were installed by the user during IIS setup.

Solution

Install all necessary IIS components. See IIS setup description in the Installing Foresight Analytics Platform Web Application section, Step 6. Setting Up Internet Information Services document or on the help system page.

Problem

On installing Foresight Analytics Platform the following error message is displayed:

Could not find files to install required Microsoft SQL Server Native Client 2008 R2 x64 components. Installation will be stopped. It may be connected with unsuccessful or aborted loading.

Cause

This problem may occur if the installer could not find the Microsoft SQL Server Native Client 2008 R2 prerequisite that must be located in the ISSetupPrerequisites folder.

Solution

When installing, the folder with the installer must contain the ISSetupPrerequisites folder with all necessary software that is required for work of Foresight Analytics Platform. See the list of prerequisites in the help system of Foresight Analytics Platform.

Problem

On installing or deleting Foresight Analytics Platform the following error message is displayed:

Error 1402: "Cannot open key: <key>. Check if there are sufficient access permissions for this key or contact the system engineer.

Cause

This problem may occur if the setup program cannot open the registry section because of the absence of permissions for it.

Solution

Below are the variants of solving the problem. If the variant does not work, go to the next variant.

1. Open registry editor (regedit.exe). Expand the branch HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Installer\UserData\S-1-5-18\Components (name S-1-5-18 may differ). Find GUID with the numbers and letters set from the error message. Open the context menu of this GUID section and select the Permissions item. Use the Add button in the Group Permissions dialog box to add the "Administrator", "Administrators", and "system" accounts. If the current administrator account name differs from the Administrator, enter the current user name. Go back to the Group Permissions dialog box. Select each added account and make sure that the Full Access and the Read checkboxes are selected. Click the More button and in the Additional Security Parameters window dialog box execute the following operations:

   1. Select the Replace All Child Object Permissions with Inheritable Permissions from This Object checkbox on the Permissions tab (the Include Inheritable Permissions from This Object's Parent checkbox must be selected).

   2. Select the Administrators name on the Owner tab and select the Replace Subcontainer and Object Owner checkbox.

2. Use the SubInACL Microsoft utility (http://www.microsoft.com/en-us/download/details.aspx?id=23510) and execute the set of commands in the following sequence:

   1. path_to_file/subinacl.exe /subkeyreg HKEY_LOCAL_MACHINE /setowner=Administrator.

   2. path_to_file/subinacl.exe /subkeyreg HKEY_CURRENT_USER /setowner=Administrator.

   3. path_to_file/subinacl.exe /subkeyreg HKEY_CLASSES_ROOT /setowner=Administrator.

   4. path_to_file/subinacl.exe /subkeyreg HKEY_LOCAL_MACHINE /grant=Administrator=f /grant=system=f.

   5. path_to_file/subinacl.exe /subkeyreg HKEY_CURRENT_USER /grant=Administrator=f /grant=system=f.

   6. Path_to_the_file/subinacl.exe /subkeyreg HKEY_CLASSES_ROOT /grant=Administrator=f /grant=system=f.

Problem

On installing Foresight Analytics Platform the Failed prerequisite installation status is returned. On an attempt to manually install the prerequisite the following error message is displayed:

Missing permissions to update <OS_name>. Contact the system administrator. / You do not have permission to update <OS name>. Please contact your system administrator.

Cause

This problem may occur if on installing the prerequisites there are not enough permissions for group policy objects.

For details see http://support.microsoft.com/kb/888791.

Solution

Check permissions to group policy objects:

• File and catalog archiving.

• File and catalog recovery.

• Auditing and security log management.

• File and other object owner assignment.

• System shutdown.

• Program debugging.

To view and change user permissions, execute the operations listed below:

1. Start the group policy objects editor for the local computer or domain. Additional information is described in the Group Policy Management Console article on the Microsoft corporation site.

2. In the Computer Configuration section select the Windows Configuration element.

3. Select the Security Settings item, and then Local Policies and User Rights Assignment items.

4. Set up access permissions to all objects, necessary to install.

Problem

On Foresight Analytics Platform installer startup the process is initialized that copies and starts the installer from a temporary folder. After copying has been made, the process finishes its work before the installation is finished. If several installers are started one by one, all of them are started at the same time. This may result in installation conflict.

Cause

The problem is related to InstallShield 2016 installation features, based on which all Foresight Analytics Platform installers are built.

Solution

To solve the problems, in installer startup options add the parameter clone_wait:

FP9Full.exe /clone_wait

If several installers are started one by one:

FP9Full.exe /clone_wait

"Foresight Add-in for Excel.exe" /clone_wait

Problem

When updating the current version of Foresight Analytics Platform or on deleting Foresight Analytics Platform the error message is displayed:

Transformations application error. Verify that the specified transform paths are valid"/"Error applying transforms. Verify that the specified transform paths are valid».

Cause

The problem is not related with Foresight Analytics Platform, this is a floating error of Windows Installer used for installation.

Solution

To resolve the problem:

1. Run registry editor.

2. In the registry branch HKEY_CLASSES_ROOT\Installer\Products\ find the section related to Foresight Analytics Platform. The search can be executed using the keyword: "Foresight Analytics Platform".

3. In the found section delete the Transforms parameter.

To avoid occurring the problem in the future it is recommended to execute the following operations:

1. Find the registry branch HKEY_LOCAL_MACHINE\SOFTWARE\Policies\Microsoft\Windows\Installer (if the Installer section is missing, create it).

2. In the Installer section create the DWORD TransformsSecure parameter with the 0 value.

3. Deselect the Cache Transforms in Secure Location on Workstation checkbox in the local group policy editor for the Windows Installer application:

1. Using the Start/Run menu, start the gpedit.msc application.

2. Go to the section Local Computer Policy\Computer Configuration\Administrative Templates\Windows Features\Windows Installer.

3. Find the specified option and set the Disabled mode. On executing this operation, the TransformsSecure flag with the 0 value is created in the registry.

4. If remote access is executed via the operating system earlier than Windows Server 2008, create the EnableAdminTSRemote DWORD parameter with the 1 value in the branch HKEY_LOCAL_MACHINE\SOFTWARE\Policies\Microsoft\Windows\Installer.