Hotfixes

The following hotfix is available for Appian 19.2.

Hotfix Package J

This is a cumulative hotfix package that includes Hotfix Packages A, B, C, D, E, F, G, H, and I as well as new hotfixes in a single download and a set of instructions. This package is required for any Appian 19.2 installations not currently on Hotfix Package J. After installing, you will be running on Appian 19.2 Hotfix Package J.

See the Installation section at the bottom of this page for instructions on how to install this hotfix package.

19.2 Hotfix Package J

Release Date: 30 March 2020

Resolved Issues

  • Security Updates - Medium

  • AN-153911 - High
    The performance of dictionaries with a large number of fields has been improved.

  • AN-150731 - Medium
    Fixed an issue with the getUsernameByUuid API that could result in null users

  • AN-152705 - Medium
    a!queryProcessAnalytics no longer returns an error when an empty list is provided as the query.

  • AN-153819 - Medium
    Fixed an issue where saving changes on the Branding page caused subsequent interactions in the Admin Console to fail.

  • AN-154329 - Medium
    Improved performance of Interface Designer for interfaces with deeply nested components.

Release Date: 28 February 2020 (Released as Hotfix Package I)

Removals

The Disk Usage Metrics log has been removed. Previously, this log would record the amount of disk space consumed by logs, process model definitions, search indexes, and documents on a 12 hour cadence. For sites that had large numbers of these items, the size calculation could lead to intermittent performance issues.

Resolved Issues

  • Security Updates - Medium

  • AN-151874 - Critical
    Topologies configured in appian-topology.xml which distribute a single replica set of engines across multiple hosts now function properly. For instance, with this fix it is possible once again to configure all process-execution and process-analytics engines on one host and the remaining engines on another host. This restores behavior to be consistent with version 19.2 and earlier.

  • AN-149140 - High
    For security reasons, the Query Database Smart Service has been updated. Customers cannot run the LOAD DATA LOCAL INFILE command against a MySQL database by default from a Query Database Node in the Process Model. To provide higher security, for Appian Cloud customers, this command was already disabled at the database level for the Appian Cloud database and at the JDBC level for configured MySQL databases. There is no impact or action for Cloud customers. On-premise customers who wish to use this command must set the conf.data.mysql.loaddata.enabled property to "true" and conf.data.load.infile.path property as a comma-separated list of paths to whitelisted directories that contain the files to be loaded. If the required properties are not set, any Process Model using this command will pause by exception at runtime. This command is generally used to periodically load data from files into the database, and so we expect that most customers will not have to take the required action.

  • AN-149305 - High
    JDBC connector configuration property "autoDeserialize" has been set to false for all MySQL database connections, in order to improve security.

  • AN-150186 - High
    The engine transaction logs are now protected against recording additional transactions after the checkpoint request during system shutdown. Prior to this protection, a race condition could cause a transaction to be recorded after checkpointing on shutdown, which can complicate subsequent upgrades or hotfixes.

  • AN-151549 - High
    Adds additional protection against interfaces with large context memory sizes.

  • AN-137156 - Medium
    Fixed an issue in the Interface Designer which prevented Design Mode from loading when using a!groupsByName().

  • AN-135117 - Low
    Fixed an issue where changing a group type's name reset the attribute values of dependent groups.

  • AN-150265 - Low
    Updated export function and smart service descriptions to include column limits.

Release Date: 31 January 2020 (released as Package H)

