Missing header of type START_ID


(Christianne Greer) #1

I keep getting this error trying to import nodes and edges.

org.neo4j.unsafe.impl.batchimport.input.MissingHeaderException: Missing header of type START_ID, among entries [] at org.neo4j.unsafe.impl.batchimport.input.csv.DataFactories$AbstractDefaultFileHeaderParser.validateHeader(DataFactories.java:259) at org.neo4j.unsafe.impl.batchimport.input.csv.DataFactories$AbstractDefaultFileHeaderParser.create(DataFactories.java:215) at org.neo4j.unsafe.impl.batchimport.input.csv.CsvInput.verifyHeaders(CsvInput.java:139) at org.neo4j.unsafe.impl.batchimport.input.csv.CsvInput.<init>(CsvInput.java:107) at org.neo4j.unsafe.impl.batchimport.input.csv.CsvInput.<init>(CsvInput.java:87) at org.neo4j.commandline.dbms.CsvImporter.doImport(CsvImporter.java:125) at org.neo4j.commandline.dbms.ImportCommand.execute(ImportCommand.java:249) at org.neo4j.commandline.admin.AdminTool.execute(AdminTool.java:127) at org.neo4j.commandline.admin.AdminTool.main(AdminTool.java:51) unexpected error: Missing header of type START_ID, among entries []

Here's some node and edge data:

ANUMBER :LABEL UUID :ID
203610177 ANUMBER 670ab259da179e3968d51bbe9c773ee7eee660e8f20e8782c3913f3d6f3dc790 ANM~203610177
67269055 ANUMBER 61b76e938d1564e086b852b0599100c5453ebf89d31a49841909325e626bb7f6 ANM~067269055
19681216 ANUMBER f13d8b8af9fc04209f56680e1aaa6c889cfd26ba4d5fb05beb648a8666ea0e63 ANM~019681216
463974659 ANUMBER f7b27227ae8e7081663c6a8b727c0106c36cab12e16eebbc20530d5ae5229320 ANM~463974659
C115_PAR_ID :LABEL UUID :ID
2150515221 PARID 3a0a541a16ad4d2d928ab1299cabfc33769e0132dc8d944b907a269e11c327ef PAR~2150515221
2618176069 PARID 9dd01ed4226c873d80715f6f66970dca9cb8c09674e18f38dfe84fbc599a9f53 PAR~2618176069
2950062460 PARID a12944eda423fa177785b5c2dbfa56cb0b7b0b9e010d650685921292d0f54769 PAR~2950062460
ANUMBER C115_PAR_ID :TYPE UUID :START_ID :END_ID
225139522 5668625082 ASSOCIATED 779b432742c3fe46e5421fd58c180860f9bbd3980e22374aa2248e79280a46f6 ANM~225139522 PAR~5668625082
126201010 7934398690 ASSOCIATED 230b46b14804086b52eb3a491c68f0c58cd7fe1d05c220628a412ed7688dbfab ANM~126201010 PAR~7934398690
203369400 9874942015 ASSOCIATED 30c6946466ee22f1502ddb007d09e9091cc6684718e33f3f87e2fd4398b3e672 ANM~203369400 PAR~9874942015
45592262 5411409431 ASSOCIATED e214f8f9116f7ecdd06cbfc0a3ea6dbd230cc901b24891a5c31139359d65f9d3 ANM~045592262 PAR~5411409431

I'm trying to understand what the error means. This isn't all of the files and there are lots more different types of nodes and edges, but this is the format in which I'm importing the files. Any ideas what would throw this exception? I have the --ignore-missing-nodes option enabled so it shouldn't fail the job when I have edges that don't map to nodes -- yet I'm getting a failed job as a result of the posted error.


(Michael Hunger) #2

Did you read the docs? https://neo4j.com/docs/operations-manual/current/tools/import/file-header-format/

Your nodes need at least one :ID field and your relationships need at least one :START_ID and :END_ID header field each.