FIX3.03.05 · Released 25 February 2021
FIXfinPOWER Connect
Released in
3.03.05
25 February 2021
  1. Opened21 Dec 2020
  2. Closed24 Dec 2020
  3. Released25 Feb
Article 17723 Job J025713

Sample Account Processes "Account History Rating Update" script; fails if Client Group or Client Type range specified

The sample Account Processes "Account History Rating Update" script fails if a Client Group or Client Type range specified.

The error is "Failed to run Account Processes. Failed to run script 'AP.HISTRAT'. Failed to open DataReader. Failed to open DataTable. No value given for one or more required parameters.".

Note, this occurs because the "Client" table is not joined into the SQL query.

The following sample script has been updated:

  • AP.HISTRAT
    • Script_AccountProcesses_AccountHistoryRatingUpdate.xml
    • Version 1.06 (24/12/2020)