EPC - 877

Date : April 10, 2015

ProductVisual LANSA and LANSA for iSeries
LANSA for the Web (EPC878 on Windows)
Version12 SP1
Pre-Requisite Details873
Special NotesAll Version 12 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 NotesThe IBM i instructions are expedited procedures that assume a sound knowledge of IBM i.
You should use a user profile that is QSECOFR, part of the QSECOFR group, or, has *ALLOBJ and *SECADM special authorities.
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 ActionsThere are no CCS items that require user action.
Document UpdatesThis EPC does not contain updates to any guides.

The latest guide updates are available at http://www.lansa.com/support/docs/update.htm
HotfixesThe following Hotfixes will be replaced by this EPC:
Windows:

EPC873HF-130510
EPC873HF-130516
EPC873HF-130520
EPC873HF-130522
EPC873HF-130619
EPC873HF-130628
EPC873HF-130701
EPC873HF-130712
EPC873HF-130731
EPC873HF-130731d
EPC873HF-130809



EPC873HF-130904
EPC873HF-131002
EPC873HF-131210
EPC873HF-140108
EPC873HF-140109
EPC873HF-140301
EPC873HF-140303
EPC873HF-140305
EPC873HF-140310d
EPC873HF-140312
EPC873HF-140319
IBM i:

EC873P01
EC873P02
EC873P03
EC873P04
EC873P05
EC873P06
EC871P07
EC871P08
EC871P09
EC871P10
EC873P11
EC873P12
EC873P13
EC873P14
EC873P15
EC873P16

Instructions to install the EPC

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

Instructions provided for:

Detailed changes

CCS id.Description
EPC877/EPC878 
0140820
0142785
0150157
VARCHAR and STRING field values become blank padded when added to browselist

This defect has now been rectified
0146306
0151279
Line of code following long list definition is dropped on checkin/checkout

This defect has now been rectified
0148092
0149386
Radio button inconsistency when using tabbing

This defect has now been rectified
0148518
0149740
Ensure that LANSA does not store any unencrypted passwords in the registry

This defect has now been rectified
0148918Incorrect handling of DBCS in HTML tags in Web Components

This defect has now been rectified
0148986Decimal Point symbol incorrect immediately after first install of a deployed app

Issue does not occur in Version 13. Its only previous versions which manifest this issue.
0149056
0149308
0149401
0153066
STM_FILE_WRITE_CTL writing incorrect CRLF

This defect has now been rectified
0149189After upgrade to EPC873, some js files are referenced in the wrong locations

jQuery UI weblets internationalization (i18n) file requests were being made to the wrong directory. Issue fixed.
0149210
0151065
Problem compiling a file with a large amount of fields with the SUNI attribute.

This defect has now been rectified
0149220
0146329
Incorrect navigation and focus behaviour when a groupbox has "&&" in the label

This defect has now been rectified
0149480ActiveX process not terminated correctly if LANSA fails

RDMLX errors, such as null reference and divide by zero, didn't cause X_RUN to terminate if they happened inside an event routine listening to an ActiveX event.
This defect has now been rectified
0149501SQL error occurs compiling a Logical file without Rebuild Table option

This defect has now been rectified
0149595
0150691
0151013
Sorting the grid contents by clicking on the column heading no longer works

Grid sorting stopped working when using old style layouts (not themed).
This defect has now been rectified
0149675CKEditor onchangeScript property not working

This defect has now been rectified
0149735An error occurs when an array is used in WHERE clause of SELECT command

This defect has now been rectified
0149832
0150961
V12 SP1 - SCHI characters are lost when saving to the iSeries

This defect has now been rectified
0149866Encryption of the "Connection String" message in LANSA trace

0149947ActiveX causes access violations

This defect has now been rectified
0150105Excessive WMI calls cause performance issues and random crashes in Citrix

This defect has now been rectified
0150117
0149936
*user_authenticated not being populated

This defect has now been rectified
0150427
0151080
Allow user exit programs that use SQL CLI to share LANSA's connection handle

They need to call program DCXP8210 with parameters:
Action - Alpha 3 bytes value 'GET'
Handle - Integer 4 bytes
If handle is returned as hex '00000000' then LANSA doesn't currently have a connection.
0150503Performance improvement when creating a large amount of Reusable Parts

This defect has now been rectified
0150630Numeric fields accept characters in functions on Windows

This defect has now been rectified
0150639IME is not turned on first when moving focus to grid cell using tab key

This defect has now been rectified
0150790JSMX BIF does not validate and return error when length of field is incorrect

Integrator now validates the data returned to Visual LANSA.
0150885WAM calling Webevent/Webevent calling WAM fails in IE9/IE10

