2020-10-21 01:00:01.770 CDT [21341] FATAL:  database "egroves" does not exist
2020-10-21 02:39:37.815 CDT [41941] LOG:  could not receive data from client: Connection timed out
2020-10-21 07:52:01.744 CDT [9710] ERROR:  invalid input syntax for type integer: "CusCode"
2020-10-21 07:52:01.744 CDT [9710] 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-21 07:52:01.804 CDT [9710] ERROR:  invalid input syntax for type integer: "CusCode"
2020-10-21 07:52:01.804 CDT [9710] 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-21 09:16:46.557 CDT [38504] ERROR:  relation "groves_users" does not exist at character 850
2020-10-21 09:16:46.557 CDT [38504] STATEMENT:  SELECT customer_p21.sales_rep_id, sales_reps.full_name AS sales_rep_name,  takers.taker_id,
								takers.full_name AS taker_name, integrations_customer, ariba_network_id,
								punch_out_enabled, punch_out_type, hook_url, customer_p21.customer_name,
								takers.avatar AS taker_avatar, sales_reps.avatar AS sales_rep_avatar,
								takers.email_address AS taker_email, sales_reps.email_address AS sales_rep_email,
								takers.phone_number AS taker_phone_number, takers.cell_number  AS taker_cell_number,
								takers.phone_ext AS taker_phone_ext, sales_reps.phone_number AS sales_rep_phone_number,
								sales_reps.cell_number AS sales_rep_cell_number, sales_reps.phone_ext AS sales_rep_phone_ext
						  FROM customer_p21
						  LEFT JOIN customer_web_data
						  ON customer_p21.customer_id = customer_web_data.customer_id
						  LEFT JOIN groves_users takers
						  ON takers.taker_id = customer_web_data.taker_id
						  LEFT JOIN groves_users sales_reps
						  ON sales_reps.salesrep_id = CAST(customer_p21.sales_rep_id AS character varying)
						  WHERE customer_p21.customer_id = $1
						  GROUP BY customer_p21.sales_rep_id, sales_reps.full_name,  takers.taker_id,
								takers.full_name, integrations_customer, ariba_network_id,
								punch_out_enabled, punch_out_type, hook_url, customer_p21.customer_name,
								takers.avatar , sales_reps.avatar, takers.email_address, sales_reps.email_address,
								takers.phone_number, takers.cell_number, takers.phone_ext, sales_reps.phone_number,
								sales_reps.cell_number, sales_reps.phone_ext 
2020-10-21 09:46:53.367 CDT [48638] ERROR:  relation "groves_users" does not exist at character 850
2020-10-21 09:46:53.367 CDT [48638] STATEMENT:  SELECT customer_p21.sales_rep_id, sales_reps.full_name AS sales_rep_name,  takers.taker_id,
								takers.full_name AS taker_name, integrations_customer, ariba_network_id,
								punch_out_enabled, punch_out_type, hook_url, customer_p21.customer_name,
								takers.avatar AS taker_avatar, sales_reps.avatar AS sales_rep_avatar,
								takers.email_address AS taker_email, sales_reps.email_address AS sales_rep_email,
								takers.phone_number AS taker_phone_number, takers.cell_number  AS taker_cell_number,
								takers.phone_ext AS taker_phone_ext, sales_reps.phone_number AS sales_rep_phone_number,
								sales_reps.cell_number AS sales_rep_cell_number, sales_reps.phone_ext AS sales_rep_phone_ext
						  FROM customer_p21
						  LEFT JOIN customer_web_data
						  ON customer_p21.customer_id = customer_web_data.customer_id
						  LEFT JOIN groves_users takers
						  ON takers.taker_id = customer_web_data.taker_id
						  LEFT JOIN groves_users sales_reps
						  ON sales_reps.salesrep_id = CAST(customer_p21.sales_rep_id AS character varying)
						  WHERE customer_p21.customer_id = $1
						  GROUP BY customer_p21.sales_rep_id, sales_reps.full_name,  takers.taker_id,
								takers.full_name, integrations_customer, ariba_network_id,
								punch_out_enabled, punch_out_type, hook_url, customer_p21.customer_name,
								takers.avatar , sales_reps.avatar, takers.email_address, sales_reps.email_address,
								takers.phone_number, takers.cell_number, takers.phone_ext, sales_reps.phone_number,
								sales_reps.cell_number, sales_reps.phone_ext 
