Opswise Automation Center Controller 5.1.1 Maintenance

Opswise Automation Center Controller 5.1.1 Maintenance

Introduction

Stonebranch provides product maintenance in the form of updated product installation packages. This document lists the product installation package maintenance history for Opswise Automation Center Controller 5.1.1.

Note

You only can install a maintenance package to a product installation of the same version, release, and modification levels (see #Versioning, below). For example, you can install a 5.1.1.10 maintenance package to a 5.1.1.x installation, but you cannot install a 5.1.1.10 maintenance package to a 5.1.0.x installation.

Product Packaging

A package maintenance level is incremented when the package changes or the package installation changes.

Stonebranch changes product version, release, or modification identifiers at its discretion when it deems an appropriate number of enhancements or capabilities have been introduced to warrant the change.

Versioning

Package version numbers are comprised of four numeric identifiers: version, release, modification level, and maintenance level.

For example, for Opswise Automation Center Controller 5.1.1.10:

  • 5 = Version 5

  • 1 = Release 1

  • 1 = Modification Level 1

  • 0 = Maintenance Level 10

Packaging Methods

The Opswise Automation Center Controller 5.1.1 packages are provided in formats appropriate for the target platforms.

See Installation, Upgrade, and Applying Maintenance for information on installing, upgrading, and applying maintenance to the Opswise Controller.


Package Maintenance Levels

This section identifies the changes included in Opswise Automation Center Controller 5.1.1.

Release 5.1.1.11 - December 6, 2013

Change ID

Description

Change ID

Description

B-04026

Optimize triggers using complex restriction with Custom Day noun/qualifier.

B-04028

Optimize skipping operation when most task instances are skipped by run criteria at trigger time.

B-04031

Add Maximum Timer Threads property for controlling the maximum size of the timer service thread pool.

D-04112

Some task instance statuses experience delays in changing.

D-04114

View Instances list/pop-up window has incorrect sort direction on Create column.

D-04115

"Average Estimated End Time" not recalculated when failed task instance re-started by Re-run command.

D-04130

Performance issues on AIX in communications with the Message Hub.

Release 5.1.1.10 - October 29, 2013

Change ID

Description

Change ID

Description

B-03163

Add support for enabling trigger forecast simulation at the individual trigger level.

B-03719

Always send default "Start Line" value of 1 if not specified for output retrieval parameters.

B-03730

Add "Description" field to action base table (currently only on variable action extension table) so that it is a common field for all actions.

B-03773

Utilize new System Notifications feature to notify administrator(s) of current/upcoming License violations.

B-03789

Add administrator command, Reset Virtual Resource, to reset the "Resource Used" amount of a selected virtual resource.

B-03791

Add server-generated "Type Details" column on the Actions List screen for System Operations and Set Variables actions.

B-03793

Add a friendly display column for Parameters on z/OS task lists and for Environment Variables on Windows and Linux task lists.

B-03810

Add build # to the cluster node to be consistent with Overview widget data.

B-03811

Reset "failed_attempts" count when the Lock Account After Maximum Failed Login Attempts Opswise system property is enabled.

B-03814

Add delay to post-node database reconnect to allow the Active cluster node to continue as active.

B-03815

Log when forecast generation starts and ends.

B-03822

Add purge_versions_exceeding_maximum.js maintenance script for trimming versions in excess of a configured maximum.

B-03823

Add automated version purging configuration.

B-03828

Reduce database locking where possible to minimize database deadlocks.

B-03829

Limit number of items per 'tab' pag to 20 instead of using the 'items per page' configuration in order to improve performance when opening task form.

B-03864

Add support for Every to the Relative Repeating Date type of Custom Day.

B-03868

Enhance the database password option with additional encryption capabilities.

B-03885

Optimize All Triggers, All Tasks, and Task Instances lists to avoid additional fetches on extension table records.

B-03886

For new Opswise deployments, initialize the Maximize Activity Table Width Opswise system property to "true".

B-03891

Add the gc_and_clear_cache.js maintenance script to clear out the controller LRU caches.

D-02806

Opening a task definition screen for a task with a large number of instances can be very slow; therefore, provide View Instances button/menu options for viewing the task's instances on demand.

D-03345

Not all task types set the "End Time" for a Failed status.

D-03376

List reports generate bad filter criteria under certain conditions.

D-03858

Displayed Cancel command not functioning for a SQL Stored Procedure task instance.

D-03868

MySQL queries (without predicate) on the Activity table for users with permissions granted by Business Services can be slow.

D-03969

Add 'SQLCode: 8642' to the Controller transient database exception mapper for SQL Server.

D-03973

Prohibit the deletion of a user that is referenced by enabled trigger field, 'ops_trigger.enabled_by', or by active task instance field, 'ops_exec.execution_user'.

D-03994

Time Triggers and Triggers with Special Restrictions not using Trigger time zone when calculating holidays.

D-04006

java.lang.NullPointerException during undeployment flooded in catalina log.

D-04008

Updating multiple Time Triggers fails because irrelevant "Day Style" sub-options remain enabled in persisted record.

D-04009

"View selected item" for a task with '#' character in name from a trigger screen displays blank/incorrect workflow.

D-04011

"Failed" task instances with Hold Resources on Failure that are purged by a Data Backup/Purge operation do not properly return their acquired virtual resources.

D-04023

"*** WARNING *** "VARNAME" is not defined." is logged if Show Details is used for task instance with variable in name.

D-04061

Completed workflow instance containing zero tasks did not remove its exclusive orders causing another task instance to remain in Execution Wait status.

D-04075

Re-run of "Failed" task instance with Late Finish specified by Duration creates new Timer and leaves old Timer behind in the database.

Release 5.1.1.9 - August 9, 2013

Change ID

Description

Change ID

Description

D-03939

Reporting not handling date/time hour queries properly when in DST.

D-03946

"Update Virtual Resource Limit" Web Service / CLI command generates a virtual resource version even if limit unchanged.

D-03958

Bundle-less promotio does not properly map agents when promoting an agent cluster.

D-03960

Modifying a workflow graph should not create a version of the workflow task if Automatically Create Versions is set to false.

D-03962

Updating non-Schedule fields on an enabled Data Backup/Purge causes the Data Backup/Purge to be disabled.

D-03965

Web Service / CLI login fails if value of user column "pw_last_changed" is NULL when using MySQL database.

Release 5.1.1.8 - August 6, 2013

Change ID

Description

Change ID

Description

B-02908

Support variables in Database Connection field on SQL Task and Stored Procedure Task screens.

B-03265

Add support for GLOBAL variable scope to Set Variable action.

B-03529

Add new System Operation action for Set Virtual Resource Limit operation.

B-03724

Preserve coordinates in workflow graph when exiting/re-entering workflow editor/monitor, etc.

B-03749

Add the running File Monitor Status field to the File Trigger list.

B-03755

Add support for password expiration for Controller user credentials.

B-03756

Add support for Controller user accounts to be locked out after N failed login attempts.

B-03760

Create a RESTful Web Service API for listing variables.

B-03767

Add new System Operation action for Agent/Agent Cluster operations.

B-03783

Add User options for restricting a user from using Web Interface (Web Browser), Command Line Interface, or Web Service.

D-03818

Date Adjustment (Less/Plus) should not be evaluated if Day Style is not Complex.

D-03832

Activity refresh can perform unnecessary database fetches.

D-03835

java.lang.NullPointerException occurs when running the inspect_persisted_events.js maintenance script.

D-03850

STDERR not attached to email if only STDERR is selected as an attachment option.

D-03876

Non-admin users cannot see Parameters for Stored Procedure Task Instances.

D-03878

Data Backup/Purge can delete Actions for promoted Tasks.

Release 5.1.1.7 - May 20, 2013

Change ID

Description

Change ID

Description

B-02935

Limit number of tasks running per agent cluster.

B-03078

Limit number of tasks running per agent.

B-03079

Suspend/Resume agents, agent clusters, and agent cluster memberships.

B-03438

Add "Stable Period" type of criteria to FTP File Monitor task.

B-03493

Add ability to override Opswise system properties.

B-03523

Add built-in Mathematical functions.

B-03586

Add verbose user login/session logging option for diagnosis.

B-03633

Add ${ops_jcl_location} and ${ops_job_id} built-in variables for z/OS task instances.

B-03636

Increase environment variable column from 1000 to 4000 characters for Linux/Unix tasks and Windows tasks.

B-03638

Add "Progress" (wf_progress) column to ops_exec table to indicate the workflow progress in terms of number of completed (success/finished/skipped) tasks.

B-03658

Add optional row separator parameter on SQL resultsAll / resultsAllFromTask functions to override default new line character.

D-02389

Updating workflow skip/run criteria brings you back to workflow List.

D-03327

List export of gauges not exporting related gauge count records.

D-03651

Calculation of statistics for start time offset within workflow can result in Arithmetic overflow database exception.

D-03652

Activity purge can be very slow.

D-03653

Task Monitor still enforcing hidden From / To time scope values even though time scope changed to none.

D-03664

Add var<function-name> equivalent string manipulation functions that take a variable name instead of value to allow for handling "\" escape character in string arguments.

D-03704

User abruptly logged out when per-domain cookie limit reached using Internet Explorer.

D-03778

FTP File Monitors that are Running when an Agent is restarted can remain Running indefinitely.

Release 5.1.1.6 - March 12, 2013

Change ID

Description

Change ID

Description

B-02787

Add support for Opswise variables in Script Library script content.

B-03567

Add Expose Resolved Script Opswise system property to allow for generating SCRIPT output type for task instances using Script Library scripts with the Resolve Opswise Variables option.

D-03360

Variable name is lost in the "Copy of <task-name>" when performing copy operation from form.

D-03631

After 1000 failed database connection attempts, Controller will stop attempting to connect to the database.

Release 5.1.1.5 - February 25, 2013

Change ID

Description

Change ID

Description

B-03455

Add built-in variable, ops_task_ref_count, for task instances.

B-03456

Add built-in variable, ops_attempt, for task instances.

B-03359

Add built-in variables, ops_trigger_time and ops_launch_time, for task instances.

B-03477

Add built-in variable, ops_sql_rows, for row count to SQL/Stored Procedure task instances.

B-03491

Add system/node time to Home Page Overview.

B-03505

Add Opswise property, Maximize Activity Table Width, to allow maximizing the Activity table width.

B-03510

Improve usability of creating connections (task dependencies) in workflow editor with Internet Explorer.

B-03522

Add system/node paused indication to Home Page Overview.

D-03216

Updating a Calendar / Custom Day does not recalculate the next scheduled time on enabled Triggers.

D-03447

"contains" filter option missing for Script Content field.

D-03450

While performing a Data Backup/Purge operation, Controller logs that records have been purged prior to purge actually completing.

D-03456

When printing a workflow, the task/vertex icons are missing.

D-03477

SimpleOrComplex class name change causing problem with promotion.

D-03485

Name wildcard(*) Read permission not granted if lower privilege Read permission defined.

D-03502

Setting Log File Retention Period in Days Opswise system property to >24 days will purge all previous log files.

D-03503

SQL Task / Stored Procedure Task completes with Success when Result Set is empty even if there is a "Success Result Set Contains" results processing condition.

D-03511

Avoid benign log messages during field label lookup, "*** ERROR *** Element [SBRELEASE:field_name] does not exist".

D-03519

Persisted timers not deleted from database under certain conditions.

D-03522

Triggers do not behave well when disabled "externally" via SQL.

D-03544

Delete operation for non-existing record results in invalid cascade delete operation.

D-03551

Setting Activity refresh rate to blank generates high CPU load.

D-03560

Report with ### in "Starts With" filter not rendering properly.

D-03578

Email notifications missing attachments due to Retrieve Output command validation errors.

D-03594

"SQLServerException: Arithmetic overflow" after skipping / unskipping workflow task instance.

Release 5.1.1.4 - December 14, 2012

Change ID

Description

Change ID

Description

B-02907

Add support for System Monitor built-in variables.

B-03182

Add support for task mutual exclusion without using resources.

B-03210

Add option to promote a bundle definition between environments.

B-03278

Add "Custom Day Periods" to workflow task run criteria.

B-03319

Ability to View Resource Requests and View Resources In Use from task instance form.

B-03327

Add option on the task definition to Hold Resources on Failure.

B-03338

Add support for Boundary virtual resource type.

B-03339

Add support for Depletable virtual resource type.

B-03341

Add bundled Virtual Resource reports for Currently In Use.

B-03342

Add bundled Virtual Resource reports for Outstanding Requests.

B-03385

Add Unpublish button to published report.