EPC - 871

Date : October 15 2011

EPC871 Highlights

Get this EPCDownload EPC871 via the LANSA Support Portal
Product

Visual LANSA and LANSA for iSeries
LANSA for the Web (EPC872 on Windows)

Version12 SP1
Pre-Requisite DetailsNone
Related ProductsLANSA Client
LANSA Open
Special Notes

All 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 Notes The 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 ActionsThe following CCS items require user action:

144373 IBM i: Fix RDML func calling RDMLX func after RDMLX abort (with IF_ERROR(*NEXT))
144773 System Variable *USER_AUDIT incompletely shipped in V12 SP1
145129 IBM i RDMLX Native I/O leaves no record locks when before triggers VE or ER

See below for details.

Document Updates Updates to these guides are provided:

     lansa012.chm    Visual LANSA Guide
lansa015.chmTechnical Reference Guide
lansa016.chmVisual LANSA Feature Help
lansa020.chmDeploying Visual LANSA Applications
lansa087.chmWeb Application Modules (WAMs)
lansa088.chmWeb Housekeeping

The guides updated by EPC are only placed in the default LANSA documentation location as installed with Visual LANSA. This default location is ...\x_win95\x_lansa\execute\eng directory. If you installed the LANSA documentation (default folder ...\lansadoc\) from the LANSA Windows CD-ROM, you should manually copy the updated guides to those folders.

The latest guide updates are also available at http://www.lansa.com/support/docs/update.htm

Hotfixes The following Hotfixes will be replaced by this EPC:
Windows:
EPC859HF-110621
EPC859HF-110630
EPC866HF-110615
EPC866HF-110707
EPC866HF-110713
EPC866HF-110804
EPC866HF-110808
EPC866HF-110818
EPC866HF-110819
EPC866HF-110825
EPC866HF-110831
EPC866HF-110913
EPC866HF-111004
EPC866HF-111006
EPC866HF-111014
 
IBM i:
EC859P07

EC866P04


Instructions to install the EPC

EPC871 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 EPC871.EXE file from the Web site or email.
  2. Unzip (double click) EPC871.EXE. These files will be extracted:

Instructions provided for:

YesLANSA for iSeries
YesIBM i Web Server (multi-tier)
YesVisual LANSA

 

Detailed changes

   EPC871/EPC872 includes these changes:    [Click here to Hide table...]

  CCS id.      Description
EPC871/EPC872
0113894 Static web page generation support for WAMs

A Webroutine can now be executed using X_RUN to generate and save the output to a file which may be later served by a web server as a static page.

The X_RUN command to generate the static page will be similar to the following:
X_RUN PROC=*WAMSP WMOD={wamname} WRTN={webroutinename} PART={partition} LANG=*DFT WAML=LANSA:XHTML WASP="/path/to/output.html"

where:
"{wamname}" and "{webroutinename}" nominate the WAM/Webroutine to execute.
"{partition}" is the partition name.
WAML specifies the markup language to use.
WASP specifies the path where the output will be saved, double quotes are optional if the path does not contain blanks. If the option is not specified, the output file will be saved in the X_LANSA directory with the same name as the WAM and Webroutine names.
WXML=Y can be added to the command line to save the LXML data instead (without XSLT processing).

Refer to the LANSA documentation for further information about the arguments.

NOTE: This is currently not supported on windows when using a seat based web license (eg. W05)

0135824 Prompter does not close if "close" webroutine reached via TRANSFER

Fixes an issue where a prompter will not close if the "close" webroutine is reached via TRANSFER TOROUTINE(), unless the closing_wrname property value is all lowercase.

0140804
0140834
XSL Generation: Use <label> elements for field captions

Element <label> now used for captions to associate them to their related field.

0142054 Form height changed automatically (behavior changed from V11 SP5)


0143189 WAM Editor: IE9 compatibility

It is now possible to drop a weblet over an input field when using IE9

0143423 Using the host monitor randomly causes the VL Editor to fail.

