EPC - 150050

Date : September 2022

EPC150050 for LANSA V15

EPC150050 ships fixes and enhancements for V15 across the LANSA product suite.

Product Visual LANSA
Version 15
Pre-Requisite Details V15 EPC150040
Special Notes All Version 15 Visual LANSA EPCs include updates that must be applied to Windows and IBM i systems (Independent Visual LANSA development environments only require the Windows updates). Failure to upgrade both sides of a development environment will render the Host Monitor and Super Server applications inoperable. Attempting to use the Host Monitor and Super Server applications without having applied the EPC to both sides of a development environment will generate an EPC mismatch error.

Make a full backup of your LANSA environment on each platform to which this EPC will be applied.
IBM i Specific Special Notes The IBM i instructions are expedited procedures that assume a sound knowledge of IBM i.
You must use a user profile that is QSECOFR or part of the QSECOFR group.

The restore command parameter FRCOBJCVN used by the Install/Upgrade/LoadEPC process uses FRCOBJCVN (*YES *RQD). Because of this, the QFRCCVNRST system value must have a value of 0, 1 or 2.

You must end the web server and run the LANSA for the Web cleanup program before applying this EPC.

You must end the Listener and Host Monitor if active.

You must end the LANSA Integrator server if it has been installed with the LANSA system to be updated.
User Actions User Actions exist for: 0163592, 0163608, 0163593.
For LANSA for i, an automatic partition initialization of CSP and WXT are submitted for affected partitions at the completion of the EPC150050 install.
Deployment Notes This EPC can not be deployed as a patch to a previous version. A new version of the package must be have been built with V15 GA as stated in the V15 Late Breaking News page.

Instructions to install the EPC

EPC150050 includes software to be installed on an IBM i machine and on a Windows machine. These instructions describe the installation and use of all delivered items.

  1. Download EPC150050.EXE file from the Web site or email.
  2. Unzip (double click) EPC150050.EXE. These files will be extracted:
    • AllEPCs.exe - Windows multiple EPC installer.
    • AllEPCs.ini - AllEPCs control file.
    • EPC150050 - IBM i Save file.
    • wEPC150050.exe - Windows Visual LANSA install executable.
    •  wEPC150051.exe - Windows LANSA Communications install executable.
    • wEPC150053.exe - Windows LANSA Web Server install executable.
    • wEPC150056.exe - Windows LANSA Integrator install executable.

Instructions provided for:

Detailed changes

CCS id. Description
0163593 Request to include LongRange license into AWS Scalable license

This enhancement has been included in this EPC.

User Action: After applying EPC150050, you must request an updated Longrange object in order for the Longrange scalable license to work in AWS. Request u_bif984.dll from your local LANSA support representative.
0163286 Improve UTF8 support in Deployment Tool

Improved UTF8 support in the Deployment Tool to provide better interface experience for Japanese.
0163303
0163524
TouchSize property of textarea not working as expected

This defect has now been rectified.
0163326 VCS: Objects with duplicate YAML files can cause confusion with Git Status

This defect has now been rectified.
0163366 Paste of SBCS & DBCS of exact same length as field incl SO/SI bytes crashes

This defect has now been rectified.
0163378 Exported excel file contains mixed fonts, without any observable pattern

This defect has now been rectified.
0163388 SQLNULL date/numbers do not display empty when exporting to Excel, PDF and CSV

They are now displayed similar to how they appear in the list.
0163397
0163425
Export to CSV not handling quotes or commas in cell values

All edit masks for numbers are removed (only decimal separator remains) as export to CSV is a data export (no formatting). Text with quotes and commas are now handled according to CSV rules.
0163398 Prompter visualization on a grid is not displayed in certain circumstances

This defect has now been rectified.
0163415 List EPCs and Patches in the EPC log by date applied, not by numbered sequence

EPC Log and Imports Log now sortable by date or name.
0163441 Date display is out by 1 day when exporting *SQLNULL to Excel using #List.Export

Workaround implemented to bypass defect in ExcelJS third party library.

