100-Installation-FromScratch

Govern Installation from Scratch

Version 6.0 | Version 6.1

Overview

This section covers the steps and the best practices when installing 6.0 from scratch.
For upgrades or updates see 100-Upgrade where you will find tools, tips and training material to help with the upgrade.
Return to the Main Installation page 100-Install

Before Getting Started
Database Server (optional)

  • Install and/or start MS SQL SERVER 2014
  • Create Database / Restore Databases for upgrades
  • Roles and Security

Step by Step

OpenForms Initial Installation from a blank database.

  1. Create Govern Database(s) – make sure to add Govern as the owner of the database
  2. Install DeployEZ
  3. Create Deployment and Connexion key (note you will need to supply a Serial Number License Key)
  4. Install GNA
  5. GNA Run Database Verification (twice – first time prepares what it needs)
  6. GNA Set Organization parameters & SY REGISTRY, Create department, Create new sysadmin user
  7. GNA Import (EMT) System Queries & Tables (DynamicSearch.xml) and basic forms (FormReference.xml)
  8. GNA Create a report
  9. GNA Create a batch process
  10. GNA Create a profile
    • Set Forms, Batch programs, A/R allowed, Reports…
  11. GSM Create Roles
  12. GSM Synchronize
  13. GSM Setup Access rights (Apps, menu, profile)
  14. In SQL, make sure to enter 0 or 1 in USR_KEY_MASTER (until 1504)

See Also
100-Standards
100-Technical Requirements

 

100-Installation-FromScratch

 

0 votes, average: 0.00 out of 50 votes, average: 0.00 out of 50 votes, average: 0.00 out of 50 votes, average: 0.00 out of 50 votes, average: 0.00 out of 5 (0 votes, average: 0.00 out of 5)
You need to be a registered member to rate this.Loading...

 

Govern for Windows Installation

Govern for Windows Installation

For use with OpenForms version 6.0

How to install

Download Govern for Windows full installation pack for 10.8

NOTE: Contact Govern Support for the address to download installation packs

Steps to Upgrade

Upgrade to the Latest Version of 10.8

The following are the steps to upgrade your database to the latest version of Govern for Windows Release 10.8.

  1. Copy the Govern for Windows Full pack 10.8 to File server; ensure that you also obtain the latest version of the Govern for Windows 10.8 Reference Database.
  2. Create the following folders
    • Bin
    • Bitmap
    • Documentation
    • Help
    • Install32_108
    • StandardReports
    • CustomReports
    • Scripts
  3. Unzip the packages in the download files.
  4. Create an ODBC connection to the database. (Use the the 32 bit ODBC Data Source Administrator)
  5. Configure a .INI file with your organization name and serial number obtained from Harris Govern Technical Support.
  6. Run Govern for Windows Updata Release 10.8.
  7. In Updata, create an MS Access attach table.
  8. Verify that you are using the latest version of the reference database, then run the Upgrade process.

At the end of the upgrade process, your database will have been updated to the latest version of Release 10.8; you may now proceed to the next step of upgrading to Govern V6.0.

Going from Version 10.8 to Govern V6.0

Having successfully completed the upgrade to the latest version of the Govern for Windows 10.8 database, You now need to create a deployment of the latest Govern V6.0 applications. The steps to upgrade to V6.0 are as follows:

  1. Created a V6.0 deployment with DeployEZ; during the deployment you will create the Connection Key to the Database.
  2. Install the Govern New Administration (GNA) V6.0.
  3. Allow GNA to perform its Pre-Upgrade Check.
  4. Restart GNA and run the Database Verification.
  5. Correct any database errors that GNA finds.
  6. Run the Database Verification process again.

After this process, you database will have been upgraded to V6.0. The following is a link to a more detailed description of the upgrade process.
Click 100-upgrade-GFW_to_OF.pdf for the document.

 

 

700-Install

 

0 votes, average: 0.00 out of 50 votes, average: 0.00 out of 50 votes, average: 0.00 out of 50 votes, average: 0.00 out of 50 votes, average: 0.00 out of 5 (0 votes, average: 0.00 out of 5)
You need to be a registered member to rate this.Loading...

 

AR – Installation

Accounts Receivable Installation

Overview

The Govern OpenForms applications required for Accounts Receivable are installed through Govern Deploy EZ, See Deploy EZ.

 

 

101-ar-install

 

0 votes, average: 0.00 out of 50 votes, average: 0.00 out of 50 votes, average: 0.00 out of 50 votes, average: 0.00 out of 50 votes, average: 0.00 out of 5 (0 votes, average: 0.00 out of 5)
You need to be a registered member to rate this.Loading...

Govern Installation

Govern Installation

Overview

This page contains links to installation and setup resources, and documentation.

Setup

