Message Type Process or Tool Id Details Information -1 Running at a Low Priority. Unknown (17) 15 https://www.googleapis.com/bigquery/v2BigQuerySELECT DISTINCT CAST(a.WEEKENDDATE AS DATE) DATE_VALUE, a.YEAR_WEEK FISCAL_YEAR_WEEK_VALUE, b.HOLIDAY, b.DAY_NUM FROM `us-alteryx-prd-e33c.staging.calendar` a LEFT JOIN (SELECT DISTINCT YEAR_WEEK, HOLIDAY, DAY_NUM FROM `us-alteryx-prd-e33c.staging.calendar` WHERE HOLIDAY IS NOT NULL) b ON a.YEAR_WEEK=b.YEAR_WEEK ORDER BY FISCAL_YEAR_WEEK_VALUE
BigQuery Unknown (101) -1 action:POST URL:http://ususpophyp012:9090/ExoInsight/service Information 7 366 unique records and 0 duplicates were found Unknown (101) -1 action:POST URL:http://ususpophyp012:9090/ExoInsight/service Information 17 1818 unique records and 0 duplicates were found Information 3 1818 records were True and 0 were False Warning 4 The field "Temporary_GM" is missing. Compare the tool configuration with the input stream. Warning 4 The field "Temporary_GM_" is missing. Compare the tool configuration with the input stream. Warning 4 The field "Gross_Margin" is missing. Compare the tool configuration with the input stream. Warning 12 The field "Average_Bill_Rate" is not present in all inputs. Warning 12 The field "Entity" is not present in all inputs. Warning 12 The field "flag_covid" is not present in all inputs. Warning 12 The field "Period" is not present in all inputs. Warning 12 The field "Perm_Fees" is not present in all inputs. Warning 12 The field "Temp_Revenue___IC" is not present in all inputs. Warning 12 The field "Temporary_Billing_GM" is not present in all inputs. Warning 12 The field "Temporary_Billing_GM__" is not present in all inputs. Warning 12 The field "TW" is not present in all inputs. Warning 12 The field "Year" is not present in all inputs. Warning 12 The field "Year Default" is not present in all inputs. Information 10 303 records were joined with 0 un-joined left records and 63 un-joined right records Information 15 2645 records were read from a custom BigQuery Query. Warning 14 The field "Avg_Christmas_Day" is not present in all inputs. Warning 14 The field "Avg_Christmas_Day__Observed_" is not present in all inputs. Warning 14 The field "Avg_Columbus_Day" is not present in all inputs. Warning 14 The field "Avg_Easter" is not present in all inputs. Warning 14 The field "Avg_Independence_Day" is not present in all inputs. Warning 14 The field "Avg_Independence_Day__Observed_" is not present in all inputs. Warning 14 The field "Avg_Labor_Day" is not present in all inputs. Warning 14 The field "Avg_Martin_Luther_King_Jr__Day" is not present in all inputs. Warning 14 The field "Avg_Memorial_Day" is not present in all inputs. Warning 14 The field "Avg_New_Year_s_Day" is not present in all inputs. Warning 14 The field "Avg_New_Year_s_Day__Observed_" is not present in all inputs. Warning 14 The field "Avg_Thanksgiving" is not present in all inputs. Warning 14 The field "Avg_Veterans_Day" is not present in all inputs. Warning 14 The field "Avg_Veterans_Day__Observed_" is not present in all inputs. Warning 14 The field "Avg_Washington_s_Birthday" is not present in all inputs. Warning 14 The field "DATE_VALUE" is not present in all inputs. Warning 14 The field "holiday" is not present in all inputs. Warning 14 The field "Period" is not present in all inputs. Warning 14 The field "Year" is not present in all inputs. Warning 14 The field "Year Default" is not present in all inputs. Information 13 366 records were joined with 0 un-joined left records and 2244 un-joined right records Conversion Error 40 DATETIMEPARSE: Cannot convert "2021-10-08 09:49:06" to a date/time with format "%m/%d/%Y %H:%M:%S" and language "English": Month number is out of range 1..12: '2021-10-08 09:49:06' Conversion Error 40 DATETIMEPARSE: Cannot convert "2021-10-08 10:16:55" to a date/time with format "%m/%d/%Y %H:%M:%S" and language "English": Month number is out of range 1..12: '2021-10-08 10:16:55' Conversion Error 40 DATETIMEPARSE: Cannot convert "2021-10-20 11:55:00" to a date/time with format "%m/%d/%Y %H:%M:%S" and language "English": Month number is out of range 1..12: '2021-10-20 11:55:00' Conversion Error 40 DATETIMEPARSE: Cannot convert "2021-10-21 14:29:12" to a date/time with format "%m/%d/%Y %H:%M:%S" and language "English": Month number is out of range 1..12: '2021-10-21 14:29:12' Conversion Error 40 DATETIMEPARSE: Cannot convert "2021-10-21 14:49:03" to a date/time with format "%m/%d/%Y %H:%M:%S" and language "English": Month number is out of range 1..12: '2021-10-21 14:49:03' Conversion Error 40 DATETIMEPARSE: Cannot convert "2021-10-26 12:07:08" to a date/time with format "%m/%d/%Y %H:%M:%S" and language "English": Month number is out of range 1..12: '2021-10-26 12:07:08' File Input 36 _externals\1\project_log_ris_final.csv|9 records were read from "_externals\1\project_log_ris_final.csv" Information 37 9 records were summarized to 1 groups Information 38 1 records were joined with 0 un-joined left records and 8 un-joined right records Information 16 SUCCESS: reading input data "#1" Information 16 SUCCESS: reading input data "#project" Information 16 SUCCESS: writing outgoing connection data 1 Information 16 SUCCESS: writing outgoing connection data 2 Information 16 SUCCESS: writing outgoing connection data 3 Information 16 SUCCESS: writing outgoing connection data 4 File Output 32 D:\SA_share\corpfin\forecasts\ris_forecasts_2021-10-26.csv|2 records were written to "D:\SA_share\corpfin\forecasts\ris_forecasts_2021-10-26.csv" File Output 33 _externals\1\project_log_ris_final.csv|10 records were written to "_externals\1\project_log_ris_final.csv"