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

703-all-batch

703-all-batch #GovernforWindows #system

Govern for Windows – BATCH (DAEMON)

Overview | Manuals | Frequently Asked Questions | Technical Information

Overview

Manuals

Click on the release number to access the Super User (and Batch) pdf manual.
[v10.7]

Frequently Asked Questions

FAQ

GovBatch Daemon Processing

Question: From a technical perspective what prevent the same record in usr_daemon_online from being picked up by more than 1 daemon while it is being processed? I understand usr_daemon batch with the ctrl record but not individually? This is a question that Winnipeg asked.
Answer: (to validate) It must be the processed flag that is set at the beginning of the transaction.
Note: There is also other logic and rules the daemon needs to follow:

  • Smaller year first in multiyear
  • Children first in Parcel Linking

Administrator note: wiki page = 703-faq / Page Embedded Faq=Title 2

Technical Information

998-ny-map

New York State – Product Map

The following includes special state of New York processes and interfaces for Suffolk and Nassau County.

Product Codes

Section Status Product Code/ Wiki Page Description Requirement Process Name Technical Info Quality Assurance Developers
Accounts Receivable Accounts Receivable
Over and Short Feature
Batch Process New York State
Requirement 998-re-bp-113 NY – Generate Real Property Tax – ARLM 1 & 2 Reports 15890 NY_ARLM1_2 998-re-bp-113
Requirement 998-re-bp-114 NY – Generate Real Property Tax – Assessment Role 15897 NY_ASSMTROLE 998-re-bp-114
Roadmap 998-re-bp-115 NY – Generate Real Property Tax – Tax Role 15898 NY_TAXROLE 998-re-bp-115
Roadmap 998-re-bp-116 NY – Generate Real Property Tax – RPS File 15901 NY_RPS 998-re-bp-116
Roadmap 998-re-bp-117 NY – Generate Real Property Tax – Property Tax Freeze Export File 15979 NY_TAX_FREEZE_EX 998-re-bp-117
Suffolk County
Requirement 998-re-bp-112 NY – Suffolk County – Real Property Tax Extract 15886 NY_SUFFOLK_EX 998-re-bp-112 (DEV) 998-re-bp-112
Requirement 998-re-bp-110 NY – Suffolk County – Load Arrears File to County 15899 NY_SUFFOLK_ARR 998-re-bp-110
Roadmap 998-re-bp-111 NY – Suffolk County – Load Payments From County 15900 NY_SUFFOLK_PAY 998-re-bp-111
Nassau County
Not on Roadmap 998-re-bp-130 NY – Nassau County – Return (Paid/Unpaid) [Output] ? NY_NASSAU_CNTY

 

 

998-ny-map

 

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

703-faq

Frequently Asked Questions (FAQ)

GovBatch Daemon Processing

Question

From a technical perspective what prevent the same record in usr_daemon_online from being picked up by more than 1 daemon while it is being processed? I understand usr_daemon batch with the ctrl record but not individually? This is a question that Winnipeg asked.

Answer

(to validate) It must be the processed flag that is set at the beginning of the transaction.
Note: There is also other logic and rules the daemon needs to follow:

  • Smaller year first in multiyear
  • Children first in Parcel Linking