Client Upload FAILED

TEST

· 7. DISCOVERER LUANDA (DRILL SHIP) IADC.pdf · Job #3

Step 2: Find Inventory Matches New Upload

Products Extracted

0

Categories

0

Pages Scanned

96

Inventory Matching

Click "Find Inventory Matches" to run Step 2

1 Parsed Items

2 Inventory Matches

Match Run History 7 runs

1

Run #86 2026-07-06 21:12:22

0.0% rate 0/0 matched 0 strong

2

Run #78 2026-07-06 20:33:38

0.0% rate 0/0 matched 0 strong

3

Run #72 2026-07-06 19:11:57

0.0% rate 0/0 matched 0 strong

4

Run #70 2026-07-04 08:33:15

0.0% rate 0/0 matched 0 strong

5

Run #49 2026-07-01 06:25:49

0.0% rate 0/0 matched 0 strong

6

Run #41 2026-06-22 07:15:25

0.0% rate 0/0 matched 0 strong

7

Run #23 2026-05-26 03:05:20

0.0% rate 0/0 matched 0 strong

Processing Logs 13 entries

06:36:53 INFO Starting extraction: 7. DISCOVERER LUANDA (DRILL SHIP) IADC.pdf

06:36:53 INFO Step 1: Extracting text and tables from PDF...

06:37:57 INFO Extracted 3706 text lines from 96 pages

06:37:57 INFO Merged table data: 4315 total lines (609 from tables)

06:37:57 INFO Step 2: Parsing IADC sections...

06:37:57 INFO Found 893 sections

06:37:57 INFO Step 3: Building products from sections...

06:37:58 INFO Built 755 products (603 with data, 152 section-only)

06:37:58 WARN 152 products have section headers only — kept for completeness

06:37:58 INFO Step 4: Categorizing products...

06:37:58 OK Categorized into 17 categories

06:37:58 INFO Step 5: Saving ALL products to database (zero-loss policy)...

