Open the folder indicated in the error message.
Right-click the folder and click Sharing and Security.
Click the Security tab and click Add.
In the Enter the object names to select box, type the name of the account indicated in the error message, and then click OK.
Under Allow, ensure that the Read & Execute, List Folder Contents, Read and Write check boxes are selected.
Click OK.
When the warning message is displayed, click Yes.

The permissions granted user ‘domain\username’ are insufficient for performing this operation

This error indicates that the user does not have sufficient rights to access the reporting services site.

This error can also occur when trying to deploy the Reporting Services reports from a Windows Server 2008 server with User Account Control enabled. The steps to resolve this error are different than for when the end user encounters this error. Both resolutions are described below.

Steps to Resolve

To resolve this error for the end user:

You must assign your BizInsight users to the Content Manager role in Reporting Services security. Reporting Service security is accessed by browsing to the Reporting Services Report Manager URL (ex. http://servername/reports):

SQL Server Reporting Services 2005 and 2008, go to the Properties tab:

SQL Server Reporting Services 2008 R2, click on the Folder Settings button.

The following screenshot shows an example of a Reporting Service site with user security configured. The user named “linda” has been given Content Manager permissions.

To resolve this error when deploying Reporting Services report:s

Run Business Intelligence Development Studio as administrator by locating the program in the Programs menu, holding down Ctrl + Shift and then right-clicking on the program and choosing Run as Administrator. This will elevate your privileges so that you can deploy the reports.

Cannot open database ‘dbname’ requested by the login.

This error indicates that the user does not have rights in SQL Server to the accounting system database. Or, if using SQL authentication, the user mistyped their login id or password.

Figure 1 – Error message with XMLFast enabled

Figure 2 - Error message without XMLFast enabled

Steps to Resolve

1. Click on Start > Programs > Microsoft SQL Server 2005(or 2008/2008 R2) > SQL Server Management Studio.

2. The Connect to Server dialog will open. Make sure the Servername is correct and click Connect.

3. In the left pane, expand Security, right-click on Logins and click New Login .

4. In the Login – New dialog box, enter the user’s name in the Login name field. Click on Search to browse for an existing Windows login id. Or type in a name to use for a SQL login id.

It is possible to use an Active Directory group that contains all BizInsight users. To add a group, be sure to click on the Object Types button and check the Groups checkbox. This will ensure that your group will be found by your search.

5. Click on User Mapping in the left pane.

Check the Map checkbox next to the accounting system database or if this content pack uses a Linked Server, check the Map checkbox next to the master database. Check the db_datareader role membership in the bottom pane. Click OK.

Failure: Login failed for user ‘username’

This error will occur if the XMLFast feature is enabled and login credentials are stored in the Reporting Services data source. When using XMLFast, authentication for the data source either needs to be set to Windows authentication or to prompt for SQL credentials.

Steps to Resolve

A short term solution for this issue is to disable XMLFast by unchecking it in the BizInsight Application Settings dialog.

In order to use XMLFast, the data source needs to be configured to either use Windows authentication or prompt the user for credentials. Perform the following steps to make this adjustment:

1. Browse Reporting Services Report Manager URL (ex. http://servername/reports)

2. Click on the Data Sources folder

3. Click on the data source being used by BizInsight (BizNetMAS90, MAS500, DYN_SL, etc)

4. Choose either of the highlighted options. Then click Apply.

6. If you choose to have the credentials supplied by the user, be sure to check the Persist SQL Credentials checkbox in the BizInsight Application Settings on the client workstation to ensure that the user is not prompted each time a data retrieval call is made.

The specified reportserver URL http://servename/Reports could not be found

This error will occur if you have entered the Report Manager URL for the TargetServerURL of the reporting service solution you are trying to deploy instead of the Web Service URL (ex. http://servername/ ReportServer)

Steps to Resolve

1. The solution name will vary by content pack. Right-click on the project name in the Solution Explorer pane and choose Properties.

2. Change the Target Server URL to the correct path for your report server Web Service URL. Click OK.

IMPORTANT: If your Report Server Web Service URL uses a non-default port, be sure to include that port number in the TargetServerURL. For example “http://BizNetSvr:8080/ReportServer”.

Error: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible.

This error indicates that there is some kind of connectivity problem between the client workstation and the server where the linked servers have been created. The most common cause of this issue is that necessary server configuration changes have not been made for the XMLFast feature to work.

If you have been using a BizInsight version older than 5.0.3.4, the XMLFast feature added in the 5.0.34 release is enabled by default. For this feature to work properly, you must confirm that the following requirements are satisfied on the server:

· TCP/IP remote connection must be enabled for SQL Server

· The SQL Browser service is started

· Server firewall exceptions must be added for TCP Port 1433, UDP Port 1434 and a program exception for sqlservr.exe

· The Reporting Services data source is not configured with stored user credentials.

Steps to resolve

1. CheckTCP/IP and SQL Browser

The steps to check whether TCP/IP is enabled vary depending on your SQL Server version. The steps for SQL Server 2005 are as follows. For SQL Server 2008 or higher, click here.

SQL Server 2005

1. Click on Start > All Programs > Microsoft SQL Server 2005 > Configuration Tools > SQL Server Surface Area Configuration.

2. Click on Surface Area Configuration for Services and Connections .

3. In the left pane, click on SQL Server Browser. When the right pane has refreshed with the options for the SQL Server Browser, make sure that Startup Type is set to Automatic and click on Start if the service is not started.

4. Under Database Engine , click on Remote Connections. Select the Local and Remote Connections radio button to enable remote users to access this SQL Server instance. Click Apply.

5. An alert dialog will be displayed indicating that the changes will not take effect until the Database Engine service is stopped and restarted. Click OK.

In the left pane, expand Database Engine and click on Service. In the right pane, click on Stop and then click on Start when that button becomes enabled. Once the service is restarted, click OK to exit the Surface Area Configuration tool.

Click here to skip to the section describing adding Windows Firewall exceptions.

SQL Server 2008 or higher

1. Click on Start > All Programs > Microsoft SQL Server 2008 (2008 R2) > Configuration Tools > SQL Server Configuration Manager .

2. Expand SQL Server Network Configuration and select the Protocols for InstanceName that corresponds to the SQL Server instance that hosts the accounting system database

3. Verify that the TCP/IP Protocol is Enabled. If it is not enabled, double-click on the protocol and change its properties to enabled. You will receive a warning that the service will need to be stopped and restarted:

4. Go to the SQL Server Services section. Select the SQL Server service and click on the restart the service button.

5. In the SQL Server Services section, verify that the SQL Server Browser service is started. If it is not, double-click on the service to open the service properties.

6. Click on the Service tab and verify that the Start Mode is set to Automatic and change it if it is set to Disabled or Manual.

7. On the Log On tab, click on the Start button to start the service

2. Add Windows Firewall Exceptions

This steps may not need to be performed if the Windows Firewall is turned off on the server.

Server 2003 (click here to go to the Server 2008 instructions )

1. Click on Start > Control Panel > Windows Firewall

2. On the Exceptions tab, click the Add Port button.

3. In the Add a Port dialog, enter a name for the exception entry and type 1433 for the port number. Click OK.

4. Add a second port exception for UDP 1434.

5. Click the Add Program button then click the Browse button

6. Browse to the SQL Server installation’s Binn directory and select the sqlservr.exe.

7. Close the Firewall dialog after making these additions.

Server 2008

1. Click on Start > Administrative Tools > Windows Firewall with Advanced Security

2. Click on Inbound Rules.

3. Click on New Rule.

4. Choose the Port radio button and click Next.

5. Leave the TCP option selected and type in port 1433. Click Next.

6. Leave the Allow the connection radio button selected and click Next.

7. Uncheck the Public checkbox and click Next.

8. Type a name and description for the exception and click Finish.

9. Repeat these steps to add a UDP port exception for port 1434.

10. Add a third new inbound rule for a program exception.

11. Click on the Browse button and browse to the SQL Server installation’s Binn directory and select the sqlservr.exe. Then click Next.

12. Leave Allow the connection selected and click Next.

13. Uncheck the Public checkbox and click Next.

14. Type a name and description for the exception and click Finish.

Your current license restricts you to X Designer users (or Power users)

This error will occur when you have entered more names in the referenced user type’s .users file in the admin shared directory than your license allows. This error can also occur if you have a line return after the last name in the file.

Steps to Resolve

1. Browse to the Admin shared directory.

2. Open the .lic file with Notepad and verify how many licenses exist for the user type indicated in the error message.

3. Open the .users file with Notepad that corresponds with the error message.

4. In the .users file, verify that the number of names entered does not exceed the number of licenses indicated in the license file. Also verify that there are no line returns after the last name entered in the file.

Cannot import Excelxxxx_register_OnDemand.reg. Error opening the file.

This error can occur on Windows 7 workstations with User Account Control enabled. The error occurs because user account control elevates the user’s permissions and changes what the operating system considers to be the current location such that the file referenced in the error message is not found.

Steps to Resolve

1. Browse to the reg5 subdirectory of the local BizInsight directory.

2. Open the Register BizInsight for Excel xxxx_register_OnDemand.bat with Notepad.

3. Add the file directory path to each entry in the file. For example, in the below screenshot, BizInsight was installed to C:\BizNet Software\BizInsight and the paths to the .reg and .dll files were added to each line:

Notice that the second path points to the bin5 subdirectory and not the reg5 subdirectory. Be sure to enclose paths with spaces in them in double-quotes.

‘C:\Users\username\Documents\BizContent\BizNetERP.xll”, is in a different format than specified by the file extension.

This error will occur when the BizContent add-in is 32-bit and the Excel version is 64-bit.

Steps to Resolve

Until 64-bit compatible BizInsight and BizContent versions are available, the only resolution is to uninstall Excel and install a 32-bit compatible version.

There was a problem locating a valid .biz file

This error will occur when the Configuration Path specified in the Application Settings dialog is incorrect or if the path is correct, that the .biz files have not been copied to the directory.

Steps to Resolve

1. Open the Application Settings dialog and copy the Configuration Path.

2. Open Windows Explorer, paste the path and press Enter.

3. Verify that the directory is accessible and is the directory intended to store the shared content files. If it is not the right location, correct the Configuration Path in the Application Settings dialog and test to see if the issue is resolved.

4. Verify that the .biz files exist in the directory that the Configuration Path setting points to and if they are not there, copy them to that directory and test again. Refer to Step 6: Create and Populate Shared Directory in the Installation Guide for BizInsight and BizContent 5.0 for information on where to find the .biz files.

Unable to expand top node of the Navigation Pane

If you are not able to expand the content pack node in the Navigation Pane, your login id has not been added to one of the .users files in the admin share directory or a BizBroadcast license has been copied into the admin share directory.

Steps to Resolve

1. Click on the Application Settings dialog and copy the Administration Path. Browse to that directory and confirm that .users files are present in that directory. If they are not there, refer to Step 6: Create and Populate Shared Directory of the Installation Guide for BizInsight and BizContent 5.0 for steps on adding those files to this directory.

2. In Excel, click on the About button on the BizInsight ribbon or toolbar to check your rights.

3. Verify that the name displayed has been added to one of the .users files (Designer.users, Power.users or Drilldown.users) in the admin shared directory.

4. Verify that the entry in the .users file exactly matches the username displayed in the About dialog.

5. Verify that there is only one .lic file present in the directory. If a BizBroadcast .lic file is also in that directory move it to a different location.

Function arguments dialog contains no parameters and functions return #NAME?

This situation indicates that the BizContent add-in that supplies that particular function is not registered in Excel. If this is occurring for a non-BizInsight user, refer to the section titled “Distributing Reports to non-BizInsight Users” in the document Guide to Using BizInsight 5.0.

Steps to Resolve

1. Click on the Application Settings dialog and copy the Configuration Path. Browse to that directory and confirm that the three BizContent add-in files for the module are present in the content share directory. If they are not there, refer to “Step 6: Create and Populate Shared Directory” of the Installation Guide for BizInsight and BizContent 5.0 for steps on adding those files to this directory.

2. In Excel, click on the Scan for Content button to re-scan for content. Restart Excel and check to see if that resolved the issue.

3. If the issue is still not resolved, check to see if the add-in is disabled. To do this, open the add-ins dialog for the Excel version on the client workstation:

Excel 2010 - Click on File > Options
Excel 2007 - Click on the Office button and then click on the Excel Options button.

In the right pane, scroll to the bottom of the add-ins and check the section named Disabled Items for the missing BizContent add-in.

If the add-in is shown as disabled, click on the Manage drop down list and choose Disabled Items and then click Go. Select the add-in and click the Enable button.

Excel 2003

a. Click on Help > About Microsoft Office Excel

b. Click on the Disabled Items button.

c. Select the add-in and click the Enable button.

Cells update with #VALUE when using Excel 2013

This is a known issue with BizInsight version 5.0.34.2.

Steps to Resolve

Click on the About button on the BizInsight ribbon and check your BizInsight version. If it is version 5.0.34.2, uninstall that version and install the latest BizInsight version.

“Microsoft Excel has stopped working” error using Excel 2013

The Enable Formula Editor Pop-up option cannot be enabled at the same time as the Enable Cache Information Dialog option 2013. After dragging and dropping a function and supplying parameters in the Function Arguments dialog that opens automatically, the following error occurs and Excel closes:

Steps to Resolve

Click on the Application Settings button on the BizInsight ribbon menu and uncheck the Enable Formula Editor Pop-up checkbox, OR if you would like the formula editor window to open automatically, uncheck the Enable Cache Information Dialog. This will allow the formula editor pop-up window to work but will turn off the data caching information windows that are displayed when a report is refreshing.

Drilldown Options are disabled in Excel 2013

When opening a BizInsight report and right-clicking on a cell containing a BizInsight function, the Drilldown options are disabled.

This issue is caused by the fact that the BizInsight drilldown menu is being built dynamically. If a blank Excel workbook or a workbook without BizInsight functions is the first workbook opened when Excel is opened, the drilldown menu will not be built.

Steps to Resolve

This issue has been resolved in BizInsight version 5.0.34.3 or higher. Click on the About button on the BizInsight ribbon in Excel to verify the BizInsight version that is installed. If it is version 5.0.34.2, uninstall and install the latest BizInsight version.

“Your security permissions do not allow this action” dragging and dropping an analysis set

Viewer users who have upgraded to BizInsight version 5.0.34.2 and drag and drop an analysis set receive the error “Your security permissions do not allow this action”

Steps to Resolve

Uninstall the 5.0.34.2 version and install 5.0.34.3 which resolved this issue.

Cells update with #VALUE

The #VALUE error can have several underlying problems.

Steps to Troubleshoot

The following steps will help you identify the underlying problem and hopefully that issue is documented elsewhere in this document with steps to resolve.

1. On the BizInsight ribbon tab or toolbar, make sure that BizInsight is not Offline.

2. Make sure BizInsight is loaded before trying to refresh the report or change input parameters. See “3.1. Starting BizInsight” in Guide to Using BizInsight 5.0 for information on how to properly start BizInsight.

3. Go into the Add-ins dialog and check that the BizContent add-ins are enabled and located in a local directory location and not a network location. Steps to open the add-ins dialog:

Excel 2010 - Click on File > Options
Excel 2007 - Click on the Office button and then click on the Excel Options button.

Excel 2003 – Click on Tools > Add-ins.

If the add-ins are in a network location, you need to change the local content path for the user to a local directory and re-scan for content (Scan for Content is a BizInsight version 5.0.34 or higher feature). See “Step 9: Configure BizInsight” of the Installation Guide for BizInsight and BizContent 5.0 for steps on changing the local content path.

4. Open the BizNet Software event viewer log and check for errors. As you look at the event viewer log, if you see entries about the data set being empty, look for errors just before that error for the error that is causing the data set to be empty. To get to the Event Viewer log, go to Start > Control Panel > Administrative Tools > Event Viewer. If BizInsight 5.0.34 is installed, the BizNet Software event viewer log can be accessed from the Support Tools located at the bottom of the BizInsight About dialog.

If the BizNet Software event viewer log is not present and the client workstation is running Windows 7, turn off User Account Control (‘UAC’), reboot the computer and start Excel once to trigger the creation of the event viewer log. Reproduce the issue and check the log. Be sure to set UAC back to its original setting.

5. Check one function that is returning a #VALUE. If you are changing the sign of the data returned by the function with a *-1, remove that temporarily to see whether a more informative error is displayed. If this is a Power user, try temporarily making them a Designer user so they can edit the function to reveal the true error.

6. Implement the most current content pack available for the module you are trying to use. Refer to the document named Applying BizInsight and BizContent Updates for steps on how to implement content pack updates.

7. Re-register BizInsight and then re-scan for content. To re-register BizInsight:

a. Click on Start > Programs > BizNet Software > Re-Register BizInsight for Excel xxxx On Demand.bat. If you do not see this option on the Programs menu, browse to the reg5 subdirectory of the BizInsight installation directory on the workstation to locate the Re-register BizInsight for Excel xxxx On Demand.bat file.

b. Open Excel and click on Scan for Content to re-scan for content.

The Request Failed with HTTP status 404: Not Found."

This error will occur if the Report Manager URL was entered for the Default Reporting Services Server during installation instead of the Web Service URL.

Steps to Resolve

1. Open Excel and click on the Application Settings button on the BizInsight ribbon or toolbar.

2. Check the Default Reporting Services Server parameter and if it has a URL similar to http://servername/Reports, change the “Reports” portion to “ReportServer”.

Cannot run the macro ‘BizData. The macro may not be available in this workbook or all macros may be disabled

This error usually indicates that one of the product components is not registered in Excel. This can often occur after a new installation.

Steps to Resolve

1. Re-register BizInsight and then re-scan for content. To re-register BizInsight:

b. Open Excel and click on Scan for Content to re-scan for content.

"The specified DSN contains an architecture mismatch" creating linked server

This error will occur for implementations that use linked servers and the ODBC data source driver is 32-bit but the SQL Server installation in which the linked server is being created is 64-bit.

Steps to Resolve

Uninstall the 64-bit SQL Server or install a 32-bit bit version side-by-side with the existing 64-bit SQL Server installation.

BizInsight is not loaded

By default, BizInsight is designed to load On Demand which means that if you want to work with BizInsight, you have to start it up within Excel prior to doing anything else in Excel. This error can also occur if you double-click on a BizInsight report to open it and Excel starts re-calculating before you have had a chance to load BizInsight.

Steps to Resolve

To resolve this issue, you must load BizInsight in Excel before accessing a BizInsight report. If you have been working in Excel already with non-BizInsight reports, you must either close and reopen Excel or start a new Excel session that BizInsight can be loaded before anything is done in Excel. To load BizInsight, click on the BizExplorer button on the BizInsight ribbon or toolbar.

HTTP status 400 bad request

This error usually indicates a problem with the URL entered for the Default Reporting Services server in the Application Settings dialog.

Steps to Resolve

1. Click on the Application Settings button on the BizInsight ribbon or toolbar.

2. Check the Default Reporting Services Server parameter for trailing spaces.

3. Open an internet browser dialog and paste the URL in the address field. If the page is not found, check for typographical errors in the URL.

Error: Connection was closed. Could not establish trust relationship for the SSL/TSL secure channel

This error will occur when Reporting Services is configured to use SSL when it shouldn’t be or SSL is incorrectly configured or there is a problem with the security certificate.

Steps to Resolve

If SSL is not required:

1. Open the Reporting Service Configuration Manager and remove all SSL entries.

2. Check the SecureConnectionLevel parameter of the rsreportserver.config file to make sure it is correctly configured to 0. The steps for performing this step are documented in this Microsoft bug posting: http://connect.microsoft.com/SQLServer/feedback/details/686214/removing-ssl-cert-in-config-manager-doesnt-properly-modify-rsreportserver-config

If SSL is required:

BizNet Software Support will not assist with issues configuring SSL for Reporting Services. Microsoft has articles describing how to properly configure Reporting Services for SSL. Refer to the appropriate Microsoft article for steps on how to configure SSL:

SQL Server 2005 - http://msdn.microsoft.com/en-us/library/ms345223(v=SQL.90).aspx

SQL Server 2008 - http://msdn.microsoft.com/en-us/library/ms345223(v=sql.100).aspx

SQL Server 2008 R2 - http://msdn.microsoft.com/en-us/library/ms345223(v=sql.105).aspx

The remote name could not be resolved ‘servername’

This error occurs when there is a problem occurring during the data retrieval from the Reporting Services server. This could be caused by an incorrect Reporting Services URL in the Application Settings dialog or the Reporting Services service is stopped.

Steps to Resolve

To troubleshoot this issue, do the following:

1. On the server, go to Start > Programs > Microsoft SQL Server xxxx > Configuration Tools > Reporting Services Configuration Manager.

2. Check that the Reporting Services service is running. If it is not, start it and then test whether this resolves the issue. Be sure to close and reopen Excel for the test.

3. If the service is started and the SQL version is 2008 or 2008 R2, go to the Web Service URL page of the Reporting Services Configuration Manager tool and note the URL.

4. In Excel, open the BizInsight Application Settings dialog. Copy the URL provided for the Default Reporting Services Server parameter and paste it into a Browser dialog. If it does not take you to the site, verify that the URL matches what you wrote down in Step 3. OR, type the URL that you noted into the browser dialog and see if you can get to the site. Be sure to include the port number if a different port than port 80 is being used. If the URL provided in the Application Setting dialog is wrong, correct it and test again.

5. On the server, confirm that the firewall is not blocking the reporting services port, usually port 80. To quickly test whether it is a firewall issue, temporarily turn off the firewall and try accessing the reporting services site from the client again. If the server can be accessed, the problem is caused by the firewall and an exception needs to be made for accessing Reporting Services.

Error generating DrillDown menus: Object reference not set to an instance of an object

This error occurs when the Navigation Pane is collapsed. The Navigation Pane must be visible/expanded when working with BizInsight.

Steps to Resolve

The Navigation Pane contains buttons that allow you to easily access the different functional elements of the product. The Navigation Pane can be collapsed by clicking on the vertical dots in the middle of the right edge or re-sized by clicking on the right edge and dragging to the left. To re-display the Navigation Pane after collapsing it, click on the vertical dots again.

Error using Refresh Pivot Cache right-click option

When right-clicking on a pivot table and choosing the Refresh Pivot Cache option, the following error can occur:

Exception Source:

Exception Type: System.Runtime.InteropServices.COMException

Exception Message: Exception from HRESULT: 0x800A03EC

Exception Target Site: ForwardCallToInvokeMember

This error will occur if the pivot table selected was created by BizInsight. This option can only be used on an Excel pivot table that you created using Excel’s Insert Pivot Table option.

Scan For Content Button Missing from Ribbon

On some workstations, the Scan for Content button may not show up on the BizInsight ribbon in Excel after installation. Take the following steps to resolve this issue:

1. Close Excel.

2. Open Windows Explorer and browse to the Microsoft Office user directory.

a. Windows 7 C:\Users\ username\AppData\Local\Microsoft\Office

b. Windows XP C:\Documents and Settings\ username\Local Settings\Application Data\Microsoft\Office

3. Rename the Excel xx.CustomUI file in that directory.

a. Excel 2007 this file will be named “Excel12.CustomUI”

b. Excel 2010 this file will be named “Excel14.CustomUI”

4. Browse to the reg5 subdirectory of the BizInsight local installation directory and run the file named Register BizInsight for Excel xxxx OnDemand.bat, where xxxx is the Excel version.

5. Close and reopen Excel and check the ribbon for the Scan for Content button.

C:\Users\username\Documents\BizContent\xxx .xll could not be found

This error can occur upon the start of Excel when the filename for a content add-in file has been changed. Scan for Content will identify and remove old content add-in files but is not able to update the registry entries that still point to those old files.

To resolve this issue, do the following:

3. Go to the Excel add-ins dialog. The steps for each Office version are as follows:

Excel 2010

a. Click on File > Options.

b. Click on Add-ins in the left pane and then click on Go at the bottom on the right pane.

Excel 2007

a. Click on the Office button and then click on the Excel Options button.

b. Click on Add-ins in the left pane and then click on Go at the bottom on the right pane.

Excel 2003

a. Click on Tools > Add-Ins

4. In the Add-ins dialog, click on the Browse button.

5. Once in the add-ins dialog, uncheck the content add-in. You will get the following message. Click Yes.

Close and reopen Excel.

Attempted to read or write protected memory

The following exception can occur and cause Excel to crash when BizInsight is installed:

This error is commonly caused by a conflict with another add-in that is installed within Excel. The most common one that causes this issue is the Microsoft Analysis Toolpak VBA add-in. Application conflicts are a fact of life, and Excel is no different. Since our application is hosted by EXCEL.EXE, other add-ins may conflict or causes issues with BizInsight.

At this time, the only option to resolve this issue is to disable the conflicting add-in. To determine what other add-ins might be installed and active in Excel, open the add-ins dialog using the appropriate method for the Excel version installed:

Excel 2010 - Click on File > Options

Excel 2007 - Click on the Office button and then click on the Excel Options button.

Excel 2003 – Click on Tools > Add-ins.

In the add-ins dialog, look at the Active Add-ins section to identify add-ins that are not BizInsight or BizContent related (Examples of BizInsight/BizContent add-ins are highlighted):

To determine whether other add-ins listed are causing the problem, look at the Type of the add-in in the far right column and then go to the bottom of the dialog and change the Manage drop down list to the appropriate Add-in type and click Go.

Uncheck the add-in in the Add-ins dialog then close and reopen Excel and see if the error still occurs. Repeat this action for each active add-in to see which one, if any, are the culprit.

Method not found: 'System.Collections.Generic.List`1<System.String> BizSSRS.MISReportingService.GetReportParmsArray(System.String, System.String ByRef, System.String ByRef, System.String)'.

This error message will occur when the previous BizInsight version was not uninstalled from the workstation before installing the current BizInsight version.

To resolve this issue, uninstall and reinstall the current BizInsight version.

Failure: Unable to cast object of type 'BizSSRS.ReportService2005.InvalidDataSourceReference' to type 'BizSSRS.ReportService2005.DataSourceReference'

This error usually indicates that the user does not have sufficient permissions to a folder on the reporting services site. You’ll need to check the security setup at each level and determine which level for which the user does not have correct permissions. Users need Browser rights to the Data Sources folder and Content Manager rights to the data source itself. There are 4 possible levels where security can be set and each level needs to be checked to see if the user is missing at one of the levels or has insufficient rights.

Home

>>>>Data Sources

>>>>>>>>>> Data Source object (ex. MAS500, Ross, BizNetMAS90, etc.)

>>>> Content folder (ex. BizNetMAS500, MAS90ProvideX, Ross, DYNSL, etc.)

To resolve this issue, do the following:

1. Browse to the Report Manager site while logged in as a user with Content Manager rights to the site. This could be another BizInsight user who is not experiencing this error or as a user that belongs to the local administrators group of the reporting services server. If you are not sure of the Report Manager URL, copy the default reporting services URL provided in the Application Settings dialog accessible from the BizInsight ribbon menu in Excel. Change the “ReportServer” part of the URL to “Reports” and then browse to that site.

2. At the Home level or folder level, you will click on either the Folder Properties button or the Properties tab (depending on which Reporting Services version you’re using).

3. For the data source object, you click on the object and then click on Security in the left pane to see that object’s security.

4. If you see a Revert to Parent Security button, that means the security is not being inherited by that object and so the user must be added to that object’s security so that the user can access it. For the Data Sources folder, Browser rights are sufficient.

5. If the security at the Data Sources folder looks good, click on the data source object itself and go to Security and check that the user is showing up there. If they are not, you need to add them and give them Content Manager rights to the data source.

Our instructions do not include setting security on the sub level objects but if you are using Reporting Services for other things, then you may need to do that but make sure you the BizInsight users are added to all necessary levels so they can access the objects. If you don’t need to set the security at this object level, just click on the Revert to Parent Security button to inherit from the parent level.

#LICENSE

This error can have several different causes:

1. The BizInsight Administration Path is pointed to a directory that does not contain a license file, or

2. The report being refreshed contained BizInsight functions created with an earlier version and BizInsight was not started properly before the report was refreshed.

3. The BizInsight license file has been modified.

Steps to Troubleshoot

To troubleshoot this issue, first click on the Application Settings button on the BizInsight ribbon. Copy the path provided for the Administration Path and browse to that directory in Windows Explorer. Verify that there is a single .lic file in that directory. If one is not present and you do not have a copy of your license file, contact BizNet Software Support to request your license file be emailed to you.

If the report is a report with BizInsight functions from an older version, close Excel and then restart Excel. When Excel opens, click on BizInsight and then click on the BizInsight Explorer button on the Navigation Pane. Then open and refresh the report to see if the refresh works. It is important that the Navigation Pane is opened in Excel immediately after Excel opens before any BizInsight report is opened and refreshed. The error will manifest itself as an error that BizInsight is not loaded if the report contains BizInsight 5.0 functions but with the older version functions, they just change to #LICENSE.

If a BizInsight file is edited in any way, it can invalidate the license. If you think it might have been changed, replace the file with an original copy of your license and see if it resolves the issue. If you do not have a copy of your license file, contact BizNet Software Support to request your license file be emailed to you.