EPC - 859

Date : August 31 2010

EPC859 Highlights

Get this EPCDownload EPC859 via the LANSA Support Portal
Product Visual LANSA and LANSA for iSeries
LANSA for the Web (EPC860 on windows)
Version12
Pre-Requisite DetailsNone
Related ProductsLANSA Integrator
LANSA Open .NET
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:

132415 IBM i: Select of CLOB field fails on second loop
138966 FUNX output attribute only writes first 7 characters when updated from function
140437 Rebuild of a file with CLOB SUNI field fails
140491 LANSA file with SUNI field from PC OTHER file fails to compile
140515 IBM i: ODBC column length less than returned field size on DELETE or UPDATE 140591 IDE Repository browser does not refresh Templates after import
140716 WAM/LOBS Remove file method does not work correctly with LOBs retrieved by OAM
141155 Fatal Error (0977) Incorrect use of SQLDA: cannot set the number of columns
141747 V12 Upgrade DT package does not update LX_F96 table

See below for details.

Document Updates This EPC does not contain updates to any guides.
The latest guide updates are available at http://www.lansa.com/support/docs/update.htm
Hotfixes The following Hotfixes will be replaced by this EPC:
Windows:
EPC851HF-100408
EPC851HF-100427
EPC851HF-100428
EPC851HF-100504
EPC851HF-100526
EPC851HF-100531
EPC851HF-100604
EPC851HF-100605
EPC851HF-100608
EPC851HF-100611
EPC851HF-100709a
EPC851HF-100709b
EPC851HF-100709c
EPC851HF-100722
EPC851HF-100803
EPC851HF-100806
EPC851HF-100806a
EPC851HF-100809
EPC851HF-100811
EPC851HF-100811a
EPC851HF-100812
IBM i:
EC851P01
EC851P02
EC851P03
EC851P04
EC851P05

Instructions to install the EPC

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

Instructions provided for:

Yes LANSA for iSeries
Yes IBM i Web Server (multi-tier)
Yes Visual LANSA

 

Detailed changes

   EPC859 includes these changes:    [Click here to Hide table...]

  CCS id.      Description
EPC858
0115201
0137541
0137654
0141573
Enable IPv6 code in Windows, Linux and IBM i.

A new configuration item has been added to enable IPv6.

0136704
0136705
OpenSSL support in Connect.

The listener now supports SSL. Clients connecting to this listener when SSL is enabled cannot be older versions (12 GA or earlier).

0141582TCP Keep-Alive value reset if TCP No Delay option cleared.

Default value handling was incorrect

0141413
0141160
LANSA Connect not using local version of x_lickey.dat

When the LANSA install configuration was restructured, connect was not updated to locate the local license file, it was always using the shared license file. This has now been corrected
NOTE: This only effects seated licenses

EPC859
0106264 Development Export Fails to import on Linux systems

Import of development tables will now be skipped on Linux systems, instead of causing a fatal error.

0121775 Windows rebuild of iSeries Other File with BLOB or CLOB loses data
0132415 IBM i: Select of CLOB field fails with SQL0452 or MCH3601 on second loop

IBM introduced a defect in V5R4 (and it continued in V6R1). They have fixed it in the following PTFs:
V5R4: SI39059
V6R1: SI38777

User Action: Apply the appropriate IBM i PTF

0132517 Turn off messages being dumped into the Event Viewer application log

MESSAGE commands for Web functions or WAMs no longer generate event log messages for Windows.

0134004
0138250
Is it possible to get the week number using a date field intrinsic function?

A new intrinsic, Week, has been added for Date fields. 
WeekNumber and StartOfWeek properties have been added to the Calendar control.

0135174 Extraneous system variable references in LXML document

References to variables from inlined weblet templates were unnecessarily being included in the runtime references list. This has been fixed.

0137480
0140905
Web authenticated user longer than 10 characters being truncated after a timeout.

Authenticated Web users longer than 10 characters are now stored and the full value able to be retrieved after a timeout.

