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.

Browser not supported