💬0 Comments

🔥0 Discussions

👤0 Members

🔌0 Online

Options

400 Bad Request error

jgatherc

jgatherc Member Posts: 3

Contributor I

December 2022 in Help

I'm getting the following error when trying to connect to a Google Big Query table.

Connection for GCP_Vista of type 'cloud_connectivity:google-cloud-storage' failed: Could not connect to Google: Error: 400 Bad Request

{

"error": "invalid_grant",

"error_description": "Bad Request"

}

When I tried to refresh the GCP_Vista connection access token, I get the following error:

<?xml version="1.0" encoding="UTF-8"?><process version="9.9.002">

<context>

<input/>

<output/>

<macros/>

</context>

<operator activated="true" class="process" compatibility="9.4.000" expanded="true" name="Process">

<parameter key="logverbosity" value="init"/>

<parameter key="random_seed" value="2001"/>

<parameter key="send_mail" value="never"/>

<parameter key="notification_email" value=""/>

<parameter key="process_duration_for_mail" value="30"/>

<parameter key="encoding" value="SYSTEM"/>

<process expanded="true">

<operator activated="true" class="jdbc_connectors:read_database" compatibility="9.2.001" expanded="true" height="82" name="PVOS" width="90" x="45" y="289">

<parameter key="define_connection" value="repository"/>

<parameter key="connection_entry" value="/Connections/PVOS DB"/>

<parameter key="connection" value="PVOS DB"/>

<parameter key="database_system" value="MySQL"/>

<parameter key="define_query" value="query"/>

<parameter key="query" value="select	distinct
		t1.PVO026_SRC_VIN_R as 'VIN',
		t1.PVO003_PORT_C as 'PVOS_Port',
		t1.PVO002_BRAND_C as 'Brand',
		PVO012_ORDER_TYP_C as 'Order Type',
		case PVO026_SOLD_F
			when 0 then 'Y'
			when 1 then 'N'
		end as 'Sold Flag',
		PVO032_ALLOCATED_DEALER_C as 'Allocated Dealer',
		t3.PVO032_DEALER_N as 'Allocated Dealer Name',
		t1.PVO032_SHIP_TO_DEALER_C as 'Ship To Dealer',
		t4.PVO032_DEALER_N as 'Ship To Dealer Name',
		CURRENT_STATUS as 'Current Status'
from	dbo.NPVO026_VIN_DTL t1 left outer join dbo.NPVO032_DEALER t3
			on t1.PVO032_ALLOCATED_DEALER_C = t3.PVO032_DEALER_C 
		left outer join dbo.VW_VIN_CURRENT_STATUS_NEW t2 
			on t1.PVO026_SRC_VIN_R = t2.PVO026_SRC_VIN_R 
		left outer join	dbo.NPVO032_DEALER t4
			on t1.PVO032_ALLOCATED_DEALER_C = t4.PVO032_DEALER_C
where	t1.PVO003_PORT_C in ('BAL','SSI','NTD') and
		CURRENT_STATUS not in ('LOL','ITR 1','CDD') and
		t1.PVO002_BRAND_C in ('JAG','LR')
order
by		PVO032_ALLOCATED_DEALER_C"/>

<parameter key="use_default_schema" value="true"/>

<parameter key="prepare_statement" value="false"/>

<enumeration key="parameters"/>

<parameter key="datamanagement" value="double_array"/>

<parameter key="data_management" value="auto"/>

</operator>

<operator activated="true" class="retrieve" compatibility="9.9.002" expanded="true" height="68" name="Retrieve GCP_Vista" width="90" x="45" y="34">

<parameter key="repository_entry" value="/Connections/GCP_Vista"/>

</operator>

<operator activated="true" class="in_database_processing:indb_nest" compatibility="9.10.003" expanded="true" height="103" name="GCP (Vista)" width="90" x="246" y="34">

<parameter key="autodetect_SQL_dialect" value="true"/>

<parameter key="SQL_dialect" value="other"/>

<parameter key="parallelize" value="true"/>

<parameter key="parallelization_limit" value="2"/>

<parameter key="parallelization_delay" value="500"/>

<parameter key="allow_all_operators" value="false"/>

<process expanded="true">

<operator activated="true" class="in_database_processing:indb_source" compatibility="9.10.003" expanded="true" height="68" name="Retrieve (In Database)" width="90" x="45" y="85">

<parameter key="schema_name" value="stg_sales_ops"/>

<parameter key="table_name" value="FLAT_VISTA_Transformed"/>

</operator>

<operator activated="true" class="in_database_processing:indb_filter" compatibility="9.10.003" expanded="true" height="68" name="Pre-Loadline Status Filter" width="90" x="246" y="85">

<parameter key="condition_class" value="custom_filters"/>

<parameter key="parameter_expression" value=""/>

<parameter key="replace_square_brackets" value="true"/>

<list key="filters_list">

<parameter key="filters_entry_key" value="Common_Status_Description.equals.Into Port of Entry or Receiving Compound"/>

</list>

<parameter key="filters_logic_and" value="false"/>

<parameter key="filters_check_metadata" value="true"/>