This defect has now been rectified.
0163459 Support logical files in the New Server module / Application template

This enhancement has been included in this EPC.
0163462 After displaying and closing a message box from a dialog, focus is not returned

This defect has now been rectified.
0163483 Horizontal scroll bar does not follow focus cell when tabbing or pressing enter

This defect has now been rectified.
0163485 Objects set to null / Unrealized take a long time to disappear

This defect has now been rectified.
0163505 Clicking on prompter button on field on web page causes IDE to crash

This defect has now been rectified.
0163508 Cannot use Host Monitor after changing SBMJOB command default to MSGQ(*WRKSTN)

Create and compile batch jobs, import/export and Host Monitor in LANSA now specify explicitly to send the messages to the user profile. The RDML SUBMIT command has the same change. This is to overcome problems in sites that override the IBM i supplied SBMJOB command to a value different to the IBM default *USRPRF.
0163516 ExpanderPanel PrivateStyle is not working as expected

This defect has now been rectified.
0163518 Add support for Ctrl+A (select all) in VL Open dialog

Select all shortcut Ctrl+A is now supported in the Open dialog.
0163519 IDE abend when registering a specific ActiveX control (Fujifilm Docuviewer v9.1)

This defect has now been rectified.
0163521 Caption of field can get truncated for picklist if caption is longer than field

This defect has now been rectified.
0163529 webmodules.conf has conversion issues after check-in to French IBM i

This defect has now been rectified.
0163537 Numbers in fields with no edit code are displayed blank in exported Excel file

This defect has now been rectified.
0163539 CSP: Need to add *.gstatic.com to list of sites for allowable styles

Domain *.gstatic.com added to allowable style source.
0163542 Support Cloud Licensing for AWS SKU lansa-scalable-stack-2

This defect has now been rectified.
0163550 Events not fired as expected when using Enter to move around list

This defect has now been rectified.
0163551 Menu bar not shown the second time a modal form is shown

This defect has now been rectified.
0163553 Error not issued on DEF_ARRAY if RDMLX field used in OVERLAYING

This defect has now been rectified.
0163568 Support BitShiftLeft and BitShiftRight intrinsics

This enhancement has been included in this EPC.
0163577 Enhancements to generated Web Page for routing template

Minor enhancements to interface and template used to generate a new Web Page with Routing
0163581 Images in a Web App are not deployed

This defect has now been rectified.
0163583 Error 0211 (DBCS string too long) error for DBCS shift J field

This defect has now been rectified.
0163585 AWS EPC Check error due to insufficient rights to enumerate services

This defect has now been rectified.
0163586 Using Tab navigation in list view hides the column header

This defect has now been rectified.
0163587 VL editor crash opening a Reusable Part with "Target render Type" set to Win32

This defect has now been rectified.
0163592 Upgrade jQuery UI to version 1.13.0

Upgrade to enable jQuery UI to work with jQuery 3.6.0.

User actions: If you use jQuery for your own Javascript code, you may need to make changes due to jQuery deprecating functions and features.
0163593 Request to include LongRange license into AWS Scalable license

This enhancement has been included in this EPC.
0163605 Upgrade CKEditor to version 4.17.1

CKEditor upgraded to version 4.17.1
0163606 Upgrade jQuery File Upload to version 10.32.0

jQuery File Upload plugin upgraded to version 10.32.0
0163608 Upgrade json-js to version 2019-08-25

json-js is a shim that was initially shipped with LANSA to support outdated browsers such as IE8. As the most dated browser in our supported platforms already defines the native Javascript JSON object, this shim is no longer required. We have updated it to its current release in case users are including it as it is shipped as an external resource.

User actions: Remove json-js from your WAMs as it is no longer needed. LANSA plans to remove this external resource in a later release.
0163615 Tabstop order is incorrect when editing Process's [Attachments]

This defect has now been rectified.
0163619 Upgrade big-js to version 6.1.1

big-js version upgraded
0163621 Add IASP details to LANSA About

IASP details added to LANSA About. OSU library (no longer shipped) removed.
0163657
0163691
V15 Listener can look for a license file with the wrong extension.

