cancel
Showing results for 
Search instead for 
Did you mean: 

Head's Up! These forums are read-only. All users and content have migrated. Please join us at community.neo4j.com.

Etl import of postgres db fails

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:

  1. 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.
  1. 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.
  1. 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 😉

0 REPLIES 0