Commit Graph

  • 255044f23b Enhance MARS-956 export and rollback scripts with process tracking identifier Grzegorz Michalski 2026-02-13 08:39:39 +01:00
  • 0053ecc556 Add MARS-835-PREHOOK scripts to update and rollback A_SOURCE_FILE_RECEIVED table structure Grzegorz Michalski 2026-02-13 08:39:03 +01:00
  • 3b7ce7de97 Implement rollback functionality for MARS-956: - Added script to delete exported CSV files from DATA bucket. - Enhanced rollback file registrations script with improved error handling and success messages. - Updated process logs cleanup script to include error handling and success messages. - Modified rollback verification script for clearer success and warning messages. - Removed outdated README.md file and updated installation script to reflect schema changes. - Adjusted rollback master script to streamline execution steps and improve clarity. Grzegorz Michalski 2026-02-13 07:50:54 +01:00
  • a3ec31341b Update DATA_EXPORTER package to version 2.8.1, fix query in EXPORT_TABLE_DATA to ensure single file output, and update version history. Grzegorz Michalski 2026-02-12 16:31:00 +01:00
  • 6039d6bce4 Update DATA_EXPORTER package to version 2.8.0, refactor EXPORT_TABLE_DATA to export to a single CSV file, and add pFileName and pMaxFileSize parameters. Grzegorz Michalski 2026-02-12 09:56:57 +01:00
  • a7d286b1e6 Refactor MARS-956 package for C2D MPEC data export Grzegorz Michalski 2026-02-12 09:56:37 +01:00
  • f2bcdb3a76 ignore Grzegorz Michalski 2026-02-12 09:28:54 +01:00
  • 15dafbff2a zachowanie wersj 2.7.5 Grzegorz Michalski 2026-02-12 09:27:57 +01:00
  • 3261aa1a6d wk Grzegorz Michalski 2026-02-11 23:05:51 +01:00
  • 1327410880 Fix URI construction in ARCHIVE_TABLE_DATA procedure to include 'ARCHIVE' directory for correct file path. Grzegorz Michalski 2026-02-11 21:53:31 +01:00
  • f4e9fb9cb2 Merge branch 'develop' Grzegorz Michalski 2026-02-11 21:32:47 +01:00
  • f8213b76ab Refactor export scripts to use DATA_EXPORTER.EXPORT_TABLE_DATA procedure, update folder structure to DATA/C2D, and add file registration validation in README and validation script. Grzegorz Michalski 2026-02-11 21:22:37 +01:00
  • 641af7415f Update DATA_EXPORTER package to version 2.7.5, adding pRegisterExport parameter to EXPORT_TABLE_DATA procedure for file registration in A_SOURCE_FILE_RECEIVED. Grzegorz Michalski 2026-02-11 20:32:21 +01:00
  • c1c3890a1a pierwsza wersja paczki MARS-956 Grzegorz Michalski 2026-02-11 20:24:45 +01:00
  • 63ed05930e Enhance EXPORT_TABLE_DATA procedure by adding pTemplateTableName parameter for flexible column order and date formatting. Update version history for clarity on recent changes. Grzegorz Michalski 2026-02-11 19:46:28 +01:00
  • 5320db627b przygotowanie pod nowe zmiany Grzegorz Michalski 2026-02-11 19:04:06 +01:00
  • 3171ff2ddf Update DATA_EXPORTER package to version 2.7.4, enhancing filename storage and metadata retrieval logic for exported files. Grzegorz Michalski 2026-02-11 18:27:44 +01:00
  • 26aba08759 Add FILE_ARCHIVER package and enhance A_SOURCE_FILE_CONFIG table Grzegorz Michalski 2026-02-11 18:24:18 +01:00
  • d237c2d7aa pRegisterExport Grzegorz Michalski 2026-02-11 09:54:04 +01:00
  • 96e3e2f845 pRegisterExport Grzegorz Michalski 2026-02-11 09:53:53 +01:00
  • 3eb39091de dodanie: pRegisterExport => TRUE Grzegorz Michalski 2026-02-11 09:49:28 +01:00
  • 113b9f55e3 deprecated version 2.8.0 Grzegorz Michalski 2026-02-11 09:45:11 +01:00
  • b96becd8ef Add autonomous transaction pragma to ARCHIVE_TABLE_DATA and GATHER_TABLE_STAT procedures for improved transaction handling Grzegorz Michalski 2026-02-11 07:36:52 +01:00
  • b1bb24e487 Refactor file retrieval logic in ARCHIVE_TABLE_DATA and GATHER_TABLE_STAT procedures to simplify queries and enhance clarity Grzegorz Michalski 2026-02-10 14:03:52 +01:00
  • 86535048fc Add TRASH folder management procedures for restoring and purging files Grzegorz Michalski 2026-02-10 13:53:12 +01:00
  • 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 Grzegorz Michalski 2026-02-10 13:18:17 +01:00
  • 6c8b22eac9 Add DATA_EXPORTER package and update installation scripts for export registration Grzegorz Michalski 2026-02-10 09:33:46 +01:00
  • d443c4f07d Update FILE_ARCHIVER package to version 3.2.0 with TRASH retention control and new statuses Grzegorz Michalski 2026-02-10 08:23:06 +01:00
  • cdd9dff32d aktualizacja dokumentacji w związku z TRASH i nowymi statusami plików. Grzegorz Michalski 2026-02-10 08:21:51 +01:00
  • 70909ba8c4 Enhance FILE_ARCHIVER package to include ODS bucket URI retrieval and update insert statements for A_TABLE_STAT_HIST and A_TABLE_STAT Grzegorz Michalski 2026-02-09 13:42:50 +01:00
  • 88325f0b8c Refactor FILE_ARCHIVER package to use CT_MRDS.ENV_MANAGER consistently for logging and parameter formatting Grzegorz Michalski 2026-02-09 11:04:33 +01:00
  • dc8031262c konfiguracja Grzegorz Michalski 2026-02-09 10:22:38 +01:00
  • fc95b12c9e Remove test scenarios for archival strategies from test_archival_strategies.sql Grzegorz Michalski 2026-02-09 09:40:31 +01:00
  • 23b9962128 Update ARCHIVE_TABLE_DATA procedure to use GROUP BY instead of DISTINCT to resolve ORA-22950 issue Grzegorz Michalski 2026-02-09 09:36:05 +01:00
  • 802c102f29 Refactor archival strategy logic in FILE_ARCHIVER package to enhance clarity and support for age-based archiving Grzegorz Michalski 2026-02-09 09:12:49 +01:00
  • fa1f179be9 gitignore Grzegorz Michalski 2026-02-09 08:13:26 +01:00
  • 293f2873b7 dokumentacja testow Grzegorz Michalski 2026-02-09 07:49:12 +01:00
  • 5e9233649e Merge 3.3.1 into 3.4.0 (MARS-1046 into MARS-1057) Grzegorz Michalski 2026-02-06 14:08:14 +01:00
  • 974f6eca25 Update FILE_ARCHIVER package to version 3.1.2 with enhanced archival strategies and fixes Grzegorz Michalski 2026-02-06 11:45:57 +01:00
  • c4f5ba48bc wk Grzegorz Michalski 2026-02-06 11:41:25 +01:00
  • e6ab189dc9 Refactor archival strategies in FILE_ARCHIVER package Grzegorz Michalski 2026-02-05 20:17:51 +01:00
  • e93140e962 zmiany w pakiecie Grzegorz Michalski 2026-02-05 11:03:15 +01:00
  • f42777f480 dokumentacja Grzegorz Michalski 2026-02-05 10:54:48 +01:00
  • 19925603fa aktualizacja definicji Grzegorz Michalski 2026-02-04 14:41:30 +01:00
  • 569c647b6c dopracowanie paczki Grzegorz Michalski 2026-02-04 12:22:33 +01:00
  • 8a162ce9bf dok Grzegorz Michalski 2026-02-04 12:21:48 +01:00
  • 7864c568d7 Cleanup: Remove old REL01_POST_DEACTIVATION folders after merge from main Grzegorz Michalski 2026-02-04 10:58:04 +01:00
  • c508e1e4e2 Refactor archival strategy rollback scripts for Release 01 tables Grzegorz Michalski 2026-02-03 19:39:08 +01:00
  • d6fd0b3dbd Add scripts for configuring and rolling back archival strategies for Release 01 tables Grzegorz Michalski 2026-02-03 19:02:32 +01:00
  • 32c7a5dcee wk Grzegorz Michalski 2026-02-03 18:38:17 +01:00
  • 76c8ce6cc7 change rollback folder name Grzegorz Michalski 2026-02-03 14:00:47 +01:00
  • 64965fb8c8 MARS-828 Grzegorz Michalski 2026-02-03 13:51:13 +01:00
  • d17d71031a wk Grzegorz Michalski 2026-02-03 13:33:45 +01:00
  • e3ff1618ce Przeniesienie Grzegorz Michalski 2026-02-03 13:32:06 +01:00
  • b353fb38f5 Add installation script for ODS.FILE_MANAGER_ODS Package Specification v2.2.0 Grzegorz Michalski 2026-02-03 11:08:12 +01:00
  • 98af9fa737 wk Grzegorz Michalski 2026-02-02 12:00:47 +01:00
  • aac908ebba workon Grzegorz Michalski 2026-02-02 11:55:21 +01:00
  • 00063f1d0b Mearge recent development Grzegorz Michalski 2026-02-02 11:18:42 +01:00
  • b4eb235154 Merge pull request 'Develop' (#1) from develop into main admin 2026-02-02 10:15:14 +00:00
  • ffcb288afa Develop Grzegorz Michalski 2026-02-02 11:13:24 +01:00
  • ecd833f682 Init Grzegorz Michalski 2026-02-02 10:59:29 +01:00