Skip to main content

OpCon 21 Release Notes

OpCon 21.10.0​

2022 December

Server​

✳️ OPCON-17772: OpCon Core services now use self-contained .Net 6 Core instead of self-contained .Net 3.1.

Solution Manager​

✳️ OPCON-17594: Solution Manager now allows users to view, add, edit, copy and delete master jobs from a link on the "library" page, for the following types: Null, Windows, UNIX, SQL, SAP R/3, Container, File Transfer, OpCon MFT.

✳️ OPCON-16236: Solution Manager now allows users to create a new OpCon MFT agent and job type. Details are in the documentation.

OpCon 21.9.0​

2022 November

REST API​

✅ OPCON-17814: Improved query performance for the HistoryJob endpoint to efficiently manage large amounts of data.

ImpEx2 Web Service​

✳️ OPCON-18274: Added Windows Authentication to ImpEx2 Server.

OpCon 21.8.0​

2022 October

Server​

✅ OPCON-17121: Fixed an issue with SSL and TLS based Email and text message notifications.

✅ OPCON-17624: Fixed an issue in the notification system where an SMTP server that does not require authentication could not send notification emails as Notify Handler was forcing authentication.

REST API​

✅ OPCON-17447: Fixed a bug that allowed all-whitespace tag names in /api/jobtags and errored on an empty tag name.

✅ OPCON-17296: Fixed performance issue in dailyJobs endpoint when includeDetails=true and there are a lot of container jobs.

✅ OPCON-17204: Fixed an internal server error bug in /api/jobinstanceactions when retrieving JORS output for historical jobs.

✅ OPCON-17190: Fixed an issue where adding/updating a daily schedule instance property inserted a backslash.

✅ OPCON-17178: Migration for Notification Triggers was moved from 21.4 and 21.6 to 21.8.

✅ OPCON-16932: Fixed issue where single quotes in a batch user name caused an error.

Installation​

✅ OPCON-17234: Updated Installer to allow users to set a default (initial) password for database users 'opconsam' and 'opconui'. Please note that if these users already exist in the database, no changes will be made to their passwords.

Solution Manager​

✅ OPCON-17291: Fixed an issue in the scripts page where HTML inside a comment was being rendered to screen.

✅ OPCON-17195: Fixed an issue where File Transfer Jobs threw an unexpected error.

✅ OPCON-17047: Fixed issue with scripts timing out when a large amount of cross references exist.

✅ OPCON-15633: Fixed a bug with tooltips on expression dependencies.

✅ OPCON-16312: Fixed issues with self service where migration would fail and service requests would not execute for some input types (Date, Choice, etc.) if user-defined variable name contains dot.

✅ OPCON-16337: Added the options to disable builds for schedule named instances without parameters.

✅ OPCON-16973: Added "With Error(s)" message to jobs that have failed jobs.

✅ OPCON-17185: Fixed the Escalation screen to allow special characters.

✅ OPCON-17601: Fixed an error that affected Enterprise Manager that was caused by deleting notification groups inside Solution Manager.

✅ OPCON-17602: Fixed a bug in Solution Manager that caused an error in Enterprise Manager when users tried to delete a group that was associated with a category.

✅ OPCON-17603: Added improvements to the retrieval and posting actions for triggers inside Notification Manager.

ImpEx2 Web Service​

✅ OPCON-17433: Fixed issues with schedule level frequencies when performing a deployment update. The errors included duplicate keys if jobs added during the deployment, or missing frequencies for job if new schedule level frequencies were added.

✅ OPCON-17766: Fixed an issue where schedule import failed to extract the thresholds/resources used in the complex expressions for Job Expression Events.

OpCon 21.6.0​

2022 July

Server​

✅ OPCON-16723: Fixed an issue in the expression evaluator, where Windows file arrival paths were incorrectly resolved when running OpCon on Docker.

✅ OPCON-17069: Fixed an issue where Netcom tracking files were getting populated with machine up/down messages that would never get cleared.

REST API​

✅ OPCON-16939: Fixed an issue where Posting Roles to its endpoint with batch users caused an error.

✅ OPCON-16185: Fixed an issue in OpCon API where new machines were shown as created by Unknown user in Audit Management.

Solution Manager​

