2022.2

Table Of Contents
3
If the No source port range restriction option is checked (recommended), see footnote 1. If the
option is unchecked, the local port will be chosen from a range going from 721 to 731.
4
Contact your DBMS vendor to determine which ports are used by the ODBC driver for accessing a net-
work database.
Known Issues
Microsoft patch causing handling of XLS to fail
Some Windows updates from Microsoft have impacted the handling of XLS sources in PReS\Plan-
etPress Workflow 8.
The Microsoft updates concerned are as follows:
l
KB4041693 for Windows 8.1 and Windows Server 2012 R2
l
KB4041681 for Windows 7 and Windows Server 2008 R2
l
KB4041690 for Windows Server 2012 (no service pack)
Installing these updates may cause the application to fail when attempting to open or load XLS files via
a plugin or in a script. The following error message may appear: Unexpected error from external data-
base driver (1). (Microsoft JET Database Engine)".
Suggested resolution
Uninstall the Microsoft patches and wait for the issue to be fixed in a subsequent Microsoft patch.
Workarounds
l
For the Lookup in Microsoft Excel Documents plugin (found in the Connectors tab of the plugin
bar): Open the original .xls file and save it with the .xlsx format. That will force the Excel Lookup
plugin to switch drivers.
l
For the Database Query plugin (found in the Actions tab of the plugin bar) and when using
Excel/Access in PlanetPress Design: Change the ODBC driver used for Excel files from JET to
ACE (change the Data Source). As an example: in Windows 10: Change the Excel File ODBC
driver from ODBCJT32.dll to ACEODBC.dll. (Naming may vary from versions of the OS but the
basics stay the same.) Important: Before switching from JET to ACE, install the latest MS
Access Database Engine 2016 Redistributable (https://www.microsoft.com/en-us/-
download/details.aspx?id=54920). Otherwise, using ACE in one or more self-replicating pro-
cesses in a Workflow configuration can cause Workflow to crash.
In the meantime Objectif Lune would like to apologize to any customers affected by this problem and for
any inconvenience caused. For more information, please contact your local support team.
Page 27