06:37:58 ERR Failed: (psycopg2.errors.StringDataRightTruncation) value too long for type character varying(20) [SQL: INSERT INTO extracted_products (job_id, name, section_id, category, subcategory, manufacturer, model, prod_type, quantity, product_overview_json, specifications_json, attributes_json, origin, condition, notes, source_document, vessel_year, vessel_cou ... 487559 characters truncated ... 6, sen_counter) ORDER BY sen_counter RETURNING extracted_products.id, extracted_products.id AS id__1] [parameters: {'subcategory__0': 'K.1.1', 'model__0': '', 'condition__0': None, 'source_type__0': 'text', 'prod_type__0': 'N/A', 'manufacturer__0': '', 'vessel_classification__0': 'DNV +1A1, "Ship Shaped Drilling Unit", EO,', 'name__0': 'Company Representative’s Office', 'vessel_rig_type__0': ': Dual Activity Drill Ship', 'sub_items_json__0': '[]', 'job_id__0': 3, 'category__0': 'Accommodation & Living Quarters', 'product_overview_json__0': '{"make": "N/A", "type": "N/A", "model": "N/A"}', 'source_pages_json__0': '[84]', 'vessel_imo__0': ': Yes', 'attributes_json__0': '{}', 'has_data__0': True, 'vessel_flag__0': ': Marshall Islands', 'vessel_country__0': ': Marshall Islands', 'quantity__0': 7, 'notes__0': None, 'section_id__0': 'K.1.1', 'vessel_year__0': 'Keel Laid : 2008 (Year into Service in 2010)', 'source_document__0': '7. DISCOVERER LUANDA (DRILL SHIP) IADC.pdf', 'specifications_json__0': '{"Unrestricted view to drill floor": "yes/no 1 Yes, 6 No"}', 'raw_lines_json__0': '["K.1.1 Company Representative\\u2019s Office", "Quantity: no. 7", "Complete with desk, filing cabinet(s) and yes/no Yes", "other necessary furniture:", "Unrestricted view to drill floor: yes/no 1 Yes, 6 No"]', 'origin__0': 'TEST', 'subcategory__1': 'K.1.2', 'model__1': '', 'condition__1': None, 'source_type__1': 'text', 'prod_type__1': 'N/A', 'manufacturer__1': '', 'vessel_classification__1': 'DNV +1A1, "Ship Shaped Drilling Unit", EO,', 'name__1': 'Contractor’s Representative’s Office', 'vessel_rig_type__1': ': Dual Activity Drill Ship', 'sub_items_json__1': '[]', 'job_id__1': 3, 'category__1': 'Accommodation & Living Quarters', 'product_overview_json__1': '{"make": "N/A", "type": "N/A", "model": "N/A"}', 'source_pages_json__1': '[84]', 'vessel_imo__1': ': Yes', 'attributes_json__1': '{}', 'has_data__1': True, 'vessel_flag__1': ': Marshall Islands', 'vessel_country__1': ': Marshall Islands', 'quantity__1': 5, 'notes__1': None, 'section_id__1': 'K.1.2', 'vessel_year__1': 'Keel Laid : 2008 (Year into Service in 2010)' ... 20285 parameters truncated ... 'prod_type__753': 'fixed/', 'manufacturer__753': '', 'vessel_classification__753': 'DNV +1A1, "Ship Shaped Drilling Unit", EO,', 'name__753': 'Make / Model', 'vessel_rig_type__753': ': Dual Activity Drill Ship', 'sub_items_json__753': '[]', 'job_id__753': 3, 'category__753': 'Unit Specifications & Dimensions', 'product_overview_json__753': '{"make": "N/A", "type": "fixed/", "model": "N/A"}', 'source_pages_json__753': '[17]', 'vessel_imo__753': ': Yes', 'attributes_json__753': '{}', 'has_data__753': False, 'vessel_flag__753': ': Marshall Islands', 'vessel_country__753': ': Marshall Islands', 'quantity__753': None, 'notes__753': None, 'section_id__753': 'A.11.4bvv', 'vessel_year__753': 'Keel Laid : 2008 (Year into Service in 2010)', 'source_document__753': '7. DISCOVERER LUANDA (DRILL SHIP) IADC.pdf', 'specifications_json__753': '{}', 'raw_lines_json__753': '["Make / Model", "Type: fixed/", "portable"]', 'origin__753': 'TEST', 'subcategory__754': 'A.11.5', 'model__754': '', 'condition__754': None, 'source_type__754': 'text', 'prod_type__754': 'N/A', 'manufacturer__754': 'Unitor', 'vessel_classification__754': 'DNV +1A1, "Ship Shaped Drilling Unit", EO,', 'name__754': 'High Pressure Cleaner', 'vessel_rig_type__754': ': Dual Activity Drill Ship', 'sub_items_json__754': '[]', 'job_id__754': 3, 'category__754': 'Unit Specifications & Dimensions', 'product_overview_json__754': '{"make": "Unitor", "type": "N/A", "model": "N/A"}', 'source_pages_json__754': '[17]', 'vessel_imo__754': ': Yes', 'attributes_json__754': '{"Max delivered pressure": "bar 160"}', 'has_data__754': True, 'vessel_flag__754': ': Marshall Islands', 'vessel_country__754': ': Marshall Islands', 'quantity__754': 2, 'notes__754': None, 'section_id__754': 'A.11.5', 'vessel_year__754': 'Keel Laid : 2008 (Year into Service in 2010)', 'source_document__754': '7. DISCOVERER LUANDA (DRILL SHIP) IADC.pdf', 'specifications_json__754': '{"Electric/pneumatic/diesel": "Electric"}', 'raw_lines_json__754': '["A.11.5 High Pressure Cleaner", "Quantity: no. 2", "Make / Type: Unitor", "Electric/pneumatic/diesel: Electric", "Max delivered pressure: bar 160"]', 'origin__754': 'TEST'}] (Background on this error at: https://sqlalche.me/e/20/9h9h)