Starting Debug while running the Host Monitor could potentially cause the editor to fail.

0143589
0145099
ImageAlignment property of panel/image is not being calculated correctly in V12

Fix for incorrect display of Image with ImageAlignment(Center) on Panel control.

0143856 FETCH FIELDS(*ALL_VIRT) FROM_FILE(FILE without virtual fields) errors


0144040 Modeler crashes IDE if you try to delete a external element twice

Through adding and removing External Entities in the Logical Modeller you could end up in a situation where elements exist more than once in the model. This would eventually cause a crash when deleting that element.

0144049 Modeler crashes IDE when opening previously saved model

The Logical Modeller is now a bit more robust when it comes to restoring models that have some information missing.

0144145
0145125
LANSA Client join query abends - joblog shows MCH0601


0144256 TPTH setting ignored for X_ERR.LOG file when using root directory

Issue was introduced when a check was made as to whether the temporary directory existed.

0144327 Multilingual text variable values list in exported weblets


0144373 IBM i: Fix RDML func calling RDMLX func after RDMLX abort (with IF_ERROR(*NEXT))

If an RDML function invoked RDMLX code after a previous abort from a CALL to an RDMLX function invoked with IF_ERROR(*NEXT), the internal fatal error flag was left on in RDMLX from the first CALL. This led to unexpected behaviour.

User Action: 
For IBM i only, rebuild any RDMLX functions that are called from RDML functions with IF_ERROR(*NEXT)

0144416 LANSA Open does not support RRNA and RRNB parameter setting
0144444 WAM Editor: Use standard '&' separator in LANSA WAM requests

When executing a WAM in a browser '&' separator is used in the URL
When executing a WAM as a Web Service '&' separator is used in the URL

0144481
0144779
Memory leak in Windows when calling a RDMLX function that contains Mthroutines.


0144523 SUBMIT does not a create message when QUET=Y


0144536
0144548
IBM i: Working directory no longer changed on startup of RDMLX environment

Note: For old behavior (change working directory to x_lansa on startup), set x_run parameter ICWD=Y on the command-line or in the X_RUN environment variable. (It has no effect if specified in x_lansa.pro.)

0144544 listname show lists for all WAMs open in the editor, not just the current one

lists shown are for the current webroutine, unless property parameters indicate differently

0144546
0144572
Include a new set of images for selection from the WAM editor

A new set of modern looking images are now available in different states (normal, hot and disabled) and sizes.

0144562 Opening existing external resource in V12 SP1 gives version mismatch error

Opening a shipped External Resource gave a version mismatch error. However, shipped External Resources shouldn't have been editable at all, this has been corrected.

0144588 Add hover effects and row selection to the grid and list

Added rowHoverEffect, selectableRows and onRowClickJS properties to the standard grids.

0144591
0144635
New themable button

New button weblet based on jQuery UI button.

0144593 New weblet to add "Print Page" feature.


0144594 New weblet to export list contents to Excel spreadsheet (IE only)


0144622
0144623
New WAM CRUD Application using jQuery themes

A new sample WAM CRUD Application leveraging the jQuery theming and new weblets introduced in V12 SP1 and this EPC can now be generated using the Wizards available from the Tools menu of the LANSA Editor.

0144626 Option to not show list headings if list is empty (standard list)

New option to allow now showing the list headings if the list is empty. It defaults to "Not show".

0144656 Minify LANSA shipped JavaScript and CSS files

JavaScript and CSS files shipped by LANSA are now minified for faster downloads. The non-minified version of the files are shipped as well.

0144660 Expanding a Group or Framework causes loss of information.

After expanding a Group or Framework in the Repository Browser, objects don't show their Modified Date and Build Status anymore.

0144669 Wide lists are truncated in Webroutine design even when width_type is fluid

WAM Layout parameters don't show property dropdowns in the WAM Editor. This has been fixed.

0144671 Insert fieldset tag using the WAM Editor

