Gradience Pro / Enterprise - Runtime Error 217 on a Standalone Workstation after Windows 10 Update 1709

These instructions specifically apply to a Standalone Computer.

If you are not sure whether the affected computer is…

  • A Client or...
  • A Standalone, or…
  • A Server,

…please determine this first before proceeding with the steps below because the solution involves installing a specific release of version 11 and you may be running another release on another machine or may even be running version 12 on another machine that shares the same data with the software running on your machine. 

CAUTION! Often, people think that just because they are the only [user] of the software that the data must exist on their computer. Even if you are the only [user] of the software, your data may actually exist on another computer or on your server. If this turns out to be the case, then the software also exists on that other computer or server and your computer would be considered to be a Client Workstation rather than a Standalone Computer.

So, it is possible to actually have the software running on a server or [other] computer that is hosting your data [and] have the software on your computer that is accessing the data on the [other] machine. In this type of situation, the computer hosting the data is considered to be the server and the computer that is only [using] the data is considered to be a Client Workstation.

How to Verify whether this machine is a Server or a Client or a Standalone...

1. Go to C:\ProgramData\Gradience and open the Hrware.ini file. 

2. Very near the top, you will see a line that begins with...

Server= ...Whatever follows the equal sign is the computer hosting the data.

If you see anything other than the word Localhost, it means that your machine is a Client Workstation. If you discover that your computer is actually a Client Workstation instead of a Standalone Computer, please click here to access the correct instructions.

If you see the word Localhost following the equal sign means that this machine is hosting the data in which case you have ruled out a Client Workstation but you could be a Standalone or a Server because [both] host the data. The difference is a Standalone is the [only] computer [using] the software while a Server is sharing the data with Gradience installed on [other] computers.

If you know of anyone else who can access the same data as you by using Gradience on his/her computer, then that other person is using Gradience on his/her computer as a Client workstation, and you are running Gradience on your computer as a Server. In this case, you must click here to access the correct instructions.

A True Standalone Computer...

If it turns out that you truly are running Gradience as a Standalone where your computer is hosting the data and you are not using the software anywhere else, you may proceed with the instructions below.

Version 12 Users Have two Options...

Option One for version 12 Users:

If you had previously used version 11 and upgraded to version 12 but have been running version 12 for only a short while or you have not done much data entry since using version 12, you may want to consider reverting back to version 11. If you do this, you will have to restore a backup that you made while you were using version 11 so any data entered while using version 12 will have to be re-entered but at least you can continue using Gradience on Windows 10. Please click here to revert to version 11.

Option Two for version 12 Users:

If you have been running version 12 for many months or have never run anything other than version 12, It will not be possible to revert to version 11 because you will have no version 11 backup that you can restore. For this situation, we can offer you a workaround below that will allow you to remain on version 12.

Workaround for Option Two Above...

First copy your database file. The name of your database file is Hrware.gdb and paste it into a neutral location. If you do not know where to find it, go back to C:\ProgramData\Gradience and open the Hrware.ini file. Very near the top, you will see a line that begins with...

PATH= ...Whatever follows the equal sign is precise location of the data.

Copy the Hrware.gdb and paste it into a neutral location.

Open up a Windows 7 VM [virtual machine] on your Windows 10 computer. Install version 12 on that. You may click here to install version 12 as a Standalone on the VM. This will create a new, blank database on the VM. It will be named Hrware.gdb and will be located at C:\ProgramData\Gradience. You must replace the new, blank database with the copy you made of your original database file. 

Version 11 Users - There are two Types...

  • Those who had version 11 all along
  • Those reverting back to version 11 from version 12

Those who had version 11 all along...

1. Go into Services and stop Firebird.

2. Go to Programs and Features and uninstall Firebird and Gradience [if you see them].

3. Go to C:\Program Files and delete the firebird folder [if you see one].

4. Go to C:\Program Files (x86) and delete the firebird folder [if you see one].

5. Go to C:\ProgramData and delete the firebird folder [if you see one].

6. Please click here to reinstall Gradience as a Standalone.  

Those reverting back to version 11 from version 12

1. Go to where your database is located (Hrware.gdb) and rename it Hrware_v12.gdb.

If you do not know where to find your database file, go back to C:\ProgramData\Gradience and open the Hrware.ini file. Very near the top, you will see a line that begins with...

PATH= ...Whatever follows the equal sign is precise location of the data.

2. Go into Services and stop Firebird.

3. Go to Programs and Features and uninstall Firebird and Gradience [if you see them].

4. Go to C:\Program Files and delete the firebird folder [if you see one].

5. Go to C:\Program Files (x86) and delete the firebird folder [if you see one].

6. Go to C:\ProgramData and delete the firebird folder [if you see one].

7. Please click here to reinstall Gradience as a Standalone. This will create a new, blank database file named Hrware.gdb in the same folder where you renamed your original database file. 

8. You may now click here to restore your most recent version 11 database file.  

9. Open the software and re-enter any data that had been entered while you were using version 12.


If you need further assistance, please go to www.gradiencesupport.com and click on Submit a Request. When you submit your request, please be clear as to the following facts...

1. The full, multi-digit version number for Gradience.

2. The number of computers that are running Gradience.

3. The operating systems of the computers/server running Gradience.

4. The account number [if known] of the organization running the software.

5. The name of & main business phone number of the organization running the software.

6. The sales order number [if known] for the software license purchase. 

7. If the software was purchased through a reseller such as Office Depot, or Staples, or SHRM, or Quill, or Amazon, etc., please send us a scanned copy of the receipt. We are only authorized to render support to those for whom we can verify a current software license.

 

 

Have more questions? Submit a request

Comments

0 comments

Article is closed for comments.