admin/mars
1
0
Fork 0
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity

Commit Graph

  • a35e28042b feat(FILE_ARCHIVER): Improve archival logic and error handling in FILE_ARCHIVER procedures main Grzegorz Michalski 2026-03-23 11:48:37 +01:00
  • 92feb95ae0 feat(FILE_ARCHIVER): Enhance documentation with new function details and clarify private functions Grzegorz Michalski 2026-03-20 13:37:05 +01:00
  • 74b8857096 feat(FILE_ARCHIVER): Rename IS_KEEP_IN_TRASH to IS_KEPT_IN_TRASH for consistency in configuration Grzegorz Michalski 2026-03-20 13:26:37 +01:00
  • 24997b1583 feat(MARS-1409): Add prerequisite checks for MARS-1409 objects in installation script Grzegorz Michalski 2026-03-20 13:13:26 +01:00
  • eb9b2bc38b feat(FILE_MANAGER): Rename pIsKeepInTrash to pIsKeptInTrash for consistency in parameter naming Grzegorz Michalski 2026-03-19 13:29:51 +01:00
  • 2ea708a694 Merge branch 'main' of https://git.itbi.mywire.org/admin/mars Grzegorz Michalski 2026-03-19 12:26:27 +01:00
  • 12c58f32a3 feat(MARS-1409): Rename IS_KEEP_IN_TRASH to IS_KEPT_IN_TRASH across relevant files and update related logic Grzegorz Michalski 2026-03-19 12:23:29 +01:00
  • 811df6e8b1 feat(FILE_ARCHIVER): Enhance logging messages to include detailed parameters for better error tracking Grzegorz Michalski 2026-03-19 12:14:35 +01:00
  • c2e9409e55 feat(FILE_ARCHIVER): Enhance logging by adding parameters to log events for better traceability Grzegorz Michalski 2026-03-19 11:51:37 +01:00
  • c96bf2051f Merge branch 'main' of https://git.itbi.mywire.org/admin/mars Grzegorz Michalski 2026-03-19 11:13:37 +01:00
  • 5d0e03d7ad feat(MARS-1409): Add DATA_EXPORTER package installation and rollback scripts Grzegorz Michalski 2026-03-19 11:13:09 +01:00
  • ffd6c7eeae feat(ENV_MANAGER): Add new error codes for workflow key validation and update package version to 3.3.0 refactor(FILE_MANAGER): Remove redundant error logging for unknown errors Grzegorz Michalski 2026-03-19 11:13:02 +01:00
  • bbdf008125 Add DATA_EXPORTER package for comprehensive data export capabilities Grzegorz Michalski 2026-03-19 10:50:28 +01:00
  • 396e7416f6 feat(FILE_ARCHIVER): Update SQL query in ARCHIVE_TABLE_DATA for improved archival statistics and column order consistency Grzegorz Michalski 2026-03-19 09:37:42 +01:00
  • 0ed75875ac Refactor MARS-1409: Rollback changes to A_SOURCE_FILE_RECEIVED and related tables Grzegorz Michalski 2026-03-19 08:46:49 +01:00
  • a7db9b67bc Merge branch 'main' of https://git.itbi.mywire.org/admin/mars Grzegorz Michalski 2026-03-18 18:19:19 +01:00
  • ce9b6eeff6 feat(FILE_MANAGER): Update package version to 3.6.3 and enhance ADD_SOURCE_FILE_CONFIG with new parameters for archival control Grzegorz Michalski 2026-03-18 18:19:04 +01:00
  • 0725119b45 feat: Enhance MARS-1409 post-hook scripts to include checks for empty ODS tables and update installation script for workflow key diagnosis Grzegorz Michalski 2026-03-17 12:10:18 +01:00
  • 896e67bcb9 feat: Refactor A_SOURCE_FILE_CONFIG table structure and update comments for clarity Grzegorz Michalski 2026-03-17 10:58:01 +01:00
  • ad5a6f393a feat: Update installation script to reflect expected duration for MARS-1409 post-hook process Grzegorz Michalski 2026-03-17 09:54:42 +01:00
  • a4ac132b76 feat: Implement MARS-1409 changes to add ARCHIVAL_STRATEGY and ARCH_MINIMUM_AGE_MONTHS columns to A_TABLE_STAT and A_TABLE_STAT_HIST, and update FILE_ARCHIVER for handling these new fields Grzegorz Michalski 2026-03-17 08:23:14 +01:00
  • 6468d12349 minor Grzegorz Michalski 2026-03-13 13:51:53 +01:00
  • fe0f7bce18 feat: Enhance FILE_ARCHIVER package to handle empty ODS bucket scenarios with improved statistics initialization Grzegorz Michalski 2026-03-13 13:34:38 +01:00
  • 6b2f60f413 feat: Update FILE_ARCHIVER package to version 3.3.1 with improved handling for empty ODS bucket scenarios Grzegorz Michalski 2026-03-13 11:40:19 +01:00
  • ca11debd93 minor Grzegorz Michalski 2026-03-13 11:35:11 +01:00
  • 24e6bce18c minor changes Grzegorz Michalski 2026-03-13 11:34:59 +01:00
  • aa03dd1616 feat: Update FILE_MANAGER package to version 3.6.1 with fixes for CHAR/NCHAR/NVARCHAR2 column definitions Grzegorz Michalski 2026-03-13 09:11:28 +01:00
  • 9190681051 MARS-1409-POSTHOOK Grzegorz Michalski 2026-03-13 09:08:44 +01:00
  • 096994d514 feat: Add diagnostic script for workflow key status in MARS-1409 post-hook Grzegorz Michalski 2026-03-13 08:43:14 +01:00
  • 1385bfb9e7 feat: Implement MARS-1409 post-hook for backfilling A_WORKFLOW_HISTORY_KEY Grzegorz Michalski 2026-03-13 08:30:32 +01:00
  • 7d2fb34ad9 MARS-1005-PREHOOK Grzegorz Michalski 2026-03-12 08:51:15 +01:00
  • 202b535f9f Update DATA_EXPORTER package to v2.17.0: Fix RFC 4180 compliance and Parquet format corruption Grzegorz Michalski 2026-03-12 08:50:08 +01:00
  • 5ba6c30fda MARS-1005-PREHOOK Grzegorz Michalski 2026-03-11 10:34:47 +01:00
  • 64a4b9a2f0 Refactor rollback script to delete specific legacy files and adjust object URI construction Grzegorz Michalski 2026-03-09 11:46:01 +01:00
  • dec3e7137e Refactor rollback script to delete only files registered by MARS-1005 and improve output messages Grzegorz Michalski 2026-03-09 10:24:24 +01:00
  • 0ecc119ee9 Refactor data integrity verification script to use A_ETL_LOAD_SET_FK instead of A_WORKFLOW_HISTORY_KEY Grzegorz Michalski 2026-03-09 09:31:30 +01:00
  • 182e6240d3 Update export script comments for clarity and consistency Grzegorz Michalski 2026-03-09 09:25:20 +01:00
  • b81e524351 Refactor MARS-1005 scripts for OU_TOP legacy data export and rollback Grzegorz Michalski 2026-03-06 14:34:12 +01:00
  • 73e99b6e76 MARS-1005 Grzegorz Michalski 2026-03-06 12:06:18 +01:00
  • 113ea0a618 Refactor MARS-1409 SQL scripts for workflow history key management Grzegorz Michalski 2026-03-05 12:33:59 +01:00
  • 59e18d9b35 Add error handling for TRG_A_WORKFLOW_HISTORY trigger installation Grzegorz Michalski 2026-03-04 10:16:35 +01:00
  • a58a5ae82a ignore export files Grzegorz Michalski 2026-03-03 09:48:43 +01:00
  • b537719b64 added template tables Grzegorz Michalski 2026-03-03 09:47:24 +01:00
  • 4de14b64fb rmemove unneeded Grzegorz Michalski 2026-03-03 09:46:06 +01:00
  • 36a04dde04 MARS-1409 Grzegorz Michalski 2026-03-02 14:26:12 +01:00
  • cad6e63479 exported files from dev Grzegorz Michalski 2026-03-02 13:51:59 +01:00
  • 7db10725a0 MARS-1409 Grzegorz Michalski 2026-03-02 10:15:22 +01:00
  • a13a9d415f remove autthor Grzegorz Michalski 2026-03-02 10:14:53 +01:00
  • 1c6f552df9 szkielet paczki MARS-1409 Grzegorz Michalski 2026-02-27 07:32:21 +01:00
  • e9d4056451 Merge develop into main - DATA_EXPORTER v2.14.0 optimization develop Grzegorz Michalski 2026-02-26 20:39:33 +01:00
  • 60b218d211 Hotfix - Add filtering for successful workflows in archival queries Grzegorz Michalski 2026-02-26 20:37:03 +01:00
  • 819b6f7880 Update version history in FILE_MANAGER package to include changes for MARS-828 compatibility Grzegorz Michalski 2026-02-25 09:50:30 +01:00
  • c68d5bfe2c feat(MARS-835): Enhance EXPORT_PARTITION_PARALLEL with pTaskName parameter for session isolation and optimize chunk retrieval logic Grzegorz Michalski 2026-02-25 09:49:25 +01:00
  • c607bbe26e Update CSDB DEBT tables to set MINIMUM_AGE_MONTHS to 0 for current month only Grzegorz Michalski 2026-02-25 07:00:04 +01:00
  • 1569237306 Add T2_PEAK_LIQUIDITY_NEED template table with column comments Grzegorz Michalski 2026-02-24 19:20:28 +01:00
  • 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 Grzegorz Michalski 2026-02-24 19:19:45 +01:00
  • 04d4f6ac02 feat(MARS-835): Update export scripts to support HIST-only strategy, including verification and rollback adjustments Grzegorz Michalski 2026-02-24 19:18:16 +01:00
  • ca5d8b320c feat(MARS-835): Enhance DELETE_FAILED_EXPORT_FILE procedure to delete all matching files before retrying export, preventing data duplication in parallel processing Grzegorz Michalski 2026-02-24 09:38:09 +01:00
  • 2605896469 refactor(EXPORT): Improve formatting and logging Grzegorz Michalski 2026-02-24 08:22:42 +01:00
  • b588b0bb72 Add FILE_MANAGER package installation and rollback scripts; update installation process for compatibility with MARS-828 Grzegorz Michalski 2026-02-23 09:14:20 +01:00
  • 6060f93fde wk Grzegorz Michalski 2026-02-20 15:23:12 +01:00
  • 99aca3af40 wk1 Grzegorz Michalski 2026-02-20 15:22:58 +01:00
  • 1089184367 wk1 Grzegorz Michalski 2026-02-20 15:18:08 +01:00
  • e538706896 feat(MARS-826): Add pTemplateTableName parameter to export scripts for various tables Grzegorz Michalski 2026-02-20 15:16:37 +01:00
  • ff034fcd68 MARS-1057 Grzegorz Michalski 2026-02-20 15:08:18 +01:00
  • b85172ae84 wk1 Grzegorz Michalski 2026-02-20 14:25:19 +01:00
  • 577c94f363 Zmiana nazw kolumn ARCHIVE_ENABLED → IS_ARCHIVE_ENABLED (konwencja boolean) KEEP_IN_TRASH → IS_KEEP_IN_TRASH (konwencja boolean) Grzegorz Michalski 2026-02-20 11:56:41 +01:00
  • 11723f6c88 dokumentacja Grzegorz Michalski 2026-02-20 11:34:58 +01:00
  • b63be15f5d Merge branch 'main' of https://git.itbi.mywire.org/admin/mars Grzegorz Michalski 2026-02-20 10:18:33 +01:00
  • 28972e7428 fix(README): Correct typo in active tasks and update installation commands for MARS-1057 Grzegorz Michalski 2026-02-20 10:18:25 +01:00
  • 866b886c70 Merge develop into main - added pJobClass parameter and MARS-826, MARS-835, MARS-828 updates Grzegorz Michalski 2026-02-20 10:09:37 +01:00
  • 3848a9471b Add pJobClass parameter to export scripts for Oracle Scheduler resource management Grzegorz Michalski 2026-02-19 11:26:51 +01:00
  • cafa30f8f3 refactor(FILE_MANAGER): Update schema reference handling for grants and table operations Grzegorz Michalski 2026-02-19 08:58:39 +01:00
  • a0f4146a24 refactor(FILE_MANAGER): Update privilege handling to use dynamic schema reference Grzegorz Michalski 2026-02-19 07:35:49 +01:00
  • 2b116c0256 feat(MARS-1057): Upgrade FILE_MANAGER to v3.5.0 with area filter functionality Grzegorz Michalski 2026-02-18 14:03:11 +01:00
  • 204616252a Add pRestoreGrants parameter to CREATE_EXTERNAL_TABLES_SET for grant preservation during table recreation Grzegorz Michalski 2026-02-18 13:27:12 +01:00
  • 93d2e537a9 Update SQL execution commands in README to use 'echo' for confirmation prompts Grzegorz Michalski 2026-02-18 12:59:12 +01:00
  • 2143a81aa0 Add pJobClass parameter to MARS-835 export scripts for Oracle Scheduler resource management Grzegorz Michalski 2026-02-18 12:58:18 +01:00
  • b6cf54f103 Add JOB_CLASS parameter to DATA_EXPORTER for Oracle Scheduler support Grzegorz Michalski 2026-02-18 12:58:06 +01:00
  • 6ade77c3c0 Update DATA_EXPORTER package to version 2.10.1, fixing redundant deletion of COMPLETED chunks before parallel export to prevent ORA-01403 errors. Grzegorz Michalski 2026-02-17 12:03:36 +01:00
  • 8ce07c3360 Add grant and rollback scripts for EXECUTE privilege on T_FILENAME to MRDS_LOADER Grzegorz Michalski 2026-02-17 12:03:21 +01:00
  • 64dc830a2b Add 'VALIDATION_FAILED' status to A_SOURCE_FILE_RECEIVED constraint for improved status handling Grzegorz Michalski 2026-02-17 11:54:07 +01:00
  • 020dacb571 Refactor MARS-835 installation scripts to include explicit date handling and remove obsolete files Grzegorz Michalski 2026-02-17 11:12:03 +01:00
  • 057a4e7ce3 Enhance trigger validation in MARS-828 verification script to improve error handling and output clarity Grzegorz Michalski 2026-02-16 11:01:44 +01:00
  • a9a51f19be Rename ARCH_FILE_NAME to ARCH_PATH in FILE_ARCHIVER for clarity and consistency in directory URI handling Grzegorz Michalski 2026-02-16 11:01:01 +01:00
  • fc6304c60b wk Grzegorz Michalski 2026-02-16 10:50:38 +01:00
  • 912b7a6466 Remove recent export activity logging from C2D MPEC historical data export script Grzegorz Michalski 2026-02-13 21:06:15 +01:00
  • b6f6446232 Add author information to MARS-828 installation script Grzegorz Michalski 2026-02-13 21:05:09 +01:00
  • aa2f2f13f9 Update author information to Grzegorz Michalski in MARS-835 SQL scripts Grzegorz Michalski 2026-02-13 20:16:05 +01:00
  • 5c77d42d9a Update author information to Grzegorz Michalski in MARS-956 SQL scripts and remove pre-check script from installation process Grzegorz Michalski 2026-02-13 19:42:02 +01:00
  • d370b9c9ef Update DATA_EXPORTER package to version 2.10.0 with multi-file support for DBMS_CLOUD.EXPORT_DATA, preventing orphaned files in rollback processes. Grzegorz Michalski 2026-02-13 19:08:54 +01:00
  • c5d39fc01d Add ENV_MANAGER package with comprehensive error handling and logging features Grzegorz Michalski 2026-02-13 13:56:36 +01:00
  • 80916ea302 Refactor SQL scripts to replace MRDS_LOADER.cloud_wrapper.list_objects with DBMS_CLOUD.LIST_OBJECTS for improved compatibility Grzegorz Michalski 2026-02-13 12:39:03 +01:00
  • a4ab56e96d Enhance MARS-835 rollback process with new scripts for file registration deletion and manual cleanup, and add process tracking identifier for exports Grzegorz Michalski 2026-02-13 12:36:45 +01:00
  • 92c5261215 Revert "Add process tracking identifier to MARS-835 export and rollback scripts" Grzegorz Michalski 2026-02-13 09:45:49 +01:00
  • b34c942a8f Revert "Enhance MARS-826 Rollback Scripts and Export Procedures" Grzegorz Michalski 2026-02-13 09:24:02 +01:00
  • d175179ddc Update DATA_EXPORTER package version to 2.9.0 and enhance version history for process tracking improvements Grzegorz Michalski 2026-02-13 09:21:06 +01:00
  • d8a5edc3b1 Update step prompts for MARS-835-PREHOOK installation script to reflect correct sequence of operations Grzegorz Michalski 2026-02-13 09:00:42 +01:00
  • d6c34085f7 Enhance MARS-826 Rollback Scripts and Export Procedures Grzegorz Michalski 2026-02-13 09:00:13 +01:00
  • 2c40f091e0 Add process tracking identifier to MARS-835 export and rollback scripts Grzegorz Michalski 2026-02-13 08:50:56 +01:00