2020-10-17 01:00:01.593 CDT [56762] FATAL: database "egroves" does not exist 2020-10-17 11:39:24.358 CDT [62610] ERROR: syntax error at or near "where" at character 344 2020-10-17 11:39:24.358 CDT [62610] STATEMENT: SELECT item_id, item_image_1, item_detail_image_1, item_enlarged_image_1, item_image_2, item_detail_image_2, item_enlarged_image_2, item_image_3, item_detail_image_3, item_enlarged_image_3, item_image_4, item_detail_image_4, item_enlarged_image_4, item_image_5, item_detail_image_5, item_enlarged_image_5 FROM public.ad_item_info; where item_image_1 LIKE '%cdn.grovesindustrial.com%' OR item_image_2 LIKE '%cdn.grovesindustrial.com%' OR item_image_3 LIKE '%cdn.grovesindustrial.com%' OR item_image_4 LIKE '%cdn.grovesindustrial.com%' OR item_image_5 LIKE '%cdn.grovesindustrial.com%' 2020-10-17 22:07:13.709 CDT [8284] ERROR: duplicate key value violates unique constraint "p21_item_pkey" 2020-10-17 22:07:13.709 CDT [8284] DETAIL: Key (item_id)=(SAF JS1500-38R) already exists. 2020-10-17 22:07:13.709 CDT [8284] 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-17 22:15:25.560 CDT [12239] ERROR: duplicate key value violates unique constraint "temp_item_categories_pkey" 2020-10-17 22:15:25.560 CDT [12239] DETAIL: Key (item_id)=(SAF JS1500-38R) already exists. 2020-10-17 22:15:25.560 CDT [12239] 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-17 22:21:18.863 CDT [12443] ERROR: missing FROM-clause entry for table "temp_item_specs" at character 344 2020-10-17 22:21:18.863 CDT [12443] 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)