Working Problems

Problem

Emergency shutdown of BI server process with activated performance tests.

Cause

Emergency shutdown occurs due to triggering of data execution prevention (DEP). When measuring memory consumption, memory allocation or deallocation function calls are intercepted. This is done by recording executable code bytes to memory that triggers the prevention.

Solution

Memory is measured only if data execution prevention is disabled. The prevention can be disabled as follows:

1. Select the System > Advanced System Settings item on the control panel.

2. Click the Settings button on the Advanced tab in the Performance area.

3. Select the Turn On DEP for Essential Windows Programs and Services Only radio button on the Data Execution Prevention tab or add appropriate exceptions:

• When IIS are used, add the w3wp.exe file located in the C:\Windows\System32\inetsrv\ directory to exceptions.

• When Apache web server is used, add the httpd.exe file from the directory with installed Apache web server to exceptions.

Problem

When working in Foresight Analytics Platform the following message is displayed:

The connection was closed by administrator.
Contact the administrator.

Cause

This problem may occur if the user was disconnected from the repository by the administrator.

Solution

Contact the administrator to know when you can continue working with the repository. To continue, reconnect to the repository.

Problem

When repository connection settings are created, edited, or deleted, that is used for all users, the user is denied access.

NOTE. The repository is used for all users if the Anyone Who Uses This Computer radio button is selected in the Repository Parameters dialog box.

Cause

The problem may occur if:

• Foresight Analytics Platform is running without elevating privileges when UAC is enabled.

• The user does not have permissions to write into the HKEY_LOCAL_MACHINE registry key.

Solution

On login to Foresight Analytics Platform as an administrator.

Problem

When the user who is not included into the local administrators group creates repository connection settings, used for the current user, new repository settings are not saved after Foresight Analytics Platform restart.

Cause

When the Only for Me radio button is selected, appropriate registry record is executed. The list of added repositories will be empty because registry values cannot be read.

NOTE. The repository is used for the current user if the Only for Me radio button is selected in the Repository Parameters dialog box.

Solution

To solve the problem, grant the user registry reading permissions.

Problem

After Foresight add-ins have been installed, the Foresight tab is not shown on the ribbon on starting Microsoft Office applications.

Solution

1. Check if Foresight Analytics Platform, Microsoft Office, and Foresight add-in bitness match.
   Check if versions of Foresight Analytics Platform and Foresight Add-In match.
   If bitness and versions mismatch, install applications with matching bitness and versions.

2. If the Foresight tab has not appeared, go to document options and on the Add-Ins tab select the Foresight Add-In in the list of inactive add-ins.
   In the Manage drop-down list select the COM Add-Ins option and click the Go button.
   Then select the checkbox next to the add-in and click the OK button.
   For the changes to take effect, restart a Microsoft Office application.

Problem

On working in the operating system in English after connecting to repository, object names set in Russian are displayed as question marks.

Cause

A repository has been created in an operating system in Russian, and the For Unicode Charset checkbox has been selected for it.

Solution

This problem can be solved only by recreating a repository and selecting the For Unicode Charset checkbox. The databases that contain repository settings must also have the Use Unicode Encoding for Data Representation checkbox selected.

Problem

After Foresight Analytics Platform BI server has been installed in a RedHat-based distribution file, on connecting to Oracle DBMS based repository the error occurs

ERROR: ORA-21561: OID generation failed.

Cause

The error is not related to Foresight Analytics Platform, this may be due to the hosts file contents.

Solution

To resolve the error, perform the following operations:

1. Find computer's IP address ("ip a" command) and computer network name ("hostname" command).

2. Add comparison of IP address and network name into the /etc/hosts file. The file must be opened for edit with administrator permissions:

sudo nano /etc/hosts

Problem

After finishing preparation of PostgreSQL server, when repository is created, the repository manager shows the error message.

Cause

Most frequently errors on working with PostgreSQL driver occur when the path to the Bin folder of the PostgreSQL driver is not added to the Path variable in Windows environment variables.

Solution

It is required to set up PostgreSQL server strictly according to help materials:

1. PostgreSQL server is prepared by the DBMS administrator. The preparation includes the steps described in the Preparing PostgreSQL Server selection.

2. After all steps in the item 1 have been successfully executed, create a repository.

Problem

An error occurs on converting MDM dictionary or composite MDM dictionary into table MDM dictionary. Possible error text:

OLE\COM 0x80040E14. Microsoft SQL Server Native Client 10.0 MSSQL-102: Incorrect syntax near '@errno'.

Cause

If metadata schema was earlier transferred from Microsoft SQL Server 2008 to Microsoft SQL Server 2012, MDM dictionaries are not converted. Transferring of schemas between different DBMS versions is not supported due to difference in SQL syntax.

Solution

Update MDM repository by means of repository manager (RepoMngr.exe). After the successful update repeat dictionary conversion.

Problem

On working with the web application under the user who is not a local administrator or is not in the list of users of the computer with installed BI server, the error occurs:

Catastrophic failure.

Cause

The error occurs if the ForeExec operation is used on executing of a Fore.NET method. It is related with the error of .NET Framework which addresses the registry key of the system account NetworkService - [HKEY_USERS\S-1-5-20\Software\Microsoft\Windows\CurrentVersion\Internet Settings], and cannot access it. The BI server application pool is started under this account.

Solution

To solve the problem, grant the user, under whom the work is executed, registry reading permissions.

Problem

On working in calculation block formula editor of the Calculation Algorithms extension the Access Violation… or Error Loading Form/Component errors occur.

Cause

The problem is not related with Foresight Analytics Platform, it is Windows OS system defect.

Solution

To solve the problem:

• The Foresight Analytics Platform bitness must be the same as Windows OS bitness.

• Install the last Windows OS updates.

Problem

When cube cache is updated in the repository navigator or from application code, an error accessing cache files occurs. The error may also occur on executing cache update task in task scheduler.

Cause

Cache files are used by another instance of Foresight Analytics Platform. For example, BI server instance and desktop application of Foresight Analytics Platform are running on one computer.

Solution

Cube cache should be updated only if one platform instance is running. The task scheduler should be started on a separate server that does not use desktop application or BI server of Foresight Analytics Platform. One can also set up cache update task execution on a separate BI server.

Problem

In web application, on opening objects linked to database, the following error appears:

Database opening rejected.

Cause

On working with objects linked to database, the database opens. To open the database, user credentials are required.

On database creation, the automatic connection was not set up and on objects opening, the Database Authorization dialog box must be opened to input user name and password, but it is not supported in web application.

Solution

To solve the problem, in web application set up automatic connection to database:

1. Open the database in use for edit.

2. Go to the Database Properties in the database edit wizard.

3. Select the Automatic Connection checkbox and select one of the connection options:

• Select the Use Login Credentials checkbox.

• Determine user credentials that will be used for server connection.

4. Click the Next button. The connection to database will be checked.

5. Click the Ready button on the last page to close the wizard.