Versions Compared

Key

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

← Back to Technical Info page

...

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 21.1.0 software. Also use these instructions to upgrade AGRIS System Version 9.5.0 to this new version.
For information regarding running AGRIS on Microsoft SQL Server, please refer to the documentation here: AGRIS on Microsoft SQL Server

...

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.

SW-Database Engine

Actian ZEN v14™ SP1 Update 2 (Build 14.11.023)

Actian® Zen™ v14 SP1 (Build 14.10.035)

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.

...

      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.

...

Install components in the following order:


AGRIS

...

21.

...

1.0 Server Installation


This section describes how to install the AGRIS System Version 21.1.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:

...

  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.

...

  • 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.

...

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.

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

...

21.

...

1.0

  • Launch AGRIS 21.1.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.

...

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 21.1.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.

...

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.

...

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.

...

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.

...