✳️ OPCON-15118: Solution Manager now allows users to configure notifications in OpCon for machines, schedules and jobs, when any actionable change occurs to them. Notification triggers belong to a group, but in the new notification system, groups are flat structures instead of hierarchical ones like Enterprise Manager used to have. So, each notification trigger belongs to a single root group. Any pre-defined hierarchical groups will stay as they are, but only the lowest level of the group is visible in Solution Manager. Instead, users can define a 'Category' for each trigger as a way to tag them for a purpose. A trigger can have multiple categories assigned. The new system makes it easy to understand and categorize triggers. NOTE: A bug in the latest release (21.6) may cause Notification Manager to not work for customers whose upgrade or install path had included version 21.4. Notification Manager does work for new installs or upgrades from other versions. If you are experiencing issues with Notification Manager, please upgrade to 21.8 when available.

✳️ OPCON-15117: Solution Manager now allows users to define and configure escalation rules for different notification triggers. Users can create and associate the rules to each trigger, and also to a group of users who will receive the escalation based on the defined rules provided they have an email address defined. The escalation manager allows users to be associated to the rules and notification manager allows them to be associated with the triggers.

✳️ OPCON-15100: Solution Manager now allows a user to manage batch users via the Library. You may add, edit and delete batch users and you can view cross references for them.

✅ OPCON-17029: Fixed a sorting error with calendars screen when there are two or more pages.

ImpEx2 Web Service​

✅ OPCON-16749: Fixed an issue in ImpEx2 service where an SAP job import and deploy caused problem with certain header types in the XML request to the SAP system. The XML headers are now cleared before the request is made.

OpCon 21.5.0​

2022 May

Installation​

✅ OPCON-16513: Fixed an issue with the database migration during a minor upgrade where if the Windows Domain user running the upgrade did not have the correct permissions to the database, the migration failed. The installer should have used the SQL user from the database config file (DAT file) for the migration, instead.

REST API​

✅ OPCON-16687: Fixed an issue in OpCon API where concurrent access to its authentication end point sometimes caused issues with the token management and the API stopped running.

✅ OPCON-16793: Fixed an issue in the OpCon API where fetching calendars and frequencies (GET) required the user to have 'maintain' privileges to those resources, when they are only needed to add/update/delete them.

✳️ OPCON-16604: The OpCon API now allows users to fetch basic job details from master, without any dependencies, events, etc. It also allows the user to fetch cross references to these jobs from other master jobs.

✳️ OPCON-16613: The OpCon API now allows maintaining notification escalation groups. A user can call the API to fetch, create, edit and delete escalation groups with either OpCon users and/or global properties that contain the user name. API documentation has more details (api/escalationGroups).

✳️ OPCON-16656: The OpCon API now allows users to edit a null job in master with only basic details, without any dependencies, events, etc.

✳️ OPCON-16855: The OpCon API now allows users to view cross references to master jobs from other master jobs (jobs that depend on this job).

Solution Manager​

✅ OPCON-16012: Fixed a performance issue in Solution Manager PERT view of the Operations page, where the request timed out in some instances resulting in the PERT view not being displayed.

✅ OPCON-16702: Fixed an issue in Solution Manager with calendars, where saving dates on a system with the French date format caused calendars to throw 'invalid date format' errors.

✅ OPCON-15595: Fixed an issue in Solution Manager where a dependency on a named instance schedule's job from a different named instance, did not show the instance name as part of the schedule name built in daily in the job dependencies section.

✳️ OPCON-15120: Solution Manager now allows users to maintain scripts. Users can add, edit, copy and delete scripts and their types and runners. They can view cross references for the script, manage their versions, and deploy specific versions to defined jobs.

✳️ OPCON-16126: Solution Manager now allows users to maintain machines. From the agents page, a user can select machines and edit them, add new machines, copy settings to new a machine and check the cross references for them.

ImpEx2 Web Service​

✅ OPCON-16321: Fixed an issue in ImpEx2 where external job dependencies from named instance schedule to regular schedule were not extracted correctly.

✅ OPCON-16074: Fixed ImpEx2 to stop schedule/script import and display an exception message if a duplicate script type name is detected.

✅ OPCON-16336: Fixed an issue in ImpEx2 service where validation was not done for missing batch users for Windows, Unix, IBM i, and MCP file transfer jobs before deploying them to the target environment.

✅ OPCON-16345: Fixed ImpEx2 to fail the deploy if batch user for SQL jobs does not exist in the target system.

✅ OPCON-16498: Fixed an issue in ImpEx2 where "Job Status Description" LSAM feedback events were not supported.

OpCon 21.4.0​

2022 April

Enterprise Manager​

✅ OPCON-16476: Corrected Enterprise Manager environment switching problem by removing database connection pool from Enterprise Manager connections and only using database connection pool for ImpEx2 connections.

Installation​

