ETL - Load Failing using oetl

[rmanzar]

I am getting this error while using oetl on my windows machine
using this versionorientdb-community-2.2.8

oetl posts.json
oetl postscsv.json
oetl commentscsv.json
oetl comment.json

Files are attached as a zip and I have placed them in the bin folder.
Manyfiles.zip

OrientDB etl v.2.2.8 (build 2.2.x@r39259e190e16045fe1425b1c0485f8562fca055b; 2016-08-23 14:38:49+0000) www.orientdb.com
Exception in thread "main" com.orientechnologies.orient.core.exception.OConfigurationException: Error on creating ETL processor
DB name="soft"
at com.orientechnologies.orient.etl.OETLProcessor.parse(OETLProcessor.java:225)
at com.orientechnologies.orient.etl.OETLProcessor.parse(OETLProcessor.java:176)
at com.orientechnologies.orient.etl.OETLProcessor.parseConfigAndParameters(OETLProcessor.java:144)
at com.orientechnologies.orient.etl.OETLProcessor.main(OETLProcessor.java:108)
Caused by: com.orientechnologies.orient.core.exception.OStorageException: Cannot open local storage '/usr/local/orientdb/databases/soft' wit
h mode=rw
DB name="soft"
at com.orientechnologies.orient.core.storage.impl.local.OAbstractPaginatedStorage.open(OAbstractPaginatedStorage.java:339)
at com.orientechnologies.orient.core.db.document.ODatabaseDocumentTx.open(ODatabaseDocumentTx.java:257)
at com.orientechnologies.orient.core.db.OPartitionedDatabasePool$DatabaseDocumentTxPooled.internalOpen(OPartitionedDatabasePool.java
:443)
at com.orientechnologies.orient.core.db.OPartitionedDatabasePool.openDatabase(OPartitionedDatabasePool.java:306)
at com.orientechnologies.orient.core.db.OPartitionedDatabasePool.acquire(OPartitionedDatabasePool.java:261)
at com.tinkerpop.blueprints.impls.orient.OrientBaseGraph.(OrientBaseGraph.java:143)
at com.tinkerpop.blueprints.impls.orient.OrientGraphNoTx.(OrientGraphNoTx.java:62)
at com.tinkerpop.blueprints.impls.orient.OrientGraphFactory.getNoTx(OrientGraphFactory.java:138)
at com.orientechnologies.orient.etl.loader.OOrientDBLoader.configureGraphDB(OOrientDBLoader.java:415)
at com.orientechnologies.orient.etl.loader.OOrientDBLoader.configure(OOrientDBLoader.java:401)
at com.orientechnologies.orient.etl.OETLProcessor.configureComponent(OETLProcessor.java:449)
at com.orientechnologies.orient.etl.OETLProcessor.configureLoader(OETLProcessor.java:262)
at com.orientechnologies.orient.etl.OETLProcessor.parse(OETLProcessor.java:209)
... 3 more
Caused by: com.orientechnologies.orient.core.exception.OStorageException: Can not open storage it is acquired by other process
DB name="soft"
at com.orientechnologies.orient.core.storage.impl.local.paginated.OPaginatedStorageDirtyFlag.lockFile(OPaginatedStorageDirtyFlag.jav
a:103)

    at com.orientechnologies.orient.core.storage.impl.local.paginated.OPaginatedStorageDirtyFlag.open(OPaginatedStorageDirtyFlag.java:13

8.  at com.orientechnologies.orient.core.storage.impl.local.paginated.OLocalPaginatedStorage.preOpenSteps(OLocalPaginatedStorage.java:33
   

9.  at com.orientechnologies.orient.core.storage.impl.local.OAbstractPaginatedStorage.open(OAbstractPaginatedStorage.java:291)
   

[robfrank]

Inside the jsons you are pointing to a remote database, but in the postscsv.json you are poiting to "dbURL": "plocal:/usr/local/orientdb/databases/soft" . If the OrientDB server is stil running, as I think, then you got :

Caused by: com.orientechnologies.orient.core.exception.OStorageException: Can not open storage it is acquired by other process
DB name="soft"

ONLY a process can open a database: the server OR the oetl process in plocal.

[robfrank]

did you solve the problem? may I close?

[rmanzar]

Thanks Frank, Yes, I could solve the problem. I had to use serverUser and serverPassword.

[robfrank]

Issue moved to orientechnologies/orientdb #6756 via ZenHub

[wolf4ood]

I'm closing this since has been moved.