IBM Support

IBM i 7.5 Infor LX BPCS Technical Note

How To


Summary

Information for installing and running Infor LX and BPCS solutions on IBM i 7.5

Objective

​You are in:  ERP Solutions on IBM i  >  Infor and Lawson Solutions on IBM i  > IBM i 7.5 Infor LX BPCS Technical Note


IBM i 7.5 Infor LX and BPCS Technical Note 

Last updated 23 February 2024

Overview 

Technote contains information for installing or running Infor's BPCS and LX products on IBM i 7.5. This information includes required PTFs for IBM i and related operating system components, minimum levels supported for Infor LX (BPCS) software, or other information on known problems and restrictions.

Currently, supported versions include: LX 8.4.2, LX 8.4.1, LX 8.4.0, LX 8.3.5.

SQL Statement Errors - "Blank" vs Numeric Comparison

IBM made a change in IBM i 7.4 database group 13 (SF99704-13) as part of PTF SI76030, and in 7.3 database group 24 (SF99703-24) as part of PTF SI76035 to fail SQL statements that are making a comparison between an empty or blank string to a numeric value.  Infor LX has SQL statements where this type of comparison is being made, thus causing failures after the PTF is applied.  Error messages you might receive in this case: CPD4374 RC7, SQL0302 RC6, or SQL0678 RC6.
Previous to IBM i 7.5 a work around was available to revert to the old behavior to circumvent the errors. Therefore, in IBM i 7.5 that work around is no longer available, Infor LX BMRs are required to be installed. See Known Issues and Resolutions below for BMR details.

IBM Program Fixes (PTFs) 

PTFs are not listed out individually below once they are part of the latest group PTF or cumulative release. Therefore, it is STRONGLY recommended that you put in place a process to regularly obtain and apply the latest update of the Group PTF for SQL and Database to your system.

Any PTFs required by BPCS programs which are NOT included in the database group PTF or latest Cumulative, are listed separately below. Currently, there are no individual required PTFs for IBM i 7.5.

The most current IBM i 7.5 CUM and HIPER PTFs are strongly recommended as a minimum set. Other recommended PTF groups include the Database Group, Security Group, and HTTP Server Group. Here are some useful links for finding and applying PTF groups.

The current Cumulative PTF documentation (SF99750) can be found at this link:   http://www-01.ibm.com/support/docview.wss?uid=nas4SF99750 

The latest HIPER Group PTF (SF99959) can be found at this link:   http://www-01.ibm.com/support/docview.wss?uid=nas4SF99959

The latest Db2 for i Group PTF (SF99950) can be found at this link:   http://www-01.ibm.com/support/docview.wss?uid=nas4SF99950

The following link lists the IBM i Group PTFs for all IBM i releases, including links to the latest: https://www.ibm.com/support/pages/ibm-i-group-ptfs-level

Use the WRKPTFGRP command to check the current level of the installed PTF cum and groups on your system. By default WRKPTFGRP will show multiple levels, but you can specify WRKPTFGRP PTFGRPLVL(*LATEST) to show the latest applied level.

Known Issues and Resolutions 

LX Programs SQL Errors

Affected versions: LX 8.4.2, LX 8.4.1, LX 8.4.0, LX 8.3.5, and LX Extensions 3.0/2.3

An IBM i 7.5 change to SQL error handling regarding a query that included an incompatible comparison between a numeric value and blank(s) or a numeric value and an empty string will now result in an SQL failure.

See KB 2252214 for BMRs required to resolve these SQL errors.

Webtop Will Not Launch LX Programs

Affected versions: Webtop 4.7, Webtop 4.8

An IBM i 7.5 change to socket application security was made to set the default *PUBLIC data authority of Unix sockets to *NONE.

See Primary Solution for WebTop 4.7 Infor LX and Infinium (KB 1992942) regarding required fixes.

System i Workspace Anywhere

Support requires feature pack FP17, see KB 1963350 for SiW Feature Pack information.

IDF Framework

Support requires IDF Framework 9.2 or 10.0 to be running at Java 1.8 or higher.

Document Location

Worldwide

[{"Type":"MASTER","Line of Business":{"code":"LOB57","label":"Power"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SWG60","label":"IBM i"},"ARM Category":[{"code":"a8m0z0000000CGbAAM","label":"General Information"}],"ARM Case Number":"","Platform":[{"code":"PF012","label":"IBM i"}],"Version":"7.5.0"}]

Document Information

Modified date:
26 February 2024

UID

ibm16831247