0138128 You may now establish a SuperServer connection from a Linux Visual LANSA system to a Windows Server using the DEFINE_ANY_SERVER and CONNECT_SERVER BIFs. 
This allows Linux applications to read and update databases on Windows servers.
0138608 Focus is not returned correctly after showing a prompter form.

This defect has been corrected.

0138922 X_CPU utility has been updated to cater for Linux 64-bit box.
0139689 Assigning object to new task on Independent Server Installation

Task locks were not released when setting a Task to Finished on an independent install.
This defect has been corrected.

0139695 Tab Sheet Caption has ellipses in text where previously it did not.

Ellipses property has been added for Tabs with a default value of None for backward compatibility

0139865 Tree with check box beeps when space bar used

TreeView issue fixed for Microsoft Vista where setting the checked state of an Item with the space bar would also cause the system MessageBeep to sound

0140061 Allow the (Ready to use) minimum and maximum values to be set up to 9999

Web pre-start jobs: Ready To Use minimum and maximum values have been increased from 3 digits to 4 digits to allow setting a value up to 9999.

0140175 Remove "Include Generated Source" option from package settings

The option to "Include Generated Source" is no longer supported in the package settings. This option was used to support deployment to Linux but is redundant since inclusion of Deliver to Linux functionality in V11 SP5.

0140328 When import a file with DB triggers, the IBM i triggers are not re-added.

When a file that has been compiled with DB Triggers enabled is imported on IBM i, the OS/400 triggers for the file will now be added.

0140405 LANSA Open .NET 3.5 support
0140416 Enable DOCTYPE in XHTML documents

Enable DOCTYPE (DTD declarations) in WAMs to allow standards mode in IE7/IE8

0140437 Rebuild file with CLOB SUNI field fails

For example: Unexpected type (12) for SUNI field (column SUN2CHR03) Routine : Derive_Column_Map_from_Func

This only occurred if fields that were not SUNI were added after a CLOB SUNI field, and the file was rebuilt with data unloaded and reloaded.

User Action: Rebuild OAM for files that have a SUNI CLOB, before rebuilding with unload/reload data.

0140427 Warning issued in Translation Interface if translation longer than default

When using the Translation Interface to translate LANSA objects descriptions and multilingual variable values, if the translated value entered is longer than the base description or value the text is highlighted in red to make this obvious to the translator.

0140491 LANSA file with SUNI fields from PC Other File fails to compile

Message in the compile log is: I/O module compile error - field <fldname> not in data dictionary.
This defect has now been corrected.

User Action: Rebuild file.

0140551 IBM i menu item wrongly listed in Review user access option

This has been corrected.

0140591 Repository browser doesn't refresh Templates after import.

Imports containing templates created in Visual LANSA V11.4 or later were corrupted. This has been corrected.

User Action: The imports will need to be rebuilt.

0140596 DCM1316 Unexpected error when performing "immediate" access to file DC@F60V1

Web Utilities - on connecting to server, some of one customer's systems running V5R4M5 would randomly get the DCM1316 error on DC@F60V1.

0140646 Lockup of RSS Reader when you right click and select properties.

This defect has been corrected.

0140716
0141102
0141103
WAMS/LOBS- RemoveFile method does not work properly with LOBs retrieved by OAM

User Action: Rebuild OAMs for any files with LOB fields that will be retrieved from the file in a WAM.

0140753 Further enhancements to 5250 debugger
  1. Display variables in character mode by default so more variables can be shown on the breakpoint panel.
  2. Change F20=Select All to toggle between Select All and Omit All when choosing / reviewing variables to show at breakpoints. Function key is now F20=Sel/OmtAll, and when this function key is used the choose / review variables to show at breakpoints panel is shown with the results of the function key.
  3. Change F20=Select All to toggle between Select All and Omit All when choosing / reviewing RDML breakpoints. Function key is now F20=Sel/OmtAll, and when this function key is used the choose / review RDML breakpoints panel is shown with the results of the function key.

These 5250 debugger enhancements are in addition to the following enhancements delivered in EPC851 by 0140001

0140790 Web Function: DateTime fields of various lengths are not handled properly

Web Function browse lists can now display DataTime fields of length other than 29.

0140801 Insufficient buffer space allocated for SUNI field when using DBCS language

