Jiwa 7.02.01.25
- 1 Breaking Change
- 2 Standard Plugin Change
- 3 Naming Change
- 4 Installer Change
- 5 Potential Breaking Changes
- 5.1 REST API
- 5.2 Microsoft Graph REST API
- 6 About Service Releases
- 7 Where to Obtain
- 8 How to Install
- 9 How to remove / roll-back
- 10 Solutions in Addition to Service Release
- 11 Issues Addressed in Service Release
- 12 REST API
- 13 Cumulative Issues Addressed In Service Release
Breaking Change
The installer now deploys Crystal Reports Runtime SP39 (instead of SP22) which contains a critical bug fix for Windows Server 2022 (DEV-12402).
This means that plugin assembly references will be broken because they will be looking for the old SP22 Crystal components. The installer cannot automatically fix this because it essentially requires a database change. Service Releases typically avoid database changes; however, due to the severity of the Crystal Runtime bug, a one‑off exception was necessary to implement the required fix.
To update plugin references to point to SP39 Crystal components, and a new version of Microsoft.SqlServer.Dac, run this SQL script (some other housekeeping is also performed on the standard Jiwa plugins):
UPDATE SY_PluginReference SET AssemblyFullName = REPLACE(AssemblyFullName, '13.0.3500.0', '13.0.4000.0') WHERE AssemblyName LIKE 'CrystalDecisions%'
GO
UPDATE SY_PluginReference SET AssemblyFullName = REPLACE(AssemblyFullName, '162.0.0.0', '170.0.0.0') WHERE AssemblyName LIKE 'Microsoft.SqlServer.Dac%'
GO
UPDATE SY_PluginReference SET AssemblyFullName = REPLACE(AssemblyFullName, 'b03f5f7f11d50a3a', '89845dcd8080cc91') WHERE AssemblyName LIKE 'Microsoft.SqlServer.Dac%'
GO
--Delete known unnecessary references
DELETE FROM SY_PluginReference WHERE (AssemblyName LIKE 'CrystalDecisions%' OR AssemblyName = 'Microsoft.SqlServer.Dac.dll') AND SY_Plugin_RecID IN
(
SELECT RecID FROM SY_Plugin WHERE Author = 'Jiwa Financials' AND Name IN
(
'Allow Notes in Purchase Orders To Always Be Editable',
'Bendigo Bank Cashbook CSV Imports',
'Bill of Materials Import',
'Cashbook Bank CSV Import',
'CBA Export EFT Batch to ABA File',
'Copy Bill Custom Field Values To Work Order',
'Custom Ribbon Tool Mapping',
'Custom Search - Email',
'Debtor Export to CSV',
'Debtor Statement Emailing',
'Demonstration Data Custom Fields',
'Email - Configuration Office365 REST',
'Email - Configuration Outlook',
'Email - Configuration SMTP',
'Email Plugin',
'Export EFT Batch to ABA File',
'File Watcher',
'Find Stock From Other Sales',
'IFS Smartfreight',
'Import Queue Processing',
'Insert New Inventory Item',
'Inventory Console',
'Inventory Document Import',
'Inventory Export to CSV',
'Inventory Image File Watcher',
'Inventory Image Legacy Import',
'Inventory Import Debtor Specific Prices',
'Inventory Import Notes',
'Inventory Maintenance - Rename Part No.',
'Inventory Web Tab',
'Journal Set Copy Reference',
'Journals Created From Sales Orders - Group by Sign and Account',
'Launch App',
'Legacy Pre-Version 7 Plugin',
'Magento Integration',
'Magento Integration Action Sample',
'Make Quote From Sales Order',
'Manual Serial Numbers',
'Mark PO As Sent When PO Emailed',
'Move Lines to New Order',
'Move Outstanding Amounts to New Order',
'MYEExport',
'New Journals As Pending',
'Pantry List',
'Password Policy',
'Paypal CC Processing',
'Permission Override',
'POS',
'Process Sales Orders - Untick Process by Default',
'Production Planning Method - Build To Order',
'Production Planning Method - Replenish to Minimum',
'Purchase Order Generation Reorder Method - Replenish to Minimum',
'Purchase Order Generation Reorder Method - Sales Forecast',
'Purchase Order Reorder Method - Replenish to Minimum',
'Purchase Order Reorder Method - Weighted And YTD Average',
'Reduce Deliveries',
'Report Image',
'REST API Custom Routes Example',
'Sales Order - Print Invoice On Save',
'Sales Order Create Purchase Orders',
'Sales Order Customer Panel',
'Sales Orders - Round Cash Sales to Nearest 5c',
'Sample Custom Fields',
'Service Job Labour - Set BillingTime To Elapsed Time',
'Sort Notes',
'Staff Branch Assignment',
'Staff Warehouse Assignment',
'Warehouse Styling',
'Web Browser',
'Westpac Export EFT Batch to ABA File'
)
)
GO
DELETE FROM SY_PluginReference WHERE AssemblyName = 'Microsoft.SqlServer.Dac.dll' AND SY_Plugin_RecID IN
(
SELECT RecID FROM SY_Plugin WHERE Author = 'Jiwa Financials' AND Name IN
(
'Email Report',
'Purchase Order Custom Email',
'Sales Order Custom Email',
'Sales Quote Custom Email',
'REST API'
)
)
GO
UPDATE SY_PluginReference SET AssemblyFullName = 'ZetaHtmlEditControl, Version=1.1.0.4, Culture=neutral, PublicKeyToken=2e2e5ba5da72b6c0' WHERE AssemblyFullName = 'ZetaHtmlEditControl, Version=1.1.0.3, Culture=neutral, PublicKeyToken=2e2e5ba5da72b6c0'
GO
UPDATE SY_PluginReference SET AssemblyFullName = 'Microsoft.ApplicationInsights, Version=2.23.0.29, Culture=neutral, PublicKeyToken=31bf3856ad364e35' WHERE AssemblyFullName = 'Microsoft.ApplicationInsights, Version=2.4.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35'
GO
UPDATE SY_PluginReference SET AssemblyFullName = 'Microsoft.SqlServer.Dac, Version=170.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' WHERE AssemblyFullName = 'Microsoft.SqlServer.Dac, Version=14.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a'
GO
UPDATE SY_PluginReference SET AssemblyFullName = REPLACE(AssemblyFullName, '7.2.1.0', '7.2.1.25')
GO
UPDATE SY_BusinessLogic SET AssemblyFullName = REPLACE(AssemblyFullName, '7.2.1.0', '7.2.1.25')
GO
--Touch all plugins to force a recompile
UPDATE SY_Plugin SET IsEnabled = IsEnabled
GOStandard Plugin Change
From Jiwa 7.2.1.25 onwards, updated standard Jiwa plugins will be installed at <InstallationFolder>\Plugins. If desired, these can be imported into Jiwa to replace older versions. Note that a new plugin called “Import Multiple Plugins” is included - import this one first, log out and back into Jiwa, and now the Plugin Maintenance form will show an “Import Multiple Plugins” button. This button can be used to import many plugins at once.
Naming Change
From Jiwa 7.2.1.22 onwards, Service releases are now identified by looking at the 4th digit of the version number, i.e. 07.02.01.25. A change in only the 4th digit of the version number means there are no database changes and implies that this is a service release.
Installer Change
The installer for service releases are now full installs, not just patches.
The installer uninstalls whatever 7.2.1.0 SR and 7.2.1.0 base install are present and installs itself.
It is a complete installer, not just a patch - a 7.2.1.0 base install is no longer required.
A new user can just install “Jiwa 7.2.1.25 Setup.exe” and they are good to go (previously they would have to install 7.2.1.0, and then the desired SR .msp file).
To roll back this SR, one would uninstall it via Add/Remove Programs, then re-install 7.2.1.0 base, and then install the 7.2.1.0 SR that is desired (ie. 7.2.1.0 SR21).
Potential Breaking Changes
REST API
A previous service release, 07.02.01 SR 15, introduced a potential breaking change to plugins which extend the REST API. As this Service Release, 07.02.01.25, includes those changes upgrading to 07.02.01.25 may expose you to breaking changes. See the breaking changes section of the Jiwa 7.02.01.00 Service Release 15 article for details.
It is also advisable to update the REST API to the version shipped with 07.02.01.25 - see the section below on Obtaining the latest REST API.
Microsoft Graph REST API
Because 7.2.1.25 is a full install, any previous additional DLLs you had installed for Microsoft Graph REST API emailing plugin need to be re-installed. See here for more information about this plugin. https://jiwa.atlassian.net/wiki/x/_QgP
About Service Releases
Jiwa 7 Service Releases are cumulative, and later Service Releases supersede earlier Service Releases.
This means you only need to install the most recent Service Release to obtain all the fixes of previous Service Releases. Installing a later Service Release will automatically remove older Service Releases.
Where to Obtain
The service release is obtained from the Downloads page of the new Jiwa Customer Portal.
How to Install
Typically, the .exe file, once downloaded can by run simply by double-clicking the file to run. If upgrading from a previous version it is advised to make a backup of config files (i.e. JiwaAPISelfHostedService.exe.config, JiwaPluginSchedulerService.exe.config) and put them back in place after installation.
You may get the following error during installation - “Visual C++ 2005 SP1 Redistributable (x86) mandatory prerequisite was not correctly installed”. This is usually due to Antivirus Software. Disable the software temporarily and restart the Jiwa 07.02.01.23 Installation.
How to remove / roll-back
Jiwa 7.2.1.25 is a full install, so to remove or roll-back, you Uninstall Jiwa 7 from Add / Remove Programs and Features in Control Panel.
In addition, 7.2.1.25 comes with a later release of SAP Crystal Reports runtime engine, which is not compatible with earlier versions of Jiwa. Therefore you must remove this as well.
If you don’t un-install SAP Crystal Reports runtime 13.0.39.5601, then Jiwa 7.2.1.24 and prior will fail to launch.
To roll back to an earlier version of Jiwa, either install 7.2.1.22 onwards from the downloaded installer, or for an even earlier version, install 7.2.1.0, then the Service Release you desire.
Solutions in Addition to Service Release
There are issues that have been addressed that cannot be included in Service Releases. There are also enhancements that are described in more detail in this section. Please review this list - Solutions in Addition to Service Releases.
Issues Addressed in Service Release
Jiwa 07.02.01.25 includes all issues addressed in Jiwa 07.02.01.24 in addition to the following:
REST API
The minimum version of the REST API plugin for 07.02.01.25 is 7.2.1.54. The version deployed in the package with this release is 7.2.1.69.
When importing the plugin for use, don’t forget to enable it.
Obtaining the latest REST API
The REST API can now be obtained from the Plugins folder under the Jiwa installation folder (e.g. Program Files (x86)\Jiwa Financials\Jiwa 7\Plugins). Locate the Plugin REST API.xml file and import this into Jiwa using the Plugin Maintenance form.
NOTE: Using the latest REST API plugin will require all clients to have the same Service Release installed, as the plugin is dependent on changes only introduced in this Service Release.
Cumulative Issues Addressed In Service Release
A complete list of all issues addressed: