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

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

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

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

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

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

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

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

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.

B-03386

Add View Published URL button to published report.

B-03387

Add property Override Published Reports Base URL for customization of the Base URL for published reports.

B-03411

Add option for Windows tasks to run with highest privileges.

B-03421

Add support for task instance Clear Resources command.

D-03291

Workflow name disappears after saving graph in the workflow editor.

Release 5.1.1.3 - October 24, 2012

Change ID

Description

B-03122

Add View Notes menu option from task instance form.

B-03184

Add ability to skip a task and all dependent tasks with a single Skip Path command.

B-03185

Add ability to Retrieve Output (stdout and stderr) while a task is still running.

B-03214

Add ability to display notes for task instances in reports/gauges.

B-03240

When issuing the Retrieve Output command, replace the previously retrieved output with the new output (for same output_type and task instance attempt).

B-03271

Add INFO-level log message to indicate when a maintenance script has completed.

D-03325

Queries on Activity are slow when security administered using Business Services.

Release 5.1.1.2 - October 1, 2012

Change ID

Description

D-03312

Task run criteria using variable with Run Time evaluation is not processed.

Release 5.1.1.1 - September 28, 2012

Change ID

Description

D-01832

Business Services filter not functioning; "form not found".

D-02942

Hovering over the form preview pop-up for agents will display information, however, status is blank.

D-03276

Go To search not working with # character.

D-03292

Tasks with very long duratio and/or very long workflow start offset causing overflow in INT data type column.

D-03305

Variables defined at the File Monitor and Task Monitor trigger level are not being passed to the associated file monitor or task monitor when the trigger is enabled.

D-03310

Automatic retry intermittently fails with "prohibited due to security constraints" for execution user with ops_admin role.

Release 5.1.1.0 - September 12, 2012

Change ID

Description

B-02322

Add Insert Task option for inserting a task into an active workflow instance.

B-02332

Extend Calendaring functionality by adding support for Custom Periods.

B-02780

Improve security filtering on Lists by not displaying blank rows/pages of records for which a user does not have Read permission.

B-02796

New command that combines cancel and force finish.

B-02798

Add Follow References option to Bundle definition (similar to Export with References option).

B-02811

Add Result Limit to queries from Task Find/Open Workflow pop-up in Workflow Editor.

B-02815

Add node information to the Overview widget on homepage so users can determine which cluster node they are logged into and the node's status.

B-02839

Extend Time Trigger functionality by adding support for Less/Plus adjustments, Nth Date Adjective, and Run Every # Days, Starting On <Date>.

B-02840

Extend forecasting functionality to incorporate tasks within workflows/sub-workflows in order to provide a more comprehensive view of planned workload.

B-02843

Enablement of SAP Business Warehouse feature in Opswise Controller.

B-02882

Re-brand Opswise Groups as Business Services to avoid ambiguity with Security Groups.

B-02888

Add ability to set priority for acquiring virtual resources.

B-02916

Sort variables by name on launch/trigger with variables dialog.

B-02921

Enhance SAP Connection to support type B (load balancing) connections.

B-02942

Include the evaluation of Run Criteria when generating forecast information.

B-02944

Add auditing for User and Group administration operations.

B-02945

Add all supported code pages to the Codepage drop-down list for the "INFITRAN" File Transfer Task type.

B-02946

Build Tomcat bundled version of the Opswise Controller installation (AIX only).

B-02966

Add ability to unskip a task instance within an active workflow instance.

B-02967

Add ability to hide skipped task instances within a workflow instance.

B-02983

Add ability to generate date/time variables for a specific day.

B-02985

Add Find In Graph option from within Workflow Editor/Monitor.

B-02995

Add ops-update-resource-limit capability to CLI.

B-02996

Incorporate User Login activity into Audit.

B-03071

Add Forecast reports leveraging new forecast information.

B-03140

Add tooltip for edge conditions in Workflow Editor/Monitor.

B-03146

Add Nth support to Task Run Criteria.

B-03148

Make glide.ldap.groups.filter_indirect=true the new default in glide.properties.

B-03157

Add to Bundle does not clearly indicate when an item is already in the bundle.

B-03159

Add Enable Trigger Simulation Opswise property to allow generating forecast data without triggers firing.

B-03162

Add Forecast Calendar and Forecast List links to the navigator.

B-03172

Increase To, CC, BCC and Subject column sizes on Email Task and Email Notification forms.

B-03180

Add column for Trigger Time to the Forecast table.

B-03194

Dump stacktrace on detection of GUID lock held for extended period.

D-02677

Attach File Email Notification option not always attaching the correct file (z/OS).

D-02781

Charts in Emailed Reports not built same as charts in Automation Center.

D-02793

Deleting an active (enabled) Trigger with Forecast enabled results in orphaned/invalid forecast records.

D-02797

Cannot personalize columns for lists that are part of a tab on a form.

D-02834

Updating an enabled trigger from a passive node gives incorrect error message.

D-02839

"SQLException: ORA-12899: value too large for column "OPSWISE"."OPS_AUDIT"."description" (actual: 1501, maximum: 1000)."

D-02840

LDAP refresh or update can cause a large number of log messages in the opswise.log.

D-02841

Add extra start-up logging to show Opswise Release/Build information and MySQL properties.

D-02883

History Duration Report fails on MS SQL Server.

D-02985

Using calendar preview with a special character (&) in the description produces an error.

D-03007

Invalid IP address for z/OS agent in exported XML file.

D-03060

User can end up with duplicate roles in the User Roles list.

D-03083

Deleting unsatisfiable order of multi-part resource order does not release instance.

D-03196

List export (with references) of a Workflow Task does not export Custom Days in Run Criteria.

D-03202

Enabling forecast for triggers that launch large workflows can result in an out of memory exception.

D-03254

Data Backup/Purge command results in a flood of GUID lock warnings in log if back-up takes a while.

Prior Maintenance

In addition to the above changes, see Opswise Automation Center Outboard 5.1.0 Maintenance for changes previously included in 5.1.0 maintenance releases that also are included in the 5.1.1 releases.