Resolved Issues

  • Security Updates - Medium

  • AN-148700 - High
    Fixed an issue that sometimes caused UIs to error when navigating quickly while reevaluation requests were in progress.

  • AN-148160 - High
    A race condition that could prevent a clean shutdown of multi-node sites has been prevented.

  • AN-148043 - High
    When using IE11 in compatibility mode to authenticate to Appian via SAML, an error which prevents sign-in no longer occurs.

  • AN-147957 - High
    Application server performance under high concurrency has been improved.

  • AN-147763 - High
    Fixed an issue with the "not in" operator in a!queryFilter.

  • AN-146311 - High
    A condition that could cause the process execution engines to use abnormally high amounts of CPU has been removed.

  • AN-145981 - High
    An error that could prevent proper shutdown that would prevent upgrading has been prevented.

  • AN-142514 - High
    Fixed an issue that would have been introduced by an upcoming Chrome version, Chrome 80, where embedded users would be unable to login.

  • AN-148138 - Medium
    Fixed issue causing Query Database smart service to pause by exception when its first input is null

  • AN-148009 - Medium
    Fixed an issue that was preventing Quick App sites from properly displaying Tasks as links

  • AN-147232 - Medium
    Reduces the number of messages broadcast between app servers, resulting in a performance improvement in the engines.

  • AN-146474 - Medium
    Fixed an issue where confirmation boxes now display correctly when using Internet Explorer with Document Viewer.

  • AN-147760 - Low
    The engine recovery script no longer encounters an error when reinserting transactions into the engine transaction log.

  • AN-146688 - Low
    Knowledge center administrators are no longer displayed in the role maps of document folders that do not inherit security.

  • AN-146512 - Low
    The cleanup script no longer removes archived kdb files when the logs parameter is specified.

  • AN-60854 - Low
    A 'Report-Only' Content Security Policy header has been added.

Release Date: 13 December 2019 (Released as Package G)

Resolved Issues

  • Security Updates - High

  • AN-145504 - Critical
    For security reasons, the Query DB Node smart service has been updated. Customers running the LOAD DATA INFILE command against a MySQL instance (only applicable to Configured Data Sources; not applicable to the Appian Cloud database) from a Query DB Node in a Process Model must set the conf.data.load.infile.paths custom property as a comma-separated list of file paths to whitelist the required directories. If the property is not set, any Process Model using this command will pause by exception at runtime. This command is generally used to periodically load data from files into the database, and so we expect that most customers will not have to take the required action described here.

  • AN-146412 - High
    Clicking on a start process link after the SAIL cache is full no longer results in a full-screen error.

  • AN-147053 - High
    A memory leak in service manager has been resolved.

  • AN-145522 - Medium
    A stability fix for service manager in the case of an unstable or degraded zookeeper cluster.

  • AN-145736 - Medium
    The service manager process is now more robust to leadership changes during the startup process.

  • AN-146140 - Medium
    An error retrieving document statistics on highly-available installations has been resolved.

  • AN-147232 - Medium
    Reduces the number of messages broadcast between app servers, resulting in a performance improvement in the engines.

  • AN-141142 - Low
    The service manager process is now robust to multiple copies of the same engine running when only one is configured.

  • AN-146092 - Low
    Fixed an issue preventing the application server from starting when non-critical components of Search Server are not running.

  • AN-146167 - Low
    Fixed an issue where engine_disk_usage.csv was not logging accurate values for some directories.

  • AN-146705 - Low
    Fixed an issue causing Search Server to break a site that is low on disk space.

Release Date: 22 November 2019 (Released as Hotfix Package F)

Resolved Issues

  • Security Updates - Critical

  • AN-141281 - High
    Fixed an issue where orphan process variables could exist and impact system performance.

  • AN-144440 - High
    A race condition in service manager that could lead to site unavailability has been resolved.

  • AN-139947 - Medium
    System memory use for Appian Cloud sites has been reduced.

  • AN-145027 - Medium
    Document upload will no longer be limited by personal user storage space quotas, which were deprecated in Appian 17.3.

  • AN-145158 - Medium
    When a connection to a data source is closed due to a network error, Appian will now recover.

  • AN-140484 - Low
    A NullPointException is no longer logged in the tomcat-stdOut.log log file when clicking a related action shortcut on a record view in sites.

  • AN-144395 - Low
    A race condition that could result in multiple primaries for a single engine has been resolved.

  • AN-145153 - Low
    When more than one value is present in a SAML assertion for a single-valued field, the first value is always selected.

  • AN-145596 - Low
    Stability improvement for service manager component.

Release Date: 29 October 2019 (Released as Hotfix Package E)

