[Central-Ledger] initial "OPEN" settlementWindow is failing on clean install

[mdebarros]

Summary:

Golden Path tests are failing on a new "fresh" deployment (including external backend dependencies).

This is due to Migration/Seeds (InitContainer) failing due to the following error when inserting the initial SettlementWindow on the Seed script seeds/settlementWindow2Open.js:

Working directory changed to /opt/app/config
Uploading seeds for initial settlementWindow has failed with the following error: AssertionError [ERR_ASSERTION]: The values in where clause must not be object or array.
Ran 23 seed files

This also results in the following error on the Fulfil Handler when allocating the "OPEN" settlementWindow:

TypeError: Cannot read properties of undefined (reading 'settlementWindowId')
    at /opt/app/src/models/transfer/facade.js:355:64
    at processTicksAndRejections (node:internal/process/task_queues:96:5) {stack: 'TypeError: Cannot read properties of undefine…ions (node:internal/process/task_queues:96:5)', message: 'Cannot read properties of undefined (reading 'settlementWindowId')'}

Severity:
Critical

Priority:
High

Expected Behavior

• Migration/Seeds should execute without error
• GP Test-Collections should pass

Steps to Reproduce

1. Deploy a new MySQL DB for Central-Ledger
2. Run npm run migrate script

Specifications

• Component (if known): Central-Ledger
• Version: v17.0.0
• Platform: n/a
• Subsystem: n/a
• Type of testing:
• Bug found/raised by: @mdebarros

Notes:

• Severity when opened: Critical
• Priority when opened: High

[mdebarros]

PR for fix: mojaloop/central-ledger#946

This issue was introduced in Knex v2.4.0+ with the following change:

• MySQL: Add assertion for basic where clause not to be object or array - knex/issues/#1227