2021.2

Table Of Contents
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 processes 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.
Data Repository error
The Push to Repository task, as well as the corresponding repository API calls SetValue() and
SetValueW() may on rare occasions fail with an unexpected error (517), caused by the Write
Ahead Logging (WAL) journal mode.
The workaround is to disable WAL journal mode:
1. Create the "Repository" key in \HKEY_LOCAL_
MACHINE\SOFTWARE\WOW6432Node\Objectif Lune\PlanetSuite\PlanetWatch\8.0\ if it
does not exist.
2. Add a new DWORD32 value in Repository key named SQliteWALJournalMode and
set it to 0.
Switching the registry key from 1 (WAL) to 0 (DELETE) disables the Write Ahead Log.
3. If the Write Ahead Log is disabled, -sham and -wal files should no longer appear in the
Repository folder.
4. Restart the PPWatch service.
Page 27