Resolved Issues

  • Security Updates - Critical

  • AN-143289 - Critical
    Fixed an issue with a null parameter in a!queryLogicalExpression and a!queryAggregation.

  • AN-143776 - High
    An issue that could prevent the application server from connecting to the engines has been prevented.

  • AN-132464 - High
    The Kafka component used by the Internal Messaging Service has been upgraded to version 2.2. This upgrade resolves stability issues, such as KAFKA-2729.

  • AN-143655 - Medium
    Restarting a single node on a Highly Available Appian Cloud site no longer prevents the data server from starting up.

  • AN-143583 - Medium
    Memory optimization for the service manager process.

  • AN-142283 - Medium
    Fixed an issue that caused some record links to break on import of the record type.

  • AN-141658 - Medium
    Users no longer need to be in the Designer group to upload documents using Google Cloud Vision, SharePoint, and other document-based connected systems.

  • AN-140220 - Medium
    A race condition that could prevent an engine from shutting down cleanly has been resolved.

  • AN-138545 - Medium
    More advanced retry logic for when an engine fails to start up for a potentially transient reason.
  • AN-144259 - Low
    For Appian Cloud customers, data server startup procedure is now more robust to issues on the standby server.

  • AN-142517 - Low
    Scheduled backups for on-premise customers taken with the backup script now include Kafka logs and Zookeeper data

  • AN-142355 - Low
    Multiple data types with the same names but different casing can now be in the same export package.

  • AN-141300 - Low
    HTML entered in a post, message, or comment is now rendered as text in Appian emails.

  • AN-139911 - Low
    The queryFilter function with an 'in' filter that has many values now performs as expected again. In fact, it is over an order of magnitude faster than it was before this issue was introduced! All query filters have improved noticeably in performance, but none nearly as much as an 'in' filter with many values. This applies equally to uses of queryFilter in the queryentity, queryrecord, and queryProcessAnalytics functions.

  • AN-135983 - Low
    A specific error message is now displayed when object comparisons fail to render due to a system error.

Release Date: 30 September 2019 (Released as Hotfix Package D)

Enhancements

  • Added additional data metrics columns for connected systems.

Resolved Issues

  • Security Updates - High

  • AN-141232 Critical
    The process analytics engine now correctly handles the case where it mistakenly receives multiple copies for a single process variable for the same process from the process execution engines. Previously this could cause a sudden increase in memory used by the analytics engine.

  • AN-141683 - High
    Fixed an issue where users were unable to load mobile-enabled quick tasks that were group assigned.

  • AN-141901 - High
    Fixed an issue where users were unable to view mobile-enabled quick tasks in the related actions tab after opening the task.

  • AN-139860 - Medium
    Deselecting a pre-selected row in read-only grids now properly saves the row data.

  • AN-140894 - Medium
    Fixes an error caused by indexing into invalid fields or list indices in unevaluated branches of a local variable definition, such as the valueIfFalse parameter of an if() when the condition is true.

  • AN-140947 - Medium
    Fixed an issue where auditor and viewer roles for Sites were not being respected after upgrading to 18.4.

  • AN-141212 - Medium
    Clarify DevOps infrastructure connection statuses.

  • AN-141355 - Medium
    Navigating to a record view no longer triggers extra requests after navigating away from that view.

  • AN-141740 - Medium
    A warning is no longer logged every time a service account calls a Web API using API key authentication.

  • AN-130623 - Low
    Process model diagrams in process model comparisons will no longer fail to render.

  • AN-133660 - Low
    Using an expression for process model node assignment no longer causes errors in the process model comparison.

  • AN-134753 - Low
    Added additional product metrics for integration executions.

  • AN-141453 - Low
    Saving interface expressions with syntax errors now have better error handling when reopening an interface.

  • AN-141466 - Low
    Allow incoming PATCH calls to the app server.

Release Date: 4 September 2019 (Released as Hotfix Package C)

Enhancements

  • AN-139955 - Updated the Admin Console Infrastructure dashboard so that URLs link to the corresponding environments

