EPC - 132800

Date : May 2015

EPC132800 Updates to IBM i and Windows LANSA Integrator

  • New LUI Connector:
    • LUI Connector is a JavaScript library with APIs for resources provided by IBM i servers
    • The APIs interface with LUI Connector Service Provider software installed on an IBM i server.
    • The product equips developers with an interface to request use of IBM i resources from JavaScript in a browser.
  • Add cell merge capability to ExcelService
ProductLANSA Integrator
Version13 SP2
Pre-Requisite Details131900 (V13 SP2)
Related ProductsNone
Document UpdatesThe latest guides are available at http://www.lansa.com/support/docs/update.htm

Instructions to install the EPC

EPC132800 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 EPC132800.EXE file from the Web site or email.
  2. Unzip (double click) EPC132800.EXE. These files will be extracted:
    • EPC132800 - IBM i Save file
    • EPC132800w.exe - Windows Visual LANSA install executable

Instructions provided for:

Detailed changes

CCS id.Description
0152477Enhance Multipart upload by using a Shared InputStream

A shared InputStream is used to reduce the memory requirements for multiple file upload.
0152479Add PDF/A-3B support to PDFSpoolFileService

This support ensures that PDFs that are created comply with ISO standards.
0152480Upgrade JTOpen to version 8.4


0152481Add LongReach notify for get, put and delete file/folder transactions

This allows an administrator to monitor all types of operations on files and folders.
0152609Develop LUI Connector

LUI Connector is a JavaScript library with APIs for resources provided by IBM i servers.
The product equips developers with an interface to request use of IBM i resources from JavaScript in a browser. For example, call a program, retrieve or update data areas, change a user password or place or retrieve messages on a data queue.
For more information, contact your LANSA product vendor.
0152871Add cell merge capability to ExcelService

The ADD OBJECT(*CELLMERGE) R1C1(10,3) R2C2(12,5) has been added to the ExcelService to allow merging of cells.
0152872Unicode hypen, dashes and quotes are not supported by job CCSID

The problem is that the Unicode characters in the Excel cell value are not supported by job CCSID.

\u2013 – EN DASH
\u201C “ LEFT DOUBLE QUOTATION MARK
\u201D ” RIGHT DOUBLE QUOTATION MARK
\u2018 ‘ LEFT SINGLE QUOTATION MARK
\u2019 ’ RIGHT SINGLE QUOTATION MARK

The ExcelService has been enhanced to replace these characters with their ASCII/EBCDIC versions.

\u002D - HYPEN & MINUS
\u0022 " QUOTATION MARK
\u0027 ' APOSTROPHE
0152889Change MessageDigest algorithm from SHA to SHA-1

Do not use alias SHA, but use standard name SHA-1
0152891Change default SSLContext protocol from SSL to TLS

The industry has moved to TLS 1.0 as the minumum SSL protocol level.
0152909
0152741
Enhance JavaMail 1.4.7 code to handle UTF-8 bytes instead of US-ASCII bytes

This defect has now been rectified
0153008
0153007
Object cast exception when using SSL tunnelling via proxy

HTTP SSL Tunneling via proxy server was casting proxy socket not SSL socket.
This defect has now been rectified
0153071Upgrade certificate creation to allow SHA256WithRSA signing

PKIEditor and AS2CertificateService have been enhanced to allow certificate signing using the SHA256WithRSA algorithm.
0153072Add new properties to manager.properties and SystemDefault.properties

New properties are:

# mail.mime.decodefilename=true
# mail.mime.encodefilename=true
# mail.mime.decodeparameters=true
# mail.mime.encodeparameters=true

# os400.file.encoding.ccsid=01208
0153073Add support for Unicode JSM command, status and message fields

It is now possible to define the RDMLX JSM BIFs to use Unicode fields.
This will allow Unicode command strings to be passed to the JSM service and Unicode status and message to be returned.
0153074Add SET SUBJECT(*LIST) to the SMTPMailService to allow settting of subject value

The email SUBJECT value can now be set using a working list field value.
0153251Enhance FTP and HTTP services trace SSL certificates to trace files

If a custom SSL socket factory is configured and trust SSL server option is enabled, then received SSL certificates are written to trace files TRUST_CERT_n.CER.
0153363Enhance ExcelService to allow get cell count for a specified row