This defect has now been rectified.
0163658
0935632
#PRIM_LIST.DropdownColumn shows selected value only when focus is lost

This defect has now been rectified.
0163673 Remember size for Import dialog in IDE

The Import dialog nows opens to the same size as last opened.
0163682
0961641
IDE crashes when selecting a specific ActiveX (QRMakerAD)

This defect has now been rectified.
0163686 Prompter weblet display position is wrong after upgrade from V13 to V15

Prompter window was not taking into account the scrolled position of the prompter button.
This defect has now been rectified.
0163697 Japanese description of User Name in 'Connect to Remote System' is corrupted

Japanese translation provided for User Name in Remote Connect dialog.

This defect has now been rectified.
0163704 Excel file created by list export is corrupted if the list has Edit Code 'A'

This defect has now been rectified.
0163709 Warning message 'extended identifier XG_... remains unexpanded' in editor

This defect has now been rectified.
0163715 IDE abends with unquoted FaceName value

This defect has now been rectified.
0163716 Modernise images on Home page and Welcome page

This enhancement has been included in this EPC.
0163718 "Dragstyle(Automatic)" for list change behavior of checkbox with Material Design

This defect has now been rectified.
0163733 IDE crash when server module API and Data Model tabs use MasterOnly field

This defect has now been rectified.
0163750 The caption of list dropdown is truncated

This defect has now been rectified.
0163753 The second message box on a webpage does not get the focus

This defect has now been rectified.
0163763 VCS cmd line compile defects

1. Tables using the partition default library were always flagged as errors
2. Errors used the Alternate Name which did not always exist for an object
3. Logic for detecting whether an object was compiled was incorrect (and still needs more changes)
4. Derivation of the executable name did not implement the correct algorithm. Foreign language replacements for @#$ were not accounted for and 1st character replacement was not correct.
5. Enhancement - added list of objects skipped
6. Reporting on object state when an object was skipped/filtered out.
7. Make compile.cmd completely prompt free
8. Clarify log file locations in logging messages
0163769 XSL Editor: Customizer dialog window not large enough for content

This defect has now been rectified.
0163773 Upgrade jQuery for LANSA:XHTML to version 3.6.0

jQuery Core for Technology Service LANSA:XHTML upgraded to version 3.6.0

Note that jQuery Core for Technology Service LANSA:JQMOBILE remains at version 1.12.4 as version 3.6.0 is not compatible with jQuery Mobile. The jQuery Mobile project is no longer supported: https://jquerymobile.com/
0163779 Tab panels custom property editor buttons not rendering correctly

This defect has now been rectified.
0163780 Editing the disabled property of an inline checkbox throws a JS error

This defect has now been rectified.
0163785 EPC/hotfix and upgrade backout libraries not created in the correct IASP

This defect has now been rectified.
0163789 Required imports not available in partition init option for new RDML partition

List of imports for an RDML multi-lingual partition was incomplete. This defect has now been rectified.
0163792 When hovered over, the first row of DropDown is retrieved as the CurrentItem

This defect has now been rectified.
0163800 Control using FixedPosition(True) is not correctly positioned by table layout

This defect has now been rectified.
0776316 Messages cleared when XPrim_JSONObject is destroyed - may clear app messages

This defect has now been rectified.
0779784 Issues when deleting and recreating an object with same long name

This defect has now been rectified.
0789092 Allow user to cancel from the version control dialog

This provides the ability to cancel long running jobs or to cancel from a job which gets into a state which requires user input.
0793465 Saving resuable part window positioned before field visualisation window

This defect has now been rectified.
0800080 V15 Logon dialog Help link shows as V14 documentation

This defect has now been rectified.
0808501 If a password contains '%' the Sys Init fails with Character '%' not valid error

This defect has now been rectified.
0817904 ThemeDrawStyle applied to dropdown list is not correctly applied to items

This defect has now been rectified.
0877875 Cannot scroll a webpage on mobile until a field is touched to set focus to it.

