[06/28/2023 12:56:45] loading ul_config ... <br>
[06/28/2023 12:56:45] user_level_l_topic.pl started: custom, 20230628125643, 6738, 42149 <br>
[06/28/2023 12:56:45] work_dir: /project/tmp/std_user_level/custom/20230628125643/6738/42149 <br>
[06/28/2023 12:56:45] 6738 xxxxx Weekly 31552 6582 42149  xxxxx Newsletter 99175   custom N <br>
[06/28/2023 12:56:45] tactic_name='xxxxx_NR_381703.2' <br>
[06/28/2023 12:56:45] create_ul_target_list <br>
[06/28/2023 12:56:45] SELECT ANALYZE_STATISTICS('UL_TARGET_LIST') <br>
[06/28/2023 12:56:46] fill ul_cohort... <br>
[06/28/2023 12:59:43] 31342  records added <br>
[06/28/2023 12:59:43] starting fill_ul_report_detail... <br>
[06/28/2023 12:59:43] deleting ul_report_detail for REPORT_ID = 6738 and ID = 160493471... <br>
[06/28/2023 12:59:43] 0  records deleted <br>
[06/28/2023 12:59:43] inserting into ul_report_detail for 6738 and ID = 160493471... <br>
[06/28/2023 12:59:43] 1  records added <br>
[06/28/2023 12:59:43] USER <br>
Wide character in print at UL_VERTICA.pm line 951. <br>
Wide character in print at UL_VERTICA.pm line 951. <br>
Wide character in print at UL_VERTICA.pm line 951. <br>
[06/28/2023 12:59:46] ACTION <br>
[06/28/2023 12:59:49] Validating reports... <br>
[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 <br>
[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 <br>
[06/28/2023 12:59:49] file size validation - passed <br>
[06/28/2023 12:59:50] unique user counts in USER and ACTION - passed <br>
[06/28/2023 12:59:50] QUESTION is not applicable to this product <br>
[06/28/2023 12:59:50] 21050 records in /project/tmp/std_user_level/custom/20230628125643/6738/42149/6738_xxxxx_USER_DATA_20230628125643.txt <br>
[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 <br>
[06/28/2023 12:59:50] update ul_run_status... <br>
[06/28/2023 12:59:50] user_level_l_topic.pl ended <br>
 <br>
[06/28/2023 13:00:00] Connected to v_xxxxx_node0005 <br>
[06/28/2023 13:00:00] FILE_STATUS_ID=410504550 <br>
[06/28/2023 13:00:00] Load Format Data... <br>
[06/28/2023 13:00:00] Extract report data... <br>
[06/28/2023 13:00:07] Generate data <br>
 <br>
[06/28/2023 13:00:07] generate_data: Processing format detail 1 <br>
[06/28/2023 13:00:07] Metrics=4 <br>
[06/28/2023 13:00:12] generate_data: done with format detail 1:User Action Media Data <br>
 <br>
[06/28/2023 13:00:12] generate_data: Processing format detail 2 <br>
[06/28/2023 13:00:12] Metrics=40 <br>
[06/28/2023 13:00:36] generate_data: done with format detail 2:User Action Data <br>
 <br>
[06/28/2023 13:00:36] Generate files <br>
 <br>
[06/28/2023 13:00:36] generate_file: Processing format detail 1 <br>
[06/28/2023 13:00:37] generate_file: done with format detail 1:User Action Media Data <br>
 <br>
[06/28/2023 13:00:37] generate_file: Processing format detail 2 <br>
[06/28/2023 13:00:38] Error: [Vertica][Support] (50310) Unrecognized ICU conversion error. (SQL-HY000) <br>
[06/28/2023 13:00:38] generate_report_files.pl ended <br>