Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

← Back to Technical Info page

...

Version

Type

Change Description

2021.31.0

General

Document created for the instructions to install AGRIS Version 2021.31.0

For Agris

...

21.1.

...

0 please note: It may be best to use the Edge or Internet Explorer browser as the Chrome browser may block the links.

Introduction

Purpose

The Installation Instructions assist you in performing new software installations of the AGRIS System Version 2021.31.0 software. Also use these instructions to upgrade AGRIS System Version 9.5versions 10.0.0 and higher to this new version.
For information regarding running AGRIS on Microsoft SQL Server, please refer to the documentation here: AGRIS on Microsoft SQL Server

IMPORTANT:  Before upgrading your system to AGRIS 2021.31.0, read Appendix H – Tips, Known Issues, and Best Practices

IMPORTANT: Installing or upgrading AGRIS requires up to two (2) system restarts on all server and client machines, as detailed below.  Please take this into consideration when planning your installation or upgrade.

1.  A system restart after completing the .NET Framework installation program (this installation program will only run if the computer does not yet have the required version of the .NET Framework)

2.  A system restart after completing the AGRIS installation program

Summary of Major System Requirements - Added and Removed

The following table summarizes the major hardware (HW) and software (SW) requirements changes relating to the maintenance and support of AGRIS 2021.31.0 (compared to the previous release of AGRIS).

Requirement

Added

Removed

HW-Hard-Drive

No changes.

No changes.

HW-RAM

No changes.*

No changes.

HW-CPU

No changes.

No changes.

SW – AGRIS Dataset Conversions

No changes.No changes

AGRIS dataset conversions from versions prior to 10.0.0.

SW-Database Engine

Actian ZEN v14™ SP1 Update 2 (Build 14.11.023)

Actian® Zen™ v14 SP1 (Build 14.10.035)

No changes.

No changes.

SW-Database File Format

No changes.

No changes.

SW-Operating System

No changes.

No changes.

SW-Application Software

No changes.

No changes.

SW-Report Component

No changes.

No changes.

SW- Terminal Server

No changes.

No changes.

*The installation utility checks for at least 512MB of RAM and quits if this amount is not met.

Upgrading From Previous Versions of AGRIS

Note:this amount is not met.

Upgrading From Previous Versions of AGRIS

Important Note:  Dataset conversions from version 9.6.x or earlier are not supported in this upgrade.  If you are upgrading from AGRIS Version version 9.4.6.x or earlier, please contact Greenstone Technical Support (800-366-2474). Conversions from V9.4.6.x or earlier are not supported in this upgrade.you will first need to upgrade to version 20.3.0 with the instructions HERE.  Be sure to convert all of your datasets to version 20.3.0.  Then return to this page to continue the upgrade to version 21.1.0.

New as of V9.6.0.0: Retained Settings During Upgrade

The upgrade process in AGRIS retains certain settings from the previous version of AGRIS (such as the settings in the Agris.ini, the Installation Type, the Distribution Folder path, and the COM+ user credentials). During an upgrade installation, the installation process will skip the windows in the Installation Wizard for the retained settings since it already has that information.
If you do not want to retain your settings from the previous version of AGRIS, you can manually uninstall the previous version of AGRIS in Add/Remove Programs or the Program Manager prior to starting the AGRIS installation.

New as of V9.6.0.0: Relocation of the AGRIS startup executable

The following message will appear when upgrading from a version previous to 9.6.0.0. Please read the message carefully. Click the No button to exit the installation process. Click the Yes button to proceed with the installation process.

Removing the prior version of AGRIS

When performing upgrades, the following messages may appear. Click Yes to remove the older version of AGRIS during the upgrade.

The Remove AGRIS Message

The Remove AGRIS Client? Message

The Remove AGRIS Server Components Message

The Remove Previous Version Window
Note: The following screen may appear when removing the previous AGRIS Server components. Click Yes to remove the existing COM+ applications.

The Remove AGRIS Specific MTS Packages Message

RetailWise Customers

RetailWise customers cannot upgrade directly to AGRIS 2021.31.0 and must coordinate their upgrade to Store Manager ES and AGRIS 2021.31.0 with the Sales Team (800-393-0075). The AGRIS Integration Platform (AIP) for RetailWise, which is translates data between RetailWise and AGRIS, is not supported in AGRIS 9.5.0.7 and higher. Note that customers already running Store Manager ES are not impacted by this and are able to upgrade to AGRIS 2021.31.0.

Tips for Minimizing Downtime During the Installation

Multiple client installations can run simultaneously.

    1. From a client machine, browse out to the UNC path of the Agrisdist folder
    2. Please refer to Appendix A for help on determining your Agrisdist UNC path.
    3. Perform at least the first dataset conversions on the server.

Known Installation Issues

  1. When uninstalling AGRIS, a message may appear indicating "An error occurred while trying to uninstall AGRIS. It may have already been uninstalled. Would you like to remove AGRIS from the Program and Features list?"

Resolution: Click the No button on this message to proceed with the uninstall.

Pervasive SQL Database File Format Conversion

Upgrading from Previous PSQL Versions

AGRIS requires you to pre-install Pervasive® PSQL™ to manage dataset operations. Please follow the instructions at  
https://culturana.force.com/s/article/ka036000000oLocAAE/AGRIS-Installing-Actian-PSQL-v12-SP1-and-Update-3?r=1

System Requirements

Please:

    • Consult the System Requirements document before continuing to install AGRIS.
    • Verify that all computers meet or exceed the minimum system requirements.
    • Where this document refers to "Pervasive® PSQL™", be sure that you are using a supported version of Pervasive® PSQL™ for this version of AGRIS.

Technical Support

Greenstone provides support to all subscribing users of the AGRIS System Version 2021.31.0. You can contact our Technical Assistance Center in the following ways:
Email:  Mysupport@culturatech.com
Phone:  (800) 366-2474
Mail:  3820 Mansell Road, Suite 375. Alpharetta, GA 30022
Website:  http://www.greenstonesystems.com/
Knowledge Base https://culturana.force.com/s/login

AGRIS Auto-Update

As a result of many requests for improving the software update process, AGRIS includes a utility for updating AGRIS client computers. This feature, called the AGRIS Auto-Update, assumes the AGRIS users/clients are running AGRIS V9.5.0.27 or greater, any updates made to the Component Server are automatically detected by the system.

Requirements

    • You must install the AGRIS System on a separate machine usually referred to as the component server. This type of configuration is usually referred to as a Network Configuration.
    • You must install the AGRIS Auto-Update utility via a UNC (Universal Naming Convention) path:

...

    • All users must have Administrator privileges for their local computers.
    • This feature is not supported on Terminal or Citrix Servers.
    • This feature is not supported on Standalone installations.

Description

When you launch AGRIS from a client machine, AGRIS compares its local version to the Component Server version. If an update is detected, it automatically prepares the update application and prompts you to decide whether or not to update the system:

The AGRIS System Update Window

...

Note: Depending on the state of the system, you may need to restart your workstation following the update.

Procedure

Note: AGRIS requires that you specify network locations using UNC paths.

      1. Create a network share (Example: \\servername\apps\AGRISDIST). All users need Read permissions to this share.
      2. The network administrator should save all the installation files to this share.
      3. If an update is available (update.exe), it should be copied to the same folder that contains the setup.exe, which was created in the previous step.
      4. Install AGRIS Version 2021.31.0 or later on all AGRIS servers, for example, component servers, database servers, etc. Also, apply updates, if they exist, for example, update.exe.
      5. Install AGRIS Version 2021.31.0 or later on all your AGRIS workstations. The AGRIS clients are now ready to detect updates from your servers. When you receive an update from AGRIS, you only have to update your Component Server(s) and application server(s). If you have not specifically set up a Component Server(s), then we assume the database server is the Component Server.


AGRIS

...

21.

...

1.0 Network Installation

Installation Checklist

Print this checklist to assist you in installing AGRIS 2021.31.0.

Step #SectionStep

1.

Sec 2.2

Verify your workstations and servers meet or exceed the system requirements and check their compatibility with current hardware requirements.

2.

Sec 2.3

Install any outstanding Windows Service Packs (if necessary).

3.

Install a supported version of Pervasive® PSQL™ Server on the database server(s) using the instructions available at https://culturana.force.com/s/article/ka036000000oLocAAE/AGRIS-Installing-Actian-PSQL-v12-SP1-and-Update-3?r=1

4.

Install a supported version of Pervasive® PSQL™ Client on any AGRIS client workstations, including Citrix or Terminal Servers using the instructions available at https://culturana.force.com/s/article/ka036000000oLocAAE/AGRIS-Installing-Actian-PSQL-v12-SP1-and-Update-3?r=1

5.

Sec 2.5

Set up a padmin user account.

6.

Sec 2.7

Create a COM+ Services user account.

7.

Sec 2.8

Set up network COM+ access on the AGRIS Server.

8.

Sec 2.10

Set up the AGRIS directory structure and permissions.

9.

Sec 2.14

IMPORTANT! Back up your datasets.

10.

Stop the Pervasive® PSQL™ services on the AGRIS server.

11.

Sec 3

Manually install AGRIS Server on the database server.

12.

Sec 4

Manually install AGRIS Server on any Citrix Servers/Terminal Servers.

13.

Sec 5

Manually install AGRIS Client on all your workstations.

14.

Sec 2.17

Download and manually install the latest AGRIS Service Pack on the database server and on any Citrix Servers/Terminal Servers.

15.

Sec 1.9

Use the Auto-Update feature to apply the latest service pack to all client workstations.

16.

Launch AGRIS from a client workstation to create the datasets folder and first database.

17.

Sec 10

Update the licenses file and the extended options

19.

Sec 7

Install any standalone units that use oneWeigh.

20.

Sec 2.16

If necessary, set up Auto Blender configurations to include AGRIS User information.

Anchor
_Toc190080247
_Toc190080247
Anchor
_Toc190143436
_Toc190143436
Anchor
_Toc190143719
_Toc190143719
Anchor
_Toc190144887
_Toc190144887
Anchor
_Toc190145126
_Toc190145126
Anchor
_Toc190148400
_Toc190148400
Anchor
_Toc190150242
_Toc190150242
Anchor
_Toc190153792
_Toc190153792
Anchor
_Toc190156072
_Toc190156072
Anchor
_Toc190156449
_Toc190156449
Anchor
_Toc190157861
_Toc190157861
Anchor
_Toc190159589
_Toc190159589
Anchor
_Toc190160041
_Toc190160041
Anchor
_Toc190162053
_Toc190162053
Anchor
_Toc190163022
_Toc190163022
Anchor
_Toc190237306
_Toc190237306
Anchor
_Toc190492481
_Toc190492481
Anchor
_Toc190496352
_Toc190496352
Anchor
_Toc190496837
_Toc190496837
Anchor
_Toc190497612
_Toc190497612
Anchor
_Toc190508103
_Toc190508103
Anchor
_Toc190509979
_Toc190509979
Anchor
_Toc190574229
_Toc190574229
Anchor
_Toc190574421
_Toc190574421
Anchor
_Toc190574611
_Toc190574611
Anchor
_Toc190577218
_Toc190577218
Anchor
_Toc190578436
_Toc190578436
Anchor
_Toc190848189
_Toc190848189
Anchor
_Toc224360401
_Toc224360401
Anchor
_Toc226346505
_Toc226346505
Anchor
_Toc226346731
_Toc226346731
Anchor
_Toc226350624
_Toc226350624
Anchor
_Toc226350852
_Toc226350852
Anchor
_Toc226351092
_Toc226351092
Anchor
_Toc190080248
_Toc190080248
Anchor
_Toc190143437
_Toc190143437
Anchor
_Toc190143720
_Toc190143720
Anchor
_Toc190144888
_Toc190144888
Anchor
_Toc190145127
_Toc190145127
Anchor
_Toc190148401
_Toc190148401
Anchor
_Toc190150243
_Toc190150243
Anchor
_Toc190153793
_Toc190153793
Anchor
_Toc190156073
_Toc190156073
Anchor
_Toc190156450
_Toc190156450
Anchor
_Toc190157862
_Toc190157862
Anchor
_Toc190159590
_Toc190159590
Anchor
_Toc190160042
_Toc190160042
Anchor
_Toc190162054
_Toc190162054
Anchor
_Toc190163023
_Toc190163023
Anchor
_Toc190237307
_Toc190237307
Anchor
_Toc190492482
_Toc190492482
Anchor
_Toc190496353
_Toc190496353
Anchor
_Toc190496838
_Toc190496838
Anchor
_Toc190497613
_Toc190497613
Anchor
_Toc190508104
_Toc190508104
Anchor
_Toc190509980
_Toc190509980
Anchor
_Toc190574230
_Toc190574230
Anchor
_Toc190574422
_Toc190574422
Anchor
_Toc190574612
_Toc190574612
Anchor
_Toc190577219
_Toc190577219
Anchor
_Toc190578437
_Toc190578437
Anchor
_Toc190848190
_Toc190848190
Anchor
_Toc224360402
_Toc224360402
Anchor
_Toc226346506
_Toc226346506
Anchor
_Toc226346732
_Toc226346732
Anchor
_Toc226350625
_Toc226350625
Anchor
_Toc226350853
_Toc226350853
Anchor
_Toc226351093
_Toc226351093
Anchor
_Ref88359718
_Ref88359718
Anchor
_Ref88364378
_Ref88364378
Anchor
_Toc158617991
_Toc158617991

Anchor
_Toc478038981
_Toc478038981
Verify System Requirements

Please consult the AGRIS Version 2021.31.0 System Requirements document before proceeding with the install. Please verify that all computers meet or exceed the minimum system requirements.
Note: The AGRIS installation will fail if minimum system requirements are not met.

