100-bp-ExecuteQuery

Standard Batch Process – Execute Query

General

The Execute Query batch process is distributed as a standard in Govern OpenForms. It is used to run an update query on the Govern database. You can select a query and run it on the fly or create a schedule to run the query at a later time or on a regular basis.
You can run only one query each time that you execute a batch process. However, you can create multiple schedules and associate a different query with each process and you can also create multiple batch processes of the same type (process name) and associate different reports, e-mails, and schedules with each one.

  • Process description: Execute Query
  • Process name: co_executequery

 

Specification

  • Update and Selection Queries can be executed
  • Queries are defined in Govern Administrator (GNA)
  • Selection queries will generate a CVS file with the query results
  • Update queries do not generate attachments
  • Refresh (F5) in Govern is needed for newly created queries

 

 

100-bp-ExecuteQuery

 

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

100-bp-Execution

Standard Batch Process – Execution & Connection

Version 6.0 and Version 6.1 (In Development)

Overview

The following explains the type and mode of batch executions.

Transaction Type

A Govern batch process can run synchronously or asynchronously.

Synch

In synchronous batch processing, transactions are processed one after another in a sequence.
If there are multiple steps in the process, one step is completed before the next begins.

Asynch

In asynchronous processing, multiple operations are started and run at the same time. As soon as one finishes, the next begins.
Multiple steps can run at the same time; for example, steps one, two, three, and four can all begin at the same time.
For long batch processes, using asynchronous batch processing can speed up the transaction time, because multiple computer operations or threads are processed at the same time compared to synchronous batch processing, where one operation has to finish before the next can begin.

IMPORTANT: If a batch process has multiple steps that need to be performed in order; for example, if the results of the first step are required for a calculation in the second step, use synchronous batch processing.

 

Connection Pool

You can define a Maximum Connection Pool Size for asynchronous batch processing in the addition to the general Connection Pool Size. You can also set a Connection time out for batch processes.
These parameters are defined on the Connection Key General Parameters Management form in GNA.

The Connection Pool is the number of connections that can be open on the server at the same time. Connections are required for the asynchronous batch processes. They are used by the threads to perform operations for batch processing. They are also required for all other Govern operations from all deployments in your organization.

The Connection Time Out refers to the length of time that a batch process executes a query before a time out occurs. The default is zero (0). This means that there is no time out.

Transaction Mode

Select one of the following transaction modes for the process.
Break If One Transaction Failed
The process terminates when the transaction fails.

Roll Back If One Transaction Failed
The process terminates when a transaction fails. All the transactions that were completed are cancelled. All the computations are returned to the starting point.

IMPORTANT: The roll back can take a long time to execute if the error occurred at the end of the process.

Continue If One Transaction Failed
The process continues to run even if a transaction fails.

 

 

100-bp-Execution

 

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

998-re-bp-117

New York State – Property Tax Freeze
Back to 900-Home … Module wiki Maps Standard Features | Accounts Receivable | Cash Collection | Real Property Tax | Mass Appraisal… Last modified Jan 31st 2016

Table of Contents

Batch Compute User Interface
Batch Processing (technical)
What’s New
Troubleshooting

VERSION 6.0 (under construction)
Specification Overview
Purpose
The purpose of this batch program …….

Identification

  • Process Name: NY_TAXFREEZE_EX – to verify
  • Requirement Number: 15979

Records to be processed:

  • Year selected: or all if none selected
  • Records (parcels) selected: all, saved named dataset (includes autosave dataset), jurisdiction, neighborhood
  • Record Frozen-id = zero (current)

Records to be calculated:

  • When the ……

Batch Processing:

  • The batch program can be scheduled to run periodically.
  • The transaction Mode “Roll Back If One Transaction Failed” is not supported. It will be “Continue If One Transaction Failed” by default
  • Refer to the Standard Batch Process details Batch Program Setup or Govern Scheduler for more details

Batch Compute User Interface

