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 On Sat, Sep 26, 2015 at 11:09 PM, Jihoon Park <[email protected]> wrote: > 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 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 > [email protected]. > For more options, visit https://groups.google.com/d/optout. > -- --- 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.
