Troubleshooting and FAQs

Microsoft Office loads Add-Ins in the order they were added in Excel. And because Nectari Excel Add-In was installed last, other Add-Ins may interfered with.

1. Untick all Add-In checkboxes and click on OK.
   
2. Close Excel and open it again.
3. Tick the Nectari Add-in for Excel checkbox and click on OK.
   
   
4. Close Excel and open it again.
5. Tick any other Add-in checkboxes you absolutely need and click on OK.
   
   
6. Close Excel and open it again. All Add-ins will work.

When performing a Data Extraction, I cannot add Columns to the Selected Columns section because the Columns section is covering the arrows that allow me to do so.

Solution

In Excel 2016 and up, there is a display settings. If it set to Optimize for best appearance it will mess up the window. Set it to Optimize for compatibility.

The Data Extraction window should be displayed correctly as presented below:

If the "MSOLEDBSQL provider is not registered on the local machine" error message shows up in the BIService.log file, this might be because the Windows server was in pending reboot after a Windows update.

Solution

If not done already, restart the computer on which Excel Add-in is installed.

Let's say you have two servers with Nectari installed with their own Central Point:

Server 1	Server 2

1. Save the same BI License data source on all Central Points:
   1. Log in to the Web Central Point Configurator on each Central Point (refer to Web Central Point Configurator).
   2. Ensure that the BILicense data source is exactly the same for all Central Points.

2. Activate the license on the first server:
   1. Log in to the Web Client on SERVER_ONE (refer to Starting the Nectari Web Client for the first time).
   2. Enter the serial number and validate. The license is now activated and registered in the BILicense database.

3. Restart the BI Service on other servers (SERVER_TWO in this case):
   1. Press the Windows + R keys to open the Run window.
   2. Enter services.msc and press the Enter key.
   3. In the list, right-click on BI Service and select Restart.
   4. Log in to the Web Client (refer to Starting the Nectari Web Client for the first time). You should access to the second Central Point by using the same license.

Repeat steps 1 and 3 for others Nectari servers you want to link to.

1. Go to the User options (refer to User Options).
2. Click on Profile then on Opening Parameters.
3. Under the Landing Page section, click on Delete then on Save to apply changes.

When experimenting an issue with the Web Central Pojnt Configurator, verify if you have a CPConfiguratorClient log file in the following path:

C:\inetpub\wwwroot\CPConfiguratorClient\App_Data\log.txt

If BI License doesn't appear for License Data Source, switch Type to another one and come back to SQL Server to fill in these fields again automatically.

Ensure that the user set on the Application Pool CPConfiguratorPool has enough permissions on Central Point shared folder (Sharing and Security permissions).

1. Open IIS.
2. Select Application Pools, right-click on CPConfiguratorPool and select Advanced Settings.
3. Change the Identity to your new user then restart IIS.

1. Go to the folder in: C:\Program Files\Nectari\Nectari\Service\objserver\ebi_res.bak\.
2. Copy over the files in there and transfer them to its parent folder (C:\Program Files\Nectari\Nectari\Service\objserver).
3. Restart the BI Service and IIS and try again.