The following parameters and options are available:

Year :

  • All if no year is selected. The year field is user persistent and displays the year selected when the batch process was last run – to verify

Parcels to compute option:

  • All, or by Jurisdiction, Neighborhood or Saved Name Datasets – to verify

TIP: If you turn on the TREEVIEW Synchronization option (Govern’s Option menu), and select the AUTOSAVE from the Saved Datasets drop down table, the compute will processed all records in the user’s Dataset Treeview.

Batch Execution

The batch program can be executed on demand or scheduled with Govern Scheduler.

During the execution, warning and error messages will be presented in the batch result grid. – to verify

  • On error, the parcel id will be displayed in the message
  • Double-click on the message to access the full text

Once completed, information will be displayed, that includes:

  • Parameters and Options used
  • Total number of records read
  • Total number of records processed

Batch Processing (technical)

Before Executing Subprocesses:

  • Select all parcel ID and frozen ID related to the year (or all year if none selected) the jurisdiction, or the neighborhood or the saved dataset if chosen.

Execute Subprocess

  • For each batch process

Error Reporting
In addition to the standard Batch Processing standard error reporting, the following will be validated:

What’s New

[6.0] Batch program created for OpenForms

Troubleshooting

The following is to help troubleshoot the batch process.

  • After changes, it is always best to compute for a single year and small dataset
  • The parcel id is listed in the error message
  • Turning on the Govern Diagnostic Tool
  • Turning on the SQL Profiler Tool (system administrator)

See Also

The following information might be of interest

Batch Compute User Interface | Batch Processing (technical) | What’s New | Troubleshooting

998-re-bp-130

New York State – Nassau County – Paid/Unpaid [output]

Version 6.0 (In Development)

Specification Overview

Purpose

T/C

Identification

  • Process Name: NY_NASSAU_CNTY – to verify
  • Requirement Number: not on roadmap

Records to be processed:

  • Year selected: or all if none selected
  • Records (parcels) selected: all, saved named dataset (includes autosave dataset), jurisdiction, neighborhood
  • Record Frozen-id = zero (current)

Records to be calculated:

Batch Processing:

  • The batch program can be scheduled to run periodically.
  • The transaction Mode “Roll Back If One Transaction Failed” is not supported. It will be “Continue If One Transaction Failed” by default
  • Refer to the Standard Batch Process details Batch Program Setup or Govern Scheduler for more details

Batch Compute User Interface

The following parameters and options are available:

Year :

  • All if no year is selected. The year field is user persistent and displays the year selected when the batch process was last run – to verify

Parcels to compute option:

  • All, or by Jurisdiction, Neighborhood or Saved Name Datasets – to verify
TIP: If you turn on the TREEVIEW Synchronization option (Govern’s Option menu), and select the AUTOSAVE from the Saved Datasets drop down table, the compute will processed all records in the user’s Dataset Treeview.

Batch Execution

The batch program can be executed on demand or scheduled with Govern Scheduler.

During the execution, warning and error messages will be presented in the batch result grid. – to verify

  • On error, the parcel id will be displayed in the message
  • Double-click on the message to access the full text

Once completed, information will be displayed, that includes:

  • Parameters and Options used
  • Total number of records read
  • Total number of records processed

Batch Processing (technical)

Before Executing Subprocesses:

  • Select all parcel ID and frozen ID related to the year (or all year if none selected) the jurisdiction, or the neighborhood or the saved dataset if chosen.

Execute Subprocess

  • For each batch process

Error Reporting
In addition to the standard Batch Processing standard error reporting, the following will be validated:

What’s New

[6.0] Batch program created for OpenForms

Troubleshooting

The following is to help troubleshoot the batch process.

  • After changes, it is always best to compute for a single year and small dataset
  • The parcel id is listed in the error message
  • Turning on the Govern Diagnostic Tool
  • Turning on the SQL Profiler Tool (system administrator)

See Also

The following information might be of interest

 

 

