Miscellaneous Notes and Bug Fixes for USoft 11.0.1H
Patch installation
When installing this patch in the production environment:
- Web publications must be updated in order to get the fixes made in this patch.
- Flat files do not have to be updated.
- Service Framework servers do not have to be updated.
Bug fixes
The identification number in front of each item is a Jira Issue ID. This is a number that USoft uses internally.
An identification number(s) in parentheses at the end of an item (if any) is a Jira Support ID. This is a number that USoft Support uses to communicate with external reporters.
AUTHORIZER
USD-7633
It was not possible to change the case of the username in the Authorizer.
This has been fixed.
DATABASE CONNECTIVITY
USD-6859 (US-1685)
Logging in with an expired password on Oracle would show a redundant RDBMS error before the error telling that the password is expired.
This has been fixed.
DEFINER
USD-7398 (US-2169)
When starting a USoft application that is under version control, such as Definer, Designer, or Delivery Manager, USoft checks whether any changes have been made in the version control repository that need to be read in. For large repositories, this process could take a long time on slower computers, significantly increasing the startup time of the USoft application.
If the underlying version control system is Git, the performance of this process has now been greatly improved.
While a USoft application is running, USoft monitors the folder used by version control. When a change is detected, the application immediately shows an information message asking the user to synchronize. This prevents developers from continuing to work and accidentally overwriting newly changed files. This monitoring process could also be slow on slower computers.
When Git is used as the underlying version control system, USoft now monitors only the .git folder. As a result, delays are greatly reduced, especially when multiple Definer or Designer sessions are running at the same time.
All Git operations that might change the contents of files or folders, such as pull, checkout, and reset, are detected by USoft. However, when files in the version control repository are changed manually, for example by using Notepad++, these changes are not detected automatically. In that situation, a manual Synchronize from the Tools menu is needed to read in the changes.
USD-7626 (US-2337)
Entering an incomplete UNION ALL SQL statement could lead to a crash.
This has been fixed.
USD-7659 (US-2354)
USoft Definer stopped working when adding a new CASE to the select list of a constraint.
This has been fixed.
USD-7668 (US-2363)
In version control, synchronizing a change that included renaming an object and all of its references could cause unexpected changes in the version control files.
This has been fixed.
Renaming a correct constraint while simultaneously changing the SQL in a way that made it invalid could result in unexpected errors.
This has been fixed.
XML.Import could sometimes report an error stating that it could not read the document, followed by garbled data.
This has been fixed.
LINUX PORT
USD-7653 (US-2350)
On Linux, the -ddfile option was missing from pc:CreApp.
This has been fixed.
SERVICE FRAMEWORK
USD-7456 (US-2214)
In the Service Definer it was not possible to derive a structure from a statement containing a SELECT with a UNION operator.
This has been fixed.
USD-7511 (US-2251)
In the Service Definer the information message about a missing default connection was not shown anymore.
This has been fixed.
WEB APPLICATION
USD-4275 (US-648)
The FileUploadControl has two new options:
- "Confirm Upload": allows you to confirm the selected files before they are set in the control for uploading.
- "Submit Upload Automatically": allows you to delay the actual uploading of files until the script
$.udb.upload('submit')is executed.
USD-7425 (US-2176)
The File Upload Control in Web Designer now also limits the files shown in the dialog with the extensions restriction set in the control in Web Designer. MIME types are also allowed to restrict the files allowed.
USD-7429 (US-2180)
The FileUploadControl could report a successful upload, while the Service Framework actually rejected the file.
This has been fixed.
USD-7544
Several improvements were made to ensure that the VariableSetDataSource works correctly with the .gotoDataSet() function, when dataset pagination is enabled for the data source, and to display its contents in a TabularGridControl.
In addition, a .toTable() function has been added to the UdbRows class to allow creating an array of non-reactive row data directly from a data source, and a .fromTable() function has been added to UdbRowSet to read this array directly into a VariableSetDataSource.
USD-7601
When changing the language of an application, it changed the language on all pages, including the previous page of a related page. This could result in error messages if it changed properties of an input control.
This has been fixed.
USD-7604
Host variables used in the WHERE clause of an embedded data source were not always properly propagated to the query that was generated by the Page Engine.
This has been fixed.
USD-7632 (US-2339)
Some old JavaScript libraries with vulnerabilities were still in use. The following changes were made:
moment.js: this library has been dropped and removed from the source, as it was largely obsolete and its functionality had been absorbed by native JavaScript functionality.bootstrap: all Bootstrap libraries have been updated to their latest released versions.
WEB DESIGNER
USD-7673 (US-2368)
When synchronizing in version control, controls would sometimes swap from update to delete, or the reverse.
This has been fixed.
WINDOWS APPLICATION
USD-7694 (US-2375)
Using host variables in RulesEngine.MustExistExecuteStatement() led to an application crash.
This has been fixed.