while doing etl operation getting error: Error in Pipeline execution: java.lang.IllegalArgumentExc

[lovaraju...@gmail.com]

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

[Jihoon Park]

Are you sure your "USER_PROJECT_ROLE" table has a non-NULL column named "user_id"?

[Lova Raju Allumalla]

Hi Jihoon,

I had that doubt and i replaced the select * from USER_PROJECT_ROLE with select * from USER_PROJECT_ROLE where user_id is not null

and tried still the same error persists.

Thanks and Regards,

Lova Raju Allumalla

 

--

---
You received this message because you are subscribed to a topic in the Google Groups "OrientDB" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/orient-database/4iroF5F_Rv4/unsubscribe.
To unsubscribe from this group and all its topics, send an email to orient-databa...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.