This enhancement has been included in this EPC.
0886669
0896104
File checked in from IDE has incorrect field labels when viewed from RUNQRY

This defect has now been rectified.
When checking in a file definition, errors will now be returned for fields in the file definition that are not yet defined in the repository and labels will be blank for those fields.
Before checking in a file definition, ensure all file field definitions are checked in.
0891407 Cannot run SELECT_SQL on @@RRNO column - both #@@RRNO and X_RRNO fail

This defect has now been rectified.
0892366 Cannot perform multiple installations of the same web application on same server

This defect has now been rectified.
Note the following.
This has been tested using the currently logged on user as the webuser too. E.g. if logged on as user1 then the webuser is also user1. Other combinations may work. If they seem not to then you need to reproduce the issue using this test case in order to receive support.
The user (e.g. user1) must be given dbowner rights to the database so that tables can be created.
The install will create a USER DSN for the current user. If the webuser is different then you must log on as that user and manually create a User DSN.
The steps are:
1. Open an Administrator command prompt
2. Install as user that is the web user and has db_owner rights to the database
1. Install to a different directory
2. Install to a different database
3. Specify the current user on the web user dialog with the correct password
4. Next available ports will be used, or choose to configure the ports yourselves
3. Do not need to Create User DSN as same user being used
4. There is no System DSN to delete
5. Change the Webalias as appropriate - .\run\conf\lansaweb.conf

When uninstalling, ensure the uninstall is ALSO run from an administrative command prompt.

A test has been performed where 5 separate installs were done. All had data entered which was not visible to any of the other installations. When 1 application was uninstalled, the rest still ran correctly after the uninstall (IIS has to be stopped during installs and uninstalls). Installing the same application again to the same database showed the data as it was before the uninstall.
Default ip ports were used for all installs. (V15 install auto detects ports in use and uses the next free port in sequence)
0892661 Unable to consume the LANSA Scalable License in 2016 AMI when using SuperServer

This defect has now been rectified.
0895419 Text size for the field caption in a Dialog changes between fields

This defect has now been rectified.
0895470 New View does not create required Notes and Attachments code or icons

This defect has now been rectified.
0895913 Update request to add more material design icons

Latest set of Material Design Font Icons incorporated into IDE and VL-Web Runtime.
0896629 Embedded page gets stuck on loading when using service workers

This defect has now been rectified.
0897402 Unable to use own icon in a PWA application

This defect has now been rectified.
0897638 Prim_list - Virtualization(Page) causes blank items to be shown

This defect has now been rectified.
0898059 HHMM format for AsTime intrinsic and HH:MM and HH:MM AM/PM for AsDisplayString

Added HHMM and HHsMM as AsDisplayString, AsNumber and AsTime options.
Added CustomDisplayString to Date and Time data classes to enable more formatting that includes AM/PM options.
Enabled CustomDisplayString for Date, Time and DateTime on the web.
0898976 Failure to export list to PDF when list contains a hidden column

This defect has now been rectified.
0899434 Drag and drop a component to a Web Pages resource tab incomplete

Server Modules can now be added to the Resources tab of a Web Page
0900669 Can no longer drag and drop on Mobile devices after applying EPC150040

This defect has now been rectified.
0903064 Details properties tab needs vertical scroll bar for SM, API, Schema Properties

This defect has now been rectified.
0903176
0910789
0953620
PWA icon not being recognized or used after applying EPC150040

This defect has now been rectified.
0903704 ButtonDefault not working with EPC150040

This defect has now been rectified.
0903911 Enhance the Go To feature to separate the different types of routines

This enhancement has been included in this EPC.
0905154 For PWA, not possible to configure an Icon for "homescreen" on iOS

This defect has now been rectified.
0908614 Snapping form to side of screen reverts to default location with CLR_MESSAGE use

This defect has now been rectified.
0913011
0915531
0163739
0948840
Partition Init errors and web execution errors after upgrading to Windows 11

After upgrading from Windows 10 to Windows 11, all web connections to the D/A server generate a 404 error.
Errors are also issued for select imports in the Partition Initialization. Refer to the entry in https://www.lansa.com/support/v15news/