0153448Default system/mailcap.txt SMIME entries changed from Phaos to Bouncy Castle

The mailcap.txt entries for SMIME have been changed to Bouncy Castle classes.

Install Instructions

  1. Backup all the LANSA Integrator library and ALL the Integrator IFS objects (LANSA_jsmlib/jsm) before applying this EPC (this IFS is backed up by the EPC load program)
  2. End the JSM server to be upgraded before installing EPC132800.
  3. 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.
  4. Move the unzipped file EPC132800 to an IFS folder on the IBM i. ( e.g. /LANSA_jsmlib(pgmlib)/tmp/epc132800' )
  5. For this EPC use the following options:
    1. Install the EPC from = *IFS
    2. Apply this EPC to = LANSA_INTEGRATOR
  6. Run the command LOADEPC with the following parameters:
    jsmlib
    /LOADEPC and press command 4 (F4) to prompt the command (This command also can be run in batch)

    EPC number . . . . . . . . . . . > 132800

    Install the EPC from . . . . . . > *IFS
    IFS Path and object name . . . . eg: /LANSA_jsmlib(pgmlib)/tmp/epc132800
    Apply this EPC to . . . . . . . > LANSA_INTEGRATOR
    LANSA Integrator library . . . jsmlib
    LANSA program librar . . . pgmlib (This is optional)

  1. End the JSM server to be upgraded before installing EPC132800.
  2. Make a backup of the JSM directory from the IBM i. The current JSM directory will also be saved in the backout library.
  3. EPC132800 must be extracted onto a Windows machine then uploaded onto the iSeries server.
    For iSeries shared folders:
  • in Explorer, map to the shared folder drive
  • create a folder named EPC132800
  • copy unzipped file EPC132800 to folder EPC132800
  1. Get the EPC132800 file into IBM i as ta save file. Can use FTP or CPYFRMSTMF command
  2. Use the OS/400 RSTOBJ (restore object) command to restore all objects from library QTEMP into library QTEMP.

For a save file you will use the following command:
RSTOBJ OBJ(*ALL) SAVLIB(QTEMP) DEV(*SAVF) SAVF(EPC132800) RSTLIB(QTEMP)

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

    Install the EPC using the command:
    LOADEPC EPCNUM(132800) USE(*SVF) SAVF(EPC132800) SELECT(LANSA_INTEGRATOR) JSMLIB(<jsmlib>) PGMLIB(<LANSA_pgmlib>)

    Where <jsmlib> is the name of the LANSA Integrator JSM library. This is often JSMLIB but it may be different on your system.

    Where <LANSA_pgmlib> is LANSA program library name and is optional.
  2. Press enter to continue processing.
  1. End the JSM server to be upgraded before installing EPC132800.
  2. Make a backup of the Integrator directory from Windows.
  3. Unzip (double click) EPC132800w.exe to start the upgrade of LANSA Integrator on Windows.
    NOTE: Please view the Additional Install Notes section in this document for important post-installation/upgrade checks.

When the JSM instance starts it will process the files in the upgrade directory. If the upgrade is successful the JSM instance will restart else the instance will end. Check the file UPGRADE-LOG.txt in the JSM instance directory for upgrade messages.
An example of the upgrade messages :

--------------------------------------------
manager: version : 13.2.2
upgrade: version : 13.2.2
-
java.class.path : ./jar/jsm.jar:./jar/jsmide.jar:./jar/jsmjaf.jar
-
Upgrade instance : /LANSA_inxpgmlib/jsm/instance
-
Backup instance : /LANSA_inxpgmlib/jsm/instance
-
System file deleted : device-davifs.txt
...
-
System file already exists : ClassCache.jar
...
-
Add system file : device-unknown.txt
...
-
Replace system file : httpd-template.xml
...
-
Upgrade properties file : manager.properties
Properties file upgraded
...
-
Instructions
PRODUCT=JSM
-
Integrator upgrade
-
Add system file : httpd.xml
-
Add system file : webifs.html
-
Add system file : webifs-search.html
-
Upgrade integrator manager properties
-
Upgrade completed
--------------------------------------------
Remove upgrade files
-
File removed : /LANSA_inxpgmlib/jsm/instance/upgrade/AS2CertificateService.properties
...
-
Remove upgrade directory
-
Removal completed
--------------------------------------------

© 2014 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.