Anchor
_Toc158617994
_Toc158617994
Anchor
_Toc478038983
_Toc478038983
Active Directory-Integrated Domain Name Service (DNS)

Active Directory-Integrated DNS is a critical piece of the infrastructure, required for the successful operation of AGRIS. The steps below are provided as a reference for installing and configuring DNS correctly:

...

    1. Click on Start >> Programs >> Administrative Tools >> DNS.
    2. Right-click the server and select Properties.
    3. Click the Forwarders tab.
    4. Click the Enable Forwarders option to enable the field allow the IP addresses to be entered.
    5. Enter the primary DNS server (provided by the internet service provider) and click Add.
    6. Enter the secondary DNS server (provided by the internet service provider) and click Add.
    7. Click Apply >> OK.
    8. Close the DNS window.

Anchor
_Ref88359829
_Ref88359829
Anchor
_Toc158617998
_Toc158617998
Anchor
_Ref190154666
_Ref190154666
Anchor
_Ref190154670
_Ref190154670
Anchor
_Toc190492488
_Toc190492488
Anchor
_Toc190498207
_Toc190498207
Anchor
_Toc478038984
_Toc478038984
Setting up the padmin User Account

You must set up a local user account on the Pervasive database server.

...

  1. Go to Start >> Settings >> Control Panel.
  2. Open Administrative Tools.
  3. Open Computer Management.
  4. Browse to Local Users and Groups and expand.
  5. Click Users.
  6. Click Action >> New User or right-click Users and select New User.
  7. Type a username (Typically padmin). The Full name and Description are optional.
  8. Type a password.
  9. Check the following options:
    • User cannot change password
    • Password never expires
  10. Click Create, and then Close.
  11. Right-click the user created in step 7 and click Properties
  12. Click the Member Of Tab and click Add... and type Administrators then click Check Names followed by OK
  13. Click OK again
  14. Close Computer Management, Administrative Tools and Control Panel.

Anchor
_Toc190492489
_Toc190492489
Anchor
_Toc190498208
_Toc190498208
Anchor
_Toc478038985
_Toc478038985
Assigning Log on Rights

If the AGRIS server is also a Domain Controller, then the padmin user account must be a domain user instead of a local user and made a member of the Builtin Administrators group. 

Anchor
_Installing_or_Upgrading
_Installing_or_Upgrading
Anchor
_Ref88359837
_Ref88359837
Anchor
_Toc158617999
_Toc158617999

Anchor
_Toc478038986
_Toc478038986
Creating a COM+ Services User Account

This user account is used to start the COM+ services. This account needs administrative permissions to the server that the COM+ components are running on.

  1. Go to Start >> Settings >> Control Panel.
  2. Open Administrative Tools.
  3. Open Active Directory Users and Computers.
  4. Click Users.
  5. Click Action >> New User or right-click Users and select New User.
  6. Type a username. (Typically services) The Full name and Description are optional.
  7. Type a password.
  8. Check the following options:
    • User cannot change password
    • Password never expires
  9. Click Create, and then Close.
  10. Click the new user account.
  11. Choose Action >> Properties or right-click the user and select Properties.
  12. Click the Member Of tab.
  13. Click Add.
  14. Browse to and select Administrators.
  15. Click Add.
  16. Click OK to add this user to the group.
  17. Click OK to finish working with this user account.
  18. Close Active Directory Users and Computers.

Anchor
_Toc478038987
_Toc478038987
Anchor
_Ref88359854
_Ref88359854
Anchor
_Toc158618001
_Toc158618001
Setting up Network COM+ Access

Anchor
_Toc478038988
_Toc478038988
Windows Server 2016, Windows Server 2019

There are no steps needed for Windows Server 2016 and Windows Server 2019. The AGRIS installation enables this feature programmatically by setting the following registry entry.

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\COM3
Name:  RemoteAccessEnabled
Type:  REG_DWORD
Data: 0x00000001 (1)

Anchor
_Toc478038989
_Toc478038989
Windows Server 2012 R2

  1. On the Component Server, typically the database server, click Start and type "Server Manager", then click on the Server Manager.
  2. Click on the Local Server in the selection tree.
  3. Scroll down to the ROLES AND FEATURES section
  4. In the TASKS dropdown, select Add Roles and Features
  5. On the Before you begin step, click Next
  6. On the Select installation type step, select Role-based or feature-based installation and click Next
  7. On the Select destination server step, ensure your server is selected and click Next
  8. On the Server Roles step, expand the Application Server option, checkmark COM+ Network Access, and click Next
  9. On the Features step, click Next
  10. On the Confirmation step, click Install
  11. Once the installation is complete, click Close to close the Add Roles and Features Wizard.

Granting Access to Component Services

Windows Server 2012 R2, Windows Server 2016, Windows Server 2019

  1. On the Component Server, typically the database server, click Start and type "Server Manager", then click on the Server Manager.
  2. From the Tools menu, select Component Services
  3. Double-click Component Services >> Computers.
  4. Right-click My Computer >> Properties.
  5. Click the Com Security tab.
  6. Click Edit Limits for the Launch and Activation Permissions.
  7. Click the Everyone group.
  8. Check the Remote Launch and Remote Activation options.
  9. Click OK >> OK.
  10. Close Component Services.

Anchor
_Toc158618003
_Toc158618003
Anchor
Installation_and_Distribution
Installation_and_Distribution
Creating the Installation and Distribution Folders

Prior to installing AGRIS on the database server, you must create the following folders:

...

If choosing folder names other than those specified above, be aware that the name of the directory where the software is installed (typically the AGRIS folder) cannot exceed eight characters.
Review Section 2.11 , below, for detailed information on setting up these folders.

Setting up the Recommended Directory Structure

To set up the installation and distribution folders in accordance with AGRIS standards, please perform the following steps:
Create the Apps folder:

...

    1. Click File >> New >> Folder
    2. Type Agrisdist as the name of the new folder and press [Enter].


Assigning Permissions for File Access

There are two levels of security involved with running AGRIS:

...

Apps Share Permissions:

    • Administrators = Full Control
    • Padmin = Change and Read
    • Services = Change and Read
    • AGRIS Users = Change and Read

Apps Security Permissions:

  • Administrators = Full Control
  • Padmin = Full Control
  • System = Full Control
  • Services = Full Control
  • AGRIS Users = Modify, Read & Execute, List Folder Contents, Read, and Write

Disabling Offline File Synchronization

Offline File Synchronization, a feature of Windows which enables users to synchronize files between their local workstations and the network, can cause severe problems with database applications. Disable the Offline File Synchronization in the Apps folder to prevent any file synchronization from occurring.

Windows Server 2012 R2, Windows Server 2016, Windows Server 2019

  1. Double-click My Computer > C: (or the drive where the Apps folder resides).
  2. Right-click the Apps folder >> Properties
  3. Click on the Sharing tab
  4. Click Advanced Sharing… button.
  5. Click Caching button.
  6. Click No files or programs from the shared folder are available offline
  7. Click OK >> OK >> Close


Backing up AGRIS Data

IMPORTANT
You must back up all standalone workstations (including oneWeigh units) and servers storing AGRIS datasets to prevent loss of data. Back up the entire Apps folder and all subfolders on a daily basis (recommended).

    • The Apps\AGRIS\datasets\ folder contains setup information and data
    • The Apps\AGRIS\userprog\ folder contains user-defined reports and forms.
    • The Apps\AGRIS\support\ folder contains user-defined printer text drivers, custom logos and backgrounds if present.


Backing Up Open Database Files

Occasionally, if users fail to completely exit from AGRIS prior to running the backup routine, the backup software fails to completely back up the AGRIS datasets. Due to the file relationships that AGRIS maintains, the resulting, partially backed up datasets are often not useable if you need to restore the entire dataset.
To minimize this problem, an open file agent, such as Pervasive Backup Agent™, is recommended. Backup Agent increases the chances of a successful backup if files are held open while the backup is running and is compatible with most backup solutions. For additional information about the Pervasive Backup Agent, please contact the Technical Assistance Center (800-366-2474).

Automated Blender Setup

Starting with AGRIS V9.5.0.9, the Automated Blender Setup procedure now requires the assignment of an AGRIS dataset user, which allows the Auto Blender service to log on to and load session information relative to the dataset.

  1. Stop the Auto Blender services.
  2. If you have not already done so, convert your first dataset to AGRIS 2021.31.0.
  3. From the AGRIS Main Menu, select AGY >> General Setup >> Automated Controls to display the Automated Blender Setup window.


    The Automated Blender Setup Window

  4. For each Auto Blender:
    1. Click the button to the right of the Auto Blender field to select an automated blender from the list.
    2. Click the button to the right of the AGRIS User field to select a user from the list. Be sure to select an AGRIS user with password permissions set to Never Expire.
    3. Click Apply to apply the changes.
  5. When you finish assigning users, click OK to close the Automated Blender Setup window.
  6. Restart the Auto Blender services.

Downloading the AGRIS

...

21.

...

1.0 Installation Program

  1. From the console of the server or standalone unit, click Start >> Run…
  2. Type  https://culturana.force.com/  >> click OK(NOTE: It may be best to use the Edge or Internet Explorer browser as the Chrome browser may block the links).
  3. Log on to the website
    1. If you are not already signed up for a user account, you can click the "Register" link to sign up. Account applications are reviewed and approved within 8 business hours.
  4. Click search for the AGRIS 2021.31.0 is Available Article and the Download setup.exe link for AGRIS 2021.31.0.
  5. Click Save when the "Do you want to run or save this file?" message displays.
  6. On the left side of the window, click Desktop, and then click Save on the bottom, right side to download the update (which may take a few minutes).
  7. WARNING: Due to enhanced security features in Windows, please ensure that the installer is unblocked prior to installation using the following steps:
    1. Right-click on the downloaded installation file and click Properties
    2. At the bottom of the General tab, look for a button that says "Unblock"
      1. If the button exists, click Unblock and then click OK
      2. If the button does not exist, click Cancel
  8. If necessary, you can request an AGRIS 2021.31.0 CD from the Technical Assistance Center (800-366-2474) or by emailing Mysupport@culturatech.com.

Anchor
_Toc147834562
_Toc147834562
Anchor
_Ref189375937
_Ref189375937
Anchor
_Toc190572028
_Toc190572028

Configuring Anti-Virus Software

AGRIS is compatible with a variety of anti-virus solutions, but additional configuration reduces the negative performance impact that the real-time anti-virus scanning may cause. Modify your real-time file scanning to exclude the entire AGRIS directory and sub-directories. Failure to configure the anti-virus properly may cause intermittent errors within AGRIS.
Real-time scanning also increases the time needed to install, or update to, AGRIS and PSQL, and may even prevent PSQL from installing. To alleviate both issues, temporarily disable real-time file scanning during the installation.
Please consult the anti-virus documentation for instructions on how to exclude files and folders from the real-time scan and to temporarily disable the real-time file scanning.

Server Installation

AGRIS Server Installation Checklist

Install components in the following order:


AGRIS

...

21.

...

1.0 Server Installation


This section describes how to install the AGRIS System Version 2021.31.0 software in the supported configurations listed in the AGRIS System Requirements document. It assumes that all hardware and supporting software requirements are in place and operational.
The following prerequisites must be satisfied:

...

Note: The existing version of the AGRIS System must be version 910.51.0 or higher. No earlier versions of the software can be directly upgraded to Version 2021.31.0.

    • Ensure that you have a complete backup of your current version's software and data.
    • Purge any unnecessary data files to enhance dataset conversion performance.

Server Installation Procedure


  • Installing the .NET Framework:
    • For Windows Server 2012 R2 and Windows Server 2016 and Windows Server 2019, part of the .NET Framework must be installed through the Server Manager:

      • Click Start and type "Server Manager", then click on the Server Manager.

      • Click on the Local Server in the selection tree.

      • Scroll down to the ROLES AND FEATURES section

      • In the TASKS dropdown, select Add Roles and Features

      • On the Before you begin step, click Next

      • On the Select installation type step, select Role-based or feature-based installation and click Next

      • On the Select destination server step, ensure your server is selected and click Next

      • On the Server Roles step:

        • For Windows Server 2012 R2: checkmark Application Server, click Next

        • For Windows Server 2016: click Next

      • On the Features step, checkmark the .NET Framework 3.5 Features option. Checking this will automatically check the .NET Framework 3.5 (includes .NET 2.0 and 3.0) option. For AGRIS, you do not need to checkmark the options for HTTP Activation. Click Next until you are on the Confirmation step.

      • On the Confirmation step, click Install

      • Once the installation is complete, click Close to close the Add Roles and Features Wizard.

      • Close the Server Manager.

      • Proceed with the next step in the AGRIS installation

    • For all other supported Server operating systems, there are no extra steps for the .NET Framework.

  • Open the Agrisdist network share created in section 2.10
  • Open the Setup.exe:
    • Right-click the Setup.exe and choose Run as Administrator. If there is a User Account Control message, click Allow.
  • If the computer does not have version 4.7.2 of the .NET Framework installed, the installation process will prompt to install it. Click Install to start the installation. This process can take several minutes to complete.  You will be prompted to reboot after this. You can choose to reboot now or later, however rebooting after the .NET Framework installation is mandatory before proceeding with the remainder of the AGRIS installation. Reboot and then log back in as the same user, and the AGRIS installation will automatically continue.

...

  • The final step in the installation process takes place in a command window. Do not manually close this window. When complete, this command window will automatically close and the computer will restart.


The Command Window


Citrix Server/Terminal Server Installation

Anchor
_Toc158618014
_Toc158618014
Anchor
_Ref190154932
_Ref190154932
Anchor
_Ref190154936
_Ref190154936
Anchor
_Toc478039010
_Toc478039010
AGRIS

