EPC - 142070

Date : June 2022

EPC142070 for LANSA V14 SP2

EPC142070 ships many fixes and enhancements for V14 SP2 across the LANSA product suite. Major highlights include:

  • Required updates to LANSA for Windows 11 support in V14 SP2 (0913011)
  • The addition of support of charts as native LANSA controls, allowing developers to drag and drop them from the Controls Tab and style and manipulate them at design time in the same was as other LANSA controls (0161554)
  • Support for new AWS market place offers (0163453)
  • This EPC also ships all the latest fixes and changes shipped via hotfix and patch since the last EPC.

 

Product Visual LANSA
Version 14
Pre-Requisite Details V14 SP2 EPC142060
Special Notes All Version 14 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 used with the LANSA system to be updated.
User Actions A partition initialization of Mandatory Partition Initialization is required. 
User Actions exist for: 0162631 SELECT - ISO date key field used in startkey select crashes
See below for details.
Deployment Notes This EPC can be deployed as a patch to a previous version. A new version of the package must be have been built with V14 SP2 GA as stated in the V14 Late Breaking News page.

Instructions to install the EPC

EPC142070 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 EPC142070.EXE file from the Web site or email.
  2. Unzip (double click) EPC142070.EXE. These files will be extracted:
    • AllEPCs.exe - Windows multiple EPC installer
    • AllEPCs.ini - AllEPCs controll file
    • EPC142070 - IBM i Save file
    • wEPC142070.exe - Windows Visual LANSA install executable
    • wEPC142071.exe - Windows LANSA Communications install executable
    • wEPC142073.exe - Windows LANSA Web Server install executable

Instructions provided for:

Detailed changes

CCS id. Description
0156954 Update openssl to the later version 1.1.1d

This enhancement has been included in this EPC.
0158034
0158054 		Add events for List.CellLostFocus and List.CellGotFocus

This enhancement has been included in this EPC.
0161385 VL crashes when pulling or checking out a branch from Git

This defect has now been rectified.
0161554 Native Chart support in Visual LANSA for the Web

Visual Lansa for the Web now supports Charts as native LANSA controls.

Previously charts were done through Widgets, now you can drag and drop them from the Controls Tab and style and manipulate them at design time just like you can with all other LANSA controls.

Implementation at runtime is done through the ChartJS library, which draws directly onto the HTML5 canvas. This means it's all done in memory which doesn't require a connection to the internet, unlike the shipped GoogleChart widgets.
0162080
0768205 		Android devices not detecting data in fields

This defect has now been rectified.
0162227
0162633 		Blob/Clob files with DBCS names cause a server error in SuperServer

This relates to working lists which contain BLOB or CLOB fields being exchanged in CALL_SERVER_FUNCTION. If the BLOB/CLOB was assigned a file which had a DBCS name an error would occur.
This defect has now been rectified.
0162397 PRIM_TREE scrolling issue when item height exceeds the viewport

This defect has now been rectified.
0162528 Error MCH1210 for Export List on IBM i (very large exports)

Exports with many large WAMs and TSP/language permutations may cause a sequence counter to overflow.
This defect has now been rectified.
0162609 LANSA Runtime error when showing a popup panel more than once

This defect has now been rectified.
0162631
0162654 		SELECT - ISO date key field used in startkey select crashes

This defect has now been rectified.
User Action: 
Recompile any effected OAMs.
0162649 X_RUN error in combase.dll when closing form on Windows 2016

This defect has now been rectified.
0162656 *TIMEDATEC, *TIMEDATE, *TIMEDATE8C and *TIMEDATE8 are missing on the WEB

This defect has now been rectified.
0162696 SYS_WEB.Navigate crashes on Edge if Enterprise Mode is enabled

This defect has now been rectified.
0162714 Do not automatically delete old layout when creating new layout

This enhancement has been included in this EPC.
0162802 FilePicker shows an unwanted hint (No file chosen) on Chrome/Firefox

This enhancement has been included in this EPC.
0162808 Memory leak in PRIM_CCOL.CalculateHash stops components from being destroyed

This defect has now been rectified.
0162817 FaceName truncated when used in PRIM_THM

This defect has now been rectified.
0162827 Material Design File Picker runtime error

This defect has now been rectified.
0162831 Windows Azure VMs fail to be licensed under certain circumstances

This defect has now been rectified.
0162842 Shortcut key event handler does not work in a GRID on a Japanese OS

This defect has now been rectified.
0162844 Web Page layout is changing when pressing save button

This defect has now been rectified.
0162868 Inconsistent behaviour in Replace intrinsic in a DBCS IBMi environment

This defect has now been rectified.
0162869 Allow Session Token to be stored and shared between browser tabs

It is now possible to save and restore the session token between browser sessions through the use of the #SYS_WEB.Session object.
0162873 Field visualizations should ignore a layout's variable sizing directives

This defect has now been rectified.
0162911 Access violation error in Memo control with TypeRender=W

Value modification of Multiline edit field visual when unrealized sometimes triggered a runtime error and other times an access violation.
This defect has now been rectified.
0162926 Improve pre-V15 (openssl 1.0) connect compatibility with V15 (openssl 1.1)

This defect has now been rectified.
0162928
0163306 		Browser freezes when moving focus after adding many records to a list.

This defect has now been rectified.
0162975 Command-line build abends because of duplicate YAML files.

This defect has now been rectified.
0163009 Cannot input DBCS in memo box with NVarChar source field

This defect has now been rectified.
0163100 LceLansaCall error 'The process definition cannot be found' calling CL program.

This defect has now been rectified.
0163170 In a web page, the menu width shrinks each time popup menu is shown.

