EPC - 150030

Date : February 2021

EPC150030 for LANSA V15

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

  • This EPC ships support for Progressive Web Apps (PWAs), allowing VL Web to use service workers and providing the ability to generate a web app manifest utilizing the power of Visual LANSA's hybrid low-code. 
  • Further enhancements and streamlining of the Web Services API offering based on customer feedback and requests.
  • The conversion of single-byte Kana to double-byte Kana in the IDE for a more consistent and modern look when running in Japanese.
  • All EPCs include all the latest fixes and changes shipped via hotfix and patch since the last EPC.
Product Visual LANSA
Version 15
Pre-Requisite Details V15 EPC150020
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: 0163243 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.
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

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

Instructions provided for:

Detailed changes

CCS id. Description
0150057 Remember last value for Table Schema on Import dialog

Last used value for Table Schema is remembered when Import dialog is opened again.
0161308 Enhance VL WEB to use a Service Worker

This enhancement has been included in this EPC.
0161633 PWA support: Generate a Web Manifest

This enhancement has been included in this EPC.
0163126
0795605
0790554 *
Tables whose schema name contains an á cannot be committed to version control

This defect has now been rectified.
0163183
0163243 *
0163371 *
Convert single-byte Kana to double-byte Kana for IDE

This enhancement has been included in this EPC.
0163271
0163043 *
0163325 *
LANSA Event Log: Enhance LANSA Log Event system.

Ability to filter on filename added.
0163287 Expose Quick translate option

A Quick Translate option has been added to the right click menu for repository objects.
0163329 Error when exporting list data to Excel for the first time

Javacript file with icon fonts was missing from spreadsheet fonts subdirectory. This defect has now been rectified.
0163333 VL-Web application runs with <html lang="en"> despite language set to JPN

This defect has now been rectified.
0163352 Web page service worker js and web manifest file not created when checked in

This defect has now been rectified.
0799716 Modifying an object causes it to be unexpectedly deleted

In a Version Control configuration, if an object was modified and committed, it may have resulted in Visual LANSA deleting the object.
This defect has now been rectified.
0819033
0859645
Server modules with Web APIs defined generate invalid YAML in VCS environment

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.
0864593
0163334 *
Path traversal exploit possible in VL Web

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

    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.

© 2020 LANSA