INFO 2023-05-09 13:14:35,904 [Dispatch Load Data Warehouse : bg@DESKTOP-L4FIFVN (tenant=clarity)] dwh.event (clarity:admin:5281536__BAC23F93-7567-454B-8AF2-6D29834156D2:Load Data Warehouse) Job Parameters INFO 2023-05-09 13:14:35,906 [Dispatch Load Data Warehouse : bg@DESKTOP-L4FIFVN (tenant=clarity)] dwh.event (clarity:admin:5281536__BAC23F93-7567-454B-8AF2-6D29834156D2:Load Data Warehouse) SRC_DATABASE_URL: jdbc:postgresql://localhost:5432/ppmdb INFO 2023-05-09 13:14:35,906 [Dispatch Load Data Warehouse : bg@DESKTOP-L4FIFVN (tenant=clarity)] dwh.event (clarity:admin:5281536__BAC23F93-7567-454B-8AF2-6D29834156D2:Load Data Warehouse) SRC_DATABASE_CLASS: org.postgresql.Driver INFO 2023-05-09 13:14:35,906 [Dispatch Load Data Warehouse : bg@DESKTOP-L4FIFVN (tenant=clarity)] dwh.event (clarity:admin:5281536__BAC23F93-7567-454B-8AF2-6D29834156D2:Load Data Warehouse) SRC_DATABASE_USER: ppmdb INFO 2023-05-09 13:14:35,907 [Dispatch Load Data Warehouse : bg@DESKTOP-L4FIFVN (tenant=clarity)] dwh.event (clarity:admin:5281536__BAC23F93-7567-454B-8AF2-6D29834156D2:Load Data Warehouse) TGT_DATABASE_URL: jdbc:postgresql://localhost:5432/dwhdb INFO 2023-05-09 13:14:35,907 [Dispatch Load Data Warehouse : bg@DESKTOP-L4FIFVN (tenant=clarity)] dwh.event (clarity:admin:5281536__BAC23F93-7567-454B-8AF2-6D29834156D2:Load Data Warehouse) TGT_DATABASE_CLASS: org.postgresql.Driver INFO 2023-05-09 13:14:35,907 [Dispatch Load Data Warehouse : bg@DESKTOP-L4FIFVN (tenant=clarity)] dwh.event (clarity:admin:5281536__BAC23F93-7567-454B-8AF2-6D29834156D2:Load Data Warehouse) TGT_DATABASE_USER: dwhdb INFO 2023-05-09 13:14:35,908 [Dispatch Load Data Warehouse : bg@DESKTOP-L4FIFVN (tenant=clarity)] dwh.event (clarity:admin:5281536__BAC23F93-7567-454B-8AF2-6D29834156D2:Load Data Warehouse) CLARITY_DB_TYPE: postgres INFO 2023-05-09 13:14:35,908 [Dispatch Load Data Warehouse : bg@DESKTOP-L4FIFVN (tenant=clarity)] dwh.event (clarity:admin:5281536__BAC23F93-7567-454B-8AF2-6D29834156D2:Load Data Warehouse) DWH_DB_TYPE: postgres INFO 2023-05-09 13:14:35,908 [Dispatch Load Data Warehouse : bg@DESKTOP-L4FIFVN (tenant=clarity)] dwh.event (clarity:admin:5281536__BAC23F93-7567-454B-8AF2-6D29834156D2:Load Data Warehouse) SRC_DBNAME: ppmdb INFO 2023-05-09 13:14:35,908 [Dispatch Load Data Warehouse : bg@DESKTOP-L4FIFVN (tenant=clarity)] dwh.event (clarity:admin:5281536__BAC23F93-7567-454B-8AF2-6D29834156D2:Load Data Warehouse) DB_LINK: PPMDBLINK INFO 2023-05-09 13:14:41,343 [Thread-16] dwh.event (none:none:none:none) dwh_etl_master - Start of job execution INFO 2023-05-09 13:14:43,660 [dwh_check_slice_info_pg - Write Time Info to Log] dwh.event (none:none:none:none) Write Time Info to Log - ------------> Linenr 1------------------------------ Date Time Values application_time = 2023-05-09 13:14:43.262-05 ppm_time_minus_15 = 2023-05-09 13:14:28.457-05 ppm_time_plus_15 = 2023-05-09 13:14:58.457-05 dwh_time = 2023-05-09 13:14:43 dwh_time_minus_15 = 2023-05-09 13:14:28.457-05 dwh_time_plus_15 = 2023-05-09 13:14:58.457-05 ==================== ERROR 2023-05-09 13:14:43,862 [dwh_etl_master_pg UUID: 65ca6187-c63f-42f0-b2cf-35f65f4ed778] dwh.event (none:none:none:none) Abort job - At least 1 checkbox for 'Include Period Data' must be checked under System Options for the Data Warehouse. INFO 2023-05-09 13:14:44,028 [Thread-16] dwh.event (none:none:none:none) dwh_etl_master - Job execution finished ERROR 2023-05-09 13:14:44,198 [Dispatch Load Data Warehouse : bg@DESKTOP-L4FIFVN (tenant=clarity)] dwh.event (clarity:admin:5281536__BAC23F93-7567-454B-8AF2-6D29834156D2:Load Data Warehouse) ETL Job Failed. Log details below: 2023/05/09 13:14:43 - Write Time Info to Log.0 - 2023/05/09 13:14:43 - Write Time Info to Log.0 - ------------> Linenr 1------------------------------ 2023/05/09 13:14:43 - Write Time Info to Log.0 - Date Time Values 2023/05/09 13:14:43 - Write Time Info to Log.0 - 2023/05/09 13:14:43 - Write Time Info to Log.0 - application_time = 2023-05-09 13:14:43.262-05 2023/05/09 13:14:43 - Write Time Info to Log.0 - ppm_time_minus_15 = 2023-05-09 13:14:28.457-05 2023/05/09 13:14:43 - Write Time Info to Log.0 - ppm_time_plus_15 = 2023-05-09 13:14:58.457-05 2023/05/09 13:14:43 - Write Time Info to Log.0 - dwh_time = 2023-05-09 13:14:43 2023/05/09 13:14:43 - Write Time Info to Log.0 - dwh_time_minus_15 = 2023-05-09 13:14:28.457-05 2023/05/09 13:14:43 - Write Time Info to Log.0 - dwh_time_plus_15 = 2023-05-09 13:14:58.457-05 2023/05/09 13:14:43 - Write Time Info to Log.0 - 2023/05/09 13:14:43 - Write Time Info to Log.0 - ==================== 2023/05/09 13:14:43 - Abort job - ERROR (version 9.3.0.0-428, build 9.3.0.0-428 from 2022-04-12 04.56.25 by buildguy) : At least 1 checkbox for 'Include Period Data' must be checked under System Options for the Data Warehouse. 2023/05/09 13:14:43 - Abort job - ERROR (version 9.3.0.0-428, build 9.3.0.0-428 from 2022-04-12 04.56.25 by buildguy) : At least 1 checkbox for 'Include Period Data' must be checked under System Options for the Data Warehouse. 2023/05/09 13:14:43 - Write Time Info to Log.0 - 2023/05/09 13:14:43 - Write Time Info to Log.0 - ------------> Linenr 1------------------------------ 2023/05/09 13:14:43 - Write Time Info to Log.0 - Date Time Values 2023/05/09 13:14:43 - Write Time Info to Log.0 - 2023/05/09 13:14:43 - Write Time Info to Log.0 - application_time = 2023-05-09 13:14:43.262-05 2023/05/09 13:14:43 - Write Time Info to Log.0 - ppm_time_minus_15 = 2023-05-09 13:14:28.457-05 2023/05/09 13:14:43 - Write Time Info to Log.0 - ppm_time_plus_15 = 2023-05-09 13:14:58.457-05 2023/05/09 13:14:43 - Write Time Info to Log.0 - dwh_time = 2023-05-09 13:14:43 2023/05/09 13:14:43 - Write Time Info to Log.0 - dwh_time_minus_15 = 2023-05-09 13:14:28.457-05 2023/05/09 13:14:43 - Write Time Info to Log.0 - dwh_time_plus_15 = 2023-05-09 13:14:58.457-05 2023/05/09 13:14:43 - Write Time Info to Log.0 - 2023/05/09 13:14:43 - Write Time Info to Log.0 - ==================== null INFO 2023-05-09 13:18:52,034 [Dispatch Load Data Warehouse : bg@DESKTOP-L4FIFVN (tenant=clarity)] dwh.event (clarity:admin:5281549__CC3B0668-68B0-4775-93DB-E191E16E71A0:Load Data Warehouse) Job Parameters INFO 2023-05-09 13:18:52,035 [Dispatch Load Data Warehouse : bg@DESKTOP-L4FIFVN (tenant=clarity)] dwh.event (clarity:admin:5281549__CC3B0668-68B0-4775-93DB-E191E16E71A0:Load Data Warehouse) SRC_DATABASE_URL: jdbc:postgresql://localhost:5432/ppmdb INFO 2023-05-09 13:18:52,035 [Dispatch Load Data Warehouse : bg@DESKTOP-L4FIFVN (tenant=clarity)] dwh.event (clarity:admin:5281549__CC3B0668-68B0-4775-93DB-E191E16E71A0:Load Data Warehouse) SRC_DATABASE_CLASS: org.postgresql.Driver INFO 2023-05-09 13:18:52,036 [Dispatch Load Data Warehouse : bg@DESKTOP-L4FIFVN (tenant=clarity)] dwh.event (clarity:admin:5281549__CC3B0668-68B0-4775-93DB-E191E16E71A0:Load Data Warehouse) SRC_DATABASE_USER: ppmdb INFO 2023-05-09 13:18:52,037 [Dispatch Load Data Warehouse : bg@DESKTOP-L4FIFVN (tenant=clarity)] dwh.event (clarity:admin:5281549__CC3B0668-68B0-4775-93DB-E191E16E71A0:Load Data Warehouse) TGT_DATABASE_URL: jdbc:postgresql://localhost:5432/dwhdb INFO 2023-05-09 13:18:52,037 [Dispatch Load Data Warehouse : bg@DESKTOP-L4FIFVN (tenant=clarity)] dwh.event (clarity:admin:5281549__CC3B0668-68B0-4775-93DB-E191E16E71A0:Load Data Warehouse) TGT_DATABASE_CLASS: org.postgresql.Driver INFO 2023-05-09 13:18:52,037 [Dispatch Load Data Warehouse : bg@DESKTOP-L4FIFVN (tenant=clarity)] dwh.event (clarity:admin:5281549__CC3B0668-68B0-4775-93DB-E191E16E71A0:Load Data Warehouse) TGT_DATABASE_USER: dwhdb INFO 2023-05-09 13:18:52,037 [Dispatch Load Data Warehouse : bg@DESKTOP-L4FIFVN (tenant=clarity)] dwh.event (clarity:admin:5281549__CC3B0668-68B0-4775-93DB-E191E16E71A0:Load Data Warehouse) CLARITY_DB_TYPE: postgres INFO 2023-05-09 13:18:52,037 [Dispatch Load Data Warehouse : bg@DESKTOP-L4FIFVN (tenant=clarity)] dwh.event (clarity:admin:5281549__CC3B0668-68B0-4775-93DB-E191E16E71A0:Load Data Warehouse) DWH_DB_TYPE: postgres INFO 2023-05-09 13:18:52,037 [Dispatch Load Data Warehouse : bg@DESKTOP-L4FIFVN (tenant=clarity)] dwh.event (clarity:admin:5281549__CC3B0668-68B0-4775-93DB-E191E16E71A0:Load Data Warehouse) SRC_DBNAME: ppmdb INFO 2023-05-09 13:18:52,038 [Dispatch Load Data Warehouse : bg@DESKTOP-L4FIFVN (tenant=clarity)] dwh.event (clarity:admin:5281549__CC3B0668-68B0-4775-93DB-E191E16E71A0:Load Data Warehouse) DB_LINK: PPMDBLINK INFO 2023-05-09 13:18:52,140 [Thread-48] dwh.event (none:none:none:none) dwh_etl_master - Start of job execution INFO 2023-05-09 13:18:53,610 [dwh_check_slice_info_pg - Write Time Info to Log] dwh.event (none:none:none:none) Write Time Info to Log - ------------> Linenr 1------------------------------ Date Time Values application_time = 2023-05-09 13:18:53.206-05 ppm_time_minus_15 = 2023-05-09 13:18:38.401-05 ppm_time_plus_15 = 2023-05-09 13:19:08.401-05 dwh_time = 2023-05-09 13:18:53 dwh_time_minus_15 = 2023-05-09 13:18:38.401-05 dwh_time_plus_15 = 2023-05-09 13:19:08.401-05 ==================== ERROR 2023-05-09 13:19:27,090 [dwh_load_settings_check_pg UUID: 935340d1-1d10-403b-8bd6-55bd3f00a6ed] dwh.event (none:none:none:none) Update Config Settings - An error occurred executing this job entry : Couldn't execute SQL: UPDATE DWH_CFG_SETTINGS SET LANGUAGE_CODE_KEY = 1, LANGUAGE_CODE = 'en', CURRENCY_PRECISION = 0,0, WEEK_START_DAY = 1, WEEK_START_DAY_CHANGED = CASE WHEN 1 = 1 THEN 0 ELSE 1 END, ENTITY_KEY = 5075791, ENTITY_CHANGED = CASE WHEN 5075791 = 0 THEN 0 ELSE 1 END, CURRENT_FISCAL_PERIOD_KEY = 5069135, FISCAL_PERIOD_CHANGED = CASE WHEN 5069135 = 0 THEN 0 ELSE 1 END, WEEKLY_SLICES = 1, MONTHLY_SLICES = 1, FISCAL_SLICES = 1, ONE_SET_OF_FISCAL_PERIODS = 1, DISABLE_RESOURCE_SECURITY = 0, DISABLE_INVESTMENT_SECURITY = 0, SINGLE_CURRENCY = 1, DAILY_ROLLOVER_OCCURRED = CASE WHEN '2023/08/09 00:00:00' > '1900/01/01 00:00:00' THEN 1 ELSE 0 END, WEEKLY_ROLLOVER_OCCURRED = CASE WHEN '2023/07/31 00:00:00' > '1900/01/01 00:00:00' THEN 1 ELSE 0 END, MONTHLY_ROLLOVER_OCCURRED = CASE WHEN '2023/08/01 00:00:00' > '1900/01/01 00:00:00' THEN 1 ELSE 0 END, FISCAL_ROLLOVER_OCCURRED = CASE WHEN '2023/06/01 00:00:00' > '1900/01/01 00:00:00' THEN 1 ELSE 0 END, DAILY_ROLLOVER_DATE = TO_TIMESTAMP('2023/08/09 00:00:00','YYYY/MM/DD HH24:MI:SS'), WEEKLY_ROLLOVER_DATE = TO_TIMESTAMP('2023/07/31 00:00:00','YYYY/MM/DD HH24:MI:SS'), MONTHLY_ROLLOVER_DATE = TO_TIMESTAMP('2023/08/01 00:00:00','YYYY/MM/DD HH24:MI:SS'), FISCAL_ROLLOVER_DATE = TO_TIMESTAMP('2023/06/01 00:00:00','YYYY/MM/DD HH24:MI:SS'), FULL_RELOAD = (CASE WHEN 'Y' = 'Y' THEN 1 WHEN '2001-07-10 09:04:08' > '1900-01-01 00:00:00' THEN 1 ELSE 0 END), DWH_DIM_PREV_START_DATE = CASE WHEN 'Y' = 'Y' THEN TO_TIMESTAMP('1900/01/01 00:00:00','YYYY/MM/DD HH24:MI:SS') ELSE TO_TIMESTAMP('2023/05/09 13:19:19','YYYY/MM/DD HH24:MI:SS') END ERROR: error de sintaxis en o cerca de «0» Position: 114 INFO 2023-05-09 13:19:27,237 [Thread-48] dwh.event (none:none:none:none) dwh_etl_master - Job execution finished ERROR 2023-05-09 13:19:27,385 [Dispatch Load Data Warehouse : bg@DESKTOP-L4FIFVN (tenant=clarity)] dwh.event (clarity:admin:5281549__CC3B0668-68B0-4775-93DB-E191E16E71A0:Load Data Warehouse) ETL Job Failed. Log details below: 2023/05/09 13:14:43 - Write Time Info to Log.0 - 2023/05/09 13:14:43 - Write Time Info to Log.0 - ------------> Linenr 1------------------------------ 2023/05/09 13:14:43 - Write Time Info to Log.0 - Date Time Values 2023/05/09 13:14:43 - Write Time Info to Log.0 - 2023/05/09 13:14:43 - Write Time Info to Log.0 - application_time = 2023-05-09 13:14:43.262-05 2023/05/09 13:14:43 - Write Time Info to Log.0 - ppm_time_minus_15 = 2023-05-09 13:14:28.457-05 2023/05/09 13:14:43 - Write Time Info to Log.0 - ppm_time_plus_15 = 2023-05-09 13:14:58.457-05 2023/05/09 13:14:43 - Write Time Info to Log.0 - dwh_time = 2023-05-09 13:14:43 2023/05/09 13:14:43 - Write Time Info to Log.0 - dwh_time_minus_15 = 2023-05-09 13:14:28.457-05 2023/05/09 13:14:43 - Write Time Info to Log.0 - dwh_time_plus_15 = 2023-05-09 13:14:58.457-05 2023/05/09 13:14:43 - Write Time Info to Log.0 - 2023/05/09 13:14:43 - Write Time Info to Log.0 - ==================== 2023/05/09 13:14:43 - Abort job - ERROR (version 9.3.0.0-428, build 9.3.0.0-428 from 2022-04-12 04.56.25 by buildguy) : At least 1 checkbox for 'Include Period Data' must be checked under System Options for the Data Warehouse. 2023/05/09 13:18:53 - Write Time Info to Log.0 - 2023/05/09 13:18:53 - Write Time Info to Log.0 - ------------> Linenr 1------------------------------ 2023/05/09 13:18:53 - Write Time Info to Log.0 - Date Time Values 2023/05/09 13:18:53 - Write Time Info to Log.0 - 2023/05/09 13:18:53 - Write Time Info to Log.0 - application_time = 2023-05-09 13:18:53.206-05 2023/05/09 13:18:53 - Write Time Info to Log.0 - ppm_time_minus_15 = 2023-05-09 13:18:38.401-05 2023/05/09 13:18:53 - Write Time Info to Log.0 - ppm_time_plus_15 = 2023-05-09 13:19:08.401-05 2023/05/09 13:18:53 - Write Time Info to Log.0 - dwh_time = 2023-05-09 13:18:53 2023/05/09 13:18:53 - Write Time Info to Log.0 - dwh_time_minus_15 = 2023-05-09 13:18:38.401-05 2023/05/09 13:18:53 - Write Time Info to Log.0 - dwh_time_plus_15 = 2023-05-09 13:19:08.401-05 2023/05/09 13:18:53 - Write Time Info to Log.0 - 2023/05/09 13:18:53 - Write Time Info to Log.0 - ==================== 2023/05/09 13:19:27 - Update Config Settings - ERROR (version 9.3.0.0-428, build 9.3.0.0-428 from 2022-04-12 04.56.25 by buildguy) : An error occurred executing this job entry : 2023/05/09 13:19:27 - Update Config Settings - Couldn't execute SQL: UPDATE DWH_CFG_SETTINGS 2023/05/09 13:19:27 - Update Config Settings - SET LANGUAGE_CODE_KEY = 1, 2023/05/09 13:19:27 - Update Config Settings - LANGUAGE_CODE = 'en', 2023/05/09 13:19:27 - Update Config Settings - CURRENCY_PRECISION = 0,0, 2023/05/09 13:19:27 - Update Config Settings - WEEK_START_DAY = 1, 2023/05/09 13:19:27 - Update Config Settings - WEEK_START_DAY_CHANGED = CASE WHEN 1 = 1 THEN 0 ELSE 1 END, 2023/05/09 13:19:27 - Update Config Settings - ENTITY_KEY = 5075791, 2023/05/09 13:19:27 - Update Config Settings - ENTITY_CHANGED = CASE WHEN 5075791 = 0 THEN 0 ELSE 1 END, 2023/05/09 13:19:27 - Update Config Settings - CURRENT_FISCAL_PERIOD_KEY = 5069135, 2023/05/09 13:19:27 - Update Config Settings - FISCAL_PERIOD_CHANGED = CASE WHEN 5069135 = 0 THEN 0 ELSE 1 END, 2023/05/09 13:19:27 - Update Config Settings - WEEKLY_SLICES = 1, 2023/05/09 13:19:27 - Update Config Settings - MONTHLY_SLICES = 1, 2023/05/09 13:19:27 - Update Config Settings - FISCAL_SLICES = 1, 2023/05/09 13:19:27 - Update Config Settings - ONE_SET_OF_FISCAL_PERIODS = 1, 2023/05/09 13:19:27 - Update Config Settings - DISABLE_RESOURCE_SECURITY = 0, 2023/05/09 13:19:27 - Update Config Settings - DISABLE_INVESTMENT_SECURITY = 0, 2023/05/09 13:19:27 - Update Config Settings - SINGLE_CURRENCY = 1, 2023/05/09 13:19:27 - Update Config Settings - DAILY_ROLLOVER_OCCURRED = CASE WHEN '2023/08/09 00:00:00' > '1900/01/01 00:00:00' THEN 1 ELSE 0 END, 2023/05/09 13:19:27 - Update Config Settings - WEEKLY_ROLLOVER_OCCURRED = CASE WHEN '2023/07/31 00:00:00' > '1900/01/01 00:00:00' THEN 1 ELSE 0 END, 2023/05/09 13:19:27 - Update Config Settings - MONTHLY_ROLLOVER_OCCURRED = CASE WHEN '2023/08/01 00:00:00' > '1900/01/01 00:00:00' THEN 1 ELSE 0 END, 2023/05/09 13:19:27 - Update Config Settings - FISCAL_ROLLOVER_OCCURRED = CASE WHEN '2023/06/01 00:00:00' > '1900/01/01 00:00:00' THEN 1 ELSE 0 END, 2023/05/09 13:19:27 - Update Config Settings - DAILY_ROLLOVER_DATE = TO_TIMESTAMP('2023/08/09 00:00:00','YYYY/MM/DD HH24:MI:SS'), 2023/05/09 13:19:27 - Update Config Settings - WEEKLY_ROLLOVER_DATE = TO_TIMESTAMP('2023/07/31 00:00:00','YYYY/MM/DD HH24:MI:SS'), 2023/05/09 13:19:27 - Update Config Settings - MONTHLY_ROLLOVER_DATE = TO_TIMESTAMP('2023/08/01 00:00:00','YYYY/MM/DD HH24:MI:SS'), 2023/05/09 13:19:27 - Update Config Settings - FISCAL_ROLLOVER_DATE = TO_TIMESTAMP('2023/06/01 00:00:00','YYYY/MM/DD HH24:MI:SS'), 2023/05/09 13:19:27 - Update Config Settings - FULL_RELOAD = (CASE WHEN 'Y' = 'Y' THEN 1 2023/05/09 13:19:27 - Update Config Settings - WHEN '2001-07-10 09:04:08' > '1900-01-01 00:00:00' THEN 1 2023/05/09 13:19:27 - Update Config Settings - ELSE 0 END), 2023/05/09 13:19:27 - Update Config Settings - DWH_DIM_PREV_START_DATE = CASE WHEN 'Y' = 'Y' THEN TO_TIMESTAMP('1900/01/01 00:00:00','YYYY/MM/DD HH24:MI:SS') 2023/05/09 13:19:27 - Update Config Settings - ELSE TO_TIMESTAMP('2023/05/09 13:19:19','YYYY/MM/DD HH24:MI:SS') END 2023/05/09 13:19:27 - Update Config Settings - 2023/05/09 13:19:27 - Update Config Settings - ERROR: error de sintaxis en o cerca de «0» Position: 114 2023/05/09 13:19:27 - Update Config Settings - ERROR (version 9.3.0.0-428, build 9.3.0.0-428 from 2022-04-12 04.56.25 by buildguy) : An error occurred executing this job entry : 2023/05/09 13:19:27 - Update Config Settings - Couldn't execute SQL: UPDATE DWH_CFG_SETTINGS 2023/05/09 13:19:27 - Update Config Settings - SET LANGUAGE_CODE_KEY = 1, 2023/05/09 13:19:27 - Update Config Settings - LANGUAGE_CODE = 'en', 2023/05/09 13:19:27 - Update Config Settings - CURRENCY_PRECISION = 0,0, 2023/05/09 13:19:27 - Update Config Settings - WEEK_START_DAY = 1, 2023/05/09 13:19:27 - Update Config Settings - WEEK_START_DAY_CHANGED = CASE WHEN 1 = 1 THEN 0 ELSE 1 END, 2023/05/09 13:19:27 - Update Config Settings - ENTITY_KEY = 5075791, 2023/05/09 13:19:27 - Update Config Settings - ENTITY_CHANGED = CASE WHEN 5075791 = 0 THEN 0 ELSE 1 END, 2023/05/09 13:19:27 - Update Config Settings - CURRENT_FISCAL_PERIOD_KEY = 5069135, 2023/05/09 13:19:27 - Update Config Settings - FISCAL_PERIOD_CHANGED = CASE WHEN 5069135 = 0 THEN 0 ELSE 1 END, 2023/05/09 13:19:27 - Update Config Settings - WEEKLY_SLICES = 1, 2023/05/09 13:19:27 - Update Config Settings - MONTHLY_SLICES = 1, 2023/05/09 13:19:27 - Update Config Settings - FISCAL_SLICES = 1, 2023/05/09 13:19:27 - Update Config Settings - ONE_SET_OF_FISCAL_PERIODS = 1, 2023/05/09 13:19:27 - Update Config Settings - DISABLE_RESOURCE_SECURITY = 0, 2023/05/09 13:19:27 - Update Config Settings - DISABLE_INVESTMENT_SECURITY = 0, 2023/05/09 13:19:27 - Update Config Settings - SINGLE_CURRENCY = 1, 2023/05/09 13:19:27 - Update Config Settings - DAILY_ROLLOVER_OCCURRED = CASE WHEN '2023/08/09 00:00:00' > '1900/01/01 00:00:00' THEN 1 ELSE 0 END, 2023/05/09 13:19:27 - Update Config Settings - WEEKLY_ROLLOVER_OCCURRED = CASE WHEN '2023/07/31 00:00:00' > '1900/01/01 00:00:00' THEN 1 ELSE 0 END, 2023/05/09 13:19:27 - Update Config Settings - MONTHLY_ROLLOVER_OCCURRED = CASE WHEN '2023/08/01 00:00:00' > '1900/01/01 00:00:00' THEN 1 ELSE 0 END, 2023/05/09 13:19:27 - Update Config Settings - FISCAL_ROLLOVER_OCCURRED = CASE WHEN '2023/06/01 00:00:00' > '1900/01/01 00:00:00' THEN 1 ELSE 0 END, 2023/05/09 13:19:27 - Update Config Settings - DAILY_ROLLOVER_DATE = TO_TIMESTAMP('2023/08/09 00:00:00','YYYY/MM/DD HH24:MI:SS'), 2023/05/09 13:19:27 - Update Config Settings - WEEKLY_ROLLOVER_DATE = TO_TIMESTAMP('2023/07/31 00:00:00','YYYY/MM/DD HH24:MI:SS'), 2023/05/09 13:19:27 - Update Config Settings - MONTHLY_ROLLOVER_DATE = TO_TIMESTAMP('2023/08/01 00:00:00','YYYY/MM/DD HH24:MI:SS'), 2023/05/09 13:19:27 - Update Config Settings - FISCAL_ROLLOVER_DATE = TO_TIMESTAMP('2023/06/01 00:00:00','YYYY/MM/DD HH24:MI:SS'), 2023/05/09 13:19:27 - Update Config Settings - FULL_RELOAD = (CASE WHEN 'Y' = 'Y' THEN 1 2023/05/09 13:19:27 - Update Config Settings - WHEN '2001-07-10 09:04:08' > '1900-01-01 00:00:00' THEN 1 2023/05/09 13:19:27 - Update Config Settings - ELSE 0 END), 2023/05/09 13:19:27 - Update Config Settings - DWH_DIM_PREV_START_DATE = CASE WHEN 'Y' = 'Y' THEN TO_TIMESTAMP('1900/01/01 00:00:00','YYYY/MM/DD HH24:MI:SS') 2023/05/09 13:19:27 - Update Config Settings - ELSE TO_TIMESTAMP('2023/05/09 13:19:19','YYYY/MM/DD HH24:MI:SS') END 2023/05/09 13:19:27 - Update Config Settings - 2023/05/09 13:19:27 - Update Config Settings - ERROR: error de sintaxis en o cerca de «0» Position: 114 2023/05/09 13:19:27 - Update Config Settings - ERROR (version 9.3.0.0-428, build 9.3.0.0-428 from 2022-04-12 04.56.25 by buildguy) : An error occurred executing this job entry : 2023/05/09 13:19:27 - Update Config Settings - Couldn't execute SQL: UPDATE DWH_CFG_SETTINGS 2023/05/09 13:19:27 - Update Config Settings - SET LANGUAGE_CODE_KEY = 1, 2023/05/09 13:19:27 - Update Config Settings - LANGUAGE_CODE = 'en', 2023/05/09 13:19:27 - Update Config Settings - CURRENCY_PRECISION = 0,0, 2023/05/09 13:19:27 - Update Config Settings - WEEK_START_DAY = 1, 2023/05/09 13:19:27 - Update Config Settings - WEEK_START_DAY_CHANGED = CASE WHEN 1 = 1 THEN 0 ELSE 1 END, 2023/05/09 13:19:27 - Update Config Settings - ENTITY_KEY = 5075791, 2023/05/09 13:19:27 - Update Config Settings - ENTITY_CHANGED = CASE WHEN 5075791 = 0 THEN 0 ELSE 1 END, 2023/05/09 13:19:27 - Update Config Settings - CURRENT_FISCAL_PERIOD_KEY = 5069135, 2023/05/09 13:19:27 - Update Config Settings - FISCAL_PERIOD_CHANGED = CASE WHEN 5069135 = 0 THEN 0 ELSE 1 END, 2023/05/09 13:19:27 - Update Config Settings - WEEKLY_SLICES = 1, 2023/05/09 13:19:27 - Update Config Settings - MONTHLY_SLICES = 1, 2023/05/09 13:19:27 - Update Config Settings - FISCAL_SLICES = 1, 2023/05/09 13:19:27 - Update Config Settings - ONE_SET_OF_FISCAL_PERIODS = 1, 2023/05/09 13:19:27 - Update Config Settings - DISABLE_RESOURCE_SECURITY = 0, 2023/05/09 13:19:27 - Update Config Settings - DISABLE_INVESTMENT_SECURITY = 0, 2023/05/09 13:19:27 - Update Config Settings - SINGLE_CURRENCY = 1, 2023/05/09 13:19:27 - Update Config Settings - DAILY_ROLLOVER_OCCURRED = CASE WHEN '2023/08/09 00:00:00' > '1900/01/01 00:00:00' THEN 1 ELSE 0 END, 2023/05/09 13:19:27 - Update Config Settings - WEEKLY_ROLLOVER_OCCURRED = CASE WHEN '2023/07/31 00:00:00' > '1900/01/01 00:00:00' THEN 1 ELSE 0 END, 2023/05/09 13:19:27 - Update Config Settings - MONTHLY_ROLLOVER_OCCURRED = CASE WHEN '2023/08/01 00:00:00' > '1900/01/01 00:00:00' THEN 1 ELSE 0 END, 2023/05/09 13:19:27 - Update Config Settings - FISCAL_ROLLOVER_OCCURRED = CASE WHEN '2023/06/01 00:00:00' > '1900/01/01 00:00:00' THEN 1 ELSE 0 END, 2023/05/09 13:19:27 - Update Config Settings - DAILY_ROLLOVER_DATE = TO_TIMESTAMP('2023/08/09 00:00:00','YYYY/MM/DD HH24:MI:SS'), 2023/05/09 13:19:27 - Update Config Settings - WEEKLY_ROLLOVER_DATE = TO_TIMESTAMP('2023/07/31 00:00:00','YYYY/MM/DD HH24:MI:SS'), 2023/05/09 13:19:27 - Update Config Settings - MONTHLY_ROLLOVER_DATE = TO_TIMESTAMP('2023/08/01 00:00:00','YYYY/MM/DD HH24:MI:SS'), 2023/05/09 13:19:27 - Update Config Settings - FISCAL_ROLLOVER_DATE = TO_TIMESTAMP('2023/06/01 00:00:00','YYYY/MM/DD HH24:MI:SS'), 2023/05/09 13:19:27 - Update Config Settings - FULL_RELOAD = (CASE WHEN 'Y' = 'Y' THEN 1 2023/05/09 13:19:27 - Update Config Settings - WHEN '2001-07-10 09:04:08' > '1900-01-01 00:00:00' THEN 1 2023/05/09 13:19:27 - Update Config Settings - ELSE 0 END), 2023/05/09 13:19:27 - Update Config Settings - DWH_DIM_PREV_START_DATE = CASE WHEN 'Y' = 'Y' THEN TO_TIMESTAMP('1900/01/01 00:00:00','YYYY/MM/DD HH24:MI:SS') 2023/05/09 13:19:27 - Update Config Settings - ELSE TO_TIMESTAMP('2023/05/09 13:19:19','YYYY/MM/DD HH24:MI:SS') END 2023/05/09 13:19:27 - Update Config Settings - 2023/05/09 13:19:27 - Update Config Settings - ERROR: error de sintaxis en o cerca de «0» Position: 114 2023/05/09 13:19:27 - Update Config Settings - ERROR (version 9.3.0.0-428, build 9.3.0.0-428 from 2022-04-12 04.56.25 by buildguy) : An error occurred executing this job entry : 2023/05/09 13:19:27 - Update Config Settings - Couldn't execute SQL: UPDATE DWH_CFG_SETTINGS 2023/05/09 13:19:27 - Update Config Settings - SET LANGUAGE_CODE_KEY = 1, 2023/05/09 13:19:27 - Update Config Settings - LANGUAGE_CODE = 'en', 2023/05/09 13:19:27 - Update Config Settings - CURRENCY_PRECISION = 0,0, 2023/05/09 13:19:27 - Update Config Settings - WEEK_START_DAY = 1, 2023/05/09 13:19:27 - Update Config Settings - WEEK_START_DAY_CHANGED = CASE WHEN 1 = 1 THEN 0 ELSE 1 END, 2023/05/09 13:19:27 - Update Config Settings - ENTITY_KEY = 5075791, 2023/05/09 13:19:27 - Update Config Settings - ENTITY_CHANGED = CASE WHEN 5075791 = 0 THEN 0 ELSE 1 END, 2023/05/09 13:19:27 - Update Config Settings - CURRENT_FISCAL_PERIOD_KEY = 5069135, 2023/05/09 13:19:27 - Update Config Settings - FISCAL_PERIOD_CHANGED = CASE WHEN 5069135 = 0 THEN 0 ELSE 1 END, 2023/05/09 13:19:27 - Update Config Settings - WEEKLY_SLICES = 1, 2023/05/09 13:19:27 - Update Config Settings - MONTHLY_SLICES = 1, 2023/05/09 13:19:27 - Update Config Settings - FISCAL_SLICES = 1, 2023/05/09 13:19:27 - Update Config Settings - ONE_SET_OF_FISCAL_PERIODS = 1, 2023/05/09 13:19:27 - Update Config Settings - DISABLE_RESOURCE_SECURITY = 0, 2023/05/09 13:19:27 - Update Config Settings - DISABLE_INVESTMENT_SECURITY = 0, 2023/05/09 13:19:27 - Update Config Settings - SINGLE_CURRENCY = 1, 2023/05/09 13:19:27 - Update Config Settings - DAILY_ROLLOVER_OCCURRED = CASE WHEN '2023/08/09 00:00:00' > '1900/01/01 00:00:00' THEN 1 ELSE 0 END, 2023/05/09 13:19:27 - Update Config Settings - WEEKLY_ROLLOVER_OCCURRED = CASE WHEN '2023/07/31 00:00:00' > '1900/01/01 00:00:00' THEN 1 ELSE 0 END, 2023/05/09 13:19:27 - Update Config Settings - MONTHLY_ROLLOVER_OCCURRED = CASE WHEN '2023/08/01 00:00:00' > '1900/01/01 00:00:00' THEN 1 ELSE 0 END, 2023/05/09 13:19:27 - Update Config Settings - FISCAL_ROLLOVER_OCCURRED = CASE WHEN '2023/06/01 00:00:00' > '1900/01/01 00:00:00' THEN 1 ELSE 0 END, 2023/05/09 13:19:27 - Update Config Settings - DAILY_ROLLOVER_DATE = TO_TIMESTAMP('2023/08/09 00:00:00','YYYY/MM/DD HH24:MI:SS'), 2023/05/09 13:19:27 - Update Config Settings - WEEKLY_ROLLOVER_DATE = TO_TIMESTAMP('2023/07/31 00:00:00','YYYY/MM/DD HH24:MI:SS'), 2023/05/09 13:19:27 - Update Config Settings - MONTHLY_ROLLOVER_DATE = TO_TIMESTAMP('2023/08/01 00:00:00','YYYY/MM/DD HH24:MI:SS'), 2023/05/09 13:19:27 - Update Config Settings - FISCAL_ROLLOVER_DATE = TO_TIMESTAMP('2023/06/01 00:00:00','YYYY/MM/DD HH24:MI:SS'), 2023/05/09 13:19:27 - Update Config Settings - FULL_RELOAD = (CASE WHEN 'Y' = 'Y' THEN 1 2023/05/09 13:19:27 - Update Config Settings - WHEN '2001-07-10 09:04:08' > '1900-01-01 00:00:00' THEN 1 2023/05/09 13:19:27 - Update Config Settings - ELSE 0 END), 2023/05/09 13:19:27 - Update Config Settings - DWH_DIM_PREV_START_DATE = CASE WHEN 'Y' = 'Y' THEN TO_TIMESTAMP('1900/01/01 00:00:00','YYYY/MM/DD HH24:MI:SS') 2023/05/09 13:19:27 - Update Config Settings - ELSE TO_TIMESTAMP('2023/05/09 13:19:19','YYYY/MM/DD HH24:MI:SS') END 2023/05/09 13:19:27 - Update Config Settings - 2023/05/09 13:19:27 - Update Config Settings - ERROR: error de sintaxis en o cerca de «0» Position: 114 null INFO 2023-05-09 13:25:10,330 [Dispatch Load Data Warehouse : bg@DESKTOP-L4FIFVN (tenant=clarity)] dwh.event (clarity:admin:5281571__B615634B-452E-4025-BAD2-090701EB5CA1:Load Data Warehouse) Job Parameters INFO 2023-05-09 13:25:10,330 [Dispatch Load Data Warehouse : bg@DESKTOP-L4FIFVN (tenant=clarity)] dwh.event (clarity:admin:5281571__B615634B-452E-4025-BAD2-090701EB5CA1:Load Data Warehouse) SRC_DATABASE_URL: jdbc:postgresql://localhost:5432/ppmdb INFO 2023-05-09 13:25:10,331 [Dispatch Load Data Warehouse : bg@DESKTOP-L4FIFVN (tenant=clarity)] dwh.event (clarity:admin:5281571__B615634B-452E-4025-BAD2-090701EB5CA1:Load Data Warehouse) SRC_DATABASE_CLASS: org.postgresql.Driver INFO 2023-05-09 13:25:10,331 [Dispatch Load Data Warehouse : bg@DESKTOP-L4FIFVN (tenant=clarity)] dwh.event (clarity:admin:5281571__B615634B-452E-4025-BAD2-090701EB5CA1:Load Data Warehouse) SRC_DATABASE_USER: ppmdb INFO 2023-05-09 13:25:10,331 [Dispatch Load Data Warehouse : bg@DESKTOP-L4FIFVN (tenant=clarity)] dwh.event (clarity:admin:5281571__B615634B-452E-4025-BAD2-090701EB5CA1:Load Data Warehouse) TGT_DATABASE_URL: jdbc:postgresql://localhost:5432/dwhdb INFO 2023-05-09 13:25:10,331 [Dispatch Load Data Warehouse : bg@DESKTOP-L4FIFVN (tenant=clarity)] dwh.event (clarity:admin:5281571__B615634B-452E-4025-BAD2-090701EB5CA1:Load Data Warehouse) TGT_DATABASE_CLASS: org.postgresql.Driver INFO 2023-05-09 13:25:10,331 [Dispatch Load Data Warehouse : bg@DESKTOP-L4FIFVN (tenant=clarity)] dwh.event (clarity:admin:5281571__B615634B-452E-4025-BAD2-090701EB5CA1:Load Data Warehouse) TGT_DATABASE_USER: dwhdb INFO 2023-05-09 13:25:10,331 [Dispatch Load Data Warehouse : bg@DESKTOP-L4FIFVN (tenant=clarity)] dwh.event (clarity:admin:5281571__B615634B-452E-4025-BAD2-090701EB5CA1:Load Data Warehouse) CLARITY_DB_TYPE: postgres INFO 2023-05-09 13:25:10,331 [Dispatch Load Data Warehouse : bg@DESKTOP-L4FIFVN (tenant=clarity)] dwh.event (clarity:admin:5281571__B615634B-452E-4025-BAD2-090701EB5CA1:Load Data Warehouse) DWH_DB_TYPE: postgres INFO 2023-05-09 13:25:10,331 [Dispatch Load Data Warehouse : bg@DESKTOP-L4FIFVN (tenant=clarity)] dwh.event (clarity:admin:5281571__B615634B-452E-4025-BAD2-090701EB5CA1:Load Data Warehouse) SRC_DBNAME: ppmdb INFO 2023-05-09 13:25:10,332 [Dispatch Load Data Warehouse : bg@DESKTOP-L4FIFVN (tenant=clarity)] dwh.event (clarity:admin:5281571__B615634B-452E-4025-BAD2-090701EB5CA1:Load Data Warehouse) DB_LINK: PPMDBLINK INFO 2023-05-09 13:25:10,461 [Thread-134] dwh.event (none:none:none:none) dwh_etl_master - Start of job execution INFO 2023-05-09 13:25:11,906 [dwh_check_slice_info_pg - Write Time Info to Log] dwh.event (none:none:none:none) Write Time Info to Log - ------------> Linenr 1------------------------------ Date Time Values application_time = 2023-05-09 13:25:11.544-05 ppm_time_minus_15 = 2023-05-09 13:24:56.704-05 ppm_time_plus_15 = 2023-05-09 13:25:26.704-05 dwh_time = 2023-05-09 13:25:11 dwh_time_minus_15 = 2023-05-09 13:24:56.704-05 dwh_time_plus_15 = 2023-05-09 13:25:26.704-05 ==================== ERROR 2023-05-09 13:25:46,649 [dwh_load_settings_check_pg UUID: 7c672f8b-88f8-4e36-a1fd-328a56c78b7f] dwh.event (none:none:none:none) Update Config Settings - An error occurred executing this job entry : Couldn't execute SQL: UPDATE DWH_CFG_SETTINGS SET LANGUAGE_CODE_KEY = 1, LANGUAGE_CODE = 'en', CURRENCY_PRECISION = 0,0, WEEK_START_DAY = 1, WEEK_START_DAY_CHANGED = CASE WHEN 1 = 1 THEN 0 ELSE 1 END, ENTITY_KEY = 5075791, ENTITY_CHANGED = CASE WHEN 5075791 = 0 THEN 0 ELSE 1 END, CURRENT_FISCAL_PERIOD_KEY = 5069135, FISCAL_PERIOD_CHANGED = CASE WHEN 5069135 = 0 THEN 0 ELSE 1 END, WEEKLY_SLICES = 1, MONTHLY_SLICES = 1, FISCAL_SLICES = 1, ONE_SET_OF_FISCAL_PERIODS = 1, DISABLE_RESOURCE_SECURITY = 0, DISABLE_INVESTMENT_SECURITY = 0, SINGLE_CURRENCY = 1, DAILY_ROLLOVER_OCCURRED = CASE WHEN '2023/08/09 00:00:00' > '1900/01/01 00:00:00' THEN 1 ELSE 0 END, WEEKLY_ROLLOVER_OCCURRED = CASE WHEN '2023/07/31 00:00:00' > '1900/01/01 00:00:00' THEN 1 ELSE 0 END, MONTHLY_ROLLOVER_OCCURRED = CASE WHEN '2023/08/01 00:00:00' > '1900/01/01 00:00:00' THEN 1 ELSE 0 END, FISCAL_ROLLOVER_OCCURRED = CASE WHEN '2023/06/01 00:00:00' > '1900/01/01 00:00:00' THEN 1 ELSE 0 END, DAILY_ROLLOVER_DATE = TO_TIMESTAMP('2023/08/09 00:00:00','YYYY/MM/DD HH24:MI:SS'), WEEKLY_ROLLOVER_DATE = TO_TIMESTAMP('2023/07/31 00:00:00','YYYY/MM/DD HH24:MI:SS'), MONTHLY_ROLLOVER_DATE = TO_TIMESTAMP('2023/08/01 00:00:00','YYYY/MM/DD HH24:MI:SS'), FISCAL_ROLLOVER_DATE = TO_TIMESTAMP('2023/06/01 00:00:00','YYYY/MM/DD HH24:MI:SS'), FULL_RELOAD = (CASE WHEN 'Y' = 'Y' THEN 1 WHEN '2001-07-10 09:04:08' > '1900-01-01 00:00:00' THEN 1 ELSE 0 END), DWH_DIM_PREV_START_DATE = CASE WHEN 'Y' = 'Y' THEN TO_TIMESTAMP('1900/01/01 00:00:00','YYYY/MM/DD HH24:MI:SS') ELSE TO_TIMESTAMP('2023/05/09 13:25:40','YYYY/MM/DD HH24:MI:SS') END ERROR: error de sintaxis en o cerca de «0» Position: 114 INFO 2023-05-09 13:25:46,831 [Thread-134] dwh.event (none:none:none:none) dwh_etl_master - Job execution finished ERROR 2023-05-09 13:25:47,075 [Dispatch Load Data Warehouse : bg@DESKTOP-L4FIFVN (tenant=clarity)] dwh.event (clarity:admin:5281571__B615634B-452E-4025-BAD2-090701EB5CA1:Load Data Warehouse) ETL Job Failed. Log details below: 2023/05/09 13:14:43 - Write Time Info to Log.0 - 2023/05/09 13:14:43 - Write Time Info to Log.0 - ------------> Linenr 1------------------------------ 2023/05/09 13:14:43 - Write Time Info to Log.0 - Date Time Values 2023/05/09 13:14:43 - Write Time Info to Log.0 - 2023/05/09 13:14:43 - Write Time Info to Log.0 - application_time = 2023-05-09 13:14:43.262-05 2023/05/09 13:14:43 - Write Time Info to Log.0 - ppm_time_minus_15 = 2023-05-09 13:14:28.457-05 2023/05/09 13:14:43 - Write Time Info to Log.0 - ppm_time_plus_15 = 2023-05-09 13:14:58.457-05 2023/05/09 13:14:43 - Write Time Info to Log.0 - dwh_time = 2023-05-09 13:14:43 2023/05/09 13:14:43 - Write Time Info to Log.0 - dwh_time_minus_15 = 2023-05-09 13:14:28.457-05 2023/05/09 13:14:43 - Write Time Info to Log.0 - dwh_time_plus_15 = 2023-05-09 13:14:58.457-05 2023/05/09 13:14:43 - Write Time Info to Log.0 - 2023/05/09 13:14:43 - Write Time Info to Log.0 - ==================== 2023/05/09 13:14:43 - Abort job - ERROR (version 9.3.0.0-428, build 9.3.0.0-428 from 2022-04-12 04.56.25 by buildguy) : At least 1 checkbox for 'Include Period Data' must be checked under System Options for the Data Warehouse. 2023/05/09 13:18:53 - Write Time Info to Log.0 - 2023/05/09 13:18:53 - Write Time Info to Log.0 - ------------> Linenr 1------------------------------ 2023/05/09 13:18:53 - Write Time Info to Log.0 - Date Time Values 2023/05/09 13:18:53 - Write Time Info to Log.0 - 2023/05/09 13:18:53 - Write Time Info to Log.0 - application_time = 2023-05-09 13:18:53.206-05 2023/05/09 13:18:53 - Write Time Info to Log.0 - ppm_time_minus_15 = 2023-05-09 13:18:38.401-05 2023/05/09 13:18:53 - Write Time Info to Log.0 - ppm_time_plus_15 = 2023-05-09 13:19:08.401-05 2023/05/09 13:18:53 - Write Time Info to Log.0 - dwh_time = 2023-05-09 13:18:53 2023/05/09 13:18:53 - Write Time Info to Log.0 - dwh_time_minus_15 = 2023-05-09 13:18:38.401-05 2023/05/09 13:18:53 - Write Time Info to Log.0 - dwh_time_plus_15 = 2023-05-09 13:19:08.401-05 2023/05/09 13:18:53 - Write Time Info to Log.0 - 2023/05/09 13:18:53 - Write Time Info to Log.0 - ==================== 2023/05/09 13:19:27 - Update Config Settings - ERROR (version 9.3.0.0-428, build 9.3.0.0-428 from 2022-04-12 04.56.25 by buildguy) : An error occurred executing this job entry : 2023/05/09 13:19:27 - Update Config Settings - Couldn't execute SQL: UPDATE DWH_CFG_SETTINGS 2023/05/09 13:19:27 - Update Config Settings - SET LANGUAGE_CODE_KEY = 1, 2023/05/09 13:19:27 - Update Config Settings - LANGUAGE_CODE = 'en', 2023/05/09 13:19:27 - Update Config Settings - CURRENCY_PRECISION = 0,0, 2023/05/09 13:19:27 - Update Config Settings - WEEK_START_DAY = 1, 2023/05/09 13:19:27 - Update Config Settings - WEEK_START_DAY_CHANGED = CASE WHEN 1 = 1 THEN 0 ELSE 1 END, 2023/05/09 13:19:27 - Update Config Settings - ENTITY_KEY = 5075791, 2023/05/09 13:19:27 - Update Config Settings - ENTITY_CHANGED = CASE WHEN 5075791 = 0 THEN 0 ELSE 1 END, 2023/05/09 13:19:27 - Update Config Settings - CURRENT_FISCAL_PERIOD_KEY = 5069135, 2023/05/09 13:19:27 - Update Config Settings - FISCAL_PERIOD_CHANGED = CASE WHEN 5069135 = 0 THEN 0 ELSE 1 END, 2023/05/09 13:19:27 - Update Config Settings - WEEKLY_SLICES = 1, 2023/05/09 13:19:27 - Update Config Settings - MONTHLY_SLICES = 1, 2023/05/09 13:19:27 - Update Config Settings - FISCAL_SLICES = 1, 2023/05/09 13:19:27 - Update Config Settings - ONE_SET_OF_FISCAL_PERIODS = 1, 2023/05/09 13:19:27 - Update Config Settings - DISABLE_RESOURCE_SECURITY = 0, 2023/05/09 13:19:27 - Update Config Settings - DISABLE_INVESTMENT_SECURITY = 0, 2023/05/09 13:19:27 - Update Config Settings - SINGLE_CURRENCY = 1, 2023/05/09 13:19:27 - Update Config Settings - DAILY_ROLLOVER_OCCURRED = CASE WHEN '2023/08/09 00:00:00' > '1900/01/01 00:00:00' THEN 1 ELSE 0 END, 2023/05/09 13:19:27 - Update Config Settings - WEEKLY_ROLLOVER_OCCURRED = CASE WHEN '2023/07/31 00:00:00' > '1900/01/01 00:00:00' THEN 1 ELSE 0 END, 2023/05/09 13:19:27 - Update Config Settings - MONTHLY_ROLLOVER_OCCURRED = CASE WHEN '2023/08/01 00:00:00' > '1900/01/01 00:00:00' THEN 1 ELSE 0 END, 2023/05/09 13:19:27 - Update Config Settings - FISCAL_ROLLOVER_OCCURRED = CASE WHEN '2023/06/01 00:00:00' > '1900/01/01 00:00:00' THEN 1 ELSE 0 END, 2023/05/09 13:19:27 - Update Config Settings - DAILY_ROLLOVER_DATE = TO_TIMESTAMP('2023/08/09 00:00:00','YYYY/MM/DD HH24:MI:SS'), 2023/05/09 13:19:27 - Update Config Settings - WEEKLY_ROLLOVER_DATE = TO_TIMESTAMP('2023/07/31 00:00:00','YYYY/MM/DD HH24:MI:SS'), 2023/05/09 13:19:27 - Update Config Settings - MONTHLY_ROLLOVER_DATE = TO_TIMESTAMP('2023/08/01 00:00:00','YYYY/MM/DD HH24:MI:SS'), 2023/05/09 13:19:27 - Update Config Settings - FISCAL_ROLLOVER_DATE = TO_TIMESTAMP('2023/06/01 00:00:00','YYYY/MM/DD HH24:MI:SS'), 2023/05/09 13:19:27 - Update Config Settings - FULL_RELOAD = (CASE WHEN 'Y' = 'Y' THEN 1 2023/05/09 13:19:27 - Update Config Settings - WHEN '2001-07-10 09:04:08' > '1900-01-01 00:00:00' THEN 1 2023/05/09 13:19:27 - Update Config Settings - ELSE 0 END), 2023/05/09 13:19:27 - Update Config Settings - DWH_DIM_PREV_START_DATE = CASE WHEN 'Y' = 'Y' THEN TO_TIMESTAMP('1900/01/01 00:00:00','YYYY/MM/DD HH24:MI:SS') 2023/05/09 13:19:27 - Update Config Settings - ELSE TO_TIMESTAMP('2023/05/09 13:19:19','YYYY/MM/DD HH24:MI:SS') END 2023/05/09 13:19:27 - Update Config Settings - 2023/05/09 13:19:27 - Update Config Settings - ERROR: error de sintaxis en o cerca de «0» Position: 114 2023/05/09 13:25:11 - Write Time Info to Log.0 - 2023/05/09 13:25:11 - Write Time Info to Log.0 - ------------> Linenr 1------------------------------ 2023/05/09 13:25:11 - Write Time Info to Log.0 - Date Time Values 2023/05/09 13:25:11 - Write Time Info to Log.0 - 2023/05/09 13:25:11 - Write Time Info to Log.0 - application_time = 2023-05-09 13:25:11.544-05 2023/05/09 13:25:11 - Write Time Info to Log.0 - ppm_time_minus_15 = 2023-05-09 13:24:56.704-05 2023/05/09 13:25:11 - Write Time Info to Log.0 - ppm_time_plus_15 = 2023-05-09 13:25:26.704-05 2023/05/09 13:25:11 - Write Time Info to Log.0 - dwh_time = 2023-05-09 13:25:11 2023/05/09 13:25:11 - Write Time Info to Log.0 - dwh_time_minus_15 = 2023-05-09 13:24:56.704-05 2023/05/09 13:25:11 - Write Time Info to Log.0 - dwh_time_plus_15 = 2023-05-09 13:25:26.704-05 2023/05/09 13:25:11 - Write Time Info to Log.0 - 2023/05/09 13:25:11 - Write Time Info to Log.0 - ==================== 2023/05/09 13:25:46 - Update Config Settings - ERROR (version 9.3.0.0-428, build 9.3.0.0-428 from 2022-04-12 04.56.25 by buildguy) : An error occurred executing this job entry : 2023/05/09 13:25:46 - Update Config Settings - Couldn't execute SQL: UPDATE DWH_CFG_SETTINGS 2023/05/09 13:25:46 - Update Config Settings - SET LANGUAGE_CODE_KEY = 1, 2023/05/09 13:25:46 - Update Config Settings - LANGUAGE_CODE = 'en', 2023/05/09 13:25:46 - Update Config Settings - CURRENCY_PRECISION = 0,0, 2023/05/09 13:25:46 - Update Config Settings - WEEK_START_DAY = 1, 2023/05/09 13:25:46 - Update Config Settings - WEEK_START_DAY_CHANGED = CASE WHEN 1 = 1 THEN 0 ELSE 1 END, 2023/05/09 13:25:46 - Update Config Settings - ENTITY_KEY = 5075791, 2023/05/09 13:25:46 - Update Config Settings - ENTITY_CHANGED = CASE WHEN 5075791 = 0 THEN 0 ELSE 1 END, 2023/05/09 13:25:46 - Update Config Settings - CURRENT_FISCAL_PERIOD_KEY = 5069135, 2023/05/09 13:25:46 - Update Config Settings - FISCAL_PERIOD_CHANGED = CASE WHEN 5069135 = 0 THEN 0 ELSE 1 END, 2023/05/09 13:25:46 - Update Config Settings - WEEKLY_SLICES = 1, 2023/05/09 13:25:46 - Update Config Settings - MONTHLY_SLICES = 1, 2023/05/09 13:25:46 - Update Config Settings - FISCAL_SLICES = 1, 2023/05/09 13:25:46 - Update Config Settings - ONE_SET_OF_FISCAL_PERIODS = 1, 2023/05/09 13:25:46 - Update Config Settings - DISABLE_RESOURCE_SECURITY = 0, 2023/05/09 13:25:46 - Update Config Settings - DISABLE_INVESTMENT_SECURITY = 0, 2023/05/09 13:25:46 - Update Config Settings - SINGLE_CURRENCY = 1, 2023/05/09 13:25:46 - Update Config Settings - DAILY_ROLLOVER_OCCURRED = CASE WHEN '2023/08/09 00:00:00' > '1900/01/01 00:00:00' THEN 1 ELSE 0 END, 2023/05/09 13:25:46 - Update Config Settings - WEEKLY_ROLLOVER_OCCURRED = CASE WHEN '2023/07/31 00:00:00' > '1900/01/01 00:00:00' THEN 1 ELSE 0 END, 2023/05/09 13:25:46 - Update Config Settings - MONTHLY_ROLLOVER_OCCURRED = CASE WHEN '2023/08/01 00:00:00' > '1900/01/01 00:00:00' THEN 1 ELSE 0 END, 2023/05/09 13:25:46 - Update Config Settings - FISCAL_ROLLOVER_OCCURRED = CASE WHEN '2023/06/01 00:00:00' > '1900/01/01 00:00:00' THEN 1 ELSE 0 END, 2023/05/09 13:25:46 - Update Config Settings - DAILY_ROLLOVER_DATE = TO_TIMESTAMP('2023/08/09 00:00:00','YYYY/MM/DD HH24:MI:SS'), 2023/05/09 13:25:46 - Update Config Settings - WEEKLY_ROLLOVER_DATE = TO_TIMESTAMP('2023/07/31 00:00:00','YYYY/MM/DD HH24:MI:SS'), 2023/05/09 13:25:46 - Update Config Settings - MONTHLY_ROLLOVER_DATE = TO_TIMESTAMP('2023/08/01 00:00:00','YYYY/MM/DD HH24:MI:SS'), 2023/05/09 13:25:46 - Update Config Settings - FISCAL_ROLLOVER_DATE = TO_TIMESTAMP('2023/06/01 00:00:00','YYYY/MM/DD HH24:MI:SS'), 2023/05/09 13:25:46 - Update Config Settings - FULL_RELOAD = (CASE WHEN 'Y' = 'Y' THEN 1 2023/05/09 13:25:46 - Update Config Settings - WHEN '2001-07-10 09:04:08' > '1900-01-01 00:00:00' THEN 1 2023/05/09 13:25:46 - Update Config Settings - ELSE 0 END), 2023/05/09 13:25:46 - Update Config Settings - DWH_DIM_PREV_START_DATE = CASE WHEN 'Y' = 'Y' THEN TO_TIMESTAMP('1900/01/01 00:00:00','YYYY/MM/DD HH24:MI:SS') 2023/05/09 13:25:46 - Update Config Settings - ELSE TO_TIMESTAMP('2023/05/09 13:25:40','YYYY/MM/DD HH24:MI:SS') END 2023/05/09 13:25:46 - Update Config Settings - 2023/05/09 13:25:46 - Update Config Settings - ERROR: error de sintaxis en o cerca de «0» Position: 114 2023/05/09 13:19:27 - Update Config Settings - ERROR (version 9.3.0.0-428, build 9.3.0.0-428 from 2022-04-12 04.56.25 by buildguy) : An error occurred executing this job entry : 2023/05/09 13:19:27 - Update Config Settings - Couldn't execute SQL: UPDATE DWH_CFG_SETTINGS 2023/05/09 13:19:27 - Update Config Settings - SET LANGUAGE_CODE_KEY = 1, 2023/05/09 13:19:27 - Update Config Settings - LANGUAGE_CODE = 'en', 2023/05/09 13:19:27 - Update Config Settings - CURRENCY_PRECISION = 0,0, 2023/05/09 13:19:27 - Update Config Settings - WEEK_START_DAY = 1, 2023/05/09 13:19:27 - Update Config Settings - WEEK_START_DAY_CHANGED = CASE WHEN 1 = 1 THEN 0 ELSE 1 END, 2023/05/09 13:19:27 - Update Config Settings - ENTITY_KEY = 5075791, 2023/05/09 13:19:27 - Update Config Settings - ENTITY_CHANGED = CASE WHEN 5075791 = 0 THEN 0 ELSE 1 END, 2023/05/09 13:19:27 - Update Config Settings - CURRENT_FISCAL_PERIOD_KEY = 5069135, 2023/05/09 13:19:27 - Update Config Settings - FISCAL_PERIOD_CHANGED = CASE WHEN 5069135 = 0 THEN 0 ELSE 1 END, 2023/05/09 13:19:27 - Update Config Settings - WEEKLY_SLICES = 1, 2023/05/09 13:19:27 - Update Config Settings - MONTHLY_SLICES = 1, 2023/05/09 13:19:27 - Update Config Settings - FISCAL_SLICES = 1, 2023/05/09 13:19:27 - Update Config Settings - ONE_SET_OF_FISCAL_PERIODS = 1, 2023/05/09 13:19:27 - Update Config Settings - DISABLE_RESOURCE_SECURITY = 0, 2023/05/09 13:19:27 - Update Config Settings - DISABLE_INVESTMENT_SECURITY = 0, 2023/05/09 13:19:27 - Update Config Settings - SINGLE_CURRENCY = 1, 2023/05/09 13:19:27 - Update Config Settings - DAILY_ROLLOVER_OCCURRED = CASE WHEN '2023/08/09 00:00:00' > '1900/01/01 00:00:00' THEN 1 ELSE 0 END, 2023/05/09 13:19:27 - Update Config Settings - WEEKLY_ROLLOVER_OCCURRED = CASE WHEN '2023/07/31 00:00:00' > '1900/01/01 00:00:00' THEN 1 ELSE 0 END, 2023/05/09 13:19:27 - Update Config Settings - MONTHLY_ROLLOVER_OCCURRED = CASE WHEN '2023/08/01 00:00:00' > '1900/01/01 00:00:00' THEN 1 ELSE 0 END, 2023/05/09 13:19:27 - Update Config Settings - FISCAL_ROLLOVER_OCCURRED = CASE WHEN '2023/06/01 00:00:00' > '1900/01/01 00:00:00' THEN 1 ELSE 0 END, 2023/05/09 13:19:27 - Update Config Settings - DAILY_ROLLOVER_DATE = TO_TIMESTAMP('2023/08/09 00:00:00','YYYY/MM/DD HH24:MI:SS'), 2023/05/09 13:19:27 - Update Config Settings - WEEKLY_ROLLOVER_DATE = TO_TIMESTAMP('2023/07/31 00:00:00','YYYY/MM/DD HH24:MI:SS'), 2023/05/09 13:19:27 - Update Config Settings - MONTHLY_ROLLOVER_DATE = TO_TIMESTAMP('2023/08/01 00:00:00','YYYY/MM/DD HH24:MI:SS'), 2023/05/09 13:19:27 - Update Config Settings - FISCAL_ROLLOVER_DATE = TO_TIMESTAMP('2023/06/01 00:00:00','YYYY/MM/DD HH24:MI:SS'), 2023/05/09 13:19:27 - Update Config Settings - FULL_RELOAD = (CASE WHEN 'Y' = 'Y' THEN 1 2023/05/09 13:19:27 - Update Config Settings - WHEN '2001-07-10 09:04:08' > '1900-01-01 00:00:00' THEN 1 2023/05/09 13:19:27 - Update Config Settings - ELSE 0 END), 2023/05/09 13:19:27 - Update Config Settings - DWH_DIM_PREV_START_DATE = CASE WHEN 'Y' = 'Y' THEN TO_TIMESTAMP('1900/01/01 00:00:00','YYYY/MM/DD HH24:MI:SS') 2023/05/09 13:19:27 - Update Config Settings - ELSE TO_TIMESTAMP('2023/05/09 13:19:19','YYYY/MM/DD HH24:MI:SS') END 2023/05/09 13:19:27 - Update Config Settings - 2023/05/09 13:19:27 - Update Config Settings - ERROR: error de sintaxis en o cerca de «0» Position: 114 2023/05/09 13:25:46 - Update Config Settings - ERROR (version 9.3.0.0-428, build 9.3.0.0-428 from 2022-04-12 04.56.25 by buildguy) : An error occurred executing this job entry : 2023/05/09 13:25:46 - Update Config Settings - Couldn't execute SQL: UPDATE DWH_CFG_SETTINGS 2023/05/09 13:25:46 - Update Config Settings - SET LANGUAGE_CODE_KEY = 1, 2023/05/09 13:25:46 - Update Config Settings - LANGUAGE_CODE = 'en', 2023/05/09 13:25:46 - Update Config Settings - CURRENCY_PRECISION = 0,0, 2023/05/09 13:25:46 - Update Config Settings - WEEK_START_DAY = 1, 2023/05/09 13:25:46 - Update Config Settings - WEEK_START_DAY_CHANGED = CASE WHEN 1 = 1 THEN 0 ELSE 1 END, 2023/05/09 13:25:46 - Update Config Settings - ENTITY_KEY = 5075791, 2023/05/09 13:25:46 - Update Config Settings - ENTITY_CHANGED = CASE WHEN 5075791 = 0 THEN 0 ELSE 1 END, 2023/05/09 13:25:46 - Update Config Settings - CURRENT_FISCAL_PERIOD_KEY = 5069135, 2023/05/09 13:25:46 - Update Config Settings - FISCAL_PERIOD_CHANGED = CASE WHEN 5069135 = 0 THEN 0 ELSE 1 END, 2023/05/09 13:25:46 - Update Config Settings - WEEKLY_SLICES = 1, 2023/05/09 13:25:46 - Update Config Settings - MONTHLY_SLICES = 1, 2023/05/09 13:25:46 - Update Config Settings - FISCAL_SLICES = 1, 2023/05/09 13:25:46 - Update Config Settings - ONE_SET_OF_FISCAL_PERIODS = 1, 2023/05/09 13:25:46 - Update Config Settings - DISABLE_RESOURCE_SECURITY = 0, 2023/05/09 13:25:46 - Update Config Settings - DISABLE_INVESTMENT_SECURITY = 0, 2023/05/09 13:25:46 - Update Config Settings - SINGLE_CURRENCY = 1, 2023/05/09 13:25:46 - Update Config Settings - DAILY_ROLLOVER_OCCURRED = CASE WHEN '2023/08/09 00:00:00' > '1900/01/01 00:00:00' THEN 1 ELSE 0 END, 2023/05/09 13:25:46 - Update Config Settings - WEEKLY_ROLLOVER_OCCURRED = CASE WHEN '2023/07/31 00:00:00' > '1900/01/01 00:00:00' THEN 1 ELSE 0 END, 2023/05/09 13:25:46 - Update Config Settings - MONTHLY_ROLLOVER_OCCURRED = CASE WHEN '2023/08/01 00:00:00' > '1900/01/01 00:00:00' THEN 1 ELSE 0 END, 2023/05/09 13:25:46 - Update Config Settings - FISCAL_ROLLOVER_OCCURRED = CASE WHEN '2023/06/01 00:00:00' > '1900/01/01 00:00:00' THEN 1 ELSE 0 END, 2023/05/09 13:25:46 - Update Config Settings - DAILY_ROLLOVER_DATE = TO_TIMESTAMP('2023/08/09 00:00:00','YYYY/MM/DD HH24:MI:SS'), 2023/05/09 13:25:46 - Update Config Settings - WEEKLY_ROLLOVER_DATE = TO_TIMESTAMP('2023/07/31 00:00:00','YYYY/MM/DD HH24:MI:SS'), 2023/05/09 13:25:46 - Update Config Settings - MONTHLY_ROLLOVER_DATE = TO_TIMESTAMP('2023/08/01 00:00:00','YYYY/MM/DD HH24:MI:SS'), 2023/05/09 13:25:46 - Update Config Settings - FISCAL_ROLLOVER_DATE = TO_TIMESTAMP('2023/06/01 00:00:00','YYYY/MM/DD HH24:MI:SS'), 2023/05/09 13:25:46 - Update Config Settings - FULL_RELOAD = (CASE WHEN 'Y' = 'Y' THEN 1 2023/05/09 13:25:46 - Update Config Settings - WHEN '2001-07-10 09:04:08' > '1900-01-01 00:00:00' THEN 1 2023/05/09 13:25:46 - Update Config Settings - ELSE 0 END), 2023/05/09 13:25:46 - Update Config Settings - DWH_DIM_PREV_START_DATE = CASE WHEN 'Y' = 'Y' THEN TO_TIMESTAMP('1900/01/01 00:00:00','YYYY/MM/DD HH24:MI:SS') 2023/05/09 13:25:46 - Update Config Settings - ELSE TO_TIMESTAMP('2023/05/09 13:25:40','YYYY/MM/DD HH24:MI:SS') END 2023/05/09 13:25:46 - Update Config Settings - 2023/05/09 13:25:46 - Update Config Settings - ERROR: error de sintaxis en o cerca de «0» Position: 114 2023/05/09 13:19:27 - Update Config Settings - ERROR (version 9.3.0.0-428, build 9.3.0.0-428 from 2022-04-12 04.56.25 by buildguy) : An error occurred executing this job entry : 2023/05/09 13:19:27 - Update Config Settings - Couldn't execute SQL: UPDATE DWH_CFG_SETTINGS 2023/05/09 13:19:27 - Update Config Settings - SET LANGUAGE_CODE_KEY = 1, 2023/05/09 13:19:27 - Update Config Settings - LANGUAGE_CODE = 'en', 2023/05/09 13:19:27 - Update Config Settings - CURRENCY_PRECISION = 0,0, 2023/05/09 13:19:27 - Update Config Settings - WEEK_START_DAY = 1, 2023/05/09 13:19:27 - Update Config Settings - WEEK_START_DAY_CHANGED = CASE WHEN 1 = 1 THEN 0 ELSE 1 END, 2023/05/09 13:19:27 - Update Config Settings - ENTITY_KEY = 5075791, 2023/05/09 13:19:27 - Update Config Settings - ENTITY_CHANGED = CASE WHEN 5075791 = 0 THEN 0 ELSE 1 END, 2023/05/09 13:19:27 - Update Config Settings - CURRENT_FISCAL_PERIOD_KEY = 5069135, 2023/05/09 13:19:27 - Update Config Settings - FISCAL_PERIOD_CHANGED = CASE WHEN 5069135 = 0 THEN 0 ELSE 1 END, 2023/05/09 13:19:27 - Update Config Settings - WEEKLY_SLICES = 1, 2023/05/09 13:19:27 - Update Config Settings - MONTHLY_SLICES = 1, 2023/05/09 13:19:27 - Update Config Settings - FISCAL_SLICES = 1, 2023/05/09 13:19:27 - Update Config Settings - ONE_SET_OF_FISCAL_PERIODS = 1, 2023/05/09 13:19:27 - Update Config Settings - DISABLE_RESOURCE_SECURITY = 0, 2023/05/09 13:19:27 - Update Config Settings - DISABLE_INVESTMENT_SECURITY = 0, 2023/05/09 13:19:27 - Update Config Settings - SINGLE_CURRENCY = 1, 2023/05/09 13:19:27 - Update Config Settings - DAILY_ROLLOVER_OCCURRED = CASE WHEN '2023/08/09 00:00:00' > '1900/01/01 00:00:00' THEN 1 ELSE 0 END, 2023/05/09 13:19:27 - Update Config Settings - WEEKLY_ROLLOVER_OCCURRED = CASE WHEN '2023/07/31 00:00:00' > '1900/01/01 00:00:00' THEN 1 ELSE 0 END, 2023/05/09 13:19:27 - Update Config Settings - MONTHLY_ROLLOVER_OCCURRED = CASE WHEN '2023/08/01 00:00:00' > '1900/01/01 00:00:00' THEN 1 ELSE 0 END, 2023/05/09 13:19:27 - Update Config Settings - FISCAL_ROLLOVER_OCCURRED = CASE WHEN '2023/06/01 00:00:00' > '1900/01/01 00:00:00' THEN 1 ELSE 0 END, 2023/05/09 13:19:27 - Update Config Settings - DAILY_ROLLOVER_DATE = TO_TIMESTAMP('2023/08/09 00:00:00','YYYY/MM/DD HH24:MI:SS'), 2023/05/09 13:19:27 - Update Config Settings - WEEKLY_ROLLOVER_DATE = TO_TIMESTAMP('2023/07/31 00:00:00','YYYY/MM/DD HH24:MI:SS'), 2023/05/09 13:19:27 - Update Config Settings - MONTHLY_ROLLOVER_DATE = TO_TIMESTAMP('2023/08/01 00:00:00','YYYY/MM/DD HH24:MI:SS'), 2023/05/09 13:19:27 - Update Config Settings - FISCAL_ROLLOVER_DATE = TO_TIMESTAMP('2023/06/01 00:00:00','YYYY/MM/DD HH24:MI:SS'), 2023/05/09 13:19:27 - Update Config Settings - FULL_RELOAD = (CASE WHEN 'Y' = 'Y' THEN 1 2023/05/09 13:19:27 - Update Config Settings - WHEN '2001-07-10 09:04:08' > '1900-01-01 00:00:00' THEN 1 2023/05/09 13:19:27 - Update Config Settings - ELSE 0 END), 2023/05/09 13:19:27 - Update Config Settings - DWH_DIM_PREV_START_DATE = CASE WHEN 'Y' = 'Y' THEN TO_TIMESTAMP('1900/01/01 00:00:00','YYYY/MM/DD HH24:MI:SS') 2023/05/09 13:19:27 - Update Config Settings - ELSE TO_TIMESTAMP('2023/05/09 13:19:19','YYYY/MM/DD HH24:MI:SS') END 2023/05/09 13:19:27 - Update Config Settings - 2023/05/09 13:19:27 - Update Config Settings - ERROR: error de sintaxis en o cerca de «0» Position: 114 2023/05/09 13:25:46 - Update Config Settings - ERROR (version 9.3.0.0-428, build 9.3.0.0-428 from 2022-04-12 04.56.25 by buildguy) : An error occurred executing this job entry : 2023/05/09 13:25:46 - Update Config Settings - Couldn't execute SQL: UPDATE DWH_CFG_SETTINGS 2023/05/09 13:25:46 - Update Config Settings - SET LANGUAGE_CODE_KEY = 1, 2023/05/09 13:25:46 - Update Config Settings - LANGUAGE_CODE = 'en', 2023/05/09 13:25:46 - Update Config Settings - CURRENCY_PRECISION = 0,0, 2023/05/09 13:25:46 - Update Config Settings - WEEK_START_DAY = 1, 2023/05/09 13:25:46 - Update Config Settings - WEEK_START_DAY_CHANGED = CASE WHEN 1 = 1 THEN 0 ELSE 1 END, 2023/05/09 13:25:46 - Update Config Settings - ENTITY_KEY = 5075791, 2023/05/09 13:25:46 - Update Config Settings - ENTITY_CHANGED = CASE WHEN 5075791 = 0 THEN 0 ELSE 1 END, 2023/05/09 13:25:46 - Update Config Settings - CURRENT_FISCAL_PERIOD_KEY = 5069135, 2023/05/09 13:25:46 - Update Config Settings - FISCAL_PERIOD_CHANGED = CASE WHEN 5069135 = 0 THEN 0 ELSE 1 END, 2023/05/09 13:25:46 - Update Config Settings - WEEKLY_SLICES = 1, 2023/05/09 13:25:46 - Update Config Settings - MONTHLY_SLICES = 1, 2023/05/09 13:25:46 - Update Config Settings - FISCAL_SLICES = 1, 2023/05/09 13:25:46 - Update Config Settings - ONE_SET_OF_FISCAL_PERIODS = 1, 2023/05/09 13:25:46 - Update Config Settings - DISABLE_RESOURCE_SECURITY = 0, 2023/05/09 13:25:46 - Update Config Settings - DISABLE_INVESTMENT_SECURITY = 0, 2023/05/09 13:25:46 - Update Config Settings - SINGLE_CURRENCY = 1, 2023/05/09 13:25:46 - Update Config Settings - DAILY_ROLLOVER_OCCURRED = CASE WHEN '2023/08/09 00:00:00' > '1900/01/01 00:00:00' THEN 1 ELSE 0 END, 2023/05/09 13:25:46 - Update Config Settings - WEEKLY_ROLLOVER_OCCURRED = CASE WHEN '2023/07/31 00:00:00' > '1900/01/01 00:00:00' THEN 1 ELSE 0 END, 2023/05/09 13:25:46 - Update Config Settings - MONTHLY_ROLLOVER_OCCURRED = CASE WHEN '2023/08/01 00:00:00' > '1900/01/01 00:00:00' THEN 1 ELSE 0 END, 2023/05/09 13:25:46 - Update Config Settings - FISCAL_ROLLOVER_OCCURRED = CASE WHEN '2023/06/01 00:00:00' > '1900/01/01 00:00:00' THEN 1 ELSE 0 END, 2023/05/09 13:25:46 - Update Config Settings - DAILY_ROLLOVER_DATE = TO_TIMESTAMP('2023/08/09 00:00:00','YYYY/MM/DD HH24:MI:SS'), 2023/05/09 13:25:46 - Update Config Settings - WEEKLY_ROLLOVER_DATE = TO_TIMESTAMP('2023/07/31 00:00:00','YYYY/MM/DD HH24:MI:SS'), 2023/05/09 13:25:46 - Update Config Settings - MONTHLY_ROLLOVER_DATE = TO_TIMESTAMP('2023/08/01 00:00:00','YYYY/MM/DD HH24:MI:SS'), 2023/05/09 13:25:46 - Update Config Settings - FISCAL_ROLLOVER_DATE = TO_TIMESTAMP('2023/06/01 00:00:00','YYYY/MM/DD HH24:MI:SS'), 2023/05/09 13:25:46 - Update Config Settings - FULL_RELOAD = (CASE WHEN 'Y' = 'Y' THEN 1 2023/05/09 13:25:46 - Update Config Settings - WHEN '2001-07-10 09:04:08' > '1900-01-01 00:00:00' THEN 1 2023/05/09 13:25:46 - Update Config Settings - ELSE 0 END), 2023/05/09 13:25:46 - Update Config Settings - DWH_DIM_PREV_START_DATE = CASE WHEN 'Y' = 'Y' THEN TO_TIMESTAMP('1900/01/01 00:00:00','YYYY/MM/DD HH24:MI:SS') 2023/05/09 13:25:46 - Update Config Settings - ELSE TO_TIMESTAMP('2023/05/09 13:25:40','YYYY/MM/DD HH24:MI:SS') END 2023/05/09 13:25:46 - Update Config Settings - 2023/05/09 13:25:46 - Update Config Settings - ERROR: error de sintaxis en o cerca de «0» Position: 114 2023/05/09 13:19:27 - Update Config Settings - ERROR (version 9.3.0.0-428, build 9.3.0.0-428 from 2022-04-12 04.56.25 by buildguy) : An error occurred executing this job entry : 2023/05/09 13:19:27 - Update Config Settings - Couldn't execute SQL: UPDATE DWH_CFG_SETTINGS 2023/05/09 13:19:27 - Update Config Settings - SET LANGUAGE_CODE_KEY = 1, 2023/05/09 13:19:27 - Update Config Settings - LANGUAGE_CODE = 'en', 2023/05/09 13:19:27 - Update Config Settings - CURRENCY_PRECISION = 0,0, 2023/05/09 13:19:27 - Update Config Settings - WEEK_START_DAY = 1, 2023/05/09 13:19:27 - Update Config Settings - WEEK_START_DAY_CHANGED = CASE WHEN 1 = 1 THEN 0 ELSE 1 END, 2023/05/09 13:19:27 - Update Config Settings - ENTITY_KEY = 5075791, 2023/05/09 13:19:27 - Update Config Settings - ENTITY_CHANGED = CASE WHEN 5075791 = 0 THEN 0 ELSE 1 END, 2023/05/09 13:19:27 - Update Config Settings - CURRENT_FISCAL_PERIOD_KEY = 5069135, 2023/05/09 13:19:27 - Update Config Settings - FISCAL_PERIOD_CHANGED = CASE WHEN 5069135 = 0 THEN 0 ELSE 1 END, 2023/05/09 13:19:27 - Update Config Settings - WEEKLY_SLICES = 1, 2023/05/09 13:19:27 - Update Config Settings - MONTHLY_SLICES = 1, 2023/05/09 13:19:27 - Update Config Settings - FISCAL_SLICES = 1, 2023/05/09 13:19:27 - Update Config Settings - ONE_SET_OF_FISCAL_PERIODS = 1, 2023/05/09 13:19:27 - Update Config Settings - DISABLE_RESOURCE_SECURITY = 0, 2023/05/09 13:19:27 - Update Config Settings - DISABLE_INVESTMENT_SECURITY = 0, 2023/05/09 13:19:27 - Update Config Settings - SINGLE_CURRENCY = 1, 2023/05/09 13:19:27 - Update Config Settings - DAILY_ROLLOVER_OCCURRED = CASE WHEN '2023/08/09 00:00:00' > '1900/01/01 00:00:00' THEN 1 ELSE 0 END, 2023/05/09 13:19:27 - Update Config Settings - WEEKLY_ROLLOVER_OCCURRED = CASE WHEN '2023/07/31 00:00:00' > '1900/01/01 00:00:00' THEN 1 ELSE 0 END, 2023/05/09 13:19:27 - Update Config Settings - MONTHLY_ROLLOVER_OCCURRED = CASE WHEN '2023/08/01 00:00:00' > '1900/01/01 00:00:00' THEN 1 ELSE 0 END, 2023/05/09 13:19:27 - Update Config Settings - FISCAL_ROLLOVER_OCCURRED = CASE WHEN '2023/06/01 00:00:00' > '1900/01/01 00:00:00' THEN 1 ELSE 0 END, 2023/05/09 13:19:27 - Update Config Settings - DAILY_ROLLOVER_DATE = TO_TIMESTAMP('2023/08/09 00:00:00','YYYY/MM/DD HH24:MI:SS'), 2023/05/09 13:19:27 - Update Config Settings - WEEKLY_ROLLOVER_DATE = TO_TIMESTAMP('2023/07/31 00:00:00','YYYY/MM/DD HH24:MI:SS'), 2023/05/09 13:19:27 - Update Config Settings - MONTHLY_ROLLOVER_DATE = TO_TIMESTAMP('2023/08/01 00:00:00','YYYY/MM/DD HH24:MI:SS'), 2023/05/09 13:19:27 - Update Config Settings - FISCAL_ROLLOVER_DATE = TO_TIMESTAMP('2023/06/01 00:00:00','YYYY/MM/DD HH24:MI:SS'), 2023/05/09 13:19:27 - Update Config Settings - FULL_RELOAD = (CASE WHEN 'Y' = 'Y' THEN 1 2023/05/09 13:19:27 - Update Config Settings - WHEN '2001-07-10 09:04:08' > '1900-01-01 00:00:00' THEN 1 2023/05/09 13:19:27 - Update Config Settings - ELSE 0 END), 2023/05/09 13:19:27 - Update Config Settings - DWH_DIM_PREV_START_DATE = CASE WHEN 'Y' = 'Y' THEN TO_TIMESTAMP('1900/01/01 00:00:00','YYYY/MM/DD HH24:MI:SS') 2023/05/09 13:19:27 - Update Config Settings - ELSE TO_TIMESTAMP('2023/05/09 13:19:19','YYYY/MM/DD HH24:MI:SS') END 2023/05/09 13:19:27 - Update Config Settings - 2023/05/09 13:19:27 - Update Config Settings - ERROR: error de sintaxis en o cerca de «0» Position: 114 2023/05/09 13:25:46 - Update Config Settings - ERROR (version 9.3.0.0-428, build 9.3.0.0-428 from 2022-04-12 04.56.25 by buildguy) : An error occurred executing this job entry : 2023/05/09 13:25:46 - Update Config Settings - Couldn't execute SQL: UPDATE DWH_CFG_SETTINGS 2023/05/09 13:25:46 - Update Config Settings - SET LANGUAGE_CODE_KEY = 1, 2023/05/09 13:25:46 - Update Config Settings - LANGUAGE_CODE = 'en', 2023/05/09 13:25:46 - Update Config Settings - CURRENCY_PRECISION = 0,0, 2023/05/09 13:25:46 - Update Config Settings - WEEK_START_DAY = 1, 2023/05/09 13:25:46 - Update Config Settings - WEEK_START_DAY_CHANGED = CASE WHEN 1 = 1 THEN 0 ELSE 1 END, 2023/05/09 13:25:46 - Update Config Settings - ENTITY_KEY = 5075791, 2023/05/09 13:25:46 - Update Config Settings - ENTITY_CHANGED = CASE WHEN 5075791 = 0 THEN 0 ELSE 1 END, 2023/05/09 13:25:46 - Update Config Settings - CURRENT_FISCAL_PERIOD_KEY = 5069135, 2023/05/09 13:25:46 - Update Config Settings - FISCAL_PERIOD_CHANGED = CASE WHEN 5069135 = 0 THEN 0 ELSE 1 END, 2023/05/09 13:25:46 - Update Config Settings - WEEKLY_SLICES = 1, 2023/05/09 13:25:46 - Update Config Settings - MONTHLY_SLICES = 1, 2023/05/09 13:25:46 - Update Config Settings - FISCAL_SLICES = 1, 2023/05/09 13:25:46 - Update Config Settings - ONE_SET_OF_FISCAL_PERIODS = 1, 2023/05/09 13:25:46 - Update Config Settings - DISABLE_RESOURCE_SECURITY = 0, 2023/05/09 13:25:46 - Update Config Settings - DISABLE_INVESTMENT_SECURITY = 0, 2023/05/09 13:25:46 - Update Config Settings - SINGLE_CURRENCY = 1, 2023/05/09 13:25:46 - Update Config Settings - DAILY_ROLLOVER_OCCURRED = CASE WHEN '2023/08/09 00:00:00' > '1900/01/01 00:00:00' THEN 1 ELSE 0 END, 2023/05/09 13:25:46 - Update Config Settings - WEEKLY_ROLLOVER_OCCURRED = CASE WHEN '2023/07/31 00:00:00' > '1900/01/01 00:00:00' THEN 1 ELSE 0 END, 2023/05/09 13:25:46 - Update Config Settings - MONTHLY_ROLLOVER_OCCURRED = CASE WHEN '2023/08/01 00:00:00' > '1900/01/01 00:00:00' THEN 1 ELSE 0 END, 2023/05/09 13:25:46 - Update Config Settings - FISCAL_ROLLOVER_OCCURRED = CASE WHEN '2023/06/01 00:00:00' > '1900/01/01 00:00:00' THEN 1 ELSE 0 END, 2023/05/09 13:25:46 - Update Config Settings - DAILY_ROLLOVER_DATE = TO_TIMESTAMP('2023/08/09 00:00:00','YYYY/MM/DD HH24:MI:SS'), 2023/05/09 13:25:46 - Update Config Settings - WEEKLY_ROLLOVER_DATE = TO_TIMESTAMP('2023/07/31 00:00:00','YYYY/MM/DD HH24:MI:SS'), 2023/05/09 13:25:46 - Update Config Settings - MONTHLY_ROLLOVER_DATE = TO_TIMESTAMP('2023/08/01 00:00:00','YYYY/MM/DD HH24:MI:SS'), 2023/05/09 13:25:46 - Update Config Settings - FISCAL_ROLLOVER_DATE = TO_TIMESTAMP('2023/06/01 00:00:00','YYYY/MM/DD HH24:MI:SS'), 2023/05/09 13:25:46 - Update Config Settings - FULL_RELOAD = (CASE WHEN 'Y' = 'Y' THEN 1 2023/05/09 13:25:46 - Update Config Settings - WHEN '2001-07-10 09:04:08' > '1900-01-01 00:00:00' THEN 1 2023/05/09 13:25:46 - Update Config Settings - ELSE 0 END), 2023/05/09 13:25:46 - Update Config Settings - DWH_DIM_PREV_START_DATE = CASE WHEN 'Y' = 'Y' THEN TO_TIMESTAMP('1900/01/01 00:00:00','YYYY/MM/DD HH24:MI:SS') 2023/05/09 13:25:46 - Update Config Settings - ELSE TO_TIMESTAMP('2023/05/09 13:25:40','YYYY/MM/DD HH24:MI:SS') END 2023/05/09 13:25:46 - Update Config Settings - 2023/05/09 13:25:46 - Update Config Settings - ERROR: error de sintaxis en o cerca de «0» Position: 114 null INFO 2023-05-09 13:35:51,760 [Dispatch Load Data Warehouse : bg@DESKTOP-L4FIFVN (tenant=clarity)] dwh.event (clarity:admin:5281604__09BB438E-A0A5-4C80-B087-A1969D9B6C7E:Load Data Warehouse) Job Parameters INFO 2023-05-09 13:35:51,760 [Dispatch Load Data Warehouse : bg@DESKTOP-L4FIFVN (tenant=clarity)] dwh.event (clarity:admin:5281604__09BB438E-A0A5-4C80-B087-A1969D9B6C7E:Load Data Warehouse) SRC_DATABASE_URL: jdbc:postgresql://localhost:5432/ppmdb INFO 2023-05-09 13:35:51,760 [Dispatch Load Data Warehouse : bg@DESKTOP-L4FIFVN (tenant=clarity)] dwh.event (clarity:admin:5281604__09BB438E-A0A5-4C80-B087-A1969D9B6C7E:Load Data Warehouse) SRC_DATABASE_CLASS: org.postgresql.Driver INFO 2023-05-09 13:35:51,760 [Dispatch Load Data Warehouse : bg@DESKTOP-L4FIFVN (tenant=clarity)] dwh.event (clarity:admin:5281604__09BB438E-A0A5-4C80-B087-A1969D9B6C7E:Load Data Warehouse) SRC_DATABASE_USER: ppmdb INFO 2023-05-09 13:35:51,760 [Dispatch Load Data Warehouse : bg@DESKTOP-L4FIFVN (tenant=clarity)] dwh.event (clarity:admin:5281604__09BB438E-A0A5-4C80-B087-A1969D9B6C7E:Load Data Warehouse) TGT_DATABASE_URL: jdbc:postgresql://localhost:5432/dwhdb INFO 2023-05-09 13:35:51,760 [Dispatch Load Data Warehouse : bg@DESKTOP-L4FIFVN (tenant=clarity)] dwh.event (clarity:admin:5281604__09BB438E-A0A5-4C80-B087-A1969D9B6C7E:Load Data Warehouse) TGT_DATABASE_CLASS: org.postgresql.Driver INFO 2023-05-09 13:35:51,760 [Dispatch Load Data Warehouse : bg@DESKTOP-L4FIFVN (tenant=clarity)] dwh.event (clarity:admin:5281604__09BB438E-A0A5-4C80-B087-A1969D9B6C7E:Load Data Warehouse) TGT_DATABASE_USER: dwhdb INFO 2023-05-09 13:35:51,760 [Dispatch Load Data Warehouse : bg@DESKTOP-L4FIFVN (tenant=clarity)] dwh.event (clarity:admin:5281604__09BB438E-A0A5-4C80-B087-A1969D9B6C7E:Load Data Warehouse) CLARITY_DB_TYPE: postgres INFO 2023-05-09 13:35:51,760 [Dispatch Load Data Warehouse : bg@DESKTOP-L4FIFVN (tenant=clarity)] dwh.event (clarity:admin:5281604__09BB438E-A0A5-4C80-B087-A1969D9B6C7E:Load Data Warehouse) DWH_DB_TYPE: postgres INFO 2023-05-09 13:35:51,760 [Dispatch Load Data Warehouse : bg@DESKTOP-L4FIFVN (tenant=clarity)] dwh.event (clarity:admin:5281604__09BB438E-A0A5-4C80-B087-A1969D9B6C7E:Load Data Warehouse) SRC_DBNAME: ppmdb INFO 2023-05-09 13:35:51,760 [Dispatch Load Data Warehouse : bg@DESKTOP-L4FIFVN (tenant=clarity)] dwh.event (clarity:admin:5281604__09BB438E-A0A5-4C80-B087-A1969D9B6C7E:Load Data Warehouse) DB_LINK: PPMDBLINK INFO 2023-05-09 13:35:51,777 [Thread-222] dwh.event (none:none:none:none) dwh_etl_master - Start of job execution INFO 2023-05-09 13:35:52,489 [dwh_check_slice_info_pg - Write Time Info to Log] dwh.event (none:none:none:none) Write Time Info to Log - ------------> Linenr 1------------------------------ Date Time Values application_time = 2023-05-09 13:35:52.166-05 ppm_time_minus_15 = 2023-05-09 13:35:37.323-05 ppm_time_plus_15 = 2023-05-09 13:36:07.323-05 dwh_time = 2023-05-09 13:35:52 dwh_time_minus_15 = 2023-05-09 13:35:37.323-05 dwh_time_plus_15 = 2023-05-09 13:36:07.323-05 ==================== ERROR 2023-05-09 13:36:03,199 [dwh_load_settings_check_pg UUID: 6e3978bf-dca8-4046-8edf-f257ba1e855a] dwh.event (none:none:none:none) Update Config Settings - An error occurred executing this job entry : Couldn't execute SQL: UPDATE DWH_CFG_SETTINGS SET LANGUAGE_CODE_KEY = 1, LANGUAGE_CODE = 'en', CURRENCY_PRECISION = 0,0, WEEK_START_DAY = 1, WEEK_START_DAY_CHANGED = CASE WHEN 1 = 1 THEN 0 ELSE 1 END, ENTITY_KEY = 5075791, ENTITY_CHANGED = CASE WHEN 5075791 = 5075791 THEN 0 ELSE 1 END, CURRENT_FISCAL_PERIOD_KEY = 5069135, FISCAL_PERIOD_CHANGED = CASE WHEN 5069135 = 5069135 THEN 0 ELSE 1 END, WEEKLY_SLICES = 1, MONTHLY_SLICES = 1, FISCAL_SLICES = 1, ONE_SET_OF_FISCAL_PERIODS = 1, DISABLE_RESOURCE_SECURITY = 0, DISABLE_INVESTMENT_SECURITY = 0, SINGLE_CURRENCY = 1, DAILY_ROLLOVER_OCCURRED = CASE WHEN '2023/08/09 00:00:00' > '2023/08/09 00:00:00' THEN 1 ELSE 0 END, WEEKLY_ROLLOVER_OCCURRED = CASE WHEN '2023/07/31 00:00:00' > '2023/07/31 00:00:00' THEN 1 ELSE 0 END, MONTHLY_ROLLOVER_OCCURRED = CASE WHEN '2023/08/01 00:00:00' > '2023/08/01 00:00:00' THEN 1 ELSE 0 END, FISCAL_ROLLOVER_OCCURRED = CASE WHEN '2023/06/01 00:00:00' > '2023/06/01 00:00:00' THEN 1 ELSE 0 END, DAILY_ROLLOVER_DATE = TO_TIMESTAMP('2023/08/09 00:00:00','YYYY/MM/DD HH24:MI:SS'), WEEKLY_ROLLOVER_DATE = TO_TIMESTAMP('2023/07/31 00:00:00','YYYY/MM/DD HH24:MI:SS'), MONTHLY_ROLLOVER_DATE = TO_TIMESTAMP('2023/08/01 00:00:00','YYYY/MM/DD HH24:MI:SS'), FISCAL_ROLLOVER_DATE = TO_TIMESTAMP('2023/06/01 00:00:00','YYYY/MM/DD HH24:MI:SS'), FULL_RELOAD = (CASE WHEN 'Y' = 'Y' THEN 1 WHEN '2001-07-10 09:04:08' > '1900-01-01 00:00:00' THEN 1 ELSE 0 END), DWH_DIM_PREV_START_DATE = CASE WHEN 'Y' = 'Y' THEN TO_TIMESTAMP('1900/01/01 00:00:00','YYYY/MM/DD HH24:MI:SS') ELSE TO_TIMESTAMP('2023/05/09 13:36:00','YYYY/MM/DD HH24:MI:SS') END ERROR: error de sintaxis en o cerca de «0» Position: 114 INFO 2023-05-09 13:36:03,245 [Thread-222] dwh.event (none:none:none:none) dwh_etl_master - Job execution finished ERROR 2023-05-09 13:36:03,403 [Dispatch Load Data Warehouse : bg@DESKTOP-L4FIFVN (tenant=clarity)] dwh.event (clarity:admin:5281604__09BB438E-A0A5-4C80-B087-A1969D9B6C7E:Load Data Warehouse) ETL Job Failed. Log details below: 2023/05/09 13:14:43 - Write Time Info to Log.0 - 2023/05/09 13:14:43 - Write Time Info to Log.0 - ------------> Linenr 1------------------------------ 2023/05/09 13:14:43 - Write Time Info to Log.0 - Date Time Values 2023/05/09 13:14:43 - Write Time Info to Log.0 - 2023/05/09 13:14:43 - Write Time Info to Log.0 - application_time = 2023-05-09 13:14:43.262-05 2023/05/09 13:14:43 - Write Time Info to Log.0 - ppm_time_minus_15 = 2023-05-09 13:14:28.457-05 2023/05/09 13:14:43 - Write Time Info to Log.0 - ppm_time_plus_15 = 2023-05-09 13:14:58.457-05 2023/05/09 13:14:43 - Write Time Info to Log.0 - dwh_time = 2023-05-09 13:14:43 2023/05/09 13:14:43 - Write Time Info to Log.0 - dwh_time_minus_15 = 2023-05-09 13:14:28.457-05 2023/05/09 13:14:43 - Write Time Info to Log.0 - dwh_time_plus_15 = 2023-05-09 13:14:58.457-05 2023/05/09 13:14:43 - Write Time Info to Log.0 - 2023/05/09 13:14:43 - Write Time Info to Log.0 - ==================== 2023/05/09 13:14:43 - Abort job - ERROR (version 9.3.0.0-428, build 9.3.0.0-428 from 2022-04-12 04.56.25 by buildguy) : At least 1 checkbox for 'Include Period Data' must be checked under System Options for the Data Warehouse. 2023/05/09 13:18:53 - Write Time Info to Log.0 - 2023/05/09 13:18:53 - Write Time Info to Log.0 - ------------> Linenr 1------------------------------ 2023/05/09 13:18:53 - Write Time Info to Log.0 - Date Time Values 2023/05/09 13:18:53 - Write Time Info to Log.0 - 2023/05/09 13:18:53 - Write Time Info to Log.0 - application_time = 2023-05-09 13:18:53.206-05 2023/05/09 13:18:53 - Write Time Info to Log.0 - ppm_time_minus_15 = 2023-05-09 13:18:38.401-05 2023/05/09 13:18:53 - Write Time Info to Log.0 - ppm_time_plus_15 = 2023-05-09 13:19:08.401-05 2023/05/09 13:18:53 - Write Time Info to Log.0 - dwh_time = 2023-05-09 13:18:53 2023/05/09 13:18:53 - Write Time Info to Log.0 - dwh_time_minus_15 = 2023-05-09 13:18:38.401-05 2023/05/09 13:18:53 - Write Time Info to Log.0 - dwh_time_plus_15 = 2023-05-09 13:19:08.401-05 2023/05/09 13:18:53 - Write Time Info to Log.0 - 2023/05/09 13:18:53 - Write Time Info to Log.0 - ==================== 2023/05/09 13:19:27 - Update Config Settings - ERROR (version 9.3.0.0-428, build 9.3.0.0-428 from 2022-04-12 04.56.25 by buildguy) : An error occurred executing this job entry : 2023/05/09 13:19:27 - Update Config Settings - Couldn't execute SQL: UPDATE DWH_CFG_SETTINGS 2023/05/09 13:19:27 - Update Config Settings - SET LANGUAGE_CODE_KEY = 1, 2023/05/09 13:19:27 - Update Config Settings - LANGUAGE_CODE = 'en', 2023/05/09 13:19:27 - Update Config Settings - CURRENCY_PRECISION = 0,0, 2023/05/09 13:19:27 - Update Config Settings - WEEK_START_DAY = 1, 2023/05/09 13:19:27 - Update Config Settings - WEEK_START_DAY_CHANGED = CASE WHEN 1 = 1 THEN 0 ELSE 1 END, 2023/05/09 13:19:27 - Update Config Settings - ENTITY_KEY = 5075791, 2023/05/09 13:19:27 - Update Config Settings - ENTITY_CHANGED = CASE WHEN 5075791 = 0 THEN 0 ELSE 1 END, 2023/05/09 13:19:27 - Update Config Settings - CURRENT_FISCAL_PERIOD_KEY = 5069135, 2023/05/09 13:19:27 - Update Config Settings - FISCAL_PERIOD_CHANGED = CASE WHEN 5069135 = 0 THEN 0 ELSE 1 END, 2023/05/09 13:19:27 - Update Config Settings - WEEKLY_SLICES = 1, 2023/05/09 13:19:27 - Update Config Settings - MONTHLY_SLICES = 1, 2023/05/09 13:19:27 - Update Config Settings - FISCAL_SLICES = 1, 2023/05/09 13:19:27 - Update Config Settings - ONE_SET_OF_FISCAL_PERIODS = 1, 2023/05/09 13:19:27 - Update Config Settings - DISABLE_RESOURCE_SECURITY = 0, 2023/05/09 13:19:27 - Update Config Settings - DISABLE_INVESTMENT_SECURITY = 0, 2023/05/09 13:19:27 - Update Config Settings - SINGLE_CURRENCY = 1, 2023/05/09 13:19:27 - Update Config Settings - DAILY_ROLLOVER_OCCURRED = CASE WHEN '2023/08/09 00:00:00' > '1900/01/01 00:00:00' THEN 1 ELSE 0 END, 2023/05/09 13:19:27 - Update Config Settings - WEEKLY_ROLLOVER_OCCURRED = CASE WHEN '2023/07/31 00:00:00' > '1900/01/01 00:00:00' THEN 1 ELSE 0 END, 2023/05/09 13:19:27 - Update Config Settings - MONTHLY_ROLLOVER_OCCURRED = CASE WHEN '2023/08/01 00:00:00' > '1900/01/01 00:00:00' THEN 1 ELSE 0 END, 2023/05/09 13:19:27 - Update Config Settings - FISCAL_ROLLOVER_OCCURRED = CASE WHEN '2023/06/01 00:00:00' > '1900/01/01 00:00:00' THEN 1 ELSE 0 END, 2023/05/09 13:19:27 - Update Config Settings - DAILY_ROLLOVER_DATE = TO_TIMESTAMP('2023/08/09 00:00:00','YYYY/MM/DD HH24:MI:SS'), 2023/05/09 13:19:27 - Update Config Settings - WEEKLY_ROLLOVER_DATE = TO_TIMESTAMP('2023/07/31 00:00:00','YYYY/MM/DD HH24:MI:SS'), 2023/05/09 13:19:27 - Update Config Settings - MONTHLY_ROLLOVER_DATE = TO_TIMESTAMP('2023/08/01 00:00:00','YYYY/MM/DD HH24:MI:SS'), 2023/05/09 13:19:27 - Update Config Settings - FISCAL_ROLLOVER_DATE = TO_TIMESTAMP('2023/06/01 00:00:00','YYYY/MM/DD HH24:MI:SS'), 2023/05/09 13:19:27 - Update Config Settings - FULL_RELOAD = (CASE WHEN 'Y' = 'Y' THEN 1 2023/05/09 13:19:27 - Update Config Settings - WHEN '2001-07-10 09:04:08' > '1900-01-01 00:00:00' THEN 1 2023/05/09 13:19:27 - Update Config Settings - ELSE 0 END), 2023/05/09 13:19:27 - Update Config Settings - DWH_DIM_PREV_START_DATE = CASE WHEN 'Y' = 'Y' THEN TO_TIMESTAMP('1900/01/01 00:00:00','YYYY/MM/DD HH24:MI:SS') 2023/05/09 13:19:27 - Update Config Settings - ELSE TO_TIMESTAMP('2023/05/09 13:19:19','YYYY/MM/DD HH24:MI:SS') END 2023/05/09 13:19:27 - Update Config Settings - 2023/05/09 13:19:27 - Update Config Settings - ERROR: error de sintaxis en o cerca de «0» Position: 114 2023/05/09 13:25:11 - Write Time Info to Log.0 - 2023/05/09 13:25:11 - Write Time Info to Log.0 - ------------> Linenr 1------------------------------ 2023/05/09 13:25:11 - Write Time Info to Log.0 - Date Time Values 2023/05/09 13:25:11 - Write Time Info to Log.0 - 2023/05/09 13:25:11 - Write Time Info to Log.0 - application_time = 2023-05-09 13:25:11.544-05 2023/05/09 13:25:11 - Write Time Info to Log.0 - ppm_time_minus_15 = 2023-05-09 13:24:56.704-05 2023/05/09 13:25:11 - Write Time Info to Log.0 - ppm_time_plus_15 = 2023-05-09 13:25:26.704-05 2023/05/09 13:25:11 - Write Time Info to Log.0 - dwh_time = 2023-05-09 13:25:11 2023/05/09 13:25:11 - Write Time Info to Log.0 - dwh_time_minus_15 = 2023-05-09 13:24:56.704-05 2023/05/09 13:25:11 - Write Time Info to Log.0 - dwh_time_plus_15 = 2023-05-09 13:25:26.704-05 2023/05/09 13:25:11 - Write Time Info to Log.0 - 2023/05/09 13:25:11 - Write Time Info to Log.0 - ==================== 2023/05/09 13:25:46 - Update Config Settings - ERROR (version 9.3.0.0-428, build 9.3.0.0-428 from 2022-04-12 04.56.25 by buildguy) : An error occurred executing this job entry : 2023/05/09 13:25:46 - Update Config Settings - Couldn't execute SQL: UPDATE DWH_CFG_SETTINGS 2023/05/09 13:25:46 - Update Config Settings - SET LANGUAGE_CODE_KEY = 1, 2023/05/09 13:25:46 - Update Config Settings - LANGUAGE_CODE = 'en', 2023/05/09 13:25:46 - Update Config Settings - CURRENCY_PRECISION = 0,0, 2023/05/09 13:25:46 - Update Config Settings - WEEK_START_DAY = 1, 2023/05/09 13:25:46 - Update Config Settings - WEEK_START_DAY_CHANGED = CASE WHEN 1 = 1 THEN 0 ELSE 1 END, 2023/05/09 13:25:46 - Update Config Settings - ENTITY_KEY = 5075791, 2023/05/09 13:25:46 - Update Config Settings - ENTITY_CHANGED = CASE WHEN 5075791 = 0 THEN 0 ELSE 1 END, 2023/05/09 13:25:46 - Update Config Settings - CURRENT_FISCAL_PERIOD_KEY = 5069135, 2023/05/09 13:25:46 - Update Config Settings - FISCAL_PERIOD_CHANGED = CASE WHEN 5069135 = 0 THEN 0 ELSE 1 END, 2023/05/09 13:25:46 - Update Config Settings - WEEKLY_SLICES = 1, 2023/05/09 13:25:46 - Update Config Settings - MONTHLY_SLICES = 1, 2023/05/09 13:25:46 - Update Config Settings - FISCAL_SLICES = 1, 2023/05/09 13:25:46 - Update Config Settings - ONE_SET_OF_FISCAL_PERIODS = 1, 2023/05/09 13:25:46 - Update Config Settings - DISABLE_RESOURCE_SECURITY = 0, 2023/05/09 13:25:46 - Update Config Settings - DISABLE_INVESTMENT_SECURITY = 0, 2023/05/09 13:25:46 - Update Config Settings - SINGLE_CURRENCY = 1, 2023/05/09 13:25:46 - Update Config Settings - DAILY_ROLLOVER_OCCURRED = CASE WHEN '2023/08/09 00:00:00' > '1900/01/01 00:00:00' THEN 1 ELSE 0 END, 2023/05/09 13:25:46 - Update Config Settings - WEEKLY_ROLLOVER_OCCURRED = CASE WHEN '2023/07/31 00:00:00' > '1900/01/01 00:00:00' THEN 1 ELSE 0 END, 2023/05/09 13:25:46 - Update Config Settings - MONTHLY_ROLLOVER_OCCURRED = CASE WHEN '2023/08/01 00:00:00' > '1900/01/01 00:00:00' THEN 1 ELSE 0 END, 2023/05/09 13:25:46 - Update Config Settings - FISCAL_ROLLOVER_OCCURRED = CASE WHEN '2023/06/01 00:00:00' > '1900/01/01 00:00:00' THEN 1 ELSE 0 END, 2023/05/09 13:25:46 - Update Config Settings - DAILY_ROLLOVER_DATE = TO_TIMESTAMP('2023/08/09 00:00:00','YYYY/MM/DD HH24:MI:SS'), 2023/05/09 13:25:46 - Update Config Settings - WEEKLY_ROLLOVER_DATE = TO_TIMESTAMP('2023/07/31 00:00:00','YYYY/MM/DD HH24:MI:SS'), 2023/05/09 13:25:46 - Update Config Settings - MONTHLY_ROLLOVER_DATE = TO_TIMESTAMP('2023/08/01 00:00:00','YYYY/MM/DD HH24:MI:SS'), 2023/05/09 13:25:46 - Update Config Settings - FISCAL_ROLLOVER_DATE = TO_TIMESTAMP('2023/06/01 00:00:00','YYYY/MM/DD HH24:MI:SS'), 2023/05/09 13:25:46 - Update Config Settings - FULL_RELOAD = (CASE WHEN 'Y' = 'Y' THEN 1 2023/05/09 13:25:46 - Update Config Settings - WHEN '2001-07-10 09:04:08' > '1900-01-01 00:00:00' THEN 1 2023/05/09 13:25:46 - Update Config Settings - ELSE 0 END), 2023/05/09 13:25:46 - Update Config Settings - DWH_DIM_PREV_START_DATE = CASE WHEN 'Y' = 'Y' THEN TO_TIMESTAMP('1900/01/01 00:00:00','YYYY/MM/DD HH24:MI:SS') 2023/05/09 13:25:46 - Update Config Settings - ELSE TO_TIMESTAMP('2023/05/09 13:25:40','YYYY/MM/DD HH24:MI:SS') END 2023/05/09 13:25:46 - Update Config Settings - 2023/05/09 13:25:46 - Update Config Settings - ERROR: error de sintaxis en o cerca de «0» Position: 114 2023/05/09 13:35:52 - Write Time Info to Log.0 - 2023/05/09 13:35:52 - Write Time Info to Log.0 - ------------> Linenr 1------------------------------ 2023/05/09 13:35:52 - Write Time Info to Log.0 - Date Time Values 2023/05/09 13:35:52 - Write Time Info to Log.0 - 2023/05/09 13:35:52 - Write Time Info to Log.0 - application_time = 2023-05-09 13:35:52.166-05 2023/05/09 13:35:52 - Write Time Info to Log.0 - ppm_time_minus_15 = 2023-05-09 13:35:37.323-05 2023/05/09 13:35:52 - Write Time Info to Log.0 - ppm_time_plus_15 = 2023-05-09 13:36:07.323-05 2023/05/09 13:35:52 - Write Time Info to Log.0 - dwh_time = 2023-05-09 13:35:52 2023/05/09 13:35:52 - Write Time Info to Log.0 - dwh_time_minus_15 = 2023-05-09 13:35:37.323-05 2023/05/09 13:35:52 - Write Time Info to Log.0 - dwh_time_plus_15 = 2023-05-09 13:36:07.323-05 2023/05/09 13:35:52 - Write Time Info to Log.0 - 2023/05/09 13:35:52 - Write Time Info to Log.0 - ==================== 2023/05/09 13:36:03 - Update Config Settings - ERROR (version 9.3.0.0-428, build 9.3.0.0-428 from 2022-04-12 04.56.25 by buildguy) : An error occurred executing this job entry : 2023/05/09 13:36:03 - Update Config Settings - Couldn't execute SQL: UPDATE DWH_CFG_SETTINGS 2023/05/09 13:36:03 - Update Config Settings - SET LANGUAGE_CODE_KEY = 1, 2023/05/09 13:36:03 - Update Config Settings - LANGUAGE_CODE = 'en', 2023/05/09 13:36:03 - Update Config Settings - CURRENCY_PRECISION = 0,0, 2023/05/09 13:36:03 - Update Config Settings - WEEK_START_DAY = 1, 2023/05/09 13:36:03 - Update Config Settings - WEEK_START_DAY_CHANGED = CASE WHEN 1 = 1 THEN 0 ELSE 1 END, 2023/05/09 13:36:03 - Update Config Settings - ENTITY_KEY = 5075791, 2023/05/09 13:36:03 - Update Config Settings - ENTITY_CHANGED = CASE WHEN 5075791 = 5075791 THEN 0 ELSE 1 END, 2023/05/09 13:36:03 - Update Config Settings - CURRENT_FISCAL_PERIOD_KEY = 5069135, 2023/05/09 13:36:03 - Update Config Settings - FISCAL_PERIOD_CHANGED = CASE WHEN 5069135 = 5069135 THEN 0 ELSE 1 END, 2023/05/09 13:36:03 - Update Config Settings - WEEKLY_SLICES = 1, 2023/05/09 13:36:03 - Update Config Settings - MONTHLY_SLICES = 1, 2023/05/09 13:36:03 - Update Config Settings - FISCAL_SLICES = 1, 2023/05/09 13:36:03 - Update Config Settings - ONE_SET_OF_FISCAL_PERIODS = 1, 2023/05/09 13:36:03 - Update Config Settings - DISABLE_RESOURCE_SECURITY = 0, 2023/05/09 13:36:03 - Update Config Settings - DISABLE_INVESTMENT_SECURITY = 0, 2023/05/09 13:36:03 - Update Config Settings - SINGLE_CURRENCY = 1, 2023/05/09 13:36:03 - Update Config Settings - DAILY_ROLLOVER_OCCURRED = CASE WHEN '2023/08/09 00:00:00' > '2023/08/09 00:00:00' THEN 1 ELSE 0 END, 2023/05/09 13:36:03 - Update Config Settings - WEEKLY_ROLLOVER_OCCURRED = CASE WHEN '2023/07/31 00:00:00' > '2023/07/31 00:00:00' THEN 1 ELSE 0 END, 2023/05/09 13:36:03 - Update Config Settings - MONTHLY_ROLLOVER_OCCURRED = CASE WHEN '2023/08/01 00:00:00' > '2023/08/01 00:00:00' THEN 1 ELSE 0 END, 2023/05/09 13:36:03 - Update Config Settings - FISCAL_ROLLOVER_OCCURRED = CASE WHEN '2023/06/01 00:00:00' > '2023/06/01 00:00:00' THEN 1 ELSE 0 END, 2023/05/09 13:36:03 - Update Config Settings - DAILY_ROLLOVER_DATE = TO_TIMESTAMP('2023/08/09 00:00:00','YYYY/MM/DD HH24:MI:SS'), 2023/05/09 13:36:03 - Update Config Settings - WEEKLY_ROLLOVER_DATE = TO_TIMESTAMP('2023/07/31 00:00:00','YYYY/MM/DD HH24:MI:SS'), 2023/05/09 13:36:03 - Update Config Settings - MONTHLY_ROLLOVER_DATE = TO_TIMESTAMP('2023/08/01 00:00:00','YYYY/MM/DD HH24:MI:SS'), 2023/05/09 13:36:03 - Update Config Settings - FISCAL_ROLLOVER_DATE = TO_TIMESTAMP('2023/06/01 00:00:00','YYYY/MM/DD HH24:MI:SS'), 2023/05/09 13:36:03 - Update Config Settings - FULL_RELOAD = (CASE WHEN 'Y' = 'Y' THEN 1 2023/05/09 13:36:03 - Update Config Settings - WHEN '2001-07-10 09:04:08' > '1900-01-01 00:00:00' THEN 1 2023/05/09 13:36:03 - Update Config Settings - ELSE 0 END), 2023/05/09 13:36:03 - Update Config Settings - DWH_DIM_PREV_START_DATE = CASE WHEN 'Y' = 'Y' THEN TO_TIMESTAMP('1900/01/01 00:00:00','YYYY/MM/DD HH24:MI:SS') 2023/05/09 13:36:03 - Update Config Settings - ELSE TO_TIMESTAMP('2023/05/09 13:36:00','YYYY/MM/DD HH24:MI:SS') END 2023/05/09 13:36:03 - Update Config Settings - 2023/05/09 13:36:03 - Update Config Settings - ERROR: error de sintaxis en o cerca de «0» Position: 114 2023/05/09 13:19:27 - Update Config Settings - ERROR (version 9.3.0.0-428, build 9.3.0.0-428 from 2022-04-12 04.56.25 by buildguy) : An error occurred executing this job entry : 2023/05/09 13:19:27 - Update Config Settings - Couldn't execute SQL: UPDATE DWH_CFG_SETTINGS 2023/05/09 13:19:27 - Update Config Settings - SET LANGUAGE_CODE_KEY = 1, 2023/05/09 13:19:27 - Update Config Settings - LANGUAGE_CODE = 'en', 2023/05/09 13:19:27 - Update Config Settings - CURRENCY_PRECISION = 0,0, 2023/05/09 13:19:27 - Update Config Settings - WEEK_START_DAY = 1, 2023/05/09 13:19:27 - Update Config Settings - WEEK_START_DAY_CHANGED = CASE WHEN 1 = 1 THEN 0 ELSE 1 END, 2023/05/09 13:19:27 - Update Config Settings - ENTITY_KEY = 5075791, 2023/05/09 13:19:27 - Update Config Settings - ENTITY_CHANGED = CASE WHEN 5075791 = 0 THEN 0 ELSE 1 END, 2023/05/09 13:19:27 - Update Config Settings - CURRENT_FISCAL_PERIOD_KEY = 5069135, 2023/05/09 13:19:27 - Update Config Settings - FISCAL_PERIOD_CHANGED = CASE WHEN 5069135 = 0 THEN 0 ELSE 1 END, 2023/05/09 13:19:27 - Update Config Settings - WEEKLY_SLICES = 1, 2023/05/09 13:19:27 - Update Config Settings - MONTHLY_SLICES = 1, 2023/05/09 13:19:27 - Update Config Settings - FISCAL_SLICES = 1, 2023/05/09 13:19:27 - Update Config Settings - ONE_SET_OF_FISCAL_PERIODS = 1, 2023/05/09 13:19:27 - Update Config Settings - DISABLE_RESOURCE_SECURITY = 0, 2023/05/09 13:19:27 - Update Config Settings - DISABLE_INVESTMENT_SECURITY = 0, 2023/05/09 13:19:27 - Update Config Settings - SINGLE_CURRENCY = 1, 2023/05/09 13:19:27 - Update Config Settings - DAILY_ROLLOVER_OCCURRED = CASE WHEN '2023/08/09 00:00:00' > '1900/01/01 00:00:00' THEN 1 ELSE 0 END, 2023/05/09 13:19:27 - Update Config Settings - WEEKLY_ROLLOVER_OCCURRED = CASE WHEN '2023/07/31 00:00:00' > '1900/01/01 00:00:00' THEN 1 ELSE 0 END, 2023/05/09 13:19:27 - Update Config Settings - MONTHLY_ROLLOVER_OCCURRED = CASE WHEN '2023/08/01 00:00:00' > '1900/01/01 00:00:00' THEN 1 ELSE 0 END, 2023/05/09 13:19:27 - Update Config Settings - FISCAL_ROLLOVER_OCCURRED = CASE WHEN '2023/06/01 00:00:00' > '1900/01/01 00:00:00' THEN 1 ELSE 0 END, 2023/05/09 13:19:27 - Update Config Settings - DAILY_ROLLOVER_DATE = TO_TIMESTAMP('2023/08/09 00:00:00','YYYY/MM/DD HH24:MI:SS'), 2023/05/09 13:19:27 - Update Config Settings - WEEKLY_ROLLOVER_DATE = TO_TIMESTAMP('2023/07/31 00:00:00','YYYY/MM/DD HH24:MI:SS'), 2023/05/09 13:19:27 - Update Config Settings - MONTHLY_ROLLOVER_DATE = TO_TIMESTAMP('2023/08/01 00:00:00','YYYY/MM/DD HH24:MI:SS'), 2023/05/09 13:19:27 - Update Config Settings - FISCAL_ROLLOVER_DATE = TO_TIMESTAMP('2023/06/01 00:00:00','YYYY/MM/DD HH24:MI:SS'), 2023/05/09 13:19:27 - Update Config Settings - FULL_RELOAD = (CASE WHEN 'Y' = 'Y' THEN 1 2023/05/09 13:19:27 - Update Config Settings - WHEN '2001-07-10 09:04:08' > '1900-01-01 00:00:00' THEN 1 2023/05/09 13:19:27 - Update Config Settings - ELSE 0 END), 2023/05/09 13:19:27 - Update Config Settings - DWH_DIM_PREV_START_DATE = CASE WHEN 'Y' = 'Y' THEN TO_TIMESTAMP('1900/01/01 00:00:00','YYYY/MM/DD HH24:MI:SS') 2023/05/09 13:19:27 - Update Config Settings - ELSE TO_TIMESTAMP('2023/05/09 13:19:19','YYYY/MM/DD HH24:MI:SS') END 2023/05/09 13:19:27 - Update Config Settings - 2023/05/09 13:19:27 - Update Config Settings - ERROR: error de sintaxis en o cerca de «0» Position: 114 2023/05/09 13:25:46 - Update Config Settings - ERROR (version 9.3.0.0-428, build 9.3.0.0-428 from 2022-04-12 04.56.25 by buildguy) : An error occurred executing this job entry : 2023/05/09 13:25:46 - Update Config Settings - Couldn't execute SQL: UPDATE DWH_CFG_SETTINGS 2023/05/09 13:25:46 - Update Config Settings - SET LANGUAGE_CODE_KEY = 1, 2023/05/09 13:25:46 - Update Config Settings - LANGUAGE_CODE = 'en', 2023/05/09 13:25:46 - Update Config Settings - CURRENCY_PRECISION = 0,0, 2023/05/09 13:25:46 - Update Config Settings - WEEK_START_DAY = 1, 2023/05/09 13:25:46 - Update Config Settings - WEEK_START_DAY_CHANGED = CASE WHEN 1 = 1 THEN 0 ELSE 1 END, 2023/05/09 13:25:46 - Update Config Settings - ENTITY_KEY = 5075791, 2023/05/09 13:25:46 - Update Config Settings - ENTITY_CHANGED = CASE WHEN 5075791 = 0 THEN 0 ELSE 1 END, 2023/05/09 13:25:46 - Update Config Settings - CURRENT_FISCAL_PERIOD_KEY = 5069135, 2023/05/09 13:25:46 - Update Config Settings - FISCAL_PERIOD_CHANGED = CASE WHEN 5069135 = 0 THEN 0 ELSE 1 END, 2023/05/09 13:25:46 - Update Config Settings - WEEKLY_SLICES = 1, 2023/05/09 13:25:46 - Update Config Settings - MONTHLY_SLICES = 1, 2023/05/09 13:25:46 - Update Config Settings - FISCAL_SLICES = 1, 2023/05/09 13:25:46 - Update Config Settings - ONE_SET_OF_FISCAL_PERIODS = 1, 2023/05/09 13:25:46 - Update Config Settings - DISABLE_RESOURCE_SECURITY = 0, 2023/05/09 13:25:46 - Update Config Settings - DISABLE_INVESTMENT_SECURITY = 0, 2023/05/09 13:25:46 - Update Config Settings - SINGLE_CURRENCY = 1, 2023/05/09 13:25:46 - Update Config Settings - DAILY_ROLLOVER_OCCURRED = CASE WHEN '2023/08/09 00:00:00' > '1900/01/01 00:00:00' THEN 1 ELSE 0 END, 2023/05/09 13:25:46 - Update Config Settings - WEEKLY_ROLLOVER_OCCURRED = CASE WHEN '2023/07/31 00:00:00' > '1900/01/01 00:00:00' THEN 1 ELSE 0 END, 2023/05/09 13:25:46 - Update Config Settings - MONTHLY_ROLLOVER_OCCURRED = CASE WHEN '2023/08/01 00:00:00' > '1900/01/01 00:00:00' THEN 1 ELSE 0 END, 2023/05/09 13:25:46 - Update Config Settings - FISCAL_ROLLOVER_OCCURRED = CASE WHEN '2023/06/01 00:00:00' > '1900/01/01 00:00:00' THEN 1 ELSE 0 END, 2023/05/09 13:25:46 - Update Config Settings - DAILY_ROLLOVER_DATE = TO_TIMESTAMP('2023/08/09 00:00:00','YYYY/MM/DD HH24:MI:SS'), 2023/05/09 13:25:46 - Update Config Settings - WEEKLY_ROLLOVER_DATE = TO_TIMESTAMP('2023/07/31 00:00:00','YYYY/MM/DD HH24:MI:SS'), 2023/05/09 13:25:46 - Update Config Settings - MONTHLY_ROLLOVER_DATE = TO_TIMESTAMP('2023/08/01 00:00:00','YYYY/MM/DD HH24:MI:SS'), 2023/05/09 13:25:46 - Update Config Settings - FISCAL_ROLLOVER_DATE = TO_TIMESTAMP('2023/06/01 00:00:00','YYYY/MM/DD HH24:MI:SS'), 2023/05/09 13:25:46 - Update Config Settings - FULL_RELOAD = (CASE WHEN 'Y' = 'Y' THEN 1 2023/05/09 13:25:46 - Update Config Settings - WHEN '2001-07-10 09:04:08' > '1900-01-01 00:00:00' THEN 1 2023/05/09 13:25:46 - Update Config Settings - ELSE 0 END), 2023/05/09 13:25:46 - Update Config Settings - DWH_DIM_PREV_START_DATE = CASE WHEN 'Y' = 'Y' THEN TO_TIMESTAMP('1900/01/01 00:00:00','YYYY/MM/DD HH24:MI:SS') 2023/05/09 13:25:46 - Update Config Settings - ELSE TO_TIMESTAMP('2023/05/09 13:25:40','YYYY/MM/DD HH24:MI:SS') END 2023/05/09 13:25:46 - Update Config Settings - 2023/05/09 13:25:46 - Update Config Settings - ERROR: error de sintaxis en o cerca de «0» Position: 114 2023/05/09 13:36:03 - Update Config Settings - ERROR (version 9.3.0.0-428, build 9.3.0.0-428 from 2022-04-12 04.56.25 by buildguy) : An error occurred executing this job entry : 2023/05/09 13:36:03 - Update Config Settings - Couldn't execute SQL: UPDATE DWH_CFG_SETTINGS 2023/05/09 13:36:03 - Update Config Settings - SET LANGUAGE_CODE_KEY = 1, 2023/05/09 13:36:03 - Update Config Settings - LANGUAGE_CODE = 'en', 2023/05/09 13:36:03 - Update Config Settings - CURRENCY_PRECISION = 0,0, 2023/05/09 13:36:03 - Update Config Settings - WEEK_START_DAY = 1, 2023/05/09 13:36:03 - Update Config Settings - WEEK_START_DAY_CHANGED = CASE WHEN 1 = 1 THEN 0 ELSE 1 END, 2023/05/09 13:36:03 - Update Config Settings - ENTITY_KEY = 5075791, 2023/05/09 13:36:03 - Update Config Settings - ENTITY_CHANGED = CASE WHEN 5075791 = 5075791 THEN 0 ELSE 1 END, 2023/05/09 13:36:03 - Update Config Settings - CURRENT_FISCAL_PERIOD_KEY = 5069135, 2023/05/09 13:36:03 - Update Config Settings - FISCAL_PERIOD_CHANGED = CASE WHEN 5069135 = 5069135 THEN 0 ELSE 1 END, 2023/05/09 13:36:03 - Update Config Settings - WEEKLY_SLICES = 1, 2023/05/09 13:36:03 - Update Config Settings - MONTHLY_SLICES = 1, 2023/05/09 13:36:03 - Update Config Settings - FISCAL_SLICES = 1, 2023/05/09 13:36:03 - Update Config Settings - ONE_SET_OF_FISCAL_PERIODS = 1, 2023/05/09 13:36:03 - Update Config Settings - DISABLE_RESOURCE_SECURITY = 0, 2023/05/09 13:36:03 - Update Config Settings - DISABLE_INVESTMENT_SECURITY = 0, 2023/05/09 13:36:03 - Update Config Settings - SINGLE_CURRENCY = 1, 2023/05/09 13:36:03 - Update Config Settings - DAILY_ROLLOVER_OCCURRED = CASE WHEN '2023/08/09 00:00:00' > '2023/08/09 00:00:00' THEN 1 ELSE 0 END, 2023/05/09 13:36:03 - Update Config Settings - WEEKLY_ROLLOVER_OCCURRED = CASE WHEN '2023/07/31 00:00:00' > '2023/07/31 00:00:00' THEN 1 ELSE 0 END, 2023/05/09 13:36:03 - Update Config Settings - MONTHLY_ROLLOVER_OCCURRED = CASE WHEN '2023/08/01 00:00:00' > '2023/08/01 00:00:00' THEN 1 ELSE 0 END, 2023/05/09 13:36:03 - Update Config Settings - FISCAL_ROLLOVER_OCCURRED = CASE WHEN '2023/06/01 00:00:00' > '2023/06/01 00:00:00' THEN 1 ELSE 0 END, 2023/05/09 13:36:03 - Update Config Settings - DAILY_ROLLOVER_DATE = TO_TIMESTAMP('2023/08/09 00:00:00','YYYY/MM/DD HH24:MI:SS'), 2023/05/09 13:36:03 - Update Config Settings - WEEKLY_ROLLOVER_DATE = TO_TIMESTAMP('2023/07/31 00:00:00','YYYY/MM/DD HH24:MI:SS'), 2023/05/09 13:36:03 - Update Config Settings - MONTHLY_ROLLOVER_DATE = TO_TIMESTAMP('2023/08/01 00:00:00','YYYY/MM/DD HH24:MI:SS'), 2023/05/09 13:36:03 - Update Config Settings - FISCAL_ROLLOVER_DATE = TO_TIMESTAMP('2023/06/01 00:00:00','YYYY/MM/DD HH24:MI:SS'), 2023/05/09 13:36:03 - Update Config Settings - FULL_RELOAD = (CASE WHEN 'Y' = 'Y' THEN 1 2023/05/09 13:36:03 - Update Config Settings - WHEN '2001-07-10 09:04:08' > '1900-01-01 00:00:00' THEN 1 2023/05/09 13:36:03 - Update Config Settings - ELSE 0 END), 2023/05/09 13:36:03 - Update Config Settings - DWH_DIM_PREV_START_DATE = CASE WHEN 'Y' = 'Y' THEN TO_TIMESTAMP('1900/01/01 00:00:00','YYYY/MM/DD HH24:MI:SS') 2023/05/09 13:36:03 - Update Config Settings - ELSE TO_TIMESTAMP('2023/05/09 13:36:00','YYYY/MM/DD HH24:MI:SS') END 2023/05/09 13:36:03 - Update Config Settings - 2023/05/09 13:36:03 - Update Config Settings - ERROR: error de sintaxis en o cerca de «0» Position: 114 2023/05/09 13:19:27 - Update Config Settings - ERROR (version 9.3.0.0-428, build 9.3.0.0-428 from 2022-04-12 04.56.25 by buildguy) : An error occurred executing this job entry : 2023/05/09 13:19:27 - Update Config Settings - Couldn't execute SQL: UPDATE DWH_CFG_SETTINGS 2023/05/09 13:19:27 - Update Config Settings - SET LANGUAGE_CODE_KEY = 1, 2023/05/09 13:19:27 - Update Config Settings - LANGUAGE_CODE = 'en', 2023/05/09 13:19:27 - Update Config Settings - CURRENCY_PRECISION = 0,0, 2023/05/09 13:19:27 - Update Config Settings - WEEK_START_DAY = 1, 2023/05/09 13:19:27 - Update Config Settings - WEEK_START_DAY_CHANGED = CASE WHEN 1 = 1 THEN 0 ELSE 1 END, 2023/05/09 13:19:27 - Update Config Settings - ENTITY_KEY = 5075791, 2023/05/09 13:19:27 - Update Config Settings - ENTITY_CHANGED = CASE WHEN 5075791 = 0 THEN 0 ELSE 1 END, 2023/05/09 13:19:27 - Update Config Settings - CURRENT_FISCAL_PERIOD_KEY = 5069135, 2023/05/09 13:19:27 - Update Config Settings - FISCAL_PERIOD_CHANGED = CASE WHEN 5069135 = 0 THEN 0 ELSE 1 END, 2023/05/09 13:19:27 - Update Config Settings - WEEKLY_SLICES = 1, 2023/05/09 13:19:27 - Update Config Settings - MONTHLY_SLICES = 1, 2023/05/09 13:19:27 - Update Config Settings - FISCAL_SLICES = 1, 2023/05/09 13:19:27 - Update Config Settings - ONE_SET_OF_FISCAL_PERIODS = 1, 2023/05/09 13:19:27 - Update Config Settings - DISABLE_RESOURCE_SECURITY = 0, 2023/05/09 13:19:27 - Update Config Settings - DISABLE_INVESTMENT_SECURITY = 0, 2023/05/09 13:19:27 - Update Config Settings - SINGLE_CURRENCY = 1, 2023/05/09 13:19:27 - Update Config Settings - DAILY_ROLLOVER_OCCURRED = CASE WHEN '2023/08/09 00:00:00' > '1900/01/01 00:00:00' THEN 1 ELSE 0 END, 2023/05/09 13:19:27 - Update Config Settings - WEEKLY_ROLLOVER_OCCURRED = CASE WHEN '2023/07/31 00:00:00' > '1900/01/01 00:00:00' THEN 1 ELSE 0 END, 2023/05/09 13:19:27 - Update Config Settings - MONTHLY_ROLLOVER_OCCURRED = CASE WHEN '2023/08/01 00:00:00' > '1900/01/01 00:00:00' THEN 1 ELSE 0 END, 2023/05/09 13:19:27 - Update Config Settings - FISCAL_ROLLOVER_OCCURRED = CASE WHEN '2023/06/01 00:00:00' > '1900/01/01 00:00:00' THEN 1 ELSE 0 END, 2023/05/09 13:19:27 - Update Config Settings - DAILY_ROLLOVER_DATE = TO_TIMESTAMP('2023/08/09 00:00:00','YYYY/MM/DD HH24:MI:SS'), 2023/05/09 13:19:27 - Update Config Settings - WEEKLY_ROLLOVER_DATE = TO_TIMESTAMP('2023/07/31 00:00:00','YYYY/MM/DD HH24:MI:SS'), 2023/05/09 13:19:27 - Update Config Settings - MONTHLY_ROLLOVER_DATE = TO_TIMESTAMP('2023/08/01 00:00:00','YYYY/MM/DD HH24:MI:SS'), 2023/05/09 13:19:27 - Update Config Settings - FISCAL_ROLLOVER_DATE = TO_TIMESTAMP('2023/06/01 00:00:00','YYYY/MM/DD HH24:MI:SS'), 2023/05/09 13:19:27 - Update Config Settings - FULL_RELOAD = (CASE WHEN 'Y' = 'Y' THEN 1 2023/05/09 13:19:27 - Update Config Settings - WHEN '2001-07-10 09:04:08' > '1900-01-01 00:00:00' THEN 1 2023/05/09 13:19:27 - Update Config Settings - ELSE 0 END), 2023/05/09 13:19:27 - Update Config Settings - DWH_DIM_PREV_START_DATE = CASE WHEN 'Y' = 'Y' THEN TO_TIMESTAMP('1900/01/01 00:00:00','YYYY/MM/DD HH24:MI:SS') 2023/05/09 13:19:27 - Update Config Settings - ELSE TO_TIMESTAMP('2023/05/09 13:19:19','YYYY/MM/DD HH24:MI:SS') END 2023/05/09 13:19:27 - Update Config Settings - 2023/05/09 13:19:27 - Update Config Settings - ERROR: error de sintaxis en o cerca de «0» Position: 114 2023/05/09 13:25:46 - Update Config Settings - ERROR (version 9.3.0.0-428, build 9.3.0.0-428 from 2022-04-12 04.56.25 by buildguy) : An error occurred executing this job entry : 2023/05/09 13:25:46 - Update Config Settings - Couldn't execute SQL: UPDATE DWH_CFG_SETTINGS 2023/05/09 13:25:46 - Update Config Settings - SET LANGUAGE_CODE_KEY = 1, 2023/05/09 13:25:46 - Update Config Settings - LANGUAGE_CODE = 'en', 2023/05/09 13:25:46 - Update Config Settings - CURRENCY_PRECISION = 0,0, 2023/05/09 13:25:46 - Update Config Settings - WEEK_START_DAY = 1, 2023/05/09 13:25:46 - Update Config Settings - WEEK_START_DAY_CHANGED = CASE WHEN 1 = 1 THEN 0 ELSE 1 END, 2023/05/09 13:25:46 - Update Config Settings - ENTITY_KEY = 5075791, 2023/05/09 13:25:46 - Update Config Settings - ENTITY_CHANGED = CASE WHEN 5075791 = 0 THEN 0 ELSE 1 END, 2023/05/09 13:25:46 - Update Config Settings - CURRENT_FISCAL_PERIOD_KEY = 5069135, 2023/05/09 13:25:46 - Update Config Settings - FISCAL_PERIOD_CHANGED = CASE WHEN 5069135 = 0 THEN 0 ELSE 1 END, 2023/05/09 13:25:46 - Update Config Settings - WEEKLY_SLICES = 1, 2023/05/09 13:25:46 - Update Config Settings - MONTHLY_SLICES = 1, 2023/05/09 13:25:46 - Update Config Settings - FISCAL_SLICES = 1, 2023/05/09 13:25:46 - Update Config Settings - ONE_SET_OF_FISCAL_PERIODS = 1, 2023/05/09 13:25:46 - Update Config Settings - DISABLE_RESOURCE_SECURITY = 0, 2023/05/09 13:25:46 - Update Config Settings - DISABLE_INVESTMENT_SECURITY = 0, 2023/05/09 13:25:46 - Update Config Settings - SINGLE_CURRENCY = 1, 2023/05/09 13:25:46 - Update Config Settings - DAILY_ROLLOVER_OCCURRED = CASE WHEN '2023/08/09 00:00:00' > '1900/01/01 00:00:00' THEN 1 ELSE 0 END, 2023/05/09 13:25:46 - Update Config Settings - WEEKLY_ROLLOVER_OCCURRED = CASE WHEN '2023/07/31 00:00:00' > '1900/01/01 00:00:00' THEN 1 ELSE 0 END, 2023/05/09 13:25:46 - Update Config Settings - MONTHLY_ROLLOVER_OCCURRED = CASE WHEN '2023/08/01 00:00:00' > '1900/01/01 00:00:00' THEN 1 ELSE 0 END, 2023/05/09 13:25:46 - Update Config Settings - FISCAL_ROLLOVER_OCCURRED = CASE WHEN '2023/06/01 00:00:00' > '1900/01/01 00:00:00' THEN 1 ELSE 0 END, 2023/05/09 13:25:46 - Update Config Settings - DAILY_ROLLOVER_DATE = TO_TIMESTAMP('2023/08/09 00:00:00','YYYY/MM/DD HH24:MI:SS'), 2023/05/09 13:25:46 - Update Config Settings - WEEKLY_ROLLOVER_DATE = TO_TIMESTAMP('2023/07/31 00:00:00','YYYY/MM/DD HH24:MI:SS'), 2023/05/09 13:25:46 - Update Config Settings - MONTHLY_ROLLOVER_DATE = TO_TIMESTAMP('2023/08/01 00:00:00','YYYY/MM/DD HH24:MI:SS'), 2023/05/09 13:25:46 - Update Config Settings - FISCAL_ROLLOVER_DATE = TO_TIMESTAMP('2023/06/01 00:00:00','YYYY/MM/DD HH24:MI:SS'), 2023/05/09 13:25:46 - Update Config Settings - FULL_RELOAD = (CASE WHEN 'Y' = 'Y' THEN 1 2023/05/09 13:25:46 - Update Config Settings - WHEN '2001-07-10 09:04:08' > '1900-01-01 00:00:00' THEN 1 2023/05/09 13:25:46 - Update Config Settings - ELSE 0 END), 2023/05/09 13:25:46 - Update Config Settings - DWH_DIM_PREV_START_DATE = CASE WHEN 'Y' = 'Y' THEN TO_TIMESTAMP('1900/01/01 00:00:00','YYYY/MM/DD HH24:MI:SS') 2023/05/09 13:25:46 - Update Config Settings - ELSE TO_TIMESTAMP('2023/05/09 13:25:40','YYYY/MM/DD HH24:MI:SS') END 2023/05/09 13:25:46 - Update Config Settings - 2023/05/09 13:25:46 - Update Config Settings - ERROR: error de sintaxis en o cerca de «0» Position: 114 2023/05/09 13:36:03 - Update Config Settings - ERROR (version 9.3.0.0-428, build 9.3.0.0-428 from 2022-04-12 04.56.25 by buildguy) : An error occurred executing this job entry : 2023/05/09 13:36:03 - Update Config Settings - Couldn't execute SQL: UPDATE DWH_CFG_SETTINGS 2023/05/09 13:36:03 - Update Config Settings - SET LANGUAGE_CODE_KEY = 1, 2023/05/09 13:36:03 - Update Config Settings - LANGUAGE_CODE = 'en', 2023/05/09 13:36:03 - Update Config Settings - CURRENCY_PRECISION = 0,0, 2023/05/09 13:36:03 - Update Config Settings - WEEK_START_DAY = 1, 2023/05/09 13:36:03 - Update Config Settings - WEEK_START_DAY_CHANGED = CASE WHEN 1 = 1 THEN 0 ELSE 1 END, 2023/05/09 13:36:03 - Update Config Settings - ENTITY_KEY = 5075791, 2023/05/09 13:36:03 - Update Config Settings - ENTITY_CHANGED = CASE WHEN 5075791 = 5075791 THEN 0 ELSE 1 END, 2023/05/09 13:36:03 - Update Config Settings - CURRENT_FISCAL_PERIOD_KEY = 5069135, 2023/05/09 13:36:03 - Update Config Settings - FISCAL_PERIOD_CHANGED = CASE WHEN 5069135 = 5069135 THEN 0 ELSE 1 END, 2023/05/09 13:36:03 - Update Config Settings - WEEKLY_SLICES = 1, 2023/05/09 13:36:03 - Update Config Settings - MONTHLY_SLICES = 1, 2023/05/09 13:36:03 - Update Config Settings - FISCAL_SLICES = 1, 2023/05/09 13:36:03 - Update Config Settings - ONE_SET_OF_FISCAL_PERIODS = 1, 2023/05/09 13:36:03 - Update Config Settings - DISABLE_RESOURCE_SECURITY = 0, 2023/05/09 13:36:03 - Update Config Settings - DISABLE_INVESTMENT_SECURITY = 0, 2023/05/09 13:36:03 - Update Config Settings - SINGLE_CURRENCY = 1, 2023/05/09 13:36:03 - Update Config Settings - DAILY_ROLLOVER_OCCURRED = CASE WHEN '2023/08/09 00:00:00' > '2023/08/09 00:00:00' THEN 1 ELSE 0 END, 2023/05/09 13:36:03 - Update Config Settings - WEEKLY_ROLLOVER_OCCURRED = CASE WHEN '2023/07/31 00:00:00' > '2023/07/31 00:00:00' THEN 1 ELSE 0 END, 2023/05/09 13:36:03 - Update Config Settings - MONTHLY_ROLLOVER_OCCURRED = CASE WHEN '2023/08/01 00:00:00' > '2023/08/01 00:00:00' THEN 1 ELSE 0 END, 2023/05/09 13:36:03 - Update Config Settings - FISCAL_ROLLOVER_OCCURRED = CASE WHEN '2023/06/01 00:00:00' > '2023/06/01 00:00:00' THEN 1 ELSE 0 END, 2023/05/09 13:36:03 - Update Config Settings - DAILY_ROLLOVER_DATE = TO_TIMESTAMP('2023/08/09 00:00:00','YYYY/MM/DD HH24:MI:SS'), 2023/05/09 13:36:03 - Update Config Settings - WEEKLY_ROLLOVER_DATE = TO_TIMESTAMP('2023/07/31 00:00:00','YYYY/MM/DD HH24:MI:SS'), 2023/05/09 13:36:03 - Update Config Settings - MONTHLY_ROLLOVER_DATE = TO_TIMESTAMP('2023/08/01 00:00:00','YYYY/MM/DD HH24:MI:SS'), 2023/05/09 13:36:03 - Update Config Settings - FISCAL_ROLLOVER_DATE = TO_TIMESTAMP('2023/06/01 00:00:00','YYYY/MM/DD HH24:MI:SS'), 2023/05/09 13:36:03 - Update Config Settings - FULL_RELOAD = (CASE WHEN 'Y' = 'Y' THEN 1 2023/05/09 13:36:03 - Update Config Settings - WHEN '2001-07-10 09:04:08' > '1900-01-01 00:00:00' THEN 1 2023/05/09 13:36:03 - Update Config Settings - ELSE 0 END), 2023/05/09 13:36:03 - Update Config Settings - DWH_DIM_PREV_START_DATE = CASE WHEN 'Y' = 'Y' THEN TO_TIMESTAMP('1900/01/01 00:00:00','YYYY/MM/DD HH24:MI:SS') 2023/05/09 13:36:03 - Update Config Settings - ELSE TO_TIMESTAMP('2023/05/09 13:36:00','YYYY/MM/DD HH24:MI:SS') END 2023/05/09 13:36:03 - Update Config Settings - 2023/05/09 13:36:03 - Update Config Settings - ERROR: error de sintaxis en o cerca de «0» Position: 114 2023/05/09 13:19:27 - Update Config Settings - ERROR (version 9.3.0.0-428, build 9.3.0.0-428 from 2022-04-12 04.56.25 by buildguy) : An error occurred executing this job entry : 2023/05/09 13:19:27 - Update Config Settings - Couldn't execute SQL: UPDATE DWH_CFG_SETTINGS 2023/05/09 13:19:27 - Update Config Settings - SET LANGUAGE_CODE_KEY = 1, 2023/05/09 13:19:27 - Update Config Settings - LANGUAGE_CODE = 'en', 2023/05/09 13:19:27 - Update Config Settings - CURRENCY_PRECISION = 0,0, 2023/05/09 13:19:27 - Update Config Settings - WEEK_START_DAY = 1, 2023/05/09 13:19:27 - Update Config Settings - WEEK_START_DAY_CHANGED = CASE WHEN 1 = 1 THEN 0 ELSE 1 END, 2023/05/09 13:19:27 - Update Config Settings - ENTITY_KEY = 5075791, 2023/05/09 13:19:27 - Update Config Settings - ENTITY_CHANGED = CASE WHEN 5075791 = 0 THEN 0 ELSE 1 END, 2023/05/09 13:19:27 - Update Config Settings - CURRENT_FISCAL_PERIOD_KEY = 5069135, 2023/05/09 13:19:27 - Update Config Settings - FISCAL_PERIOD_CHANGED = CASE WHEN 5069135 = 0 THEN 0 ELSE 1 END, 2023/05/09 13:19:27 - Update Config Settings - WEEKLY_SLICES = 1, 2023/05/09 13:19:27 - Update Config Settings - MONTHLY_SLICES = 1, 2023/05/09 13:19:27 - Update Config Settings - FISCAL_SLICES = 1, 2023/05/09 13:19:27 - Update Config Settings - ONE_SET_OF_FISCAL_PERIODS = 1, 2023/05/09 13:19:27 - Update Config Settings - DISABLE_RESOURCE_SECURITY = 0, 2023/05/09 13:19:27 - Update Config Settings - DISABLE_INVESTMENT_SECURITY = 0, 2023/05/09 13:19:27 - Update Config Settings - SINGLE_CURRENCY = 1, 2023/05/09 13:19:27 - Update Config Settings - DAILY_ROLLOVER_OCCURRED = CASE WHEN '2023/08/09 00:00:00' > '1900/01/01 00:00:00' THEN 1 ELSE 0 END, 2023/05/09 13:19:27 - Update Config Settings - WEEKLY_ROLLOVER_OCCURRED = CASE WHEN '2023/07/31 00:00:00' > '1900/01/01 00:00:00' THEN 1 ELSE 0 END, 2023/05/09 13:19:27 - Update Config Settings - MONTHLY_ROLLOVER_OCCURRED = CASE WHEN '2023/08/01 00:00:00' > '1900/01/01 00:00:00' THEN 1 ELSE 0 END, 2023/05/09 13:19:27 - Update Config Settings - FISCAL_ROLLOVER_OCCURRED = CASE WHEN '2023/06/01 00:00:00' > '1900/01/01 00:00:00' THEN 1 ELSE 0 END, 2023/05/09 13:19:27 - Update Config Settings - DAILY_ROLLOVER_DATE = TO_TIMESTAMP('2023/08/09 00:00:00','YYYY/MM/DD HH24:MI:SS'), 2023/05/09 13:19:27 - Update Config Settings - WEEKLY_ROLLOVER_DATE = TO_TIMESTAMP('2023/07/31 00:00:00','YYYY/MM/DD HH24:MI:SS'), 2023/05/09 13:19:27 - Update Config Settings - MONTHLY_ROLLOVER_DATE = TO_TIMESTAMP('2023/08/01 00:00:00','YYYY/MM/DD HH24:MI:SS'), 2023/05/09 13:19:27 - Update Config Settings - FISCAL_ROLLOVER_DATE = TO_TIMESTAMP('2023/06/01 00:00:00','YYYY/MM/DD HH24:MI:SS'), 2023/05/09 13:19:27 - Update Config Settings - FULL_RELOAD = (CASE WHEN 'Y' = 'Y' THEN 1 2023/05/09 13:19:27 - Update Config Settings - WHEN '2001-07-10 09:04:08' > '1900-01-01 00:00:00' THEN 1 2023/05/09 13:19:27 - Update Config Settings - ELSE 0 END), 2023/05/09 13:19:27 - Update Config Settings - DWH_DIM_PREV_START_DATE = CASE WHEN 'Y' = 'Y' THEN TO_TIMESTAMP('1900/01/01 00:00:00','YYYY/MM/DD HH24:MI:SS') 2023/05/09 13:19:27 - Update Config Settings - ELSE TO_TIMESTAMP('2023/05/09 13:19:19','YYYY/MM/DD HH24:MI:SS') END 2023/05/09 13:19:27 - Update Config Settings - 2023/05/09 13:19:27 - Update Config Settings - ERROR: error de sintaxis en o cerca de «0» Position: 114 2023/05/09 13:25:46 - Update Config Settings - ERROR (version 9.3.0.0-428, build 9.3.0.0-428 from 2022-04-12 04.56.25 by buildguy) : An error occurred executing this job entry : 2023/05/09 13:25:46 - Update Config Settings - Couldn't execute SQL: UPDATE DWH_CFG_SETTINGS 2023/05/09 13:25:46 - Update Config Settings - SET LANGUAGE_CODE_KEY = 1, 2023/05/09 13:25:46 - Update Config Settings - LANGUAGE_CODE = 'en', 2023/05/09 13:25:46 - Update Config Settings - CURRENCY_PRECISION = 0,0, 2023/05/09 13:25:46 - Update Config Settings - WEEK_START_DAY = 1, 2023/05/09 13:25:46 - Update Config Settings - WEEK_START_DAY_CHANGED = CASE WHEN 1 = 1 THEN 0 ELSE 1 END, 2023/05/09 13:25:46 - Update Config Settings - ENTITY_KEY = 5075791, 2023/05/09 13:25:46 - Update Config Settings - ENTITY_CHANGED = CASE WHEN 5075791 = 0 THEN 0 ELSE 1 END, 2023/05/09 13:25:46 - Update Config Settings - CURRENT_FISCAL_PERIOD_KEY = 5069135, 2023/05/09 13:25:46 - Update Config Settings - FISCAL_PERIOD_CHANGED = CASE WHEN 5069135 = 0 THEN 0 ELSE 1 END, 2023/05/09 13:25:46 - Update Config Settings - WEEKLY_SLICES = 1, 2023/05/09 13:25:46 - Update Config Settings - MONTHLY_SLICES = 1, 2023/05/09 13:25:46 - Update Config Settings - FISCAL_SLICES = 1, 2023/05/09 13:25:46 - Update Config Settings - ONE_SET_OF_FISCAL_PERIODS = 1, 2023/05/09 13:25:46 - Update Config Settings - DISABLE_RESOURCE_SECURITY = 0, 2023/05/09 13:25:46 - Update Config Settings - DISABLE_INVESTMENT_SECURITY = 0, 2023/05/09 13:25:46 - Update Config Settings - SINGLE_CURRENCY = 1, 2023/05/09 13:25:46 - Update Config Settings - DAILY_ROLLOVER_OCCURRED = CASE WHEN '2023/08/09 00:00:00' > '1900/01/01 00:00:00' THEN 1 ELSE 0 END, 2023/05/09 13:25:46 - Update Config Settings - WEEKLY_ROLLOVER_OCCURRED = CASE WHEN '2023/07/31 00:00:00' > '1900/01/01 00:00:00' THEN 1 ELSE 0 END, 2023/05/09 13:25:46 - Update Config Settings - MONTHLY_ROLLOVER_OCCURRED = CASE WHEN '2023/08/01 00:00:00' > '1900/01/01 00:00:00' THEN 1 ELSE 0 END, 2023/05/09 13:25:46 - Update Config Settings - FISCAL_ROLLOVER_OCCURRED = CASE WHEN '2023/06/01 00:00:00' > '1900/01/01 00:00:00' THEN 1 ELSE 0 END, 2023/05/09 13:25:46 - Update Config Settings - DAILY_ROLLOVER_DATE = TO_TIMESTAMP('2023/08/09 00:00:00','YYYY/MM/DD HH24:MI:SS'), 2023/05/09 13:25:46 - Update Config Settings - WEEKLY_ROLLOVER_DATE = TO_TIMESTAMP('2023/07/31 00:00:00','YYYY/MM/DD HH24:MI:SS'), 2023/05/09 13:25:46 - Update Config Settings - MONTHLY_ROLLOVER_DATE = TO_TIMESTAMP('2023/08/01 00:00:00','YYYY/MM/DD HH24:MI:SS'), 2023/05/09 13:25:46 - Update Config Settings - FISCAL_ROLLOVER_DATE = TO_TIMESTAMP('2023/06/01 00:00:00','YYYY/MM/DD HH24:MI:SS'), 2023/05/09 13:25:46 - Update Config Settings - FULL_RELOAD = (CASE WHEN 'Y' = 'Y' THEN 1 2023/05/09 13:25:46 - Update Config Settings - WHEN '2001-07-10 09:04:08' > '1900-01-01 00:00:00' THEN 1 2023/05/09 13:25:46 - Update Config Settings - ELSE 0 END), 2023/05/09 13:25:46 - Update Config Settings - DWH_DIM_PREV_START_DATE = CASE WHEN 'Y' = 'Y' THEN TO_TIMESTAMP('1900/01/01 00:00:00','YYYY/MM/DD HH24:MI:SS') 2023/05/09 13:25:46 - Update Config Settings - ELSE TO_TIMESTAMP('2023/05/09 13:25:40','YYYY/MM/DD HH24:MI:SS') END 2023/05/09 13:25:46 - Update Config Settings - 2023/05/09 13:25:46 - Update Config Settings - ERROR: error de sintaxis en o cerca de «0» Position: 114 2023/05/09 13:36:03 - Update Config Settings - ERROR (version 9.3.0.0-428, build 9.3.0.0-428 from 2022-04-12 04.56.25 by buildguy) : An error occurred executing this job entry : 2023/05/09 13:36:03 - Update Config Settings - Couldn't execute SQL: UPDATE DWH_CFG_SETTINGS 2023/05/09 13:36:03 - Update Config Settings - SET LANGUAGE_CODE_KEY = 1, 2023/05/09 13:36:03 - Update Config Settings - LANGUAGE_CODE = 'en', 2023/05/09 13:36:03 - Update Config Settings - CURRENCY_PRECISION = 0,0, 2023/05/09 13:36:03 - Update Config Settings - WEEK_START_DAY = 1, 2023/05/09 13:36:03 - Update Config Settings - WEEK_START_DAY_CHANGED = CASE WHEN 1 = 1 THEN 0 ELSE 1 END, 2023/05/09 13:36:03 - Update Config Settings - ENTITY_KEY = 5075791, 2023/05/09 13:36:03 - Update Config Settings - ENTITY_CHANGED = CASE WHEN 5075791 = 5075791 THEN 0 ELSE 1 END, 2023/05/09 13:36:03 - Update Config Settings - CURRENT_FISCAL_PERIOD_KEY = 5069135, 2023/05/09 13:36:03 - Update Config Settings - FISCAL_PERIOD_CHANGED = CASE WHEN 5069135 = 5069135 THEN 0 ELSE 1 END, 2023/05/09 13:36:03 - Update Config Settings - WEEKLY_SLICES = 1, 2023/05/09 13:36:03 - Update Config Settings - MONTHLY_SLICES = 1, 2023/05/09 13:36:03 - Update Config Settings - FISCAL_SLICES = 1, 2023/05/09 13:36:03 - Update Config Settings - ONE_SET_OF_FISCAL_PERIODS = 1, 2023/05/09 13:36:03 - Update Config Settings - DISABLE_RESOURCE_SECURITY = 0, 2023/05/09 13:36:03 - Update Config Settings - DISABLE_INVESTMENT_SECURITY = 0, 2023/05/09 13:36:03 - Update Config Settings - SINGLE_CURRENCY = 1, 2023/05/09 13:36:03 - Update Config Settings - DAILY_ROLLOVER_OCCURRED = CASE WHEN '2023/08/09 00:00:00' > '2023/08/09 00:00:00' THEN 1 ELSE 0 END, 2023/05/09 13:36:03 - Update Config Settings - WEEKLY_ROLLOVER_OCCURRED = CASE WHEN '2023/07/31 00:00:00' > '2023/07/31 00:00:00' THEN 1 ELSE 0 END, 2023/05/09 13:36:03 - Update Config Settings - MONTHLY_ROLLOVER_OCCURRED = CASE WHEN '2023/08/01 00:00:00' > '2023/08/01 00:00:00' THEN 1 ELSE 0 END, 2023/05/09 13:36:03 - Update Config Settings - FISCAL_ROLLOVER_OCCURRED = CASE WHEN '2023/06/01 00:00:00' > '2023/06/01 00:00:00' THEN 1 ELSE 0 END, 2023/05/09 13:36:03 - Update Config Settings - DAILY_ROLLOVER_DATE = TO_TIMESTAMP('2023/08/09 00:00:00','YYYY/MM/DD HH24:MI:SS'), 2023/05/09 13:36:03 - Update Config Settings - WEEKLY_ROLLOVER_DATE = TO_TIMESTAMP('2023/07/31 00:00:00','YYYY/MM/DD HH24:MI:SS'), 2023/05/09 13:36:03 - Update Config Settings - MONTHLY_ROLLOVER_DATE = TO_TIMESTAMP('2023/08/01 00:00:00','YYYY/MM/DD HH24:MI:SS'), 2023/05/09 13:36:03 - Update Config Settings - FISCAL_ROLLOVER_DATE = TO_TIMESTAMP('2023/06/01 00:00:00','YYYY/MM/DD HH24:MI:SS'), 2023/05/09 13:36:03 - Update Config Settings - FULL_RELOAD = (CASE WHEN 'Y' = 'Y' THEN 1 2023/05/09 13:36:03 - Update Config Settings - WHEN '2001-07-10 09:04:08' > '1900-01-01 00:00:00' THEN 1 2023/05/09 13:36:03 - Update Config Settings - ELSE 0 END), 2023/05/09 13:36:03 - Update Config Settings - DWH_DIM_PREV_START_DATE = CASE WHEN 'Y' = 'Y' THEN TO_TIMESTAMP('1900/01/01 00:00:00','YYYY/MM/DD HH24:MI:SS') 2023/05/09 13:36:03 - Update Config Settings - ELSE TO_TIMESTAMP('2023/05/09 13:36:00','YYYY/MM/DD HH24:MI:SS') END 2023/05/09 13:36:03 - Update Config Settings - 2023/05/09 13:36:03 - Update Config Settings - ERROR: error de sintaxis en o cerca de «0» Position: 114 null