✅ OPCON-15798: Fixed an issue where new OpCon installs did not work for non-contained databases. Going forward, only contained databases will be allowed as it is a requirement when supporting Azure SQL because security related information like users can't exist outside the database in the cloud. Existing installs without containment will keep working as they are.

REST API​

✅ OPCON-16477: Fixed error in Machine Groups endpoint where it was trying to validate Machines in each group.

Server​

✅ OPCON-15619: Added fix in ENS to prevent error when saving records in the EscalaitonRecipientHistory table.

Solution Manager​

✅ OPCON-16442: Added functionality so that the back button takes the user back to the Agent's page when appropriate.

✅ OPCON-15792: Modified Frequency parameter in JOB:ADD events in Solution Manager to no longer be required.

OpCon 21.3.0​

2022 March

Installation​

✅ OPCON-16206: Ampersand is now allowed as a characters in DB user passwords when running the OpCon installer.

Solution Manager​

✳️ OPCON-15121: Solution Manager now allows management of frequencies in OpCon. You can edit an existing frequency to update its settings, associate a calendar to it, and also see the resulting forecast for it. NOTE: The forecast in the frequency manager does not account for any schedule calendar holidays, so it may be different from the actual days on which the schedule or job will be build as there are additional holiday calendars that are considered when building a schedule.

✳️ OPCON-15099: Solution Manager now allows management of Departments. Users can add, edit, copy and delete departments. They can view any references for a selected department to master/daily jobs and/or roles that have a function privilege defined on that department.

ImpEx2 Web Service​

✅ OPCON-16123: When adding a new role to a schedule, the role must be defined in the target OpCon system. If the role is not defined, the deployment will fail with an error message, Role not defined in destination opCon system.

✳️ OPCON-16167: Include Role checking during deployment simulation

✅ OPCON-16313: Fixed an issue in ImpEx2 with SQL jobs where the User ID did not get deployed or updated for Windows authentication.

✅ OPCON-16111: Fixed an issue in ImpEx2 where connections to the database were not getting disposed and eventually all TCP dynamic ports were getting used up.

✅ OPCON-15995: Implemented removal of roles for ImpEx2, that are no longer required during deployment of existing schedule/package

OpCon 21.2.0​

2022 January

REST API​

✳️ OPCON-15895: Fixed an API issue where the calendar type was incorrect for new calendars.

✳️ OPCON-15894: Added calendar associations to the API response for calendars.

✳️ OPCON-15857: Added the PUT functionality for IBM i job type "Operator Reply".

✅ OPCON-16031: Fixed an issue in the API where a port specified in the INI file was not checked for a valid TLS certificate.

Solution Manager​

✳️ OPCON-15890: Solution Manager now allows users to edit IBM i "Tracked Jobs" job type.

✳️ OPCON-15847: Added the feature to edit IBM i job details for the 'Operator Replay' job type.

✳️ OPCON-15844: Added List of previous Schedule Check results under Schedule Check section of Daily Schedule's and Date's right panel.

✳️ OPCON-15842: Added Schedule Check section to Daily Schedule's and Date's right panel, that allows user to perform a Schedule Check.

✳️ OPCON-15537: Added the display feature for IBM i job task details for "Operator Replay Job" job type.

✳️ OPCON-15119: Solution Manager now allows users to manage job tags - create, associate to jobs at job/frequency level, or delete them.

✳️ OPCON-15106: Solution Manager now allows users to view and maintain calendars. This includes adding new calendars, editing, deleting and copying existing calendars and deleting old dates (greater than 30 days) on existing calendars. It also fixes minor bugs on the API for calendars that existed before regarding calendar description length and description of all errors returned.

✅ OPCON-16102: Fixed issue with using period '.' in Self Service Variable names

✅ OPCON-16032: Fixed an issue with Windows authentication where a pop-up occurred on expired logins.

✅ OPCON-16025: Fixed the flickering issue of when user cache is reset

✅ OPCON-15951: Fixed an issue in Solution Manager where editing job dependencies in daily had performance issues when the list of total schedules and named instances for each of those was very large.

✅ OPCON-15793: Fixed bug where select all was ignoring filtered records in Thresholds and Resources screen.

Utilities​

✅ OPCON-16024: Fixed a bug where selecting a different drive to install the configuration utility did not affect it and it was installed on the system drive.

ImpEx2 Web Service​

✅ OPCON-15836: Corrected a problem in ImpEx2 when changing a Null Job to a Windows Job during deployment.

OpCon 21.1.0​

2021 December

Enterprise Manager​

✅ OPCON-15949: Fixed an issue that occurred while using export Daily Job Audit Management.

REST API​