998-re-bp-130

 

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

903-ken

903-ken #900999 #client

Kenai Peninsula Alaska Custom Page (KEN)
Overview | Self Reported Tax (Custom)

Overview

The Kenai Peninsula Borough was incorporated in 1964 as a second-class borough under the authority of the State of Alaska Borough Act of 1961. The Borough’s governmental responsibilities are comparable to those of a county. The five first-class and home-rule cities in the borough are Kenai, Soldotna, Homer, Seldovia, and Seward. Other locally governed communities include Kachemak City and the native villages of Tyonek, Port Graham, and Nanwalek.
Customer web site ….

Self Reported Tax (Custom)

Standard Features (fea)

Batch Programs (bp)

Code Module Type no sub_type custcode vers Standard_name
903 st bp 001 ken 6.0 ST Intialize Missing Filers (Kenai)
903 st bp 002 ken 6.0 ST Update Missing Filers (Kenai)
903 st bp 003 ken 6.0 ST Binary Interface (Kenai)
903 st bp 004 ken 6.0 ST Remove Delinquency Flag (Kenai)
903 gl bp 312 ken 6.0 GL Interface Export to GEMS
903 pc bp 203 ken 6.0 PC Gis Import

998-re-bp-114

New York State – Generate Real Property Tax – Assessment Role
Back to 900-Home … Module wiki Maps Standard Features | Accounts Receivable | Cash Collection | Real Property Tax | Mass Appraisal… Last modified Jan 31st 2016

Table of Contents

Batch Compute User Interface
Batch Processing (technical)
What’s New
Troubleshooting

VERSION 6.0 (under construction)
Specification Overview
Purpose
The purpose of this batch program …….

Identification

  • Process Name: NY_ASMT_ROLE – to verify
  • Requirement Number: 15897

Records to be processed:

  • Year selected: or all if none selected
  • Records (parcels) selected: all, saved named dataset (includes autosave dataset), jurisdiction, neighborhood
  • Record Frozen-id = zero (current)

Records to be calculated:

  • When the ……

Batch Processing:

  • The batch program can be scheduled to run periodically.
  • The transaction Mode “Roll Back If One Transaction Failed” is not supported. It will be “Continue If One Transaction Failed” by default
  • Refer to the Standard Batch Process details Batch Program Setup or Govern Scheduler for more details

Batch Compute User Interface

The following parameters and options are available:

Year :

  • All if no year is selected. The year field is user persistent and displays the year selected when the batch process was last run – to verify

Parcels to compute option:

  • All, or by Jurisdiction, Neighborhood or Saved Name Datasets – to verify

TIP: If you turn on the TREEVIEW Synchronization option (Govern’s Option menu), and select the AUTOSAVE from the Saved Datasets drop down table, the compute will processed all records in the user’s Dataset Treeview.

Batch Execution

The batch program can be executed on demand or scheduled with Govern Scheduler.

During the execution, warning and error messages will be presented in the batch result grid. – to verify

  • On error, the parcel id will be displayed in the message
  • Double-click on the message to access the full text

Once completed, information will be displayed, that includes:

  • Parameters and Options used
  • Total number of records read
  • Total number of records processed

Batch Processing (technical)

Before Executing Subprocesses:

  • Select all parcel ID and frozen ID related to the year (or all year if none selected) the jurisdiction, or the neighborhood or the saved dataset if chosen.

Execute Subprocess

  • For each batch process

Error Reporting
In addition to the standard Batch Processing standard error reporting, the following will be validated:

What’s New

[6.0] Batch program created for OpenForms

Troubleshooting

The following is to help troubleshoot the batch process.

  • After changes, it is always best to compute for a single year and small dataset
  • The parcel id is listed in the error message
  • Turning on the Govern Diagnostic Tool
  • Turning on the SQL Profiler Tool (system administrator)

See Also

The following information might be of interest

Batch Compute User Interface | Batch Processing (technical) | What’s New | Troubleshooting