...

21.

...

1.0 Citrix Server/Terminal Server Installation checklist

Install components in the following order based on the application server software being used:

Citrix Server

Windows Server 2012 R2 Terminal Services

Latest Windows Service Pack

No Service Pack

Install Terminal Services

Install Terminal Services

Install MetaFrame XP/Presentation Server or Citrix XenApp 6.5.0


Pervasive® PSQL™ 32-bit Client

Pervasive® PSQL™ 32-bit Client

AGRIS Server

AGRIS Server

Anchor
_Ref88362347
_Ref88362347
Anchor
_Toc158618015
_Toc158618015
Anchor
_Toc478039011
_Toc478039011
Installing AGRIS

...

21.

...

1.0 Server on Citrix Server/Terminal Server

  1. Log all users out of the Citrix/Terminal Server(s) and prevent additional users from logging on while installing AGRIS.
  2. Close all other applications and restart the server.
  3. Install a supported version of Pervasive® PSQL™ using the instructions available on the AGRIS Customer Portal site:
    https://culturana.force.com/s/article/ka036000000oLocAAE/AGRIS-Installing-Actian-PSQL-v12-SP1-and-Update-3?r=1 * = NOTE: It may be best to use the Edge or Internet Explorer browser as the Chrome browser may block the above links.
  4. Complete section 3.2 to install AGRIS.
  5. Manually set the AGRIS data path - see Section 13.1 for additional information.
  6. Save the AGRIS data path and restart the server.

Note:  Ensure all AgroGuide users connecting via a Citrix Server/Terminal Server have full control of the Program Files\Common Files directory on that server.

Anchor
_Toc478039012
_Toc478039012
Environment variable required on a Citrix Server/Terminal Server for AGRIS


A Citrix Server/Terminal Server running AGRIS needs to have an AgrisTS=1 System Environment Variable on it in order for AGRIS to function correctly (for correctly mapping printers to the correct station for example).  To add/check this:

...


AGRIS as a default will assign your PSN (workstation number) by your NIC (network card number), not by your login.  Users logging in to AGRIS through Citrix Server/Terminal Server will all have the same NIC address, creating conflicts.  The AgrisTS will change AGRIS so that it assigns your PSN by your network Log-in ID instead.  This ensures that everyone not only has unique station numbers but they will also have the same station number at each login. Each workstation logging in thru a Citrix Server/Terminal Server should have its own unique user id.

Anchor
_Toc227387425
_Toc227387425
Anchor
_Client_Installation
_Client_Installation
Anchor
_Ref190154970
_Ref190154970
Anchor
_Ref190154974
_Ref190154974
Anchor
_Toc478039013
_Toc478039013
Client Installation

Anchor
_AGRIS_Client_Workstation
_AGRIS_Client_Workstation
Anchor
_Toc6991040
_Toc6991040
Anchor
_Toc478039014
_Toc478039014
AGRIS Client Workstation Installation Checklist

Install components in the following order based on the workstation operating system:

Windows 8.1

Windows 10

No Service Pack

No Service Pack

Pervasive® PSQL™ 32-bit Client

Pervasive® PSQL™ 32-bit Client

AGRIS Client

AGRIS Client

Anchor
_Install_Pervasive_Client_Engine
_Install_Pervasive_Client_Engine
Anchor
_Toc6991042
_Toc6991042
Anchor
_Ref188851585
_Ref188851585
Anchor
_Ref188851602
_Ref188851602
Anchor
_Ref188937111
_Ref188937111
Anchor
_Toc478039015
_Toc478039015
AGRIS

...

21.

...

1.0 Client Installation Procedure

IMPORTANT:Before installing the AGRIS Client, install a supported version of Pervasive® PSQL™ on the client workstation using the instructions available at; at  
https://culturana.force.com/s/article/ka036000000oLocAAE/AGRIS-Installing-Actian-PSQL-v12-SP1-and-Update-3?r=1

...

  • The final step in the installation process takes place in a command window. Do not manually close this window. When complete, this command window will automatically close and the computer will restart.


The Command Window

Anchor
_Toc188937729
_Toc188937729
Anchor
_Toc188940697
_Toc188940697
Anchor
_Toc188940865
_Toc188940865
Anchor
_Toc188941035
_Toc188941035
Anchor
_Toc188942422
_Toc188942422
Anchor
_Toc188942591
_Toc188942591
Anchor
_Toc188942760
_Toc188942760
Anchor
_Toc188942929
_Toc188942929
Anchor
_Toc188943098
_Toc188943098
Anchor
_Toc188943267
_Toc188943267
Anchor
_Toc188943436
_Toc188943436
Anchor
_Toc188943244
_Toc188943244
Anchor
_Toc188943691
_Toc188943691
Anchor
_Toc188943763
_Toc188943763
Anchor
_Toc188943932
_Toc188943932
Anchor
_Toc188944102
_Toc188944102
Anchor
_Toc188944272
_Toc188944272
Anchor
_Toc188944767
_Toc188944767
Anchor
_Toc188952181
_Toc188952181
Anchor
_Toc188953026
_Toc188953026
Anchor
_Toc188953730
_Toc188953730
Anchor
_Toc188953899
_Toc188953899
Anchor
_Toc188955019
_Toc188955019
Anchor
_Toc188956665
_Toc188956665
Anchor
_Toc189281655
_Toc189281655
Anchor
_Toc189282481
_Toc189282481
Anchor
_Toc189380534
_Toc189380534
Anchor
_Toc189470094
_Toc189470094
Anchor
_Toc189470399
_Toc189470399
Anchor
_Toc189470908
_Toc189470908
Anchor
_Toc189471286
_Toc189471286
Anchor
_Toc189471802
_Toc189471802
Anchor
_Toc189472900
_Toc189472900
Anchor
_Toc189473114
_Toc189473114
Anchor
_Toc189548904
_Toc189548904
Anchor
_Toc189887046
_Toc189887046
Anchor
_Toc189887848
_Toc189887848
Anchor
_Toc189888012
_Toc189888012
Anchor
_Toc189902098
_Toc189902098
Anchor
_Toc190070537
_Toc190070537
Anchor
_Toc190077674
_Toc190077674
Anchor
_Toc190078526
_Toc190078526
Anchor
_Toc190079739
_Toc190079739
Anchor
_Toc190080291
_Toc190080291
Anchor
_Toc190143479
_Toc190143479
Anchor
_Toc190143762
_Toc190143762
Anchor
_Toc190144930
_Toc190144930
Anchor
_Toc190145169
_Toc190145169
Anchor
_Toc190148443
_Toc190148443
Anchor
_Toc190150285
_Toc190150285
Anchor
_Toc190153835
_Toc190153835
Anchor
_Toc190156114
_Toc190156114
Anchor
_Toc190156491
_Toc190156491
Anchor
_Toc190157903
_Toc190157903
Anchor
_Toc190159632
_Toc190159632
Anchor
_Toc190160085
_Toc190160085
Anchor
_Toc190162097
_Toc190162097
Anchor
_Toc190163066
_Toc190163066
Anchor
_Toc190237350
_Toc190237350
Anchor
_Toc190492525
_Toc190492525
Anchor
_Toc190496388
_Toc190496388
Anchor
_Toc190496873
_Toc190496873
Anchor
_Toc190497648
_Toc190497648
Anchor
_Toc190508141
_Toc190508141
Anchor
_Toc190510017
_Toc190510017
Anchor
_Toc190574266
_Toc190574266
Anchor
_Toc190574459
_Toc190574459
Anchor
_Toc190574649
_Toc190574649
Anchor
_Toc190577256
_Toc190577256
Anchor
_Toc190578474
_Toc190578474
Anchor
_Toc190848228
_Toc190848228
Anchor
_Toc224360440
_Toc224360440
Anchor
_Toc226346575
_Toc226346575
Anchor
_Toc226346801
_Toc226346801
Anchor
_Toc226350694
_Toc226350694
Anchor
_Toc226350924
_Toc226350924
Anchor
_Toc226351164
_Toc226351164
Anchor
_Toc478039016
_Toc478039016
Anchor
_Toc6991043
_Toc6991043
Anchor
_Toc506706944
_Toc506706944
Anchor
_Toc522174742
_Toc522174742
Anchor
_Toc6991048
_Toc6991048
Optional Separate Component Server Installation

The majority of users designate a single server to act as the Component Server and to store the database files. Customers that extensively use the reporting features of AGRIS may require a separate server to act as the Component Server. Please call the Technical Assistance Center (800-366-2474) to determine if a separate Component Server is necessary, or advisable.

Anchor
_Toc478039017
_Toc478039017
AGRIS Component Server Installation Checklist

Install components in the following order:

Pervasive® PSQL™ 32-bit Client

Create a COM+ Services User Account

AGRIS Server


Anchor
_Toc478039018
_Toc478039018
Installing A Separate Component Server

Install the Pervasive Client Engine in accordance with the instructions available at 
https://culturana.force.com/s/article/ka036000000oLocAAE/AGRIS-Installing-Actian-PSQL-v12-SP1-and-Update-3?r=1 
Install the AGRIS Server in accordance with the instructions contained in section Server Installation.
Install the AGRIS Client in accordance with the instructions contained in section Client Installation.

Anchor
_Standalone_Installation
_Standalone_Installation
Anchor
_Ref190143390
_Ref190143390
Anchor
_Ref190143396
_Ref190143396
Anchor
_Toc478039019
_Toc478039019
Standalone Installation

Anchor
_Ref190155135
_Ref190155135
Anchor
_Ref190155138
_Ref190155138
Anchor
_Toc478039020
_Toc478039020
AGRIS Standalone Workstation Installation Checklist

Install components in the following order based on the workstation operating system:

Windows 8.1

Windows 10

No Service Pack

No Service Pack

Pervasive® PSQL™ Workgroup

Pervasive® PSQL™ Workgroup

AGRIS Standalone

AGRIS Standalone


Anchor
_Toc478039021
_Toc478039021
AGRIS

...

21.

...

1.0 Standalone Installation

  • Installing the .NET Framework:
    • For Windows 8.1 and Windows 10, part of the.NET Framework must be installed through the Programs and Features:
      • Click Start and type "Programs and Features", then click on the Programs and Features.
      • Click on the Turn Windows Features on or off link.
      • Checkmark the .NET Framework 3.5 (includes .NET 2.0 and 3.0) checkbox
      • Click OK to start the installation
      • Once the installation is complete, click Close
      • Close the Programs and Features
      • Proceed with the next step in the AGRIS installation.
    • For all other supported standalone operating systems, there are no extra steps for the .NET Framework.

...

  • Anchor
    StandaloneNextStep
    StandaloneNextStep
    If you did not create a network share in section 2.10:
    • Insert the AGRIS 20.3.0 CD into the CD ROM. Use the Windows Start\Run utility to browse to setup.exe on the CD.

...

  • The final step in the installation process takes place in a command window. Do not manually close this window. When complete, this command window will automatically close and the computer will restart.



The Command Window

Anchor
_Toc478039022
_Toc478039022
Starting AGRIS

To start AGRIS, select it from the Start/Programs/AGRIS, or double-click the AGRIS icon on the desktop.

    • The initial launch of AGRIS creates an empty database, if one is not present in the data path.
    • Three messages appear when a database is created.
      • The name message indicates how the database is stored internally.
        • Naming convention: A[dataset number] + [date stamp] + [time stamp]
      • The second message verifies that the database is created.
      • The third message verifies the database connection.
    • The new dataset appears in the Available Datasets menu. Select the dataset and the AGRIS System menu appears.
    • Proceed to the Licensing Setup section.


Anchor
_Toc478039023
_Toc478039023
Converting Datasets

If you are converting from earlier versions of the AGRIS Business System to Version 20.3.0, this is a simple process.

Note:If you are upgrading from AGRIS Version 9.4.6.x or earlier, please contact Greenstone Technical Support (800-366-2474). Conversions from V9.4.6.x or earlier are not supported in this upgrade.

This version of AGRIS supports dataset conversions from versions 10.0.0 and higher.

Anchor
_Converting_from_Agris_1
_Converting_from_Agris_1
Anchor
_Toc6991049
_Toc6991049
Anchor
_Toc478039024
_Toc478039024
Converting to AGRIS

...

21.

...

1.0

  • Launch AGRIS 2021.31.0 and the Select Dataset screen will appear.
  • Choose the desired dataset and click Select.
  • A window appears describing that a dataset conversion is required.

...

    • A dataset must be converted before users (and other services) can access it.
    • Each dataset requires its own conversion.
    • Once the dataset conversion process is complete, it is complete for all users.
    • Complete the first dataset conversion from start to finish (including logging into the dataset) before starting other conversions. This ensures that the Datasets*.AGR files, which are shared between all datasets, convert successfully.
    • Converting a dataset on the database server typically takes less time than on a client machine.
    • Simultaneously converting multiple datasets may significantly degrade performance if large file sizes are present. If you still wish to convert multiple datasets simultaneously, please contact the Technical Assistance Center for more details.
    • Consider prioritizing the conversion of datasets to minimize the impact to end users.