2020-10-21 10:16:58.696 CDT [59613] ERROR:  relation "groves_users" does not exist at character 850
2020-10-21 10:16:58.696 CDT [59613] STATEMENT:  SELECT customer_p21.sales_rep_id, sales_reps.full_name AS sales_rep_name,  takers.taker_id,
								takers.full_name AS taker_name, integrations_customer, ariba_network_id,
								punch_out_enabled, punch_out_type, hook_url, customer_p21.customer_name,
								takers.avatar AS taker_avatar, sales_reps.avatar AS sales_rep_avatar,
								takers.email_address AS taker_email, sales_reps.email_address AS sales_rep_email,
								takers.phone_number AS taker_phone_number, takers.cell_number  AS taker_cell_number,
								takers.phone_ext AS taker_phone_ext, sales_reps.phone_number AS sales_rep_phone_number,
								sales_reps.cell_number AS sales_rep_cell_number, sales_reps.phone_ext AS sales_rep_phone_ext
						  FROM customer_p21
						  LEFT JOIN customer_web_data
						  ON customer_p21.customer_id = customer_web_data.customer_id
						  LEFT JOIN groves_users takers
						  ON takers.taker_id = customer_web_data.taker_id
						  LEFT JOIN groves_users sales_reps
						  ON sales_reps.salesrep_id = CAST(customer_p21.sales_rep_id AS character varying)
						  WHERE customer_p21.customer_id = $1
						  GROUP BY customer_p21.sales_rep_id, sales_reps.full_name,  takers.taker_id,
								takers.full_name, integrations_customer, ariba_network_id,
								punch_out_enabled, punch_out_type, hook_url, customer_p21.customer_name,
								takers.avatar , sales_reps.avatar, takers.email_address, sales_reps.email_address,
								takers.phone_number, takers.cell_number, takers.phone_ext, sales_reps.phone_number,
								sales_reps.cell_number, sales_reps.phone_ext 
2020-10-21 10:41:54.915 CDT [7325] ERROR:  relation "groves_users" does not exist at character 850
2020-10-21 10:41:54.915 CDT [7325] STATEMENT:  SELECT customer_p21.sales_rep_id, sales_reps.full_name AS sales_rep_name,  takers.taker_id,
								takers.full_name AS taker_name, integrations_customer, ariba_network_id,
								punch_out_enabled, punch_out_type, hook_url, customer_p21.customer_name,
								takers.avatar AS taker_avatar, sales_reps.avatar AS sales_rep_avatar,
								takers.email_address AS taker_email, sales_reps.email_address AS sales_rep_email,
								takers.phone_number AS taker_phone_number, takers.cell_number  AS taker_cell_number,
								takers.phone_ext AS taker_phone_ext, sales_reps.phone_number AS sales_rep_phone_number,
								sales_reps.cell_number AS sales_rep_cell_number, sales_reps.phone_ext AS sales_rep_phone_ext
						  FROM customer_p21
						  LEFT JOIN customer_web_data
						  ON customer_p21.customer_id = customer_web_data.customer_id
						  LEFT JOIN groves_users takers
						  ON takers.taker_id = customer_web_data.taker_id
						  LEFT JOIN groves_users sales_reps
						  ON sales_reps.salesrep_id = CAST(customer_p21.sales_rep_id AS character varying)
						  WHERE customer_p21.customer_id = $1
						  GROUP BY customer_p21.sales_rep_id, sales_reps.full_name,  takers.taker_id,
								takers.full_name, integrations_customer, ariba_network_id,
								punch_out_enabled, punch_out_type, hook_url, customer_p21.customer_name,
								takers.avatar , sales_reps.avatar, takers.email_address, sales_reps.email_address,
								takers.phone_number, takers.cell_number, takers.phone_ext, sales_reps.phone_number,
								sales_reps.cell_number, sales_reps.phone_ext 
2020-10-21 10:47:05.642 CDT [12828] ERROR:  relation "groves_users" does not exist at character 850
2020-10-21 10:47:05.642 CDT [12828] STATEMENT:  SELECT customer_p21.sales_rep_id, sales_reps.full_name AS sales_rep_name,  takers.taker_id,
								takers.full_name AS taker_name, integrations_customer, ariba_network_id,
								punch_out_enabled, punch_out_type, hook_url, customer_p21.customer_name,
								takers.avatar AS taker_avatar, sales_reps.avatar AS sales_rep_avatar,
								takers.email_address AS taker_email, sales_reps.email_address AS sales_rep_email,
								takers.phone_number AS taker_phone_number, takers.cell_number  AS taker_cell_number,
								takers.phone_ext AS taker_phone_ext, sales_reps.phone_number AS sales_rep_phone_number,
								sales_reps.cell_number AS sales_rep_cell_number, sales_reps.phone_ext AS sales_rep_phone_ext
						  FROM customer_p21
						  LEFT JOIN customer_web_data
						  ON customer_p21.customer_id = customer_web_data.customer_id
						  LEFT JOIN groves_users takers
						  ON takers.taker_id = customer_web_data.taker_id
						  LEFT JOIN groves_users sales_reps
						  ON sales_reps.salesrep_id = CAST(customer_p21.sales_rep_id AS character varying)
						  WHERE customer_p21.customer_id = $1
						  GROUP BY customer_p21.sales_rep_id, sales_reps.full_name,  takers.taker_id,
								takers.full_name, integrations_customer, ariba_network_id,
								punch_out_enabled, punch_out_type, hook_url, customer_p21.customer_name,
								takers.avatar , sales_reps.avatar, takers.email_address, sales_reps.email_address,
								takers.phone_number, takers.cell_number, takers.phone_ext, sales_reps.phone_number,
								sales_reps.cell_number, sales_reps.phone_ext 
