cancel
Showing results for 
Search instead for 
Did you mean: 

Join the community at Nodes 2022, our free virtual event on November 16 - 17.

Getting unexpected error: Duplicate header entries found

kalyan_b_aninda
Graph Buddy

hello
I am using neo4j 3.5.14 version. I need to import csvs through bulk import operation. after configuring the nodes and relationship files I executes commands in script file'

but getting this error

unexpected error: Duplicate header entries found first RAJSHAHI:string, other (and conflicting) RAJSHAHI:string

neo4j-admin import \

--id-type=string \

--ignore-missing-nodes=true \

--ignore-extra-columns=true \

--max-memory=200g \

--ignore-duplicate-nodes=true \

--nodes=AGENT= **"AGENT_HEADER.csv,nodes_AGENT.csv"** \

--nodes=CUSTOMER= **"CUSTOMER_HEADER.csv,nodes_CUSTOMER.csv"** \

--nodes=MERCHANT= **"MERCHANT_HEADER.csv,nodes_MERCHANT.csv"** \

--nodes=DM= **"DM_HEADER.csv,nodes_DM.csv"** \

--nodes=BILLER= **"BILLER_HEADER.csv,nodes_BILLER.csv"** \

--nodes=BANK= **"BANK_HEADER.csv,nodes_BANK.csv"** \

--nodes=NONLABEL= **"NONLABEL_HEADER.csv,nodes_NON.csv"** \

--nodes=ATM= **"ATM_HEADER.csv,nodes_ATM.csv"** \

--nodes=CARD= **"CARD_HEADER.csv,nodes_CARD.csv"** \

--nodes=REMITTER= **"REMITTER_HEADER.csv,nodes_REMITTER.csv"** \

--relationships=SENDMONEY= **"relationship_SENDMONEY-HEADER.csv,relationship_SENDMONEY.csv"** \

--relationships=CASHOUT= **"relationship_CASHOUT-HEADER.csv,relationship_CASHOUT.csv"** \

--relationships=CASHIN= **"relationship_CASHIN-HEADER.csv,relationship_CASHIN.csv"** \

--relationships=PAYMENT= **"relationship_PAYMENT-HEADER,relationship_PAYMENT.csv"** \

--relationships=DISBURSE= **"relationship_DISBURSE-MERCHANT-HEADER.csv,relationship_DISBURSE-MERCHANT.csv"** \

--relationships=DISBURSE= **"relationship_DISBURSE-DM-HEADER.csv,relationship_DISBURSE-DM.csv"** \

--relationships=PAYBILL= **"relationship_PAYBILL-HEADER.csv,relationship_PAYBILL.csv"** \

--relationships=IBANKING= **"relationship_IBANKING-HEADER.csv,relationship_IBANKING.csv"** \

--relationships=REMIT= **"relationship_REMIT-HEADER.csv,relationship_REMIT.csv"** \

--relationships=C2W= **"relationship_C2W-HEADER.csv,relationship_C2W.csv"** \

--relationships=ATMCO= **"relationship_ATMCO-HEADER.csv,relationship_ATMCO.csv"** \

--relationships=AIRTIME= **"relationship_AIRTIME-AGENT-HEADER.csv,relationship_AIRTIME-AGENT.csv"** \

--relationships=AIRTIME= **"relationship_AIRTIME-CUSTOMER-HEADER.csv,relationship_AIRTIME-CUSTOMER.csv"** \

--relationships=AIRTIME= **"relationship_AIRTIME-MERCHANT-HEADER.csv,relationship_AIRTIME-MERCHANT.csv"** \

--relationships=AIRTIME= **"relationship_AIRTIME-DM-HEADER.csv,relationship_AIRTIME-DM.csv"** \

--relationships=AIRTIME= **"relationship_AIRTIME-NONLABEL-HEADER.csv,relationship_AIRTIME-NON.csv"** \

--relationships=AIRTIME= **"relationship_AIRTIME-BILLER-HEADER.csv,relationship_AIRTIME-BILLER.csv"** \

--relationships=AIRTIME= **"relationship_AIRTIME-ATM-HEADER.csv,relationship_AIRTIME-ATM.csv"** \

--relationships=AIRTIME= **"relationship_AIRTIME-BANK-HEADER.csv,relationship_AIRTIME-BANK.csv"** \

--relationships=AIRTIME= **"relationship_AIRTIME-CARD-HEADER.csv,relationship_AIRTIME-CARD.csv"** \

--relationships=AIRTIME= **"relationship_AIRTIME-REMITTER-HEADER.csv,relationship_AIRTIME-REMITTER.csv"** \

--high-io=true

this is my command script file . how could I solve this issue

2 REPLIES 2

clem
Graph Steward

I would grep RAJSHAHI *.csv for RAJSHAHI in your csv files to see which file contains the offending string.

My wild guess is that RAJSHAHI is actually data and not the name of a column, which would infer that one of your .csv files is missing a header row.

But hard to say for sure...

crutting
Node

Did you find a solution to this? I am having a very similar issue. my error gives a bit more detail.
org.neo4j.internal.batchimport.input.DuplicateHeaderException: Duplicate header entries found in /var/lib/neo4j/import/node_mara_conc.csv, first 0.0:string, other (and conflicting) 0.0:string

I'm not sure what this means or what needs to be corrected. Anyone have any explanation or suggestions for me to look into?