[06/28/2023 13:03:23] loading ul_config ...
[06/28/2023 13:03:26] user_level_l_topic.pl started: custom, 20230628130317, 6738, 42149
[06/28/2023 13:03:26] work_dir: /project/tmp/std_user_level/custom/20230628130317/6738/42149
[06/28/2023 13:03:26] 6738 xxxxx Weekly 31552 6582 42149 xxxxx Newsletter 99175 custom N
[06/28/2023 13:03:26] tactic_name='xxxxx_NR_381703.2'
[06/28/2023 13:03:26] create_ul_target_list
[06/28/2023 13:03:27] SELECT ANALYZE_STATISTICS('UL_TARGET_LIST')
[06/28/2023 13:03:28] fill ul_cohort...
[06/28/2023 13:06:49] 31342 records added
[06/28/2023 13:06:49] starting fill_ul_report_detail...
[06/28/2023 13:06:49] deleting ul_report_detail for REPORT_ID = 6738 and ID = 160497671...
[06/28/2023 13:06:49] 0 records deleted
[06/28/2023 13:06:49] inserting into ul_report_detail for 6738 and ID = 160497671...
[06/28/2023 13:06:49] 1 records added
[06/28/2023 13:06:49] USER
[06/28/2023 13:06:52] ACTION
[06/28/2023 13:06:54] Validating reports...
[06/28/2023 13:06:54] USER: /project/tmp/std_user_level/custom/20230628130317/6738/42149/6738_xxxxx_USER_DATA_20230628130317.txt size=6083513 bytes
[06/28/2023 13:06:54] ACTION: /project/tmp/std_user_level/custom/20230628130317/6738/42149/6738_xxxxx_USER_ACTION_DATA_20230628130317.txt size=10097634 bytes
[06/28/2023 13:06:54] file size validation - passed
[06/28/2023 13:06:55] unique user counts in USER and ACTION - passed
[06/28/2023 13:06:55] QUESTION is not applicable to this product
[06/28/2023 13:06:55] 21050 records in /project/tmp/std_user_level/custom/20230628130317/6738/42149/6738_xxxxx_USER_DATA_20230628130317.txt
[06/28/2023 13:06:55] 31342 records in /project/tmp/std_user_level/custom/20230628130317/6738/42149/6738_xxxxx_USER_ACTION_DATA_20230628130317.txt
[06/28/2023 13:06:55] update ul_run_status...
[06/28/2023 13:06:55] user_level_l_topic.pl ended

[06/28/2023 13:07:03] Connected to v_xxxxx_node0010
[06/28/2023 13:07:03] FILE_STATUS_ID=410508751
[06/28/2023 13:07:03] Load Format Data...
[06/28/2023 13:07:03] Extract report data...
[06/28/2023 13:07:07] Generate data

[06/28/2023 13:07:07] generate_data: Processing format detail 1
[06/28/2023 13:07:07] Metrics=4
[06/28/2023 13:07:08] generate_data: done with format detail 1:User Action Media Data

[06/28/2023 13:07:08] generate_data: Processing format detail 2
[06/28/2023 13:07:08] Metrics=40
[06/28/2023 13:07:22] generate_data: done with format detail 2:User Action Data

[06/28/2023 13:07:22] Generate files

[06/28/2023 13:07:22] generate_file: Processing format detail 1
[06/28/2023 13:07:22] generate_file: done with format detail 1:User Action Media Data

[06/28/2023 13:07:22] generate_file: Processing format detail 2
[06/28/2023 13:07:24] New file: /mnt/xxxxx/PromoUserLevelReporting/xxxxx/xxxxx/custom/xxxxx/6738_xxxxx_USER_LEVEL_20230628130701.txt
[06/28/2023 13:07:27] New file: /mnt/xxxxx/PromoUserLevelReporting/xxxxx/xxxxx/custom/xxxxx/6738_xxxxx_CTL_20230628130701.ctl
[06/28/2023 13:07:27] generate_file: done with format detail 2:User Action Data