Error message shown: "ODBC Column length less than returned field size"

This occurs when the SUNI field has a DBCS keyboard shift like keyboard shift O, which is recommended for SUNI fields so that the field can contain up to the maximum number of characters requested in the Field Length. That is, the field length is the number of characters, not bytes. With keyboard shift O specified, more bytes may be in the field than the total number of characters when it contains DBCS. If so, the error occurs.

0140876 Can't transfer to LOB webroutine from another webroutine

Runtime check was stopping transfers to a LOB serving webroutine.
This defect has been corrected.

0140939 Tracing of SQL Server connection reports an error, though its only informational

This defect has now been corrected.

0140972 Webroutine: Don't generate hidden division for hidden lists if there are none

Avoid creating the hidden division to contain hidden lists if there are none in the webroutine.

0140985 VL PC user's password update issue

After changing a user's password on the IBM i and performing a sys init of PC users, you cannot log into the IDE with the user and new password. This issue is fixed and sys init will update IDE with correct user and new password.

0140994 Functions cannot compile in RDMLX due to CHANGE with roundup on alpha fields

This defect has been corrected

0141012 Use Oracle Client 11g r2 in LANSA 12 for Linux

Visual LANSA for Linux now ships with the latest Oracle 11g Instant Client for Linux.

0141143 Better diagnostic error when access to LOB file is denied

These errors are now reported in the Performance and WAM logs for better diagnostics.

0141155 Fatal Error (0977) - Incorrect use of SQLDA: cannot set the number of columns

User Action:  Rebuild OAMs (on system i) for LANSA files that have long char/binary/string/varbinary columns that are created as LOB types on system i (and require SQL to be used at run time for INSERT, DELETE, etc). Only required for files that have had their OAM rebuilt with version 11 SP5 after EPC845, or version 12 after EPC851.

0141160
0141413
JIT server does not release license seats when using Inn license

This defect has been corrected.

0141175 Integrator BIF Crashes when using *BOOLEAN and SERVICE_EXCHANGE(*FIELD)

This defect has been corrected.

0141180 Fatal checkin errors don't display in red only when using language JPN

The Japanese message file DC@M01 with appropriate severity code has been included.

0141206 New Remote System - include checkbox to proceed to Partition Init

New Remote System automatically proceeds to Partition Initialisation dialog if the associated checkbox is selected when created a Linux Remote System.

0141241 V12 upgrade gives MSG1108 LX_F96 not setup correctly
0141252
0141437
DT package build log shows incorrect filename in copy failure messages.
0141321 X'05'(Tab) char gets expanded to spaces in a report created by an RDMLX Function

When a report produced by an RDMLX function on iSeries contains printer instructions in the form of unprintable characters, when the horizontal tab character (X'05') is encountered it will no longer be replaced by a number of blanks.

0141345 ABEND after SQL Server connection has been dropped by SQL Server

Access violation in odbc32.dll when SQL Server connection has been dropped by SQL Server for no apparent reason. In SuperServer it may be seen as a hang, but the access violation has already occurred. The fix is to stop all further database IO when a database fatal error has occurred.

0141363 Connected counts to database server are different in V10 VL environment and V11.

USE_SINGLE_CONNECTION defaulted to YES

0141377 IDE Design emulator shifted position during display editing

Screen designer issue fixed where clicking an element when in a scrolled panel could cause the element to be assigned incorrect line\col information.

0141378
0134667
Checkout retains quotes for literals in SELECT_SQL FIELDS SQL source

Checkout of SELECT_SQL FIELDS SQL Source retains quotes when the 1st character is "-".
Checkout of '''X''' in SELECT_SQL FIELDS SQL source will retain the triple quoting for the X to be interpreted as a literal by SQL.
Checkout of 'X' in SELECT_SQL FIELDS SQL source will retain the single quoting for the X to be interpreted as a column name by SQL.
Checkout of X in SELECT_SQL FIELDS SQL source will add single quotes for the X to still be interpreted as a column name by SQL. Further checkin/checkout will retain the single quoting.
 

0141381
0141342
0141463
Issue with deployment tool when adding an icon