Anchor
_Converting_from_Agris
_Converting_from_Agris
Anchor
_Toc246140228
_Toc246140228
Anchor
_Toc251923600
_Toc251923600
Anchor
_Toc251923717
_Toc251923717
Anchor
_Toc252284944
_Toc252284944
Anchor
_Toc255806713
_Toc255806713
Anchor
_Toc255806830
_Toc255806830
Anchor
_Licensing_Setup_Instructions
_Licensing_Setup_Instructions
Anchor
_Licensing_Setup
_Licensing_Setup
Anchor
_Convert_Datasets_from_Pervasive_7.x
_Convert_Datasets_from_Pervasive_7.x
Anchor
_Toc246140229
_Toc246140229
Anchor
_Toc251923601
_Toc251923601
Anchor
_Toc251923718
_Toc251923718
Anchor
_Toc252284945
_Toc252284945
Anchor
_Toc255806714
_Toc255806714
Anchor
_Toc255806831
_Toc255806831
Anchor
_Toc246140230
_Toc246140230
Anchor
_Toc251923602
_Toc251923602
Anchor
_Toc251923719
_Toc251923719
Anchor
_Toc252284946
_Toc252284946
Anchor
_Toc255806715
_Toc255806715
Anchor
_Toc255806832
_Toc255806832
Anchor
_Toc246140231
_Toc246140231
Anchor
_Toc251923603
_Toc251923603
Anchor
_Toc251923720
_Toc251923720
Anchor
_Toc252284947
_Toc252284947
Anchor
_Toc255806716
_Toc255806716
Anchor
_Toc255806833
_Toc255806833
Anchor
_Toc506706945
_Toc506706945
Anchor
_Toc522174743
_Toc522174743
Anchor
_Toc6991051
_Toc6991051
Anchor
_Ref188936877
_Ref188936877
Anchor
_Toc478039025
_Toc478039025
Licensing Setup

Use the licensing setup to set the number of user licenses for each purchased package. The licensing setup for the AGRIS Business System is located in the main system menu under Help. Use this process along with the licensing diskette that accompanies the AGRIS 2021.31.0 installation CD. Load the licensing diskette during installation or if any package licenses are upgraded.
Note:Program module icons are not present until the package is licensed for use. An access code is required during this procedure, so perform this procedure during hours when the Technical Assistance Center (800-366-2474) is available. Tell them that you are performing the license update procedure and need an access code.

Anchor
_Ref190155067
_Ref190155067
Anchor
_Ref190155072
_Ref190155072
Anchor
_Toc478039026
_Toc478039026
Setting up AGRIS Licenses

    • From the AGRIS System Manager Menu, select Help, and then Update Licenses.
    • When prompted to Update Allocated Package Licenses, click Yes.
    • Contact our Technical Assistance Center (800-366-2474) for an access code to enter in the Database Security Configuration window.
    • Read the Access Number to the Support Representative, who then provides an Access Code for you to enter.
    • In the Source field, provide the path to where the AGRIS.LIC file resides (if the AGRIS.LIC file exists in C:\Apps then C:\Apps is your source, not C:\Apps\AGRIS.LIC). Please note that AGRIS license files are generally sent via email and must be saved to a directory in order to apply it. Be sure to save the file with the name AGRIS.LIC as any other name will cause the license update process to fail.
    • In the Destination field, type the drive letter and folder location of your AGRIS dataset.
    • Click OK. The Update Licenses window appears and displays the following information:
    • Licenses Column shows your License count before the update.
    • Update To indicates what your new changes will be.
    • View Only is the View count before any changes.
    • Upgrade To is your new View License count.
    • Click Apply to initialize your changes.
    • If you want to view license changes, from the AGRIS System Manager Menu, select Help, and then About AGRIS.
    • Click File, and then Print.
    • The last section of the printout shows your licensing information.
    • If anyone is using any of the packages, the Licenses In Use column is updated.
    • If anyone is in the view function, the View Only In Use column is updated.

...


Anchor
_AGRIS.INI_file_explained
_AGRIS.INI_file_explained
Anchor
_Ref190155088
_Ref190155088
Anchor
_Ref190155093
_Ref190155093
Anchor
_Toc6991052
_Toc6991052

Anchor
Setting_Up_the_Extended_Options_License
Setting_Up_the_Extended_Options_License
Anchor
_Toc478039027
_Toc478039027
Setting up the Extended Options License

Note:  Extended options control access to selected package menu options. Upgrading to AGRIS 2021.31.0 requires application of initial extended option settings from the license file. All extended options are considered "off" until this process is complete. Skipping this process will block access to package menu options controlled by extended options.

...

If the current dataset has already been converted to AGRIS 2021.31.0 and this is the first time Extended Option System Default Settings have been updated, then elect to update the current dataset with the System Default Settings. Once Extended Option System Default Settings are set, they will be automatically applied to a dataset during conversion to AGRIS 2021.31.0, or when a package is initialized in a dataset.

If an extended option is enabled in the System Default file, then that option can be enabled\disabled per dataset.

Anchor
_Toc478039028
_Toc478039028
Installing Additional AGRIS Components