This defect has now been rectified
0150952Uncommitted updates for a file are automatically rolled back on IBM i

RDMLX function termination will no longer specifically rollback any uncommitted database transactions on IBM i. This allows subsequent processing in the job to determine whether to commit or rollback database transactions as for RDML function termination.
0150961
0149832
V12 SP1 - DBCS (SCHI) corruption when the DBCS character contains '&'

This defect has now been rectified
0151292FXQF=*ALL setting causes SAVE List BIFS to fail execution with LX_F80 errors

This defect has now been rectified
0151331Field label and field column heading are missing after check-in

This defect has now been rectified
0151339Deployment tool does not successfully deliver a table with BLOB records

Ensures the Deployment Tool includes BLOB and CLOB file data if file data is nominated to be included in the package.
0151501V12 CGI to support larger amount of POST data

This defect has now been rectified
0152178Enhance STM_FILE_OPEN to create files according to User Profile Setting

This defect has now been rectified
0153023Some SCHI characters are lost when saving to the iSeries

This defect has now been rectified

Affected objects

Object NameObject Type
EPC877
liih.exe\LANSA
liio.dll\LANSA
liis.dll\LANSA
liiv.dll\LANSA
liiy.dll\LANSA
x_base.dll\LANSA
x_prim.dll\LANSA
XSLEditorFrame.dll\LANSA
XSLEditorFrameFRA.dll\LANSA
XSLEditorFrameJPN.dll\LANSA
PreviewBrowser.dll\lansa\XslEditor
PreviewBrowserFRA.dll\lansa\XslEditor
PreviewBrowserJPN.dll\lansa\XslEditor
XSLEditor.dll\lansa\XslEditor
XSLEditorFRA.dll\lansa\XslEditor
XSLEditorJPN.dll\lansa\XslEditor
XSLHTMLEditor.dll\lansa\XslEditor
XSLHTMLEditorFRA.dll\lansa\XslEditor
XSLHTMLEditorJPN.dll\lansa\XslEditor
XSLTextEditor.dll\lansa\XslEditor
XSLTextEditorFRA.dll\lansa\XslEditor
XSLTextEditorJPN.dll\lansa\XslEditor
installr.dll\X_WIN95\X_LANSA\Execute
letprc01.dll\X_WIN95\X_LANSA\Execute
lh_hmprs.dll\X_WIN95\X_LANSA\Execute
lh_procd.dll\X_WIN95\X_LANSA\Execute
lp_udt.dll\X_WIN95\X_LANSA\Execute
lxptbbld.exe\X_WIN95\X_LANSA\Execute
runsql.exe\X_WIN95\X_LANSA\Execute
w3@p1600.dll\X_WIN95\X_LANSA\Execute
w3_p1200.exe\X_WIN95\X_LANSA\Execute
w3_p1600.dll\X_WIN95\X_LANSA\Execute
w3wsvpgm.dll\X_WIN95\X_LANSA\Execute
w3wsvpgx.dll\X_WIN95\X_LANSA\Execute
x_base.dll\X_WIN95\X_LANSA\Execute
x_bifms.dll\X_WIN95\X_LANSA\Execute
x_comms.dll\X_WIN95\X_LANSA\Execute
x_dbmms.dll\X_WIN95\X_LANSA\Execute
x_dll.dll\X_WIN95\X_LANSA\Execute
x_funms.dll\X_WIN95\X_LANSA\Execute
x_pdfms.dll\X_WIN95\X_LANSA\Execute
x_prim.dll\X_WIN95\X_LANSA\Execute
x_run.exe\X_WIN95\X_LANSA\Execute
x_uimmseng.dll\X_WIN95\X_LANSA\Execute
x_uimmsfra.dll\X_WIN95\X_LANSA\Execute
x_uimmsjpn.dll\X_WIN95\X_LANSA\Execute
x_xqlms.dll\X_WIN95\X_LANSA\Execute
EPC878
std_ckeditor.jsWebServer\images\script
std_ckeditor.min.jsWebServer\images\script
std_jqueryui.jsWebServer\images\script
std_jqueryui.min.jsWebServer\images\script
std_script.jsWebServer\images\script
std_script.min.jsWebServer\images\script
std_script2.jsWebServer\images\script
std_script2.min.jsWebServer\images\script
Object NameObject TypeLibrary
LCOMGR40*SRVPGMLANSA communication library
LCOPROXY*SRVPGMLANSA communication library
DCXSPASE*SRVPGMLANSA communication library and Web Server
DCXS86XX*SRVPGMLANSA communication library and Web Server
LXUTIL*SRVPGMLANSA communication library and Web Server
W3XSVPGM*SRVPGMLANSA communication library and Web Server
W3XSVPGV*SRVPGMLANSA communication library and Web Server
W3XSVPGY*SRVPGMLANSA communication library and Web Server
W3XSVPGX*SRVPGMLANSA communication library
W3XS4210C*SRVPGMLANSA communication library
LCXP0010*PGMLANSA communication library
W3@P1600*PGMLANSA communication library
W3PROFUN*SRVPGMLANSA program library
X_BASE*SRVPGMLANSA program library
X_COM*SRVPGMLANSA program library
X_COMP*SRVPGMLANSA program library
X_DBG*SRVPGMLANSA program library
X_DBI*SRVPGMLANSA program library
X_DBM*SRVPGMLANSA program library
X_DBM_IS*SRVPGMLANSA program library
X_DLL*SRVPGMLANSA program library
X_FUN*SRVPGMLANSA program library
X_LSV*SRVPGMLANSA program library
X_PDF*SRVPGMLANSA program library
X_PRIM*SRVPGMLANSA program library
X_SSV*SRVPGMLANSA program library
X_VAR*SRVPGMLANSA program library
X_XQL*SRVPGMLANSA program library
BI@P291*PGMLANSA program library
BI@P292*PGMLANSA program library
BI@P299*PGMLANSA program library
BI@P300*PGMLANSA program library
BI@P301*PGMLANSA program library
BI@P304*PGMLANSA program library
DCXP0007*PGMLANSA program library
LCOLIST*PGMLANSA program library
LCOTP*PGMLANSA program library
RUNSQL*PGMLANSA program library
W3@P1200*PGMLANSA program library
W3@P1400*PGMLANSA program library
W3XPASETD*PGMLANSA program library
W3XPASETP*PGMLANSA program library
lpcr.bndSTMF../x_lansa
lpcrfra.bndSTMF../x_lansa
lpcrjpn.bndSTMF../x_lansa
lppa.bndSTMF../x_lansa
lppafra.bndSTMF../x_lansa
lppajpn.bndSTMF../x_lansa
x_ctddef.hSTMF../x_lansa/source
x_funstr.hSTMF../x_lansa/source
x_glodef.hSTMF../x_lansa/source
x_pdfpro.hSTMF../x_lansa/source
MQ_GETBIFLANSA program library