Database and Connections

  • Install MS SQL SERVER (399-Installation)
  • Create Databases and Connections (ODBC)
  • Execute Admin One-Time Script Execution
    • As of 6.0, a one-time script needs to be executed by a DB SYS ADMIN to setup a Table Change Event required by the application. The first time a Verify Database is run, the script will be executed.
      • If the Govern user does not have the required access, an error will be displayed and it will be MANDATORY to have the Database Administrator (DBA) executed it manually.
      • Click here to access the CreateCleanupJobForRecentTableChanges script commands that can be copy and pasted in a MS SQL SERVER Query windows

Deployment Server

Deployment Client

Configuration

API/Services

  • Batch Scheduler Service (106-installation) see also (106-all-sc)
  • AR / CC Web Service
  • PC / GIS Web Service
  • eGov Web Service

System Options

  • Mobile Installation
  • e-Government Installation
  • GIS

3rd Party Tools

  • For testing email notifications SMTP4Dev

Other Systems

Upgrades

From Govern for Windows 10.8

From a Previous Version of OpenForms

Troubleshooting

Cannot Start Application Error

Application cannot be started. Contact the application vendor. If you are having problems to open the shortcuts directly from the server you need to delete the folder [2.0] under the path below. C:Usersuser_idAppDataLocalApps. 100-Installation-ShortcutError.pdf Users do not have access to Govern Security Manager Only users setup as Administrator or Super User in the User definition table can access GSM. (USR_USERFILE)     100-Installation   0 votes, average: 0.00 out of 50 votes, average: 0.00 out of 50 votes, average: 0.00 out of 50 votes, average: 0.00 out of 50 votes, average: 0.00 out of 5 (0 votes, average: 0.00 out of 5)
You need to be a registered member to rate this.Loading...

eGov – eGovernment Installation

eGovernment (eGov) – Installation

Overview

The following is intended for initial installation and web site configuration.

System Requirements

Minimum System Requirements depends on the Govern Suite and major release version. See System Requirements.

Installation Steps

Read More...

Service Installation

Deployment of Installation pack

Server Configuration

(Simplified Steps)
For server configuration, refer to the complete configuration steps in the user guide below.

  1. Installation of IIS and Framework 4.6
    NOTE: Although efforts have been made to ensure that IIS will run correctly, due to the diversity of versions, additional steps, and changes in the sequence of steps may be required to ensure correct functioning.
  2. Installation of AJAX Extensions
  3. Installation of Crystal Report Runtime
  4. Installation of Oracle Client (Optional)
  5. Verify that GovWin 10.7, or greater is installed
  6. Database Preparation
  7. Install DeployEZ
    OR
  8. Install GNA, Database Preparation, and Resource files
  9. Verify Presence of Key Folders
  10. Launch GNA
  11. Perform Complete Database Reset
  12. Creation of Required Directories
  13. Obtain and Extract Web User Interface File
  14. Create Application Pools
  15. Create Web site (Optional)
  16. Convert the eGov Folder to an Application
  17. Create a Virtual Directory (Optional for Crystal Report Viewer)
  18. Create a Directory for Multimedia Documents (Optional Virtual Directory)
  19. Set ASP.NET Version to 4 (for IIS 6.1 or earlier)

Web site Configuration (Simplified Steps)

  1. Create a Webskin
  2. Configure your Dynamic Web Search
  3. Configure your Web site
  4. Use Web Config Editor
  5. Set up Web eProfile Parameters
  6. Design and Create your Menus
  7. Set up Private Names & Addresses (As Required)
  8. Configure ePayment Parameters (As Required)
  9. Configure ePermits (As Required)
  10. Configure Fields that are viewable on Web (As Required)
  11. Configure eRenewal Activity Steps (As Required)
  12. Configure eRemittance Web Layout (As Required)

 

Testing and Troubleshooting

Read More...

Development Testing – Direct Report Viewer

(Release 6.1.1506)
For development testing, this is a direct link to the e-Government eportal (no credentials or login are required). The link will show the report without any interaction by the user. The name of the report and the parameters and parameters names are passed through the URL that is entered.
Details of parameter:

  • REPORTNAME – This is the report file name without a file extension. The folder where the report is placed inside the configured in the web.config file. The parameter used is the same one used for all reports. The configuration string is a follows:
  • <add key=”GovernSoftware.WebReportDirectoryPath” value=”C:inetpubwwwrootDEMO_REPORTSSHN” />

Where…

  • reporttitle = This is the report title that is displayed in the middle of the report viewer screen.
  • pn1 = parameter Name
  • pv1 = parameter value

 

Installation Best Practices