</operator>

<operator activated="true" class="in_database_processing:indb_select" compatibility="9.10.003" expanded="true" height="68" name="Select Attributes (In Database)" width="90" x="447" y="85">

<parameter key="attribute_filter_type" value="subset"/>

<parameter key="attribute" value=""/>

<parameter key="attributes" value="D42_Port_of_Entry|Port|Retailer_Name|RtlrCode|VIN|LastUpdate_VISTA|LastUpdate_PVOS"/>

<parameter key="use_except_expression" value="false"/>

<parameter key="value_type" value="attribute_value"/>

<parameter key="use_value_type_exception" value="false"/>

<parameter key="except_value_type" value="time"/>

<parameter key="block_type" value="attribute_block"/>

<parameter key="use_block_type_exception" value="false"/>

<parameter key="except_block_type" value="value_matrix_row_start"/>

<parameter key="invert_selection" value="false"/>

</operator>

<operator activated="true" class="in_database_processing:indb_rename" compatibility="9.10.003" expanded="true" height="68" name="Rename (In Database)" width="90" x="581" y="85">

<parameter key="old_name" value="Retailer_Name"/>

<parameter key="new_name" value="Vista_Retailer_Name"/>

<list key="rename_additional_attributes">

<parameter key="RtlrCode" value="Vista_Retailer_Code"/>

<parameter key="VIN" value="Vista_VIN"/>

</list>

</operator>

<operator activated="true" class="in_database_processing:indb_generate_attributes" compatibility="9.10.003" expanded="true" height="68" name="Generate Attributes (In Database)" width="90" x="715" y="85">

<list key="function_descriptions">

<parameter key="Vista_Port" value="substr(Port,3,3)"/>

</list>

<parameter key="keep_all" value="true"/>

<parameter key="replace_square_brackets" value="true"/>

</operator>

<connect from_op="Retrieve (In Database)" from_port="example set output" to_op="Pre-Loadline Status Filter" to_port="example set input"/>

<connect from_op="Pre-Loadline Status Filter" from_port="example set output" to_op="Select Attributes (In Database)" to_port="example set input"/>

<connect from_op="Select Attributes (In Database)" from_port="example set output" to_op="Rename (In Database)" to_port="example set input"/>

<connect from_op="Rename (In Database)" from_port="example set output" to_op="Generate Attributes (In Database)" to_port="example set input"/>

<connect from_op="Generate Attributes (In Database)" from_port="example set output" to_port="example set 1"/>

<portSpacing port="sink_example set 1" spacing="0"/>

<portSpacing port="sink_example set 2" spacing="0"/>

</process>

</operator>

<operator activated="true" class="concurrency:join" compatibility="9.8.001" expanded="true" height="82" name="Join" width="90" x="313" y="187">

<parameter key="remove_double_attributes" value="true"/>

<parameter key="join_type" value="inner"/>

<parameter key="use_id_attribute_as_key" value="false"/>

<list key="key_attributes">

<parameter key="Vista_VIN" value="VIN"/>

</list>

<parameter key="keep_both_join_attributes" value="false"/>

</operator>

<operator activated="true" class="filter_examples" compatibility="9.5.001" expanded="true" height="103" name="Filter Examples" width="90" x="447" y="187">

<parameter key="parameter_expression" value="[Allocated Dealer] != Vista_Retailer_Code"/>

<parameter key="condition_class" value="expression"/>

<parameter key="invert_filter" value="false"/>

<list key="filters_list"/>

<parameter key="filters_logic_and" value="true"/>

<parameter key="filters_check_metadata" value="true"/>

</operator>

<operator activated="true" class="write_excel" compatibility="9.2.001" expanded="true" height="103" name="Write Excel" width="90" x="648" y="187">

<parameter key="excel_file" value="C:\Users\jgatherc\Documents\Vista-PVOS Dealer Mismatch 12-26-22.xlsx"/>

<parameter key="file_format" value="xlsx"/>

<enumeration key="sheet_names"/>

<parameter key="sheet_name" value="RapidMiner Data"/>

<parameter key="date_format" value="yyyy-MM-dd HH:mm:ss"/>

<parameter key="number_format" value="#.0"/>

<parameter key="encoding" value="SYSTEM"/>

</operator>

<connect from_op="PVOS" from_port="output" to_op="Join" to_port="right"/>

<connect from_op="Retrieve GCP_Vista" from_port="output" to_op="GCP (Vista)" to_port="connection"/>

<connect from_op="GCP (Vista)" from_port="example set 1" to_op="Join" to_port="left"/>

<connect from_op="Join" from_port="join" to_op="Filter Examples" to_port="example set input"/>

<connect from_op="Filter Examples" from_port="example set output" to_op="Write Excel" to_port="input"/>

<connect from_op="Write Excel" from_port="through" to_port="result 1"/>

<portSpacing port="source_input 1" spacing="0"/>

<portSpacing port="sink_result 1" spacing="0"/>

<portSpacing port="sink_result 2" spacing="0"/>

</process>

</operator>

</process>

0

Sign In or Register to comment.