ETL error

[Armand Puccetti]

Hi,

I am new to OrientDB and exploring how its JSON importation module works in order to build a database of heterogenous documents.

For this, I installed version 3.0.21 and run the OrientDB server and Studio.

I attempted to run the example of importing a JSON file into demoDB , using the documentation instructions:

- I adapted the configuration file as below:

{

  "config": {

    "log": "debug"

  },

  "source" : {

    "file": { "path": "/Users/armand/GIT/markdown-report/examples/orient/database.json" }

  },

  "extractor" : {

    "json": {}

  },

  "transformers" : [

    { "merge": { "joinFieldName": "id", "lookup": "Account.id" } },

    { "vertex": { "class": "Account"} },

    { "edge": {

      "class": "Friend",

      "joinFieldName": "friends",

      "lookup": "Account.id",

      "unresolvedLinkAction": "CREATE"

    } }

  ],

  "loader" : {

    "orientdb": {

      "dbURL": "remote:localhost/demodb",

      "dbUser": "admin",

      "dbPassword": "admin",

      "dbAutoDropIfExists": true,

      "dbAutoCreate": true,

      "standardElementConstraints": false,

      "tx": false,

      "wal": false,

      "batchCommit": 1000,

      "dbType": "graph",

      "classes": [{"name": "Account", "extends":"V"}, {"name": "Friend", "extends":"E"}, {"name": 'Enemy', "extends":"E"}],

      "indexes": [{"class":"Account", "fields":["id:integer"], "type":"UNIQUE_HASH_INDEX" }]

    }

  }

}

and with a JSON source file exactly the same as in the documentation, namely:

[

 {

  "name": "Joe",

  "id": 1,

  "friends": [2,4,5],

  "enemies": [6]

 },

 {

  "name": "Suzie",

  "id": 2,

  "friends": [1,4,6],

  "enemies": [5,2]

 }

]

- then, I ran ETL in a bash console on macOSX:

$ ~/Downloads/orientdb-3.0.21/bin/oetl.sh import.json

OrientDB etl v.3.0.21 - Veloce (build 1d8b0c01ca8fe12a516bba355681e3ec8b218d1d, branch 3.0.x) https://www.orientdb.com

2019-07-15 17:02:27:193 INFO  Default limit of open files (512) will be used. [ONative]Exception in thread "main" com.orientechnologies.orient.core.exception.OConfigurationException: Error on loading config file: import.json

at com.orientechnologies.orient.etl.OETLProcessorConfigurator.parseConfigAndParameters(OETLProcessorConfigurator.java:79)

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

Caused by: java.io.FileNotFoundException: import.json (No such file or directory)

at java.io.FileInputStream.open0(Native Method)

at java.io.FileInputStream.open(FileInputStream.java:195)

at java.io.FileInputStream.<init>(FileInputStream.java:138)

at com.orientechnologies.common.io.OIOUtils.readFileAsString(OIOUtils.java:145)

at com.orientechnologies.orient.etl.OETLProcessorConfigurator.parseConfigAndParameters(OETLProcessorConfigurator.java:69)

... 1 more

Any idea of what went wrong? Perhaps the loader dbURL field?

Thanks for any help.

Armand

[Aaron Laws]

I'm not sure as I haven't done that before, but based on the error, perhaps try an absolute path? If you want to keep using a relative path, you'll need to figure out whence that relative path is resolved (does the script change directories? etc.).

In Christ,
Aaron Laws

--

---
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.
To view this discussion on the web visit https://groups.google.com/d/msgid/orient-database/064eb186-1322-4df8-b342-6d06842bbad3%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.