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:

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.