Right mouse click where you want the fieldset. In the context menu choose Insert and then Fieldset.

0144680 std_nav_panel border details always revert back to solid despite specifying none

std_nav_panel border setting now respects the chosen value

0144692 Prompter weblet does not close in V12 SP1

The prompter may not recognise the "Closing Webroutine" and automatically close.


0144695 Add a transparentBackground property to the Simple Blank Layout

A transparentBackground property has been added to the Simple Blank Layout. If true, this will override any CSS set background color to make the document body transparent.

0144701 V12 SP1 - File name "ADMIN" cannot be used in Crystal Report after an upgrade

ADMIN removed from reserved words

0144706 Menus with submenus in the jQuery menubar weblet do not display correctly.


0144748 Web deployment package runtime failure

This defect has now been rectified

0144758 Replace hidefocus property with cross-browser option

hidefocus attribute is IE only. Added class with outline:none for other browsers.

0144773
0145090
System Variable *USER_AUDIT incompletely shipped in V12 SP1

The *USER_AUDIT system variable was shipped in LANSA Version 12 SP1 with a new system variable evaluation program, M@SYSVA2 as this allows it to now allow for a user audit entity of up to 256 characters, while functions and I/O modules / OAMs previously compiled had the user audit entity of up to 10 characters. However not everything was shipped to allow for the M@SYSVA2 system variable evaluation program. A workaround of changing the program back to M@SYSVAR was used to give the old limitation back.

User Action: 
If the new behavior is required, the *USER_AUDIT system variable evaluation program must be set to M@SYSVA2 and then functions and IOMs/OAMs using it need to be recompiled.

0144777 Presubmit JavaScript should not escape characters when in <script> section

XML reserved characters should not be escaped when the presubmit JavaScript is in a <script> section.

0144797 Content area expansion areas need to be better highlighted

Content area expansion or replacement is now highlighted so it is easier to see where the area is to be expanded or replaced. The background is red with yellow text color.

0144801 std_datetimepicker weblet has incorrect date format for inline

The date format for this weblet was defaulting to 'yy-mm-dd'. It now defaults to using the locale based on the ISO language code.
You need to refresh this weblet where it is used in inlined lists.

0144832
0144900
AutoComplete Weblet value field/label field do not show fields from the list

Fields from the list chosen in the listName property were not shown for the LabelField and ValueField property values.
This defect has now been rectified

0144835 WAM Editor: Visualize as input field not to create onpropertychange attribute

onpropertychange attribute is no longer created
- when replacing a weblet with a input field (using context menu)
- when turning a output field into a input field (using context menu)

0144839 Check out / propagation causes LX_F02 duplicate key error and IDE crash


0144849 Inlined lists missing attribute inline="true" at runtime

Attribute is used by some weblets to inform when an inlined list has incorrectly been used when a non-inlined list is required.

0144858 Dynamic Select Box weblet does not work on IBM i or Linux servers

When running a WAM that uses the Dynamic Select Box weblet on an IBM i or Linux server, and the onchangeExtraFields or updateFieldsToSubmit properties contain default values, a JavaScript syntax error will be produced prevent the weblet from working.
This defect has now been rectified

0144863
0144952
Host Monitor receives Invalid CursorStatus error after upgrade to V12 SP1


0144864 Update Webroutine command documentation with OPTIONS and RESPONSE parameters

This defect has now been rectified

0144881 Duplicate default name created for inlined lists

Items dropped in inlined lists will now have the row index as part of their name, hence they will be unique in the list.

0144886 Check-in or compile on 2 particular PCs ends in error

This defect has now been rectified

0144890 GET_MESSAGE bif returns blank messages after IO in Windows<->Windows SuperServer


0144910 Delete partition step is not clearing DC@FEH file records

Deleting a partition via Housekeeping menu now removes External Resource information.

0144915 Editor crash focusing on an instance of a Reusable Part extending a popup menu.

