9.3-MP2 Maintenance Patch Notes
March 2020
New features
Oracle 19c Support
Oracle Database version 19c is now supported for 9.3 systems (including all maintenance patch levels).
With the support of 19c, Oracle Database version 12.2.0.1 will no longer be supported with as of the 10.1 release (Fall 2020). Customers using Oracle Database should upgrade to a supported version.
For support information, refer to 9.3 Platform and Software Support here.
Bugfixes
ISSUE-307665 - Cleaned up invalid / unused synonyms in schema
Invalid and unused synonyms in the stepview schema were pointing to views that no longer existed in the stepsys schema. These have been cleaned up.
ISSUE-327092 - Search Widget history cleared between users
In the Web UI, search history from the Search Widget is no longer shared between different users. A hotfix is available for step-8.3-mp3.
ISSUE-369072 - Extension API Search Tab fix
Fixed a problem with the STEP Extension API when the Node Selection Dialog called a null set of object types and the Search Tab was not shown.
ISSUE-369442 - Move classification error fix
Fixed an issue in which an attempt to move the classification using the 'Move' button caused an unexpected error in Web UI.
ISSUE-373944 - Merge Values in LOV wizard fix
In the workbench, the Merge Values in LOV wizard now correctly keeps the selected master value ID during both manual value prioritization and in the final result in situations with either no- or one-dimensional dependencies.
ISSUE-376251 - Search Table Tab can limit results
The Search Table Tab in the Web UI uses drill down search for typeahead to allow the use of search plugins. Previously, the drill down search could not be limited, which made it very slow when returning a large result set. Now, it can be limited by selecting a maximum result number under the Advanced flipper of the Search Table Tab Properties.
ISSUE-377196 - Advanced Search criteria available to subgroups
In the Web UI, Advanced Search criteria that is saved and shared with a given user group is now also available to users in subgroups of that specific group.
ISSUE-379646 - Search error fix
An error occurred in the workbench when a search's character count crossed the maximum limit, especially if the search was enclosed in brackets. This has been fixed.
ISSUE-379998 - Automatic Classification exceptions fix
Fixed a problem where Automatic Classification exceptions in the Allow Rules were duplicated in the workbench. A hotfix is available for step-9.2-mp3.
ISSUE-380065 - Attribute validity In-Memory fix
Previously, when validity was removed from attributes that had values on a combination of products, classifications, or entities, and references on In-Memory systems, a NullPointerException (NPE) would occur. This has been fixed.
ISSUE-380556 - Move Action redirect fix
In the Web UI, there was an issue where the Move Action would trigger the page to be redirected to the Homepage. This has been fixed.
ISSUE-380762 - Inherited references fix for Web UI
Inherited references are now correctly shown under the References component in Web UI, even if the Reference Type is not valid for the selected object type but is valid for the original source, which inherits it to the child. Note that inherited references will only be shown in inherited (and all relative selections, such as 'ALL,' 'INHERITED,' 'INHERITEDSUPPRESSING,' etc.) for Reference Mode on the Node Editor properties.
ISSUE-381192 - Create Variants popup error message added
Now, an error message will occur when a user attempts to select an LOV with more than 5,000 values to be added to the product variant on the Create Variants popup in the Web UI. This error message informs the user that the number of values exceeds the maximum.
ISSUE-382143 - Scrollbar fix for Table Display View mode
Now, the scrollbar is only displayed on the Table Display View mode on the Multi Reference component of the Web UI if necessary.
ISSUE-382705 - Move Unit To Header transformation fix
Fixed a bug where the table transformation 'Move Unit To Header' only worked in cases where the destination header row / column did not contain a node. Now, the transformation moves the unit up from non-header rows / columns.
ISSUE-383604 - Workbench recycle bin performance fix
Loading products in the workbench recycle bin would sometimes be very slow due to the computation of calculated attributes. For this reason, calculated attributes are no longer loaded up front for products in the recycle bin since users are not expected to work with the products in the recycle bin.
ISSUE-383841 - Setup Groups deletion fix
Deletion of Setup Groups failed if it contained multiple versions of revised children (e.g. integration endpoints). This has been fixed, and a hotfix is available for step-9.3-mp1.
ISSUE-384027 - MoveUnitsToHeader plugin log level lowered
The MoveUnitsToHeader table plugin was filling the log with errors when it encountered a cell of a type it did not handle. This error has now been lowered to a warning.
The following property must be added in config.properties for the log level to disappear: 'Log.Level.com.stibo.core.domain.impl.table.transformations.MoveUnitsToHeader = SEVERE'.
ISSUE-384505 - LDAP multi-domain fix
The problem occurred when using multi-domains for LDAP. It was not possible to log out from an instance of the Web UI and then log in again with the LDAP user. This has been fixed so that it is possible to log out and log in again when multi-domains for LDAP is enabled. A hotfix is available for step-9.3-mp1.
ISSUE-384658 - Translation Status search fix
There was an error in the Translation Status search when using In-Memory. When doing a multi-clause search where one of the clauses was a Translation Status search for 'Not-Translated' text, the restriction for node type (i.e. Classification, Product, Asset, etc.) would sometimes be ignored, resulting in the search result including objects of the wrong type. This has been fixed.
ISSUE-384770 - Golden Record Clerical Review Task List filtering fix
Now, Golden Record Clerical Review Task List will correctly filter collection and status flag filtering on a Status Selector Homepage Widget in Web UI. Hotfixes are available for step-9.1-mp5 and step-9.1-mp6.
ISSUE-384821 - Task List filtering fix
When values were filtered on a workflow Task List in the Web UI, the case-sensitive values were incorrectly ordered. This has been fixed so that by default, the filtered values are not case sensitive.
ISSUE-384910 - Category Profiling performance fix
When running Category Profiling, there was a performance issue due to the number of folders. The ability to use parent folders (which can be cached) has been introduced to avoid having more than 10,000 subfolders. Now, there can be 10,000 parent folders and each of these can have 10,000 Category folders.
ISSUE-385018 - Performance fix for Business Rule editor
Fixed a performance issue that caused long load times when trying to open the Business Rule editor in the workbench. This was particularly noticeable on systems with many business libraries.
ISSUE-385052 - Homepage selector spacing fix
Fixed a spacing issue in the Status Selector Homepage Widget in Web UI.
ISSUE-385294 - Edit Unique Key error message fix
When the user attempted to replace a unique key with an existing unique key via the Edit Unique Key action, the system would show an uninformative message of 'Unexpected error...'. Now, the error message is more descriptive.
ISSUE-385603 - NPE fix for search results
Fixed a NullPointerException (NPE) error in setValue in the Web UI when loading search results.
ISSUE-385976 - Design Mode workplace restriction NPE fix
In Web UI Design Mode, certain Web UI components (such as Name, ID, and Value component) were throwing a NullPointerException (NPE) when attempting to add the components to a screen when the user had restrictions on certain workspaces (for example, allowed only Approved workspaces) while still in the restricted workspace (for example, Global) in the URL session.
ISSUE-386311 - Temporary DTP document property added to sharedconfig.properties
Added a new property 'DTPDocumentUpload.TmpDir,' to sharedconfig.properties, which allows the creation of temporary DTP documents to be done on a shared folder.
ISSUE-386372 - Stack trace exception capture fix
The STEP server will no longer need a restart in order to capture stack trace exceptions.
ISSUE-386437 - Filtering / sorting functionality change
When a Node List contains more than 5,000 objects, sorting and filtering is disabled. This is because Node Lists can include up to 10,000 results but will only display 5,000 objects; any objects above the 5,000 displayed will not be shown and sorting and filtering cannot be applied to them. For example, if an advanced search result contains 10,000 results, and the user clicks a header to sort and filter the Node List based on the values in the column, it would not be obvious that all objects after 5,000 are ignored, and so the resulting list would not be accurate. When users initiate sorting and filtering on a Node List with more than 5,000 objects, an informational dialog will display that reads, 'Sorting and filtering on this subset of data would display inaccurate results, so they have been disabled.' This restriction is applied to all display modes that support sorting and filtering, i.e., Multi Edit, Table, and Compare views.
ISSUE-386441 - Portal.MaxResultCount property max limit
To mitigate performance and memory issues, the Portal.MaxResultCount property now has a hard-coded maximum of 10,000 items. If the user currently has an item limit set to a value below 10,000, then nothing will change. If, however, the property is currently set to a value above 10,000, the number has been updated to 10,000.
This property affects the following: Advanced Search Screen, Node List, Search List screen, Generic Search screen, Display Children screen, and the Search Widget, Batch Admin and Multi Reference components.
ISSUE-386963 - Asset preview image fix in Web UI
Fixed a problem where the asset preview image was being cropped on the Asset Preview Screen.
ISSUE-387884 - Importer object type fix
If the import file specifies a different object type for an existing object, the importer can change the object type to the new object type. However, if existing data on the object is invalid for the new object type, the import should fail. There was an error in this check that made it possible for the object type to change even though the references were invalid. This has now been fixed.
ISSUE-387918 - Web UI cache memory fix
A cache used by the Web UI cached too much information, which caused the application server to run out of memory. This was particularly problematic in Web UI components where tables for a large numbers of nodes were shown. This has been fixed, and a hotfix is available for step-9.2-mp3.
ISSUE-387923 - Thumbnail fix for Web UI
Fixed a problem where .PDF thumbnails were not shown correctly under the Thumbnail Header on a Web UI Node List. A hotfix is available for step-9.2-mp3.
ISSUE-388009 - Footer hidden on Table Display View mode
Now, the pagination footer is hidden when viewing the only page in Table Display View mode in Multi Reference component of the Web UI.
ISSUE-388041 - Data Profile rendering fix for products
The Data Profile component now renders properly in Web UI for product and classification types.
ISSUE-388104 - NullPointerException fix for OIEP
When the OIEP user did not have view permissions for an analyzed node, a NullPointerException (NPE) was thrown. This has been fixed.
ISSUE-388152 - Duplicate value check timing fix
When a multi-valued attribute was loaded on a Node Details screen in the Web UI, a duplicate value check was not performed immediately, which meant that duplicate value warnings were also not displayed immediately. The user would have to change a value for the duplicate value check to be triggered. This issue has been fixed so that duplicate value warnings are displayed upon loading.
ISSUE-388163 - Link Metadata Values now editable
Now, it is possible to edit Link Metadata Values on a Link Attribute Column on a References Server component for local dimension-dependent links / references in the Web UI.
ISSUE-388164 - Overset frame fix
When a STEPCOND was mounted in InDesign, if the frame was overset, the STEPCOND would not be resolved and the <STEPCOND would be displayed on the mounted page. This has been resolved, and the overset STEPCOND is resolved.
ISSUE-388185 - Pasted values line break fix in Rich Text Editor
Fixed a problem in the Web UI where line breaks in the Rich Text Editor on a Node Editor were ignored after values were pasted in the Rich Text Editor.
ISSUE-388413 - Node Details display correct selection
Now, the chosen Node Details selection will correctly reload after saving changes on the Show Details section under the Node List Table Display mode in Web UI. A hotfix is available for step-9.2-mp3.
ISSUE-388430 - Web UI search performance fix
Fixed a problem in the Web UI where the Search Widget and Corner Bar Search used global value search, which significantly impacted performance.
ISSUE-388479 - Item submission acknowledgement fix
Fixed a problem occurring when the acknowledgement 'Item was successfully submitted' sometimes was not shown after successful item submission on a Node Editor with Task List details overlay enabled.
ISSUE-388484 - Table fix in the workbench
There was a problem where newly added tables were not appearing in the list of tables until after a reload in the workbench. This has been fixed. Hotfixes are available for step-9.1-mp5, step-9.1-mp6, and step-9.2-mp3.
ISSUE-388526 - Error fix for Integration Endpoint property
Fixed a ClassCastException error that occurred when the property IntegrationEndpoint.CheckForMultiplePollers.OnSchedulePoller was used on an In-Memory system.
ISSUE-388620 - Oracle Full Text search property default reverted
This affects only Oracle Full Text search on Web UI. The default value of the Search.Fulltext.PrintJoins property has been reverted back to the default value of 'false,' as it had been before 9.3. On new systems and systems where the Oracle Full Text search indexes have been recreated, the property Search.Fulltext.PrintJoins should be set to 'true.'
ISSUE-388657 - Background process NPE fix
Fixed sporadic NullPointerException (NPE) on the Background Process (BGP) Editor in the workbench.
ISSUE-388708 - LOV value fix
Fixed an issue where LOV value ID (instead of LOV value) was shown for read-only attribute value component on Web UI Node Editor screen.
ISSUE-388829 - Analytics Screen navigation fix
Previously, when the user navigated to the Analytics Screen as a Sub Screen Tab Page on the Web UI tree, a NullPointerException (NPE) was thrown when the URL included an empty or non-existing attribute. This has been fixed.
ISSUE-389199 - Workflow editor performance fix
When the workbench's workflow editor was opened, there was a lag in performance, especially if there were a lot of business libraries or business rules in the workflow. This has been fixed.
ISSUE-389348 - References '<' and '>' character fix
Fixed an issue where escaping '<' and '>' characters on References component in Web UI caused a '<multisep>' line to be added to every changed value, even for single-valued attributes.
ISSUE-389383 - Bulk Update action for approved workspaces
Now, it is possible to execute Bulk Update actions in an approved workspace in Web UI. To enable this functionality, contact Stibo Systems Support. A hotfix of this solution is also available for step-9.3-mp1 and step-9.1-mp6.
ISSUE-389391 - Node List selection fix
Previously, when selected items were removed from the Node List in Web UI as the result of a Business Rule, the items remained selected. This has been fixed so that the Node List selection clears out after Initiate Business Action is executed.
ISSUE-389479 - Print Publisher table tag definition fix
In both Print Publisher Proof View and PDF, when a table was moved to the next page, only the table tag definition was mounted on the page. This has been fixed to ensure that the table is justified when moved to the next page.
ISSUE-389963 - Domain exporter memory reduction
The amount of memory used by the domain exporter has been reduced.
ISSUE-390153 - Stack overflow error fix
Fixed an issue with duplication of method interceptors with the script engine that could cause stack overflow errors during the execution of business rules.
ISSUE-390390 - Deduplication List screen attribute values fix
Previously, the Attribute Value Group and Attribute Value headers on the Deduplication List screen in the Web UI did not display the attribute values. This has been fixed and a hotfix is available for step-9.3-mp1.
ISSUE-390868 - Thumbnail edit selection fix
Previously, when a column with thumbnails was configured, the edit field in the Web UI would jump to another row, resulting in confusion about which field was being edited. This has been fixed.
ISSUE-391013 - Character fix for Node Editor
Fixed a problem where LOV values with less than / greater than characters were not shown correctly on the Web UI Node Editor after choosing and saving the values.
ISSUE-391438 - Context / workspace Web UI fix
Fixed an issue so that users do not view a context or workspace which is not configured in the Web UI.
ISSUE-391911 - Checkbox fix for Table Display Mode
Fixed a problem where checkboxes were shown on Table Display Mode on Collection Content Screen in Web UI only if Edit Collection Action was configured.
ISSUE-391986 - LOV values in Approved Workspace fix
Fixed a problem where LOV attributes on the Web UI Node Editor in an Approved Workspace were displaying LOV IDs instead of values.
In-Memory translation error fix
Fixed an issue with In-Memory where a user got an exception during translation status search if the result involved a translation for a table. A hotfix is available for inmemory-7.0.46.
In-Memory cluster fix
Fixed an issue in In-Memory that could cause a cluster to become unresponsive in situations where one application server encountered issues or was restarted.
In-Memory task deletion fix
When viewing or managing task lists with different sorting in In-Memory, errors occurred if a task had been deleted by another user or process due to operation on the deleted object. This has now been fixed. A hotfix is available for inmemory-7.0.27.
Asset push configuration error fix
Fixed a bug that, in very rare cases, could lead to internal errors when working with asset push configurations in the Web UI.
Automatic Classification exceptions fix
Fixed a problem where Automatic Classification exceptions in the Allow Rules were duplicated in the workbench. A hotfix is available for step-9.2-mp3.
Rich Text Editor line break fix
Previously, the Rich Text Editor in Web UI did not display line breaks in the field until the editor was saved. This has been corrected, and a hotfix is available for step-8.3-mp3.
Additional logging for GDSN importing
Additional logging has been created to help determine root cause of an issue with GDSN importing.
Link Metadata Values now editable
Now, it is possible to edit Link Metadata Values on a Link Attribute Column on a References Server component for local dimension-dependent links / references in the Web UI. A hotfix is available for step-9.2-mp3.
Export locale fix
When exporting in-line references and calculated attributes in cross-context mode, when either of the two functions 'localizeNumber' or 'localizeDate' were used, the same locale was used for all contexts. This has been fixed so that the locale comes from the appropriate context. A hotfix is available for step-9.3-mp1.
Deletion of internal objects now prevented
In some situations, it was possible to delete some of the internal objects required for proper STEP operation (e.g. the attribute id=ProductPageNumber), even though it had been prevented in some places. Now, this deletion is prevented.
Logging removed from HTTP comms for MACs
Removed some logging that had been added to the HTTP comms for MACs. Hotfixes are available for step-9.1-mp5 and step-9.1-mp6.
JavaScript optimizations
Code that checks if the JavaScript running in Business Rules is accessing a field that is specified in the public API has been optimized. Additionally, other optimization has been done to reduce the overhead of checking JavaScripts to ensure they are not violating public API. Hotfixes are available for step-9.1-mp5 and step-9.1-mp6.
NPE fix for Multi Context Edit component
Fixed a NullPointerException (NPE) that was thrown upon navigation to the Multi Context Edit component in Web UI.
Advanced Search plugin fix
The STEP 9.2 Advanced Search feature, which allowed search plugins for the 'Add Reference' action, was not implemented correctly. This could lead to both poor performance and invalid results when searching for nodes to link to. This has been fixed, and a hotfix is available for step-9.2-mp3.
Performance Enhancements
ISSUE-380817 - GDSN Receiver performance improvements
As part of an ongoing performance evaluation of GDSN Receiver, a new version of the GDSN Receiver (compatible with 9.3) is available. This new version contains stability and performance improvements of the CIN handling and should not have any impact on configuration or setup. To access the updated functionality on a 9.3 system, install or update the ‘gdsn2-receiver’ add-on component. Instructions for installing components can be found in the SPOT Program topic in the System Administration Guide found in Downloadable Documentation.
The handling of CIN files can now be done in parallel; the number of 'workers' can be controlled with the setting 'BackgroundProcess.Queue.<SPECIFICQUEUENAME>.Parallel=<DesiredNumberOfThreads>'. For instance, if your queue is named BMSIN, then BackgroundProcess.Queue.BMSIN.Parallel = 4 will create a pool of 4 workers. CIN files that do not impact the same product hierarchy will be started in parallel. Care should be exercised to not starve other parts of the system of resources by setting this number high. Also, adding many threads may severely influence load of the database server. The system will come with a sensible default of '2,' which should be sufficient for most cases.
In addition to the CIN file importer now having the ability to run multiple imports in parallel, a number of performance improvements have been performed as the implementation was a bit over-eagerly fetching Provider GLN, Target Market, and Receiver GLN from the setup. This was done through the component model, which can be a fairly expensive operation. As a positive side effect of the parallelization, objects from the model are now only fetched once per thread.
Also improved is the performance of importing GDSN CIN files in the GDSN Receiver in the case where each subscription in the system contains a large number of products. This is done by not creating a reference from the products to the matching subscription. Instead, the subscription that matches the product is recorded in a new externally maintained description attribute in the products. This attribute is created automatically when needed. Contact Stibo Systems Support to enable / implement this particular solution. If the system is set up to not create references, it will not be possible to view the products that are included in a given subscription using the pre-configured Web UI configuration build using the Create GDSN Receiver Web UI action on a GDSN Receiver datapool node in the STEP Workbench.
Patch Recipe
The 9.3-MP2 baseline patch can be installed with the following recipe:
spot --upgrade=step:9.3
Customers with on-premise systems: Refer to the SPOT Program documentation for more information, including how to use the SPOT --upgrade command to also find compatible components that can be added at the same time as the baseline patch in the SPOT Program topic of the System Administration Guide found in Downloadable Documentation. For assistance, contact Stibo Systems Technical Services.