-
Notifications
You must be signed in to change notification settings - Fork 13
Open
Description
Thanks for the project, I have just started and run through the setup, new database and first import on postgresql/python3 and ubuntu. It seems stuck at this error:
[Looking for error lines in file /data1/large_data/uspto/CSV/CSV_P/continuityparent.csv]
- Error line number in file /data1/large_data/uspto/CSV/CSV_P/continuityparent.csv identified as line number 774668
- Error line 21435 has been found and removed from: /data1/large_data/uspto/CSV/CSV_L/attorney.csv
Database bulk load query failed... /data1/large_data/uspto/CSV/CSV_L/attorney.csv into table: uspto.ATTORNEY_L
Query string: COPY uspto.uspto.ATTORNEY_L FROM STDIN DELIMITER '|' CSV HEADER
Traceback (most recent call last):
File "/data1/large_data/uspto/SQLProcessor.py", line 147, in load_csv_bulk_data
self._cursor.copy_expert(sql, open(csv_file_obj['csv_file_name'], "r"))
psycopg2.errors.NotNullViolation: null value in column "name" violates not-null constraint
DETAIL: Failing row contains (0:10-cv-02292, 0:10-cv-02292, Defendant, null, null, null, attorneys).
CONTEXT: COPY attorney_l, line 22614: "0:10-cv-02292|0:10-cv-02292|Defendant||||attorneys"Is that a known error or something I could look into?
Metadata
Metadata
Assignees
Labels
No labels