Anchor
_Toc188079237
_Toc188079237
Anchor
_Toc188775449
_Toc188775449
Anchor
_Toc188775617
_Toc188775617
Anchor
_Toc188775951
_Toc188775951
Anchor
_Toc188776116
_Toc188776116
Anchor
_Toc188776282
_Toc188776282
Anchor
_Toc188776464
_Toc188776464
Anchor
_Toc188779710
_Toc188779710
Anchor
_Toc188846950
_Toc188846950
Anchor
_Toc188851986
_Toc188851986
Anchor
_Toc188852151
_Toc188852151
Anchor
_Toc188852696
_Toc188852696
Anchor
_Toc188852862
_Toc188852862
Anchor
_Toc188853036
_Toc188853036
Anchor
_Toc188867420
_Toc188867420
Anchor
_Toc188867738
_Toc188867738
Anchor
_Toc188936184
_Toc188936184
Anchor
_Toc188936497
_Toc188936497
Anchor
_Toc188937752
_Toc188937752
Anchor
_Toc188940721
_Toc188940721
Anchor
_Toc188940889
_Toc188940889
Anchor
_Toc188941059
_Toc188941059
Anchor
_Toc188942446
_Toc188942446
Anchor
_Toc188942615
_Toc188942615
Anchor
_Toc188942784
_Toc188942784
Anchor
_Toc188942953
_Toc188942953
Anchor
_Toc188943122
_Toc188943122
Anchor
_Toc188943291
_Toc188943291
Anchor
_Toc188943460
_Toc188943460
Anchor
_Toc188943271
_Toc188943271
Anchor
_Toc188943788
_Toc188943788
Anchor
_Toc188943957
_Toc188943957
Anchor
_Toc188944127
_Toc188944127
Anchor
_Toc188944297
_Toc188944297
Anchor
_Toc188944792
_Toc188944792
Anchor
_Toc188952206
_Toc188952206
Anchor
_Toc188953051
_Toc188953051
Anchor
_Toc188953755
_Toc188953755
Anchor
_Toc188953924
_Toc188953924
Anchor
_Toc188955044
_Toc188955044
Anchor
_Toc188956690
_Toc188956690
Anchor
_Toc189281679
_Toc189281679
Anchor
_Toc189282505
_Toc189282505
Anchor
_Toc189380558
_Toc189380558
Anchor
_Toc189470118
_Toc189470118
Anchor
_Toc189470423
_Toc189470423
Anchor
_Toc189470932
_Toc189470932
Anchor
_Toc189471310
_Toc189471310
Anchor
_Toc189471826
_Toc189471826
Anchor
_Toc189472924
_Toc189472924
Anchor
_Toc189473138
_Toc189473138
Anchor
_Toc189548928
_Toc189548928
Anchor
_Toc189887070
_Toc189887070
Anchor
_Toc189887872
_Toc189887872
Anchor
_Toc189888036
_Toc189888036
Anchor
_Toc189902122
_Toc189902122
Anchor
_Toc190070561
_Toc190070561
Anchor
_Toc190077698
_Toc190077698
Anchor
_Toc190078550
_Toc190078550
Anchor
_Toc190079763
_Toc190079763
Anchor
_Toc190080315
_Toc190080315
Anchor
_Toc190143503
_Toc190143503
Anchor
_Toc190143786
_Toc190143786
Anchor
_Toc190144950
_Toc190144950
Anchor
_Toc190145189
_Toc190145189
Anchor
_Toc190148463
_Toc190148463
Anchor
_Toc190150305
_Toc190150305
Anchor
_Toc190153855
_Toc190153855
Anchor
_Toc190156134
_Toc190156134
Anchor
_Toc190156511
_Toc190156511
Anchor
_Toc190157923
_Toc190157923
Anchor
_Toc190159652
_Toc190159652
Anchor
_Toc190160105
_Toc190160105
Anchor
_Toc190162117
_Toc190162117
Anchor
_Toc190163086
_Toc190163086
Anchor
_Toc190237370
_Toc190237370
Anchor
_Toc190492545
_Toc190492545
Anchor
_Toc190496404
_Toc190496404
Anchor
_Toc190496889
_Toc190496889
Anchor
_Toc190497664
_Toc190497664
Anchor
_Toc190508157
_Toc190508157
Anchor
_Toc190510033
_Toc190510033
Anchor
_Toc190574282
_Toc190574282
Anchor
_Toc190574475
_Toc190574475
Anchor
_Toc190574665
_Toc190574665
Anchor
_Toc190577272
_Toc190577272
Anchor
_Toc190578490
_Toc190578490
Anchor
_Toc190848244
_Toc190848244
Anchor
_Toc224360456
_Toc224360456
Anchor
_Toc226346591
_Toc226346591
Anchor
_Toc226346817
_Toc226346817
Anchor
_Toc226350710
_Toc226350710
Anchor
_Toc226350940
_Toc226350940
Anchor
_Toc226351180
_Toc226351180
Anchor
_Toc188079241
_Toc188079241
Anchor
_Toc188775453
_Toc188775453
Anchor
_Toc188775621
_Toc188775621
Anchor
_Toc188775955
_Toc188775955
Anchor
_Toc188776120
_Toc188776120
Anchor
_Toc188776286
_Toc188776286
Anchor
_Toc188776468
_Toc188776468
Anchor
_Toc188779714
_Toc188779714
Anchor
_Toc188846954
_Toc188846954
Anchor
_Toc188851990
_Toc188851990
Anchor
_Toc188852155
_Toc188852155
Anchor
_Toc188852700
_Toc188852700
Anchor
_Toc188852866
_Toc188852866
Anchor
_Toc188853040
_Toc188853040
Anchor
_Toc188867424
_Toc188867424
Anchor
_Toc188867742
_Toc188867742
Anchor
_Toc188936188
_Toc188936188
Anchor
_Toc188936501
_Toc188936501
Anchor
_Toc188937756
_Toc188937756
Anchor
_Toc188940725
_Toc188940725
Anchor
_Toc188940893
_Toc188940893
Anchor
_Toc188941063
_Toc188941063
Anchor
_Toc188942450
_Toc188942450
Anchor
_Toc188942619
_Toc188942619
Anchor
_Toc188942788
_Toc188942788
Anchor
_Toc188942957
_Toc188942957
Anchor
_Toc188943126
_Toc188943126
Anchor
_Toc188943295
_Toc188943295
Anchor
_Toc188943464
_Toc188943464
Anchor
_Toc188943277
_Toc188943277
Anchor
_Toc188943792
_Toc188943792
Anchor
_Toc188943961
_Toc188943961
Anchor
_Toc188944131
_Toc188944131
Anchor
_Toc188944301
_Toc188944301
Anchor
_Toc188944796
_Toc188944796
Anchor
_Toc188952210
_Toc188952210
Anchor
_Toc188953055
_Toc188953055
Anchor
_Toc188953759
_Toc188953759
Anchor
_Toc188953928
_Toc188953928
Anchor
_Toc188955048
_Toc188955048
Anchor
_Toc188956694
_Toc188956694
Anchor
_Toc189281683
_Toc189281683
Anchor
_Toc189282509
_Toc189282509
Anchor
_Toc189380562
_Toc189380562
Anchor
_Toc189470122
_Toc189470122
Anchor
_Toc189470427
_Toc189470427
Anchor
_Toc189470936
_Toc189470936
Anchor
_Toc189471314
_Toc189471314
Anchor
_Toc189471830
_Toc189471830
Anchor
_Toc189472928
_Toc189472928
Anchor
_Toc189473142
_Toc189473142
Anchor
_Toc189548932
_Toc189548932
Anchor
_Toc189887074
_Toc189887074
Anchor
_Toc189887876
_Toc189887876
Anchor
_Toc189888040
_Toc189888040
Anchor
_Toc189902126
_Toc189902126
Anchor
_Toc190070565
_Toc190070565
Anchor
_Toc190077702
_Toc190077702
Anchor
_Toc190078554
_Toc190078554
Anchor
_Toc190079767
_Toc190079767
Anchor
_Toc190080319
_Toc190080319
Anchor
_Toc190143507
_Toc190143507
Anchor
_Toc190143790
_Toc190143790
Anchor
_Toc190144954
_Toc190144954
Anchor
_Toc190145193
_Toc190145193
Anchor
_Toc190148467
_Toc190148467
Anchor
_Toc190150309
_Toc190150309
Anchor
_Toc190153859
_Toc190153859
Anchor
_Toc190156138
_Toc190156138
Anchor
_Toc190156515
_Toc190156515
Anchor
_Toc190157927
_Toc190157927
Anchor
_Toc190159656
_Toc190159656
Anchor
_Toc190160109
_Toc190160109
Anchor
_Toc190162121
_Toc190162121
Anchor
_Toc190163090
_Toc190163090
Anchor
_Toc190237374
_Toc190237374
Anchor
_Toc190492549
_Toc190492549
Anchor
_Toc190496408
_Toc190496408
Anchor
_Toc190496893
_Toc190496893
Anchor
_Toc190497668
_Toc190497668
Anchor
_Toc190508161
_Toc190508161
Anchor
_Toc190510037
_Toc190510037
Anchor
_Toc190574286
_Toc190574286
Anchor
_Toc190574479
_Toc190574479
Anchor
_Toc190574669
_Toc190574669
Anchor
_Toc190577276
_Toc190577276
Anchor
_Toc190578494
_Toc190578494
Anchor
_Toc190848248
_Toc190848248
Anchor
_Toc224360460
_Toc224360460
Anchor
_Toc226346595
_Toc226346595
Anchor
_Toc226346821
_Toc226346821
Anchor
_Toc226350714
_Toc226350714
Anchor
_Toc226350944
_Toc226350944
Anchor
_Toc226351184
_Toc226351184
Anchor
_Toc188079244
_Toc188079244
Anchor
_Toc188775456
_Toc188775456
Anchor
_Toc188775624
_Toc188775624
Anchor
_Toc188775958
_Toc188775958
Anchor
_Toc188776123
_Toc188776123
Anchor
_Toc188776289
_Toc188776289
Anchor
_Toc188776471
_Toc188776471
Anchor
_Toc188779717
_Toc188779717
Anchor
_Toc188846957
_Toc188846957
Anchor
_Toc188851993
_Toc188851993
Anchor
_Toc188852158
_Toc188852158
Anchor
_Toc188852703
_Toc188852703
Anchor
_Toc188852869
_Toc188852869
Anchor
_Toc188853043
_Toc188853043
Anchor
_Toc188867427
_Toc188867427
Anchor
_Toc188867745
_Toc188867745
Anchor
_Toc188936191
_Toc188936191
Anchor
_Toc188936504
_Toc188936504
Anchor
_Toc188937759
_Toc188937759
Anchor
_Toc188940728
_Toc188940728
Anchor
_Toc188940896
_Toc188940896
Anchor
_Toc188941066
_Toc188941066
Anchor
_Toc188942453
_Toc188942453
Anchor
_Toc188942622
_Toc188942622
Anchor
_Toc188942791
_Toc188942791
Anchor
_Toc188942960
_Toc188942960
Anchor
_Toc188943129
_Toc188943129
Anchor
_Toc188943298
_Toc188943298
Anchor
_Toc188943467
_Toc188943467
Anchor
_Toc188943280
_Toc188943280
Anchor
_Toc188943795
_Toc188943795
Anchor
_Toc188943964
_Toc188943964
Anchor
_Toc188944134
_Toc188944134
Anchor
_Toc188944304
_Toc188944304
Anchor
_Toc188944799
_Toc188944799
Anchor
_Toc188952213
_Toc188952213
Anchor
_Toc188953058
_Toc188953058
Anchor
_Toc188953762
_Toc188953762
Anchor
_Toc188953931
_Toc188953931
Anchor
_Toc188955051
_Toc188955051
Anchor
_Toc188956697
_Toc188956697
Anchor
_Toc189281686
_Toc189281686
Anchor
_Toc189282512
_Toc189282512
Anchor
_Toc189380565
_Toc189380565
Anchor
_Toc189470125
_Toc189470125
Anchor
_Toc189470430
_Toc189470430
Anchor
_Toc189470939
_Toc189470939
Anchor
_Toc189471317
_Toc189471317
Anchor
_Toc189471833
_Toc189471833
Anchor
_Toc189472931
_Toc189472931
Anchor
_Toc189473145
_Toc189473145
Anchor
_Toc189548935
_Toc189548935
Anchor
_Toc189887077
_Toc189887077
Anchor
_Toc189887879
_Toc189887879
Anchor
_Toc189888043
_Toc189888043
Anchor
_Toc189902129
_Toc189902129
Anchor
_Toc190070568
_Toc190070568
Anchor
_Toc190077705
_Toc190077705
Anchor
_Toc190078557
_Toc190078557
Anchor
_Toc190079770
_Toc190079770
Anchor
_Toc190080322
_Toc190080322
Anchor
_Toc190143510
_Toc190143510
Anchor
_Toc190143793
_Toc190143793
Anchor
_Toc190144957
_Toc190144957
Anchor
_Toc190145196
_Toc190145196
Anchor
_Toc190148470
_Toc190148470
Anchor
_Toc190150312
_Toc190150312
Anchor
_Toc190153862
_Toc190153862
Anchor
_Toc190156141
_Toc190156141
Anchor
_Toc190156518
_Toc190156518
Anchor
_Toc190157930
_Toc190157930
Anchor
_Toc190159659
_Toc190159659
Anchor
_Toc190160112
_Toc190160112
Anchor
_Toc190162124
_Toc190162124
Anchor
_Toc190163093
_Toc190163093
Anchor
_Toc190237377
_Toc190237377
Anchor
_Toc190492552
_Toc190492552
Anchor
_Toc190496411
_Toc190496411
Anchor
_Toc190496896
_Toc190496896
Anchor
_Toc190497671
_Toc190497671
Anchor
_Toc190508164
_Toc190508164
Anchor
_Toc190510040
_Toc190510040
Anchor
_Toc190574289
_Toc190574289
Anchor
_Toc190574482
_Toc190574482
Anchor
_Toc190574672
_Toc190574672
Anchor
_Toc190577279
_Toc190577279
Anchor
_Toc190578497
_Toc190578497
Anchor
_Toc190848251
_Toc190848251
Anchor
_Toc224360463
_Toc224360463
Anchor
_Toc226346598
_Toc226346598
Anchor
_Toc226346824
_Toc226346824
Anchor
_Toc226350717
_Toc226350717
Anchor
_Toc226350947
_Toc226350947
Anchor
_Toc226351187
_Toc226351187
Anchor
_Toc188079251
_Toc188079251
Anchor
_Toc188775463
_Toc188775463
Anchor
_Toc188775631
_Toc188775631
Anchor
_Toc188775965
_Toc188775965
Anchor
_Toc188776130
_Toc188776130
Anchor
_Toc188776296
_Toc188776296
Anchor
_Toc188776478
_Toc188776478
Anchor
_Toc188779724
_Toc188779724
Anchor
_Toc188846964
_Toc188846964
Anchor
_Toc188852000
_Toc188852000
Anchor
_Toc188852165
_Toc188852165
Anchor
_Toc188852710
_Toc188852710
Anchor
_Toc188852876
_Toc188852876
Anchor
_Toc188853050
_Toc188853050
Anchor
_Toc188867434
_Toc188867434
Anchor
_Toc188867752
_Toc188867752
Anchor
_Toc188936198
_Toc188936198
Anchor
_Toc188936511
_Toc188936511
Anchor
_Toc188937766
_Toc188937766
Anchor
_Toc188940735
_Toc188940735
Anchor
_Toc188940903
_Toc188940903
Anchor
_Toc188941073
_Toc188941073
Anchor
_Toc188942460
_Toc188942460
Anchor
_Toc188942629
_Toc188942629
Anchor
_Toc188942798
_Toc188942798
Anchor
_Toc188942967
_Toc188942967
Anchor
_Toc188943136
_Toc188943136
Anchor
_Toc188943305
_Toc188943305
Anchor
_Toc188943474
_Toc188943474
Anchor
_Toc188943287
_Toc188943287
Anchor
_Toc188943802
_Toc188943802
Anchor
_Toc188943971
_Toc188943971
Anchor
_Toc188944141
_Toc188944141
Anchor
_Toc188944311
_Toc188944311
Anchor
_Toc188944806
_Toc188944806
Anchor
_Toc188952220
_Toc188952220
Anchor
_Toc188953065
_Toc188953065
Anchor
_Toc188953769
_Toc188953769
Anchor
_Toc188953938
_Toc188953938
Anchor
_Toc188955058
_Toc188955058
Anchor
_Toc188956704
_Toc188956704
Anchor
_Toc189281693
_Toc189281693
Anchor
_Toc189282519
_Toc189282519
Anchor
_Toc189380572
_Toc189380572
Anchor
_Toc189470132
_Toc189470132
Anchor
_Toc189470437
_Toc189470437
Anchor
_Toc189470946
_Toc189470946
Anchor
_Toc189471324
_Toc189471324
Anchor
_Toc189471840
_Toc189471840
Anchor
_Toc189472938
_Toc189472938
Anchor
_Toc189473152
_Toc189473152
Anchor
_Toc189548942
_Toc189548942
Anchor
_Toc189887084
_Toc189887084
Anchor
_Toc189887886
_Toc189887886
Anchor
_Toc189888050
_Toc189888050
Anchor
_Toc189902136
_Toc189902136
Anchor
_Toc190070575
_Toc190070575
Anchor
_Toc190077712
_Toc190077712
Anchor
_Toc190078564
_Toc190078564
Anchor
_Toc190079777
_Toc190079777
Anchor
_Toc190080329
_Toc190080329
Anchor
_Toc190143517
_Toc190143517
Anchor
_Toc190143800
_Toc190143800
Anchor
_Toc190144964
_Toc190144964
Anchor
_Toc190145203
_Toc190145203
Anchor
_Toc190148477
_Toc190148477
Anchor
_Toc190150319
_Toc190150319
Anchor
_Toc190153869
_Toc190153869
Anchor
_Toc190156148
_Toc190156148
Anchor
_Toc190156525
_Toc190156525
Anchor
_Toc190157937
_Toc190157937
Anchor
_Toc190159666
_Toc190159666
Anchor
_Toc190160119
_Toc190160119
Anchor
_Toc190162131
_Toc190162131
Anchor
_Toc190163100
_Toc190163100
Anchor
_Toc190237384
_Toc190237384
Anchor
_Toc190492559
_Toc190492559
Anchor
_Toc190496418
_Toc190496418
Anchor
_Toc190496903
_Toc190496903
Anchor
_Toc190497678
_Toc190497678
Anchor
_Toc190508171
_Toc190508171
Anchor
_Toc190510047
_Toc190510047
Anchor
_Toc190574296
_Toc190574296
Anchor
_Toc190574489
_Toc190574489
Anchor
_Toc190574679
_Toc190574679
Anchor
_Toc190577286
_Toc190577286
Anchor
_Toc190578504
_Toc190578504
Anchor
_Toc190848258
_Toc190848258
Anchor
_Toc224360470
_Toc224360470
Anchor
_Toc226346605
_Toc226346605
Anchor
_Toc226346831
_Toc226346831
Anchor
_Toc226350724
_Toc226350724
Anchor
_Toc226350954
_Toc226350954
Anchor
_Toc226351194
_Toc226351194
Anchor
_Toc188079255
_Toc188079255
Anchor
_Toc188775467
_Toc188775467
Anchor
_Toc188775635
_Toc188775635
Anchor
_Toc188775969
_Toc188775969
Anchor
_Toc188776134
_Toc188776134
Anchor
_Toc188776300
_Toc188776300
Anchor
_Toc188776482
_Toc188776482
Anchor
_Toc188779728
_Toc188779728
Anchor
_Toc188846968
_Toc188846968
Anchor
_Toc188852004
_Toc188852004
Anchor
_Toc188852169
_Toc188852169
Anchor
_Toc188852714
_Toc188852714
Anchor
_Toc188852880
_Toc188852880
Anchor
_Toc188853054
_Toc188853054
Anchor
_Toc188867438
_Toc188867438
Anchor
_Toc188867756
_Toc188867756
Anchor
_Toc188936202
_Toc188936202
Anchor
_Toc188936515
_Toc188936515
Anchor
_Toc188937770
_Toc188937770
Anchor
_Toc188940739
_Toc188940739
Anchor
_Toc188940907
_Toc188940907
Anchor
_Toc188941077
_Toc188941077
Anchor
_Toc188942464
_Toc188942464
Anchor
_Toc188942633
_Toc188942633
Anchor
_Toc188942802
_Toc188942802
Anchor
_Toc188942971
_Toc188942971
Anchor
_Toc188943140
_Toc188943140
Anchor
_Toc188943309
_Toc188943309
Anchor
_Toc188943478
_Toc188943478
Anchor
_Toc188943389
_Toc188943389
Anchor
_Toc188943806
_Toc188943806
Anchor
_Toc188943975
_Toc188943975
Anchor
_Toc188944145
_Toc188944145
Anchor
_Toc188944315
_Toc188944315
Anchor
_Toc188944810
_Toc188944810
Anchor
_Toc188952224
_Toc188952224
Anchor
_Toc188953069
_Toc188953069
Anchor
_Toc188953773
_Toc188953773
Anchor
_Toc188953942
_Toc188953942
Anchor
_Toc188955062
_Toc188955062
Anchor
_Toc188956708
_Toc188956708
Anchor
_Toc189281697
_Toc189281697
Anchor
_Toc189282523
_Toc189282523
Anchor
_Toc189380576
_Toc189380576
Anchor
_Toc189470136
_Toc189470136
Anchor
_Toc189470441
_Toc189470441
Anchor
_Toc189470950
_Toc189470950
Anchor
_Toc189471328
_Toc189471328
Anchor
_Toc189471844
_Toc189471844
Anchor
_Toc189472942
_Toc189472942
Anchor
_Toc189473156
_Toc189473156
Anchor
_Toc189548946
_Toc189548946
Anchor
_Toc189887088
_Toc189887088
Anchor
_Toc189887890
_Toc189887890
Anchor
_Toc189888054
_Toc189888054
Anchor
_Toc189902140
_Toc189902140
Anchor
_Toc190070579
_Toc190070579
Anchor
_Toc190077716
_Toc190077716
Anchor
_Toc190078568
_Toc190078568
Anchor
_Toc190079781
_Toc190079781
Anchor
_Toc190080333
_Toc190080333
Anchor
_Toc190143521
_Toc190143521
Anchor
_Toc190143804
_Toc190143804
Anchor
_Toc190144968
_Toc190144968
Anchor
_Toc190145207
_Toc190145207
Anchor
_Toc190148481
_Toc190148481
Anchor
_Toc190150323
_Toc190150323
Anchor
_Toc190153873
_Toc190153873
Anchor
_Toc190156152
_Toc190156152
Anchor
_Toc190156529
_Toc190156529
Anchor
_Toc190157941
_Toc190157941
Anchor
_Toc190159670
_Toc190159670
Anchor
_Toc190160123
_Toc190160123
Anchor
_Toc190162135
_Toc190162135
Anchor
_Toc190163104
_Toc190163104
Anchor
_Toc190237388
_Toc190237388
Anchor
_Toc190492563
_Toc190492563
Anchor
_Toc190496422
_Toc190496422
Anchor
_Toc190496907
_Toc190496907
Anchor
_Toc190497682
_Toc190497682
Anchor
_Toc190508175
_Toc190508175
Anchor
_Toc190510051
_Toc190510051
Anchor
_Toc190574300
_Toc190574300
Anchor
_Toc190574493
_Toc190574493
Anchor
_Toc190574683
_Toc190574683
Anchor
_Toc190577290
_Toc190577290
Anchor
_Toc190578508
_Toc190578508
Anchor
_Toc190848262
_Toc190848262
Anchor
_Toc224360474
_Toc224360474
Anchor
_Toc226346609
_Toc226346609
Anchor
_Toc226346835
_Toc226346835
Anchor
_Toc226350728
_Toc226350728
Anchor
_Toc226350958
_Toc226350958
Anchor
_Toc226351198
_Toc226351198
Anchor
_Toc188079266
_Toc188079266
Anchor
_Toc188775478
_Toc188775478
Anchor
_Toc188775646
_Toc188775646
Anchor
_Toc188775980
_Toc188775980
Anchor
_Toc188776145
_Toc188776145
Anchor
_Toc188776311
_Toc188776311
Anchor
_Toc188776493
_Toc188776493
Anchor
_Toc188779739
_Toc188779739
Anchor
_Toc188846979
_Toc188846979
Anchor
_Toc188852015
_Toc188852015
Anchor
_Toc188852180
_Toc188852180
Anchor
_Toc188852725
_Toc188852725
Anchor
_Toc188852891
_Toc188852891
Anchor
_Toc188853065
_Toc188853065
Anchor
_Toc188867449
_Toc188867449
Anchor
_Toc188867767
_Toc188867767
Anchor
_Toc188936213
_Toc188936213
Anchor
_Toc188936526
_Toc188936526
Anchor
_Toc188937781
_Toc188937781
Anchor
_Toc188940750
_Toc188940750
Anchor
_Toc188940918
_Toc188940918
Anchor
_Toc188941088
_Toc188941088
Anchor
_Toc188942475
_Toc188942475
Anchor
_Toc188942644
_Toc188942644
Anchor
_Toc188942813
_Toc188942813
Anchor
_Toc188942982
_Toc188942982
Anchor
_Toc188943151
_Toc188943151
Anchor
_Toc188943320
_Toc188943320
Anchor
_Toc188943489
_Toc188943489
Anchor
_Toc188943569
_Toc188943569
Anchor
_Toc188943817
_Toc188943817
Anchor
_Toc188943986
_Toc188943986
Anchor
_Toc188944156
_Toc188944156
Anchor
_Toc188944326
_Toc188944326
Anchor
_Toc188944821
_Toc188944821
Anchor
_Toc188952235
_Toc188952235
Anchor
_Toc188953080
_Toc188953080
Anchor
_Toc188953784
_Toc188953784
Anchor
_Toc188953953
_Toc188953953
Anchor
_Toc188955073
_Toc188955073
Anchor
_Toc188956719
_Toc188956719
Anchor
_Toc189281708
_Toc189281708
Anchor
_Toc189282534
_Toc189282534
Anchor
_Toc189380587
_Toc189380587
Anchor
_Toc189470147
_Toc189470147
Anchor
_Toc189470452
_Toc189470452
Anchor
_Toc189470961
_Toc189470961
Anchor
_Toc189471339
_Toc189471339
Anchor
_Toc189471855
_Toc189471855
Anchor
_Toc189472953
_Toc189472953
Anchor
_Toc189473167
_Toc189473167
Anchor
_Toc189548957
_Toc189548957
Anchor
_Toc189887099
_Toc189887099
Anchor
_Toc189887901
_Toc189887901
Anchor
_Toc189888065
_Toc189888065
Anchor
_Toc189902151
_Toc189902151
Anchor
_Toc190070590
_Toc190070590
Anchor
_Toc190077727
_Toc190077727
Anchor
_Toc190078579
_Toc190078579
Anchor
_Toc190079792
_Toc190079792
Anchor
_Toc190080344
_Toc190080344
Anchor
_Toc190143532
_Toc190143532
Anchor
_Toc190143815
_Toc190143815
Anchor
_Toc190144979
_Toc190144979
Anchor
_Toc190145218
_Toc190145218
Anchor
_Toc190148492
_Toc190148492
Anchor
_Toc190150334
_Toc190150334
Anchor
_Toc190153884
_Toc190153884
Anchor
_Toc190156163
_Toc190156163
Anchor
_Toc190156540
_Toc190156540
Anchor
_Toc190157952
_Toc190157952
Anchor
_Toc190159681
_Toc190159681
Anchor
_Toc190160134
_Toc190160134
Anchor
_Toc190162146
_Toc190162146
Anchor
_Toc190163115
_Toc190163115
Anchor
_Toc190237399
_Toc190237399
Anchor
_Toc190492574
_Toc190492574
Anchor
_Toc190496433
_Toc190496433
Anchor
_Toc190496918
_Toc190496918
Anchor
_Toc190497693
_Toc190497693
Anchor
_Toc190508186
_Toc190508186
Anchor
_Toc190510062
_Toc190510062
Anchor
_Toc190574311
_Toc190574311
Anchor
_Toc190574504
_Toc190574504
Anchor
_Toc190574694
_Toc190574694
Anchor
_Toc190577301
_Toc190577301
Anchor
_Toc190578519
_Toc190578519
Anchor
_Toc190848273
_Toc190848273
Anchor
_Toc224360485
_Toc224360485
Anchor
_Toc226346620
_Toc226346620
Anchor
_Toc226346846
_Toc226346846
Anchor
_Toc226350739
_Toc226350739
Anchor
_Toc226350969
_Toc226350969
Anchor
_Toc226351209
_Toc226351209
Anchor
_Toc188079272
_Toc188079272
Anchor
_Toc188775484
_Toc188775484
Anchor
_Toc188775652
_Toc188775652
Anchor
_Toc188775986
_Toc188775986
Anchor
_Toc188776151
_Toc188776151
Anchor
_Toc188776317
_Toc188776317
Anchor
_Toc188776499
_Toc188776499
Anchor
_Toc188779745
_Toc188779745
Anchor
_Toc188846985
_Toc188846985
Anchor
_Toc188852021
_Toc188852021
Anchor
_Toc188852186
_Toc188852186
Anchor
_Toc188852731
_Toc188852731
Anchor
_Toc188852897
_Toc188852897
Anchor
_Toc188853071
_Toc188853071
Anchor
_Toc188867455
_Toc188867455
Anchor
_Toc188867773
_Toc188867773
Anchor
_Toc188936219
_Toc188936219
Anchor
_Toc188936532
_Toc188936532
Anchor
_Toc188937787
_Toc188937787
Anchor
_Toc188940756
_Toc188940756
Anchor
_Toc188940924
_Toc188940924
Anchor
_Toc188941094
_Toc188941094
Anchor
_Toc188942481
_Toc188942481
Anchor
_Toc188942650
_Toc188942650
Anchor
_Toc188942819
_Toc188942819
Anchor
_Toc188942988
_Toc188942988
Anchor
_Toc188943157
_Toc188943157
Anchor
_Toc188943326
_Toc188943326
Anchor
_Toc188943495
_Toc188943495
Anchor
_Toc188943575
_Toc188943575
Anchor
_Toc188943823
_Toc188943823
Anchor
_Toc188943992
_Toc188943992
Anchor
_Toc188944162
_Toc188944162
Anchor
_Toc188944332
_Toc188944332
Anchor
_Toc188944827
_Toc188944827
Anchor
_Toc188952241
_Toc188952241
Anchor
_Toc188953086
_Toc188953086
Anchor
_Toc188953790
_Toc188953790
Anchor
_Toc188953959
_Toc188953959
Anchor
_Toc188955079
_Toc188955079
Anchor
_Toc188956725
_Toc188956725
Anchor
_Toc189281714
_Toc189281714
Anchor
_Toc189282540
_Toc189282540
Anchor
_Toc189380593
_Toc189380593
Anchor
_Toc189470153
_Toc189470153
Anchor
_Toc189470458
_Toc189470458
Anchor
_Toc189470967
_Toc189470967
Anchor
_Toc189471345
_Toc189471345
Anchor
_Toc189471861
_Toc189471861
Anchor
_Toc189472959
_Toc189472959
Anchor
_Toc189473173
_Toc189473173
Anchor
_Toc189548963
_Toc189548963
Anchor
_Toc189887105
_Toc189887105
Anchor
_Toc189887907
_Toc189887907
Anchor
_Toc189888071
_Toc189888071
Anchor
_Toc189902157
_Toc189902157
Anchor
_Toc190070596
_Toc190070596
Anchor
_Toc190077733
_Toc190077733
Anchor
_Toc190078585
_Toc190078585
Anchor
_Toc190079798
_Toc190079798
Anchor
_Toc190080350
_Toc190080350
Anchor
_Toc190143538
_Toc190143538
Anchor
_Toc190143821
_Toc190143821
Anchor
_Toc190144985
_Toc190144985
Anchor
_Toc190145224
_Toc190145224
Anchor
_Toc190148498
_Toc190148498
Anchor
_Toc190150340
_Toc190150340
Anchor
_Toc190153890
_Toc190153890
Anchor
_Toc190156169
_Toc190156169
Anchor
_Toc190156546
_Toc190156546
Anchor
_Toc190157958
_Toc190157958
Anchor
_Toc190159687
_Toc190159687
Anchor
_Toc190160140
_Toc190160140
Anchor
_Toc190162152
_Toc190162152
Anchor
_Toc190163121
_Toc190163121
Anchor
_Toc190237405
_Toc190237405
Anchor
_Toc190492580
_Toc190492580
Anchor
_Toc190496439
_Toc190496439
Anchor
_Toc190496924
_Toc190496924
Anchor
_Toc190497699
_Toc190497699
Anchor
_Toc190508192
_Toc190508192
Anchor
_Toc190510068
_Toc190510068
Anchor
_Toc190574317
_Toc190574317
Anchor
_Toc190574510
_Toc190574510
Anchor
_Toc190574700
_Toc190574700
Anchor
_Toc190577307
_Toc190577307
Anchor
_Toc190578525
_Toc190578525
Anchor
_Toc190848279
_Toc190848279
Anchor
_Toc224360491
_Toc224360491
Anchor
_Toc226346626
_Toc226346626
Anchor
_Toc226346852
_Toc226346852
Anchor
_Toc226350745
_Toc226350745
Anchor
_Toc226350975
_Toc226350975
Anchor
_Toc226351215
_Toc226351215
Anchor
_Toc6991053
_Toc6991053
Anchor
_Toc478039029
_Toc478039029
Point of Sale (POS)