Resolved Issues

  • Security Updates - Critical

  • AN-138540 - High
    Completing a Task via a Tempo Task Report no longer prevents the Task list from properly appearing.

  • AN-138598 - High
    Fixed an issue where users were unable to accept tasks built via the Forms Designer when navigating from a direct link.

  • AN-138721 - High
    Fixed an issue where users were unable to interact with related actions for mobile-enabled forms in Internet Explorer 11.

  • AN-139079 - High
    An issue that could prevent zookeeper from restarting cleanly in on-premises installations has been resolved.

  • AN-70284 - Medium
    Fixes a variety of internationalization issues with date and time formatting. For the Arabic [ar] locale, hours and seconds are now internationalized correctly, as well as the timezone. For the Arabic [ar], Chinese (Simplified) [zh_CN], Chinese (Traditional) [zh_HK], Japanese [ja], and Swedish [sv] locales, AM and PM will also be properly internationalized.

  • AN-125589 - Medium
    No errors are thrown if devops infrastructure url wasn't set on cloud sites

  • AN-129916 - Medium
    A error in Kafka that could prevent startup has been corrected.

  • AN-134827 - Medium
    Fixed an issue with rendering interfaces containing deeply nested columns in Interface Designer's live preview.

  • AN-136540 - Medium
    Fixed a bug that caused integrations to break on import when they reference themselves in the default test values

  • AN-137595 - Medium
    Fixed an indexing error that could occur with updates to the analytics engine

  • AN-137603 - Medium
    Fixed an issue where line charts with date or datetime categories affected tooltips of components on the same interface.

  • AN-137727 - Medium
    Read-only grid now shows a user-friendly value when called within the expression rule designer.

  • AN-138292 - Medium
    When running as a Windows service, the service manager process is now more tightly linked to the Windows service, preventing cases where one would be running without the other.

  • AN-138526 - Medium
    Notification emails for tasks assigned to groups are now styled correctly.

  • AN-140057 - Medium
    The Blue Prism connected system now properly handles requests that contain special characters.

  • AN-50653 - Low
    Large folders no longer display negative sizes.

  • AN-134751 - Low
    Added data metrics for api keys

  • AN-134752 - Low
    Added data metrics for SSL certificates

  • AN-136623 Low
    Fixed an issue where duplicate entries were being logged for some exec errors

  • AN-136712 - Low
    The speed at which Tasks, Actions, and News items are loaded has been improved. The improvement removes the performance degradation observed in some cases on Appian versions 18.3 and later.

  • AN-137051 - Low
    User and user and group picker results have been updated to be consistent with 19.1 and earlier.

  • AN-137640 - Low
    Added a new audit log, removed_processes.csv, to track events where a process is deleted or archived off of the system

  • AN-138326 - Low
    Added logging improvements to the engine client.

  • AN-138674 - Low
    Search server startup now waits for 30 seconds before timing out. Enhanced messaging has been added for the waiting period.

  • AN-138724 - Low
    Formatted test outputs in Appian Designer now correctly display null decimal and datetime fields in CDTs

  • AN-139526 - Low
    Adds additional logging when certain errors occur while executing a save in an interface.

  • AN-140194 - Low
    The performance improvement for Tasks, Actions, and News items loading in AN-136712 has been reverted due to race conditions which caused users to see 403 errors. The reversion applies to Appian versions 19.1 and later.

  • AN-140249 - Low
    Fixed an issue where performance metrics did not log once a data limit had been reached.

  • AN-140291 - Low
    User profile and group membership data no longer get synched via SAML login. This feature is available in version 19.3.

Release Date: 26 July 2019 (Released as Hotfix Package B)

Enhancements

  • AN-52550
    Usernames may now contain apostrophes.

