Client Upload
FAILED
Test
· 7. DISCOVERER LUANDA (DRILL SHIP) IADC.pdf · Job #2
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 #87
2026-07-06 21:12:22
0.0% rate
0/0 matched
0 strong
2
Run #76
2026-07-06 20:33:21
0.0% rate
0/0 matched
0 strong
3
Run #74
2026-07-06 19:12:53
0.0% rate
0/0 matched
0 strong
4
Run #63
2026-07-03 00:34:36
0.0% rate
0/0 matched
0 strong
5
Run #50
2026-07-01 06:25:51
0.0% rate
0/0 matched
0 strong
6
Run #44
2026-06-22 14:17:05
0.0% rate
0/0 matched
0 strong
7
Run #21
2026-05-26 03:03:29
0.0% rate
0/0 matched
0 strong
Processing Logs
13 entries
02:34:45
INFO
Starting extraction: 7. DISCOVERER LUANDA (DRILL SHIP) IADC.pdf
02:34:45
INFO
Step 1: Extracting text and tables from PDF...
02:35:35
INFO
Extracted 3706 text lines from 96 pages
02:35:35
INFO
Merged table data: 4315 total lines (609 from tables)
02:35:35
INFO
Step 2: Parsing IADC sections...
02:35:35
INFO
Found 893 sections
02:35:35
INFO
Step 3: Building products from sections...
02:35:35
INFO
Built 755 products (603 with data, 152 section-only)
02:35:35
WARN
152 products have section headers only — kept for completeness
02:35:35
INFO
Step 4: Categorizing products...
02:35:35
OK
Categorized into 17 categories
02:35:35
INFO
Step 5: Saving ALL products to database (zero-loss policy)...
02:35:35
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: {'prod_type__0': 'N/A', 'source_pages_json__0': '[84]', 'sub_items_json__0': '[]', 'has_data__0': True, 'vessel_classification__0': 'DNV +1A1, "Ship Shaped Drilling Unit", EO,', 'vessel_rig_type__0': ': Dual Activity Drill Ship', 'subcategory__0': 'K.1.1', 'manufacturer__0': '', 'attributes_json__0': '{}', 'source_type__0': 'text', 'name__0': 'Company Representative’s Office', '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"]', 'category__0': 'Accommodation & Living Quarters', 'condition__0': None, 'section_id__0': 'K.1.1', 'specifications_json__0': '{"Unrestricted view to drill floor": "yes/no 1 Yes, 6 No"}', 'vessel_country__0': ': Marshall Islands', 'source_document__0': '7. DISCOVERER LUANDA (DRILL SHIP) IADC.pdf', 'vessel_flag__0': ': Marshall Islands', 'vessel_year__0': 'Keel Laid : 2008 (Year into Service in 2010)', 'quantity__0': 7, 'model__0': '', 'notes__0': None, 'vessel_imo__0': ': Yes', 'job_id__0': 2, 'product_overview_json__0': '{"make": "N/A", "type": "N/A", "model": "N/A"}', 'origin__0': 'Test', 'prod_type__1': 'N/A', 'source_pages_json__1': '[84]', 'sub_items_json__1': '[]', 'has_data__1': True, 'vessel_classification__1': 'DNV +1A1, "Ship Shaped Drilling Unit", EO,', 'vessel_rig_type__1': ': Dual Activity Drill Ship', 'subcategory__1': 'K.1.2', 'manufacturer__1': '', 'attributes_json__1': '{}', 'source_type__1': 'text', 'name__1': 'Contractor’s Representative’s Office', 'raw_lines_json__1': '["K.1.2 Contractor\\u2019s Representative\\u2019s Office", "Quantity: no. 5", "Unrestricted view to drill floor: yes/no 1 Yes, 4 No"]', 'category__1': 'Accommodation & Living Quarters', 'condition__1': None, 'section_id__1': 'K.1.2', 'specifications_json__1': '{"Unrestricted view to drill floor": "yes/no 1 Yes, 4 No"}', 'vessel_country__1': ': Marshall Islands', 'source_document__1': '7. DISCOVERER LUANDA (DRILL SHIP) IADC.pdf', 'vessel_flag__1': ': Marshall Islands', 'vessel_year__1': 'Keel Laid : 2008 (Year into Service in 2010)', 'quantity__1': 5, 'model__1': '', 'notes__1': None ... 20285 parameters truncated ... 'vessel_classification__753': 'DNV +1A1, "Ship Shaped Drilling Unit", EO,', 'vessel_rig_type__753': ': Dual Activity Drill Ship', 'subcategory__753': 'A.11.4bvv', 'manufacturer__753': '', 'attributes_json__753': '{}', 'source_type__753': 'text', 'name__753': 'Make / Model', 'raw_lines_json__753': '["Make / Model", "Type: fixed/", "portable"]', 'category__753': 'Unit Specifications & Dimensions', 'condition__753': None, 'section_id__753': 'A.11.4bvv', 'specifications_json__753': '{}', 'vessel_country__753': ': Marshall Islands', 'source_document__753': '7. DISCOVERER LUANDA (DRILL SHIP) IADC.pdf', 'vessel_flag__753': ': Marshall Islands', 'vessel_year__753': 'Keel Laid : 2008 (Year into Service in 2010)', 'quantity__753': None, 'model__753': '', 'notes__753': None, 'vessel_imo__753': ': Yes', 'job_id__753': 2, 'product_overview_json__753': '{"make": "N/A", "type": "fixed/", "model": "N/A"}', 'origin__753': 'Test', 'prod_type__754': 'N/A', 'source_pages_json__754': '[17]', 'sub_items_json__754': '[]', 'has_data__754': True, 'vessel_classification__754': 'DNV +1A1, "Ship Shaped Drilling Unit", EO,', 'vessel_rig_type__754': ': Dual Activity Drill Ship', 'subcategory__754': 'A.11.5', 'manufacturer__754': 'Unitor', 'attributes_json__754': '{"Max delivered pressure": "bar 160"}', 'source_type__754': 'text', 'name__754': 'High Pressure Cleaner', '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"]', 'category__754': 'Unit Specifications & Dimensions', 'condition__754': None, 'section_id__754': 'A.11.5', 'specifications_json__754': '{"Electric/pneumatic/diesel": "Electric"}', 'vessel_country__754': ': Marshall Islands', 'source_document__754': '7. DISCOVERER LUANDA (DRILL SHIP) IADC.pdf', 'vessel_flag__754': ': Marshall Islands', 'vessel_year__754': 'Keel Laid : 2008 (Year into Service in 2010)', 'quantity__754': 2, 'model__754': '', 'notes__754': None, 'vessel_imo__754': ': Yes', 'job_id__754': 2, 'product_overview_json__754': '{"make": "Unitor", "type": "N/A", "model": "N/A"}', 'origin__754': 'Test'}]
(Background on this error at: https://sqlalche.me/e/20/9h9h)