As of Version 9.5.0.0, Point of Sale (POS) is no longer part of the AGRIS system.

Anchor
_Toc6991058
_Toc6991058
Anchor
_Toc478039030
_Toc478039030
Blender Control Setup

The following Automated Blender Controls are available for AGRIS.

...

Please refer to section 2.16 for instructions on updating the Auto Blender configuration information.

Anchor
_Toc478039031
_Toc478039031
The AGRIS Initialization File

The AGRIS Initialization file (agris.ini) is located in the root of the AGRIS installation folder and contains eight lines at the end that may need to be set depending on your configuration of AGRIS.

Anchor
_Ref189470528
_Ref189470528
Anchor
_Toc478039032
_Toc478039032
Path Settings

The agris.ini file is primarily used to instruct clients as to where datasets and user defined reports are located. It is located in the root of the AGRIS installation folder and contains 6 lines at the end that may need to be set depending on your configuration of AGRIS.
Essentially, the Data Path and Work Path should be filled in. The remaining paths will default to the correct locations based on how the Data Path is set.
Note:Path setting information is also provided in the agris.ini file.

Data Path

This is the path to the location of the agris\datasets folder where all of your data is kept. If running standalone this value does not need to be set since it defaults to the local machine. If running in a client server environment this value needs to point to the database server.
Example: \\server\apps\agris\datasets.

Support Path

This is the path to the location of the support folder. By default this is set relative to the path set for the Data path.

Userprog Path

This is the path to the location of the userprog folder. By default this is set relative to the path set for the Data Path.

Work Path

This is the path to the location of where AGRIS creates temporary files. By default this is set to the Data path. (For best performance, set this to a local drive. Example: c:\apps\agris\temp)

Component Server

This is the name of the server that runs the AGRIS COM+ applications. If left blank, this setting is derived from the Data path. Otherwise, this can be set to the name of a separate Component Server on the network.

Locking Server

This is the name of the server that runs the AGRIS COM+ ServerLock application. If left blank, this setting is derived from the Data path. Otherwise, this can be set to the name of a separate Locking Server on the network. When this field is used all clients need to use the same Locking Server or data corruption could occur due to multiple locking servers.

GEOData Path

This parameter provides the ability to reference your Georeference data such as TIGER data from various locations on your network. This path can contain drive letters or UNC but it must be a valid location, otherwise you will get an error. If the GEOData Path is empty then the default is Agrisroot\support\agy. If the GEOData Path is set then this value will override the default.

Notification URL

Using Notification URL01 - 99 you can point to different Web Services that may be needed. They must be sequentially set with no gaps, starting with Notification URL01.

