Issues
- Sunflower 2025-R1 Schema testingMODFISTO-522Resolved issue: MODFISTO-522Boburbek Kadirkhodjaev
- Sunflower 2025-R1 releaseMODFISTO-521Resolved issue: MODFISTO-521Mikita Siadykh
- Support multiple groups per fund in finance data and improve the viewMODFISTO-520
- Only one row for unique budget should be displayed in batch allocation form if fund is included in different groupsMODFISTO-519Resolved issue: MODFISTO-519Serhii_Nosko
- Sensitive data in logs cleanupMODFISTO-516
- Create budget when adding batch allocation to fund without budgetMODFISTO-517Resolved issue: MODFISTO-517Serhii_Nosko
- Support deleting pending payments with batch transaction APIMODFISTO-515Resolved issue: MODFISTO-515Serhii_Nosko
- Encumbrance script: remove links to encumbrances for pending orders in an old FYMODFISTO-514Resolved issue: MODFISTO-514Serhii_Nosko
- Add support of optimistic locking in credits migration scriptMODFISTO-511Resolved issue: MODFISTO-511Azizbek Khushvakov
- Optimistic locking error displays in error message instead of banner when editing the same Group in “Finance” appMODFISTO-513Resolved issue: MODFISTO-513Azizbek Khushvakov
- Replace mod-configuration to retrieve active host address to send emailMODFISTO-509
- Missing interface dependencies in module descriptorMODFISTO-508Resolved issue: MODFISTO-508Serhii Nosko
- Add ability to filter DB View results by set of fieldMODFISTO-507
- Implement endpoint to return financial data for FYMODFISTO-506
- Encumbrance value incorrect after paying credit invoiceMODFISTO-512Resolved issue: MODFISTO-512Dennis Bridges
- Release Ramsons versionMODFISTO-505Resolved issue: MODFISTO-505Serhii_Nosko
- Perform DB schema testing for Ramsons releaseMODFISTO-503Resolved issue: MODFISTO-503Boburbek Kadirkhodjaev
- Implement endpoint to save FY finance data in bulkMODFISTO-501Resolved issue: MODFISTO-501Azizbek Khushvakov
- Implement endpoint to return all finance data for FYMODFISTO-500Resolved issue: MODFISTO-500Azizbek Khushvakov
- Update libraries of dependant acq modules to the latest versionsMODFISTO-499Resolved issue: MODFISTO-499Saba Zedginidze
- Create table and API for fund updates logsMODFISTO-497Resolved issue: MODFISTO-497Azizbek Khushvakov
- FYR page (ledger tab) doesn't reflect current FYR infoMODFISTO-496Resolved issue: MODFISTO-496
- Investigate Time-out issue during FiscalYearRollover on eureka environmentMODFISTO-495Resolved issue: MODFISTO-495Boburbek Kadirkhodjaev
- Support Kitfox to investigate Rollover failure on 30k orders for QuesneliaMODFISTO-492Resolved issue: MODFISTO-492Boburbek Kadirkhodjaev
- Encumbrance script: fix inconsistent reEncumber valuesMODFISTO-491Resolved issue: MODFISTO-491
- Investigate RRT issue with enabling mod-finance-storage on some of Q clustersMODFISTO-490Resolved issue: MODFISTO-490Serhii_Nosko
- Review and cleanup Module Descriptor for mod-finance-storageMODFISTO-489Resolved issue: MODFISTO-489Mikita Siadykh
- Wrong encumbrance when cancelling an invoice with an order that is not openMODFISTO-488Resolved issue: MODFISTO-488Dennis Bridges
- Preview rollover fails with max_locks_per_transaction default setting for postgres 14MODFISTO-486Resolved issue: MODFISTO-486
- FYRO test fails with database errors, remains In Progress indefinitelyMODFISTO-485Resolved issue: MODFISTO-485
- Wrong budget overEncumbrance calculationMODFISTO-484Resolved issue: MODFISTO-484Dennis Bridges
- Add credited field support to Rollover functionalityMODFISTO-483Resolved issue: MODFISTO-483Dennis Bridges
- Migration script to separate credits from expendituresMODFISTO-482Resolved issue: MODFISTO-482Azizbek Khushvakov
- Separate credits from expenditures in mod-finance-storageMODFISTO-481Resolved issue: MODFISTO-481Azizbek Khushvakov
- Old tables are not deletedMODFISTO-480Resolved issue: MODFISTO-480Serhii_Nosko
- Poppy to Quesnelia schema comparison for mod-finance-storage Poppy to Quesnelia comparisonMODFISTO-479Brandon Barnette
- Prevent deleting transactions that are not encumbrances or pending paymentsMODFISTO-478
- A new encumbrance is needed during FYRO for orders with "Re-encumber" = falseMODFISTO-477Resolved issue: MODFISTO-477Dennis Bridges
- mod-finance-storage: module releaseMODFISTO-476Resolved issue: MODFISTO-476Mikita Siadykh
- Change restricted expenditures calculationsMODFISTO-472Resolved issue: MODFISTO-472Dennis Bridges
- mod-finance-storage: schema testingMODFISTO-471Resolved issue: MODFISTO-471Serhii_Nosko
- mod-finance-storage: Upgrade RAML Module BuilderMODFISTO-470Resolved issue: MODFISTO-470Saba Zedginidze
- Encumbrance script: do not try to fix orderStatus for past fiscal yearsMODFISTO-469Resolved issue: MODFISTO-469Serhii_Nosko
- Update budgets when deleting transactionsMODFISTO-468
- Analyze logs from karate tests run where indexes should be added, unnecessary logs disabledMODFISTO-467Resolved issue: MODFISTO-467Azizbek Khushvakov
- Make usage of an DB index for transaction type in the rollover scriptMODFISTO-466Resolved issue: MODFISTO-466Serhii_Nosko
- Wrong encumbrance calculation when paying a creditMODFISTO-475Resolved issue: MODFISTO-475Dennis Bridges
- Investigate failing integration testMODFISTO-465Resolved issue: MODFISTO-465Serhii_Nosko
- Investigate failing integration testMODFISTO-464Resolved issue: MODFISTO-464Serhii_Nosko
- Update integration tests to use the new transaction APIMODFISTO-463Resolved issue: MODFISTO-463Serhii_Nosko
50 of 428
Sunflower 2025-R1 Schema testing
Done
Description
Environment
None
Potential Workaround
None
Attachments
6
Checklist
hideDetails
Details
Assignee
Boburbek Kadirkhodjaev
Boburbek KadirkhodjaevReporter
Mikita Siadykh
Mikita SiadykhPriority
TBDStory Points
0.5
Sprint
None
Development Team
Thunderjet
Release
Not For Release
TestRail: Cases
Open TestRail: Cases
TestRail: Runs
Open TestRail: Runs
Created March 7, 2025 at 9:40 AM
Updated March 11, 2025 at 1:23 PM
Resolved March 11, 2025 at 1:23 PM
Activity
Show:
Serhii_Nosko March 11, 2025 at 1:23 PM
We agreed that this is expected discrepancy because we use CREATE TABLE IF NOT EXISTS and had in subsequent PR modified it, and change was not applied because table already exist. This is not a case for Bugfest and production envs, so we are good here.
Boburbek Kadirkhodjaev March 11, 2025 at 11:01 AM
Found 1 minor discrepancy in the job_number table schema, but other than that all is good
Boburbek Kadirkhodjaev March 11, 2025 at 10:44 AMEdited
https://github.com/folio-org/mod-finance-storage/pull/463
Applied DB changes
src/main/resources/templates/db_scripts/schema.json
Updated the default value on job_number table from 1 to 0
But found a discrepancy between the expected and actual schema states, although it is probably due to the absence of an alter query in the PR which should’ve updated the existing table with the new field default value
Boburbek Kadirkhodjaev March 11, 2025 at 10:42 AM
https://github.com/folio-org/mod-finance-storage/pull/462
No DB changes we made
Boburbek Kadirkhodjaev March 11, 2025 at 10:42 AM
https://github.com/folio-org/mod-finance-storage/pull/461
No DB changes we made
Testing module schema for tenant
fs09000000Using environment https://folio-etesting-sprint-fs09000000.ci.folio.org/
Using PgAdmin: https://folio-etesting-sprint-pgadmin.ci.folio.org/
Using PRs: Pull requests · folio-org/mod-finance-storage