Resolved Issues

  • Security Updates - High

  • AN-136428, AN-136466, AN-136570 - High
    The Hotfix resolves a vulnerability related to Google Service Account integrations with Appian. It is recommended that users of Google Service Account integrations reset their passwords in connection with the installation of this Hotfix.

  • AN-137627 - High
    Query database smart service now tolerates MySQL client-side prepared statements and does not fail.

  • AN-113345 - Medium
    Drilling from a process report to individual processes now works correctly.

  • AN-123890 - Medium
    Fixed an issue that prevented some tasks from disappearing immediately from the Task list upon completion

  • AN-134067 Medium
    Updating the batch size on a read-only grid query expression now updates the grid page size.

  • AN-135140 - Medium
    Fixes domain name mismatch on certificate from cloud sites

  • AN-135673 - Medium < br> An issue loading drivers for old versions of SQL Server on Appian Cloud sites has been resolved.

  • AN-135990 - Medium
    The "version" Process Model property now returns the correct result in Process Reports when the process has undergone In-Flight Modification (IFM).

  • AN-136057 - Medium
    Overhead of calling functions in the a! domain has been reduced.

  • AN-136782 - Medium
    MySQL prepared statements are now correctly closed. Query Database Smart Service will no longer fail because of application reaching the max_prepared_stmt_count value for prepared statements.

  • AN-136861 - Medium
    Side-By-Side Layout item lists no longer cause an error with null or empty string values.

  • AN-137015 - Medium
    A new Appian installation now correctly starts with MySQL 8.0.16 configured as a primary data source. Customers will no longer see the data truncation error.

  • AN-137219 - Medium
    Enabled TLSv1.1 and TLSv1.2 support for outgoing emails over SMTP

  • AN-137414 - Medium
    The optimization to enable faster querying of deeply nested CDTs with one-to-many relationships has been turned on by default for on-premise customers.

  • AN-137955 - Medium
    Fixed an issue that caused an error to flash on-screen when completing a Task from Sites

  • AN-129208 - Low
    The start process smart service no longer logs excessive error messages if the user who starts the process does not have permission to see that process.

  • AN-134946 - Low
    Binding an Appian Engine to a port already in use now logs a detailed error message and returns error code 100.

  • AN-135661 - Low
    The Mean Individual Time value in the appian_functions_details.csv and expressions_details.csv logs is now calculated correctly. Prior to this fix, the value could be greater than the Mean Total Time value.

  • AN-136209 - Low
    Zookeeper connectivity issues during startup no longer prevent a clean shutdown of the Appian engines.

  • AN-136685 - Low
    Fixed an issue that caused extraneous logging in customer logs

  • AN-136741 - Low
    Number of CPU threads created by the data server is now capped at 8 per data server process

  • AN-136746 - Low
    Data Type comparisons no longer include the Source field

  • AN-137010 - Low
    An artificial memory cap for the search server has been removed.

  • AN-137338 - Low
    A rare race condition that could cause an engine to hang in a "stopping" state when stopping the engines immediately after starting them has been prevented.

  • AN-137373 - Low
    Data sync process that copies data from one data server node to the other nodes is now more robust.

  • AN-137418 - Low
    Read-only grids now handle nested lists when used as grid data.

Release Date: 25 June 2019 (Released at Hotfix Package A)