✳️ OPCON-15870: - Added api/deleteActions endpoint to handle deletion of dailyJobs & schedules.

✅ OPCON-15809: Fixed an issue with Vision processing occurring when no cards were defined in the database and further performance improvement on Vision statistics queries

✅ OPCON-15779: - Fixed an issue causing tokens containing parameters to be parsed incorrectly.

  • Improved parameter validation for events using tokens.
  • Simplified handling of start and endvalue parameters for exit description analysis event triggers.

✅ OPCON-15737: Fixed a memory issue where expired tokens were not removed from cache.

Solution Manager​

✳️ OPCON-15807: Solution Manager now allows users to view and edit IBMi job details for the 'Batch job' type.

✳️ OPCON-15759: Solution Manager now allows users to create/edit/delete note(s) on a job's historical run.

✳️ OPCON-15318: Solution Manager now allows users to monitofy daily job events.

✳️ OPCON-14523: Solution Manager now allows users to view a job's historical runs along with their properties for that run.

✳️ OPCON-15105: Solution Manager now allows users to manage resources (view, add, edit, delete).

✅ OPCON-15950: Fixed French translations in the screens for Schedule, Resources, Thresholds, Global Properties, and Daily Jobs.

✅ OPCON-15947: Fixed an issue where multiple daily jobs referencing the same resource showed an invalid date in resource dependencies in Solution Manager.

✅ OPCON-15782: Fixed an isue with the migration page redirect for updating variables needed in self service.

✅ OPCON-15757: Fixed an issue with the date selector on the Processes page during Daylight Savings Time changes.

ImpEx2 Web Service​

✅ OPCON-15723: Changed script mapping during deployment process to use names instead of numeric id values. The script-name, type-name and runner-name is a unique combination.

OpCon 21.0.0​

2021 October

Documentation​

✳️ OPCON-14481: Added Overview chapter to the OpCon Installation section of documentation. The new chapter contains updates to the installation and update process and highlights any breaking changes requiring action as part of upgrading.

✅ OPCON-15505: Removed OpCon.UserDefindFunctions.pdf from the distributed Database Scripts.

Enterprise Manager​

✅ OPCON-15579: Fixed an issue in ImpEx2 where the schedule id was smallint instead of int causing numeric overflow when schedule id is greater than 32xxx during schedule import.

✅ OPCON-15530: Fixed an issue in Enterprise Manager, where Episys sub type jobs had parsing issues, when going to a None sub type, saving it and going back to the Episys sub type.

✅ OPCON-15467: Fixed an issue in Enterprise Manager where adding or updating certain MCP job arguments gave an invalid characters in argument error.

✅ OPCON-15465: Fixed a global property extract issue in schedule extract that threw an index out of bounds error, when using it.

✅ OPCON-15278: Fixed an issue where jobs using the Corelation sub-type would display a "String index out of range" error.

✅ OPCON-15079: Fixed an issue where the "Number of Days to Keep a Service Request Execution" Server Option was unable to be changed.

✅ OPCON-15008: Fixed an issue that prevented creating or opening a job using the Corelation sub-type when using Global Properties.

✅ OPCON-14816: Fixed an issue where a SQL job using the SQL DTExec job action did not display the batch user that the job ran as.

✅ OPCON-14777: Fixed an issue where the machine options "Use Schedule Instance Machine" and "Run on Least Tasked Machine" were not save-able on Windows and UNIX jobs.

✅ OPCON-14706: Fix display error where command line showing up in "Other Options" instead of "Files To Delete".

✅ OPCON-14658: Fixed an issue where the Self Service navigation item would not display for some users.

General​

✅ OPCON-14583: Updated the SMA Customer Community link in the user interfaces.

✅ OPCON-15525: Fixed an issue where job output requests would error with a code of 36235 in EM and a general error in Solution Manager.

Installation​

✅ OPCON-14847: Added validation during the REST API startup routine to ensure the database has been properly updated.

✅ OPCON-14750: The OpCon installer now checks to see if .Net Core 3.1 is installed on the system, required by the core services, and if not, installs it.

✳️ OPCON-14889: OpCon is now self-contained with .Net Core dependencies, so the system does not require .Net Core installed on it to install and run OpCon Core services.

✳️ OPCON-14824: OpCon Deploy's ImpEx2 server component now has its own installer and will be available with the OpCon package with the same release cadence. This makes it easy to upgrade ImpEx2 only when needed without having to upgrade OpCon or Deploy client. It also makes it easy to upgrade Deploy client without upgrading ImpEx2 or OpCon.