This defect has now been rectified.
0917706 No help available when pressing F1 on the Create a new web page (with routing)

This defect has now been rectified.
0921291 V15 API response times out and fails to send the data > 8MB in Model B

This defect has now been rectified.
0922680 IBM i OTHER file with many join logicals slow to load in V15

Checkboxes have been added to allow for the selection of Logical Views to be imported and to show any Join Logicals. Join Logicals are not available to be imported.
0925095 Using the source parameter for #prim_md.ListEdit will crash IDE

This defect has now been rectified.
0928012 LANSA V15 fails to compile components due to Fatal Crude Complexity Rating

Option to "Suppress FATAL Crude element Complexity Rating in function" is now supported in VCS environment.
0936009 IDE Crash with Runtime Error while switching between Source and Design Tab

This defect has now been rectified.
0939470 V15 WebService failure if size of characters in base64 field increased

This defect has now been rectified.
0940109 PRIM_SOND unable to clear or reset file name

This defect has now been rectified.
0943917 Runtime error when loading a view containing #PRIM_LIST.DropdownColumn

This defect has now been rectified.
0944117 JSON reader is interpreting the Number Property incorrectly

This defect has now been rectified.
0946503 Importing a web page from a MySQL environment shows the web page as a field

This defect has now been rectified.
0948620 APIs and Blobs: file name is being sent as string not as a base64 blob

Issue addressed with the following enhancements:
1. Fragment string handler used by #PRIM_JSON.Reader for tokens longer than 64K
2. New method TokenAsBase64BinaryFile added to #PRIM_JSON.Reader
3. New features IsStringChunked and AsBase64BinaryFile added to #PRIM_JSON.Node
4. Web API formats 'Byte' (existing) and 'BytesAsObject' (new) support Base64 data for BLOB(s) in operation request and response payloads.

Install Instructions

  1. Sign on with QSECOFR user profile or a user that is part of the QSECOFR group.
  2. Backup all the LANSA folders, system libraries and ALL the LANSA IFS objects (LANSA_pgmlib/x_lansa) before applying this EPC
  3. You need exclusive use of the LANSA system before applying the EPC. You must end the Listener, Host Monitor and Web Server for the LANSA system and run the LANSA for the Web cleanup program.
  4. To check for active users refer to How to check for Active Users.
  5. Move the unzipped file EPC150050 to an IFS folder on the IBM i ( e.g. /LANSA_pgmlib/tmp/epc150050 )
  6. To apply this EPC, run the command LOADEPC with the following parameters:

    pgmlib/LOADEPC and press command 4 (F4) to prompt the command (can be run in batch)

    EPC number . . . . . . . . . . . > 150050
    Install the EPC from . . . . . . >*IFS
    IFS Path and object name . . . .e.g./LANSA_pgmlib/tmp/epc150050
    Apply this EPC to . . . . . . . FULL_LANSA_SYSTEM
    LANSA program library . . . . . pgmlib
  7. Use DSPJOBLOG OUTPUT(*PRINT) to save a job log record of what the LOADEPC command did.
  8. Sign off and then on again before commencing the next installation, e.g.:
    • to apply this EPC on another LANSA system
    • to apply another EPC on the same LANSA system
  1. It is recommended that a backup be done of all LANSA folders and your LANSA database before applying this EPC.
  2. Stop using the LANSA development environment and stop all currently executing LANSA applications.
  3. Right click on AllEPCs.exe and 'Run as Administrator'.
  4. Select the "Setup" button or "Cancel" if you do not want to proceed.
  5. If you have multiple configurations installed, select the configuration to which the EPC is to be applied.
  6. If you are prompted to reboot your pc - please reboot.
  7. Once the EPC has been successfully applied, review the User Actions in this page and perform any mandatory tasks or actions listed in this section.
  8. To check if this EPC has been successfully applied or to view details of all installed EPCs, check the Product Information and review 8.7.2 Installation Details.

© 2020 LANSA