[06/28/2023 13:07:27] Moving 2 report files to target dir
[06/28/2023 13:07:27] mv /project/tmp/generate_report_files/20230628130701/6738/104/* '/mnt/xxxxx/PromoUserLevelReporting/xxxxx/xxxxx/custom/xxxxx' 2>>/dev/null
[06/28/2023 13:07:27] generate_report_files.pl ended
#### [06/28/2023 12:56:45] loading ul_config ...
[06/28/2023 12:56:45] user_level_l_topic.pl started: custom, 20230628125643, 6738, 42149
[06/28/2023 12:56:45] work_dir: /project/tmp/std_user_level/custom/20230628125643/6738/42149
[06/28/2023 12:56:45] 6738 xxxxx Weekly 31552 6582 42149 xxxxx Newsletter 99175 custom N
[06/28/2023 12:56:45] tactic_name='xxxxx_NR_381703.2'
[06/28/2023 12:56:45] create_ul_target_list
[06/28/2023 12:56:45] SELECT ANALYZE_STATISTICS('UL_TARGET_LIST')
[06/28/2023 12:56:46] fill ul_cohort...
[06/28/2023 12:59:43] 31342 records added
[06/28/2023 12:59:43] starting fill_ul_report_detail...
[06/28/2023 12:59:43] deleting ul_report_detail for REPORT_ID = 6738 and ID = 160493471...
[06/28/2023 12:59:43] 0 records deleted
[06/28/2023 12:59:43] inserting into ul_report_detail for 6738 and ID = 160493471...
[06/28/2023 12:59:43] 1 records added
[06/28/2023 12:59:43] USER
Wide character in print at UL_VERTICA.pm line 951.
Wide character in print at UL_VERTICA.pm line 951.
Wide character in print at UL_VERTICA.pm line 951.
[06/28/2023 12:59:46] ACTION
[06/28/2023 12:59:49] Validating reports...
[06/28/2023 12:59:49] USER: /project/tmp/std_user_level/custom/20230628125643/6738/42149/6738_xxxxx_USER_DATA_20230628125643.txt size=6083486 bytes
[06/28/2023 12:59:49] ACTION: /project/tmp/std_user_level/custom/20230628125643/6738/42149/6738_xxxxx_USER_ACTION_DATA_20230628125643.txt size=9990561 bytes
[06/28/2023 12:59:49] file size validation - passed
[06/28/2023 12:59:50] unique user counts in USER and ACTION - passed
[06/28/2023 12:59:50] QUESTION is not applicable to this product
[06/28/2023 12:59:50] 21050 records in /project/tmp/std_user_level/custom/20230628125643/6738/42149/6738_xxxxx_USER_DATA_20230628125643.txt
[06/28/2023 12:59:50] 31342 records in /project/tmp/std_user_level/custom/20230628125643/6738/42149/6738_xxxxx_USER_ACTION_DATA_20230628125643.txt
[06/28/2023 12:59:50] update ul_run_status...
[06/28/2023 12:59:50] user_level_l_topic.pl ended

[06/28/2023 13:00:00] Connected to v_xxxxx_node0005
[06/28/2023 13:00:00] FILE_STATUS_ID=410504550
[06/28/2023 13:00:00] Load Format Data...
[06/28/2023 13:00:00] Extract report data...
[06/28/2023 13:00:07] Generate data

[06/28/2023 13:00:07] generate_data: Processing format detail 1
[06/28/2023 13:00:07] Metrics=4
[06/28/2023 13:00:12] generate_data: done with format detail 1:User Action Media Data

[06/28/2023 13:00:12] generate_data: Processing format detail 2
[06/28/2023 13:00:12] Metrics=40
[06/28/2023 13:00:36] generate_data: done with format detail 2:User Action Data

[06/28/2023 13:00:36] Generate files

[06/28/2023 13:00:36] generate_file: Processing format detail 1
[06/28/2023 13:00:37] generate_file: done with format detail 1:User Action Media Data

[06/28/2023 13:00:37] generate_file: Processing format detail 2
[06/28/2023 13:00:38] Error: [Vertica][Support] (50310) Unrecognized ICU conversion error. (SQL-HY000)
[06/28/2023 13:00:38] generate_report_files.pl ended