✳️ OPCON-14761: Added a verification step to the SMA OpCon Install that validates SMA OpCon Database Scripts, SMA OpCon Documentation, SMA OpCon SAM, and SMA OpCon Solution Manager have been uninstalled before proceeding.

✅ OPCON-14732: Fixed an issue where the database connection information was not editable when doing a Repair/Modify.

✅ OPCON-14684: Fixed an issue where database scripting variables would be reset to default values when performing an upgrade.

✅ OPCON-14657: Updated the database connection screen to re-use the database server and database name entered in the database set-up screen during new installations.

✅ OPCON-14600: Fixed an issue where the SMA OpCon install would not remember SQL authentication selections when an attempt to modify the installation was made.

✅ OPCON-14576: Fixed an issue where the SMA OpCon install would use an incorrect directory for data files when installing on a non-system drive.

✅ OPCON-14120: Fixed an issue in job dependencies for the automatically installed SMA Utility schedule if jobs were converted to multi-instance jobs.

REST API​

✅ OPCON-15475: Add support for SQL job types in Daily Jobs GET and PUT endpoints.

✳️ OPCON-15678: A new endpoint has been added to the API to delete thresholds.

✳️ OPCON-15609: The API now gets/sets the documentation value of a global property. A new endpoint has been added to the API to delete global properties.

✳️ OPCON-15575: Implemented GET and PUT functionality for instance properties on the /api/dailySchedules endpoint

✳️ OPCON-15464: Added validation for daily job events through the PUT endpoint.

✳️ OPCON-15363: Added a searchable endpoint for the UI to consume. api/metadata/eventTriggers

✳️ OPCON-15310: Added the functionality to retrieve LSAM Feedback and complex expression events by using the following endpoint: api/dailyjobs/{dailyJobId}/events

✳️ OPCON-15309: Added the functionality to create complex expression events by using the following endpoint: api/dailyjobs/{dailyJobId}/events

✳️ OPCON-15308: Added the functionality to create exit description events by using the following endpoint: api/dailyjobs/{dailyJobId}/events

✳️ OPCON-15307: Added the functionality to create LSAM Feedback events by using the following endpoint: api/dailyjobs/{dailyJobId}/events

✳️ OPCON-15306: Added the functionality to retrieve job status and exit code events by using the following endpoint: api/dailyjobs/{dailyJobId}/events

✳️ OPCON-15297: Added the functionality POST/PUT/DELETE daily job events through the PUT endpoint for daily jobs.

✳️ OPCON-15296: Added the functionality to retrieve daily job events in the GET endpoint for daily jobs.

✳️ OPCON-15295: Added the PUT and DELETE endpoints for jobs jobStatus in daily job events.

✳️ OPCON-15294: Added the Post endpoint for jobs jobStatus in daily job events: api/dailyJobs/{dailyJobId}/events

✳️ OPCON-15293: Added a new endpoint, GET api/dailyJobs/{id}/eventTriggers, to retrieve Event Triggers defined for a Daily Job.

✳️ OPCON-14790: Added a new endpoint for adding a job dependency to a daily job, POST api/dailyjobs/{dailyJobId}/dependencies.

✳️ OPCON-14789: Added the ability to modify job dependencies as part of the daily jobs endpoint. Added an endpoint to update an individual job dependencies.

✳️ OPCON-14788: Added a new endpoint for deleting a job dependency on a daily job, DELETE api/dailyjobs/{dailyJobId}/dependencies/{id}.

✳️ OPCON-14785: Added a new endpoint for retrieving daily job dependencies.

✳️ OPCON-14680: Added the ability for the OpCon API to filter machines by file transfer role. The criterial "fileTransferRole"accepts values of "both", "none", "source", "destination", and "any".

✳️ OPCON-14670: The OpCon API can now create new incident tickets in the Daily Job Definitions.

✳️ OPCON-14655: The OpCon API now provides functionality to edit file transfer job details for a daily job having Windows/Unix machines.

✳️ OPCON-14557: The OpCon API now provides functionality to view file transfer job details for a daily job.

✳️ OPCON-14784: The API now supports adding, updating and deleting daily job dependencies alone on a daily job.

✳️ OPCON-14521: Add support for OS2200 job types in Daily Jobs GET and PUT endpoints

✅ OPCON-15648: Fixed issue where a request to return unencrypted Global Properties fails to return all of them. Standardized default false values in the database for TOKEN.TKNENCRYPTED to be 'False'.

✅ OPCON-15607: Fixed an issue where a global property value exceeded the maximum length when encrypted.

✅ OPCON-15437: Fixed an issue where dates submitted through self-service across time zones were being incorrectly parsed as the preceding day.

