Not able to load data using OrientDB ETL

[shraddha bhadauria]

Hi,

I have been trying to load data using OETL with json files. 

I am getting following error.

2016-05-25 15:00:40:753 WARNI The Client driver version is different than Server version: client=32, server=30. You could not use the full features of the ne

wer version. Assure to have the same versions on both [OChannelBinaryAsynchClient]Error in Pipeline execution: com.orientechnologies.orient.core.exception.OD

atabaseException: Error on saving record in cluster #76

ETL process halted: com.orientechnologies.orient.etl.OETLProcessHaltedException: Halt

Exception in thread "main" com.orientechnologies.orient.etl.OETLProcessHaltedException: Halt

        at com.orientechnologies.orient.etl.OETLPipeline.execute(OETLPipeline.java:144)

        at com.orientechnologies.orient.etl.OETLProcessor.executeSequentially(OETLProcessor.java:472)

        at com.orientechnologies.orient.etl.OETLProcessor.execute(OETLProcessor.java:269)

        at com.orientechnologies.orient.etl.OETLProcessor.main(OETLProcessor.java:116)

Caused by: com.orientechnologies.orient.core.exception.ODatabaseException: Error on saving record in cluster #76

        at com.orientechnologies.orient.core.db.document.ODatabaseDocumentTx.executeSaveRecord(ODatabaseDocumentTx.java:1842)

        at com.orientechnologies.orient.core.tx.OTransactionNoTx.saveRecord(OTransactionNoTx.java:150)

        at com.orientechnologies.orient.core.db.document.ODatabaseDocumentTx.save(ODatabaseDocumentTx.java:2372)

        at com.orientechnologies.orient.core.db.document.ODatabaseDocumentTx.save(ODatabaseDocumentTx.java:2206)

        at com.orientechnologies.orient.core.db.document.ODatabaseDocumentTx.save(ODatabaseDocumentTx.java:119)

        at com.orientechnologies.orient.server.network.protocol.binary.OBinaryNetworkProtocolAbstract.createRecord(OBinaryNetworkProtocolAbstract.java:364)

        at com.orientechnologies.orient.server.network.protocol.binary.ONetworkProtocolBinary.createRecord(ONetworkProtocolBinary.java:1385)

        at com.orientechnologies.orient.server.network.protocol.binary.ONetworkProtocolBinary.executeRequest(ONetworkProtocolBinary.java:355)

        at com.orientechnologies.orient.server.network.protocol.binary.OBinaryNetworkProtocolAbstract.execute(OBinaryNetworkProtocolAbstract.java:222)

        at com.orientechnologies.common.thread.OSoftThread.run(OSoftThread.java:71)

Caused by: java.lang.IllegalArgumentException: Cluster 76 is null

        at com.orientechnologies.orient.core.storage.impl.local.OAbstractPaginatedStorage.getClusterById(OAbstractPaginatedStorage.java:1053)

        at com.orientechnologies.orient.core.storage.impl.local.OAbstractPaginatedStorage.createRecord(OAbstractPaginatedStorage.java:631)

        at com.orientechnologies.orient.core.db.document.ODatabaseDocumentTx.executeSaveRecord(ODatabaseDocumentTx.java:1800)

        ... 9 more

D:\orientdb-community-2.1.10\orientdb-community-2.1.10\bin>

The conf file is as below.

{"config":{"parallel":false},"source":{"file":{"path":"D:/OETL/ExternalMessageConfigMapping.csv"}},"extractor":{"row":{}},"transformers":[{"csv":{}},{"vertex":{"class":"ExternalMessageConfigMapping","skipDuplicates":true}}],"loader":{"orientdb":{"dbURL":"remote:localhost/srims_test","dbType":"graph","tx":false,"batchCommit":1000,"wal":false}}}

Can someone please help me out here ?

Thank You.

[Roberto Franchini]

On Wed, May 25, 2016 at 11:46 AM, shraddha bhadauria <shraddha....@gmail.com> wrote:

Hi,

I have been trying to load data using OETL with json files. 

I am getting following error.

[cut]

D:\orientdb-community-2.1.10\orientdb-community-2.1.10\bin>

I think you are running a remote server with a different version, a 2.2.0?

 

--

Best regards,
 
Roberto Franchini

OrientDB LTD  -  http://orientdb.com

[alessand...@gmail.com]

Hi,

I have tried with your conf file with same version of client(2.1.10) and server and it works.

Kind regards,

Alessandro