Examples:
Notification URL03 cannot be set unless Notification URL01 and Notification URL02 have been set. If Notification URL02 needs to be removed, then Notification URL03 should be changed to Notification URL02 or Notification URL02 must be set to something like "Available" or "Unused".

Anchor
_Toc478039033
_Toc478039033
Original File Source Code

;Agris Setup Information
;---------------------------------------------------------------------
;The following explain how the paths will default if not set here or
;if the folder the setting points to does not exist at startup.
;Assuming Agris was installed in C:\AGRIS, Data Path will be set to
;C:\AGRIS\DATASETS.
;Support Path will be set relative to the Data Path if Support exists
;there else the Support Path is set relative to the application/program
;path. This folder is required for the application to run and the
;installation program installs Support under the application folder
;i.e. C:\AGRIS. Agris will not create the support folder. It assumes
;it already exists.
;Userprog Path will be set relative to the parent
;folder of the Data Path setting, if USERPROG folder
;exists there. If not, the UserProg path will be created.
;Work Path will be set to Data Path if Work Path is left blank.
;Work Path will be set relative to drive specification of the Data Path
;setting if Work Path does not contain a drive specification. Assuming
;Data Path is set to C:\AGRIS\DATASETS and Work Path is TEMP, then
;Work Path would be reset to C:\TEMP. Work Path will not be reset if
;Work Path is set to an absolute path such as C:\TEMP. Agris startup
;verifies the Work Path. If work path doesn't exist Agris will attempt
;to create it but parent folders cannot be created. If the parent folder
;does not exist the create work path will fail which will cause Agris to
;terminate.
;Component Server will be set to the name of the database server if
;Component Server is left blank. Otherwise, specify the name of the
;server which you intend to utilize as your component server. You can
;also specify the ip address of the component server but it is not
;recommended.
;Locking Server will be set to the name of the database server if
;the Locking Server is left blank. This has been the default behavior
;for prior AGRIS releases. In most cases, this field will be blank.
;However, if this field is set, it is recommended that it be set to
;one (and only one) of the component servers.

;GEOData Path provides the ability to reference your GEOReference
;data such as TigerData from various locations on your network.
;This path can contain drive letters or UNC but it must be a valid
;location, otherwise you will get an error. If the GEOData Path is
;empty then the default is Agrisroot\support\agy. If the GEOData
;Path is set then this value will override the default.
;Notification URL01 through Notification URL99 can be set to
;point to different Web Services that may be needed. They must
;be sequentially set with no gaps starting with Notification URL01.
;For example, Notification URL03 can not be set unless
;Notification URL01 and Notification URL02 have been set. If
;Notification URL02 needs to be removed, then Notification URL03
;should be changed to Notification URL02 or Notification URL02
;must be set to something like "Available" or "Unused".
;Sample settings
;
;Scenario 1
;
;Data Path=g:\agris\datasets
;Support Path=
;Userprog Path=
;Work Path=
;Component Server=
;Locking Server=
;
;Scenario 2
;
;Data Path=\\servername\apps\agris\datasets
;Support Path=
;Userprog Path=
;Work Path=
;Component Server=CUSTSVR01
;Locking Server=
;GEOData Path=\\apps\georeference\Tiger
;Notification URL01=http://servername1:23350/agrisgateway/service
;Notification URL02=available
;Notification URL03=http://servername2:23350/agrisgateway/service
;
;Scenario 3
;
;Data Path=\\servername\apps\agris\datasets
;Support Path=
;Userprog Path=\\servername\apps\agris\userprog
;Work Path=\\servername\apps\agris\workpath
;Component Server=CUSTSVR01
;Locking Server=CUSTSVR01
;
;Scenario 4
;
;Data Path=\\servername\apps\agris\datasets
;Support Path=
;Userprog Path=\\servername\apps\agris\userprog
;Work Path=\\servername\apps\agris\workpath
;Component Server=CUSTSVR01
;Locking Server=LOCKINGSVR
;
;Scenario 5
;
;Data Path=
;Support Path=
;Userprog Path=
;Work Path=
;Component Server=
;Locking Server=
;
;---------------------------------------------------------------------
[Paths]
Data Path=
Support Path=
Userprog Path=
Work Path=
Component Server=
Locking Server=
GEOData Path=
Notification URL01=

Anchor
_Toc478039034
_Toc478039034
Anchor
_Toc522174744
_Toc522174744
Anchor
_Toc6991060
_Toc6991060
Utility Information

Anchor
_Setting_up_Pervasive
_Setting_up_Pervasive
Anchor
_Setting_up_Pervasive_rights_on_a_se
_Setting_up_Pervasive_rights_on_a_se
Anchor
_Toc522174753
_Toc522174753
Anchor
_Toc6991062
_Toc6991062
Anchor
_Ref190079097
_Ref190079097
Anchor
_Ref190079123
_Ref190079123
Anchor
_Toc478039035
_Toc478039035
Anchor
_Toc522174747
_Toc522174747
The Alternate AGRIS INI File

AGRIS includes an option that allows you to use an alternate initialization file. This feature allows you to set up multiple INI files, pointing to various locations, based on the options set in those INI files. This feature also allows you to access reports from another USERPROG directory.
To use this feature, you must edit the AGRIS shortcut:

...

    • The Target command, above, shows an example of allowing the shortcut to point to an alternate agris.ini file. This is accomplished by including the "/I" parameter, followed by the drive letter and full directory path, then the name of the agris.ini file. You can also use this new parameter within a .BAT file from DOS when launching the main AGRIS menu (SysMenu.exe). You can set up multiple desktop shortcuts or batch files and use the command line parameter to access the alternate agris.ini files. The contents of the alternate agris.ini file allow access to multiple sets of "dataset" directory and "userprog" directories with one installation of the Version 2021.31.0 system.
    • Add the current .ini file location and current SUPPORT and USERPROG path settings. Since you can access multiple INI files, the System Information Report was enhanced to show the currently active Userprog, Support and Data paths, and the currently active agris.ini file.

Anchor
_Diagnostics_Utilities
_Diagnostics_Utilities
Anchor
_Toc522174754
_Toc522174754
Anchor
_Toc6991063
_Toc6991063

Anchor
_Toc478039036
_Toc478039036
Diagnostics Utilities

The Utilities >> Diagnostics menu option allows network connectivity and performance testing.

Anchor
_Toc522174755
_Toc522174755
Anchor
_Toc6991064
_Toc6991064
Anchor
_Toc478039037
_Toc478039037
Testing Remote Components

Use this feature to test remote connectivity for COM+ applications.

...

    • You can perform the following tests:

Anchor
_Toc6991065
_Toc6991065
Check Version

This test shows the version of AGRIS installed on the Client and the Server.

Test All Remote Components

This test shows the results of testing all of the COM+ components. The following information is displayed in the results:

...

Note:It may take longer for the test to finish if there are errors in the creation of some components.

Test AGY Components

This tests only the AgroGuide (AGY) COM+ components. Results are provided in the same format as the full test.

Test Only API XML Components

This tests only the API XML COM+ components. Results are provided in the same format as the full test.

Diagnose Server Components

This tests for connectivity between the client workstation and the COM+ server. The Sys_Svr_TestRemote.cls TestRemote tests basic connectivity between the workstation and the server to be able to create objects. The ShrDataServProxy.DTransMGR tests that connectivity is in place for the FMB and CPR applications.
You must specify the "Remote Server Name or IP address" to test remote application connectivity. Use this test to determine if components are responding to program calls. If the test fails, then specify the IP address of the server to bypass/confirm name resolution problems. The Remote Server Name defaults to the AGRIS Component Server specified in the agris.ini file. If the component server is not specified in the agris.ini then the default is the database server. If the test passes with the Server IP address but not with the Server Name then there is probably a problem with name resolution on the network. Name resolution must be functioning correctly for some AGRIS modules to work.
Test the components by clicking either "Test Sys_Svr_TestRemote.cls TestRemote" or "Test ShrDataServProxy.DTransMGR" to test the remote server components. These buttons instantiate an object on the specified COM+ server, then call that object. A box containing the following message appears:

...

There is also an option to manually enter any COM+ component and click Create Object on any dll class to test that individual component.

Anchor
_Toc6991067
_Toc6991067
Test Print Regulatory

This test provides the performance information of the print regulatory routine through an indefinite loop. The performance of the routine is shown on the form and any anomaly is recorded to the specified file for later analysis.

...

Started

The time the start button is clicked – the execution starts.

Stopped

The time the Stop button is clicked – the execution stops.

Loop Counter

The current loop/iteration number.

Time Elapsed

The elapsed time since the start of the execution.

Min Time

The minimum execution time for any loop/iteration during the execution.

Max Time

The maximum execution time for any loop/iteration during the execution.


Test Licenses

Use this feature to test license performance. If noticeable delays are occurring while navigating the AGRIS System, this utility helps diagnose the problem. Typically, it should take less than a second for the system to access a license, but there are instances where it could take longer. If times are consistently longer than a second, then the network configuration may need to be investigated. Typically, when these delays occur, they are caused by improper network configurations.
The licensing component is called after selecting most System Manager Menu options. It accesses a license and then compares the current count to the licenses purchased.
To access this utility from AGRIS:

      • Click Utilities >> Diagnostics >> Test Licenses.
      • Click Start Test to access a license
      • Count the total in use
      • Release the license each second. Once started, the button changes to Stop Test.
      • Click Stop Test to stop the test.


Validate Database

A new validation utility now allows you to scan datasets for errors before converting them.
To access this utility from AGRIS:

...

    • Either accept the default path and filename to validate the current dataset, or type in the location of another dataset you want to validate.
    • Click OK to run the validation utility.
    • When the validation process is complete, any errors are displayed in an error log.

Anchor
_Ref189471414
_Ref189471414
Anchor
_Ref189471415
_Ref189471415
Anchor
_Ref189471416
_Ref189471416
Anchor
_Toc478039038
_Toc478039038
Database Conversion Validation

If your datasets require reformatting as part of the upgrade to AGRIS 2021.31.0, a new validation utility now allows you to scan these datasets for errors before converting them.
When starting a Dataset Conversion during the upgrade to Version 2021.31.0, the Select Dataset window will appear.

...

  • Click the new Validate button prior to starting the conversion process to scan the original datasets for any potential problems areas that need to be addressed prior to the conversion.
  • Click OK to start the conversion process. When the conversion is complete, the system displays the main menu.

    The Database Conversion utility creates a log entry for the conversion of each package in the dataset.
    When reviewing the conversion log (convert.log) following a dataset conversion, you may see old dates in the log entries. This occurs when you have converted a dataset before. The log appends any new log entries to the bottom of the existing log, which can result in the same file appearing in the file multiple times, with different conversion dates.


Anchor
_Toc158618063
_Toc158618063
Anchor
_Toc478039039
_Toc478039039
Printer Associations


A new feature introduced in AGRIS V9.4.1 allows for text drivers to be associated with more than three printers. Text drivers are helpful for making forms and checks format correctly when printed and also makes printing more efficient.
To utilize this new feature, please follow the steps below.

...

  • Select the desired printer and click Select. An X appears in the Enabled column indicating that a printer has been selected for association.
    • To deselect a printer that is currently enabled, just select the printer again and click Select.
  • Repeat Step 4 for as many printers as necessary.
  • Click Save/Exit to save your changes and return to the Printer Driver Maintenance window.
  • To associate other print drivers, repeat Steps 3-6, as needed.

Anchor
_Toc158618065
_Toc158618065
Anchor
_Toc478039040
_Toc478039040
Appendices

Anchor
_Appendix_A_–
_Appendix_A_–
Anchor
_Ref88363379
_Ref88363379
Anchor
_Ref88363575
_Ref88363575
Anchor
_Toc158618070
_Toc158618070
Anchor
_Toc478039041
_Toc478039041
Appendix A – Install Mode on Citrix Servers/Terminal Servers

Install mode is used to install applications in such a way that all profiles that reside on a Citrix Server/Terminal Server are updated by the installation. Therefore, before installing any applications on a Citrix Server/Terminal Server, it is important to enter install mode.
Entering Install Mode

...

    • Click Start >> Run.
    • Type in CMD and press [Enter].
    • At the command prompt, type change user/execute and press [Enter]. A line appears, indicating that the user session is ready to execute applications.
    • Close the command prompt. Alternately, restarting the server also returns it to Execute mode.

Anchor
_Toc80773350
_Toc80773350
Anchor
_Ref88363783
_Ref88363783
Anchor
_Ref88363797
_Ref88363797
Anchor
_Ref88364032
_Ref88364032
Anchor
_Ref88364049
_Ref88364049
Anchor
_Ref88364165
_Ref88364165
Anchor
_Ref88364183
_Ref88364183
Anchor
_Ref88364213
_Ref88364213
Anchor
_Ref88364229
_Ref88364229
Anchor
_Toc158618071
_Toc158618071
Anchor
_Toc478039042
_Toc478039042
Appendix B – Common Applications that may Prevent Installation

  • ICA Administrator Toolbar

...

      • Press [Ctrl][Alt][Delete].
      • Click Task Manager.
      • Click Processes tab.
      • Locate and click Aecomm.exe.
      • Click End Process.
      • Click Yes on the Task Manager Warning message.
      • Close Task Manager.
      • Double-click Retry to continue the installation.

Anchor
_Toc80773351
_Toc80773351
Anchor
_Ref88442867
_Ref88442867
Anchor
_Ref88442898
_Ref88442898
Anchor
_Toc158618072
_Toc158618072
Anchor
_Toc478039043
_Toc478039043
Appendix C – Setting the Screen Resolution to 1024x768 or higher

  1. Click on Start >> (Settings) >> Control Panel.
  2. Double-click the Display icon.
  3. Click Settings tab.
  4. Adjust the Screen resolution slider so that it is set to at least 1024x768.
  5. Click OK.

    Note:  If you want to review your new screen resolution setting before accepting it, click Apply first, review the new screen, then click OK.

  6. Close the Control Panel.