✅ OPCON-15399: Fixed an issue in Solution Manager / API, where navigating to the schedule build page to build a multi-instance schedule on machine groups resulted in an error.

✅ OPCON-15300: Removed additional error codes that were coming back with unsuccessful PUT requests to api/dailyJobs.

✅ OPCON-15280: Regular expression pattern in Self Service Requests will no longer be evaluated for empty values.

✅ OPCON-15270: Fixed an issue where Regex was not working with double quotes inside of self-service text variable.

✅ OPCON-15249: Fixed an issue where when updating an Embedded Script job to run on a machine group instead of single machine, an error would be returned.

✅ OPCON-15075: Fixed an issue where editing a daily job definition would throw a null reference exception when no job dependency object was provided.

✅ OPCON-15011: Fixed an issue where Self Service would display a "Cannot load Service Request Executions" error for several days after upgrading to OpCon 20 or higher.

✅ OPCON-14886: Fixed an issue in self signed certificate generation where hostname did not match with the name on the certificate and it gave NET::ERR_CERT_COMMON_NAME_INVALID error when trying to browse Solution Manager.

✅ OPCON-14871: Fixed NullReference exception with 20.0 migration when Service Requests were missing information.

✅ OPCON-14843: Fixed an issue where the user's role was removed and the password was changed after attempting to retrieve a token.

✅ OPCON-14808: Fixed an issue where acknowledging a collection of escalating notifications with multiple notifications already acknowledged gave a 500 response code.

✅ OPCON-14800: Fixed an issue in OpCon API where a user could not add instance properties on a file transfer job and any existing ones were removed.

✅ OPCON-14713: Fixed an issue where Service Request event definitions would be incorrect when using a system variable more than once in the definition.

✅ OPCON-14666: /api/roles offset and limit query string parameters have been fixed.

✅ OPCON-14663: Fixed an issue where changing daily job statuses as a user with no defined external token would throw a System.NullReferenceException error.

✅ OPCON-14649: Fixed an issue where a user without user management privileges would receive a "The user specified in the request does not exist." error when executing a service request defined with the Submit events as ocadm option enabled.

✅ OPCON-14611: Fixed an issue where retrieving job summary information for a job with a machine group would fail with a "'TRIM' is not a recognized built-in function name" error on SQL Server versions lower than SQL Server 2017.

✅ OPCON-14587: Fixed an issue where retrieving Job Output for a previous run of a job would generate an error when the job was recurring and currently in a waiting status.

✅ OPCON-14238: Removed the name of a role when it is displayed in Vision Cards or Service Requests when the user does not have permission to that role.

Server​

✅ OPCON-15718: Automatically use MultipleActiveResultSets connection string parameter to better support async database operations.