The menu editor crashed on an instance of a Reusable Part that inherits from PRIM_PMNU. This is fixed now, the menu editor should only respond to instances of PRIM_PMNU, not to Reusable Parts extending it.

0144935 The List Paging Images weblet now uses disabled image

The List Paging Images weblet now uses disabled images for unavailable options rather than displaying no image at all.

0144951 SQL Server 2008 Date type in Other File gets fatal 'Numeric value out of range'


0144982 Reentry field value is ignored if set to an empty string

If a reentry field is set to empty (single quote, single quote), the reentry field was not being updated in the form before being posted to the server.

0144994 Menubar items are not all the same width when oriented vertically.


0145017 Dynamic Select onChangeExtraFields/updateFieldsToSubmit may pick unwanted values

The Dynamic Select weblet default value for the onChangeExtraFields/updateFieldsToSubmit properties was picking the values set for a different Dynamic Select weblet on the same page. This would happen on IBM i and Linux.

0145022 Links only work once in Chrome

Works around a Chrome bug (83958) which results in links with a target of _blank contained within a frame (such as a Navigation Panel) will only work once.

0145031 Deployment to MSSQL server, the data is not imported

Rectifies an issue introduced in V12SP1 whereby file data was not correctly reloaded after unloading during package build.

0145041 Select a grouping of objects to add to package. Ensure saved on package close.

When adding a grouping of objects to a package, for example selcet all Multilingual Variables in grouping "K", ensure the objects are saved when the package is closed/saved.

0145060
0145102
VL - SP1 Memobox visual style different compared to V12 (VLF memobox affected)

This defect has now been rectified

0145075 Empty ContentString causes LOB buffer allocation error

This defect has now been rectified

0145103 Changes in font appearance for existing WAMs after upgrading to SP1

This defect has now been rectified

0145129 IBM i RDMLX Native I/O leaves no record locks when before triggers VE or ER

IBM i RDMLX Native I/O (delete and update) no longer leaves records locked if a before delete or update trigger returns with VE (validation error) or ER (I/O error). This includes I/O via DEFINE_ANY_SERVER SuperServer connection to IBM i.

User Action: 
Files (OAMs) with this issue need to be checked in and recompiled after the application of this correction.

0145142 Performance issues when adding entries to BrowseList since upgrading to EPC863

Fixed.

0145180 Reload of file data bypassed

Rectifies an issue introduced in V12SP1 whereby file data was not correctly reloaded after unloading during package build.

0145225 Consolidate the two hidden content areas in new layouts

The "hidden" content area at the bottom of some layouts is now provided for all layouts. If the hidden content area is expanded or replaced in a webroutine design then any content in the original hidden

will be moved into the new content area.
0145262 EXIT command appears to act like RETURN


0145272 Google Charts not using default theme colors in IE8

The Google charts API doesn't handle hex color codes shorthand notation (for example #abc). These are now expanded before using them as parameters in the URL request.

0145301 DataArrival event incorrectly recognized as a Propery in Winsock activex control


0145330 SQL Error when saving code that has a long PTYROUTINE name


0145352 ActiveX, how to set several values for a property

 

Affected objects

   Windows Components:    [Click here to Show table...]

 

   IBM i Components:    [Click here to Show table...]

Install Instructions

Instructions for installing on IBM i

NOTE: install Instructions have changed.

  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 EPC871 to an IFS folder on the IBM i ( e.g. /LANSA_pgmlib/tmp/epc871 )
  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 . . . . . . . . . . . > 871

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

    Apply this EPC to . . . . . . . FULL_LANSA_SYSTEM
    LANSA program library . . . . . pgmlib

  9. Sign off and then on again before commencing the next installation, e.g.:

Instructions for users of IBM i Web Server (multi-tier)

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 EPC871 to an IFS folder on the IBM i. ( e.g. /LANSA_admlib/tmp/epc871)
  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 . . . . . . . . . . . > 871

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

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

 

Instructions for installing on Windows

  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

© 2011 LANSA