2020-10-19 01:00:01.576 CDT [61237] FATAL: database "egroves" does not exist 2020-10-19 05:07:03.391 CDT [61334] ERROR: column c.relhasoids does not exist at character 245 2020-10-19 05:07:03.391 CDT [61334] STATEMENT: select n.nspname, c.relname, a.attname, a.atttypid, t.typname, a.attnum, a.attlen, a.atttypmod, a.attnotnull, c.relhasrules, c.relkind, c.oid, pg_get_expr(d.adbin, d.adrelid), case t.typtype when 'd' then t.typbasetype else 0 end, t.typtypmod, c.relhasoids, attidentity, c.relhassubclass from (((pg_catalog.pg_class c inner join pg_catalog.pg_namespace n on n.oid = c.relnamespace and c.oid = 40238) inner join pg_catalog.pg_attribute a on (not a.attisdropped) and a.attnum > 0 and a.attrelid = c.oid) inner join pg_catalog.pg_type t on t.oid = a.atttypid) left outer join pg_attrdef d on a.atthasdef and d.adrelid = a.attrelid and d.adnum = a.attnum order by n.nspname, c.relname, attnum 2020-10-19 05:07:03.391 CDT [61334] ERROR: column c.relhasoids does not exist at character 245 2020-10-19 05:07:03.391 CDT [61334] STATEMENT: select n.nspname, c.relname, a.attname, a.atttypid, t.typname, a.attnum, a.attlen, a.atttypmod, a.attnotnull, c.relhasrules, c.relkind, c.oid, pg_get_expr(d.adbin, d.adrelid), case t.typtype when 'd' then t.typbasetype else 0 end, t.typtypmod, c.relhasoids, attidentity, c.relhassubclass from (((pg_catalog.pg_class c inner join pg_catalog.pg_namespace n on n.oid = c.relnamespace and c.oid = 40238) inner join pg_catalog.pg_attribute a on (not a.attisdropped) and a.attnum > 0 and a.attrelid = c.oid) inner join pg_catalog.pg_type t on t.oid = a.atttypid) left outer join pg_attrdef d on a.atthasdef and d.adrelid = a.attrelid and d.adnum = a.attnum order by n.nspname, c.relname, attnum 2020-10-19 05:07:03.392 CDT [61334] ERROR: column c.relhasoids does not exist at character 245 2020-10-19 05:07:03.392 CDT [61334] STATEMENT: select n.nspname, c.relname, a.attname, a.atttypid, t.typname, a.attnum, a.attlen, a.atttypmod, a.attnotnull, c.relhasrules, c.relkind, c.oid, pg_get_expr(d.adbin, d.adrelid), case t.typtype when 'd' then t.typbasetype else 0 end, t.typtypmod, c.relhasoids, attidentity, c.relhassubclass from (((pg_catalog.pg_class c inner join pg_catalog.pg_namespace n on n.oid = c.relnamespace and c.oid = 40238) inner join pg_catalog.pg_attribute a on (not a.attisdropped) and a.attnum > 0 and a.attrelid = c.oid) inner join pg_catalog.pg_type t on t.oid = a.atttypid) left outer join pg_attrdef d on a.atthasdef and d.adrelid = a.attrelid and d.adnum = a.attnum order by n.nspname, c.relname, attnum 2020-10-19 05:07:03.392 CDT [61334] ERROR: column c.relhasoids does not exist at character 245 2020-10-19 05:07:03.392 CDT [61334] STATEMENT: select n.nspname, c.relname, a.attname, a.atttypid, t.typname, a.attnum, a.attlen, a.atttypmod, a.attnotnull, c.relhasrules, c.relkind, c.oid, pg_get_expr(d.adbin, d.adrelid), case t.typtype when 'd' then t.typbasetype else 0 end, t.typtypmod, c.relhasoids, attidentity, c.relhassubclass from (((pg_catalog.pg_class c inner join pg_catalog.pg_namespace n on n.oid = c.relnamespace and c.oid = 40238) inner join pg_catalog.pg_attribute a on (not a.attisdropped) and a.attnum > 0 and a.attrelid = c.oid) inner join pg_catalog.pg_type t on t.oid = a.atttypid) left outer join pg_attrdef d on a.atthasdef and d.adrelid = a.attrelid and d.adnum = a.attnum order by n.nspname, c.relname, attnum 2020-10-19 05:07:06.383 CDT [61334] ERROR: column c.relhasoids does not exist at character 245 2020-10-19 05:07:06.383 CDT [61334] STATEMENT: select n.nspname, c.relname, a.attname, a.atttypid, t.typname, a.attnum, a.attlen, a.atttypmod, a.attnotnull, c.relhasrules, c.relkind, c.oid, pg_get_expr(d.adbin, d.adrelid), case t.typtype when 'd' then t.typbasetype else 0 end, t.typtypmod, c.relhasoids, attidentity, c.relhassubclass from (((pg_catalog.pg_class c inner join pg_catalog.pg_namespace n on n.oid = c.relnamespace and c.oid = 40238) inner join pg_catalog.pg_attribute a on (not a.attisdropped) and a.attnum > 0 and a.attrelid = c.oid) inner join pg_catalog.pg_type t on t.oid = a.atttypid) left outer join pg_attrdef d on a.atthasdef and d.adrelid = a.attrelid and d.adnum = a.attnum order by n.nspname, c.relname, attnum 2020-10-19 05:07:06.383 CDT [61334] ERROR: column c.relhasoids does not exist at character 245 2020-10-19 05:07:06.383 CDT [61334] STATEMENT: select n.nspname, c.relname, a.attname, a.atttypid, t.typname, a.attnum, a.attlen, a.atttypmod, a.attnotnull, c.relhasrules, c.relkind, c.oid, pg_get_expr(d.adbin, d.adrelid), case t.typtype when 'd' then t.typbasetype else 0 end, t.typtypmod, c.relhasoids, attidentity, c.relhassubclass from (((pg_catalog.pg_class c inner join pg_catalog.pg_namespace n on n.oid = c.relnamespace and c.oid = 40238) inner join pg_catalog.pg_attribute a on (not a.attisdropped) and a.attnum > 0 and a.attrelid = c.oid) inner join pg_catalog.pg_type t on t.oid = a.atttypid) left outer join pg_attrdef d on a.atthasdef and d.adrelid = a.attrelid and d.adnum = a.attnum order by n.nspname, c.relname, attnum 2020-10-19 05:07:06.383 CDT [61334] ERROR: column c.relhasoids does not exist at character 245 2020-10-19 05:07:06.383 CDT [61334] STATEMENT: select n.nspname, c.relname, a.attname, a.atttypid, t.typname, a.attnum, a.attlen, a.atttypmod, a.attnotnull, c.relhasrules, c.relkind, c.oid, pg_get_expr(d.adbin, d.adrelid), case t.typtype when 'd' then t.typbasetype else 0 end, t.typtypmod, c.relhasoids, attidentity, c.relhassubclass from (((pg_catalog.pg_class c inner join pg_catalog.pg_namespace n on n.oid = c.relnamespace and c.oid = 40238) inner join pg_catalog.pg_attribute a on (not a.attisdropped) and a.attnum > 0 and a.attrelid = c.oid) inner join pg_catalog.pg_type t on t.oid = a.atttypid) left outer join pg_attrdef d on a.atthasdef and d.adrelid = a.attrelid and d.adnum = a.attnum order by n.nspname, c.relname, attnum 2020-10-19 05:07:06.384 CDT [61334] ERROR: column c.relhasoids does not exist at character 245 2020-10-19 05:07:06.384 CDT [61334] STATEMENT: select n.nspname, c.relname, a.attname, a.atttypid, t.typname, a.attnum, a.attlen, a.atttypmod, a.attnotnull, c.relhasrules, c.relkind, c.oid, pg_get_expr(d.adbin, d.adrelid), case t.typtype when 'd' then t.typbasetype else 0 end, t.typtypmod, c.relhasoids, attidentity, c.relhassubclass from (((pg_catalog.pg_class c inner join pg_catalog.pg_namespace n on n.oid = c.relnamespace and c.oid = 40238) inner join pg_catalog.pg_attribute a on (not a.attisdropped) and a.attnum > 0 and a.attrelid = c.oid) inner join pg_catalog.pg_type t on t.oid = a.atttypid) left outer join pg_attrdef d on a.atthasdef and d.adrelid = a.attrelid and d.adnum = a.attnum order by n.nspname, c.relname, attnum 2020-10-19 09:26:02.032 CDT [23311] ERROR: invalid input syntax for type integer: "CusCode" 2020-10-19 09:26:02.032 CDT [23311] 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-19 09:26:02.082 CDT [23311] ERROR: invalid input syntax for type integer: "CusCode" 2020-10-19 09:26:02.082 CDT [23311] 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-19 13:00:50.384 CDT [24316] LOG: could not receive data from client: Connection reset by peer 2020-10-19 13:00:50.384 CDT [24316] LOG: incomplete message from client 2020-10-19 13:57:12.663 CDT [62610] LOG: could not receive data from client: Connection timed out 2020-10-19 14:18:26.519 CDT [50911] LOG: could not receive data from client: Connection timed out 2020-10-19 14:33:03.063 CDT [21448] LOG: could not receive data from client: Connection timed out 2020-10-19 14:35:12.087 CDT [24378] LOG: could not receive data from client: Connection timed out 2020-10-19 22:03:19.797 CDT [20225] ERROR: duplicate key value violates unique constraint "p21_item_pkey" 2020-10-19 22:03:19.797 CDT [20225] DETAIL: Key (item_id)=(DRK 04578) already exists. 2020-10-19 22:03:19.797 CDT [20225] 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', 'Vanish® 90158; Chemicals; Cleaners; Bathroom, Tile & Toilet Cleaners; Vanish® 90158 Non-Acid Bowl and Bathroom Cleaner, 32 oz Trigger Spray Bottle, Liquid Form, Fresh Odor/Scent, Clear Blue', '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', '47131829', '', '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-19 22:05:08.410 CDT [20225] ERROR: duplicate key value violates unique constraint "p21_item_pkey" 2020-10-19 22:05:08.410 CDT [20225] DETAIL: Key (item_id)=(LTH LED P4BM) already exists. 2020-10-19 22:05:08.410 CDT [20225] 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-19 22:07:27.508 CDT [20225] ERROR: duplicate key value violates unique constraint "p21_item_pkey" 2020-10-19 22:07:27.508 CDT [20225] DETAIL: Key (item_id)=(SAF JS1500-38R) already exists. 2020-10-19 22:07:27.508 CDT [20225] 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-19 22:15:01.089 CDT [24215] ERROR: duplicate key value violates unique constraint "temp_item_categories_pkey" 2020-10-19 22:15:01.089 CDT [24215] DETAIL: Key (item_id)=(DRK 04578) already exists. 2020-10-19 22:15:01.089 CDT [24215] 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-19 22:15:35.673 CDT [24215] ERROR: duplicate key value violates unique constraint "temp_item_categories_pkey" 2020-10-19 22:15:35.673 CDT [24215] DETAIL: Key (item_id)=(LTH LED P4BM) already exists. 2020-10-19 22:15:35.673 CDT [24215] 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-19 22:15:39.890 CDT [24215] ERROR: duplicate key value violates unique constraint "temp_item_categories_pkey" 2020-10-19 22:15:39.890 CDT [24215] DETAIL: Key (item_id)=(SAF JS1500-38R) already exists. 2020-10-19 22:15:39.890 CDT [24215] 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-19 22:21:44.398 CDT [24549] ERROR: missing FROM-clause entry for table "temp_item_specs" at character 344 2020-10-19 22:21:44.398 CDT [24549] 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)