Install Instructions

  1. Sign on with QSECOFR user profile, part of the QSECOFR group or a user profile that has *ALLOBJ and *SECADM special authorities.
  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. To check for active users refer to Appendix B How to check for Active Users in the Installing LANSA on IBM i guide for instructions.
  4. End the Listener, Host Monitor and Web Server for the LANSA system and run the LANSA for the Web cleanup program.
  5. Move the unzipped file EPC877 to an IFS folder on the IBM i ( e.g. /LANSA_pgmlib/tmp/epc877 )
  6. For this EPC use the following options:
    1. Install the EPC from = *IFS
    2. Apply this EPC to = FULL_LANSA_SYSTEM
  7. Run the following command before the LOADEPC command to avoid having to add the LANSA program library to the jobs library list.
    CHGCMD CMD(pgmlib/LOADEPC) PGM(pgmlib/DC@LCP120)
  8. 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 . . . . . . . . . . . > 877

    Install the EPC from . . . . . . >*IFS
    IFS Path and object name . . . .e.g./LANSA_pgmlib/tmp/epc877

    Apply this EPC to . . . . . . . FULL_LANSA_SYSTEM
    LANSA program library . . . . . pgmlib
  9. Once the EPC install is complete, if you do not see the message "INSTALLATION OF EPC NUMBER 877 COMPLETED", you can review the joblog produced by the EPC install and search for this message. Alternatively, you can check the Last EPC value in LANSA About or take option F10 in LANSA About to see the EPC log.
  10. The EPC backup library is saved to a save file in the LANSA Program library (iii877nn where iii = 1st three characters of the LANSA pgm library and nn is sequence number. For example DCX87701). This save file is deleted by the next LANSA upgrade or Service pack.
  11. 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 EPC877 to an IFS folder on the IBM i. ( e.g. /LANSA_admlib/tmp/epc877)
  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/DC@LCP120)

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

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

    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. Recommend 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. Double-click on AllEPCs.exe.
  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. To view details of the installed EPCs:
    1. sign into LANSA
    2. view the Help menu
    3. Product Information option
    4. then select the Installation Details tab
    5. expand the Installation/ EPC Summary
    6. review the last entries

© 2016 LANSA

Download this EPC

Note: A password is required to download EPCs. Request a password

Customers in Asia Pacific and EMEA can download EPCs from this site. Customers in the Americas can download EPCs from the Americas Region Support Portal.