Hi team,
this is regarding importing data from oracle into oreint db
I used http://orientdb.com/docs/last/Import-from-DBMS.html link as
guidance. I had used the json file which is not having edge associated gets
loaded completly but the json file having edge linkage with the former
throws an error.
please find the attached file that describes the steps followed
BEGIN ETL PROCESSOR
[1:vertex] DEBUG Transformer input:
{USER_PROJECT_ROLE_ID:SD0012695,PROJECT_ID:SD0011259,USER_ROLE_ID:null,
USER_ID:null,USER_GROUP_ID:SD00162,CREATED_USER_ID:SD00121,CREATED_DATETIME:oracle.sql.TIMEST
MPLTZ@2a7222,ACCESS_RIGHTS:null}
[1:vertex] DEBUG Transformer output: v(USER_PROJECT_ROLE)[#15:1]
[1:edge] DEBUG Transformer input: v(USER_PROJECT_ROLE)[#15:1]
[1:edge] DEBUG joinCurrentValue=null, lookupResult=null
Error in Pipeline execution: java.lang.IllegalArgumentException: Property
value can not be null
java.lang.IllegalArgumentException: Property value can not be null
at
com.tinkerpop.blueprints.util.ExceptionFactory.propertyValueCanNotBeNull(ExceptionFactory.java:60)
at
com.tinkerpop.blueprints.impls.orient.OrientElement.validateProperty(OrientElement.java:540)
at
com.tinkerpop.blueprints.impls.orient.OrientElement.setProperty(OrientElement.java:179)
at
com.orientechnologies.orient.etl.transformer.OEdgeTransformer.createEdge(OEdgeTransformer.java:129)
at
com.orientechnologies.orient.etl.transformer.OEdgeTransformer.executeTransform(OEdgeTransformer.java:113)
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:
java.lang.IllegalArgumentException: Property value can not be null
Thanking You,
With Best Regards,
Lova Raju Allumalla
--
---
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 [email protected].
For more options, visit https://groups.google.com/d/optout.
Hi Luigi,
In the process I have created 2 json files
users.json and project.json and the respective contents are
step1)
users.json:
{
"config": {
"log": "debug"
},
"extractor" : {
"jdbc": { "driver": "oracle.jdbc.driver.OracleDriver",
"url": "jdbc:oracle:thin:@//10.20.3.143:1599/VDSSDB",
"userName": "vdss",
"userPassword": "vdss",
"query": "select * from USERS" }
},
"transformers" : [
{ "vertex": { "class":"USERS"} }
],
"loader" : {
"orientdb": {
"dbURL":
"remote:localhost/GratefulDeadConcerts",
"dbUser": "admin",
"dbPassword": "admin",
"dbAutoCreate": false,
"tx": false,
"batchCommit": 10,
dbType:"graph"
}
}
}
step1-1)
project.json:
{
"config": {
"log": "debug"
},
"extractor" : {
"jdbc": { "driver": "oracle.jdbc.driver.OracleDriver",
"url": "jdbc:oracle:thin:@//10.20.3.143:1599/VDSSDB",
"userName": "vdss",
"userPassword": "vdss",
"query": "select * from USER_PROJECT_ROLE" }
},
"transformers" : [
{ "vertex": { "class": "USER_PROJECT_ROLE"} },
{ "edge": { "class": "associates", "direction" : "in",
"joinFieldName": "user_id",
"lookup":"USERS.user_id", "unresolvedLinkAction":"CREATE"} }
],
"loader" : {
"orientdb": {
"dbURL": "remote:localhost/GratefulDeadConcerts",
"dbUser": "admin",
"dbPassword": "admin",
"dbAutoCreate": true,
"tx": false,
"batchCommit": 10,
dbType:"graph"
}
}
}
step 2: at oreintDB console interface issued the below commands
create class users extends V
create class user_project_role extends V
create class associates extends E
step 3 : at command Line interface I executed
D:\orientdb-community-2.0.5\bin>oetl.bat users.json
result : I got all the data loaded from users table into oreint DB
step4:
D:\orientdb-community-2.0.5\bin>oetl.bat project.json
result : may be 1 or 2 records are loaded into oreintDB and I get the below
error.
OrientDB etl v.2.0.5 (build @BUILD@) www.orientechnologies.com
BEGIN ETL PROCESSOR
[1:vertex] DEBUG Transformer input:
{USER_PROJECT_ROLE_ID:SD0012695,PROJECT_ID:SD0011259,USER_ROLE_ID:null,
USER_ID:null,USER_GROUP_ID:SD00162,CREATED_USER_ID:SD00121,CREATED_DATETIME:oracle.sql.TIMEST
MPLTZ@2a7222,ACCESS_RIGHTS:null}
[1:vertex] DEBUG Transformer output: v(USER_PROJECT_ROLE)[#15:1]
[1:edge] DEBUG Transformer input: v(USER_PROJECT_ROLE)[#15:1]
[1:edge] DEBUG joinCurrentValue=null, lookupResult=null
Error in Pipeline execution: java.lang.IllegalArgumentException: Property value
can not be null
java.lang.IllegalArgumentException: Property value can not be null
at
com.tinkerpop.blueprints.util.ExceptionFactory.propertyValueCanNotBeNull(ExceptionFactory.java:60)
at
com.tinkerpop.blueprints.impls.orient.OrientElement.validateProperty(OrientElement.java:540)
at
com.tinkerpop.blueprints.impls.orient.OrientElement.setProperty(OrientElement.java:179)
at
com.orientechnologies.orient.etl.transformer.OEdgeTransformer.createEdge(OEdgeTransformer.java:129)
at
com.orientechnologies.orient.etl.transformer.OEdgeTransformer.executeTransform(OEdgeTransformer.java:113)
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:
java.lang.IllegalArgumentException: Property value can not be null