This defect has now been rectified.
0163205 strict_null_assign affected by changes for Case #155689

Original behaviour of *strict_null_assign has been restored.
0163212 The width of the calendar of MD datetime picker shrinks when down arrow clicked

This defect has now been rectified.
0163390 Visual LANSA unlicensed in AWS Windows 2016+ VMs

This defect has now been rectified.
0163453 Support new AWS Marketplace Offers - Visual LANSA

This enhancement has been included in this EPC.
0163519 IDE abend when registering a specific ActiveX control (Fijifilm Docuviewer v9.1)

This defect has now been rectified.
0163542 Support Cloud Licensing for AWS SKU lansa-scalable-stack-2

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.
0757119 A list that is larger than the viewport incorrectly scrolls the page on a click

This defect has now been rectified.
0758813
0762229 		VL Application using .NET control fails with x_run dump at runtime

This defect has now been rectified.
0760739 Incorrect alignment of text in a Web Page when using Flow Layout Manager

This defect has now been rectified.
0762297
0162824 		Multiplication operator rounding issue

Rounding inconsistencies on Windows only when rounding results of maths that use component variables with decimals.
This defect has now been rectified.
0763766 [email protected] has huge number of opens per minute on heavy load Webevent application

Option added to enable caching language level check through F23.
This option is disabled by default.
To enable, set data area [email protected] position 500 length 1 to 'Y'.
0764121
0778506 		IDE slowness: Large Reusable Parts can take a long time to close.

This defect has now been rectified.
0764368 Access Violation with AutoActions after VLF upgrade

This defect has now been rectified.
0765502 Instance list processing very slow compared to older LANSA Versions.

This defect has now been rectified.
0769841 When a BLOB is being added to a table a temporary lock is created using [email protected]

This defect has now been rectified.
0769864 #SYS_WEB.StorageChanged event can fire even when storage is not changed

This defect has now been rectified.
0776749 LANSA WAMS - Prompt & incorrectly resolves to &

Reentry fields are now retrieved using innerText instead of innerHTML. That is, any markup is ignored. The content is handled as simple text.
This defect has now been rectified.
0783922 Issues with PRIM_JSON objects - values not being parsed correctly

This defect has now been rectified.
0789269 Import on VCS system crashes

This defect has now been rectified.
0793828 Small typo in VLWEB locale JSON file for Dutch

Typo in long day Dutch translation.
This defect has now been rectified.
0794269 Issue updating text field in EditorChanged event in grid after V13

This defect has now been rectified.
0795154
0802380 		Unlicensed message on Azure deployment due to missing Telemetry Service

This defect has now been rectified.
0797941 Fatal Error when downloading the LANSA Package Manager when using v14

This defect has now been rectified.
0800778 XSS vulnerabilities found in a LANSA WAM

Context item values now scrubbed to prevent XSS injections.
0817041 Problems with #PRIM_MD.FilePicker in LANSA V14 SP2

This defect has now been rectified.
0861955
0866240 		Wrong maximum length used to check password length when password rules in use

Signon was checking maximum password length against system value QPWSMAXLEN when password rules other than *PWDSYSVAL were defined.

This defect has now been rectified.
0881793
0163514 		scalable license Azure VM Check fixed

This defect has now been rectified.
0892661 Unable to consume the LANSA Scalable License in 2016 AMI when using SuperServer

This defect has now been rectified.
0908614 snapping form to side of screen reverts to default location when 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/v14news/

This defect has now been rectified.
0936009 IDE Crash with Runtime Error while switching between Source and Design Tab

This defect has now been rectified.

Install Instructions

Special note for IBM i Power 5 hardware: Due to hardware conversion, you may experience a delay when importing from the VLF save files or on the first connection to the LANSA Listener. This conversion will occur only once.

  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 EPC142070 to an IFS folder on the IBM i ( e.g. /LANSA_pgmlib/tmp/EPC142070 )
  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 . . . . . . . . . . . > 142070
    Install the EPC from . . . . . . >*IFS
    IFS Path and object name . . . .e.g./LANSA_pgmlib/tmp/EPC142070
    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

The command LOADEPC is now available in the LANSA web server Admin library. Use the following instructions.

  1. If you haven't installed or upgraded LANSA for the Web on the Web Server, do so before proceeding with step 2.
  2. Backup all the LANSA folders, system libraries and ALL the LANSA IFS objects (LANSA_admlib/x_lansa) before applying this EPC
  3. End the Web Server and run the LANSA for the Web cleanup program. Refer to 13.5.6 Clean Up Systems in the LANSA Online documentation for cleanup instructions.
  4. Display your current library list. If QTEMP is not shown, then add it to your library list using the ADDLIBLE (add library list entry) command.
  5. Move the unzipped file EPC142070 to an IFS folder on the IBM i. ( e.g. /LANSA_admlib/tmp/EPC142070)
  6. For this EPC use the following options:
    1. Install the EPC from = *IFS
    2. Apply this EPC to = LANSA_WEB_SERVER
  7. Run the command LOADEPC with the following parameters:

    CHGCMD CMD(admlib/LOADEPC) PGM(admlib/[email protected])

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

    EPC number . . . . . . . . . . . > 142070
    Install the EPC from . . . . . . > *IFS
    IFS Path and object name . . . . e.g. /LANSA_admlib/tmp/EPC142070

    Apply this EPC to . . . . . . . LANSA_WEB_SERVER
    LANSA web server admin lib . . . . . admlib
  8. Save and then delete the backout library (iiiEPCnn where iii = 1st three characters of the LANSA pgm library and nn is sequence number) created by the install. The contents of the library may be used to backout this EPC and return your system to its previous state.
  9. 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.