I use the latest neo4j desktop version and etl-tool and try to import from postgres on a debian system. the db is very big (about 200MB) and I'm not allowed to share it here.
The errors i get look like this:
- running DB with bulk import
- Creating node with label
CName-Viaf
- Creating node with label CDocumentInscription
- Closing driver instance 689654773
- Closing connection pool towards localhost:11007
- Command failed due to error (IndexOutOfBoundsException: Index: 14, Size: 14). Rerun with --debug flag for detailed diagnostic information.
- Running DB with Load CSV
- Writing CSV headers for relationship REL_CSMONUMENTATTRIBUTEMONUMENTCURRENTSTATE_c9e32a9e-a796-4411-a9ba-d85f4bd25679
- Writing CSV headers for relationship REL_CSMONUMENTATTRIBUTEMONUMENTREASON_26e2af05-c0eb-42c7-92db-87db11cc4a1a
Export time: 14.859 (s) - Creating Neo4j store from CSV...
- Direct driver instance 912672706 created for server address localhost:11007
- Command failed due to error (ClientException: Couldn't load the external resource at: file:/home/kuczera/.config/Neo4j%20Desktop/Application/neo4jDatabases/database-58fe90a8-3319-44ce-a3d9-ce21766b464c/installation-3.5.9/import/tmp/csv-007/census/NODE_census.cslaterknownreplicaurl_2430eece-0c8e-46f9-ab6f-339116b583b1.csv). Rerun with --debug flag for detailed diagnostic information.
- Stopped DB
/tmp/csv-008/census/NODE_census.csdocumentinscription_3219bf22-2751-490d-b43a-73168a03fdf8_headers.csv
/tmp/csv-008/census/NODE_census.csdocumentinscription_3219bf22-2751-490d-b43a-73168a03fdf8.csv
/tmp/csv-008/public/NODE_public.olddesigneadbmasks_f96db422-f3fc-4b69-b0ab-2c8bcdbf4d64_headers.csv
[...]
Peak memory usage: 0.00 B', Stderr: 'WARNING: neo4j-import is deprecated and support for it will be removed in a future
version of Neo4j; please use neo4j-admin import instead.
Error in input data
Caused by:ERROR in input
data source: BufferedCharSeeker[source:/tmp/csv-008/census/NODE_census.customrender_200d6cf2-d4e0-4189-a1e1-637f5f660c09.csv, position:202, line:0]
in field: ftsCustomrender7fbf76f00e4ac9968f07102878a58504:byte:3
for header: [:ID(census.customrender), id:long, ftsCustomrender7fbf76f00e4ac9968f07102878a58504:byte, lastExportNote:string, easydbInsertUser:string, easydbInsertTime:string, easydbOwner:string, lastChangelogId:long, easydbUpdateUser:string, easydbUpdateTime:string, description:string, chunkSize:long, templateId:long, sqlQuery:string, tableId:long, renderType:string, name:string, :LABEL]
raw field value: '1':16 'andrea':15 'anpassungen':7 'elemente':12 'im':8 'inscriptions':4 'kopie':1 'leichten':6 'mit':5 'monument':3 'template':9 'test':14 'von':2 'xml':11 'xml-elemente':10 'zugefuegt':13
original error: Not an integer: "'1':16 'andrea':15 'anpassungen':7 'elemente':12 'im':8 'inscriptions':4 'kopie':1 'leichten':6 'mit':5 'monument':3 'template':9 'test':14 'von':2 'xml':11 'xml-elemente':10 'zugefuegt':13"
WARNING Import failed. The store files in /home/kuczera/.config/Neo4j Desktop/Application/neo4jDatabases/database-58fe90a8-3319-44ce-a3d9-ce21766b464c/installation-3.5.9/data/databases/graph.db are left as they are, although they are likely in an unusable state. Starting a database on these store files will likely fail or observe inconsistent records so start at your own risk or delete the store manually', DurationMillis: 6821 }]). Rerun with --debug flag for detailed diagnostic information.
Error can be reproduced on Mac:
- Creating node with label
CName-Viaf
- Creating node with label CDocumentInscription
- Closing driver instance 1603198149
- Closing connection pool towards localhost:7687
- Command failed due to error (IndexOutOfBoundsException: Index: 14, Size: 14). Rerun with --debug flag for detailed diagnostic information.
Everything runs smoothly until import (mapping etc.)
Any Ideas welcome ;-)