✳️ OPCON-15016: OpCon now supports Azure SQL Database to host the OpCon database to leverage cloud based infrastructure and benefit from Azure scalability, backup plans and out-of-the-box fault-tolerance. NOTE: Managed Azure SQL instances are currently not supported (Differences: https://docs.microsoft.com/en-us/azure/azure-sql/database/features-comparison). Also for consistency, all new OpCon installations (both, on-prem SQL and Azure SQL) will use the "contained database" setting, which means OpCon users will be defined in the database, and not at the SQL Server level.

✅ OPCON-15463: Fixed a bug where single quotes in a job add event cause SAM to loop an 'Incorrect syntax' error.

✅ OPCON-15400: Fixed an issue where the subject used in "SendEmail" application was incorrectly sent.

✅ OPCON-14929: Fixed an issue in Netcom where under heavy communication load with agents, if a message acknowledgement is lost or delayed, Netcom created a bad 'resend' message, which caused issues on the agent side in the tracking file.

✅ OPCON-14516: Fixed a performance issue with schedule builds that contain large amounts of sub-schedules.

✅ OPCON-14464: Fixed an issue where an embedded script with a line ending in backslash gave syntax errors when running it on agent.

✅ OPCON-12267: Fixed issue with Unknown audit records caused by Notify Handler when a connection is lost.

Solution Manager​

✅ OPCON-15626: Added a shortcut for creating new global properties from the global property selector.

✳️ OPCON-15674: Thresholds can now be consulted/changed in Solution Manager.

✳️ OPCON-15605: Added functionality to maintain Global Properties.

✳️ OPCON-15576: Added Start Time to the edit daily schedule screen

✳️ OPCON-15378: Task Details for OS2200 daily jobs can now be consulted / changed from the Daily Job Definition screen.

✳️ OPCON-15317: Daily Job events can now be viewed in Solution Manager.

✳️ OPCON-14920: Job Dependencies can now be consulted / changed from the DailyJob Definition screen.

✳️ OPCON-14906: Added a Property Selector Dialog for easily searching and selecting a property.

✳️ OPCON-14851: Add Button to navigate in context on the Processes Page to quickly consult the Active Jobs associated to an Agent.

✳️ OPCON-14818: Buttons like Save and Cancel are now always visible. Avoid to force the user to scroll down to perform an action.

✳️ OPCON-14774: DailyJob Definition Page section menu redesigned. It was moved on the left, is always visible and can be reduced

✳️ OPCON-14770: Added the number of pending and exhausted notifications to the escalation indicator. Escalated notifications may now be acknowledged even if any of the selected notifications were already acknowledged.

✳️ OPCON-14752: Updated the Property Selector to show all properties, Global, Job Instance, Schedule Instance, and Machine Instance. An icon was added to differentiate the type. Properties may also be filtered by value in addition to name.

✳️ OPCON-14654: The Operations Processes and Agents grids can be modified to only display the desired columns for Schedules, Jobs, or Machines. This selection is automatically saved in the user's profile.

✳️ OPCON-14605: Added Filter Profiles to the Operation Summary page for viewing statistics directly in the dashboard. Added the ability to navigate to the processes page with the selected Filter Profile already applied.

✳️ OPCON-14575: Escalated notifications can now be acknowledged from Solution Manager or through the OpCon API. A pop-up notification will appear within Solution Manager when new notifications enter escalation. An indicator was added to the bar at the bottom of the screen by the Agent Status icon when there are escalating notifications which need to be acknowledge. Finally a dialog was added allowing users to acknowledge the escalated notifications.

✳️ OPCON-14574: File Transfer Jobs can now be consulted / changed from the DailyJob Definition screen.

✳️ OPCON-12005: Added Resource Update and Threshold Update sections to the Daily Job Definition page.

✳️ OPCON-12004: Expression Dependencies can now be consulted / changed from the DailyJob Definition screen.

✳️ OPCON-12003: Threshold and Resource Dependencies can now be consulted / changed from the DailyJob Definition screen.

✳️ OPCON-11031: UNIX Jobs can now be consulted / changed from the DailyJob Definition screen.

✳️ OPCON-15112: File Transfer jobs with a source or destination machine of IBMi, z/OS, MCP, and OS2200 can now be consulted / changed from the DailyJob Definition screen.

✳️ OPCON-14963: Added the Daily Schedule Summary information panel

✳️ OPCON-14707: Task Details for SQL daily jobs can now be consulted / changed from the Daily Job Definition screen.

✅ OPCON-15573: Fixed an issue where Excludes Job Dependencies displayed an option to change Offset

✅ OPCON-15532: Fixed an issue in Solution Manager self service, where a user input of type choice submitted the name of the choice instead of its value.

✅ OPCON-15500: Fixed an issue where advanced failure criteria was not displayed for Windows and Unix daily jobs

✅ OPCON-15255: Fixed Solution Manager to correctly display multiple choices in a Self Service even if they represent the same value.

✅ OPCON-15226: Fixed a bug that wiped the entire screen when a filter profile was shared with a role that had the id of 0.

✅ OPCON-14949: Fixed an issue where a Schedule Build request could be submitted for the incorrect day if opening the date picker but selecting no values.

✅ OPCON-14903: Fixed an issue in Agents page where right panel actions weren't enabled after a page refresh.

✅ OPCON-14875: Fixed an issue where environment variable should not contain "=" character.

✅ OPCON-14864: Fixed an issue in Resource Dependency read only mode where condition was displayed in red instead of green when total resource number was equal to required resource.

✅ OPCON-14860: Fixed an issue in Schedule/ Resource right panel in PERT, where dependent / update job list was not filtered by the selected Schedule / Resource.

✅ OPCON-14791: Fixed an issue where clicking on a Vision Card with an offset redirects on the wrong Date in the Operation Processes Page.

✅ OPCON-14674: Fixed a cosmetic issue where NumberField does not appear correctly in some situations

✅ OPCON-14597: Fixed an issue in Schedule Build where the schedules would not build "On Hold" even when the option was selected.

✅ OPCON-14584: Fixed an issue where validation was not case-insensitive and allowed the same name to be used for Vision actions, frequencies, and remote instances.

✅ OPCON-14567: Fixed an issue in Schedule Build where the pre-defined properties on a Named Instance schedule were not able to be updated.

✅ OPCON-13063: Requesting output for an invalid job in Solution Manager no longer displays an error. The option is now correctly disabled when the job has no output.

Utilities​

✳️ OPCON-15335: OpCon now includes a utility that publishes usage data (daily task counts) to the cloud and/or local file. The utility job is set to 'do not schedule' and needs to be updated with suitable arguments and set to build 'released' (it is installed with default arguments). Details of the utility are here: https://github.com/smatechnologies/usage-data

✅ OPCON-15504: Small fix in invalid data for SMAUtility schedule.

✅ OPCON-15337: Fixed the transaction log backup file in the backup utility scripts to be initialized so it does not keep appending to it and grow forever.

✅ OPCON-12473: Fixed an issue with History.exe to purge/archive the correct amount of records according to the documentation.

ImpEx2 Web Service​

✳️ OPCON-14859: Updated ImpEx2 service (used by Deploy) to include SQL agent job enhancements - using Win Auth for package execution (DTExec) and running Integration Services Server packages - as part of the deployment to OpCon environments.

✅ OPCON-15461: Fixed an issue where ImpEx2 did not start up if the database was configured to force encrypted connections.

✅ OPCON-15450: Fixed an issue in ImpEx2 where deploying a schedule with a frequency having the same name but different case in the name deployed the schedule to target with some missing properties and missing job level frequencies.

✅ OPCON-15436: Fixed an error with deployment when calendars associated with the schedule or package to be deployed does not exist in target server.

✅ OPCON-15401: Fixed an issue where multiple embedded script versions referenced from jobs in the deployed schedule resulted in null pointer exceptions, as only one of those script versions was getting imported into Deploy.

✅ OPCON-15394: Fixed an issue where global properties in environment variables for a job were not getting extracted into the deploy repository.

✅ OPCON-15385: Fixed an issue in ImpEx2 where the target system's roles/access codes were overwritten with privileges from the source system in Deploy, if a role/access code with the same name existed on the target system.

✅ OPCON-15339: Added startup check to make sure Impex is using a correct DB schema version. Added new CLI option "--skipVersionValidation" to skip this and continue without the check.

✅ OPCON-15268: Fixed an issue in ImpEx2 where a change in a job's threshold/resource update on 'job status' and 'value' did not get deployed to the target system correctly.

✅ OPCON-15146: Fixed issue where partial-match transformation rules only applied to the first occurrence in a string

✅ OPCON-15136: Fixed an issue where SAM reused an id for a job instance due to a race condition with Deploy

✅ OPCON-15089: Fixed an issue where wildcard named job and schedule transformation rules that have the same "current value" caused incorrect transformation rules to be applied to them. Also, added suffix wildcard. "job" will match if job/schedule ends with "job". "job" and "job*" will continue behaving as normal and will match if the job/schedule starts with "job"

✅ OPCON-15080: Fixed an issue where only one of multiple external dependencies to the same schedule and job were imported into Deploy.

✅ OPCON-15069: Fixed an issue where a multi-instance schedule converted to single instance before deployment to a target system, did not get converted correctly on the target.

✅ OPCON-15067: Fixed an issue in Deploy where updating frequency priorities for an existing schedule on the target system, caused a loss of some scheduling options on the frequencies of the newly deployed schedule.

✅ OPCON-15049: Fixed an issue in ImpEx2 where blank batch users were "missing" in simulations.

✅ OPCON-15036: Fixed an issue where Thresholds/Resources/Global Properties could sometimes get duplicate entries in the target environment when transformation rules converted source names of those entities to the same target names.

✅ OPCON-15030: Fixed an issue in ImpEx2 where obsolete job dependencies in an existing schedule on target system were not getting removed.

✅ OPCON-15023: Fixed an issue that allows Deploy to correctly prefix a schedule with the environment code in events.

✅ OPCON-15010: Fixed an issue where scheduling options of the frequencies were not updated correctly if there was changes to them in the schedule that was deployed.

✅ OPCON-15001: Fixed an issue where deploying a schedule with no documentation would not remove any existing documentation.

✅ OPCON-15000: Fixed an issue in ImpEx2 service where checking available machine features sometimes resulted in a null pointer exception.

✅ OPCON-14985: Fixed an issue in batch deploy where the job sometimes ended in a concurrent modification exception.

✅ OPCON-14898: Fixed an issue in ImpEx2 where deploying a schedule with a department that has no role assigned threw an exception.

✅ OPCON-14839: Fixed an issue in ImpEx2 to prevent unexpected data loss when job threshold/resource dependencies or events were modified in the schedule that was deployed.

✅ OPCON-14830: Improved error message content returned to Deploy when the OpCon API is unreachable.