--
---
You received this message because you are subscribed to the Google Groups "OrientDB" group.
To unsubscribe from this group and stop receiving emails from it, send an email to orient-databa...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
[2:vertex] DEBUG Transformer input: {cc:Geschäftsleitung,cc_no:1,responsible:0,next_cc:1}
Error in Pipeline execution: com.orientechnologies.orient.core.storage.ORecordDuplicatedException: Cannot index record CostCenter{cc:Geschäftsleitung,cc_no:1,responsible:0,next_cc:1}: found duplicated key '1' in index 'CostCenter.cc_no' previously assigned to the record #11:0 RID=#11:0
com.orientechnologies.orient.core.storage.ORecordDuplicatedException: Cannot index record CostCenter{cc:Geschäftsleitung,cc_no:1,responsible:0,next_cc:1}: found duplicated key '1' in index 'CostCenter.cc_no' previously assigned to the record #11:0 RID=#11:0
at com.orientechnologies.orient.core.index.OIndexTxAwareOneValue.checkEntry(OIndexTxAwareOneValue.java:221)
And, if anyone is interested, this is my config file (perhaps someone as proposals to improve it):
{
"config": {
"log": "debug"
},
"source": {
"file": {
"path": "/Users/d022051/NetBeansProjects/ETL/Personalstamm - Kostenstellenhierarchie.csv"
}
},
"extractor": {
"row": {}
},
"transformers": [
{
"csv": {
"skipFrom": 0,
"skipTo": 0,
"nullValue": "",
"separator": ";",
"columns": ["id:integer", "name", "firstname", "title", "birthday:string", "function", "country", "cc", "cc_no:integer", "responsible:integer", "next_cc:integer"]
}
}, {
"field": {
"fieldName": "id",
"operation": "remove"
}
},
{
"field": {
"fieldName": "name",
"operation": "remove"
}
},
{
"field": {
"fieldName": "firstname",
"operation": "remove"
}
},
{
"field": {
"fieldName": "title",
"operation": "remove"
}
},
{
"field": {
"fieldName": "birthday",
"operation": "remove"
}
},
{
"field": {
"fieldName": "function",
"operation": "remove"
}
},
{
"field": {
"fieldName": "country",
"operation": "remove"
}
},
{
"vertex": {
"class": "CostCenter"
}
}
],
"loader": {
"orientdb": {
"dbURL": "plocal:/Users/d022051/NetBeansProjects/ETL/db",
"dbType": "graph",
"dbAutoDropIfExists": false,
"dbAutoCreate": true,
"standardElementConstraints": false,
"classes": [
{
"name": "CostCenter",
"extends": "V"
}
],
"indexes": [
{
"class": "CostCenter",
"fields": ["cc_no:integer"],
"type": "UNIQUE"
}
]
}
}
}
at com.orientechnologies.orient.core.index.OIndexTxAwareOneValue.checkEntry(OIndexTxAwareOneValue.java:221)
Error in Pipeline execution: com.orientechnologies.orient.core.storage.ORecordDuplicatedException: Cannot index record CostCenter{cc:Geschäftsleitung,cc_no:1,responsible:0,next_cc:1}: found duplicated key '1' in index 'CostCenter.cc_no' previously assigned to the record #11:0 RID=#11:0
com.orientechnologies.orient.core.storage.ORecordDuplicatedException: Cannot index record CostCenter{cc:Geschäftsleitung,cc_no:1,responsible:0,next_cc:1}: found duplicated key '1' in index 'CostCenter.cc_no' previously assigned to the record #11:0 RID=#11:0
at com.orientechnologies.orient.core.index.OIndexTxAwareOneValue.checkEntry(OIndexTxAwareOneValue.java:221)
at com.orientechnologies.orient.core.index.OClassIndexManager.checkIndexedPropertiesOnCreation(OClassIndexManager.java:322)
at com.orientechnologies.orient.core.index.OClassIndexManager.checkIndexes(OClassIndexManager.java:581)
at com.orientechnologies.orient.core.index.OClassIndexManager.onRecordBeforeCreate(OClassIndexManager.java:423)
at com.orientechnologies.orient.core.hook.ODocumentHookAbstract.onTrigger(ODocumentHookAbstract.java:218)
at com.orientechnologies.orient.core.db.document.ODatabaseDocumentTx.callbackHooks(ODatabaseDocumentTx.java:966)
at com.orientechnologies.orient.core.db.document.ODatabaseDocumentTx.executeSaveRecord(ODatabaseDocumentTx.java:1686)
at com.orientechnologies.orient.core.tx.OTransactionNoTx.saveRecord(OTransactionNoTx.java:94)
at com.orientechnologies.orient.core.db.document.ODatabaseDocumentTx.save(ODatabaseDocumentTx.java:2274)
at com.orientechnologies.orient.core.db.document.ODatabaseDocumentTx.save(ODatabaseDocumentTx.java:117)
at com.orientechnologies.orient.core.record.impl.ODocument.save(ODocument.java:1704)
at com.orientechnologies.orient.core.record.impl.ODocument.save(ODocument.java:1695)
at com.tinkerpop.blueprints.impls.orient.OrientElement.save(OrientElement.java:304)
at com.tinkerpop.blueprints.impls.orient.OrientElement.save(OrientElement.java:284)
at com.tinkerpop.blueprints.impls.orient.OrientElement.setProperty(OrientElement.java:186)
at com.orientechnologies.orient.etl.transformer.OVertexTransformer.executeTransform(OVertexTransformer.java:77)
at com.orientechnologies.orient.etl.transformer.OAbstractTransformer.transform(OAbstractTransformer.java:37)
at com.orientechnologies.orient.etl.OETLPipeline.execute(OETLPipeline.java:108)
at com.orientechnologies.orient.etl.OETLProcessor.executeSequentially(OETLProcessor.java:483)
at com.orientechnologies.orient.etl.OETLProcessor.execute(OETLProcessor.java:291)
at com.orientechnologies.orient.etl.OETLProcessor.main(OETLProcessor.java:163)
ETL process halted: com.orientechnologies.orient.etl.OETLProcessHaltedException: com.orientechnologies.orient.core.storage.ORecordDuplicatedException: Cannot index record CostCenter{cc:Geschäftsleitung,cc_no:1,responsible:0,next_cc:1}: found duplicated key '1' in index 'CostCenter.cc_no' previously assigned to the record #11:0 RID=#11:0
I have to das that I didn't look into OrientDB forum quite a while, so I cannot say what the state is.
--
---
You received this message because you are subscribed to a topic in the Google Groups "OrientDB" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/orient-database/cANKYwMOMUA/unsubscribe.
To unsubscribe from this group and all its topics, send an email to orient-databa...@googlegroups.com.