Application Support for Tyler Technologies

QUICK LINKS FOR ACTIAN ZEN v15 USERS:

• Download Zen v15: This link allows you to download a 30-day evaluation license and patches for the Zen v15 database engine. Smaller sites (under 5 concurrent users) want the Workgroup Engine. Larger sites (6+ users) should download the Enterprise Server Engine instead.

QUICK LINKS FOR ACTIAN ZEN v14 USERS:

• Download Zen v14: This link allows you to download a 30-day evaluation license and patches for the Zen v14 database engine. Smaller sites (under 5 concurrent users) want the Workgroup Engine. Larger sites (6+ users) should download the Enterprise Server Engine instead.

The Fundbalance application from Tyler Technologies uses the Actian PSQL/Zen database engine to provide world-class performance and flexibility to their application development efforts. At this time, Tyler is not selling this software directly, but rather they are referring users to resellers such as Goldstar Software to obtain the correct licenses. We have worked extensively with Tyler and Fundbalance over the years and are in an excellent position to help you get your software installed and running quickly.

Installation of the Actian database is easy -- download the installer, follow the prompts, then reboot. (If you are upgrading an existing environment, you would uninstall the old components and reboot before installing the new ones.) This process is fairly easy and well-documented on our web site, so you can do it yourself or have your tech guy (or gal) handle it for you. You can even start with the 30-day trial download available on the Actian web site (see links above) that can be converted to a full license.

If you have a small site with fewer than 5 concurrent users, then the Workgroup Engine (WGE) is for you. You need a license for the number of concurrent users, at approximately $100 per user. The database engine and the license goes onto the SERVER, or the computer on which your database directory resides. All other computers get the PSQL/Zen Client installed to them.

If you need more than 5 concurrent users, then you need a Enterprise Server Engine instead. Enterprise The Server Engine has user counts of 6, 10, 20, 35, and more, and it also provides additional performance and security over the Workgroup Engine for these larger systems. Additonally, if you expect to exceed 5 users in the near future, you should consider the Server Engine now to save money later on. The Server Engine requires the use of a Windows or Linux database/file server for best operation, but smaller systems can also work with Windows workstation-class OS (7/8/10) on the server computer, as long as you don't exceed the Microsoft licensing limitations on these operating systems (i.e. 20 concurrent connections).

For pricing, please refer to our price list for Actian Zen v15, which also has a Product Selector tool (look for the BIG button) that can help you figure out exactly what you need, or call/Email us to request an exact quote!

Older versions of Fundbalance worked on older versions of Pervasive, including the (very old) Btrieve 6.15, Pervasive.SQL 2000i, Pervasive.SQL V8, Pervasive PSQL v9, Pervasive PSQL Summit v10, Pervasive PSQL v11, and Actian PSQL v12. Further, Actian PSQL v13 is unsupported as of December 31, 2022. These old engines are no longer supported by Actian Corporation (formerly Pervasive Software), and Tyler Technologies recommends upgrading to Actian Zen v15 at this time.

Actian PSQL v11 was released in 2010 and became unsupported in 2016. While this version will work with 2021 and older releases of AMS, you will need to upgrade to be compatible with newer versions of the Fundbalance application.

Actian PSQL v12 was released in 2014 and became unsupported in 2019. While this version will work with 2021 and older releases of AMS, you will need to upgrade to be compatible with newer versions of the Fundbalance application.

Actian PSQL v13 was released in 2017 and will become unsupported at the end of 2022. It is a paid upgrade from older versions. Although it has been formally discontinued by Actian, it will be supported through December 31, 2022, so it may be a viable option if you are still running Windows 7. Please note that PSQL v13 software is NOT supported on Windows Vista or older, so sites with older computers may need to upgrade their computers or operating systems first.

Actian Zen v14 was released in 2019 and is a paid upgrade from older versions. Zen v14 is the best platform if all of your workstations are Windows 10 or newer, and v14.10 and above are fully supported by Fundbalance at this time. Please note that Zen v14 software is NOT supported on Windows Vista or older, so sites with older computers may need to upgrade their operating systems first.

Actian Zen v15 was released in 2021 and is also a paid upgrade from older versions. Zen v15 is the best platform if you need support for Windows Server 2022 or Windows 11. Please note that Zen v15 software is NOT supported on Windows 7 or older, so sites with older computers may need to upgrade their operating systems first.

*Items with a NO are not supported by the application vendor at this time. Items with YES are supported. Items with R are Recommended, and NR are NOT recommended, but will work. Items with no entry are unknown at this time.

There are a few points of interest:

1. Installation Tip: The Client Cache Engine is disabled by default on the server, but you may wish to disable the Client-Side Cache feature entirely on each workstation by following these steps from each computer:
   • Start the Pervasive Control Center (Start/Run/PCC.EXE)
   • On the Welcome screen, click on the option "Configure Microkernel Router".
   • Click on the heading (on the left) for "Performance Tuning".
   • On the right side of the window, Uncheck "Use Cache Engine" to disable the CCE.
   • Click OK or APPLY, exit the PCC, and restart your computer to ensure that the changes take effect.
2. Performance Tip: If the Workgroup Engine is used, the machine with the data files physically on it (also called the peer server) should be designated as the permanent gateway using the Gateway Locator Utility, which will provide the best performance and stability. See our white paper on this topic for more information, or click HERE for the instructional video!
3. Performance Tip: Periodically rebuilding or defragmenting your database files may provide performance gains. See our white paper on this topic for more information.
4. Status Code 161 -- License Is Not Applied: If you are getting a Status 161 (Licensing Error) after installing the engine, then your database license may not be properly applied. On the database server, start the PSQL/Zen License Administrator (which you'll find in the Start Menu) and check the license count showing on this screen. If you do not see a permanent license with the correct user count, then you will need to apply your license. See your invoice or packing slip for your Registration Keycode, and enter this string into the boxes provided, then click "Add License". You should then see the proper license count.
5. Status Code 161 -- Wrong Version Is Installed: In some cases, we see sites get Status 161 after properly installing a license. On the database server, start the PSQL/Zen License Administrator (which you'll find in the Start Menu) and check the license count showing on this screen. The the left column shows a number (such as "625") instead of a product name, then the new software license was applied, but the software was never updated! You will need to uninstall the old version and install the purchased version to correct this situation.

If you need help with installing or patching your database engine, Goldstar Software also provides update services via the Internet for a fixed fee. See our Installation Services page for more details.

If you are a software vendor and would like to add, remove, or modify your information on these pages, we'll be happy to oblige. Simply contact us directly!