EPC - 150010

Date : 15 May 2020

EPC150010 for LANSA V15

EPC150010 ships many fixes and enhancements for V15 across the LANSA product suite. Major highlights include

  • A new wizard for both forms of SELECT_SQL in RDMLX has been included in this EPC.
    Refer to the online documentation for details.
  • Several Web API template improvements have been implemented. Significant improvements include implementing security options in the Web API template, improvements to the handling of files with null fields and making Values for the Media Types parameter available in a dropdown.
  • All EPCs also ship all the latest fixes and changes shipped via hotfix and patch since the last EPC. Refer to the Detailed Changes list in this document for details.
Product Visual LANSA
Version 15
Pre-Requisite Details V15
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 A partition initialization of Mandatory Partition Initialization is required. For Visual LANSA, to avail of the latest shipped samples, a partition initialization of Sample Material is required. Refer to Visual LANSA Partition Initialization  for more information.
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

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

Instructions provided for:

Detailed changes

CCS id. Description
0161140 Create a wizard for both forms of SELECT_SQL in RDMLX

This enhancement has been included in this EPC.
Refer to the online documentation
"https://docs.lansa.com/15/en/lansa015/index.htm#lansa/select_sql_wizard.htm">SELECT_SQL Wizard
0163037 Web API definition - Provide a drop down of possible values for Media Types

Values for the Media Types parameter are now available in a dropdown.
0163049 Web APIs - improve handling of files with null fields

Improved handling of table fields when generating Web APIs from the template
0163066 Web Administrator improvements

Web Server Extension logging level can now be set using the Web Administrator.
0163073 Update openssl to the latest version 1.1.1g

This enhancement has been included in this EPC.
0163079 IBM i CGI fails if performance logging is enabled

This defect has now been rectified.
0163082 Compile failures for sample web applcations in non-English OS

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

This defect has now been rectified.
0163104
0163085
Fatal error when starting package manager - unable to download the application

Package manager can now be lauched without error.
0163115 Remove Used Car Tutorial URL from the V15 Free Trial version

This enhancement has been included in this EPC.
0163117 LANSA Event Log: Add files to log.

This enhancement has been included in this EPC.
0163119 Quick Rule for Date after today, Date before today has incorrect messages

Date quick rule captions have been fixed for the Japanese language
0163120 Caption for Quick Rule definition >= 0 shows > 0

This defect has now been rectified.
0163121 Japanese message for Quick Rule Valid Password is too long to be saved

Message for password quick rule has been shortened in Japanese
0163125 Japanese characters cannot be input in the Contact Us view for web templates

This defect has now been rectified.
0163129 Command line compilation fails

Command line compilation was failing on systems not using DD/MM/YYYY date format or if LANSA was installed into a path containing spaces or brackets eg "c:\Program Files(x86)\lansa"
This defect has now been rectified.
0163132 Security options have been implemented in the Web API template

Security options can now be selected and generated when executing the Web API
0789353 Compile errors after syncing VCS large repository to V15 environment

This defect has now been rectified.
0789488 Second execution of program that consumes webservice fails

This defect has now been rectified.
0789661 Web SCRUD templates initializing search string when switching between views

This defect has now been rectified.
0790514 In-line prompting for server module definitions not working

This defect has now been rectified.
0790554 "Show Changes" does not work if object is in a folder whose path contains spaces

This defect has now been rectified.

Affected objects

