2020-10-23 01:00:01.351 CDT [27817] FATAL: database "egroves" does not exist 2020-10-23 08:14:24.578 CDT [64448] ERROR: column "part_number" does not exist at character 33 2020-10-23 08:14:24.578 CDT [64448] HINT: Perhaps you meant to reference the column "ad_item_info.ad_part_number". 2020-10-23 08:14:24.578 CDT [64448] STATEMENT: select* from ad_item_info where part_number = '' and publish = 'Y' 2020-10-23 10:39:01.786 CDT [45509] ERROR: invalid input syntax for type integer: "" 2020-10-23 10:39:01.786 CDT [45509] STATEMENT: SELECT customer_p21.customer_id, customer_p21.customer_name, customer_p21.company_id, customer_p21.mail_address1, customer_p21.mail_address2, customer_p21.mail_address3, customer_p21.mail_city, customer_p21.mail_state, customer_p21.mail_zip, customer_p21.sales_rep_id, customer_p21.currency_desc, customer_p21.mail_country, customer_web_data.customer_uid, COALESCE(integrations.taker_id,customer_web_data.taker_id) AS taker_id, customer_web_data.email_invoices_to, customer_web_data.integrations_customer, customer_web_data.ariba_network_id, customer_p21.currency_id, customer_web_data.punch_out_enabled, customer_web_data.punch_out_type, customer_web_data.hook_url, customer_web_data.display_logo_flag, customer_web_data.customer_logo_image, crib_info.ship_to_id, crib_info.contract_no, crib_info.sales_location_id, crib_info.source_location_id, crib_info.order_pricing_method, crib_info.usage_pricing_method, COALESCE(crib_info.contact_id, 1109) AS contact_id, crib_info.use_customer_po, customer_p21.legacy_id, crib_info.import_file_type, crib_info.confirmation_email_address, COALESCE(integrations.taker_email_address, groves_users.email_address) AS taker_email_address, crib_info.import_approved FROM customer_p21 LEFT JOIN customer_web_data ON customer_p21.customer_id = customer_web_data.customer_id AND customer_p21.company_id = customer_web_data.company_id LEFT JOIN integrations ON integrations.customer_id = customer_p21.customer_id AND integrations.integration_status = 'ACTIVE' LEFT JOIN crib_info ON crib_info.integration_id = integrations.integration_id AND crib_status = 'ACTIVE' AND crib_info.delete_flag = 'N' LEFT JOIN groves_users ON groves_users.taker_id = customer_web_data.taker_id WHERE customer_p21.delete_flag = 'N' AND customer_p21.customer_id = $1 2020-10-23 10:39:01.806 CDT [45509] ERROR: invalid input syntax for type integer: "" 2020-10-23 10:39:01.806 CDT [45509] STATEMENT: SELECT source_location_id FROM source_location_overrides where customer_id = $1 and item_id = $2 2020-10-23 10:39:01.833 CDT [45509] ERROR: invalid input syntax for type integer: "" 2020-10-23 10:39:01.833 CDT [45509] STATEMENT: INSERT INTO order_header ( username, customer_id, customer_name, customer_po_number, taker_id, ship_instructions_1, ship_instructions_2, order_date, email_address, ship_to_name, ship_to_addr1, ship_to_addr2, ship_to_city, ship_to_state, ship_to_zip, bill_to_name, bill_to_addr1, bill_to_addr2, bill_to_city, bill_to_state, bill_to_zip, status, payment_method, cc_type, cc_owner, cc_number, cc_expires_month, cc_expires_year, consignment_replenishment_order, po_order, ship_to_number, contact_id, contact_name, contract_id, approved, ship_to_addr3, location_id, shipping_method_id, company_id, consignment_usage_order, sales_location_id, source_location_id ) VALUES ( $1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, '\x', '\x', '\x', $26, $27, $28, $29, $30, $31, $32, $33, $34, $35, $36, $37, $38, $39 )