Article Details
Id: | 17723 |
Product: | finPOWER Connect |
Type: | FIX |
Version: | 3.03.05 |
Opened: | 21/12/2020 |
Closed: | 24/12/2020 |
Released: | 25/02/2021 |
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)