Package including an application icon was actually correctly created but an erroneous fatal error was being issued. This has be resolved.

0141382
0141384
Support sending string LOBs from WAMs

Now you can send the content of a string as a LOB.

0141388 IDE screen Designer fails when selecting from USER KEYS tab

Screen design issue fixed where entering UserKeys via the property sheet grid view would cause the Editor to fail.

0141391 RDMLX File fails to build on IBM i if no primary key (*SQLBUILD)

In an RDMLX partition with *SQL_BUILD the checkin and compile of a file without a primary key now no longer fails in the Label on processing.

0141430 LceSubmit server-side issue: Job Description not set and overwrites Job Name

This defect has now been corrected.

0141471 STM_FILE_WRITE BIF no longer truncates on IBM i when writing to UTF-8 file

When a function is attempting to use the STM_FILE_WRITE BIF on IBM i to write characters that are not in 7 bit ASCII ('A'-'Z', 'a'-'z', '0'-'9' and a few other characters) to a stream file in UTF-8 (CCSID 1208) then the full amount of data is now written.

0141475 Fatal error occurs when trying to see the detailed log of Check-in Compile

This defect has now been corrected.

0141494 Support Visual Studio 2010 as IDE compiler

Note that the install does not yet support the detection of this compiler. In order to use this the registry entry:
LOCAL_MACHINE\Software\Lansa\MicrosoftCompiler\Enabled
must be set to 0 (FALSE) after LANSA has been installed.

This disables the use of the LANSA-shipped Microsoft compiler.

Also, the Microsoft C runtime DLLs to support this version are not installed by LANSA. When Visual Studio 2010 is installed, it installs these DLLs. But, in order to deploy your LANSA application you will need to deploy these DLLs yourself. Refer to Microsoft documentation for more details.

0141527 SELECT_SQL FIELDS with long literals no longer truncated in checkout

SELECT_SQL RDML commands with long literals and embedded quotes in the FIELDS SQL source are no longer truncated during checkout.

0141551 Deployment Tool translation utility issues warning if file missing CTD

The package build has been modified to issue a warning instead of a fatal error if an associated .ctd file is missing from a package with "Deploy with Translation List" selected.

0141561
0141675
Deployment: Install error trying to define dc_w31, but no database selected in package
0141567

*SRVPGM W3S1000 is in 2 different libraries in LANSA for iSeries V12 system

The redundant version in the program library has been removed. The version in the communications library is the correct version.

0141574Importing File Library not being converted to Partition Data Library
0141568MAIL_ADD_TEXT fails with decimal data error on IBM i

When a function is compiled without both *RPGIV AND *ILE defined in data area DC@OSVEROP, use of MAIL_ADD_TEXT in RDML functions on IBM i no longer fails

0141597Import of function without process causes RDMLX process to subsequently fail

On IBM i, when a function is imported without the compiled process, if the process is subsequently executed via the LANSA X_RUN command then it failed indicating that the process was not compiled. For example, this may occur when submitting another function in the same process as the function that was imported.
This defect has been corrected.

0141600
0141831
Trigger fails when Get_Entry Number(2) is executed in a trigger operation

This defect has been corrected.

0141641Packed input field in browselist produces incorrect data

Excessive decimal places are now truncated.

0141653
0142253
0142266
Access violation when Close Form By Click On Windows 'X' Button
0141666Database enforcement trigger now works in a French language environment
0141668jsmdirect fails if no CGI headers are returned to the browser.

If nothing is sent to stdout, jsmdirect will report this as an error if running against a Linux V12 or later LANSA system

0141740Deployment Tool Package does not add components associated with Task

When a task is selected in the object selection dialog, all objects supported by the deployment tool, including components, which are locked to the task are added to the package.

0141747V12 Upgrade package does not update the LX_F96 table to add the X96SRV column

User Action: All packages that deliver the V12 runtime will need to be recreated.

0141765 XSL Editor inline list handler no longer crashes when incorrect value is entered

The XSL Editor inline list handler no longer crashes when an incorrect value is entered into the details tab.

If an incorrect value is entered an error message is shown. Please review the error and correct it before continuing.

