Grzegorz Michalski
60b218d211
Hotfix - Add filtering for successful workflows in archival queries
2026-02-26 20:37:03 +01:00
Grzegorz Michalski
c607bbe26e
Update CSDB DEBT tables to set MINIMUM_AGE_MONTHS to 0 for current month only
2026-02-25 07:00:04 +01:00
Grzegorz Michalski
472a724fe0
Update FILE_MANAGER package to version 3.5.1; fix TIMESTAMP field syntax for SQL*Loader compatibility and add T2_PEAK_LIQUIDITY_NEED template table
2026-02-24 19:19:45 +01:00
Grzegorz Michalski
b588b0bb72
Add FILE_MANAGER package installation and rollback scripts; update installation process for compatibility with MARS-828
2026-02-23 09:14:20 +01:00
Grzegorz Michalski
99aca3af40
wk1
2026-02-20 15:22:58 +01:00
Grzegorz Michalski
1089184367
wk1
2026-02-20 15:18:08 +01:00
Grzegorz Michalski
b85172ae84
wk1
2026-02-20 14:25:19 +01:00
Grzegorz Michalski
577c94f363
Zmiana nazw kolumn
...
ARCHIVE_ENABLED → IS_ARCHIVE_ENABLED (konwencja boolean)
KEEP_IN_TRASH → IS_KEEP_IN_TRASH (konwencja boolean)
2026-02-20 11:56:41 +01:00
Grzegorz Michalski
8ce07c3360
Add grant and rollback scripts for EXECUTE privilege on T_FILENAME to MRDS_LOADER
2026-02-17 12:03:21 +01:00
Grzegorz Michalski
64dc830a2b
Add 'VALIDATION_FAILED' status to A_SOURCE_FILE_RECEIVED constraint for improved status handling
2026-02-17 11:54:07 +01:00
Grzegorz Michalski
057a4e7ce3
Enhance trigger validation in MARS-828 verification script to improve error handling and output clarity
2026-02-16 11:01:44 +01:00
Grzegorz Michalski
a9a51f19be
Rename ARCH_FILE_NAME to ARCH_PATH in FILE_ARCHIVER for clarity and consistency in directory URI handling
2026-02-16 11:01:01 +01:00
Grzegorz Michalski
b6f6446232
Add author information to MARS-828 installation script
2026-02-13 21:05:09 +01:00
Grzegorz Michalski
1327410880
Fix URI construction in ARCHIVE_TABLE_DATA procedure to include 'ARCHIVE' directory for correct file path.
2026-02-11 21:53:31 +01:00
Grzegorz Michalski
26aba08759
Add FILE_ARCHIVER package and enhance A_SOURCE_FILE_CONFIG table
...
- Created new FILE_ARCHIVER package (v3.2.1) for managing file archival processes, including procedures for archiving, restoring, and purging files.
- Added versioning and build information to the package with detailed version history.
- Enhanced A_SOURCE_FILE_CONFIG table by adding ARCHIVE_ENABLED and KEEP_IN_TRASH columns to control archival participation and TRASH retention policy.
- Implemented constraints and comments for new columns to ensure data integrity and provide clarity on their usage.
2026-02-11 18:24:18 +01:00
Grzegorz Michalski
b96becd8ef
Add autonomous transaction pragma to ARCHIVE_TABLE_DATA and GATHER_TABLE_STAT procedures for improved transaction handling
2026-02-11 07:36:52 +01:00
Grzegorz Michalski
b1bb24e487
Refactor file retrieval logic in ARCHIVE_TABLE_DATA and GATHER_TABLE_STAT procedures to simplify queries and enhance clarity
2026-02-10 14:03:52 +01:00
Grzegorz Michalski
86535048fc
Add TRASH folder management procedures for restoring and purging files
2026-02-10 13:53:12 +01:00
Grzegorz Michalski
9ffad718fe
Update FILE_ARCHIVER package to version 3.2.1, fixing status update from ARCHIVED to ARCHIVED_AND_TRASHED for files moved to TRASH folder
2026-02-10 13:18:17 +01:00
Grzegorz Michalski
d443c4f07d
Update FILE_ARCHIVER package to version 3.2.0 with TRASH retention control and new statuses
2026-02-10 08:23:06 +01:00
Grzegorz Michalski
70909ba8c4
Enhance FILE_ARCHIVER package to include ODS bucket URI retrieval and update insert statements for A_TABLE_STAT_HIST and A_TABLE_STAT
2026-02-09 13:42:50 +01:00
Grzegorz Michalski
88325f0b8c
Refactor FILE_ARCHIVER package to use CT_MRDS.ENV_MANAGER consistently for logging and parameter formatting
2026-02-09 11:04:33 +01:00
Grzegorz Michalski
dc8031262c
konfiguracja
2026-02-09 10:22:38 +01:00
Grzegorz Michalski
fc95b12c9e
Remove test scenarios for archival strategies from test_archival_strategies.sql
2026-02-09 09:40:31 +01:00
Grzegorz Michalski
23b9962128
Update ARCHIVE_TABLE_DATA procedure to use GROUP BY instead of DISTINCT to resolve ORA-22950 issue
2026-02-09 09:36:05 +01:00
Grzegorz Michalski
802c102f29
Refactor archival strategy logic in FILE_ARCHIVER package to enhance clarity and support for age-based archiving
2026-02-09 09:12:49 +01:00
Grzegorz Michalski
fa1f179be9
gitignore
2026-02-09 08:13:26 +01:00
Grzegorz Michalski
974f6eca25
Update FILE_ARCHIVER package to version 3.1.2 with enhanced archival strategies and fixes
2026-02-06 11:45:57 +01:00
Grzegorz Michalski
c4f5ba48bc
wk
2026-02-06 11:41:25 +01:00
Grzegorz Michalski
e6ab189dc9
Refactor archival strategies in FILE_ARCHIVER package
...
- Removed CURRENT_MONTH_ONLY strategy, replacing it with MINIMUM_AGE_MONTHS = 0 for current month retention.
- Updated validation logic to allow MINIMUM_AGE_MONTHS to be non-negative.
- Consolidated documentation to reflect changes in archival strategies.
- Adjusted rollback script to reset all archival parameters to NULL for 25 Release 01 tables.
- Enhanced README and installation scripts to clarify new configuration requirements and usage examples.
- Updated version history to indicate breaking changes and migration steps for existing configurations.
2026-02-05 20:17:51 +01:00
Grzegorz Michalski
e93140e962
zmiany w pakiecie
2026-02-05 11:03:15 +01:00
Grzegorz Michalski
569c647b6c
dopracowanie paczki
2026-02-04 12:22:33 +01:00
Grzegorz Michalski
c508e1e4e2
Refactor archival strategy rollback scripts for Release 01 tables
2026-02-03 19:39:08 +01:00
Grzegorz Michalski
d6fd0b3dbd
Add scripts for configuring and rolling back archival strategies for Release 01 tables
2026-02-03 19:02:32 +01:00
Grzegorz Michalski
76c8ce6cc7
change rollback folder name
2026-02-03 14:00:47 +01:00
Grzegorz Michalski
64965fb8c8
MARS-828
2026-02-03 13:51:13 +01:00
Grzegorz Michalski
00063f1d0b
Mearge recent development
2026-02-02 11:18:42 +01:00
Grzegorz Michalski
ffcb288afa
Develop
2026-02-02 11:13:24 +01:00
Grzegorz Michalski
ecd833f682
Init
2026-02-02 10:59:29 +01:00