Object NameObject Type
EPC150010
compile.cmd \lansa
lansa.exe \lansa
liio.dll \lansa
liiosrv.dll \lansa
liiv.dll \lansa
liiverinfo.dll \lansa
liiy.dll \lansa
lp.bnd \lansa
lpcmn*.bnd \lansa
lpcr*.bnd \lansa
lxclisg.dll \lansa
x_base.dll \lansa
x_cbc1.dll \lansa
x_cbc2.dll \lansa
x_cbv1.dll \lansa
x_cbv2.dll \lansa
x_dnp.dll \lansa
x_dom.dll \lansa
x_netdnp.dll \lansa
x_prim.dll \lansa
x_rdrCbv140.dll \lansa
x_rdrCbv240.dll \lansa
x_rdrvo40.dll \lansa
x_res.dll \lansa
x_rom.dll \lansa
x_var.dll \lansa
*.* \lansa\imports\DeveloperPack
*.* \lansa\imports\std_data
*.* \lansa\imports\std_file
*.* \lansa\imports\std_widgets
*.* \lansa\imports\WebSampleApps
x_cpu.exe \NetworkClient
InstallExtensionsU.dll \tools
LANSAEventLog*.* \tools
x_cpu.exe \tools
*.* \tools\gitdeployhub
lp.bnd \X_WIN64\X_LANSA\execute
lpcmn*.bnd \X_WIN64\X_LANSA\execute
lpcr*.bnd \X_WIN64\X_LANSA\execute
lxclisig.dll \X_WIN64\X_LANSA\execute
lxutil.dll \X_WIN64\X_LANSA\execute
x_Base.dll \X_WIN64\X_LANSA\execute
x_Cbc1.dll \X_WIN64\X_LANSA\execute
x_Cbc2.dll \X_WIN64\X_LANSA\execute
x_Dbg.dll \X_WIN64\X_LANSA\execute
x_Dnp.dll \X_WIN64\X_LANSA\execute
x_funms.dll \X_WIN64\X_LANSA\execute
x_lsv.dll \X_WIN64\X_LANSA\execute
x_NetDnp.dll \X_WIN64\X_LANSA\execute
x_pdfms.dll \X_WIN64\X_LANSA\execute
x_Prim.dll \X_WIN64\X_LANSA\execute
x_RdrCbc140.dll \X_WIN64\X_LANSA\execute
x_RdrCbc240.dll \X_WIN64\X_LANSA\execute
x_RdrVo40.dll \X_WIN64\X_LANSA\execute
x_var.dll \X_WIN64\X_LANSA\execute
lansa-tools.exe\X_WIN95\X_LANSA\execute
lecimt03.dll \X_WIN95\X_LANSA\execute
lefimpt1.dll \X_WIN95\X_LANSA\execute
lefnwsm2.dll \X_WIN95\X_LANSA\execute
lefsql01.dll \X_WIN95\X_LANSA\execute
lehfd002.dll \X_WIN95\X_LANSA\execute
lehfl003.dll \X_WIN95\X_LANSA\execute
lehmfd02.dll \X_WIN95\X_LANSA\execute
lehmfl02.dll \X_WIN95\X_LANSA\execute
lehsvm01.dll \X_WIN95\X_LANSA\execute
lesvmapi.dll \X_WIN95\X_LANSA\execute
letcpcmp.dll \X_WIN95\X_LANSA\execute
letsvm01.dll \X_WIN95\X_LANSA\execute
letw2000.dll \X_WIN95\X_LANSA\execute
letw2025.dll \X_WIN95\X_LANSA\execute
letw2100.dll \X_WIN95\X_LANSA\execute
levfd028.dll \X_WIN95\X_LANSA\execute
levfd090.dll \X_WIN95\X_LANSA\execute
levfl040.dll \X_WIN95\X_LANSA\execute
levhm013.dll \X_WIN95\X_LANSA\execute
levhm031.dll \X_WIN95\X_LANSA\execute
levhm032.dll \X_WIN95\X_LANSA\execute
levhm046.dll \X_WIN95\X_LANSA\execute
levhm047.dll \X_WIN95\X_LANSA\execute
levhm038.dll \X_WIN95\X_LANSA\execute
levsvm02.dll \X_WIN95\X_LANSA\execute
levsvm03.dll \X_WIN95\X_LANSA\execute
levsvm06.dll \X_WIN95\X_LANSA\execute
levsvm07.dll \X_WIN95\X_LANSA\execute
levsvm08.dll \X_WIN95\X_LANSA\execute
levsvm09.dll \X_WIN95\X_LANSA\execute
levsvm10.dll \X_WIN95\X_LANSA\execute
levsvm11.dll \X_WIN95\X_LANSA\execute
levsvm12.dll \X_WIN95\X_LANSA\execute
levsvm13.dll \X_WIN95\X_LANSA\execute
levsvm17.dll \X_WIN95\X_LANSA\execute
levsvm23.dll \X_WIN95\X_LANSA\execute
levwc003.dll \X_WIN95\X_LANSA\execute
lp.bnd \X_WIN95\X_LANSA\execute
lpcmn*.bnd \X_WIN95\X_LANSA\execute
lpcr*.bnd \X_WIN95\X_LANSA\execute
lxclisig.dll \X_WIN95\X_LANSA\execute
lxptbbld.exe \X_WIN95\X_LANSA\execute
x_Base.dll \X_WIN95\X_LANSA\execute
x_Cbc1.dll \X_WIN95\X_LANSA\execute
x_Cbc2.dll \X_WIN95\X_LANSA\execute
x_Cbv1.dll \X_WIN95\X_LANSA\execute
x_Cbv2.dll \X_WIN95\X_LANSA\execute
x_Dbg.dll \X_WIN95\X_LANSA\execute
x_Dnp.dll \X_WIN95\X_LANSA\execute
x_Dom.dll \X_WIN95\X_LANSA\execute
x_funms.dll \X_WIN95\X_LANSA\execute
x_lsv.dll \X_WIN95\X_LANSA\execute
x_NetDnp.dll \X_WIN95\X_LANSA\execute
x_pdfms.dll \X_WIN95\X_LANSA\execute
x_Prim.dll \X_WIN95\X_LANSA\execute
x_RdrCbv140.dll \X_WIN95\X_LANSA\execute
x_RdrCbv240.dll \X_WIN95\X_LANSA\execute
x_RdrVo40.dll \X_WIN95\X_LANSA\execute
x_Rom.dll \X_WIN95\X_LANSA\execute
x_var.dll \X_WIN95\X_LANSA\execute
liiodef.h \X_WIN95\X_LANSA\source
ServerModule2.sss \X_WIN95\X_LANSA\source
wiz02002.sss \X_WIN95\X_LANSA\source
wiz02007.sss \X_WIN95\X_LANSA\source
wiz02015.sss \X_WIN95\X_LANSA\source
wiz02018.sss \X_WIN95\X_LANSA\source
wiz02022.sss \X_WIN95\X_LANSA\source
wiz02023.sss \X_WIN95\X_LANSA\source
wiz02025.sss \X_WIN95\X_LANSA\source
EPC150011
lcolist.exe \connect
lcomgr32.dll \connect
lcolist.exe \connect64
lcomgr32.dll \connect64
EPC150014
lwebmfra.dll \WebUtils
lwebmjpn.dll \WebUtils
lwebutil.exe \WebUtils
Object Name Object Type Library
VL_WEB_RUNTIMEDIRx_lansa/web/vl/lansa_14_2_6_0
W3XSVPGM*SRVPGMLANSA communication library and Web Server
W3XSVPGV*SRVPGMLANSA communication library and Web Server
W3XS1000*SRVPGMLANSA communication library and Web Server
[email protected]*PGMLANSA communication library and Web Server
LWEBPASE*SAVF*CDLIB
WEBDFLS*SAVFLANSA program library
WEBINIT*SAVFLANSA program library
X_BASE*SRVPGMLANSA program library
X_CBC2*SRVPGMLANSA program library
X_COMP*SRVPGMLANSA program library
X_DBG*SRVPGMLANSA program library
X_FUN*SRVPGMLANSA program library
X_LSV*SRVPGMLANSA program library
X_PDF*SRVPGMLANSA program library
X_PRIM*SRVPGMLANSA program library
X_VAR*SRVPGMLANSA program library
[email protected]*PGMLANSA program library
DCXLOADF07*PF*LOADLIB
lpcmn.bndSTMF../x_lansa
lpcmnfra.bndSTMF../x_lansa
lpcmnjpn.bndSTMF../x_lansa
lppajpn.bndSTMF../x_lansa
liiodef.hSTMF../x_lansa/source

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

    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.

© 2019 LANSA