Using Private Names by Departments
In Development – For organizations using private names by departments, it can be a challenge to set-up the web user that can navigate and access the different features.
It is recommended to create a username password instead of using public access via the email address.
Multiple web sites should be considered for additional control.
Please contact R&D for more information.

Documentation

Click to view the .PDF draft version of the eGovern Guide to Deployment on Windows Server 2016.

See Also

  • eGovern – Administration – Configuration of the eGovern – Public Self Service Portal is carried out with the Govern New Administration (GNA) Release 6.0 and Govern Admin 10.7 in Govern for Windows. Click to view eGovern specific menus and parameters in GNA.
  • Schemas – The following link is to a schema of the suggested network configuration for the eGovernment Public Web Portal. eGovNetwkCfg61x_Rev01.pdf

 

 

201-all-egov-install

 

0 votes, average: 0.00 out of 50 votes, average: 0.00 out of 50 votes, average: 0.00 out of 50 votes, average: 0.00 out of 50 votes, average: 0.00 out of 5 (0 votes, average: 0.00 out of 5)
You need to be a registered member to rate this.Loading...

Installation Scripts

Installation Scripts

Overview

The following is a list of scripts designed to be executed in MS SQL SERVER.
Intended for Administrators.

Table Change Event Script

Script Name: CreateCleanupJobForRecentTableChanges
Version 6.0 and Version 6.1
System Administrator Rights are needed
Will be launched during the Verify Database Process. An error will be displayed if the user does not have SysAdmin rights in SQL Server.

Read More...

Script Name: CreateCleanupJobForRecentTableChanges:
IF EXISTS (SELECT job_id
FROM msdb.dbo.sysjobs_view
WHERE name = N’GV_CLEANUP_RECENT_TBL_CHANGES’)
EXEC msdb.dbo.sp_delete_job @job_name=N’GV_CLEANUP_RECENT_TBL_CHANGES’; DECLARE @dbName as sysname;

DECLARE @jobName as varchar(100);
DECLARE @scheduleName as varchar(100);
SET @dbName = db_name();
SET @jobName = N’GV_CLEANUP_RECENT_TBL_CHANGES_’ + @dbName;
SET @scheduleName = N’GV_CLEANUP_RECENT_TBL_CHANGES_EVERY_HOUR_’ + @dbName;

IF EXISTS (SELECT job_id
FROM msdb.dbo.sysjobs_view
WHERE name = @jobName)
EXEC msdb.dbo.sp_delete_job @job_name = @jobName;

EXEC msdb.dbo.sp_add_job
@job_name = @jobName,
@description = N’Govern job to cleanup the table USR_RECENT_TBL_CHANGE.’ ;

EXEC msdb.dbo.sp_add_jobstep
@job_name = @jobName,
@step_name = N’Delete records older than 1 hour.’,
@database_name = @dbName,
@command = N’DELETE FROM usr_recent_tbl_change WHERE change_date < GETDATE() – (1.0/24)’;

EXEC msdb.dbo.sp_add_schedule
@schedule_name = @scheduleName,
@freq_interval = 1,
@freq_type = 4,
@freq_subday_type = 8,
@freq_subday_interval = 1;

EXEC msdb.dbo.sp_attach_schedule
@job_name = @jobName,
@schedule_name = @scheduleName;

EXEC msdb.dbo.sp_add_jobserver
@job_name = @jobName;

 

 

100-Installation-Scripts

 

0 votes, average: 0.00 out of 50 votes, average: 0.00 out of 50 votes, average: 0.00 out of 50 votes, average: 0.00 out of 50 votes, average: 0.00 out of 5 (0 votes, average: 0.00 out of 5)
You need to be a registered member to rate this.Loading...

WM – Installation Queries

Workflow Management Installation Queries

Version 6.1 (In Development)

Overview

This page is intended for System Administrators, Business Analysts and Technical Service.
The following queries are used in OpenForms when installing or configuring the Workflow Management module.

System Queries for Workflow Management

For the complete list, see 101-wm-install-queries …

Navigation

The queries and views used to set up the workflow eSearch and the Tree Views.

  • Search Group, Styles, Objects
  • Tree Views

Workflow Form Link Types

Controller used to create workflow links to names (applicants, contacts, names, etc.) and other references (parcels, buildings, other workflow, etc.)
For examples of queries, click here (101-wm-install-queries-linktypes)
Suggested list results

Workflow View Query

Can be used on a form Tab, link, action button or on the Profile Cool Bar. This query needs to be customized in order to change its presentation in Govern.

 

 

101-wm-install-queries

 

0 votes, average: 0.00 out of 50 votes, average: 0.00 out of 50 votes, average: 0.00 out of 50 votes, average: 0.00 out of 50 votes, average: 0.00 out of 5 (0 votes, average: 0.00 out of 5)
You need to be a registered member to rate this.Loading...