Resolved Issues

  • Security Updates - High
  • AN-135342 - Critical
    The Export Data Store Entity to Excel and the Export Data Store Entity to CSV smart services (and their related functions) now export data without having duplicated rows. This issue only occurred when no 'Selection' or 'Aggregation' parameters were set on these smart services.
  • AN-134504 - Critical
    Clear the Appian WSDL cache and retry the request if an error occurs
  • AN-130798 - High
    Fixes an issue where an interface would revert back to a previous state and lose the user's input.
  • AN-131275 - High
    Fix wrong types for OpenAPI Integration headers and query parameters as well as wrong types for OpenAPI Connected System basic authentication.
  • AN-131443 - High
    Fixed an issue that prevented the Document Viewer component from being displayed correctly when using a non-standard top-level domain.
  • AN-131765 - High
    The version of OpenJDK bundled with the installer is now 8u212b03.
  • AN-132064 - High
    Resolved a browser-specific issue with Google Chrome 78+ that caused developers to be falsely alerted about concurrent editing of an object.
  • AN-134002 - High
    Application server stability has been improved for Appian Cloud sites that run with application server memory greater than 5GB.
  • AN-134686 - High
    An issue that prevented some Data Stores from appearing in the Create Constants dialog has been resolved.
  • AN-135121 - High
    Prevents Entity from being read to string when integration is run from process.
  • AN-135134 - High
    Fixes content length too long when sending over multipart form data in an integration.
  • AN-135136 - High
    Email branding settings now display properly in the administration console.
  • AN-135537 - High
    Fixes content length exception for sending multipart in integration
  • AN-93123 - Medium
    Modifying only the description of a custom data type (CDT) will now update its Last Modified user and timestamp. When exporting and importing this CDT, the new description will be reflected in the XML and in Appian Designer.
  • AN-119314 - Medium
    In High Availability configurations, when an Appian engine is unable to write to disk, that engine will be taken out of the cluster so that it no longer receives traffic.
  • AN-123861 - Medium
    Designers and end users now see errors on activity chained interfaces that contain errors instead of displaying nothing.
  • AN-126478 - Medium
    Improves performance currently experienced when loading a record list for which 'Export to Excel' is enabled.
  • AN-129449 - Medium
    When creating an interface from a data type, an error no longer occurs when the data type has a field that holds a list of boolean values.
  • AN-129865 - Medium
    This migration fixes any existing occurrence of older versions of data type not being correctly associated with the newer versions. This will prevent errors on import and CDT updates.
  • AN-130402 - Medium
    A query filter that has a null value and uses the "between" operator is now properly ignored if the ignoreFiltersWithEmptyValues parameter is set to true.
  • AN-130960 - Medium
    Fixes an issue where one very large interface context caused a performance degradation in other interfaces.
  • AN-131163 - Medium
    Fixed an issue related to older versions of data types not being correctly associated with the newer versions. This will prevent errors on import and CDT updates.
  • AN-131226 - Medium
    When creating an interface from a data type, the generated buttons are now correctly wrapped in lists.
  • AN-131227 - Medium
    Appian's shutdown process is now more resilient to services stopping out of order.
  • AN-131383 - Medium
    Fixed an issue related to user navigation after submitting a form on an Action site page.
  • AN-131428 - Medium
    Exporting a record list to Excel will now work when the record type's sort is defined using a!sortInfo() but the ascending parameter is not defined.
  • AN-131472 - Medium
    Appian's topology configurations are now more flexible.
  • AN-131658 - Medium
    The appian.keystore file is now better protected against potential corruption when starting Appian on a server with no free disk space remaining.
  • AN-131812 - Medium
    The performance of task reports has been improved.
  • AN-132129 - Medium
    Migration has been introduced to unlock the datatypes that are incorrectly locked. This will prevent errors on CDT import and updates.
  • AN-132763 - Medium
    Plug-ins that load classes from the javax.swing.* package now work in Appian Cloud. Prior to this fix, the plug-in smart service or function would fail and an error message similar to the following would be logged by the application server: java.lang.NoClassDefFoundError: Could not initialize class javax.swing.RepaintManager. This returns behavior to that of versions 18.4 and earlier.
  • AN-132813 - Medium
    The system is now more resilient against cascading degradations caused by thread exhaustion when the connection between the application server and business datasource is unavailable.
  • AN-132833 - Medium
    Fixes document rollback on integration failure.
  • AN-132818 - Medium
    An optimization has been added to enable faster querying of deeply nested CDTs with one to many relationships. A custom property can be set to enable this optimization if customers experience slowness with queries involving deeply nested CDTs.
  • AN-132239 - Medium
    Loading interfaces containing start process links when the SAIL cache is full no longer results in an error.
  • AN-133410 - Medium
    Fixed an issue where Record User Filters were incorrectly cached when changing Sources.
  • AN-134022 - Medium
    Appian now recovers correctly after receiving certain types of error responses from an RDBMS. Previously an application server restart was required to recover.
  • AN-134331 - Medium
    Fixed an issue with font size and margin display in system-generated emails to users on mobile devices.
  • AN-134365 - Medium
    Fixed an issue where in some cases of using repeated variable names, data was not correctly updated in a read-only grid.
  • AN-134663 - Medium
    Fixed an issue related to dynamically displaying interface components based on an array condition in the if() function. Now duplicates of the component are no longer displayed. This restores behavior to be consistent with version 18.4 and earlier.
  • AN-135476 - Medium
    Read-only grids which query process data no longer error when paging or sorting.
  • AN-135528 - Medium
    Export to Excel in records will now export the correct URLs when exporting record links.
  • AN-133920 - Medium
    Long instance names in the performance view of the Record Response Times page now properly truncate
  • AN-127554- Low
    Query Editor is now accessible from local variables' configuration pane in Interface Designer.
  • AN-127646 - Low
    Incremental update errors no longer log the entire content of the update message to the analytics logs. Previously, repeated incremental update errors could rapidly increase the amount of disk space used by these logs.
  • AN-129783 - Low
    Fixed a race condition issue related to the addition of multiple users to a new group. Users who have just been added to a new group will no longer see hibernate errors when they access product the product simultaneously.
  • AN-130674 - Low
    Fixed an issue where the browser window title was not set correctly for Entity Backed Records in Sites. As a result, excessive ERROR level logs being written to the appserver logs is also fixed.
  • AN-131695 - Low
    The logging mechanism for the embedded Tomcat application server is now more memory efficient.
  • AN-133944 - Low
    Performance improvement for interfaces that contain many local variables with common dependencies. This only applies to local variables created using the new a!localVariables function.
  • AN-132430 - Low
    Fixed a race condition issue related to the creation of Users in Appian. Users will no longer see a "JDBC Batch Update" error which appeared randomly on opening User records that were not correctly stored in the database.
  • AN-132437 - Low
    Reduces the amount of memory used by deeply nested instances of a!localVariables. Also reduces the amount of memory used by local variables using multiple refresh configurations of a!refreshVariable.
  • AN-132630 - Low
    Plug-ins that use the dom4j library now deploy without error without restarting the application server.
  • AN-133038, AN-75970 - Low
    The "version" Process Model property now returns the correct result in Process Reports and sorts along with the other data when sorting by a different column.
  • AN-133191 - Low
    Product metric for inspect times now logs correct values.
  • AN-133314- Low
    Query Editor is now accessible from local variables' configuration pane in Interface Designer
  • AN-134953 - Low
    Fixed an issue that prevented Salesforce integration objects with large configurations from saving.

