EPC - 150040

Date : July 2021

EPC150040 for LANSA V15

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

Product	Visual LANSA
Version	15
Pre-Requisite Details	V15 EPC150030
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: 00163183 Demo Tables converted single-byte Kana to double-byte Kana. For Visual LANSA, a partition initialization of Sample Material is required. Refer to Visual LANSA Partition Initialization for more information. For LANSA for i, an import of *WEBDFLS* (Sample Materials) must be performed from the Administration/Partition Initialization menu. User Actions exist for: 0886307 Simple web test page has been modified to show the current root directory. For Visual LANSA, a partition initialization of Mandatory Partition Initialization is required. Refer to Visual LANSA Partition Initialization for more information. For LANSA for i, an automatic partition initialization of WEBINIT is submitted at the completion of the EPC150040 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

EPC150040 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.

Download EPC150040.EXE file from the Web site or email.
Unzip (double click) EPC150040.EXE. These files will be extracted:
- AllEPCs.exe - Windows multiple EPC installer.
- AllEPCs.ini - AllEPCs control file.
- EPC150040 - IBM i Save file.
- wEPC150040.exe - Windows Visual LANSA install executable.
- wEPC150046.exe - Windows LANSA Integrator install executable.

Detailed changes

EPC150040 includes these changes

CCS id.	Description
0157907	NotFoundError occurs on Popup panel ClosePopup if parent was changed This defect has now been rectified.
0163128	The calendar in Accident Assessment has overlapping text for French This defect has now been rectified.
0163207 0163208 0795154 *	Unlicensed message on Azure deployment due to missing Telemetry Service This defect has now been rectified.
0163254	Cannot select or put focus on certain elements when base panel has dragstyle auto This defect has now been rectified.
0163280 0163385 *	Error 0x11 connecting Web Administrator with Windows user with space in password This defect has now been rectified.
0163295	Prompter ellipses disappear after selecting a value from the prompter This defect has now been rectified.
0163302	Sort order in VL Web list (#PRIM_LIST) is different to SQL sorting for Japanese This defect has now been rectified.
0163343 0163378 *	Heading rows do not match data when exporting data to excel from a #PRIM_LIST This defect has now been rectified.
0163350	Picklist value property handling in IDE is problematic This defect has now been rectified.
0163365	Row position changes when editing a non-sorted column in a list This defect has now been rectified.
0163371 0163183 *	Convert single-byte Kana to double-byte Kana for IDE This enhancement has been included in this EPC.
0163372	Access violation when CloseUp and KeyPress events trigger reload of ComboBox This defect has now been rectified.
0163376 0163378 *	Runtime error occurs when using Export of PRIM_LIST with a columnvisible(false) This defect has now been rectified.
0163377 0163378 *	Export of list with data in Editcode W fields results in a corrupt excel file Edit mask for Editcode W is custom and needs to have "/" escaped. This defect has now been rectified.
0163389 0163390 *	Integrator unlicensed in AWS Windows 2016+ VMs This defect has now been rectified.
0163390 0163389 *	Visual LANSA unlicensed in AWS Windows 2016+ VMs This defect has now been rectified.
0163391	Application layout changes in V15 EPC150030 This defect has now been rectified.
0163392 0163378 *	Runtime error when exporting paged list with Virtualization(None) This defect has now been rectified.
0163395	Enhancements to Mobile Web Application templates related to routing This enhancement has been included in this EPC.
0163396	Server Routine with Response(*Webpage) not working in EPC150030 This defect has now been rectified.
0163401	IDE does not recognise that an incorrect value is passed for Round method This enhancement has been included in this EPC.
0163430	VL Web runtime fails after replacing deprecated AppCache with Service Worker This defect has now been rectified.
0163431 0160046 *	Sometimes the Half-width Kana fixes included in EPC150030 are not applied All *.BNB files are now deleted as part of the EPC install process.
0163440	Tables with Japanese descriptions are deployed correctly but file data cleared The file data processing option on tables in a Deployment Package are now saved and processed as expected.
0163443 0873998 *	Check In of web page fails with .appcache file missing message This defect has now been rectified.
0163446	when *SQLNULL is set for a date field in a grid, value defaults to 1900/01/01 This defect has now been rectified.
0163448	Only include checked logical views when loading IBM i Other files into VL Only selected logical views are loaded when importing Tables from IBM i. Previously all logical views were loaded regardless of selection.
0163453 0163454 *	Support new AWS Marketplace Offers - Visual LANSA This enhancement has been included in this EPC.
0163454 0163453 *	Support new AWS Marketplace Offers - Integrator This enhancement has been included in this EPC.
0163456	Editor crashes when selecting the function's design tab This defect has now been rectified.
0163457	Compiling SORT_LIST of a working list with more than 199 fields fails This defect has now been rectified.
0163458	Checking in a web page with no icon causes web images to be deleted on IBM This defect has now been rectified.
0163464	Browser messages with checked in webpage with a web app manifest icon This defect has now been rectified.
0163493	IDE *NullReference error when deleting Web API Schema Property This has been rectified.
0763042	ListFields using both identfier and long name are not populated during Add_Entry This defect has now been rectified.
0777551	Input of a caption in the last line of picklist value shows double text This defect has now been rectified.
0791911	Expenses web sample provided fails to compile in French VL This defect has now been rectified.
0801635	V15 Missing Feature Help - Raise Button, SizeTo method This enhancement has been included in this EPC.
0809830	Search build log viewer in deployment tool does not scroll to highlighted entry This defect has now been rectified.
0818950	Function using XMLBindFileService fails with "UTF-16 failed to convert to UTF-8" This defect has now been rectified.
0858825	Popup menu for views referenced in documentation but not in the IDE This defect has now been rectified.
0867033	Changes for locale-nl.json for Dutch language Uur -> Uren, Minuut -> Minuten, Seconde -> Seconden Oct -> Okt dateFormat: dd-MM-yyyy timeFormat: hh:mm:ss tt startOfWeek: Maandag dateLongFormat: DDD D MMMM YYYY dateDayMonthFormat: DDD D MMM decimalPoint: , thousandsSep: .
0870371	Editing descriptions and names of properties in the web api schema is very slow This defect has now been rectified.
0870404	The API Definition section in REST Services Server modules often crashes This defect has now been rectified.
0871665	#Prim_Web page gets reloaded every time the page changes size in V15 This defect has now been rectified.
0873514	Performance and memory issues with large data sets in .NET components Some memory leaks were discovered and have been plugged. How code is structured in RDML may also assist in better memory management. Memory usage may be improved if units of work are done in reusable parts rather than all work done in a single Form or Function. When the reusable part is completed (and removed from memory) then it will drop references to .NET components used inside of it allowing the garbage collector to free the memory.
0873998 0163413 0163443 *	Deployment package that includes web pages fails to build in EPC150030 This defect has now been rectified.
0875211 0874068	Adding packed fields produces incorrect results on IBM i This defect has now been rectified.
0875729	LANSA Event Log Manager shows unexpected entries for DPINSTALL DPINSTAL.LOG will only be registered in the LANSA Event Log if it actually exists in the specified location. Existing unexpected entries in the LANSA Event Log will remain there, but only expected entries will be added from now on.
0877205	Not possible to load Public Key from PRIM_CAPI.PublicKey LoadPEMFile method This defect has now been rectified.
0877331 0163394	Failed to execute RemoveChild on Node error after apply EPC150030 This defect has now been rectified.
0877777	Unable to execute "My first VL Web application" in French environment using wizards with EPC150030 After applying EPC150030 on a French system you were unable to execute "your first VL Web application" using the Wizards, an error HTTP 404 occurs. This defect has now been rectified.
0878833	The default redirect routing not redirecting to /home if .html at the end of URL This defect has now been rectified.
0881793 0163473 *	scalable license Azure VM Check fixed This defect has now been rectified.
0882437	Selecting item from popup aborts after applying hotfix to V15 EPC150030 This defect has now been rectified.
0882609	Popup menus are displaying with a gap between last row and border This defect has now been rectified.
0885218	#SYS_WEB.DeviceChanged is fired multiple times when changing device This defect has now been rectified.
0885659	Quick rules have been removed from fields non-RDMLX fields types Quick Rules are no longer available to be applied to non-RDMLX fields
0885724	IO Performance drops with nVarchar greater than 6546 characters This defect has now been rectified.
0886008	Runtime error in VL Web dropdown after upgrading to EPC150030 This defect has now been rectified.
0886176 0887142	Using F1 on intrinsics in the VL editor gives 404 page not found error This defect has now been rectified.
0886307	Simple web test page has been modified to show the current root directory The simple web test page, used to verify an application server is running, has been modified to show the current root directory instead of the program library. User Action: A partition initialization of option "Mandatory Partition Initialization' is required for this change to be implemented.
0887776 0888727	Fatal null_reference error building web template with table with no key fields null reference error has been resolved.
0888847	Crash in Date Control after clicking first entry, typing in a day and tabbing This defect has now been rectified.
0163486	Runtime error 'Cannot read property 'Ek' of null' occurs when clicking in a cell after setting its value via code. This defect has now been rectified.
0892097	Setting a #PRIM_LIST.DateTime column to SQLNULL causes runtime error This defect has now been rectified.
0894116	Changing partition's details causes all objects to be marked requiring compile. When a partition's details have been changed and the YAML file for that partition has been committed and pulled by another VL configuration, it was causing the "Build Status" for all objects in that partition to be changed to "Build and Compile required". This defect has now been rectified.
0890324	Tabs content does not disappear in VL WEB V15 This defect has now been rectified.
0890503 0894309	IDE crash while editing files A null reference error was being generated in various scenarios assocaited with LEH object in IDE. This has been rectified.
0892129	Offline support details not stored in YAML This defect has now been rectified.
0893783	Other file compile IOM fails on IBMi after checkin IBM i tables loaded into VL which include long names on columns were being truncated. This causesd IOM to fail compile when checked into IBM i. This has been rectified.

Install Instructions

Instructions for installing on IBM i

Sign on with QSECOFR user profile or a user that is part of the QSECOFR group.
Backup all the LANSA folders, system libraries and ALL the LANSA IFS objects (LANSA_pgmlib/x_lansa) before applying this EPC
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.
To check for active users refer to How to check for Active Users.
Move the unzipped file EPC150040 to an IFS folder on the IBM i ( e.g. /LANSA_pgmlib/tmp/epc150040 )
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 . . . . . . . . . . . > 150040
Install the EPC from . . . . . . >*IFS
IFS Path and object name . . . .e.g./LANSA_pgmlib/tmp/epc150040
Apply this EPC to . . . . . . . FULL_LANSA_SYSTEM
LANSA program library . . . . . pgmlib
Use DSPJOBLOG OUTPUT(*PRINT) to save a job log record of what the LOADEPC command did.
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

Instructions for installing on Windows

It is recommended that a backup be done of all LANSA folders and your LANSA database before applying this EPC.
Stop using the LANSA development environment and stop all currently executing LANSA applications.
Right click on AllEPCs.exe and 'Run as Administrator'.
Select the "Setup" button or "Cancel" if you do not want to proceed.
If you have multiple configurations installed, select the configuration to which the EPC is to be applied.
If you are prompted to reboot your pc - please reboot.
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.
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.