It can also be found in the CINCH 18.57 Release folder on the Greenstone FTP site.

(Microsoft Dynamics GP >> Maintenance >> CINCH Maintenance >> Table Utility)

WARNINGS:

·         You must be logged in as “sa” or “DYNSA” to open the Table Utility window.

·         The table update process is a SINGLE USER situation. Do NOT allow one user to update one company while another user attempts to update another company. During the table update process existing data is copied from the company database to a tempdb database. If two users try to update the same tempdb at the same time the update WILL error.

Note: The system looks to the Dynamics.set file for which product to display. CinchAg indicates CINCH and IRDCustom indicates CINCH.

a.       Initially defaults NA (Not Applicable) but will default to the previously installed version the next time the system is updated.

Notes:

·         Starting with release 18.57, the system will record the installed version within the IRGNMainSETP table in the IRVersion field.

·         Upon upgrade, the un-chunking process will move the installed version within the IRGNMainSETP table’s IRVersion field to the IRVersionPrev field. It is the IRVersionPrev value that will default into the Upgrade From field.

 WARNING: Manually deleting, renaming, or restoring the CINCH/Intellego dictionary will not update the IRGNMainSETP file.

 b.       Drop-down will display versions starting with 18.56.  The version is based on the initial release of the version which is released each December.

c.        The expansion arrow, when pressed, will select all the tables changed or created between the Update From version and the version being installed. These tables will then be displayed in the Select Tables window.

Note: The tables to be updated are currently hard coded within the software and include both the System and Project File Series tables.

a.       Product CINCH/Intellego and Files Series Project defaults all CINCH/Intellego tables within the Company database.

b.       Product CINCH/Intellego and Files Series System default all CINCH/Intellego tables within the Dynamics database.

WARNING:  The system will not stop or warn a user from adding an additional table or removing a selected upgrade table.

a.       If upgrading only one version, follow the backfill instructions indicated within the installation guide.

b.       If upgrading multiple versions, run the backfill scripts manually for each version.

a.       Create CINCH/Intellego Jobs (No Changes)

b.       Create Tables (No Changes)

c.        Update Indexes – (No Changes)

Note: Indexes are automatically updated upon closing the Table Utility window if the compare button has been clicked before closing the window.

The following seven SQL scripts have been combined into one script called SQLCompanyCINCHR1857.sql.

WARNING:  The SQL command “exec IRCSBindDefAll” included in the SQLCompanyCINCHR1857.sql could take up to 15 minutes to complete and is the same process that runs when using the Bind Defaults window (Microsoft Dynamics GP >> Maintenance >> CINCH Maintenance >> Bind Defaults.)