Are you sure your "USER_PROJECT_ROLE" table has a non-NULL column named "user_id"?
On Thursday, September 24, 2015 at 8:51:01 PM UTC+9, [email protected] wrote: > > 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.