2020-10-21 11:43:26.398 CDT [40437] ERROR:  syntax error at or near "order" at character 54
2020-10-21 11:43:26.398 CDT [40437] STATEMENT:  select distinct ord_number from doc_ord_number where order by ord_number
2020-10-21 21:11:51.923 CDT [38999] ERROR:  missing FROM-clause entry for table "ad_item_info_ca" at character 554
2020-10-21 21:11:51.923 CDT [38999] STATEMENT:  UPDATE ad_item_info_fr
	                        SET unspsc_code = A.unspsc_code
	                        FROM
	                        (
	                            SELECT temp_item_prices_fr.item_id, temp_item_prices_fr.inv_mast_uid, temp_item_prices_fr.unspsc_code
	                            FROM public.temp_item_prices_fr
	                            WHERE temp_item_prices_fr.unspsc_code IS NOT NULL 
	                            AND temp_item_prices_fr.unspsc_code <> ''
	                        )A
	                        WHERE TRIM(A.item_id) = TRIM(ad_item_info_ca.item_id) 
2020-10-21 22:03:58.597 CDT [51466] ERROR:  duplicate key value violates unique constraint "p21_item_pkey"
2020-10-21 22:03:58.597 CDT [51466] DETAIL:  Key (item_id)=(DRK 04578) already exists.
2020-10-21 22:03:58.597 CDT [51466] 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<br>• Powerful quaternary detergent thickened liquid for toilet bowls, urinals and general purpose bathroom cleaning and disinfecting<br>• 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-21 22:05:50.634 CDT [51466] ERROR:  duplicate key value violates unique constraint "p21_item_pkey"
2020-10-21 22:05:50.634 CDT [51466] DETAIL:  Key (item_id)=(LTH LED P4BM) already exists.
2020-10-21 22:05:50.634 CDT [51466] 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<br>• Battery life of 6 hours at 16 lumens<br>• Tail switch<br>• Hard gold-plated battery contacts to maximize efficiency and resist corrosion<br>• Modular design for easy replacement of parts<br>• Water resistant<br>• 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-21 22:08:08.554 CDT [51466] ERROR:  duplicate key value violates unique constraint "p21_item_pkey"
2020-10-21 22:08:08.554 CDT [51466] DETAIL:  Key (item_id)=(SAF JS1500-38R) already exists.
2020-10-21 22:08:08.554 CDT [51466] 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<br>• A sewn bi-swing back<br>• Elastic waist inserts and hemmed sleeves with snap closures<br>• It has bar tacked reinforcements at the stress points<br>• 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-21 22:15:44.734 CDT [54580] ERROR:  duplicate key value violates unique constraint "temp_item_categories_pkey"
2020-10-21 22:15:44.734 CDT [54580] DETAIL:  Key (item_id)=(DRK 04578) already exists.
2020-10-21 22:15:44.734 CDT [54580] 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-21 22:16:19.455 CDT [54580] ERROR:  duplicate key value violates unique constraint "temp_item_categories_pkey"
2020-10-21 22:16:19.455 CDT [54580] DETAIL:  Key (item_id)=(LTH LED P4BM) already exists.
2020-10-21 22:16:19.455 CDT [54580] 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-21 22:16:24.233 CDT [54580] ERROR:  duplicate key value violates unique constraint "temp_item_categories_pkey"
2020-10-21 22:16:24.233 CDT [54580] DETAIL:  Key (item_id)=(SAF JS1500-38R) already exists.
2020-10-21 22:16:24.233 CDT [54580] 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-21 22:22:33.861 CDT [54678] ERROR:  missing FROM-clause entry for table "temp_item_specs" at character 344
2020-10-21 22:22:33.861 CDT [54678] 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) 
2020-10-21 23:59:12.615 CDT [58359] LOG:  could not receive data from client: Connection reset by peer
2020-10-21 23:59:12.615 CDT [34648] LOG:  could not receive data from client: Connection reset by peer
2020-10-21 23:59:12.615 CDT [34456] LOG:  could not receive data from client: Connection reset by peer
2020-10-21 23:59:12.615 CDT [11889] LOG:  could not receive data from client: Connection reset by peer
2020-10-21 23:59:12.615 CDT [29341] LOG:  could not receive data from client: Connection reset by peer
2020-10-21 23:59:12.615 CDT [58354] LOG:  could not receive data from client: Connection reset by peer
2020-10-21 23:59:12.615 CDT [11601] LOG:  could not receive data from client: Connection reset by peer