Anchor
_Toc80773349
_Toc80773349
Anchor
_Ref88381516
_Ref88381516
Anchor
_Ref88381533
_Ref88381533
Anchor
_Toc158618073
_Toc158618073
Anchor
_Toc478039044
_Toc478039044
Appendix D – Finding your Domain or Server Name

  1. Go to the AGRIS server
  2. Right-click My Computer >> Properties.
  3. Click the Computer Name or Network Identification tab.
  4. Find the Full computer name section. Both the server name and the domain name are both referenced in this section.

Example:  ServerDC is the server name and AGRIS is the domain name.The full computer name is ServerDC.AGRIS.local.

Anchor
_Toc158618075
_Toc158618075
Anchor
_Toc478039045
_Toc478039045
Appendix E – oneWeigh Security Changes:

oneWeigh security is integrated into the AGRIS System Security utility. If you are currently using security in AGRIS or oneWeigh on a version prior to V9.4.x, refer to the following scenarios to determine which change you need to make:

Scenario 1: AGRIS Security OFF - oneWeigh security ON

All existing oneWeigh security is disabled and users can access all oneWeigh dialogs without passwords until AGRIS Security is enabled for the dataset and the oneWeigh users' security accounts are configured.

Scenario 2: AGRIS Security ON - oneWeigh Security OFF

Until their oneWeigh security account is configured, users can access to AGRIS but not oneWeigh.

Scenario 3: AGRIS Security ON - oneWeigh Security ON

Until their oneWeigh security account is configured, users can access to AGRIS, but all existing oneWeigh security is disabled and there is no access to oneWeigh.

Anchor
_Toc158618076
_Toc158618076
Anchor
_Toc478039046
_Toc478039046
Appendix F – Citrix Virtual Memory Optimization

Citrix contains a Virtual Memory Optimization utility that can cause Btrieve 8020 errors and error zeros when launching AGRIS. To minimize this problem, disable the Citrix Virtual Memory Optimization service. To disable the Citrix Virtual Memory Optimization service:

...

Note: If the Btrieve 8020 error still occurs, uninstall Pervasive PSQL, then reinstall it.

Anchor
_Toc478039047
_Toc478039047
Appendix G –
Anchor
_Toc158617995
_Toc158617995
Setting the TCP Ports


Anchor
Appendix_H
Appendix_H
A firewall is recommended for any organization using high-speed internet access to help prevent unauthorized inbound connections (intrusions) from the internet into a local network. There are 2 types of firewalls: hardware and software. A software firewall is an application that runs on an individual computer while a hardware firewall is a physical device, such as a router, that provides firewall capabilities. Greenstone recommends the use of a hardware firewall to secure the network. No special configuration should be required to allow access to AGRIS when using a hardware firewall as AGRIS does not run across the internet (remote locations access AGRIS via Citrix/Terminal Server so those ports do need to be open).
Some organizations may also wish to utilize a software firewall, such as Windows Firewall, in addition to a hardware firewall. Here is a listing of the primary ports that must be opened on a software firewall in order to allow access to AGRIS:
Primary Ports:
Pervasive: 1583 and 3351 (TCP)
DNS: 53 (UDP, TCP)
COM+ (a.k.a. Enterprise Services): 135 (TCP) + random ports between 1024-65534 (TCP)*
Additional ports that may be required depending upon the system configuration:
Terminal Services: 3389 (TCP)
Citrix: 1494 (TCP)
FTP: 21 (TCP)

...


Configuration of the Windows Firewall showing explicitly defined inbound rules for the primary ports discussed previously:

Anchor
_Toc478039048
_Toc478039048
Appendix H: Tips, Known Issues, and Best Practices

The following is a list of tips, known issues, and best practices for installing or upgrading to more recent Microsoft operating systems, Pervasive® PSQL™, and AGRIS 2021.31.0.

Anchor
_Toc236729441
_Toc236729441
Anchor
_Toc267308911
_Toc267308911
Anchor
_Toc478039049
_Toc478039049
Pervasive® PSQL™

If you are upgrading from Pervasive PSQL v8.X, uninstall that version of PSQL before installing a version supported by the new version of AGRIS.

If you already use Pervasive Back-up Agent™, you must purchase Back-up Agent 2.0 for use with Pervasive® PSQL™ v11 or v12. See the Pervasive web site for details.



NOTE: The Create File Version and the Limit Segment Size settings discussed in this section are applied automatically as part of the AGRIS install when you allow the system to apply optimization changes towards the end of the installation routine. The information below is provided for reference only.
If you are installing Pervasive® PSQL™ on a computer with a version of Pervasive® PSQL™ prior to v10.X already installed, open the Pervasive Control Center and, before opening AGRIS and attempting to convert any datasets to AGRIS, set the File Version to 9.5.

The Workstation Properties Window

When converting datasets with split files (files that have split to .^01 or more on the files), there is a possibility of overloading the Transaction Log file size allocation for files in that dataset. Uncheck the Limit Segment Size to 2GB option in the Pervasive® PSQL™ Control Center Workstation Properties window.

The Workstation Properties Window
Once this setting has taken effect, Pervasive® PSQL™ combines these split files during the conversion process and this problem no longer occurs.


 RetailWise

RetailWise customers cannot upgrade directly to this version of AGRIS and must coordinate their upgrade to Store Manager ES and AGRIS 2021.31.0 with the Sales Team (800-393-0075). The AGRIS Integration Platform (AIP) for RetailWise, which is translates data between RetailWise and AGRIS, is not supported in AGRIS 9.5.0.7 and higher. Note that customers already running Store Manager ES are not impacted by this and are able to upgrade to AGRIS 2021.31.0.

If upgrading to Pervasive® PSQL™ v10 or greater, instead of uninstalling the previous version and installing the new version:
NOTE: If you have already upgraded to PSQL v10 or greater as part of a prior update, skip this procedure.
1. Open Pervasive PSQL.
2. Select Control Center >> Compatibility.
3. Set Create File to 9.5.
NOTE: If you don't set the Create Value parameter, Store Manager™ ES returns a Btrieve #24 error on transact.new when you try to convert the dataset.

After upgrading/installing Pervasive® PSQL™ v10 or greater on the Store Manager™ ES workstation, and prior to running Store Manager™ ES:
1. Open Pervasive PSQL >> Utilities >> Maintenance.
2. Click Options.
3. Select Show Information Editor.
4. Click Load Information.
5. Go to C:\Retailwise\Vertical\TDL.
6. Open sched.db.
7. Click Create File.
8. In the Create File window, click on the OK button. There are no records in this file, so the file is simply rebuilt.
9. Following the rebuild, click Load Information.
10. Go to C:\Retailwise\Vertical\TDL.
11. Open export.db.
12. In the Create File window, click OK. There are records in this file, so the file is simply rebuilt.
13. Go to C:\Retailwise\Vertical.
14.Open Log.db.
15.In the Create File window, click OK. There are no records in this file, so the file is simply rebuilt.
16.Go to c:\Retailwise\Vertical
17.Open LogClr.db
18.In the Create file windows, click OK. There are no records in this file, so the file is simply rebuilt.
19. Close Pervasive, open Store Manager™ ES and work as normal.
Note: If you do not perform this maintenance first, you will encounter an error on sched.db during your first daily close.

If the .db file format is incompatible or corrupt, you may receive a *Btrieve 46 error (access to file denied). This error could also affect any of the *.db files in the C:\Retailwise\Vertical folder.
Locate the file in Pervasive® PSQL™ by clicking Utilities >> Maintenance >> Options >> Show Information Editor.

A Store Manager™ ES Critical Error Example
In the example above, opening vend.db displays a file version of 3. The file is probably corrupt, since it was not converted when moved to PSQL 8.7.
RECOVERY:
Use BUTIL.EXE to recover records - the same as a file rebuild in AGRIS.
Note: You must recover, clone, and then load the database files.
Type the syntax for these commands from the DOS command prompt:
butil -recover <database file> <file.out>butil -clone <new database file.new> <original database file.db>butil -load <file.out (from recover)> <new database file.new>rename <original database file.db> <original database file.old>rename <new database file.new> <new database file.db>
You can use the same database file name, and just change the file extensions.
STRIPPING:
Use BUTIL.EXE to recover and remove records from files, or to strip the file. Carry out this procedure when you want to create an empty file.
Note: You must first clone the database files.
Type the syntax for these commands from the DOS command prompt:
butil -clone <new database file.new> <original database file.db>rename <original database file.db> <original database file.old>rename <new database file.new> <new database file.db>
You can also use the Rebuild option under Pervasive® PSQL™ to rebuild all the files to AGRIS V9.5 file format, or you can rebuild individual files through this utility, which provides a rebuild log.

Microsoft Operating Systems

Windows Server® 2012 R2, 2016, 2019

You cannot apply an Auto Update to a Windows Server 2012 R2, Windows Server 2016, nor Windows Server 2019 machine. All Service Pack installations must be carried out manually, while logged in as an Administrator.
1. Open Windows Explorer and locate the AGRIS 2021.31.0 setup.exe file on your network.
2. Right click the setup.exe file to display the option popup menu.
3. Click Run as Administrator to display the User Account Control window.


The User Account Control Window
4. Click Allow to install AGRIS on your workstation.

If you need to set up an ODBC connection for Junge® Automated Blenders in a 64-bit environment, you will need to open the ODBC setup via C:\Windows\SysWOW64\odbcad32.exe. The ODBC setup that opens through the Windows Control Panel (C:\Windows\System32\odbcad32.exe) has only one option (SQL Server).

Changing the color scheme from the Windows Server 2008 basic color scheme to either the Standard or Classic color scheme may cause some disabled AgroGuide fields to appear as though they are available.

Dataset Conversions

Start all conversions on the Database server.

The Database Conversion utility creates a log entry for the conversion of each package in the dataset.
When reviewing the conversion log (convert.log) following a dataset conversion, you may see old dates in the log entries. This occurs when you have converted a dataset for an earlier upgrade. The log appends any new conversion entries to the end of the existing log, which can result in the same file appearing in the conversion log multiple times, with different conversion dates.

On workstations where both AGRIS and Fuel Connect™ are installed, you must stop the Fuel Connect service before upgrading AGRIS.
To stop Fuel Connect, click Start >> (All) Programs >> AGRIS Fuel Connect >> Stop Fuel Connect Server.
Press any key to close the window once these services are stopped.

When transferring data between datasets using either the DTR process or Imports, ensure that both datasets are already converted to AGRIS 2021.31.0 before starting the transfer process.

When validating datasets prior to conversion, a File not Found or Package not Found entry may appear in the error log. While this does not prevent the conversion process from running, you may need to rebuild some dataset files following the conversion. If necessary, call the Technical Assistance Center (800-366-2474) for further assistance.

If you receive an Auto Blender Log cannot create session message, it indicates that an invalid login attempt occurred for an auto blender.
When a login attempt fails, the remaining auto blenders will fail to log on as indicated by the Trapped error 91 log entry. To correct, assign a valid AGRIS user to all Auto Blender controls. If necessary, call the Technical Assistance Center (800-366-2474) for further assistance.

AgroGuide Data Scrub: This conversion automatically corrects any Farm, Field, or Crop Zone codes that end with characters other than 0-9, a-z or A-Z.
NOTE: If you've already upgraded to AGRIS 2021.31.0, this correction has already been performed on your data.
A report (Report ID: URLDataScrub) appears in the Report Spooler and indicates if any corrections were made (described as "New Code").
This conversion does NOT correct any Name IDs (i.e. Clients) ending with characters other than 0-9, a-z, or A-Z, but displays any Name IDs ending with an invalid character.
Greenstone recommends that you correct any invalid characters at your earliest convenience, as these codes may impact integrations with other systems, including AgLogic.
Use the Change Name ID utility in AGRIS to change these Name ID codes.


Optimization Settings


There are three areas covered by the Optimization Settings:

  • Recommended Settings for Pervasive PSQL

Clicking Yes on the Optimization Settings prompt will apply the recommended settings for AGRIS for the Pervasive PSQL installation on the local machine. There are recommended settings for the Client, Server, and Workgroup installation types

...

Allow Cache Engine Connections - No
Create File Version - 9.5
Limit Segment Size to 2GB - No
Connection Timeout - 30
Communication Protocols - TCP/IP only
Use Cache Engine - No
Runtime Server Support - No


  • Server Message Block (SMB) set to version 1.

SMB is an operating system setting related to file access. By default, some of the operating systems supported by AGRIS have the SMB version set to version 2 or greater. AGRIS requires SMB version 1.
The Optimization Settings process will set the SMB setting to version 1 when the Pervasive Workgroup or Pervasive Server is installed. As it is a mandatory setting for AGRIS, it will be set to 1 for both Yes and No answers to the Optimization Settings prompt.

  • COM+ Error Reporting Enabled

The Optimization Settings process enables error reporting for COM+. It will be enabled for both Yes and No answers to the Optimization Settings prompt.

Warning Messages in Event Viewer


After installing AGRIS there may be a series of Warning messages in the Windows Event Viewer with a Source of Complus. These are expected warning messages and are not a cause for concern. See the example screenshot below:

Installation Log Files


The log files created by the AGRIS installation are located in the following folders. These log files are helpful for troubleshooting any problems that may occur during the installation process.

...

Click here to go back to the Technical Info page

Related Content

Page Tree
expandCollapseAlltrue
root@parent
searchBoxtrue

...