Were you able to resolve this issue? On Thursday, 30 April 2015 22:24:37 UTC+5:30, Wes Arnquist wrote: > > Hello! I am trying to import DBPedia Person, per the documentation > <http://orientdb.com/docs/last/orientdb-etl.wiki/Import-from-DBPedia.html>, > but am running into errors. Please see the below and let me know if you > have any ideas. > > Thank you! > > *OrientDB release? *2.0.3 > (Java is 8u40) > > *What steps will reproduce the problem?* > 1. Copied JSON from this page: > http://orientdb.com/docs/last/orientdb-etl.wiki/Import-from-DBPedia.html > , and pasted into a new ASCII plain text document > 2. made changes to match my case (whole file here with changes in > *bold/blue*): > { > "config": { > "log": "debug", > "fileDirectory": "*F:/IS_DSA/DBpedia/2014/*", > "fileName": "Person.csv.gz" > }, > "begin": [ > { "let": { "name": "$filePath", "value": "$fileDirectory.append( > $fileName )"} }, > { "let": { "name": "$className", "value": "$fileName.substring( 0, > $fileName.indexOf('.') )"} } > ], > "source" : { > "file": { "path": "$filePath", "lock" : true } > }, > "extractor" : { > "row": {} > }, > "transformers" : [ > { "csv": { "separator": ",", "nullValue": "NULL", "skipFrom": 1, > "skipTo": 3 } }, > { "merge": { "joinFieldName":"URI", "lookup":"V.URI" } }, > { "vertex": { "class": "$className"} } > ], > "loader" : { > "orientdb": { > "dbURL": "*remote:localhost/database/dbpedia*", > "dbUser": "*tester*", > "dbPassword": "*tester*", > "dbAutoCreate": true, > "tx": false, > "batchCommit": 1000, > "dbType": "graph", > "indexes": [{"class":"V", "fields":["URI:string"], "type":"UNIQUE" }] > } > } > } > 3. saved as ASCII encoded JSON file "import_dbpedia.json" > 4. (in Windows) started Server.bat > 5. opened cmd, cd to bin directory, then ran "oetl.bat > ../import_dbpedia.json" > 6. received this error message: (what I think is strange is the part in > *bold/red*. The JSON contains $fileName, not $fileNam. I tried changing > this to other values of different lengths - every time it cuts off the last > character of the variable. > F:\IS_DSA\Graph DBs\orientdb-community-2.0.3\bin>oetl.bat > ..\import_dbpedia.json > OrientDB etl v.2.0.3 (build @BUILD@) www.orientechnologies.com > Exception in thread "main" > com.orientechnologies.orient.core.exception.OConfigurationException: Error > on creating ETL processor > at > com.orientechnologies.orient.etl.OETLProcessor.parse(OETLProcessor.java:278) > at > com.orientechnologies.orient.etl.OETLProcessor.parse(OETLProcessor.java:188) > at > com.orientechnologies.orient.etl.OETLProcessor.main(OETLProcessor.java:163) > Caused by: java.lang.NumberFormatException: For input string: "*$fileNam*" > at java.lang.NumberFormatException.forInputString(Unknown Source) > at java.lang.Integer.parseInt(Unknown Source) > at java.lang.Integer.parseInt(Unknown Source) > at > com.orientechnologies.orient.core.record.impl.ODocumentHelper.evaluateFunction(ODocumentHelper.java:742) > at > com.orientechnologies.orient.core.record.impl.ODocumentHelper.getFieldValue(ODocumentHelper.java:481) > at > com.orientechnologies.orient.core.command.OBasicCommandContext.getVariable(OBasicCommandContext.java:121) > at > com.orientechnologies.orient.core.command.OBasicCommandContext.getVariable(OBasicCommandContext.java:57) > at > com.orientechnologies.orient.etl.OAbstractETLComponent.resolve(OAbstractETLComponent.java:130) > at > com.orientechnologies.orient.etl.block.OLetBlock.executeBlock(OLetBlock.java:59) > at > com.orientechnologies.orient.etl.block.OAbstractBlock.execute(OAbstractBlock.java:31) > at > com.orientechnologies.orient.etl.OETLProcessor.parse(OETLProcessor.java:231) > ... 2 more > > *If you're using custom settings please provide them below (to dump all > the settings run the application using the JVM > argument -Denvironment.dumpCfgAtStartup=true):* > Not using custom settings. > > *What is the expected output? What do you see instead?* > I expected the ETL program to import the DB-Pedia Person data into my > "dbpedia" database. > Instead I received an error message mentioning a truncated variable name - > $fileNam instead of $fileName: > Exception in thread "main" > com.orientechnologies.orient.core.exception.OConfigurationException: Error > on creating ETL processor > ... > java.lang.NumberFormatException: For input string: "$fileNam" > > > Thank you! >
-- --- 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-database+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/orient-database/d38783e1-040d-46b1-9d6e-a740e29dc981%40googlegroups.com.
