B1UP - Dashboard issue on SAP HANA

[Legacy note] This version of B1UP is not supported anymore, if you have this issue, please upgrade the B1UP installation.

Problem:
When you run the dashboards you get the error: "Unable to connect to database - Version mismatch"

The reason for the error is that the SAP HANA ADO.NET provider is linked to a specific version of the SAP HANA Client installation. If you are running another SAP HANA Client version than 1.0.102 you get this error. We have not solved this issue yet as dynamic dll versioning in .NET is not that easy to accomplish.

Solution

This issue was fixed in B1UP 2017.09 version so please upgrade to this release (www.boyum-it.com/sbo)

Workaround (work in some scenarios): 

NB: We strongly recommend that you move to 2017.09 release instead of applying this workaround as it is not a 100% guaranteed fix for all scenarios. So only use below if it is absolutely possible to upgrade

The workaround is to manually replace the Sap.Data.Hana.4.5.dll in the B1UP folder with the Sap.Data.Hana.4.5.dll version that is currently installed on the machine.

Steps:

1. Navigate to the folder C:\Windows\Microsoft.NET\assembly\GAC_MSIL\Sap.Data.Hana.v4.5
2. Locate the newest version
   
3. In this example: 102.
4. Copy the file and paste it into the B1UP installation folder
   Normally: 
   C:\Program Files (x86)\SAP\SAP Business One\AddOns\BOY\B1 Usability Package
   or 
   C:\Program Files\SAP\SAP Business One\AddOns\BOY\B1 Usability Package
5. Overwrite the existing file. Restart the SAP Business One client and it should now work.
6. This needs to be applied on all terminal server/client installations where the dashboard needs to run