An example of an incorrect value is a string without a closing quote, eg, 'hello, world

Entering XPath expressions directly into the details tab, ie, not using the XPath Editor, can also make what looks like a correct XPath expression be an incorrect value.

When entering XPath expressions it is recommended to use the XPath Editor located below the details area.

0141801 LOAD OTHER FILES crashes with 'OSRV_RESTOREFILEVIRTUALDATA'
0141861 SP5/V12 - Input DBCS characters in Functions different to V10
0142013 WinSock control does not receive NULL character from LANSA
0142037 Form with layout managers hangs during resize since upgrading to V12
0142199 Add support for MSSQL2008 R2 to the Package install
0142213 Package warning about deploy database support even though DBUT = NONE
0142214 x_start truncates prompt when DBCS 2nd byte contains '['
0142292It is not possible for the STM_FILE_WRITE builtin to output more than 65535 bytes
0142314Changes to IBM i Web configuration

1. System name column has been expanded to show longer names and a visual cue to indicate names that can't be shown in full.
2. IP addresses are now normalized before being stored.

0142321Duplicate entry error message not showing in IBM i Web configuration

If you tried to add a duplicate system/port entry, the program wouldn't allow you but the error message wouldn't show.

0142406IPv6 support for VL IDE Debugger

IPv6 support for VL IDE Debugger is now working for Windows Vista or later.

 
EPC860
0140416Enable DOCTYPE in XHTML documents

Enable DOCTYPE (DTD declarations) in WAMs to allow standards mode in IE7/IE8

0140784
0140907
When printing a WAM with a List in it, hidden columns cause scrollbars to appear

Hidden columns would make scrollbars appear in the printed page possibly causing some rows to not show up.

EPC861
0140061Web admin change to allow Ready to Use max and min to be increased
0142171 Allow for longer IP address for IPv6

Allow 50 characters for web server name in configuration of IIS Plug-in and Apache Module

 

   EPC859 supercedes EPC851 which included these changes:    [Click here to Show table...]

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 C 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. IF YOU ALREADY HAVE EPC851 INSTALLED GO TO Installing EPC859 with EPC851 already installed
  6. IF DO NOT HAVE EPC851 INSTALLED GO TO Installing EPC859 to V12 GA

Installing EPC859 to V12 GA

  1. Move the unzipped file EPC859 to a shared folder (QDLS) on IBM i. ( e.g. /QDLS/epc859)
  2. Use the XFLRTOSAVF command to convert the folder to a save file (LANSA program library must be on your library list) - press F4 for command details. A save file will be created by this command.
  3. Use the RSTOBJ command to restore the following objects into QGPL library.
    RSTOBJ OBJ(DC@LCP120 LOADEPC) SAVLIB(QTEMP) DEV(*SAVF) SAVF(<save file name>) RSTLIB(QGPL)
  4. For this EPC use the following options:
    1. Install the EPC from = *SVF
    2. Apply this EPC to = FULL_LANSA_SYSTEM
  5. Run the command LOADEPC with the following parameters:

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

    EPC number . . . . . . . . . . . > 859

    Install the EPC from . . . . . . > *SVF

    Save file . . . . . . . . . . . > Name of the save file
    Library Name . . . . . . . . .  Library where the save file is
    Apply this EPC to . . . . . . . FULL_LANSA_SYSTEM
    LANSA program library . . . . . pgmlib

  6. 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.
  7. Delete from QGPL DC@LCP120 program  and LOADEPC command

Installing EPC859 with EPC851 already installed

  1. Move the unzipped file EPC859 to an IFS folder on the IBM i ( e.g. /LANSA_pgmlib/tmp/epc859 )
  2. For this EPC use the following options:
    1. Install the EPC from = *IFS
    2. Apply this EPC to = FULL_LANSA_SYSTEM 
  3. 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 . . . . . . . . . . . > 859

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

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

  4. 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 EPC859 to an IFS folder on the IBM i. ( e.g. /LANSA_admlib/tmp/epc859)
  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:

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

    EPC number . . . . . . . . . . . > 859

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

    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

© 2010 LANSA