Installation

Perform the following steps to apply the hotfix:

  1. Before proceeding with applying the hotfix, there may be prerequisite steps to follow:
    1. Check if you are applying this hotfix to a version of Appian with the Komodo library version 1.230.0 by viewing the library version in <APPIAN_HOME>/services/lib
    2. If the komodo-1.230.0.jar file (with that exact version number) is present, following the instructions in KB-2084 before proceeding.
  2. Stop Appian. See Starting and Stopping Appian for detailed instructions:
    1. Shut down the application server.
    2. Shut down the search server.
    3. Shut down the data server.
    4. Shutdown all Appian Engines, ensuring that the engines are checkpointed upon shutdown.
  3. Back up your existing Appian instance. See Backing Up Your Existing Appian Instance for instructions.
  4. Unzip the contents of the 19.2.0.0_Hotfix_Package_J.zip archive into your <APPIAN_HOME> directory.
  5. Run the deleteFiles script (deleteFiles.bat on Windows, deleteFiles.sh on Linux) that is now located in your <APPIAN_HOME> directory.
    • If the script reports that some files were not deleted, address the reason for the failure (common causes listed below), and run it again until it no longer reports failed deletions.
    • Common causes of failed file deletion include:
    • The file is open in another window or process
    • The file is locked
    • You do not have permission to delete the file
  6. Unzip the contents of the updates.zip archive that is now located your <APPIAN_HOME> directory.
  7. Run the installJdk script (installJdk.bat on Windows, installJdk.sh on Linux).
  8. If you maintain customized or overridden Spring Security .xml files, merge them with the associated base files in the /deployment/web.war/WEB-INF/conf/security/ directory.
  9. Delete the deleteFiles scripts, the installJdk scripts, the OpenJDK .tar.gz and .zip files, and updates.zip.
  10. If you are using a Web server, copy the content of <APPIAN_HOME>/deployment/web.war to the folder where the Web server is getting the static resources. See Copy Static Resources to the Web Server for more information.
  11. Run the configure script to deploy your environment's configuration and re-configure any node names previously set by the configure script tools.
  12. Start Appian:
    1. Start the Appian Engines.
    2. Start the data server.
    3. Start the search server.
    4. Start the application server.

To determine if Appian 19.2 Hotfix Package J is deployed, open the build.info file located in <APPIAN_HOME>/conf/. The contents of this file should match the following code sample:

build.revision=7d2b8de0ba28612850657914b16267620d150e4e
build.version=19.2.237.0
FEEDBACK