2020-10-20 01:00:01.934 CDT [61079] FATAL: database "egroves" does not exist
2020-10-20 11:39:37.195 CDT [40638] ERROR: invalid input syntax for type integer: "undefined"
2020-10-20 11:39:37.195 CDT [40638] STATEMENT: select * from "cms_literature" where "cms_literature"."literature_uid" = $1 limit 1
2020-10-20 11:49:46.994 CDT [46449] ERROR: invalid input syntax for type integer: "undefined"
2020-10-20 11:49:46.994 CDT [46449] STATEMENT: select * from "cms_literature" where "cms_literature"."literature_uid" = $1 limit 1
2020-10-20 11:50:07.042 CDT [46823] ERROR: invalid input syntax for type integer: "undefined"
2020-10-20 11:50:07.042 CDT [46823] STATEMENT: select * from "cms_literature" where "cms_literature"."literature_uid" = $1 limit 1
2020-10-20 12:52:03.939 CDT [21476] ERROR: invalid byte sequence for encoding "UTF8": 0xca 0x1a
2020-10-20 12:52:03.939 CDT [21476] 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-20 12:52:03.998 CDT [21476] ERROR: invalid byte sequence for encoding "UTF8": 0xc1 0x12
2020-10-20 12:52:04.027 CDT [21476] ERROR: invalid byte sequence for encoding "UTF8": 0xca 0x1a
2020-10-20 12:52:04.027 CDT [21476] 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 )
2020-10-20 12:52:04.124 CDT [21476] ERROR: invalid byte sequence for encoding "UTF8": 0xd0 0xcf
2020-10-20 12:52:04.124 CDT [21476] 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 )
2020-10-20 12:52:04.149 CDT [21476] ERROR: invalid byte sequence for encoding "UTF8": 0xf5 0x16
2020-10-20 12:52:04.149 CDT [21476] 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 )
2020-10-20 12:52:04.308 CDT [21476] ERROR: invalid byte sequence for encoding "UTF8": 0xa4
2020-10-20 12:52:04.308 CDT [21476] 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 )
2020-10-20 12:52:04.311 CDT [21476] ERROR: invalid byte sequence for encoding "UTF8": 0xf3 0x34 0xa0 0x3a
2020-10-20 12:52:04.321 CDT [21476] ERROR: invalid byte sequence for encoding "UTF8": 0xd8 0x46
2020-10-20 12:52:04.321 CDT [21476] 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 )
2020-10-20 12:52:04.345 CDT [21476] ERROR: invalid byte sequence for encoding "UTF8": 0x8d
2020-10-20 12:52:04.345 CDT [21476] 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 )
2020-10-20 12:52:04.366 CDT [21476] ERROR: invalid byte sequence for encoding "UTF8": 0xbe
2020-10-20 12:52:04.366 CDT [21476] 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 )
2020-10-20 12:52:04.386 CDT [21476] ERROR: invalid byte sequence for encoding "UTF8": 0xb1
2020-10-20 12:52:04.386 CDT [21476] 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 )
2020-10-20 12:52:04.405 CDT [21476] ERROR: invalid byte sequence for encoding "UTF8": 0x9d
2020-10-20 12:52:04.405 CDT [21476] 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 )
2020-10-20 12:52:04.424 CDT [21476] ERROR: invalid byte sequence for encoding "UTF8": 0xa8
2020-10-20 12:52:04.424 CDT [21476] 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 )
2020-10-20 12:52:04.445 CDT [21476] ERROR: invalid byte sequence for encoding "UTF8": 0x93
2020-10-20 12:52:04.445 CDT [21476] 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 )
2020-10-20 12:52:04.465 CDT [21476] ERROR: invalid byte sequence for encoding "UTF8": 0x83
2020-10-20 12:52:04.465 CDT [21476] 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 )
2020-10-20 12:52:04.485 CDT [21476] ERROR: invalid byte sequence for encoding "UTF8": 0xaf
2020-10-20 12:52:04.485 CDT [21476] 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 )
2020-10-20 12:52:04.505 CDT [21476] ERROR: invalid byte sequence for encoding "UTF8": 0xc4 0xce
2020-10-20 12:52:04.505 CDT [21476] 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 )
2020-10-20 12:52:04.524 CDT [21476] ERROR: invalid byte sequence for encoding "UTF8": 0x94
2020-10-20 12:52:04.524 CDT [21476] 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 )
2020-10-20 12:52:04.544 CDT [21476] ERROR: invalid byte sequence for encoding "UTF8": 0xb5
2020-10-20 12:52:04.544 CDT [21476] 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 )
2020-10-20 12:52:04.564 CDT [21476] ERROR: invalid byte sequence for encoding "UTF8": 0xf5 0x11 0xe1 0x61
2020-10-20 12:52:04.564 CDT [21476] 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 )
2020-10-20 12:52:04.586 CDT [21476] ERROR: invalid byte sequence for encoding "UTF8": 0xf1
2020-10-20 12:52:04.586 CDT [21476] 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 )
2020-10-20 12:52:04.605 CDT [21476] ERROR: invalid byte sequence for encoding "UTF8": 0x8b
2020-10-20 12:52:04.605 CDT [21476] 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 )
2020-10-20 12:52:04.607 CDT [21476] ERROR: invalid byte sequence for encoding "UTF8": 0x85
2020-10-20 12:52:04.614 CDT [21476] ERROR: invalid byte sequence for encoding "UTF8": 0xb4
2020-10-20 12:52:04.614 CDT [21476] 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 )
2020-10-20 12:52:04.616 CDT [21476] ERROR: invalid byte sequence for encoding "UTF8": 0xba
2020-10-20 12:52:04.624 CDT [21476] ERROR: invalid byte sequence for encoding "UTF8": 0xf6 0xc2 0x20 0xf5
2020-10-20 12:52:04.624 CDT [21476] 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 )
2020-10-20 12:52:04.643 CDT [21476] ERROR: invalid byte sequence for encoding "UTF8": 0xb6
2020-10-20 12:52:04.643 CDT [21476] 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 )
2020-10-20 12:52:04.664 CDT [21476] ERROR: invalid byte sequence for encoding "UTF8": 0xa6
2020-10-20 12:52:04.664 CDT [21476] 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 )
2020-10-20 12:52:04.704 CDT [21476] ERROR: invalid byte sequence for encoding "UTF8": 0xa8
2020-10-20 12:52:04.704 CDT [21476] 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 )
2020-10-20 12:52:04.706 CDT [21476] ERROR: invalid byte sequence for encoding "UTF8": 0xc7 0x71
2020-10-20 12:52:04.728 CDT [21476] ERROR: invalid byte sequence for encoding "UTF8": 0xe9 0x64 0x34
2020-10-20 12:52:04.728 CDT [21476] 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 )
2020-10-20 12:52:04.730 CDT [21476] ERROR: invalid byte sequence for encoding "UTF8": 0xaa
2020-10-20 12:52:04.738 CDT [21476] ERROR: invalid byte sequence for encoding "UTF8": 0xbd
2020-10-20 12:52:04.738 CDT [21476] 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 )
2020-10-20 12:52:04.757 CDT [21476] ERROR: invalid byte sequence for encoding "UTF8": 0xe1 0x63 0xf3
2020-10-20 12:52:04.757 CDT [21476] 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 )
2020-10-20 12:52:04.776 CDT [21476] ERROR: invalid byte sequence for encoding "UTF8": 0x95
2020-10-20 12:52:04.776 CDT [21476] 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 )
2020-10-20 12:52:04.797 CDT [21476] ERROR: invalid byte sequence for encoding "UTF8": 0xac
2020-10-20 12:52:04.797 CDT [21476] 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 )
2020-10-20 12:52:04.817 CDT [21476] ERROR: invalid byte sequence for encoding "UTF8": 0xa1
2020-10-20 12:52:04.817 CDT [21476] 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 )
2020-10-20 12:52:04.838 CDT [21476] ERROR: invalid byte sequence for encoding "UTF8": 0x81
2020-10-20 12:52:04.838 CDT [21476] 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 )
2020-10-20 12:52:04.840 CDT [21476] ERROR: invalid byte sequence for encoding "UTF8": 0xdd 0x3f
2020-10-20 12:52:04.849 CDT [21476] ERROR: invalid byte sequence for encoding "UTF8": 0xaa
2020-10-20 12:52:04.849 CDT [21476] 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 )
2020-10-20 12:52:04.851 CDT [21476] ERROR: invalid byte sequence for encoding "UTF8": 0xcf 0x06
2020-10-20 12:52:04.859 CDT [21476] ERROR: invalid byte sequence for encoding "UTF8": 0x81
2020-10-20 12:52:04.859 CDT [21476] 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 )
2020-10-20 12:52:04.881 CDT [21476] ERROR: invalid byte sequence for encoding "UTF8": 0xdd 0xcf
2020-10-20 12:52:04.881 CDT [21476] 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 )
2020-10-20 12:52:04.903 CDT [21476] ERROR: invalid byte sequence for encoding "UTF8": 0xaf
2020-10-20 12:52:04.903 CDT [21476] 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 )
2020-10-20 12:52:04.924 CDT [21476] ERROR: invalid byte sequence for encoding "UTF8": 0xf8
2020-10-20 12:52:04.924 CDT [21476] 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 )
2020-10-20 12:52:04.945 CDT [21476] ERROR: invalid byte sequence for encoding "UTF8": 0x8a
2020-10-20 12:52:04.945 CDT [21476] 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 )
2020-10-20 12:52:04.947 CDT [21476] ERROR: invalid byte sequence for encoding "UTF8": 0xc2 0x40
2020-10-20 12:52:04.955 CDT [21476] ERROR: invalid byte sequence for encoding "UTF8": 0xe1 0x25 0xd9
2020-10-20 12:52:04.955 CDT [21476] 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 )
2020-10-20 12:52:04.963 CDT [21476] ERROR: unterminated quoted string at or near "'" at character 111
2020-10-20 12:52:04.963 CDT [21476] STATEMENT: SELECT COALESCE(NULLIF(short_desc, ''), item_desc_p21) AS item_desc
FROM ad_item_info
WHERE item_id = '
2020-10-20 12:52:04.971 CDT [21476] ERROR: invalid byte sequence for encoding "UTF8": 0xcc 0x12
2020-10-20 12:52:04.971 CDT [21476] 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 )
2020-10-20 12:52:04.991 CDT [21476] ERROR: invalid byte sequence for encoding "UTF8": 0xc1 0xce
2020-10-20 12:52:04.991 CDT [21476] 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 )
2020-10-20 12:52:04.994 CDT [21476] ERROR: invalid byte sequence for encoding "UTF8": 0x98
2020-10-20 12:52:05.016 CDT [21476] ERROR: invalid byte sequence for encoding "UTF8": 0xa2
2020-10-20 12:52:05.016 CDT [21476] 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 )
2020-10-20 12:52:05.018 CDT [21476] ERROR: invalid byte sequence for encoding "UTF8": 0xcf 0x75
2020-10-20 12:52:05.040 CDT [21476] ERROR: invalid byte sequence for encoding "UTF8": 0xcb 0x46
2020-10-20 12:52:05.040 CDT [21476] 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 )
2020-10-20 12:52:05.062 CDT [21476] ERROR: invalid byte sequence for encoding "UTF8": 0xe6 0x46 0xef
2020-10-20 12:52:05.062 CDT [21476] 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 )
2020-10-20 12:52:05.083 CDT [21476] ERROR: invalid byte sequence for encoding "UTF8": 0xa7
2020-10-20 12:52:05.083 CDT [21476] 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 )
2020-10-20 12:52:05.106 CDT [21476] ERROR: invalid byte sequence for encoding "UTF8": 0xaf
2020-10-20 12:52:05.106 CDT [21476] 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 )
2020-10-20 12:52:05.127 CDT [21476] ERROR: invalid byte sequence for encoding "UTF8": 0xf9
2020-10-20 12:52:05.127 CDT [21476] 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 )
2020-10-20 12:52:05.148 CDT [21476] ERROR: invalid byte sequence for encoding "UTF8": 0xa2
2020-10-20 12:52:05.148 CDT [21476] 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 )
2020-10-20 12:52:05.168 CDT [21476] ERROR: invalid byte sequence for encoding "UTF8": 0x81
2020-10-20 12:52:05.168 CDT [21476] 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 )
2020-10-20 12:52:05.190 CDT [21476] ERROR: invalid byte sequence for encoding "UTF8": 0xae
2020-10-20 12:52:05.190 CDT [21476] 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 )
2020-10-20 12:52:05.211 CDT [21476] ERROR: invalid byte sequence for encoding "UTF8": 0xad
2020-10-20 12:52:05.211 CDT [21476] 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 )
2020-10-20 12:52:05.239 CDT [21476] ERROR: invalid byte sequence for encoding "UTF8": 0xf9
2020-10-20 12:52:05.239 CDT [21476] 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 )
2020-10-20 12:52:05.260 CDT [21476] ERROR: invalid byte sequence for encoding "UTF8": 0xf5 0x5b 0xb4 0x4a
2020-10-20 12:52:05.260 CDT [21476] 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 )
2020-10-20 12:52:05.280 CDT [21476] ERROR: invalid byte sequence for encoding "UTF8": 0xee 0x5e 0x29
2020-10-20 12:52:05.280 CDT [21476] 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 )
2020-10-20 12:52:05.301 CDT [21476] ERROR: invalid byte sequence for encoding "UTF8": 0xb7
2020-10-20 12:52:05.301 CDT [21476] 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 )
2020-10-20 12:52:05.323 CDT [21476] ERROR: invalid byte sequence for encoding "UTF8": 0xee 0x24 0x4a
2020-10-20 12:52:05.323 CDT [21476] 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 )
2020-10-20 12:52:05.325 CDT [21476] ERROR: invalid byte sequence for encoding "UTF8": 0xcf 0x4a
2020-10-20 12:52:05.373 CDT [21476] ERROR: invalid byte sequence for encoding "UTF8": 0xcf 0x4a
2020-10-20 12:52:05.373 CDT [21476] STATEMENT: INSERT INTO order_lines ( order_id, line_number, item_id, item_description, quantity, price,
unit_of_measure, contract_id, manual_price_override, crib_no, bin_no, extended_desc,
gl_code, po_line_no, package_qty, package_id, unit_code, customer_part_number, department )
VALUES ( $1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19 )
2020-10-20 12:52:05.396 CDT [21476] ERROR: invalid byte sequence for encoding "UTF8": 0x9e
2020-10-20 12:52:05.396 CDT [21476] 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 )
2020-10-20 12:52:05.398 CDT [21476] ERROR: invalid byte sequence for encoding "UTF8": 0x87
2020-10-20 12:52:05.405 CDT [21476] ERROR: invalid byte sequence for encoding "UTF8": 0xaa
2020-10-20 12:52:05.405 CDT [21476] 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 )
2020-10-20 12:52:05.407 CDT [21476] ERROR: invalid byte sequence for encoding "UTF8": 0xe8 0xe8 0x48
2020-10-20 12:52:05.429 CDT [21476] ERROR: invalid byte sequence for encoding "UTF8": 0x96
2020-10-20 12:52:05.429 CDT [21476] 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 )
2020-10-20 12:52:05.451 CDT [21476] ERROR: invalid byte sequence for encoding "UTF8": 0xc2 0x6b
2020-10-20 12:52:05.451 CDT [21476] 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 )
2020-10-20 12:52:05.473 CDT [21476] ERROR: invalid byte sequence for encoding "UTF8": 0x85
2020-10-20 12:52:05.473 CDT [21476] 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 )
2020-10-20 12:52:05.475 CDT [21476] ERROR: invalid byte sequence for encoding "UTF8": 0xbe
2020-10-20 12:52:05.484 CDT [21476] ERROR: invalid byte sequence for encoding "UTF8": 0x84
2020-10-20 12:52:05.484 CDT [21476] 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 )
2020-10-20 12:52:05.506 CDT [21476] ERROR: invalid byte sequence for encoding "UTF8": 0xdb 0x2f
2020-10-20 12:52:05.506 CDT [21476] 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 )
2020-10-20 12:52:05.540 CDT [21476] ERROR: invalid byte sequence for encoding "UTF8": 0xf1 0xa6 0xa1 0xef
2020-10-20 12:52:05.540 CDT [21476] 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 )
2020-10-20 12:52:05.562 CDT [21476] ERROR: invalid byte sequence for encoding "UTF8": 0xff
2020-10-20 12:52:05.562 CDT [21476] 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 )
2020-10-20 12:52:05.584 CDT [21476] ERROR: invalid byte sequence for encoding "UTF8": 0x92
2020-10-20 12:52:05.584 CDT [21476] 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 )
2020-10-20 12:52:05.586 CDT [21476] ERROR: invalid byte sequence for encoding "UTF8": 0xc1 0x53
2020-10-20 12:52:05.597 CDT [21476] ERROR: invalid byte sequence for encoding "UTF8": 0xe7 0xc7 0x78
2020-10-20 12:52:05.597 CDT [21476] 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-20 12:52:05.609 CDT [21476] ERROR: invalid byte sequence for encoding "UTF8": 0xb1
2020-10-20 12:52:05.609 CDT [21476] 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 )
2020-10-20 12:52:05.611 CDT [21476] ERROR: invalid byte sequence for encoding "UTF8": 0xbd
2020-10-20 12:52:05.620 CDT [21476] ERROR: invalid byte sequence for encoding "UTF8": 0xe7 0xc7 0x78
2020-10-20 12:52:05.620 CDT [21476] 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 )
2020-10-20 12:52:05.643 CDT [21476] ERROR: invalid byte sequence for encoding "UTF8": 0xe4 0x6d 0xe5
2020-10-20 12:52:05.643 CDT [21476] 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 )
2020-10-20 12:52:05.645 CDT [21476] ERROR: invalid byte sequence for encoding "UTF8": 0x97
2020-10-20 12:52:05.670 CDT [21476] ERROR: invalid byte sequence for encoding "UTF8": 0xcd 0x23
2020-10-20 12:52:05.670 CDT [21476] 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 )
2020-10-20 12:52:05.694 CDT [21476] ERROR: invalid byte sequence for encoding "UTF8": 0x9d
2020-10-20 12:52:05.694 CDT [21476] 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 )
2020-10-20 12:52:05.718 CDT [21476] ERROR: invalid byte sequence for encoding "UTF8": 0xc1 0xb8
2020-10-20 12:52:05.718 CDT [21476] 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 )
2020-10-20 12:52:05.741 CDT [21476] ERROR: invalid byte sequence for encoding "UTF8": 0xdd
2020-10-20 12:52:05.741 CDT [21476] 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 )
2020-10-20 12:52:05.743 CDT [21476] ERROR: invalid byte sequence for encoding "UTF8": 0xce 0x2a
2020-10-20 12:52:05.766 CDT [21476] ERROR: invalid byte sequence for encoding "UTF8": 0xa1
2020-10-20 12:52:05.766 CDT [21476] 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 )
2020-10-20 12:52:05.788 CDT [21476] ERROR: invalid byte sequence for encoding "UTF8": 0xb1
2020-10-20 12:52:05.788 CDT [21476] 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 )
2020-10-20 12:52:05.809 CDT [21476] ERROR: invalid byte sequence for encoding "UTF8": 0xa3
2020-10-20 12:52:05.809 CDT [21476] 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 )
2020-10-20 12:52:05.838 CDT [21476] ERROR: invalid byte sequence for encoding "UTF8": 0x86
2020-10-20 12:52:05.838 CDT [21476] 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 )
2020-10-20 12:52:05.858 CDT [21476] ERROR: invalid byte sequence for encoding "UTF8": 0xcd 0x07
2020-10-20 12:52:05.914 CDT [21476] ERROR: invalid byte sequence for encoding "UTF8": 0xa0
2020-10-20 12:52:05.914 CDT [21476] 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 )
2020-10-20 12:52:05.948 CDT [21476] ERROR: invalid byte sequence for encoding "UTF8": 0x87
2020-10-20 12:52:05.948 CDT [21476] 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 )
2020-10-20 12:52:05.974 CDT [21476] ERROR: invalid byte sequence for encoding "UTF8": 0xfc
2020-10-20 12:52:05.974 CDT [21476] 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 )
2020-10-20 12:52:05.997 CDT [21476] ERROR: invalid byte sequence for encoding "UTF8": 0xf7 0x4c 0x6b 0x49
2020-10-20 12:52:05.997 CDT [21476] 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 )
2020-10-20 12:52:06.021 CDT [21476] ERROR: invalid byte sequence for encoding "UTF8": 0xc8 0x0e
2020-10-20 12:52:06.021 CDT [21476] 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 )
2020-10-20 12:52:06.023 CDT [21476] ERROR: invalid byte sequence for encoding "UTF8": 0xc9 0xf6
2020-10-20 12:52:06.048 CDT [21476] ERROR: invalid byte sequence for encoding "UTF8": 0x82
2020-10-20 12:52:06.048 CDT [21476] 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 )
2020-10-20 12:52:06.051 CDT [21476] ERROR: invalid byte sequence for encoding "UTF8": 0x91
2020-10-20 12:52:06.069 CDT [21476] ERROR: invalid byte sequence for encoding "UTF8": 0xd8 0x12
2020-10-20 12:52:06.069 CDT [21476] 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 )
2020-10-20 12:52:06.091 CDT [21476] ERROR: invalid byte sequence for encoding "UTF8": 0xd1 0xe6
2020-10-20 12:52:06.091 CDT [21476] 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 )
2020-10-20 12:52:06.114 CDT [21476] ERROR: invalid byte sequence for encoding "UTF8": 0xaf
2020-10-20 12:52:06.114 CDT [21476] 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 )
2020-10-20 12:52:06.135 CDT [21476] ERROR: invalid byte sequence for encoding "UTF8": 0xa2
2020-10-20 12:52:06.135 CDT [21476] 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 )
2020-10-20 12:52:06.157 CDT [21476] ERROR: invalid byte sequence for encoding "UTF8": 0xce 0x53
2020-10-20 12:52:06.157 CDT [21476] 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 )
2020-10-20 12:52:06.180 CDT [21476] ERROR: invalid byte sequence for encoding "UTF8": 0x8f
2020-10-20 12:52:06.180 CDT [21476] 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 )
2020-10-20 12:52:06.200 CDT [21476] ERROR: invalid byte sequence for encoding "UTF8": 0xce 0xe4
2020-10-20 12:52:06.200 CDT [21476] 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 )
2020-10-20 12:52:06.219 CDT [21476] ERROR: invalid byte sequence for encoding "UTF8": 0x8e
2020-10-20 12:52:06.219 CDT [21476] 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 )
2020-10-20 12:52:06.245 CDT [21476] ERROR: invalid byte sequence for encoding "UTF8": 0x92
2020-10-20 12:52:06.245 CDT [21476] 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 )
2020-10-20 12:52:06.264 CDT [21476] ERROR: invalid byte sequence for encoding "UTF8": 0xd3 0xef
2020-10-20 12:52:06.264 CDT [21476] 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 )
2020-10-20 12:52:06.283 CDT [21476] ERROR: invalid byte sequence for encoding "UTF8": 0xa7
2020-10-20 12:52:06.283 CDT [21476] 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 )
2020-10-20 12:52:06.284 CDT [21476] ERROR: invalid byte sequence for encoding "UTF8": 0xc5 0xec
2020-10-20 12:52:06.352 CDT [21476] ERROR: invalid byte sequence for encoding "UTF8": 0xce 0xfc
2020-10-20 12:52:06.352 CDT [21476] 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 )
2020-10-20 12:52:06.372 CDT [21476] ERROR: invalid byte sequence for encoding "UTF8": 0xa2
2020-10-20 12:52:06.372 CDT [21476] 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 )
2020-10-20 12:52:06.390 CDT [21476] ERROR: invalid byte sequence for encoding "UTF8": 0xfd
2020-10-20 12:52:06.390 CDT [21476] 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 )
2020-10-20 12:52:06.409 CDT [21476] ERROR: invalid byte sequence for encoding "UTF8": 0xbc
2020-10-20 12:52:06.409 CDT [21476] 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 )
2020-10-20 12:52:06.428 CDT [21476] ERROR: invalid byte sequence for encoding "UTF8": 0xd9 0x76
2020-10-20 12:52:06.428 CDT [21476] 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 )
2020-10-20 12:52:06.447 CDT [21476] ERROR: invalid byte sequence for encoding "UTF8": 0x97
2020-10-20 12:52:06.447 CDT [21476] 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 )
2020-10-20 12:52:06.465 CDT [21476] ERROR: invalid byte sequence for encoding "UTF8": 0xe6 0x1f 0x56
2020-10-20 12:52:06.465 CDT [21476] 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 )
2020-10-20 12:52:06.484 CDT [21476] ERROR: invalid byte sequence for encoding "UTF8": 0xa3
2020-10-20 12:52:06.484 CDT [21476] 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 )
2020-10-20 12:52:06.506 CDT [21476] ERROR: invalid byte sequence for encoding "UTF8": 0xba
2020-10-20 12:52:06.506 CDT [21476] 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 )
2020-10-20 12:52:06.528 CDT [21476] ERROR: invalid byte sequence for encoding "UTF8": 0xa1
2020-10-20 12:52:06.528 CDT [21476] 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 )
2020-10-20 12:52:06.546 CDT [21476] ERROR: invalid byte sequence for encoding "UTF8": 0xb1
2020-10-20 12:52:06.546 CDT [21476] 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 )
2020-10-20 12:52:06.564 CDT [21476] ERROR: invalid byte sequence for encoding "UTF8": 0x98
2020-10-20 12:52:06.564 CDT [21476] 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 )
2020-10-20 12:52:06.584 CDT [21476] ERROR: invalid byte sequence for encoding "UTF8": 0x86
2020-10-20 12:52:06.584 CDT [21476] 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 )
2020-10-20 12:52:06.606 CDT [21476] ERROR: invalid byte sequence for encoding "UTF8": 0x8b
2020-10-20 12:52:06.606 CDT [21476] 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 )
2020-10-20 12:52:06.625 CDT [21476] ERROR: invalid byte sequence for encoding "UTF8": 0xe6 0xe9 0x79
2020-10-20 12:52:06.625 CDT [21476] 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 )
2020-10-20 12:52:06.645 CDT [21476] ERROR: invalid byte sequence for encoding "UTF8": 0xa9
2020-10-20 12:52:06.645 CDT [21476] 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 )
2020-10-20 12:52:06.665 CDT [21476] ERROR: invalid byte sequence for encoding "UTF8": 0xa8
2020-10-20 12:52:06.665 CDT [21476] 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 )
2020-10-20 12:52:06.684 CDT [21476] ERROR: invalid byte sequence for encoding "UTF8": 0xa2
2020-10-20 12:52:06.684 CDT [21476] 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 )
2020-10-20 12:52:06.686 CDT [21476] ERROR: invalid byte sequence for encoding "UTF8": 0xf6 0x70 0x43 0x35
2020-10-20 12:52:06.708 CDT [21476] ERROR: invalid byte sequence for encoding "UTF8": 0xbc
2020-10-20 12:52:06.708 CDT [21476] 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 )
2020-10-20 12:52:06.726 CDT [21476] ERROR: invalid byte sequence for encoding "UTF8": 0xaf
2020-10-20 12:52:06.726 CDT [21476] 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 )
2020-10-20 22:03:58.495 CDT [15342] ERROR: duplicate key value violates unique constraint "p21_item_pkey"
2020-10-20 22:03:58.495 CDT [15342] DETAIL: Key (item_id)=(DRK 04578) already exists.
2020-10-20 22:03:58.495 CDT [15342] STATEMENT: INSERT INTO p21_item( item_id, inv_mast_uid, ad_part_number, heading, manufacturer_part_number,
manufacturer_name, brand_name, category_name_level_1, category_name_level_2, category_name_level_3, category_name_level_4,
category_name_level_5, category_name_level_6, item_desc_p21, extended_desc_p21, long_desc, short_desc, item_keywords,
company_id, p21_default_sales_unit, standard_cost, price2, p21_weight, sales_pricing_unit_size,
benefits_and_features, publish, unspsc_code, marketing_desc, p21_item_desc, ad_item_id, package_description,
alternate_part_number1, alternate_part_number2, upc_code, country_of_origin, item_length, length_uom, item_height,
height_uom, item_width, width_uom, item_weight, weight_uom, item_volume, volume_uom, category_code, category_name,
category_code_level_1, category_code_level_2, category_code_level_3, category_code_level_4, category_code_level_5,
category_code_level_6, invoice_desc, product_name, product_group, item_image_1, item_detail_image_1, item_enlarged_image_1,
item_image_type_1, item_image_2, item_detail_image_2, item_enlarged_image_2, item_image_type_2, item_image_3,
item_detail_image_3, item_enlarged_image_3, item_image_type_3, item_image_4, item_detail_image_4,
item_enlarged_image_4, item_image_type_4, item_image_5, item_detail_image_5, item_enlarged_image_5,
item_image_type_5, item_document_name_1, item_document_type_1, item_document_caption_1,
item_document_name_2, item_document_type_2, item_document_caption_2, item_document_name_3, item_document_type_3,
item_document_caption_3, item_document_name_4, item_document_type_4, item_document_caption_4, item_document_name_5,
item_document_type_5, item_document_caption_5, item_application, manufacturer_status, manufacturer_id,
brand_id, long_desc2, gtin, grainger_part_no, qty_available, default_price_family_uid, original_price) VALUES ('DRK 04578', '5973', 'FS_00202', 'Vanish® 90158', '90158', 'Sealed Air',
'Vanish®', 'Chemicals', 'Cleaners', 'Bathroom, Tile & Toilet Cleaners', '',
'', '', 'TOILET BOWL CLEANER', 'VANISH BOWL CLEANER (ACID) 32-OZ., 12/CS (REPLACED OBSOLETE 90158)', 'Vanish® Bowl and Bathroom Cleaner, Non-Acid, 32 oz Container, Trigger Spray Bottle Container, Liquid Form, Fresh Odor/Scent, Clear Blue, 2% VOC, 6.5 to 7.5 pH, 1 Specific Gravity, Composition: n-Alkyl Dimethyl Benzyl Ammonium Chloride, Isopropyl Alcohol', 'Vanish® 90158 Non-Acid Bowl and Bathroom Cleaner, 32 oz Trigger Spray Bottle, Liquid Form, Fresh Odor/Scent, Clear Blue',
'90158 Non-Acid Bowl and Bathroom Cleaner, 32 oz Trigger Spray Bottle, Liquid Form, Fresh Odor/Scent, Clear Blue ; Sealed Air ; Vanish ; 90158 ; 15200148 ; 019800901585 ; Bathroom, Tile & Toilet Cleaners', 'GROVES', 'EA', '2.3460', '4.1200', '2.400000000000',
'1.0000', '• Cleans and disinfects in one step
• Powerful quaternary detergent thickened liquid for toilet bowls, urinals and general purpose bathroom cleaning and disinfecting
• Bactericidal, virucidal, odor neutralizer and deodorizer', 'Y', '', '', 'TOILET BOWL CLEANER', 'd9f3969abaaeda415fd7848af33cb476a74cc1c65bae48108dd6cfe1e187fdee',
'', '', '', '', '', '',
'', '', '', '', '', '', '', '0.0',
'', '1514160000', 'Bathroom, Tile & Toilet Cleaners', '1500000000', '1514000000', '1514160000',
'', '', '', 'Toilet Bowl Cleaner', '', '',
'', '', '', '', '', '',
'', '', '', '', '',
'', '', '', '', '', '',
'', '', '', '', '',
'', '', '', '', '',
'', '', '', '', '',
'', '', '', '', 'Active',
'4629', '7998', '', '', '', '1', '2', '4.1200' )
2020-10-20 22:05:45.947 CDT [15342] ERROR: duplicate key value violates unique constraint "p21_item_pkey"
2020-10-20 22:05:45.947 CDT [15342] DETAIL: Key (item_id)=(LTH LED P4BM) already exists.
2020-10-20 22:05:45.947 CDT [15342] STATEMENT: INSERT INTO p21_item( item_id, inv_mast_uid, ad_part_number, heading, manufacturer_part_number,
manufacturer_name, brand_name, category_name_level_1, category_name_level_2, category_name_level_3, category_name_level_4,
category_name_level_5, category_name_level_6, item_desc_p21, extended_desc_p21, long_desc, short_desc, item_keywords,
company_id, p21_default_sales_unit, standard_cost, price2, p21_weight, sales_pricing_unit_size,
benefits_and_features, publish, unspsc_code, marketing_desc, p21_item_desc, ad_item_id, package_description,
alternate_part_number1, alternate_part_number2, upc_code, country_of_origin, item_length, length_uom, item_height,
height_uom, item_width, width_uom, item_weight, weight_uom, item_volume, volume_uom, category_code, category_name,
category_code_level_1, category_code_level_2, category_code_level_3, category_code_level_4, category_code_level_5,
category_code_level_6, invoice_desc, product_name, product_group, item_image_1, item_detail_image_1, item_enlarged_image_1,
item_image_type_1, item_image_2, item_detail_image_2, item_enlarged_image_2, item_image_type_2, item_image_3,
item_detail_image_3, item_enlarged_image_3, item_image_type_3, item_image_4, item_detail_image_4,
item_enlarged_image_4, item_image_type_4, item_image_5, item_detail_image_5, item_enlarged_image_5,
item_image_type_5, item_document_name_1, item_document_type_1, item_document_caption_1,
item_document_name_2, item_document_type_2, item_document_caption_2, item_document_name_3, item_document_type_3,
item_document_caption_3, item_document_name_4, item_document_type_4, item_document_caption_4, item_document_name_5,
item_document_type_5, item_document_caption_5, item_application, manufacturer_status, manufacturer_id,
brand_id, long_desc2, gtin, grainger_part_no, qty_available, default_price_family_uid, original_price) VALUES ('LTH LED P4BM', '10515', 'GROVES_10514', 'LED Lenser® P4', 'P4', 'Leatherman Tool Group',
'LED Lenser®', 'Portable Lighting & Flashlights', 'Flashlights', 'Flashlights - Handheld', '',
'', '', 'LED Flashlight', 'P4 BLUEMOON LL CLIP LIGHT 16 LUMEN, 27 METER', 'LED Lenser® P4 LED Flashlight, With Pocket Clip', 'LED Lenser® P4 LED Flashlight, With Pocket Clip',
'LED Lenser® P4; Portable Lighting & Flashlights; Flashlights; Flashlights - Handheld; LED Lenser® P4 LED Flashlight, With Pocket Clip', 'GROVES', 'EA', '14.3800', '25.2300', '.150000000000',
'1.0000', '• High-end LED with white "Blue Moon" beam
• Battery life of 6 hours at 16 lumens
• Tail switch
• Hard gold-plated battery contacts to maximize efficiency and resist corrosion
• Modular design for easy replacement of parts
• Water resistant
• Includes 1 P4 LED flashlight, 1 set of batteries, 1 sheath, 1 lanyard, 1 clip & instruction manual', 'Y', '', 'The P4 is a focusable, handy everyday carry flashlight, no larger than the size of a ballpoint pen. It offers 18 lumens of bright white light, with a beam distance of 82 feet. This small miniature penlight can be clipped to your shirt or pants pocket and has a run time of 8.5 hours, perfect for use at work or at home.', 'LED Flashlight', 'a69dc3b2a8e576b7e981d82b4f04a191e72647122ed2bf1ffa489f2c71b68210',
'', '', '', '', '', '',
'', '', '', '', '', '', '', '0.0',
'', '131211000000', 'Flashlights - Handheld', '490000000000', '1143130000', '131211000000',
'', '', '', 'LED Flashlight', '', '',
'GBTHX2MZJEAV.jpg', '', '', 'URL', 'GBTHX2MZJEAW.jpg', '',
'', 'URL', '', '', '',
'', '', '', '', '', '',
'', '', '', '', '',
'', '', '', '', '',
'', '', '', '', '',
'', '', '', '', 'Active',
'4063', '8112', '', '', '', '0', '2', '25.2300' )
2020-10-20 22:08:03.135 CDT [15342] ERROR: duplicate key value violates unique constraint "p21_item_pkey"
2020-10-20 22:08:03.135 CDT [15342] DETAIL: Key (item_id)=(SAF JS1500-38R) already exists.
2020-10-20 22:08:03.135 CDT [15342] STATEMENT: INSERT INTO p21_item( item_id, inv_mast_uid, ad_part_number, heading, manufacturer_part_number,
manufacturer_name, brand_name, category_name_level_1, category_name_level_2, category_name_level_3, category_name_level_4,
category_name_level_5, category_name_level_6, item_desc_p21, extended_desc_p21, long_desc, short_desc, item_keywords,
company_id, p21_default_sales_unit, standard_cost, price2, p21_weight, sales_pricing_unit_size,
benefits_and_features, publish, unspsc_code, marketing_desc, p21_item_desc, ad_item_id, package_description,
alternate_part_number1, alternate_part_number2, upc_code, country_of_origin, item_length, length_uom, item_height,
height_uom, item_width, width_uom, item_weight, weight_uom, item_volume, volume_uom, category_code, category_name,
category_code_level_1, category_code_level_2, category_code_level_3, category_code_level_4, category_code_level_5,
category_code_level_6, invoice_desc, product_name, product_group, item_image_1, item_detail_image_1, item_enlarged_image_1,
item_image_type_1, item_image_2, item_detail_image_2, item_enlarged_image_2, item_image_type_2, item_image_3,
item_detail_image_3, item_enlarged_image_3, item_image_type_3, item_image_4, item_detail_image_4,
item_enlarged_image_4, item_image_type_4, item_image_5, item_detail_image_5, item_enlarged_image_5,
item_image_type_5, item_document_name_1, item_document_type_1, item_document_caption_1,
item_document_name_2, item_document_type_2, item_document_caption_2, item_document_name_3, item_document_type_3,
item_document_caption_3, item_document_name_4, item_document_type_4, item_document_caption_4, item_document_name_5,
item_document_type_5, item_document_caption_5, item_application, manufacturer_status, manufacturer_id,
brand_id, long_desc2, gtin, grainger_part_no, qty_available, default_price_family_uid, original_price) VALUES ('SAF JS1500-38R', '18170', 'GROVES_18172', 'Saf-Tech CJS15RB-M', 'CJS15RB-M', 'Saf-Tech',
'Saf-Tech', 'Safety & Security', 'Personal Protective Equipment (PPE)', 'Clothing', 'Work Clothing',
'Coveralls & Overalls', '', 'Nomex Coveralls', 'INTL LOGO NOMEX CVRL/ROYAL BLUE-SZ. 38 REG.', 'Saf-Tech CJS15RB-M CJS1500 Contractor Coverall, Medium, Royal Blue, Indura®, 38 to 40 in Chest, 29.5 in L Inseam', 'Saf-Tech CJS15RB-M CJS1500 Contractor Coverall, Medium, Royal Blue, Indura®, 38 to 40 in Chest, 29.5 in L Inseam',
'Saf-Tech CJS15RB-M; Safety & Security; Personal Protective Equipment (PPE); Clothing; Work Clothing; Coveralls & Overalls; Saf-Tech CJS15RB-M CJS1500 Contractor Coverall, Medium, Royal Blue, Indura®, 38 to 40 in Chest, 29.5 in L Inseam', 'GROVES', 'EA', '75.1200', '131.7900', '2.000000000000',
'1.0000', '• Lay down collar
• A sewn bi-swing back
• Elastic waist inserts and hemmed sleeves with snap closures
• It has bar tacked reinforcements at the stress points
• A 2-way Nomex® brass break away zipper and double stitched reinforcements', 'Y', '', 'Saf-Tech CJS15RB-M CJS1500 Contractor Coverall, Medium, Royal Blue, Indura®, 38 to 40 in Chest, 29.5 in L Inseam', 'Nomex Coveralls', 'f17ddb7d878005ee442cfa51e18f60f79688d96ecac067a24048c439040ee317',
'', '', '', '', '', '',
'', '', '', '', '', '', '', '',
'', '1163111811', 'Coveralls & Overalls', '1100000000', '1163000000', '1163110000',
'1163111800', '1163111811', '', 'Saf-Tech CJS15RB-M CJS1500 Contractor Coverall, Medium, Royal Blue, Indura®, 38 to 40 in Chest, 29.5 in L Inseam', '', '',
'GROVES_18172.jpg', 'GROVES_18172_DET.jpg', 'GROVES_18172_HR.jpg', 'FILE', '', '',
'', '', '', '', '',
'', '', '', '', '', '',
'', '', '', '', '',
'', '', '', '', '',
'', '', '', '', '',
'', '', '', '', 'Active',
'4165', '7245', '', '', '', '0', '2', '131.7900' )
2020-10-20 22:15:36.228 CDT [21051] ERROR: duplicate key value violates unique constraint "temp_item_categories_pkey"
2020-10-20 22:15:36.228 CDT [21051] DETAIL: Key (item_id)=(DRK 04578) already exists.
2020-10-20 22:15:36.228 CDT [21051] STATEMENT: INSERT INTO temp_item_categories( item_id, inv_mast_uid, ad_part_number, category_name_level_1,
category_name_level_2, category_name_level_3, category_name_level_4, category_name_level_5,
category_name_level_6, company_id, image_name, publish) VALUES ('DRK 04578', '5973', 'FS_00202', 'Chemicals',
'Cleaners', 'Bathroom, Tile & Toilet Cleaners', '',
'', '', 'GROVES', 'Vanish_90158.jpg', 'Y')
2020-10-20 22:16:10.539 CDT [21051] ERROR: duplicate key value violates unique constraint "temp_item_categories_pkey"
2020-10-20 22:16:10.539 CDT [21051] DETAIL: Key (item_id)=(LTH LED P4BM) already exists.
2020-10-20 22:16:10.539 CDT [21051] STATEMENT: INSERT INTO temp_item_categories( item_id, inv_mast_uid, ad_part_number, category_name_level_1,
category_name_level_2, category_name_level_3, category_name_level_4, category_name_level_5,
category_name_level_6, company_id, image_name, publish) VALUES ('LTH LED P4BM', '10515', 'GROVES_10514', 'Portable Lighting & Flashlights',
'Flashlights', 'Flashlights - Handheld', '',
'', '', 'GROVES', 'GROVES_10514.jpg', 'Y')
2020-10-20 22:16:15.063 CDT [21051] ERROR: duplicate key value violates unique constraint "temp_item_categories_pkey"
2020-10-20 22:16:15.063 CDT [21051] DETAIL: Key (item_id)=(SAF JS1500-38R) already exists.
2020-10-20 22:16:15.063 CDT [21051] STATEMENT: INSERT INTO temp_item_categories( item_id, inv_mast_uid, ad_part_number, category_name_level_1,
category_name_level_2, category_name_level_3, category_name_level_4, category_name_level_5,
category_name_level_6, company_id, image_name, publish) VALUES ('SAF JS1500-38R', '18170', 'GROVES_18172', 'Safety & Security',
'Personal Protective Equipment (PPE)', 'Clothing', 'Work Clothing',
'Coveralls & Overalls', '', 'GROVES', 'GROVES_18172.jpg', 'Y')
2020-10-20 22:21:49.806 CDT [21484] ERROR: missing FROM-clause entry for table "temp_item_specs" at character 344
2020-10-20 22:21:49.806 CDT [21484] STATEMENT: update item_specs
set number_value = A.number_value
from
(
SELECT item_id, spec_name, spec_value, spec_uom,
CASE WHEN isnumeric(REPLACE(REPLACE(item_specs.spec_value, '-', ''), '/', '')) = TRUE THEN
CASE WHEN item_specs.spec_value LIKE '%/%' THEN
CASE WHEN item_specs.spec_value NOT LIKE '%-%' AND temp_item_specs.spec_value NOT LIKE '%/0%'
AND (length( item_specs.spec_value ) - length(replace( item_specs.spec_value , '/', '' ))) / length( '/' ) = 1 THEN
fraction_to_decimal(item_specs.spec_value)::REAL
WHEN item_specs.spec_value NOT LIKE '%/%-%' AND temp_item_specs.spec_value NOT LIKE '%/0%'
AND (length( item_specs.spec_value ) - length(replace( item_specs.spec_value , '-', '' ))) / length( '-' ) = 1
AND (length( item_specs.spec_value ) - length(replace( item_specs.spec_value , '/', '' ))) / length( '/' ) = 1 THEN
fraction_to_decimal(item_specs.spec_value)::REAL
ELSE NULL
END
ELSE
CASE WHEN item_specs.spec_value NOT LIKE '%-%' THEN
item_specs.spec_value::REAL
ELSE NULL
END
END
ELSE NULL
END as number_value
FROM public.item_specs
where number_value is null
and CASE WHEN isnumeric(REPLACE(REPLACE(item_specs.spec_value, '-', ''), '/', '')) = TRUE THEN
CASE WHEN item_specs.spec_value LIKE '%/%' THEN
CASE WHEN item_specs.spec_value NOT LIKE '%-%' AND temp_item_specs.spec_value NOT LIKE '%/0%'
AND (length( item_specs.spec_value ) - length(replace( item_specs.spec_value , '/', '' ))) / length( '/' ) = 1 THEN
fraction_to_decimal(item_specs.spec_value)::REAL
WHEN item_specs.spec_value NOT LIKE '%/%-%' AND temp_item_specs.spec_value NOT LIKE '%/0%'
AND (length( item_specs.spec_value ) - length(replace( item_specs.spec_value , '-', '' ))) / length( '-' ) = 1
AND (length( item_specs.spec_value ) - length(replace( item_specs.spec_value , '/', '' ))) / length( '/' ) = 1 THEN
fraction_to_decimal(item_specs.spec_value)::REAL
ELSE NULL
END
ELSE
CASE WHEN item_specs.spec_value NOT LIKE '%-%' THEN
item_specs.spec_value::REAL
ELSE NULL
END
END
ELSE NULL
END is not null
group by item_id, spec_name, spec_value, spec_uom,
CASE WHEN isnumeric(REPLACE(REPLACE(item_specs.spec_value, '-', ''), '/', '')) = TRUE THEN
CASE WHEN item_specs.spec_value LIKE '%/%' THEN
CASE WHEN item_specs.spec_value NOT LIKE '%-%' AND temp_item_specs.spec_value NOT LIKE '%/0%'
AND (length( item_specs.spec_value ) - length(replace( item_specs.spec_value , '/', '' ))) / length( '/' ) = 1 THEN
fraction_to_decimal(item_specs.spec_value)::REAL
WHEN item_specs.spec_value NOT LIKE '%/%-%' AND temp_item_specs.spec_value NOT LIKE '%/0%'
AND (length( item_specs.spec_value ) - length(replace( item_specs.spec_value , '-', '' ))) / length( '-' ) = 1
AND (length( item_specs.spec_value ) - length(replace( item_specs.spec_value , '/', '' ))) / length( '/' ) = 1 THEN
fraction_to_decimal(item_specs.spec_value)::REAL
ELSE NULL
END
ELSE
CASE WHEN item_specs.spec_value NOT LIKE '%-%' THEN
item_specs.spec_value::REAL
ELSE NULL
END
END
ELSE NULL
END
)A
where trim(item_specs.spec_name) = trim(A.spec_name)
and trim(item_specs.spec_value) = trim(A.spec_value)
and trim(item_specs.item_id) = trim(A.item_id)